You Ask, I Answer: Year-End Social Media Reporting?

Warning: this content is older than 365 days. It may be out of date and no longer relevant.

You Ask, I Answer: Year-End Social Media Reporting?

Alessandra asks, “what is the best way to prepare a social media marketing report for 2018 to send to management? I keep track of followers and number of posts by month, but maybe there is other data I should include?”

Great question. Reporting should always tell a story, and the story most management wants to hear is, what’s in it for me? What is your management measured by? What is their management measured by? How far down the value chain can you do analysis? Watch the full video for what data to include, what data not to include, and what approach to take.

You Ask, I Answer: Year-End Social Media Reporting?

Can’t see anything? Watch it on YouTube here.

Listen to the audio here:

Download the MP3 audio here.

Machine-Generated Transcript

What follows is an AI-generated transcript. The transcript may contain errors and is not a substitute for watching the video.

In today’s episode, Alexandre asks, What is the best way to prepare a social media marketing report for 2018 to send a management? I keep track of followers a number of posts by month, but maybe some other data I should include. So good question. important question. The key thing to ask is this, there’s a whole bunch of questions to ask. But reporting of any kind of, especially in marketing recording should always tell a story. And the story that most management wants to hear is, what’s in it for me, what does this do for me, right? How does this help me tell my boss my story and give me the rays are not fire me or any of those things? So what is your management measured by what are their performance metrics and in your job, if you’re not just a social media manager, if you have more than one role, or more than one area of responsibility, what else are you measured by Are you also measured by like website traffic, or email traffic, or any

of these activities that that are part of your role,

all your reporting should always tie back to those KPIs to whatever it is that you are being measured by, and what your management is being measured by. So when you’re doing reporting, if, let’s say your management is measured solely by marketing, qualified leads, right, that’s, that’s their job is to generate marketing qualified leads for the sales team, well, then anything in your report that you send to them should tell the story of how the work you’re doing, and what you’ve done that has led to marketing qualified leads. So if, for example, when you pull all your data together, and you gather it, and you run an analysis on it, if you can show a strong causal or even correlative relationship between followers and marketing, qualified leads, or engagement and marketing qualified leads, then that data goes to the report, if you can’t prove a relationship between whatever metric you’re looking at, and marketing qualified leads, guess what doesn’t go in the report, because no one’s going to care about that. Now, you will have some cultural stuff to overcome, because a lot of people are used to having the truck backed up, and no data being poured on their desks. And that’s not something that you don’t you want to do. Because all that does is add clutter and obscures the story that you’re trying to tell of either, hey, we knocked it out of the park, let’s keep doing what we’re doing. Or hey, we didn’t get the numbers we wanted. We need more resources or a different strategy or something like that

in your report. The the rule of thumb is this for any kind of reporter dashboard, and this is Avinash Kaushik rule, the more the higher up in the food chain you go, the less data there is, and the more analysis insight and strategy there is. So, if you’re sending a social media report to the CEO, it’s very possible, you might have like one or two stats like hey, marketing, qualified contributed 32% of qualified leads to sales, that might be the only piece of data in your report. But you would then have analysis to explain to that person here’s what you need to know, to inform that number to tell the story of either the success or what you need to be successful,

avoid the temptation to throw in data just for data sake, throw in only the things that tell the story that you’re being measured on, your management is being measured on plus anything you were explicitly asked for. So I had this one customer. One time that cmo deeply cared about the number of Twitter followers they had, even though from an analytical perspective, that really didn’t matter, right, it didn’t contribute to their KPIs, but that was something that the brass was really, really interested in. So of course, you include that because it would be insubordinate to include the to refuse to include data that you weren’t explicitly asked for. But

make sure that you’re focusing on those things that lead to the outcomes that you’re being measured up. Now, if no one has ever set down KPIs for social media, this is an opportune time to define those. So you’ll have to do your own analysis. But whatever it is, that you’re you are being measured on. And whatever it is that your boss is being measured on, that sort of forms, the starting point for what your KPIs are, what are the things that if these numbers go the wrong way, you get fired, or your boss gets fired, your boss cares very deeply about those numbers. So whatever they are, that begins the formation of of KPIs. And then again, you do your mathematical analysis to figure out what other numbers have a relationship to that KPI, there are a number of statistical techniques to do that. It’s a technique machine learning called driver analysis. And it’s both statistical and machine learning, depending on the method you use, but that’s something that I strongly recommend that you use, and you do so that you can figure out okay, this is what is likely contributing to the KPI where’s there’s no relationship between these numbers and the KPI. And therefore, we probably shouldn’t invest a whole lot of time gathering the data about them, measuring them, and so on and so forth. Generally speaking, they’re probably going to be about half a dozen numbers that contribute to a KPI unless you have a really, really unusual social media configuration.

The other thing that you’ll want to do is with your analytics

for reporting about what you will have thing, you know, the various numbers the end the KPIs that that are there are relevant, like followers, or likes or engagement or whatever the numbers are that that lead to your KPIs, you will want to provide a little bit of qualitative data as well. So if you look back at the year that was

in the top performing X percent of content that you created, and that your competitors created, what did they have in common? What did you create that performed well, that led to marketing qualified leads,

what were the precursor numbers like was it engagement and likes that that lead to those marketing qualified leads, and then look at using those same publicly available measures like likes and engagement, do an apples to apples comparison to a competitor to say, here’s the things that our competitors performed well on. And we should use this to inform our strategy, look at things like topics and stuff, concepts, ideas, content, what worked for you what worked for competitors, Now, that may not necessarily go into your year and reporting that may be something that you keep for yourself to help guide your own strategy. But it may be something like a bullet point in the report. It’s but again, keep your reports simple, and keep them focused on the story that will help your boss get promoted, or at least not fire and that you have data for that you can get reliable data for but avoid the temptation just back up the truck and pour data on people’s desks. That doesn’t help anybody. It consumes a lot of your time because you have first do the report and then you have to explain to people what all that stuff means. And that never goes well. So great question reporting and year end and all that stuff is is important, but it’s also important to do it well. If you have additional questions, leave them in the comments and please subscribe to the YouTube channel and the newsletter and I’ll talk to you soon one help solving your company’s data analytics and digital marketing problems.

This is trust today and let us know how we can help you

Transcribed by

You might also enjoy:

Want to read more like this from Christopher Penn? Get updates here:

subscribe to my newsletter here

AI for Marketers Book
Take my Generative AI for Marketers course!

Analytics for Marketers Discussion Group
Join my Analytics for Marketers Slack Group!


Leave a Reply

Your email address will not be published. Required fields are marked *

Pin It on Pinterest

Share This