Using Excel to summarise your Twitter Analytics data better.

Twitter Analytics with Excel

This is the first of what I’m planning will be a series of screencasts looking at Social Media data and analytics.

I hope it’s going to be a useful experience for me; but more to the point, useful for you. So I hope you’ll bear with me and give me feedback — either in the comments below, or on Twitter — where I’m @mediaczar.

For this first video, I thought I’d take a look at Twitter’s analytics product. Twitter opened this up to the general public last month — but some of us have had much longer to play around with it and get used to it. I thought it might be good to share some of what I’ve learned.



I’ve decided to share some of the tools I use to do my work. Partly in the hope that someone may find them useful; partly in the hope that having other people use the tools will help improve them. The first one I’ve posted is one of a set of link shortener tools, called bitlyquery […]

Is Facebook Failing Marketers?


Last October, Forrester’s Nate Elliott wrote an inflammatory blog post in the form of an open letter to Mark Zuckerberg. Open letters have been in vogue since Jay-Z released a track of the same name last April but I’m pretty sure (given the timing) that Mr Elliott’s post was more inspired by SinĂ©ad O’Connor’s notorious […]

Pay more attention to your LinkedIn campaigns

LinkedIn Comment Hijack

When planning LinkedIn campaigns, do make sure that you allocate resources to moderate LinkedIn promoted posts; we all do it in the line of business for Facebook, and even for Twitter. LinkedIn is a valuable platform, but too often treated as an after thought by social media planners; if we’re going to commit budget, we need to do it better than Salesforce.

The relative sizes of the social media platforms

Social Media Audience

For most of the world (China and Russia excluded), Facebook should be seen as having the same role in our marketing communications planning as Google. Together, Facebook and Google are the twin engines that drive discovery for the average web user. Everything else is fresh and interesting, but sometimes we have to prioritise.