Longevity statistics - please make them!

[Elmo]

Joined: 2002-05-14

2002-05 | 827 | 46 | 5.56 | 60 | 7.26

That means I joined in an average month.

[Annie_in_exile]

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.

Thanks Avij! I know this would be just a piece of cake for you. And yes, I can think of so many other things/statistics I'd like to see here on the forum but let's keep it simple for now. But I still have one question: If I interpret this table correctly, it shows that all of the recent users have registered notes. Really? I haven't had time to check, but aren't there always some people who just drop in to check the site and never register any notes? (And since I've written this text here, I probably realise my own mistake soon. Oh well. Doesn't matter. )

[BogPoet]

I haven't had time to check, but aren't there always some people who just drop in to check the site and never register any notes?

I guess most people always insert a note or two, just to see how the site works. There must be some 0-bill users (Andorra has been mentioned), of course, but I believe them to be extremely rare (this is just a guess, BTW, I haven't done any db checking).

[Annie_in_exile]

I wonder how the figures changed since then but I have no time to do the necessary computations. Annie...?

I just might swallow the bait, but I'll wait until we have 20000 users. Much more comfortable to do the maths. "I-I-I-I'm wicked and I'm lazy..."

[Blueman]

I guess most people always insert a note or two, just to see how the site works. There must be some 0-bill users (Andorra has been mentioned), of course, but I believe them to be extremely rare (this is just a guess, BTW, I haven't done any db checking).

I got 23 refs and of them there are 3 users who didn't entered a note..
2 of them i know..
that was in the time of the database problems and registered themself 2 times...

[Mr Euro]

Hey,
These are really interesting stats. With these stats we can see how effective an maillist can be...

Next time a day before we send out the newsletter we have to take these stats again, and than 2 weeks after the newsletter release... If you see a big difference in activity rate (pe last month %) than we could send out a news letter more frequently...

I think this is a great stat. Why don't we make an extra line below the users. "active users"

I added those monthlies up and I got 2885 active users. (December and January are included)

[avij]

If I interpret this table correctly, it shows that all of the recent users have registered notes. Really?

Um, good point. Actually I used the "lastactive" field in the user table, which seems to be initialized to the current date when the user account is created, and it's updated whenever the user enters notes. But if that user registered on that day, you can't argue that he wasn't "active" that day, right?

[nanda]

joined:2002-07-21 ..I´m old here..I´m one of 23 users active..

[valkske]

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

you are middle aged not nearly death i'm 43 and i planning to live still for a long time

[Annie_in_exile]

Could we please have an update of this table? I'd be curious to know how many users are still here one month after the peak in February.

[Schaza]

I have registered in 2002-03, so i belong to this quite sad looking group...

| 2002-03 | 917 | 31 | 3.38 | 46 | 5.02 |

[bura]

i've joined in 16.8.2003

| 2003-08 | 2678 | 185 | 6.91 | 335 | 12.51 |

so it's biggest new users month ever...

-bura