How to Create a Social Media Report and Explain It to Your Boss or Client

Mar 9, 2023

Kevan Lee Former VP of Marketing @ Buffer

Summary

10 min read

You will learn

You’re rocking social media.

You’re finding great content to share, you’re writing the best headlines, you’re engaging and automating, and seeing your brand soar.

How will you let your boss or client know all the great stuff you’re up to?

Is there an easy way to see for yourself how things are going?

Creating a social media report can be vital to explaining your progress on social media. You can choose the stats that matter and deliver them in an easy-to-understand way to your boss or client.

We’re grateful for the example of so many Buffer users who are already creating social media reports of their own to share with a boss or client. I’d love to share a bit about how these reports come together—and how you can make one for yourself.

Before we get into the details of the social media report, I thought it might be helpful to review the many different factors—metrics (and reasons for the metrics), timeframes, growth—that might go into a report.

In asking around with our awesome Buffer users, we found that social media reports can differ from person to person and brand to brand in several ways.

Which stats matter to you?

A social media report is simply a collection of data and stats.

Which data and stats should be on there? And why?

The answer likely depends on your specific social media KPIs (key performance indicators) and goals.

Followers tell you the number of people who wish to connect with your brand. The benefits of followers are for the reach of your content, the social proof of your brand’s popularity, and in some cases, a simple vanity metric to boost your confidence.
Clicks tell you that the content you’re sharing is of personal interest to the user. Clicks send traffic to a URL and establish your social profile as a great resource for curated content.
Retweets or Reposts or Sharing tell you that the content you’re sharing is perceived as potentially interesting to one’s followers. The benefits of these engagement tactics is for advanced exposure to people who aren’t your followers and social proof that you know what you’re doing on social media.
Likes are somewhat of a wild card. The benefit of favorites is as a social proof metric. Beyond that, it’s a bit hard to tell what people are thinking when they favorite because there are so many different strategies and reasons (curation, appreciation, bookmarking, etc.). On some channels, favorites/likes may surface the content higher into the News Feed.

Which timeframe is most valuable to you?

Here’re the timelines that have come up most often in our discussions:

Weekly
Monthly
Quarterly
From campaign start to end

(Note: For monthly reports, some use a 28-day period so that it’s consistent across all months, since the months may vary in length. Also, for quarterly reports, often a 90-day period is used, as you can fit four 90-day periods into a year.)

How do you want to track your progress and growth?

Also, there can be some differences in the way you view progress. For instance, are you most interested in seeing where you are today, or how you’ve grown from a previous point in time?

Here’re some of the different ways we’ve found to look at reports in this case:

Snapshot – A look at the numbers for a chosen period, with no previous history considered
Week over week, period over period – A comparison of stats for a chosen period with stats for the previous period, or even from the previous year

If you’re interested in digging further, we’ve written about goal-setting for social media, as well as some popular goal-setting strategies.

We understand that it is not easy to create great-looking social media reports. That’s why we built analytics into Buffer to simplify the process. You can create a professional report for your team, clients, and boss in as few as two clicks.

Our analytics currently support Facebook, Instagram, Twitter and LinkedIn. Here are the data you can include in your reports:

Overall + average performance
Metrics breakdown charts
Top and recent posts
Instagram Stories metrics
Audience insights

To come up with some of the report ideas listed here, we asked some of Buffer’s users what they do with their social media data.

Many of the reports you’ll read about can be made using Buffer Analyze. Also, you can create these reports with exports from Twitter Analytics and Facebook Insights.

1. Follower growth

“We’re gaining 1,000 new followers every week!”

When your boss or client looks at followers, they could draw lots of conclusions: popularity, reach, brand awareness, etc. And each one is valid. People follow social media profiles for a variety of reasons, some to receive the content from that profile, some to show their affiliation for the brand.

As you grow the followers on your social media profile, your influence gets a little wider, both in the number of people you will potentially reach and in the perceptions others have of you. A growth report is a great way to capture these two ideas.

How to create the report:

If you’re working from the dashboard of your social media analytics tool (say, Buffer Analyze, you can easily grab the follower growth numbers there.

Select a profile
Set your desired date range
Under “Metrics breakdown”, select “New Followers”

(I’ve found that follower growth is often best kept as a whole number, i.e. “I gained 35 new followers this week” as opposed to “My followers grew 0.3% this week.” The whole numbers seem a bit easier to compare.)

2. Influencer report

“Wow! Check this out! Taye Diggs is following us!”

Sometimes, it’s just really cool to know that someone big or influential is following you. In the long run, it’s likely a vanity metric, yet it’s still a fun occasion to celebrate—and perhaps to share with your boss or client.

The practical value of having influencers among your followers is that any social media update of yours has the chance to take off big time. And influencers among your tribe is great social proof for others to see that you’re being taken seriously by big-time users.

How to create the report:

To identify Twitter influencers, Followerwonk and SocialRank are a couple of the handful of tools that can help identify influential followers.

Sign up at either of these websites, connect your accounts (Followerwonk focuses on Twitter, and SocialRank does Twitter and—coming soon—Instagram), locate the followers with the largest followings, and add it all to your report.

3. Volume of posts

“Here’s what we’ve been up to for the past month. 110 posts!”

I was really interested to learn that one of the key reports that people run is a simple counting of the number of times they’ve shared to a social network.

In Buffer Analyze, you can see the number of posts under the Metrics breakdown chart. You can compare it with previous periods to see how the volume has changed over time. (You can also compare this with another metric and see how volume affects other metrics like engagement and follower growth, too.)

How to find the report:

Select your profile
Under Metrics breakdown, select Posts

4. Reach Rate

“Lookit! Our posts are seen by 10 percent of our fans.”

One of the Buffer users who shared some reporting insights with us had a great description for their process. Their team looks for reach and resonance.

Reach is the number of people who might see a post.

Resonance is the number of interactions with the content.

How to create the report:

Buffer Analyze tracks reach for Instagram, Facebook, and Twitter.

Get the reach/impressions per post by totaling up reach and dividing by the number of posts.

Reach per post (divided by) total followers = % of followers who see your content

5. Total engagement

“Does our stuff resonate with people? You betcha! 425 total interactions this month.”

Total engagement can mean different things to different people. In general, engagement is the sum of likes, comments, clicks, and reshares—basically every interaction one can take on a social media update.

What this information tells you is the overall effectiveness of your post. Did people like what you shared? If so, engagement will be high, regardless of whether the interaction was mostly due to one metric over the others. Engagement is the catchall for social media success. Good engagement = good sharing.

How to create the report:

Export the data from Buffer Analyze, Twitter, or Facebook.
In some cases, engagement may already be added together for you. If not, add up the total interactions in the columns for clicks, reshares, likes, and comments.
Done!

6. Engagement per post

“Every time we post, we can expect to get 25 interactions!”

The next step from the total engagement figure above is engagement per post. Instead of looking at total engagement for a certain period (which can fluctuate based on how many times you post), you can drill down into engagement per post, which shows a somewhat clearer picture of exactly how engaged people are with your content.

How to create the report:

Divide total engagement by the number of posts.

7. Clicks

“Our social media posts have sent 350 visits back to our website this week!”

We’ve been using clicks as a key part of our goals and strategy for several months (if not years) here at Buffer. Clicks are the most direct metric that you can tie back to your website. When someone clicks, a couple of great things happened: 1) you wrote a great headline or created an awesome visual, and 2) that person is now checking out your site, signing up for email lists, reading more articles, advancing into the marketing funnel.

How to create the report:

Export the data from Buffer Analyze, Twitter, or Facebook.

If you’re interested in total clicks, add up the clicks from each post in your date range.

If you’re interested in clicks per post (a favorite metric of ours), divide the total clicks by the number of posts.

If you’re interested in clicks per followers, take the clicks per post number and divide by total followers.

“Look at how many visitors to our site have come through social media!”

Clicks are a great way to measure the success of your individual posts. Social referral traffic is a great way to show how successful a social network as a whole is for driving people to your website.

With social referral traffic, you see how many visits each social network sent to your site. This would include any links that you shared personally as well as any links that were shared by others on social media. When seen side-by-side with organic traffic, referral traffic, and direct traffic, it does a great job of putting the impact of social media into perspective.

How to create the report:

In Google Analytics, go to All Traffic > Channels.

This report will show the percentage of traffic that comes from social, alongside traffic from search, direct, referral (other websites), email, and other.

To see the individual breakdown of traffic by social network, go to Acquisition > Social > Network Referrals.

This report will show you how much traffic has come from each website.

9. Funnel stuff

“See these sales? How cool that these people started their buying journey on social media!”

For advanced users, funnel reports show not only the clicks and referral traffic back to your site but also where that traffic ends up going and what they end up doing. Does your social media traffic convert into leads? Into subscribers? Into sales? The funnel reports take into account the whole visitor journey, from tweet to visit to action.

How to create the report:

There are lots of ways to go about funnels. There are some helpful tutorials from KISSMetrics and Social Media Examiner that do a good job of going really in-depth on the topic.

One quick way I’ve found to set up some simple funnels tracking is to use Google Analytics Goals.

After logging in to Google Analytics, click the Admin link at the top of the page.
Select your website from the drop-down list at the left, and in the right column of the page, click on Goals.
Click the “+New Goal” button.
Give the new goal a name, choose the type of goal you want to create, and set the goal details so that Google Analytics knows when a goal is reached

Once this is all set up, you can view the analytics data for this goal—including the amount that social media contributes to goal conversions—by clicking on Conversions > Goals in your Google Analytics dashboard.

Takeaways

Creating an effective social media report is crucial for measuring the success of your marketing efforts, identifying improvement areas, and demonstrating value to clients or stakeholders.

In summary, here's everything that should be considered as you create your first or next social media report:

Set clear goals and objectives: Define the purpose of your social media report by outlining specific goals and objectives, such as increasing engagement, driving website traffic, or building brand awareness. This will help you focus on the relevant metrics and create a more actionable report.
Choose relevant KPIs: Select key performance indicators (KPIs) that align with your goals and objectives, including metrics like reach, engagement, conversions, and ROI. These KPIs will enable you to measure your success and track progress over time.
Collect data from multiple sources: Utilize various social media platforms, analytics tools, and internal data sources to gather comprehensive and accurate information for your report. This will provide a holistic view of your performance and facilitate better decision-making.
Visualize data for easy consumption: Present your data using charts, graphs, and infographics to make it easily understandable for your audience. Visual representations can effectively convey complex information and highlight trends, patterns, or outliers.
Include insights and recommendations: Analyze your data to identify insights, trends, and areas for improvement. Provide actionable recommendations based on your findings to help optimize your social media strategy and achieve better results.

Connect your social media accounts in Buffer and start generating reports today!