This is a cross-post from Ranieri Communications…
Actual output from one of my dashboards
Have you seen Particle Fever yet? If not, you should. There’s a seminal moment when, on achieving collision, a Cern star states triumphantly: “We have data.” It’s the point at which the theorists craned their necks eager to see what the experimentalists could actually prove. Suddenly, this wasn’t theory any more.
If you’re in any way serious about your social media, you need to make sure you have data. Without data you don’t know what the current situation is, so you can’t measure where you’re heading, so you don’t know whether or not you’ve been successful. You need data to know whether your strategy is working.
What data exactly? Well, that depends on what you want to achieve. Say you want to use social media to improve your SEO. What makes you think you have a problem with SEO in the first place? What needs fixing? Better find out first, because that’s how you’re going to measure success. Or perhaps you want something more qualitative around reputation management. How are you going to quantify this? Where are you going to get the data from?
There are three approaches to getting data depending on how much time, expertise or cash you’ve got: manual, semi-automated, and fully automated. Here’s a quick rundown of each.
Manual: get typing
Everyone loves a spreadsheet. They’re amazing things and you can go a very long way by manually entering data that is publicly available and then drawing insights from it. The key here is to use data that you can compare like-for-like across social media channels to get an idea of how they’re doing. So, while Facebook’s dashboard for example is rich in data, and you should certainly be using it to improve your performance, a lot of the analysis isn’t available for other channels such as Twitter, or Instagram, or your blog.
At the very basic level, you can look at two essential metrics that work across all of social media: audience size and engagement. The audience size is the total potential audience you could reach with your message, so that’s fans of your Facebook page, followers of your Twitter feed and so on. Engagement is when people actually do something in response to reading about you, so they retweet you or they comment on your Facebook page.
Do this for your competitors too, build this up over time and you can start seeing patterns in the data. You’ll see spikes that correspond to activity, and how to develop more advanced metrics off the back of these. How about dividing engagement by reach to get insight into how engaged your audience really is? How about adding frequency so you can start forming an idea of tweet quality? How about requesting access to the client’s Google Analytics and looking at how social media referrals to the website are behaving? Develop your own charts, stamp them with your logo, and you’ve got a bespoke measurement system. Port this to an online resource such as Google Docs, and you’ve got an online dashboard. Nice.
Semi-automated: learn APIs
If you’ve got an in-house geek (the one you keep in the cage in the corner and occasionally feed with Haribo) then they might like this: you can start getting involved with Application Programming Interfaces (APIs).
An API grabs the data directly rather than going through the manual procedures. So, by using the Twitter API you could directly interrogate the Twitter database and get follower figures, retweets, times of tweets and so on delivered direct to your machine rather than having to input it manually. You can also use the APIs of other social search engines such as SocialMention and Social Searcher that do a lot of the grunt work for you, by searching across multiple social media sources and aggregating them.
So, by downloading the results of API calls, you build up a store of data that you can then aggregate and analyse, again in Excel. With a canny combination of download managers, batch files and macros, you can do this all with just a couple of keystrokes.
The difference here is in quantity and types of data and therefore insight: you can accrue literally thousands of data points detailing who said what, and when, and you can start understanding who your influencers are, and what your issues might be – plus those of the competition and therefore the industry at large. At this point you really do start understanding the landscape.
If you have a smattering of statistical knowledge you can also start charting the ebb and flow of debate. Moving averages show the underlying trends. Crossovers of moving averages are highly significant. And so on.
Fully automated: bring in the Big Guns
If fully manual requires investment in time and semi automated needs investment in expertise, then fully automated is the money play. Here, we’re talking systems such as BrandWatch with millions of sites categorised, crunching huge amounts of data using dedicated server farms. It’s the rocket science approach and while this is mostly the domain of large companies that provide consumer services such as telecoms companies, there’s also a strong argument to be made that smaller agencies can use them profitably by sharing the cost across several accounts.
Hands, APIs, BFGs: Which one’s right for you?
If you’re not storing and analysing any data currently, then you need to start, right now.
At the very least start recording reach and engagement, ideally alongside competitors. It’s a useful exercise as of itself because you really start to understand cause and effect, and get to grips with the concepts.
When you get the hang of that, and you’d like to dive deeper, see if you have a geek in your organisation, or a latent geek, or know someone who keeps one. They might be able to ramp you up to the semi-automated solution and then you become something of a social media data guru.
And when you’re finally seeing the shiny green numbers coursing through the very fabric of the Matrix itself, and you’ve landed that major social media account – or you’re a postdoc working at Cern – it’s time to hoover up as much data as you can possibly get your hands on. Even if you don’t uncover the secrets of life, the universe and everything, you’ll know what drives conversation, and that’s a decent second.