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 your budget.

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 to prove your work is producing results.

The takeaways you’ll pick up from reading this post are:

  • How to quickly and easily compile a social media report. We’ll walk through every step of the process.
  • How to explain social media data to your client or team members. We’ll cover how to analyze your social media data
  • How to prove social media marketing is working for your business. We’ll show you how to show you’re making a difference.

Measuring and reporting on social media marketing doesn’t have to be hard. And in this post, we’ll prove it.

Keep It Simple And Download Our Social Media Report Templates

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 Build 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.

How to Create Effective Social Media Reports

Not Sure How Or Where To Gather Your Data?

Or, Use Social Profile Reports in CoSchedule

Did you know CoSchedule makes it easy to plan and publish social media content?

It’s true! Our all-in-one marketing calendar includes everything you need to manage your entire social media marketing workflow.

And with our new Social Profile Reports, you can effortlessly measure performance and produce eye-popping reports.

With Social Profile Reports, you can…

  • Access top social profile reports from one dashboard. Stop downloading reports from individual platforms (or multiple third-party tools). Quickly view important social KPIs for Facebook, Twitter, Instagram and Pinterest right inside CoSchedule.
  • Refine your social strategy with actionable insight. Track your social performance so you know what’s working (and what isn’t). Use real-time data to make updates to your social strategy, so you can continue to drive results.
  • Connect with your audience + create posts that stand out. Track engagement stats and stop guessing at what will (or will not) resonate with your followers. Utilize your social profile reports to identify top content AND start creating posts you know your audience will love.
  • Get social profile reports delivered right to your inbox with scheduled reports. Create and schedule easy-to-understand reports to your team + stakeholders on a weekly or monthly basis. Giving everyone a pulse on your Facebook, Twitter, Instagram and Pinterest performance.

Just log into your CoSchedule account and find Social Network Reports in your analytics pane:

CoSchedule Analytics Dashboard

Then, click into your selected network and get a detailed performance breakdown for each channel:

Example Twitter Report

Ready to deliver your full social media report to your boss? Hit up your Social Engagement Report and get a presentation-ready PDF report (or get the raw data in a .csv file):

Example Social Media Engagement Report
Best of all, you can try it free for 14 days. What are you waiting for?

Automate Reporting with CoSchedule. Start Your Free Trial.

Want to use Click to Tweet on your blog?

Now, 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.

Ready to automate your social reporting schedule? Start your free trial and see how CoSchedule can help.

Try CoSchedule Free for 14 Days

Want to use Click to Tweet on your blog?

This post was most recently updated on Dec. 13, 2017 for clarity and comprehensiveness.