How do you know what’s working with your social media? And what’s not working?

The social networks provide us with a ton of data about our posts but it can be hard to distinguish the signals from the noise.

Imagine having a framework to pull out the signals from the noise — a framework that points you to the key information about your social media performance. With this framework, you can easily identify successful posts and understand why they did well.

The key is social media analytics and reporting! 🔑

In this post, you’ll learn how to analyze, evaluate, and use your social media data to boost and report your social media marketing results — from exporting your data to creating benchmarks, to finding your best times to post.

Learn Social Media Analytics

7 Tips for Getting Better Social Media Results by Using Data

To give you a quick overview of what we’ll go through in this post, here are the seven tips:

  1. Create quick reports with spreadsheets
  2. Set benchmarks for your performance
  3. Measure total engagement
  4. Add context to the data you pull
  5. Find out your best time to post
  6. Reuse your top posts
  7. Engage influencers who shared your content

Most of the tips use data from Buffer, which can be exported with a Buffer for Business plan. We’d love for you to give it a try for free if you haven’t tried it before. You can also get most of the data and graphs for free directly from Twitter Analytics and Facebook Insights.

Social Media Analytics and Reporting Tips

1. Create quick reports with spreadsheets

The most powerful tool in your toolbox: The data export

For the longest time, I was scared of a data export. What’s a .csv? What do I do with it once I have it? Exports gave me more questions than answers. I was frozen.

/cue ”Let it go” soundtrack!

Fortunately, my Buffer friends came to the rescue! I picked up some awesome tips from the community on the power of data exports.

I’d love to share the highlights!

First, export your data.
You can get an export of your data from any screen in the analytics section of your Buffer dashboard. Bonus: You can grab data from any date range imaginable; the defaults are 7 days, 30 days, and 90 days, with an option to set a custom date range, too.

Export options

(The Export option is part of our Buffer for Business plan. You can also grab free data exports from Facebook and Twitter themselves.)

Next, import the data into a Google Sheet, or open the data in Excel.

Import to Sheets

Next, calculate total engagement.
We’ll make an extra column in the spreadsheet to track total engagement: the sum of clicks, reshares, comments, and Likes.
Calculating engagement

Next, set a baseline.
Once your stats are out of Buffer, Facebook, or Twitter and into a spreadsheet, the first thing we tend to do is remove any outliers from the dataset.

For instance, in Buffer’s case, we have a lot of #bufferchat tweets on Twitter, and these aren’t necessarily part of the social media marketing posts that we’d love to analyze. We throw out the viral hits, too — yay for them, they just kind of throw off the rest of our averages. 🙂

Then we run the averages and the medians to find our baseline.

Calculating averages and medians

(The median finds the middle value in a set of numbers, which can be helpful if the data still has any outliers.)

Next, find the rates.
There are a couple of rates that are key for us at Buffer: social media stats per impression and per follower.

For instance, is a post a success if it gets 100 clicks? Maybe. Depends on how many people saw it, right! This is where stats per impression comes into play.

We can do the same with stats per followers, which ends up being a useful measure for comparing different networks like Twitter to Instagram. If we have 100 engagements on an average Instagram post and we have 5,000 Instagram followers, that might be an amazing area for us to double-down — especially if we know our Twitter average is 100 engagements per tweet with 400,000 Twitter followers!

Here’s one way that we’ve heard it explained to us:

  • Crawling: Stats per day, e.g. total clicks
  • Walking: Stats per post, e.g. average clicks
  • Running: Stats per impression/follower, e.g. click rate

Crawl walk run

Act now:

Here’re some templates to get you started with analyzing all the stats mentioned here: baselines, engagement, rates, and more.

If you prefer following a video, here’s a quick 7-minute walk-through on how to build a simple social media report with your data.

Section separator

2. Set benchmarks for your performance

Benchmarks can be aspirational, earned, traditional, and competitive

One thing we’ll often ask ourselves – just today even – when looking through our social media stats is this:

So … is that good?

We’re always on the hunt for answers here, and one of our latest tactics has made analyzing our social media updates a million times faster and smarter — not to mention saved us an hour a day on our social media processes.

Here’s the key: Setting benchmarks for what makes a good post.

And here’s how we’ve gone about it:

Once you have your social media data in your spreadsheet (steps 1 to 3 of Tip 1), run this formula on each of the stat columns that matter to you; Likes, clicks, comments, etc.:

=AVERAGE(your data).

Calculating averages

Awesome, now that you’ve got your average, we like to bump ours up slightly so that the benchmark is a bit aspirational. To the moon!


Calculating benchmarks

And just like that, you’ve set yourself a benchmark!

Now, when you’re scrolling through your Buffer history, you can see at-a-glance which posts have gone above and beyond your benchmark. You can recognize your best posts in a second or less!

Assess posts

How frequently should you re-examine your benchmarks?

Great question! I tend to rethink my benchmarks anytime I’m noticing that I’m reaching the benchmark more often than I’m not. It’s a rather soft science! I’m sure you’ll have a great intuition on when it feels best to bump the benchmark up. 🙂

Act now:

This all just scratches the surface of what benchmarks can mean for you and your organization. We’ve written a full 2,000 words on the topic in case you’re at all interested in more. Here’s a link to the full article:

So…Is That Good? The Complete Beginner’s Guide to Benchmarking on Social Media

Section separator

3. Evaluate your social media performance

Total engagement and other fun social media stats

We all might have our favorite actors, favorite foods, and favorite places. I have a sense the same is true for favorite social media stats!

(For me, it’s Jennifer Lawrence, pizza, the ski slopes, and total engagement.)

Certain stats are more important to some people than they are to others.

For instance, do you care deeply for traffic? Do you feel strongly for building awareness? Is tracking revenue a major key to your success?

I’d love to share a couple ideas here, including the one stat that everyone loves and the one stat that everyone wishes came easier.

The stat everyone loves: Total engagement

Total engagement is the sum of all interactions on your post: clicks, reshares, comments, and Likes. It is the social media analyst’s peanut butter sandwich. Almost everyone loves it.

Finding total engagement is as simple as adding up the interactions on a post. In your data spreadsheet, make an extra column in the spreadsheet to sum the number of clicks, reshares, comments, and Likes of each post.

Calculating engagement

There are several social media analytics tools that automatically calculate total engagement for you, which can save you some time. We’re working hard to show you your total engagement right within your Buffer dashboard. Stay tuned! 🙂

The stat everyone longs for: Revenue from social

It’s our white whale!

How do you even go about tracking revenue from social? It’s not as straightforward as some of the other stats like engagement or clicks. Still, it’s possible! Here’re the tools and steps we’ve found to work:

  • Buffer to set your UTMs
  • Google Analytics to crunch the revenue numbers

Here’s a quick run-through of the steps:

Step 1: Set your UTMs the way you want them in Buffer under Settings > Link Shortening.

Buffer link shortening

Step 2: Head into Google Analytics and set up Ecommerce or Goals.

Setting goals in Google Analytics

Step 3: After a day or two, head back to Google Analytics and get a traffic report by going to Acquisition > All Traffic > Channels > Social.

Step 4: Add the conversion goals to your data table, and voila, you’ll see the revenue!

Revenue in Google Analytics

(Our report is showing $0 as we have been using another tool, Looker, instead of Google Analytics, to track revenue from social.)

The Google Analytics stuff can sometimes be a bit tricky for me! Haha, okay – most of the time it’s tricky for me! I’ll often head for help at YouTube. There are some really great tutorials there!

Act now:

And of course, these two ways — total engagement and revenue — just scratch the surface of all that’s possible with evaluating your social media content. We’ve written an article that covers a bit more of the iceberg. We’d love for you to take a peek!

5 Unique Ways to Measure and Evaluate a Social Media Campaign

Section separator

4. Add context to the data you pull

How do you even do that?

Social media be confusing sometimes, especially when you’re down in the day-to-day of it and struggling to see the bigger picture.

Looking at the larger trends of your social performance is hugely helpful for seeing how strategies are playing out.

In particular, there’s this post written by the Intercom team that I just adore when it comes to trends. Here’s a key graphic from the post:

Intercom graphic

The tl;dr – Data is great, especially data with context!

To start with, it’s useful to have the trends data in front of you.

We’re hoping to make this as easy as pie for you and your team with the Analysis Report. To find your Analysis Report, head to the Analytics tab in your Buffer dashboard and click on “Analysis”.

In this report, you’ll see the trend of your key social media metrics such as clicks, Likes, reshares, and followers.

Buffer Analysis Report

Act now:

And then once you’re seeing the trends, there’re a few questions that might be great to ask:

  • What caused any spikes or valleys?
  • When will we reach the next milestone?
  • Where will we be in the next (x) days or months?
  • What factors are we not accounting for?

For example, for the graphs above, the spike in Likes was caused by a tweet that took off while the spikes in clicks were due to the launch of our new online social media strategy class.

Quick tip: You can click on any point on the graphs to zoom in on that date and see the posts published on that date. This is great for finding out which post(s) caused the spike.

Buffer Analysis Report Zoom

I’m just now realizing that it might be a bit hard to answer “What factors are we not accounting for?” Kind of like asking you to know what you don’t know! If it’s helpful, here’re some of the factors I’m often overlooking on accident:

  • Weekends
  • Holidays
  • Seasonality
  • Most popular times to share on social (9 AM to 5 PM New York time)
  • Big announcements or campaigns

Section separator

5. Find your best time to post

There’s no one ideal time to post in 2017. It’s all unique to your brand.

We used to think there’s a universal best time to post.

Not anymore.

Instead, we believe every brand has its own set of best times to post. Here’re some tips on how to find time:

How to find the best times to post on Facebook

In your Facebook Page Insights, Facebook shows you when your Facebook fans are online.

With the algorithmic News Feed, the timing of your Facebook post might be less important but I feel there’s still utility in finding the best posting times to generate initial engagement — early signs of a quality content which might cause Facebook’s algorithm to show your post to more people.

There are generally two schools of thought about best Facebook posting times. The first is to post when your fans are most active on Facebook so that there’s a higher chance of them seeing and interacting with your posts. The second is to post when your fans are least active as there is less competition for the limited space on users’ News Feed.

I’d recommend experimenting with both ideas to see which works better for your brand. For example, we have been seeing some success with posting during off-peak hours.

To get this data, head to your Facebook Page > Insights > Posts > When Fans Are Online.

Facebook Insights

How to find the best times to post on Twitter

Since Twitter still uses a reverse-chronological timeline, finding the optimal posting times is still very relevant.

While Twitter Analytics does not provide similar followers’ activity data, Twitter tools like Followerwonk and Tweriod can tell you when your followers are most active.


It’s generally believed that if you tweet when your followers are most active, there’s a higher chance that they’d see your tweets. Having said that, I’d still recommend experimenting with different times using the data you have.

There’s also a way to find out the best times to post based on how your tweets have performed in the past. It would require you to dig into your Twitter Analytics using spreadsheets. If you’re keen, here’s a guide on how to do that.

Act now:

With these data, you could experiment with different posting times to see if you can achieve better results. An experimental Twitter schedule, with five posting times, could look something like this:

  • Three posting times in the three most active hours
  • Two posting times in the two least active hours

Section separator

6. Reuse your top posts

Repeat your successes by republishing them after a few weeks

So, one of your tweets is taking off. Likes, retweets, and replies are rolling in. What should you do?

(First, celebrate, of course!)

To maximize the value of that tweet, you can consider republishing it — ideally with a different copy several days or weeks later. If you repeat this flow for a while, you can build up a nice repository of social media posts — that have proven to be great — to fall back on whenever you are having a social media manager’s block.

It’s good to remember that all networks are different. Generally, you can publish the same content more frequently on Twitter than on Facebook and more frequently on Facebook than on Instagram. For example, you could republish a piece of content a few days later on Twitter but you might want to give it a few weeks on Facebook and a few months on Instagram before republishing.

We’re hoping that one of the fastest ways to find your top-performing posts (across the networks) is in the Posts Report of your Buffer Analytics. At a glance, you can see the various types of engagement generated by each post. You can also sort them by a particular type of engagement such as retweets.

Top posts in Buffer

You can also get similar data from Twitter Analytics (Tweets > Top Tweets) and Facebook Insights (Posts > All Post Published > Sort by Reach or Engagement).

When you are lacking inspirations for new tweets, you can head to your Posts Report and grab a top post from several weeks or months back. For example, here’s what we did:

Step 1: Set the timeframe as 90 Days or set a custom timeframe if you want to go even further back.

Select 90 Days

Step 2: Sort your posts by a form of engagement such as retweets, Likes, or clicks. Here, I chose retweets.

Sort by engagement type

Step 3: Pick a post from a few weeks back and hit “Re-Buffer”.


Here’s the post we republished (originally published last December). The original tweet received 133 Likes, 135 retweets, and one reply while the republished tweet received 134 Likes, 134 retweets, and 3 replies!

Republished tweet

Act now:

We wrote a full blog post, a while back, on the power of republishing the same content and the ways we reframed our republished content in case you’re interested in more. Here’s the link to the full article:

Why You Should Share Your Blog Post More Than Once on Social Media: The Case for Reposting Content

Section separator

7. Engage influencers who shared your content

The tools to find influencers

Here’s a fun thought: At this very moment, an influencer — someone with a significant social media following — might be sharing your content.

Wow, that’d be a powerful bit of information to celebrate with a boss or client or team!

Not to mention a virtual high-five for all your hard work. 🙂

You can find out this information in a handful of ways:

We’re hoping that one of the easiest methods might be the one waiting for you in your Buffer dashboard. We’ve added a new Influencer Report for your Twitter profiles, where you can see who has shared any of your URLs on social, ranked by the number of followers each person has.

Influencer shares

Act now:

So if you published a blog post yesterday and wanted to thank the folks who had shared it since, just plug it into the tool and see the results. You can click on “View tweet” to pull up the tweet and reply the influencer.

(There’s another layer to this, too. If you click the retweets in your Buffer stats, you’ll get a list of everyone who has retweeted you — and you can follow back and click through to their profile right from the Buffer dashboard.)

View retweets

Section separator

What is your favorite analytics trick?

There are so many things you can do with your social media data, and I’m sure I barely scratched the surface with these seven tips. I’d love to learn from you and hear about your favorite analytics tip or trick!

How do you use your social media data? How has that helped you with your social media performance?

Image credit: Unsplash