Another look at "active users" at SDMB

I like your thinking! Maybe somebody between

Nametag Join Date: 04/13/2002 http://boards.straightdope.com/sdmb/member.php?u=21252

and

Zeldar Join Date: 06-18-2003 http://boards.straightdope.com/sdmb/member.php?u=36386

(a difference in User Numbers of 15134 or “halfway” being u=28819 might help zoom in on the range)

That seems to be:

http://boards.straightdope.com/sdmb/member.php?u=28819
wdcsmwscaa
Guest
Last Activity: 03-19-2004 10:15 PM
Join Date: 01-02-2003

So that ought to help cut down on the heavy lifting.

Anybody? Wanna Race?

User number 36, join date 3/11/1999

Others registered on the same day (* denotes active users):

*GusNSpot (#33)
Fichchef
Stevicus
StaceyLyn(Slkaopi)
*Doug Bowe
Lanna
*gotpasswords
Granny J
DianneCar
Egads Ron
*AskNott
*PunditLisa
*KCB615
Shane
JustJoan
Chuy63
Trigger33
TXRebel
Barbara
Dick Macy
Tyler
Quarterat
IrRev Bat
Karen
JPetraliaX
Jean
SoxFan59
The Crimson Hipster Dufuz
*DrFidelius
DAVEW0071
*AHunter3
Phantmwise
Felinecare
Mark Mal
Darwinself (#70)

Here are the stats for August 3, 2000 (member number, member name, member status, total posts, last activity date):



8530  SixStringSamurai  Guest              27    8/10/2000
8531  Endora            Guest              44    6/15/2001
8532  INTERPRETER       Guest              30     9/2/2000
8533  Gregatiki         Guest              15    11/3/2000
8534  TommyTutone       Guest           1,117   11/28/2011
8535  shorin-ryu        Guest              88   11/28/2011
8536  tomstar           Guest               1     8/9/2000
8537  nesta             Charter Member    348   11/28/2011
8538  Chibi-X           Registered User     0    10/9/2001
8539  TylerDurden       Guest               0     8/3/2000
8540  brucemarnold      Guest               2    11/7/2000
8541  George Orwell     Registered User     0     8/3/2011
8542  peedin            Member            536   11/28/2011
8543  Agentold          Registered User     0     6/6/2001
8544  Pepsi90919        Guest               1     8/3/2000
8545  AntiNorn          Guest               1     8/3/2000
8546  skwalker          Guest               0     8/3/2000
8547  MEBuckner         Charter Member  9,103   11/28/2011
8548  Sakura            Guest             101    6/27/2003
8549  enilorac          Guest             158    4/24/2003
8550  ShamaFrog         Guest              65   10/18/2001
8551  boccmon           Guest               3    4/19/2002
8552  vertigo           Guest             271   10/26/2003
8553  manofgold5        Guest               0     8/3/2000
8554  Mammie            Guest             162    6/13/2004
8555  Clarissa Moore    Guest               2    8/15/2000
8556  Mad Man           Registered User     0    5/23/2002
8557  geeky             Registered User     0     8/3/2000
8558  jonathan_krauss   Guest               0     8/3/2000


For the recently active posters, last post dates were:
TommyTutone, 11/16/2011
shorin-ryu, 9/16/2011
nesta, 11/9/2011
peedin, 11/23/2011
MEBuckner, 11/28/2011

Sweet, I don’t have to do anything. Thanks.



Username			Last Activity	Posts	UserID
Qaanik 			04/28/00 07:05 PM	5	576
blando			04/28/00 07:05 PM	29	577
Sue  		        04/28/00 07:05 PM	4	578
Christine Batchelor	04/28/00 07:05 PM	4	579
Kemper Boyd		04/20/04 07:47 AM	2	580
pricciar               today                  2047     581
DakotaDusk 		04/28/00 07:05 PM	18	582
mrsdewinter 		04/28/00 07:05 PM	1	583
Walt 			04/28/00 07:05 PM	1	584
phaticus                   04/28/00 07:05 PM	2	585
NEterk1                    04/28/00 07:05 PM	0	586
C-Gull			04/28/00 07:05 PM	0	587

I don’t know what I did wrong with my formatting. But, I think it is readable enough to show that my join date was not exactly a red letter day for new users. Aside from me only one of the 12 of us lasted past April 2000.

03-09-2010

Thanks to all of you for the input. I’ve begun the process of appending Julian Day numbers to the Join Date and User Numbers in my trimmed down and sorted summary file. As soon as I get that caught up with reality I will post it in hopes that somebody with good spreadsheet skills and software can do some fast number-crunching to provide a Big Picture analysis of how Join Dates and User Numbers are related.

The other details about “active members” may take more hands-on work.

That Biggest Day piece of trivia is another item we’ll need luck or grunt work to find.

Keep it coming. We’ve had 38 individual contributors so far.

Here’s another data point for you.
My user number is 14216 and I joined on 4-24-2001

Users 14196-14219 joined on the same day.

23 people joined on 4-24-01
21 are inactive
Myself and Simply_cats(14219) are the only two remaining active.
Oddly enough, Mort Furd, stuck around for 4 years and contributed 1432 posts before disappearing in Nov of '05

An interesting excercise.

My join date is 6/28/2000

Including me, there were 33 people who joined up that day; it looks like it’s just me and **Lsura **who are still active - and Unix Geek, but he needs to up his post count if he wants to hang with the big boys.

List:

Unix Geek - 136 posts - 11/27/2011
dpr - 49 posts - 6/28/2000 - BANNED
JJones - 1 Post - 12/2/2001
Chupacabra - 112 posts - 1/9/2004
Lsura - 5,759 posts - 11/29/2011
Rafaqat - 0 posts
qakkad - 11 posts - 6/28/2000 - BANNED
IvanK - 0 posts
PepperMan - 8 posts - 6/28/2000
zwaldd - 1,449 posts - 8/14/2005
Ayesha - 22 posts - 6/28/2000 - BANNED (with some weird sig about being a ‘look alike troll’)
alymaitland - 2 posts - 7/27/2000
Lil’ Kiffy - 43 posts - 2/21/2001
Ayesha - 7 posts - 6/28/2000 - BANNED (same name as before, odd - and ditto on the weird ‘look alike troll’ sig thing)
billrd01 - 0 posts
bp628 - 1 post - 8/22/2000
Saysha - 82 posts - 6/27/2001
Roxanne_in_the_red_light - 0 posts
Tymp - 11 posts - 6/28/2000 - BANNED
Enigma - 0 posts
Lord Vega - 128 posts - 4/25/2006
Heloise - 2 posts - 6/28/2000 - BANNED (another ‘look alike troll’)
Jack Batty - 10,185 posts - 11/29/2011
[ mystery dissappeared poster # 1 ]
gump - 9 posts - 9/12/2005
scoutmom6 - 0 posts
SILENT-BOB NOT REALLY - 56 posts - 6/28/2000 - BANNED
Salton - 14 posts - 7/2/2000
Clayfighter - 1 post - 5/10/2001
SILENT-BOB NOT - 33 posts - 6/28/2000 - BANNED
Sarnoff - 0 posts
[ mystery dissappeared poster # 2 ]
Badge - 622 posts - 2/23/2005
I’m curious what the “look alike troll” thing was all about. The first Ayesha sig reads: “Hi, I’m a lookalike troll! Lynn put this in my sig!”

In fact, weren’t Ayesha, and another banned one from my list, dpr, (maybe **Tymp **too) settled and respected posters here? It must have been some troll crusade using existing names or something.

And I’m amused by the SILENT-BOB NOT thing. I remember Silent Bob … only posted in smilies. He was much loved/hated, depending on who you ask.

As of brewha’s post above we’ve had 39 individuals’ input. And since I’ve completed the Julian Day task I’ll post the latest version of the summary data.

If you want more info on Julian Day, please look at Julian Day – Fun and Games which I started on 11-18-2011, 10:58 AM and which could stand some participation!

====================



UserName          Join Date                      User Number                                               Julian Day
=====================================================================================================================

TubaDiva          Join Date: 03-10-1999          http://boards.straightdope.com/sdmb/member.php?u=32       2451247  
OpalCat           Join Date: 3/11/1999           http://boards.straightdope.com/sdmb/member.php?u=36       2451248
kunilou           Join Date: April 7, 1999       http://boards.straightdope.com/sdmb/member.php?u=535      2451275
pricciar          Join Date: 04-11-1999          http://boards.straightdope.com/sdmb/member.php?u=581      2451279
JBDivmstr         Join Date: 6/14/1999           http://boards.straightdope.com/sdmb/member.php?u=1458     2451343
Joey P            Join Date: 6/15/1999           http://boards.straightdope.com/sdmb/member.php?u=1478     2451344
Earl Snake-Hips Tucker
                  Join Date: 07-29-1999          http://boards.straightdope.com/sdmb/member.php?u=1972     2451388      
AuntiePam         Join Date: 08-05-1999          http://boards.straightdope.com/sdmb/member.php?u=2058     2451395
Sparky812         Join Date: 08-31-1999          http://boards.straightdope.com/sdmb/member.php?u=2338     2451421
Eureka            Join Date: 9/24/1999           http://boards.straightdope.com/sdmb/member.php?u=2661     2451445
Rhythmdvl         Join Date: 10-13-1999          http://boards.straightdope.com/sdmb/member.php?u=2845     2451464
Chronos           Join Date: 01-22-2000          http://boards.straightdope.com/sdmb/member.php?u=4176     2451565 
Clothahump        Join Date: 05-24-2000          http://boards.straightdope.com/sdmb/member.php?u=6642     2451688  
Tamex             Join Date: 7/19/2000           http://boards.straightdope.com/sdmb/member.php?u=8146     2451744
MEBuckner         Join Date: August 3, 2000      http://boards.straightdope.com/sdmb/member.php?u=8547     2451759
Gyrate            Join Date: November 13, 2000   http://boards.straightdope.com/sdmb/member.php?u=10829    2451861
malkavia          Join Date: 11-17-2000          http://boards.straightdope.com/sdmb/member.php?u=10931    2451865
Cazzle            Join Date: 12-27-2000          http://boards.straightdope.com/sdmb/member.php?u=11733    2451905
amarone           Join Date: 3-30-2001           http://boards.straightdope.com/sdmb/member.php?u=13774    2451998
Cicero            Join Date: 2nd April 2001      http://boards.straightdope.com/sdmb/member.php?u=13806    2452001
Omega Glory       Join Date: 4/20/2001           http://boards.straightdope.com/sdmb/member.php?u=14145    2452019
brewha            Join Date: 4-24-2001           http://boards.straightdope.com/sdmb/member.php?u=14216    2452023
don't ask         Join Date: 31st of May 2001    http://boards.straightdope.com/sdmb/member.php?u=14776    2452060
ZipperJJ          Join Date: 8-15-2001           http://boards.straightdope.com/sdmb/member.php?u=16467    2452136
Biffy the Elephant Shrew 
                  Join Date: 3-29-02             http://boards.straightdope.com/sdmb/member.php?u=20699    2452362 
Nametag           Join Date:  04/13/2002         http://boards.straightdope.com/sdmb/member.php?u=21252    2452377
Zeldar            Join Date:  06-18-2003         http://boards.straightdope.com/sdmb/member.php?u=36386    2452808
Starving Artist   Join Date:  12-27-03           http://boards.straightdope.com/sdmb/member.php?u=42779    2453000
DfrntBreign       Join Date: Feb. 21, 2004       http://boards.straightdope.com/sdmb/member.php?u=44274    2453056
RollOutTheBarrel  Join Date: May 1st, 2005       http://boards.straightdope.com/sdmb/member.php?u=52702    2453491 
Crotalus          Join Date: 6/30/2005           http://boards.straightdope.com/sdmb/member.php?u=53607    2453551
Bob Ducca         Join Date: 1/2/2006            http://boards.straightdope.com/sdmb/member.php?u=56822    2453737
steronz           Join Date: Feb 21, 2007        http://boards.straightdope.com/sdmb/member.php?u=64260    2454152
Half Man Half Wit Join Date: 6-14-2007           http://boards.straightdope.com/sdmb/member.php?u=67227    2454265
Panurge           Join Date: 7-30-2007           http://boards.straightdope.com/sdmb/member.php?u=68877    2454311
Blank Slate       Join Date: 4-13-2008           http://boards.straightdope.com/sdmb/member.php?u=75852    2454569
Zyanthia          Join Date:  09/01/2009         http://boards.straightdope.com/sdmb/member.php?u=85536    2455075
Darth Panda       Join Date: 03-09-2010          http://boards.straightdope.com/sdmb/member.php?u=89080    2455264
Moonlitherial     Join Date: 03-09-2010          http://boards.straightdope.com/sdmb/member.php?u=89087    2455264
=============================


You guys do everything the hard way. :wink: Computers will do this kind of thing for you. During the other thread Zeldar mentioned, I wrote some code that scrapes data like this, and as a result, I have a nearly complete dataset for answering these types of questions. It was a pretty simple matter to run it a bit more to get a picture of what’s changed in the meantime, and now I can make fascinating observations like:

Day with the most signups: April 28, 2011, with 304 signups. However, only 2 of those are still active, so lots of people who flamed out (see below) or left is less interesting than looking at the number of signups who actually stuck around for a certain amount of time, such as 60 days. Top 10 days for that:



(n = num signups, a = num still active, p = percent still active)
date       n    a   p
2003-01-07 34   1   3
2002-03-14 35   4   11
2003-01-08 37   3   8
2003-01-09 38   1   3
2003-01-10 38   5   13
2002-03-13 39   6   15
1999-03-14 43   5   12
1999-03-11 49   7   14
2002-03-12 58   8   14
2002-03-11 107  27 25

The date with the highest number of now-banned users is, unsurprisingly, April 28, 2011 (232 banned users). The next highest is Jan 4, 2011, with 83 banned users.

The oldest banned account is Markxxx, banned after 4465 days.

I don’t have time to do more slicing and dicing at the moment, but if you have questions that can be answered by knowing everyone’s post count, total number of posts, signup date and last activity date, shoot them my way. I can also make the data available if anyone else wants to nerd out or draw graphs. One interesting graph I’ve thought of would be a line showing signups per day, with a series of lines below that indicating “stayed for a week”, “stayed for a month”, “stayed for 90 days”, etc.

Oh, one more pair of stats since it’s easy to calculate:



Top "posts per day"
11.28 Mangetout Guest
11.45 Der Trihs Member
12.17 BigT Guest
12.48 Really Not All That Bright Guest
12.95 gonzomax BANNED
13.01 John Mace Guest
15.44 Marley23 Administerminator
15.79 BrainGlutton Guest
16.91 CitizenPained Guest
17.59 Diogenes the Cynic BANNED

Top "total posts"
38830 Really Not All That Bright Guest
39401 Liberal Guest
41227 Chronos Charter Member
41805 Johnny L.A. Charter Member
41860 Guinastasia Member
42608 John Mace Guest
43518 Mangetout Guest
50390 BrainGlutton Guest
54218 Marley23 Administerminator
58797 Diogenes the Cynic BANNED


You da man, ntucker! Thanks for accepting the challenge and producing some outstanding trivia.

As a general rule management does not release data. But it looks like y’all are getting more than enough to chew over with what you’re doing here in the thread anyway. Carry on.

I have to assume that’s because it was exactly 222 years to the day since the mutiny on the Bounty.

Happy to help my join date brother.

About a million people joined on the same day as me (4/26/2000). Most of them quit the Dope 2 days later. Only 4 are still active, including the first person to join that day: pkbites.

After that we have:

FrEEzErMoNkEy2 Last Activity: 04-28-2000 07:07 PM
InsanityIncarnate Last Activity: 03-05-2004 12:37 AM
ajs42 Last Activity: 04-28-2000 07:07 PM
Apologist BANNED Last Activity: 04-28-2000 07:07 PM
skingraftat75mph Last Activity: 04-28-2000 07:07 PM
GarrettTaylor Last Activity: 04-28-2000 07:07 PM
LadyJanie Last Activity: 04-28-2000 07:07 PM
ej8 Last Activity: 04-28-2000 07:07 PM
redheadedokie Last Activity: 04-28-2000 07:07 PM
Queensryche Last Activity: 04-28-2000 07:07 PM
Procrutes Last Activity: 07-06-2000 07:22 PM
belltower Last Activity: 04-28-2000 07:07 PM
BELASCO Last Activity: 05-11-2000 12:00 AM
Wendy C. Brooks Last Activity: 04-28-2000 07:07 PM
Ceejaytee (me; #6004) Last Activity: Today 02:15 PM (still active)
Phrogge Last Activity: 05-23-2009 02:37 AM
tchietao Last Activity: 04-28-2000 07:07 PM
Emustrangler Last Activity: 12-05-2001 08:47 PM
kRaZycHeeZ Last Activity: 04-28-2000 07:07 PM
teela brown Last Activity: 11-27-2011 05:05 PM (still active)
JavaMaven1 Last Activity: 03-08-2009 01:19 PM
dazed Last Activity: 10-01-2001 06:13 PM
Marlitharn Last Activity: Today 01:23 PM (still active)
godfork Last Activity: 05-24-2000 11:13 AM
StupidName Last Activity: 04-28-2000 07:07 PM
John Larrabee Last Activity: 04-28-2000 07:07 PM
mattmanz_da_man Last Activity: 05-01-2000 11:56 PM
Maharet676 Last Activity: 04-28-2000 07:07 PM
Bloodshedder Last Activity: 03-11-2001 03:58 PM
abcent Last Activity: 04-28-2000 07:07 PM
Nachomama Last Activity: 05-24-2000 10:28 PM
farley BANNED Last Activity: 04-28-2000 07:07 PM
hazcon Last Activity: 04-28-2000 07:07 PM

Here is a dump of the full data in CSV format if anyone wants it, and here it is tallied into buckets by date, showing for each day: number of signups, number that stayed for at least 5 days, 30 days, 60 days, 180 days, and the number that are still active. Should make a pretty graph if someone wants to give it a whirl.

AuntiePam, I took the liberty of looking at your Join Date and the others who joined then.

Here’s a copy of what I found:

========================================

#34 Yesterday, 07:51 PM
AuntiePam (14 joined)
My number is 2058
Join Date: 08-05-1999
http://boards.straightdope.com/sdmb/member.php?u=2058

http://boards.straightdope.com/sdmb/member.php?u=2047
Outlaw - Last Activity: 04-28-2000 06:05 PM
Join Date: 08-05-1999

http://boards.straightdope.com/sdmb/member.php?u=2060
mikan - Last Activity: 01-25-2003 09:36 PM
Join Date: 08-05-1999

========================================

I did this lookup so I could have your data in a new sort I’m working on, which will have everybody’s “total joined” from most to least. Once we determine what the “average day’s” signup rate is we can see where everybody stands relative to that.

ntucker’s data answers so many of the basic questions I have had that there are only a few gee-whiz numbers I’m still curious about.

If anybody else has some burning questions about “active users” or related issues, please speak up. I have faith that ntucker can answer them, or make a Grade-A try at it.

On my join date, which was 03-05-2004 in my time zone:

[ul]
[li]34 joined[/li][li]20 with no posts (including one Banned with no posts)[/li][li]8 with 1, 2 or 3 posts[/li][li]1 with 6 posts[/li][li]1 with 17 posts[/li][li]1 with 124 posts[/li][li]1 with 180 posts[/li][li]1 (me) with 693 posts, not including this one[/li][/ul]

The only one other than me who could remotely be said to be active is the one with 17 posts, whose last activity date was in March this year.

So, 34 joined, one or two active.

There seems to be an error somewhere. I’m on my iPod and can’t get the first link to open but the total signup count for my join date of 12-27-03 is off. The bucket list (heh) shows 30 signups that day but the actual count is 36. I’m not sure about the totals in the other columns because I didn’t compile the same info. Just thought I’d mention it in case there’s a bug throwing throwing off your totals.

My guess is this is a timezone difference. To simplify things, my numbers were gathered in my own timezone (PST), which can make the day buckets slightly different than yours. I just checked the data and it looks right: userid 42767 was the last one registered on 12/26/03 and 42798 was the first one registered on 12/28/03. The 30 in between were all registered on 12/27.