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.
By no means the finest infographic ever made, but hopefully not the worst one, either. Enjoy!
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.