• warning: Creating default object from empty value in /home/sigpboo7/public_html/modules/taxonomy/ on line 34.
  • strict warning: Non-static method view::load() should not be called statically in /home/sigpboo7/public_html/modules/views/views.module on line 842.
  • strict warning: Declaration of views_handler_field_comment::init() should be compatible with views_handler_field::init(&$view, $options) in /home/sigpboo7/public_html/modules/views/modules/comment/ on line 50.
  • strict warning: Declaration of views_plugin_row::options_validate() should be compatible with views_plugin::options_validate(&$form, &$form_state) in /home/sigpboo7/public_html/modules/views/plugins/ on line 135.
  • strict warning: Declaration of views_plugin_row::options_submit() should be compatible with views_plugin::options_submit(&$form, &$form_state) in /home/sigpboo7/public_html/modules/views/plugins/ on line 135.

A Year of Mashable - 2012

At work I finally got around to doing a project I’ve been wanting to do for a long time: analyze the sharing behavior of a year’s worth of content at Mashable.

It’s no small project. First, a year’s worth of Mashable content must be collected, which ended up being 13,979 articles in total. Next, the author, publish date, headline, and full text of each post must be extracted from each page, which requires a (fortunately simple) custom scraper to be built. Next, the social resonance data of each article must be collected. For this analysis, I collected share counts for Twitter, Facebook, StumbleUpon, LinkedIn, Google+, and Pinterest, plus clicks from Bitly and per-article submissions from Reddit. Once all that data has been collected and structured, it must be analyzed. I found good ol’ Excel pivot tables to be perfect for most of the analysis. Tracking mentions of key topics from the past year, like Gangnam Style, requires the ability to do full-text searches against headlines and article content, so I indexed all of the data from above into ElasticSearch. It performed brilliantly.

I ended up making an infographic out of the data, and I posted it to the corporate blog of the company I work for. I’m proud of it, so I’m posting it here too.

By no means the finest infographic ever made, but hopefully not the worst one, either. Enjoy!

The Evolution of an Analytics Team

WCG recently turned 10 years old, and it’s gone through incredible changes over that time. And even though I’ve only been with WCG since August 2010, in those 18 months I’ve seen my little part of the business, the Analytics team, turn completely upside down. It’s moved 3 times, seen both clients and colleagues come and go, seen weddings, and welcomed children into the world. And I’ve got to say, we’ve got some pretty great digs now:

Go Ahead, Pardner.

As it’s grown from a small handful of incredibly talented people to a team of almost 40, the work has changed, too. Looking back, we’ve come through two, and we’re just starting a third.