Statistical F.U.N!

sidetwo · 03-15-2012, 02:45 PM

So I was playing around with SQL queries trying to find statistics for random things on these forums and to be honest I've always LOVED statistical data. The forums contain a LOT of data and sometimes pulling values for these sorts of things can be pretty exciting, albeit a bit geeky.

Anyway you guys might find these interesting... if you don't, well... well, it's bad luck for you, isn't it? ISN'T IT? HUH!? YEAH!? YEAAHHHH!!!??! *cough* erm..

Statistics as at March 15, 2012 - 3:30PM GMT

Most threads created by users all time

@sidetwo - 324 threads
@AnttiApina - 102 threads
@Maddieman - 88 threads
@Kahr - 59 threads
@JoYnEr - 50 threads

Most posts created by users all time

@sidetwo - 6,762 posts
@Kahr - 5,769 posts
@Maddieman - 3,821 posts
@Morry - 3,618 posts
@TannosukeGR - 2,955 posts

Most posts made in 2011

@TannosukeGR, @Kahr - 1014 posts (TIE!)
@MikkiRMD - 692 posts
@sidetwo - 666 posts (OMG! DEVIL!!!)
@yogibbear - 589 posts
@thebestbit - 498 posts

Most likes received all time

@MikkiRMD - 283 likes
@MarkusRMD - 278 likes
@sidetwo - 236 likes
@Morry - 72 likes
@yogibbear - 69 likes

Most viewed user profiles of all time

@sidetwo - 30,682 profile views
@MarkusRMD - 14,989 profile views
@GENE_BC - 14,524 profile views
@Kahr - 12,150 profile views
@Morry - 10,452 profile views

Most viewed threads of all time

25,000+ Post Topic! - 537,913 views
Max Payne Original pictures - 368,735 views
Max Payne 3 - 263,010 views
Alan Wake Ending Theories (Spoilers) - 176,534 views
What game did you last play? - 176,100 views

Most replied to threads of all time

25,000+ Post Topic! - 13,276 posts
What game did you last play? - 4,365 posts
Alan Wake coming to PC on February 16th, 2012! - 2,800 posts
Listening To Right Now? - 2,107 posts
What is with this? (720p discussion) - 1,868 posts

Most popular forum - Alan Wake
Total threads created in 2011 - 939 threads
Total threads created all time - 8,407 (5,226 actual remaining) threads
Total posts created in 2011 - 19,307 posts
Total posts created all time - 147,272 (141,631 actual remaining) posts
Most active registered users in a day - 403 users
Total users registered in 2011 - 12,401 users
Total searches performed all time - 109,820 searches
Total moderation actions (delete, close, etc) performed all time - 11,201 actions
Total spammers automatically blocked from registering - 393,205 spammers

yogibbear · 03-15-2012, 03:13 PM

I don't understand why ADM doesn't poll in any of this... MADNESS!

djshauny1 · 03-15-2012, 04:12 PM

Thats alot of spammers lol

TannosukeGR · 03-15-2012, 04:29 PM

Fortunately, I'm not the grand spammer.

LOOOOOOOOOOL, @Kahr, it's like a race for being tied.

Well, @Kahr is the King! ^^

Zhinarkos · 03-15-2012, 04:50 PM

Everybody likes Mikki!

djshauny1 · 03-15-2012, 07:24 PM

I want Mikkis stash

Morry · 03-15-2012, 07:53 PM

Quote:

Originally Posted by sidetwo

Total moderation actions (delete, close, etc) performed all time - 11,201 actions

I demand a pay rise!

Kahr · 03-16-2012, 07:29 AM

Damn you sidetwo, you thread hogger you. You create far too many threads!

How is a guy to keep up with that?!

But heeeeeey, look at me. I'm on the top five list of most view profiles. Looks like people are curious about me (and rightfully so!).

Fun stats Pete.

Jakanadin · 03-23-2012, 02:31 PM

Nice! So the Forums are definitely active, good to see. Comparing them to the Forums I take care of, our Stats aren't far off, which is actually quite surprising to me! Seeing as how this is an official gaming forum and mine is quite unofficial. Have you guys put thought into an advertising budget for the Forums? Maybe advertise through Facebook; would possibly bring more members. More members = More feedback, more word-of-mouth, more members, and more money!

Then again, I do not know the budget of which RMD has for advertising, nor any idea of what the budget pertaining to RMD in general is; just an idea from a guy wanting to see these Forums blow up!

sidetwo · 03-23-2012, 04:07 PM

Most attention in our community really does go to our social channels, which I've grown to over 300,000 members. These forums are really just a sort of insiders club, in a sense.

It's growing but it's at a nice rate that retains a lot of the culture quite well.

TannosukeGR · 03-23-2012, 04:19 PM

Hey, Pete, is there any prize for the top 5?

Jakanadin · 03-23-2012, 05:11 PM

Ahh, that's where everyone is! Good thinking. What other sites do you guys use besides Facebook for RMD?

sidetwo · 03-23-2012, 05:35 PM

We use the standard ones. Multiple pages on Facebook, our @remedygames Twitter account, alanwake.com and of course these forums.

sidetwo · 03-23-2012, 05:36 PM

Tanno: Why, yes!

Jakanadin · 03-23-2012, 05:42 PM

Hmm, haven't made it to Google+, Myspace, or Tumblr? I mean I know they're no where near as popular as Facebook or Twitter, but they'll still generate activity, people, and provide a more diverse experience for people across all mainstream social channels!

sidetwo · 03-23-2012, 05:47 PM

We're in the process of re-structuring our community, which will start happening slowly with the end result being more community support on all our channels.

It's all about focusing energy to areas where we'll see the most gain, out of those sites that would most likely be Google+. We'll see about that.

Jakanadin · 03-23-2012, 06:35 PM

Good to hear, good to hear. It'll definitely take more man-power to do that though. Does Alan wake have a dedicate Street team that takes care of the Social pages? Or is it all ran through the Company itself? It'd definitely take quite a few people to run all of those pages and answer all the questions and comments.

sidetwo · 03-23-2012, 06:51 PM

It's mainly me and a selection of other RMD staff that help out.

Jakanadin · 03-23-2012, 08:08 PM

Hmm, I highly doubt the feedback you guys give through those channels is hardly anywhere near as personal as what you give through these Forums though. I imagine quite a few people post questions, comments, and random useless things all throughout the day on it. I'd regularly link them to the Forums to get to know you guys, and see that RMD is definitely more personal and listens to feedback then other companies.

03-15-2012, 02:45 PM	#1
sidetwo Formerly of Remedy, currently of awesome.	Statistical F.U.N! So I was playing around with SQL queries trying to find statistics for random things on these forums and to be honest I've always LOVED statistical data. The forums contain a LOT of data and sometimes pulling values for these sorts of things can be pretty exciting, albeit a bit geeky. Anyway you guys might find these interesting... if you don't, well... well, it's bad luck for you, isn't it? ISN'T IT? HUH!? YEAH!? YEAAHHHH!!!??! cough erm.. Statistics as at March 15, 2012 - 3:30PM GMT Most threads created by users all time @sidetwo - 324 threads @AnttiApina - 102 threads @Maddieman - 88 threads @Kahr - 59 threads @JoYnEr - 50 threads Most posts created by users all time @sidetwo - 6,762 posts @Kahr - 5,769 posts @Maddieman - 3,821 posts @Morry - 3,618 posts @TannosukeGR - 2,955 posts Most posts made in 2011 @TannosukeGR, @Kahr - 1014 posts (TIE!) @MikkiRMD - 692 posts @sidetwo - 666 posts (OMG! DEVIL!!!) @yogibbear - 589 posts @thebestbit - 498 posts Most likes received all time @MikkiRMD - 283 likes @MarkusRMD - 278 likes @sidetwo - 236 likes @Morry - 72 likes @yogibbear - 69 likes Most viewed user profiles of all time @sidetwo - 30,682 profile views @MarkusRMD - 14,989 profile views @GENE_BC - 14,524 profile views @Kahr - 12,150 profile views @Morry - 10,452 profile views Most viewed threads of all time 25,000+ Post Topic! - 537,913 views Max Payne Original pictures - 368,735 views Max Payne 3 - 263,010 views Alan Wake Ending Theories (Spoilers) - 176,534 views What game did you last play? - 176,100 views Most replied to threads of all time 25,000+ Post Topic! - 13,276 posts What game did you last play? - 4,365 posts Alan Wake coming to PC on February 16th, 2012! - 2,800 posts Listening To Right Now? - 2,107 posts What is with this? (720p discussion) - 1,868 posts Most popular forum - Alan Wake Total threads created in 2011 - 939 threads Total threads created all time - 8,407 (5,226 actual remaining) threads Total posts created in 2011 - 19,307 posts Total posts created all time - 147,272 (141,631 actual remaining) posts Most active registered users in a day - 403 users Total users registered in 2011 - 12,401 users Total searches performed all time - 109,820 searches Total moderation actions (delete, close, etc) performed all time - 11,201 actions Total spammers automatically blocked from registering - 393,205 spammers I'm on the Twitters! @sidetwo

03-15-2012, 04:50 PM	#5
Zhinarkos Volunteer Moderator	Re: Statistical F.U.N! Everybody likes Mikki! We are what we choose to be, not what we want to be

03-15-2012, 07:53 PM	#7
Morry Volunteer Moderator	Re: Statistical F.U.N! Quote: Originally Posted by sidetwo Total moderation actions (delete, close, etc) performed all time - 11,201 actions I demand a pay rise! Remedy's currently known projects: Quantum Break Unannounced iOS project

03-16-2012, 07:29 AM	#8
Kahr Volunteer Moderator	Re: Statistical F.U.N! Damn you sidetwo, you thread hogger you. You create far too many threads! How is a guy to keep up with that?! But heeeeeey, look at me. I'm on the top five list of most view profiles. Looks like people are curious about me (and rightfully so!). Fun stats Pete. "So, where shouldn't I go so that I don't turn the power back on, accidentally?"

03-23-2012, 04:07 PM	#10
sidetwo Formerly of Remedy, currently of awesome.	Re: Statistical F.U.N! Most attention in our community really does go to our social channels, which I've grown to over 300,000 members. These forums are really just a sort of insiders club, in a sense. It's growing but it's at a nice rate that retains a lot of the culture quite well. I'm on the Twitters! @sidetwo

03-15-2012, 03:13 PM	#2
yogibbear	Re: Statistical F.U.N! I don't understand why ADM doesn't poll in any of this... MADNESS! Sarah Breaker > Barry Wheeler. Yep, I went there!

03-15-2012, 04:12 PM	#3
djshauny1	Re: Statistical F.U.N! Thats alot of spammers lol

03-15-2012, 04:29 PM	#4
TannosukeGR	Re: Statistical F.U.N! Fortunately, I'm not the grand spammer. LOOOOOOOOOOL, @Kahr, it's like a race for being tied. Well, @Kahr is the King! ^^ The game can take you in a journey of fantasy, cause your mind is the creator of fantasy !

03-15-2012, 07:24 PM	#6
djshauny1	Re: Statistical F.U.N! I want Mikkis stash

03-23-2012, 02:31 PM	#9
Jakanadin	Re: Statistical F.U.N! Nice! So the Forums are definitely active, good to see. Comparing them to the Forums I take care of, our Stats aren't far off, which is actually quite surprising to me! Seeing as how this is an official gaming forum and mine is quite unofficial. Have you guys put thought into an advertising budget for the Forums? Maybe advertise through Facebook; would possibly bring more members. More members = More feedback, more word-of-mouth, more members, and more money! Then again, I do not know the budget of which RMD has for advertising, nor any idea of what the budget pertaining to RMD in general is; just an idea from a guy wanting to see these Forums blow up!

03-23-2012, 04:19 PM	#11
TannosukeGR	Re: Statistical F.U.N! Hey, Pete, is there any prize for the top 5? The game can take you in a journey of fantasy, cause your mind is the creator of fantasy !

03-23-2012, 05:11 PM	#12
Jakanadin	Re: Statistical F.U.N! Ahh, that's where everyone is! Good thinking. What other sites do you guys use besides Facebook for RMD?

03-23-2012, 05:35 PM	#13
sidetwo Formerly of Remedy, currently of awesome.	Re: Statistical F.U.N! We use the standard ones. Multiple pages on Facebook, our @remedygames Twitter account, alanwake.com and of course these forums. I'm on the Twitters! @sidetwo

03-23-2012, 05:36 PM	#14
sidetwo Formerly of Remedy, currently of awesome.	Re: Statistical F.U.N! Tanno: Why, yes! I'm on the Twitters! @sidetwo

03-23-2012, 05:42 PM	#15
Jakanadin	Re: Statistical F.U.N! Hmm, haven't made it to Google+, Myspace, or Tumblr? I mean I know they're no where near as popular as Facebook or Twitter, but they'll still generate activity, people, and provide a more diverse experience for people across all mainstream social channels!

03-23-2012, 05:47 PM	#16
sidetwo Formerly of Remedy, currently of awesome.	Re: Statistical F.U.N! We're in the process of re-structuring our community, which will start happening slowly with the end result being more community support on all our channels. It's all about focusing energy to areas where we'll see the most gain, out of those sites that would most likely be Google+. We'll see about that. I'm on the Twitters! @sidetwo

03-23-2012, 06:35 PM	#17
Jakanadin	Re: Statistical F.U.N! Good to hear, good to hear. It'll definitely take more man-power to do that though. Does Alan wake have a dedicate Street team that takes care of the Social pages? Or is it all ran through the Company itself? It'd definitely take quite a few people to run all of those pages and answer all the questions and comments.

03-23-2012, 06:51 PM	#18
sidetwo Formerly of Remedy, currently of awesome.	Re: Statistical F.U.N! It's mainly me and a selection of other RMD staff that help out. I'm on the Twitters! @sidetwo

03-23-2012, 08:08 PM	#19
Jakanadin	Re: Statistical F.U.N! Hmm, I highly doubt the feedback you guys give through those channels is hardly anywhere near as personal as what you give through these Forums though. I imagine quite a few people post questions, comments, and random useless things all throughout the day on it. I'd regularly link them to the Forums to get to know you guys, and see that RMD is definitely more personal and listens to feedback then other companies.