Help Needed - Average MGoUser Activity

26 posts / 0 new
Login or register to post comments
Last post
February 24th, 2012 at 1:24 PM
#1
beenplumb
beenplumb's picture
Joined: 10/15/2010
MGoPoints: 847
Help Needed - Average MGoUser Activity

Hey everyone,

I’m interested in collecting some data on average user activity here on MGoBlog. I found myself wondering about how often I post here and how much of my work day is wasted clicking the banner atop the page and looking for a new ‘Hello’ post.

I thought this might make for an interesting case study, so I’m asking for some help from my fellow MGo-addicts. Simply follow this link to my Google Doc spreadsheet, enter your Username, your MGoPoint total, and how many years you’ve been active (be as exact as possible using decimal places to account for months). Columns D through G will automatically populate based on the numbers you input into B and C.

After the data is collected I’m going to do some basic analysis and will return some averages, standard deviations, and probably a cool chart or two, along with some other insights depending on what I find.

This will be my first (debatably) major contribution to the site, so your help is greatly appreciated!

@beenplumb

procsqlrunning.tumblr.com

Top
Tags:

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
February 24th, 2012 at 1:32 PM | Another way to get data... (Score:1)
justingoblue
justingoblue's picture
Joined: 11/16/2010
MGoPoints: 10858

You can also click "Users by MGoPoints", although you would need to click on each user for the date they joined.

Go Blue!

February 24th, 2012 at 1:37 PM | Well, let's skew that right off the bat.... (Score:2 Normal)
M-Wolverine
M-Wolverine's picture
Joined: 10/04/2009
MGoPoints: 38747

The division per year says it's trying to divide by 0 and not working.

"I love him, he's a great coach, he's a great mentor, he's a great friend. He's every single thing you want a college coach to be, and he does it flawlessly." -David Molk

February 24th, 2012 at 1:46 PM | Damn, M-Wolverine... (Score:1)
justingoblue
justingoblue's picture
Joined: 11/16/2010
MGoPoints: 10858

You're averaging more points per "game" than MJ did; hope Brian is paying you equivilant money.

Go Blue!

February 24th, 2012 at 2:25 PM | Well, always glad to beat MJ (Score:2 Normal)
M-Wolverine
M-Wolverine's picture
Joined: 10/04/2009
MGoPoints: 38747

More Beveled Guilt is good....maybe I'll get a cut.

As others have said, the open thread and pos-bang era made things a bit different. And it used to be that you got points for posts you started in a thread....not sure if it was one or two...but if that was true, at least 1200+ of those came from one post. Don't think that happens anymore.

And general FYI, now that no one else was using the spreadsheet, I edited the by year category so the formula works on mine.

"I love him, he's a great coach, he's a great mentor, he's a great friend. He's every single thing you want a college coach to be, and he does it flawlessly." -David Molk

February 24th, 2012 at 1:38 PM | Not sure how this will be noted (Score:5 Normal)
Vivz
Vivz's picture
Joined: 12/14/2010
MGoPoints: 938

But people with accounts prior to the posbanging system dying will most likely have a much greater number of points, and a seemingly higher ratio of activity/time spent on mgoblog.

 

History is written by the victors-Winston Churchill
February 24th, 2012 at 1:44 PM | Exactly (Score:2)
quigley.blue
quigley.blue's picture
Joined: 03/01/2010
MGoPoints: 240

I know people from the early times that have made 1 or 2 funny/solid posts, that dont post anymore that are well into the hundreds, whereas I know exactly how many posts I've made.

<------

February 24th, 2012 at 1:46 PM | You're right. If anyone knows (Score:1)
beenplumb
beenplumb's picture
Joined: 10/15/2010
MGoPoints: 847

You're right. If anyone knows what date the system changed I'll factor that in somehow, or at least make not of it in the final analysis. It won't affect anyone who joined after that.

Also, Mods giving point bumps to people will skew the data as well.

@beenplumb

procsqlrunning.tumblr.com

February 24th, 2012 at 2:02 PM | you don't recall (Score:3 Normal)
Benoit Balls
Benoit Balls's picture
Joined: 11/27/2010
MGoPoints: 858

Malwarefest 2011? Pos-bangs and everything changed after that debacle. It was roughly about 1/25/2011, as that was the night my wife and I found out our baby is a boy, and my Hard drive crashed, and I had to use my phone for everything. I am still waiting on the  commerative T-shirt

ALWAYS remember the golden rule: He who has the gold, makes the rules

 

February 24th, 2012 at 1:46 PM | I've been on here for longer (Score:3 Normal)
randyfloyd
randyfloyd's picture
Joined: 08/19/2008
MGoPoints: 1040

than most, but I don't post all the time.  I do however, check at least 10 times a day (probably more like 50), to see if there is anything new.  

 

It's tough being Blue in Columbus!!!

February 24th, 2012 at 1:58 PM | Agreed, I've been around for (Score:3 Normal)
jhender85
jhender85's picture
Joined: 10/25/2008
MGoPoints: 1381

Agreed, I've been around for awhile (well before the end of the posbang era), and have very rarily contributed to the forums until the past few months (hence the low point total), but would say I average refreshing MGoBlog atleast 2-3 times an hour during the awake hours of the day

February 24th, 2012 at 2:16 PM | Lets make it a tri-fecta (Score:3 Normal)
AZBlue
AZBlue's picture
Joined: 09/14/2008
MGoPoints: 969

Look at almost every post - even most of the OT ones, refresh and average of 20x per day but do not post often.

If Mgo and the RR era have done anything for me personally - it was to revive my obsession with M football that had faded as time and distance from Ann Arbor grew.  (FYI - This is NOT a positive in Mrs. AZBlue's eyes.)

February 24th, 2012 at 6:05 PM | It's an orgy now. (Score:2)
Hank Hill
Hank Hill's picture
Joined: 10/03/2008
MGoPoints: 192

I am in the same boat. I had an old account in the New Math days, made one post with that account, got ripped to shreds, and ran away with my tail tucked between my legs. I have since grown up and only jump in on pos-bangs, what are you drinking threads, and some of the OT stuff. I did want to create a new post about Jim Harbaugh's recent comments while being a ball boy at the Indiana basketball game last week.
I did not see anything on the forums in regards to it. http://sports.yahoo.com/blogs/ncaab-the-dagger-college-basketball-blog/j.... I just don't have the required minimum points to start a new thread.

Plus the girlfriend asked one day what I spend so much time looking at on "The Blog". When I told her I read all the front page entries and the diaries and spend a lot of time reading the forums and laughing and/or getting angry. When she asked what some of the comments I posted on the forum were, I told her that I didn't comment. She was very upset that I spent hours reading these things every day and never responding to anything. I heeded her advice and have started to become a more active member of the MGoCommunity. I was however told just recently that my user name and Avatar detract from what I actually say because everyone hears Hank Hill's voice narrating what I am saying.

I do admit that I am an addict and have a serious problem. I check the blog constantly.

"Yep"

February 24th, 2012 at 2:11 PM | I think (Score:2)
WolverBean
Joined: 06/30/2008
MGoPoints: 849

I think there are a lot of us who fall into this category. I've been here since '05, and refresh about 25 times a day, but I post maybe every other week? (Or more likely, six posts in three days, then a two month lull.)

February 24th, 2012 at 2:17 PM | Yeah I would say a good (Score:2)
HttV Wolverine
HttV Wolverine's picture
Joined: 08/02/2010
MGoPoints: 7360

Yeah I would say a good majority of my points came during the great MGoPoint posbang parties we used to have. Ah, the good times.

“What the mind can conceive, the mind can achieve and those who stay will be champions.” - Bo 

][V][

February 24th, 2012 at 1:50 PM | My unscientfic observation: I (Score:5 Normal)
thisisme08
thisisme08's picture
Joined: 12/02/2008
MGoPoints: 1458

My unscientfic observation: I know work gets in the way of my Mgoblog time frequently. 

Blue is Faster

February 24th, 2012 at 3:24 PM | That's a posbang, right (Score:3 Normal)
UMQuadz05
UMQuadz05's picture
Joined: 04/03/2009
MGoPoints: 1170

That's a posbang, right there.

Hail to the colors that float in the light-
Hurrah for the Yellow and Blue!

February 24th, 2012 at 1:51 PM | I've been here for almost a (Score:2 Normal)
Lionsfan
Lionsfan's picture
Joined: 06/03/2011
MGoPoints: 3893

I've been here for almost a year now, but my points have been inflated by the various open threads we've had for games. I'm sure there's quite a few like that too

If you're doing nothing, how do you know when you're finished?

StraightDave owes me a steak dinner

February 24th, 2012 at 1:52 PM | I'm going to need to sign an (Score:3 Normal)
This is Michigan
Joined: 08/02/2010
MGoPoints: 1218

I'm going to need to sign an IRB approved consent form before I agree to participate.



Kidding aside.



There was a poster that performed research within the past year on the same concepts for a class. Maybe try searching for his post. He used the same type of methods that Brian used for his Leaders and Legends poll.

February 24th, 2012 at 2:09 PM | Same here.  Been reading the (Score:2)
Pasadena_Blue
Pasadena_Blue's picture
Joined: 05/05/2011
MGoPoints: 90

Same here.  Been reading the blog for probably a year and a half or so, but really only post once and a while when something comes up that i feel i can actually add some decent commentary to.  I do check the blog pretty much once an hour every day, on the hour, for the entire 12-15 hour work day.

February 24th, 2012 at 3:38 PM | I definitely check it way (Score:2)
Joe
Joe's picture
Joined: 06/30/2008
MGoPoints: 185

I definitely check it way more than I should... I probably also post way more than I should - which isn't much anyways.  Much like this post right here, I rarely have anything significant to add.

February 24th, 2012 at 2:20 PM | I have been on since sometime (Score:3 Normal)
JakeinVeniceFL
Joined: 11/20/2009
MGoPoints: 337

I have been on since sometime in 2009.  Rarely post, read two or three times daily.  So your data is poo.

February 24th, 2012 at 2:47 PM | You and that (Score:2)
lbpeley
lbpeley's picture
Joined: 01/29/2009
MGoPoints: 1585

avatar need to post much, much more frequently.

February 24th, 2012 at 2:26 PM | Thanks for your feedback (Score:1)
beenplumb
beenplumb's picture
Joined: 10/15/2010
MGoPoints: 847

Thanks for your feedback everyone.

I think the direction I will take with this will be to calculate some type of 'contribution' metric. The word 'activity' is misleading for the reason that many of you pointed out - many people view the site but don't post.

Not sure how the posbang / point bumps will impact this yet.

@beenplumb

procsqlrunning.tumblr.com

February 24th, 2012 at 3:08 PM | It's going to be difficult to (Score:2)
DeuceInTheDeuce
DeuceInTheDeuce's picture
Joined: 10/29/2008
MGoPoints: 767

It's going to be difficult to quantify individual Mgoblog "activity".  If you are looking to gather posting frequency data, you could have users:

1. Head to their my MGoPoints activity page

2. Sort data by "operation"

3. Total up (or, more likely, estimate/calculate via beginning and ending page numbers) all the posts categorized as "insert"*

4. ???

5. Crash Server/Profit

As for quantifying other types of activity, yeah, no clue. Perhaps Brain could help you.

*My oldest MGoInsert date is 05/28/2010, so I'm guessing somewhere around there might need tol be "day zero" for your calculations.

February 24th, 2012 at 8:20 PM | Quick question (Score:2 Normal)
OMG Shirtless
OMG Shirtless's picture
Joined: 08/16/2009
MGoPoints: 1486

Is there a spot to list all the points I've been docked for comments that went a little too far over the line?

I put up a tough front, but deep down I just want to be held.

Theme provided by Roopletheme; sidebars adapted from Chris Murphy.