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.

Bitlyquery

bitlyquery

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 […]

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.

Getting a (temporary) access token to query Facebook’s Page Insights

Enter the query, /me/accounts and click Submit

All the pages for which you have permissions should appear in the results field.

Copy the access_token and id for the page you want to query (the id is the long number)

I’ve been playing around trying to get Page Insights data directly from the Graph API (usually we just export and process the data from the Insights dashboard.) Thanks to an excellent article by Facebook’s Paul Carduner on Authenticating with Facebook on the command line, I’ve found a way to do it; but if you just […]

Social media is powered by cat ladies

kohls-facebook.png

I’ve been in training with Altimeter Group’s Charlene Li and Ed Terpening for the last couple of days. One of the case studies that came up in passing was the US department store chain Kohl’s Facebook Page (more than 9 million likes at time of writing.) Here’s a quick flow map of the last 2.5k […]

Lil Wayne and the Facebook breast cancer meme.

Another chapter in the “like if you hate cancer” story. Interestingly, user posts on Lil Wayne’s Page don’t seem to be visible to other fans; so did the initial impetus for this post come from Lilquan’s own social graph? There’s a Facebook property, page_fan that I’ve been looking at in the hope that I can […]

How photos spread virally through Facebook

Three videos on Facebook Stories from Stamen Design visualise how photos posted by George Takei were shared and re-shared over time. Stamen’s work is always wonderful — this is remarkable. There’s no rubric, but I’m assuming that this is a form of network graph — where each node may itself become the source of new […]