ChiefsPlanet Random ChiefsPlanet Stats - Page 49

**DaFace** · 07-11-2008, 08:57 PM

There are all sorts of stats about the forum buried in the Admin CP. I'd love to make those available to everyone, but I haven't really found an add-on that does it well. But, I'm a stats geek, so I might bump this thread from time to time with useless tidbits that I find interesting.

BleedingRed · 06-27-2023, 03:17 PM

Quote:

Originally Posted by DaFace

Resurrecting an old thread because I've been playing around with the backend database as a way to practice some SQL skills (and put ChatGPT's coding skills to the test). If anyone has any ideas for analysis stuff you think would be interesting, drop them in here.

No promises on when or if I'll get to anything that you suggest, but I appreciate the fodder for things to think about. Don't worry too much about whether you think a question is answerable - that's part of the fun.

Examples of things that come to mind as stuff I might look at:
-What percentage of OG posters are still active today?
-How have participation rates in individual subforums ebbed and flowed over the years?
-How does the political leanings of the President impact the political leanings of who is active in DC? (This one will be tricky, and I might need a partner who has been a long-term DC participant help me categorize people. I think it's an interesting question, though.)
-What percentage of total posts in each forum come from that forum's top posters (e.g., how many people make up >50% of posts in each forum)?

I'd like to see a graph of Dongers post count by year, 2015 to today.

Typical bar graph, year over year.... Starting in 2015 for no particular reason.

kcgreene · 06-27-2023, 03:20 PM

I'm just one guy, but I'd be curious if there was a way to see if we could see the ratio of those lurking without an account to active users. As someone who was mainly a lurker almost daily for essentially the last decade, and finally decided to start posting, I'm genuinely curious how many more are like that.

BleedingRed · 06-27-2023, 03:21 PM

Quote:

Originally Posted by kcgreene

I'm just one guy, but I'd be curious if there was a way to see if we could see the ratio of those lurking without an account to active users. As someone who was mainly a lurker almost daily for essentially the last decade, and finally decided to start posting, I'm genuinely curious how many more are like that.

50/50 half of those lurking forgot their login information.

kcgreene · 06-27-2023, 03:30 PM

Quote:

Originally Posted by BleedingRed

50/50 half of those lurking forgot their login information.

Very possible. Makes one wonder why they haven't made new login stuff or clicked Forgot Password.

Regardless, I'd be curious.

ModSocks · 06-27-2023, 03:34 PM

Quote:

Originally Posted by DaFace

Resurrecting an old thread because I've been playing around with the backend database as a way to practice some SQL skills (and put ChatGPT's coding skills to the test). If anyone has any ideas for analysis stuff you think would be interesting, drop them in here.

No promises on when or if I'll get to anything that you suggest, but I appreciate the fodder for things to think about. Don't worry too much about whether you think a question is answerable - that's part of the fun.

Examples of things that come to mind as stuff I might look at:
-What percentage of OG posters are still active today?
-How have participation rates in individual subforums ebbed and flowed over the years?
-How does the political leanings of the President impact the political leanings of who is active in DC? (This one will be tricky, and I might need a partner who has been a long-term DC participant help me categorize people. I think it's an interesting question, though.)
-What percentage of total posts in each forum come from that forum's top posters (e.g., how many people make up >50% of posts in each forum)?

MOAR STATS. GIVE ME MORE STATS.

**DaFace** · 06-27-2023, 04:18 PM

Quote:

Originally Posted by BleedingRed

50/50 half of those lurking forgot their login information.

It's true, but who knows - I haven't ever dug into tables that track sessions. They may be in there.

**Bowser** · 06-27-2023, 04:21 PM

Are there any accounts started in August 2000 that show still active but have zero posts for the entirety of their time here?

seclark · 06-27-2023, 04:24 PM

Somebody’s gonna get busted.

sec

**DaFace** · 06-27-2023, 04:29 PM

Quote:

Originally Posted by BleedingRed

I'd like to see a graph of Dongers post count by year, 2015 to today.

Typical bar graph, year over year.... Starting in 2015 for no particular reason.

I will PROBABLY stay away from anything that singles out an individual person unless that person specifically requests it. This is meant to be fun, not contentious.

**DaFace** · 06-27-2023, 04:36 PM

Quote:

Originally Posted by Bowser

Are there any accounts started in August 2000 that show still active but have zero posts for the entirety of their time here?

Ha, that's a fun one (and easy). Alas, there are none. However, here are five guys who really show what it means to be lurkers. They all joined in August of 2000, have been active in the past month, but have less than 500 posts.

Code:

username
posts
SUPER CHIEF
98
chief mohawk
125
Traveller
158
Iron Chef
418
Wrasse
499

SUPER CHIEF was active this morning and averages one post every 85 days.

ModSocks · 06-27-2023, 04:37 PM

Quote:

Originally Posted by DaFace

Ha, that's a fun one (and easy). Alas, there are none. However, here are five guys who really show what it means to be lurkers. They all joined in August of 2000, have been active in the past month, but have less than 500 posts.

Code:

username
posts
SUPER CHIEF
98
chief mohawk
125
Traveller
158
Iron Chef
418
Wrasse
499

holy shit. I think we just uncovered the Chiefsplanet Deep State.

**mlyonsd** · 06-27-2023, 04:42 PM

Quote:

Originally Posted by DaFace

Ha, that's a fun one (and easy). Alas, there are none. However, here are five guys who really show what it means to be lurkers. They all joined in August of 2000, have been active in the past month, but have less than 500 posts.

Code:

username
posts
SUPER CHIEF
98
chief mohawk
125
Traveller
158
Iron Chef
418
Wrasse
499

SUPER CHIEF was active this morning and averages one post every 85 days.

LOL, that's awesome.

**Easy 6** · 06-27-2023, 04:46 PM

Super Chief is one cool liberal, you only get to him through me

**New World Order** · 06-27-2023, 04:56 PM

Quote:

Originally Posted by DaFace

Ha, that's a fun one (and easy). Alas, there are none. However, here are five guys who really show what it means to be lurkers. They all joined in August of 2000, have been active in the past month, but have less than 500 posts.

Code:

username
posts
SUPER CHIEF
98
chief mohawk
125
Traveller
158
Iron Chef
418
Wrasse
499

SUPER CHIEF was active this morning and averages one post every 85 days.

Incredible

**Bowser** · 06-27-2023, 04:56 PM

Quote:

Originally Posted by Chief Ten Beers

Super Chief is one cool liberal, you only get to him through me

I believe you are speaking of SuperChief, not the OG two-worded Super Chief.

07-11-2008, 08:57 PM
DaFace Kind of a mod Join Date: Aug 2005 Location: Donkey Land Casino cash: $2026899	Random ChiefsPlanet Stats There are all sorts of stats about the forum buried in the Admin CP. I'd love to make those available to everyone, but I haven't really found an add-on that does it well. But, I'm a stats geek, so I might bump this thread from time to time with useless tidbits that I find interesting.
Posts: 51,768

06-27-2023, 03:20 PM	#722
kcgreene Starter Join Date: Dec 2010 Casino cash: $5954900	I'm just one guy, but I'd be curious if there was a way to see if we could see the ratio of those lurking without an account to active users. As someone who was mainly a lurker almost daily for essentially the last decade, and finally decided to start posting, I'm genuinely curious how many more are like that.
Posts: 727

06-27-2023, 04:21 PM	#727
Bowser sorta mod-ish Join Date: Jan 2004 Location: KC North Casino cash: $3441616	Are there any accounts started in August 2000 that show still active but have zero posts for the entirety of their time here?
Posts: 100,647	1 0

06-27-2023, 04:24 PM	#728
seclark MVP Join Date: Aug 2000 Location: nemo Casino cash: $1689900	Somebody’s gonna get busted. sec __________________ "Mr. seclark. Wrong for gravy, wrong for jelly, wrong for biscuits." -rj "If every Planeteer who was disliked by another Planeteer stopped being a Planeteer we wouldn't have any Planeteers." -rj
Posts: 13,399

06-27-2023, 04:46 PM	#733
Easy 6 pie is never free Join Date: Sep 2006 Location: the drivers seat Casino cash: $3727775	Super Chief is one cool liberal, you only get to him through me
Posts: 91,692