Social Media KPI Template (Free Excel Download)

October 8, 2026 · 9 min read · by Jan Oršula

A social media KPI template is a spreadsheet where you record the same handful of numbers every month, so you can see whether your social media is moving toward a goal. The free template on this page is a working Excel file (it also opens in Google Sheets and Numbers) with four tabs: a short guide, a goals and targets tab, a monthly tracker for Instagram, Facebook, LinkedIn, TikTok, YouTube, website traffic and paid social, and a filled-in example. The formulas calculate growth, engagement rate, click-through and conversion rate for you, and every row says where to find the number in each platform's analytics. No email or sign-up is needed. Below: what's in it, how to pick the KPIs that matter, how to fill it in, and a worked example.

What's in the template

Delete the blocks for platforms you don't use. Each block calculates on its own, so removing one doesn't break the others.

KPIs vs metrics: why the tracker starts with goals

A metric is any number a platform gives you. A KPI is a metric you've chosen because it shows progress toward a business goal, and you've given it a target. Instagram reports dozens of metrics; a small business might track three KPIs.

That's why the template opens on the goals tab, not the tracker. Write the goal first, then pick the few numbers that would move if you were getting closer to it:

Our guide to social media metrics that matter explains the stages behind this table, and setting social media goals covers choosing the goal itself.

How to fill in the template each month

Once a month, after the month ends, open each platform's analytics, set the date range to the previous calendar month, and type the numbers into the yellow cells. The "Where to find it" column in the tracker names the screen for each one. A few rules keep the numbers trustworthy.

Use the same date range every time

Always the full calendar month, pulled after it ends. Mixing a 28-day view one month with a calendar month the next makes the change between months meaningless.

Don't mix reach with views or impressions

Reach counts people: each account once, however many times they saw your content. Views and impressions count displays, so one person can count many times. They answer different questions, and swapping one for the other between months makes a change in the numbers look like a change in performance.

This matters more than usual right now, because Meta replaced impressions with views. Instagram's analytics now report views, and Meta retired the impressions metric for Facebook Pages in favour of views in 2025. If your older reports used impressions, note the month you switched in the tracker rather than comparing the two directly.

Know which engagement rate you're looking at

There's no single engagement rate formula, so the template uses the one that matches each platform's own numbers and says so in the row:

• Instagram and Facebook: interactions ÷ reach.
• LinkedIn: clicks, reactions, comments and reposts ÷ impressions, which is how LinkedIn itself defines it. LinkedIn counts clicks as engagement, so its rates run higher.
• TikTok: likes, comments and shares ÷ video views.

Because the bases differ, compare each platform with its own past months, not with each other. A 7% rate on Instagram and a 4% rate on LinkedIn don't tell you Instagram is working better. The engagement rate guide covers the formulas in detail, and the free engagement rate calculator works out individual posts.

Get website numbers from GA4, not from the platforms

Platforms count clicks; your website counts the visits that actually arrived. In GA4, open Reports, then Acquisition, then Traffic acquisition, and read the Organic Social and Paid Social rows. GA4 puts a visit in those groups based on its source and medium, as Google's channel group rules describe. Visits from untagged links (from a link-in-bio page, for example) can land somewhere else. Tag every link you control with UTM parameters; the free UTM builder does it in a few seconds, and our GA4 for social media teams guide covers the setup.

How to set KPI targets

Generic industry benchmarks are a weak target, because they average together accounts of every size, industry and posting style. Your own history is a better starting point:

1. Baseline: your average for the last three months. If you don't have three months yet, fill in the tracker first and set targets afterwards.
2. Uplift: how much better you think you can realistically do, usually 5 to 20% for an account that's changing its approach, less for one that isn't.
3. Target: baseline plus the uplift. The goals tab calculates it, then compares it with this month's figure and shows "Yes" or "Not yet".

Revisit targets every quarter. A target you hit easily three months running was too low, and one you miss by half every month was a guess. Our page on social media benchmarks explains how to build your own benchmarks over time.

A worked example

The template's Example tab follows a small online candle shop that sells through its website and markets mainly on Instagram. Its goal is more online orders from social. Here's its first quarter:

Reading it the way the goal requires:

• The KPIs are sessions and conversion rate, because the goal is orders. Followers and engagement are in the tracker as early signals, not as the scorecard.
• February was the best month for orders, and it was also the month with the most reach and interactions. The shop checked which posts drove that (a gift guide carousel and two packing videos) and planned more of both.
• The targets for April come straight from the quarter: a baseline of 1,133 sessions plus 15% gives 1,303, and a 2.14% conversion rate plus 10% gives about 2.35%. The goals tab shows both calculations.

When April comes in at 1,290 sessions and a 2.2% conversion rate, the goals tab says "Not yet" for both. Close, and worth one more month of the same approach before changing course.

How often should you track social media KPIs?

Monthly is right for the template: it's often enough to adjust, and long enough that one unusual post doesn't swing the numbers. Glance at individual posts weekly if you like, but make decisions from the monthly view. Share a quarterly summary with anyone who doesn't need the detail.

If you report to a client or a manager, the monthly tracker feeds straight into a short report. Our guide to the monthly social media report shows how to turn the numbers into five answers someone will read, and the free report generator formats them. For tying the numbers to money, see how to measure social media ROI.

Frequently asked questions