Longevity statistics - please make them!

Tell us who you are, where you from, etc...

Moderators: Phaseolus, Fons

User avatar
Annie_in_exile
Euro-Master in Training
Euro-Master in Training
Posts: 986
Joined: Wed Mar 12, 2003 2:51 pm
Location: Brussels
Contact:

Longevity statistics - please make them!

Post by Annie_in_exile »

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? :) :wink:
User avatar
nodisch18
Euro-Master
Euro-Master
Posts: 1497
Joined: Sat Jun 29, 2002 8:25 pm
Location: Sint-Oedenrode
Contact:

Post by nodisch18 »

I hope they can!

I'm also really curious!
Niloc
Euro-Newbie
Euro-Newbie
Posts: 28
Joined: Sat Aug 30, 2003 8:55 pm
Location: Loire Atlantique (44)

Re: Longevity statistics - please make them!

Post by Niloc »

[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 :cry:
User avatar
Annie_in_exile
Euro-Master in Training
Euro-Master in Training
Posts: 986
Joined: Wed Mar 12, 2003 2:51 pm
Location: Brussels
Contact:

Re: Longevity statistics - please make them!

Post by Annie_in_exile »

Niloc 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 :cry:
Oh dear, am I being labelled as an agist? 8O 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 as

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.) :lol:
Niloc
Euro-Newbie
Euro-Newbie
Posts: 28
Joined: Sat Aug 30, 2003 8:55 pm
Location: Loire Atlantique (44)

Re: Longevity statistics - please make them!

Post by Niloc »

Oh dear, am I being labelled as an agist?
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 meant
User avatar
avij
Forum Moderator
Forum Moderator
Posts: 6122
Joined: Mon May 27, 2002 10:45 pm
Location: Helsinki Finland
Contact:

Re: Longevity statistics - please make them!

Post by avij »

Annie_in_exile wrote:(And Avij is probably silently cursing somewhere... does that Annie woman ever stop demanding new things.) :lol:
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:I would be extremely curious to know how many old users are still active.
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".

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.
User avatar
nodisch18
Euro-Master
Euro-Master
Posts: 1497
Joined: Sat Jun 29, 2002 8:25 pm
Location: Sint-Oedenrode
Contact:

Post by nodisch18 »

which means that only 8.1 % has been entering notes this last week! :cry: (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%...)
User avatar
Gauss
Forum Moderator
Forum Moderator
Posts: 1685
Joined: Tue Feb 25, 2003 11:35 pm

Post by Gauss »

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...?
User avatar
haemoglobin
Euro-Master
Euro-Master
Posts: 1414
Joined: Sat Apr 12, 2003 11:26 pm
Location: Oldenburg, Germany
Contact:

Post by haemoglobin »

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?
User avatar
avij
Forum Moderator
Forum Moderator
Posts: 6122
Joined: Mon May 27, 2002 10:45 pm
Location: Helsinki Finland
Contact:

Post by avij »

haemoglobin wrote:has there ever been a discussion about deleting these users?
No, why? We have plenty of space in the database even for inactive users.
Money makes the world go round. We track how the money goes round the world.
User avatar
Elmo
Euro-Master
Euro-Master
Posts: 4184
Joined: Mon Oct 14, 2002 4:16 pm
Location: Leiden (Netherlands)

Post by Elmo »

haemoglobin 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?
Yes, but we decided to keep them, because íf these people visit this site
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
joergb30
Euro-Master
Euro-Master
Posts: 3923
Joined: Thu Oct 30, 2003 1:59 am
Location: Kassel, Germany

Post by joergb30 »

.
Last edited by joergb30 on Thu Jan 01, 2009 8:30 pm, edited 1 time in total.
User avatar
Blueman
Euro-Master
Euro-Master
Posts: 2229
Joined: Mon Dec 23, 2002 1:44 am
Location: Helmond, The Netherlands
Contact:

Post by Blueman »

2002-01 | 331 | 25 | 7.55 | 38 | 11.48

38 users who become a member in the first month of EBT are still active :)
that's cool :)
Blue is the color that makes people wild!
TC
Euro-Regular in Training
Euro-Regular in Training
Posts: 141
Joined: Wed Feb 13, 2002 4:44 pm
Location: Belgique, Wavre

Post by TC »

hééé

i'm a very old member... :o

but i was in hibernation a long time :?

Date d'inscription: 2002-02-07... i was so young .... :wink:
nothing to say... just make hit ;o)
User avatar
Blueman
Euro-Master
Euro-Master
Posts: 2229
Joined: Mon Dec 23, 2002 1:44 am
Location: Helmond, The Netherlands
Contact:

Post by Blueman »

Joined: 2002-04-17

2002-04 | 1560 | 75 | 4.81 | 102 | 6.54

i am joined in the big invasion :)
Blue is the color that makes people wild!
Post Reply

Return to “EuroBillTracker Users”