an aerial view of laptop, documents with charts and cup of coffee. A man is pointing to some data on the chart

How To Create a Social Media Report

Marta

Content Manager @ Brand24. An avid reader and amateur baker. Passionate about mountains, travelling and indie music.

Social media channels are an essential part of your marketing strategy. You can attract new followers, convert leads, build brand awareness, provide customer service… The list goes on and on. With all the benefits of social media come some disadvantages as well. One of them is social media reporting. How exactly should you report the results of your social media campaigns to your senior management? Social media KPI’s don’t translate into language that people easily comprehend. Moreover, many managers are tempted by vanity metrics, like followers count, that don’t offer meaningful insights into your social media strategy. A social media report will make your efforts comprehensible to your stakeholders and will help you focus on your goals, results, obstacles and wins.

an aerial view of a piece of a social media report with graphs and a man pointing at one of the metrics

What Is a Social Media Report

There are probably plenty fo websites on the internet that will tell you precisely which metrics to include in your social media report. Followers count, social media reach, the number of interactions, likes and comments are not universal metrics and might not be useful in your case.

The truth is, there is no one-size-fits-all solution. Your social media report will answer the questions you pose. Every social media report will be different depending on the questions asked and the methodology used.

We can, however, distinguish three categories of social media reports:

  1. A regular social media report. It will contain the primary social media KPI, for example, engagement metrics, followers count or social media reach. It will demonstrate your latest progress;
  2. A report after completing a particular social media campaign. It will help determine the success of a product launch, event or marketing campaign. The impact of marketing campaigns are correlated with a company’s growth;
  3. A piece of research. You take a more in-depth look at all conversations around a specific brand, product or event. Research social media report aims to uncover insights about a particular topic.

Why Do You Need a Social Media Report

If you work in social media, you probably have problems with explaining what exactly is that you do at work. A social media report won’t help you explain your social media job to your grandmother, but will help with demonstrating the results of your latest social media marketing campaign to your boss.

A woman sitting in front of a laptop with analytics tabs open

Even if senior management understands the importance of social media, they don’t have to be savvy when it comes to grasping all different social media metrics. It’s your job to present them with a value that comes from social media activities.

A social media report is also a helpful tool for every social media manager, sales department, and even IT folks. A social media analytics report will:

  • determine the ROI of social media campaigns;
  • determine the growth or decline of social media channels;
  • identify successes and failures, so you know what to improve, tweak or delete;
  • present a general sentiment around a brand;
  • help identify the most valued new features to develop according to your audience.

Choose the Right Social Media Reporting Tool

Almost every social media channel provide some sort of free social media analytics tool, like Instagram Analytics or Facebook Insights.

Although the metrics might be enough for a beginner social media manager, if you want to justify your social media budget to your management, a free app won’t suffice.

For a more thorough knowledge, you will need a tool that offers more in-depth metrics, like Brand24.

Start with creating a project. In the project creation wizard, add the keywords you would like to monitor, such as the name of your company, the name of a specific product or a branded hashtag.

project creation wizard in Brand24 with predefined keywords

Brand24 will start to gather all the mentions with your predefined keywords from the internet.

Because you’re most interested in social media reporting, the vital pieces of information are in the Summary and Analysis tab. Let’s take a deeper look and discover what gems hide inside!

The Summary tab gives you precise information about the changes in various social media metrics:

  • number of results;
  • social media reach;
  • social media interactions;
  • the number of positive and negative mentions.

You can define the period you’re interested in yourself.

Brand24 Summary tab with data from social media needed to created a social media report

Moreover, you’ll find information about the most popular mentions, the most influential profiles, and the most active locations.

The Analysis tab provides more detailed information about the sources of social media interactions. Thanks to filters, you will be able to assess the number of likes, mentions, comments, and shares from particular social media platforms.

Brand24 Analysis dashboard with the most influential social media authors listed and social media metrics like interactions or reach needed to create a social media report

You will also be able to see the most influential social media authors and their voice share. A voice share metric is a number that indicates what part of a conversation was created by a specific author.

Brand24 Analysis dashbaord with the most influential authors listed

All the mentions will be categorised according to the social media platform. That way, you can easily identify the platform where your followers and potential customers are the most active. You’ll find the filter menu in the upper right corner.

Brand24 offers a 14-day free trial, no credit card required!

What Should a Social Media Report Include

As I mentioned before, there’s no one magical template for your social media report. Thankfully, some common guidelines will help you with creating a social media report tailored to your needs.

Like any other type of report though, preparation for social media report should start with doing thorough research.

Identify stakeholders

Who is going to read the report? Senior management, marketing and sales department, customer support or everyone in the company? Different teams require different metrics. Some of the teams prefer a more detailed analysis, while senior management would probably like to read something short and to the point.

Ask the right questions

The more specific questions you ask, the better the insights you get. That’s why it’s so important to define your queries right at the beginning of social media report.

a question mark drawn with a chalk on a blackboard

I was taught the SMART technique during my Bachelor studies, and I’ve been using it ever since. An example of a SMART question is:

Did our Twitter marketing campaign drive engagement rates by 15%?

Let’s analyse!

  • Specific – the question clearly defines the channel (Twitter)  and the metric to measure (conversion rate);
  • Measurable – with little help from Brand24 you can measure conversion rate;
  • Achievable – with a social media strategy in place you can increase your social media engagement rates and boost brand awareness;
  • Relevant – the goal will help to increase your customer base, so it’s extremely relevant;
  • Time-bound – social media marketing campaigns are usually time-bound. I’ll elaborate on this in the next point.

Research questions

An example of a research question would be:

What do men in their 30s look for in a sports brand?

You probably wonder how to gather information about this topic. The question is pretty broad and requires a lot of work to answer.

There are a lot of answers to the problem, but one of them is social media monitoring.

Once again, set up a project in Brand24, but this time include keywords that focus on sports brands and healthcare. You can monitor phrases such as the names of sports disciplines, athletes brands, or sports venues.

Take a look in Mentions tab. The tool collected all the mentions with your predefined keywords. When you browse the results, you might identify some commonalities among users interactions.

Establish a timeframe

The time frame will depend on the type of report you’re preparing.

A weekly, monthly or quarterly report will cover, well… one week, one month or one quarter, that’s self-explanatory.

Then there’s a social media report that covers the duration of a whole marketing campaign. Remember to include benchmarks from before the campaign started, so you can clearly see the results.

an aerial view of a wooden desk with calendar, alarm clock and documents on it

The broadest social media report is the research report. You can freely determine the timeframes here. It’s a good idea to have a broad time range, for example, a whole year. That way no event, like Christmas or Black Friday, will skew the data.

You may also consider a daily report. It will help you react fast to any emerging social media crisis. An issue can become a crisis in a blink of an eye. Brand24 will collect all the mentions in real-time and deliver them to your smartphone (with our mobile app) mailbox or a dedicated Slack channel.

Writing a Social Media Report

After you gather all the intel, it’s time to write down a report.

Social media marketing is all about telling a story. The same principle holds for your social media report. You’re still telling a story, you’re just using graphs and charts to make it more compelling.

Specify methodology and background

That sounds incredibly scientifical and boring but it’s a vital part of your social media report.

The background section will determine which metrics your report is trying to measure, why you are focusing on this specific campaign or period, and include campaign details.

The methodology will include the language, timeframe, social media platform or any other relevant detail.

Be direct

A Russian playwriter, Anton Chekhov, famously said:

If in the first act you have hung a pistol on the wall, then in the following one it should be fired. Otherwise, don’t put it there.

In your social media report, the pistol should fire right away. Your boss and coworkers don’t have time to skim through a 70-page report, that’s why it’s important to grab their attention right in the beginning.

Put your key findings right after methodology, so even if your reader reads two pages of your report they immediately get the most valuable insights.

Display the data

I’m a visual person so I enjoy having graphs and charts in my reports. It just makes life so much easier. You should still explain the charts and diagrams.

An aerial view of a table with a piece of paper with graphs and charts and a laptop on it

Context is important. Your boss might see a few negative comments and panic. In reality, the negative mentions might just be a small percentage of the conversation.

Personalize the report

A social media monitoring tool will give access to quotes and profiles of social media accounts. Take a look at the Quotes tab. You will find quotes from the most influential authors, together with the names of the social media channels they come from and profile pictures.

A Quotes tab from Brand24 displaying different quotes from social media users that can be used to personalize social media report

Social Media Report and Storytelling

Your social media report should tell a story about your customers. How do they interact with your social media profiles? What do they expect from your company in terms of service and product development? The deeper you dig, the more information you uncover and, ultimately, your product will be more useful for your customers.