Longevity statistics - please make them!
- Annie_in_exile
- Euro-Master in Training
- Posts: 986
- Joined: Wed Mar 12, 2003 2:51 pm
- Location: Brussels
- Contact:
Longevity statistics - please make them!
Guess what. I would have a new statistics request for the people who have access to the database (if anyone does these days). I would be extremely curious to know how many old users are still active. Would it be possible to make a simple table about how many user registrations there have been monthly since January 2002, and how many of them are still entering notes. Pleeeease?
Re: Longevity statistics - please make them!
[quote="Annie_in_exile"]how many old users are still active.
Annie are we talking aged (as in nearly dead) or length of time searching for euros? It makes a big difference to me being in the first catagory
Annie are we talking aged (as in nearly dead) or length of time searching for euros? It makes a big difference to me being in the first catagory
- Annie_in_exile
- Euro-Master in Training
- Posts: 986
- Joined: Wed Mar 12, 2003 2:51 pm
- Location: Brussels
- Contact:
Re: Longevity statistics - please make them!
Oh dear, am I being labelled as an agist? That wasn't the purpose. I really meant to find out what's the drop-out rate, how few or how many keep on tracking for 1,5-2 years or so. The table I'm after here could be as simple asNiloc wrote:Annie are we talking aged (as in nearly dead) or length of time searching for euros? It makes a big difference to me being in the first catagory
Jan-02 120 new users, 5 still active
Feb-02 230 - 12
Mar-02 270 - 9 etc.
(And Avij is probably silently cursing somewhere... does that Annie woman ever stop demanding new things.)
Re: Longevity statistics - please make them!
Annie :-Of course not, I'm too much of a gentleman to suggest such a thing, just clarifying the basis of your poll, no intent meantOh dear, am I being labelled as an agist?
- avij
- Forum Moderator
- Posts: 6122
- Joined: Mon May 27, 2002 10:45 pm
- Location: Helsinki Finland
- Contact:
Re: Longevity statistics - please make them!
Ha, is that the best challenge you can throw at me? I could do that with my hands tied behind my back while entering the commands with my nose. Well, that's assuming that I had spent a few minutes preparing the query in advance and all I had to do with my nose was to press the Enter key.Annie_in_exile wrote:(And Avij is probably silently cursing somewhere... does that Annie woman ever stop demanding new things.)
Well, that depends on your definition of "active". 63% of users are "active" if the definition is "entered a note during the last 12 months".Annie_in_exile wrote:I would be extremely curious to know how many old users are still active.
Here's a table showing how many new users registered each month, how many of them entered notes during the past week and past month, and the respective percentages from the total user count.
Code: Select all
+---------+----------+----------+--------+-----------+--------+
| month | newusers | lastweek | lw_pct | lastmonth | lm_pct |
+---------+----------+----------+--------+-----------+--------+
| 2002-01 | 331 | 25 | 7.55 | 38 | 11.48 |
| 2002-02 | 727 | 21 | 2.89 | 35 | 4.81 |
| 2002-03 | 917 | 31 | 3.38 | 46 | 5.02 |
| 2002-04 | 1560 | 75 | 4.81 | 102 | 6.54 |
| 2002-05 | 827 | 46 | 5.56 | 60 | 7.26 |
| 2002-06 | 640 | 35 | 5.47 | 53 | 8.28 |
| 2002-07 | 555 | 12 | 2.16 | 23 | 4.14 |
| 2002-08 | 499 | 18 | 3.61 | 37 | 7.41 |
| 2002-09 | 735 | 31 | 4.22 | 52 | 7.07 |
| 2002-10 | 747 | 22 | 2.95 | 43 | 5.76 |
| 2002-11 | 396 | 21 | 5.30 | 31 | 7.83 |
| 2002-12 | 1211 | 60 | 4.95 | 102 | 8.42 |
| 2003-01 | 883 | 62 | 7.02 | 78 | 8.83 |
| 2003-02 | 299 | 11 | 3.68 | 19 | 6.35 |
| 2003-03 | 403 | 23 | 5.71 | 40 | 9.93 |
| 2003-04 | 376 | 15 | 3.99 | 29 | 7.71 |
| 2003-05 | 369 | 26 | 7.05 | 43 | 11.65 |
| 2003-06 | 279 | 15 | 5.38 | 27 | 9.68 |
| 2003-07 | 760 | 50 | 6.58 | 85 | 11.18 |
| 2003-08 | 2678 | 185 | 6.91 | 335 | 12.51 |
| 2003-09 | 1471 | 146 | 9.93 | 238 | 16.18 |
| 2003-10 | 1111 | 130 | 11.70 | 209 | 18.81 |
| 2003-11 | 898 | 137 | 15.26 | 245 | 27.28 |
| 2003-12 | 812 | 178 | 21.92 | 687 | 84.61 |
| 2004-01 | 228 | 228 | 100.00 | 228 | 100.00 |
+---------+----------+----------+--------+-----------+--------+
Money makes the world go round. We track how the money goes round the world.
- nodisch18
- Euro-Master
- Posts: 1497
- Joined: Sat Jun 29, 2002 8:25 pm
- Location: Sint-Oedenrode
- Contact:
which means that only 8.1 % has been entering notes this last week! (in fact it is even lower because all the users that entered the site this week are also within that 8.1%...)
and only 14,6 entered notes during the last month... (in fact it is even lower because all the users that entered the site this month are also within that 14.6%...)
and only 14,6 entered notes during the last month... (in fact it is even lower because all the users that entered the site this month are also within that 14.6%...)
It may be worth noting, in this context, that, as of May 20, 2003,
0.1 % of the users (11 of 11298) have entered 19.1% of the notes (158120 of 828192) and
1% of the users (113 of 11298) have entered 49.4 % of the notes (409072 of 828192), if I added correctly.
And out of this top 1%, every fourth user (28 of 113) were not seen in the last 30 days.
I wonder how the figures changed since then but I have no time to do the necessary computations. Annie...?
0.1 % of the users (11 of 11298) have entered 19.1% of the notes (158120 of 828192) and
1% of the users (113 of 11298) have entered 49.4 % of the notes (409072 of 828192), if I added correctly.
And out of this top 1%, every fourth user (28 of 113) were not seen in the last 30 days.
I wonder how the figures changed since then but I have no time to do the necessary computations. Annie...?
- haemoglobin
- Euro-Master
- Posts: 1414
- Joined: Sat Apr 12, 2003 11:26 pm
- Location: Oldenburg, Germany
- Contact:
Yes, but we decided to keep them, because íf these people visit this sitehaemoglobin wrote:there are a lot of users who have never entered a note (look at the people from "andorra", for example). has there ever been a discussion about deleting these users?
again after having forgotten it they might start entering notes again. And we
have more than enough room in the database.
Of all the words of mice and men, the saddest are 'It might have been.' - Kurt Vonnegut