Social Media Report Template: How to Show Your Results - CoSchedule

We can show you how to organize all your marketing in one place by the end of today (probably right now) đź‘‹

The Best Social Media Report Template to Show Your Results 76

By

Headline Analyzer

The free blog post headline analyzer will score your overall headline quality and rate its ability to result in social shares, increased traffic, and SEO value.

Test every headline before you publish. Try the free Headline Analyzer »

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

Get Your Free Social Media Report Template Bundle

Get Your Free Social Media Report Template Bundle

Success! Your download should start shortly.

Tired of the marketing mess?

Get Rid Of Makeshift Marketing With CoSchedule

Awesome news! You're invited to a 1-on-1 marketing demo of CoSchedule! In 30 mins or less, you can see how to:

  • End the frustration of missed deadlines.
  • Get total visibility into ALL of your marketing in one place.
  • Save 20 hrs this week alone (and every week after).

If you've ever kicked the tires on CoSchedule, now's the time to see what it's really like.

Success!

We’ll be in touch shortly. In the meantime, get started with a FREE 14-day trial!

Tired of the marketing mess?


Enter your full name


Use your work
email address


Enter your company
name


Enter your website URL

Tell us a little about yourself…







By signing up, you agree to receive email updates from CoSchedule and you can opt out at any time.








Success! Your download should start shortly.

Clean up the chaos with your CoSchedule editorial calendar!

Get Rid Of Makeshift Marketing With CoSchedule

With CoSchedule, you'll:

  • Save time with blogging, social, and email (think HOURS every week)
  • Schedule your social posts in batches (and increase your posting frequency) super easily
  • Get your sh*t together (and hold yourself accountable to publishing like the boss you are!)

Now’s the perfect time to start your 14-day free trial to see for yourself!


Enter your full name & create
an account in 3 min or less!


Use your work
email address


Password must be
8 characters long.


Enter your company
name.


Enter your website URL.

Tell us a little about yourself...







Choose the right plan for you:

Essential

For bloggers
and solopreneurs

Starting At

$40/mo

1 User

Growth

For start-ups
and agencies

Starting At

$60/mo

3 Users

Professional

For professional
marketers

Starting At

$300/mo

5 Users

Enterprise

For established
marketing teams

Starting At

$1,200/mo

10 Users

Gain control over your entire marketing process with CoSchedule

Talk To An Expert

By signing up for CoSchedule, you agree to our terms of service, end user agreement and privacy policy.












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 CoSchedule's Complete Social Analytics Suite

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 and improved Social Analytics Suite, you can effortlessly measure social performance and produce eye-popping reports.

Social Engagement Reports

With Social Engagement Reports, you can get a high-level overview of your social media marketing's engagement performance. 

With this report, your marketing team can:

  • Gain actionable insights into what's working and what isn't for your social profiles. 
  • See past baseline metrics so you can determine if your efforts are improving your engagement.
  • Filter through data to find the metrics you need in a snap.

Social Profile 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:

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

Social Campaign Reports

But wait, there's more.

Our new Social Campaign Report lets you create social media reports for each social media campaign you create. The best part? This report will pull data from any social media campaign you create in CoSchedule.

With this report, you'll be able to:

  • Get actionable data on every social campaign. Gone are the days of manually gathering data for every social media campaign you published. 
  • Compare social campaigns to one another. Want to compare a current campaign to the one you did last year? Now you can. (And you get to avoid scrolling through hundreds of posts manually!)
  • Filter campaigns by content type. Need to see how your blog post campaigns are doing? Filter them all out automatically.

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 Your Free 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 Feb. 21, 2017 for clarity and comprehensiveness.

Don't forget your FREE Social Media Report Template Bundle

Download Now

Success! Your download should start shortly.

"CoSchedule has allowed us to plan and stay ahead 8-12 weeks. It's the best thing we've done to get ahead of ourselves; especially with so many last minute projects popping up."

Lee Hersh, Founder of Fit Foodie Finds
Fit Foodie Finds Logo