The Best Social Media Report Template to Show Your Results

Social media analytics can hard to translate for clients or coworkers who have little knowledge about each channel. You need to be able to clearly explain what you and your team are doing to justify the budget you are receiving.

Building social media reports can help you do that. But you can’t just throw some numbers in a spreadsheet and call it good. Your report needs to be visual, comprehensive, and easy to skim, but also include enough information that any questions that arise are easily answered.

The takeaways that you’re going to gain after reading this post are:

  • How to quickly and easily compile a social media report.
  • How to explain social media data to your client or team members.
  • How to prove what your team is doing is working.

Social media reports don’t have to take forever to construct if you know what information you’re looking for. Knowing what your organization or clients need to see will make creating your reports that much easier, too.

Keep It Simple And Download Our Social Media Report Template

Make social media reporting easy with these three free templates. Download this bundle and you’ll get:

  • Weekly Social Media Report Template to keep your team and organization up-to-date week to week.
  • Quarterly Social Media Report Template to present your quarterly progress (when you’ll likely meet with execs, clients, and key stakeholders).
  • BONUS: Social Media Posting Schedule Template to plan out your posting frequency (which you can optimize over time as you see what’s working, and what isn’t, over time).

Snag your free templates first. Then, we’ll walk through how to use them (and start showing your success to your organization).

Want to use Click to Tweet on your blog?

Why Bother Building Social Media Reports?

Social media reports help you understand what is and isn’t working in your strategy. They also help you prove that your efforts are working, as well as provide transparency throughout the company as to what your team is doing.

Not Sure How Or Where To Gather Your Data?

Let’s Walk Through How To Use These Report Templates

The next part of this post will walk you through what each section of the report template means and how to explain the data to your team.

Social Channel Reach

Social channel reach data talks about how many people saw your post in their newsfeeds. They don’t have to interact with your post at all in their feeds; they just need to scroll past it.

Scrolls = Reach = Eyeballs

So why should you care about reach?

Reach can tell you how many eyes have seen your content, which in turn can help your team establish on average how many people see your content.

As you enter your data into the table, the graph below will adjust:

To enter your data:

  1. Gather all of the new reach totals for each of your channels.
  2. Record them in a separate spreadsheet to enter in later.
  3. Take last week’s reach for one channel and divide it by new reach.
  4. Subtract that number from 100 and that will be your new percent of change.
  5. Enter in the new reach total into your chart after the new percent of change has been recorded.

Social Channel Reach

Social Channel Shares

Social shares are a part of both your weekly report and quarterly report templates. Shares happen any time an audience member shares your content to their newsfeed.

Why should this matter to your team or client? Shares help show your team that your audience is finding value in your content. The more often you can provide that value to your audience, the more you create a relationship with them.

Social shares in your weekly report are only going to indicate changes over the past week:

Social Channel Shares

 

While your quarterly report will show the volume of shares over four consecutive quarters and will look like this in your report:

Social Channel Share Volume

 

It is important to note that Instagram will not show shares data because as of right now you cannot share other people’s Instagram, except through third party apps.

Before you continue, you may have noticed that the bottom of your graph has a legend that says Date Range at the bottom. You may notice that changing the labels in your chart does not modify the labels on the graph.

To update those labels, click on the chart and select, Select Data in the graph menu:

Select data in follower growth section

 

A window will appear, and you’ll be able to adjust your dates in the column marked Horizontal Axis:

Adjust formula dates

 

Once you click OK, your graph should update.

To fill out your quarterly chart, you can move the previous week’s data down a week to make room for new data. Both graphs should update automatically.

Social Channel Likes

Likes refer to the number of times that people have interacted with your content by “liking” it. But why would the number of likes on your content matter?

Much like when people share your content, liking your content means your audience made a connection with it. Likes allow you to make sure that your topics are on track with your audience preferences.

In your weekly report, your chart will look like this:

Social Channel Likes

 

In the quarterly report, your chart will look like this:

Social Channels: Quarterly Likes

Social Channel Comments

Social channel comments are another engagement metric that can help show your team and clients that what you’re publishing is connecting with your audience.

You can add this into your weekly report if you so choose, however for these templates we’ve only included it in the quarterly report, which looks like this:

Social Channel Comments

Social Channel Follower Growth

The next set of statistics you’ll learn how to record involves how many followers your social channels have gained.

Why would these statistics be relevant to your team? The more followers your social channels gain, the more eyes see your content. The more eyes that see your content, the higher probability you’ll have of creating conversions.

Plus if you’re gaining a following from fans in your industry or with people that are interested in your company, that means that your content is connecting with the right people.

Your follower growth per channel will look like this in your weekly report:

Social Channel Follower Growth

 

It’s important to note that your follower growth in the weekly reports tracks growth over the last four weeks.

The quarterly report follower growth chart will look like this:

Follower Growth: Quarterly Report

Top Posts Per Channel

The top posts per channel are a key statistic that you can record both weekly and quarterly in your report templates.

Why would tracking your top posts be an important part of the data that you show your teams or clients? Because top posts indicate what types of content are connecting with your audience. If you post videos once every few weeks and that video turns out as a top post every time one is sent, it could be an indicator that it’s the kind of content your audience is looking for.

In your weekly and quarterly reports, your top posts will look like this:

Top Posts Per Channel

 

Social Media Channel Summary

The next part of your report process is going to involve just your weekly report. The totals section is meant to help you track your growth of likes, followers and reach over the course of a month.

This small snapshot allows you to track spikes in growth giving your team a chance to analyze what happened over those four weeks to cause the rise.

In your weekly report, your total section looks like this:

Social Channel Posts Published

The number of social media posts that you have sent is going to be recorded in your quarterly report, not your weekly report. You could add in a section for this on your weekly report, however, if your company maintains a consistent posting schedule, it could get repetitive for your team.

Your messages data will look like this in your report:

Social Media Traffic

Social media traffic is divided into two different sections for your reports. The first section involves how often your social channels are causing your audience to click to your website.

Why is traffic important? Traffic drives people to your website, which in turn should create conversions. The more people you can drive to your website, the more likely you are to create a conversion.

Mo’ conversions, mo’ money.

In your weekly report, your traffic chart will look like this:

In your quarterly report, your traffic chart will look like this:

Traffic Breakdown

The second part of your traffic data is going to involve recording your highest trafficked content, once a quarter.

In your quarterly report, you’ll find a section for highest trafficked content. It will look a lot like your top content posts section with space allotted to insert screenshots of your post and record the amount of traffic that those posts generated:

Social Media Conversions

The second last step in your social media weekly report and the second to last step in your quarterly report will involve reporting your conversions.

Conversions are the number of times that your audience members follow through and complete an action that you wanted them to. Conversions can be anything from email sign-ups to buying a product.

In your weekly report, your conversion chart will look like this:

In your quarterly report, they’re going to look like this:

Social Media Clicks

The last step in your weekly report will involve tracking the number of clicks that your content has received on each channel.

Aren’t clicks and traffic the same thing?

Not exactly, clicks can refer people to places outside your website, especially if you’re posting curated content.

Tracking your clicks in your weekly report is going to look like this:

Top Landing Pages

The last step in your quarterly report is going to involve tracking the top three landing pages for each social media channel that you are active on.

Tracking your landing pages can show where your audience is ending up the most often on your website. If it’s where you need them to go, great! If not it may be time to rethink where their initial landing point on your website is.

Your top landing pages are going to look like this in your report:

Top Landing Pages Per Channel

Social Analysis

Okay, so we’re not quite done yet! The *actual* last part of your report is going to involve writing summary notes or details that aren’t explained in the report. This section can be whatever you need it to be in to explain the data to your team:

Social Media Analysis Section

Wanna Know How We Can Make That Process Even Easier?

CoSchedule has its own social media analytics functionality and exportable Social Engagement Reports that make all this work even easier to complete.

 

Talk about a time saver.

Schedule a demo with CoSchedule and see how we can make all your social media report dreams come true.

Want to use Click to Tweet on your blog?