Social media report template: free download, worked example and formulas

A social media report template saves you from rebuilding the same document every month, but only if the template does the maths for you and forces you to explain the numbers. Most free templates are pretty slides with empty boxes. This one is a working spreadsheet.

Download the free templates (no form, no email):

• Social media report template for Excel or Google Sheets (.xlsx): Summary, Channel KPIs, Top posts, Paid social and Actions tabs, with formulas for engagement rate, CPM, CTR, CPA, ROAS and month over month change.
• Social media report template for Docs, Notion or Word (.md): the same structure as a written report you can paste and fill in.

Every number in both files is example data for an anonymised, illustrative account. Below I walk through what each section should say, a worked example, how to calculate the metrics properly and how to automate the whole thing once you outgrow a spreadsheet.

What is a social media report?

A social media report is a structured document that shows how your social channels performed over a period, why results changed and what you will do next. That last part is what separates a report from a data export.

At my agency we send these monthly to UK SMEs, and the pattern is always the same: clients read the first page and the action plan. Everything in between is evidence. So a good social media report is built around three questions:

1. Are we growing the right audience?
2. Is our content working, and which content specifically?
3. Is social contributing to business goals like enquiries, sales or website traffic?

A social media analytics report answers the same questions with more depth on audience behaviour and content effectiveness. In practice most marketing teams use the terms interchangeably.

What to include in a social media report template

A complete social media report has six sections. Each one exists because the client cares about something specific. Here is the order I use, and why.

Section	What goes in it	Why the client cares
1. Executive summary	Three to five sentences: result, cause, what failed, next steps	They have two minutes before your call
2. Headline KPIs	Followers, reach, views, engagements, engagement rate, link clicks, paid results vs last month	Shows momentum, not just a snapshot
3. Channel breakdown	Four or five key metrics per platform, one insight, one action	Tells them where the effort is paying off
4. Top posts	Five to ten best posts ranked by the KPI that matters	Makes the work visible and justifies the content plan
5. Paid social	Spend, impressions, CPM, clicks, CTR, conversions, CPA, ROAS	It is their money, so it needs its own section
6. Actions next month	Three to five actions with evidence, KPI, owner and date	Proves the retainer is buying progress, not maintenance

1. Executive summary

Write it last, put it first. Use plain English and real numbers. A weak summary says “Engagement increased this month.” A strong one says “Organic reach rose 19% and link clicks rose 11%, led by three TikTok how-to videos that brought in 690 new followers.” The client should know whether things are going well before they see a single chart.

2. Headline KPIs

These are the core metrics shown against the previous period, with the change and a one-line reason. Keep it to eight to twelve rows. In the spreadsheet, the Summary tab pulls these straight from the Channel KPIs and Paid social tabs, so you never type a total twice.

3. Channel breakdown

One short block per social media platform. Followers, reach, views, engagements, engagement rate and link clicks, then “what worked, what did not, what next”. Resist the urge to paste every metric the platform offers. Specific metrics with commentary beat a wall of raw data.

4. Top posts

Rank posts by the outcome the client values, such as saves, shares, link clicks or leads, rather than likes. Include the hook or first line. That one column turns the report into a creative brief for next month.

5. Paid social

Ad spend, impressions, CPM, clicks, CTR, conversions, CPA and ROAS per campaign, plus a total row. Always reconcile spend with the platform invoice before you send it.

6. Actions next month

This is where you show actionable insights. Each action needs evidence from the report, a KPI you will check next month, an owner and a date. If an action has no evidence behind it, it is a guess.

A worked social media report example

Here is the example data from the template, for an illustrative home services brand. It is not a real client and the figures are not benchmarks. They show how the report reads when it is filled in properly.

Headline KPIs (example data, November vs October)

KPI	This month	Last month	Change
Total followers (all channels)	36,595	35,186	+4.0%
Net follower growth	1,409	1,012	+39.2%
Reach (sum of platforms)	219,400	185,000	+18.6%
Engagements	14,890	11,830	+25.9%
Engagement rate by reach	6.79%	6.39%	+0.39 pts
Link clicks	2,290	2,065	+10.9%
Paid social spend	£4,600	£4,400	+4.5%
Paid social CPA	£25.84	£29.14	£3.30 lower

The executive summary that goes with it:

Organic reach rose 19% and link clicks rose 11% month over month. TikTok led the growth: three how-to videos added 690 followers. Moving two weekly Instagram carousels to Reels lifted Instagram video views by 18% and saves by 17%. Facebook reach fell 7% and X engagement fell 9%, so both now get repurposed content only. Paid social spend of £4,600 returned 178 conversions at a £25.84 CPA, down from £29.14.

And the first action: put £400 behind the top TikTok video as a Spark Ad, because it earned 720 shares organically, and judge it on a paid CPA below £25.

Notice what the example does. Every claim has a number. Every drop has a reason. Every action points back to evidence. That is the whole job.

How to calculate engagement rate and other metrics correctly

Engagement rate is the most quoted and least consistent number in social media reporting. There are three common formulas, and they give wildly different answers for the same month.

Using the example Instagram data (4,380 engagements, 58,400 reach, 142,600 views, 12,480 followers):

Formula	Calculation	Result	When to use it
Engagements ÷ reach	4,380 ÷ 58,400	7.5%	Our recommended headline rate
Engagements ÷ impressions (views)	4,380 ÷ 142,600	3.1%	Comparing with LinkedIn or ad platforms
Engagements ÷ followers	4,380 ÷ 12,480	35.1%	Rarely: it ignores non-follower reach

Our recommendation: engagements ÷ reach. It answers the question clients actually ask: of the people who saw this, how many cared? It is not inflated by one person seeing a post five times, and it still works when most of your reach comes from non-followers, which is now normal on TikTok and Instagram Reels. Follower-based rates made sense when feeds were chronological. They mislead now.

Three rules make any formula trustworthy:

• Define “engagements” once. We use likes or reactions, comments, shares and saves. Leave clicks out of organic engagement and report link clicks separately.
• Use aggregate totals, not an average of post rates. Averaging per-post rates lets one tiny post with 50 views and 10 likes distort the month.
• Never change the formula mid-retainer. If you must, show both for one month and explain why.

The other formulas built into the template:

• CPM = spend ÷ impressions × 1,000
• CTR = clicks ÷ impressions
• CPA = spend ÷ conversions
• ROAS = conversion value ÷ spend
• % change = (this month minus last month) ÷ last month. For rates, report the change in percentage points, so 6.39% to 6.79% is “+0.39 pts”, not “+6%”.

To measure social media ROI properly, add a business outcomes block: sessions from social in GA4, leads or sales attributed to social, and what share of the total that represents. State which attribution source you used.

Monthly vs weekly vs quarterly social media reports

The reporting cycle changes what belongs in the report. Use a monthly social media report template as the default and adapt it.

Version	Audience	What to include	Length
Weekly	Internal teams, social media managers	Posts published, top post, ad spend pacing, anything broken	Half a page
Monthly	Client or leadership	The full six sections above	Two to four pages
Quarterly	Decision makers	Follower growth trends, performance trends by format, what to stop, what to scale, budget changes	Four to six pages, fewer tables

Weekly reports catch problems. Monthly reports build trust. Quarterly reports change the future strategy. If you only have time for one, make it monthly and keep it consistent.

Platform-specific notes: what native analytics give you today

Platforms keep renaming metrics, which is the main reason social media reports break. Here is what each one reports natively, checked against their help pages in October 2026.

Instagram. The Instagram Help Center lists Views, Viewers, Interactions, Accounts engaged and follower trends. Views counts every time content was played or displayed, and Viewers is the unique accounts figure, so use Viewers as reach. Insights cover any period in the past 90 days, and audience demographics only appear once you reach or engage over 100 accounts. Export monthly, or you lose the history.

Facebook. Insights in Meta Business Suite shows Views, Content interactions, Link clicks and follows, with breakdowns by organic versus ads and followers versus non-followers. Meta added Views to video insights from October 2024, so older reports built on “impressions” will not line up neatly with new ones. Add a note when you change the label.

TikTok. Analytics live in TikTok Studio. TikTok Support notes that data can take one to two days to update, and that most analytics are shown in UTC while follower activity uses your local time. So pull TikTok numbers a couple of days after month end, not on the 1st. TikTok’s Creator Academy says the Overview tab covers up to 60 days, which is another reason to export monthly.

LinkedIn. Page content analytics report impressions and engagement rate for your posts. LinkedIn’s own definition of engagement rate is interactions per impression, and it counts clicks as interactions alongside reactions, comments and shares. That makes LinkedIn’s built-in rate look different from your reach-based rate. Report your consistent formula in the headline table and LinkedIn’s native rate in the channel block if the client is used to seeing it.

YouTube. YouTube Studio reports views, watch time, thumbnail impressions and impressions click-through rate for long-form, plus engaged views and “stayed to watch” for Shorts. A view is counted the moment playback starts, so for Shorts, engaged views is the more honest number. Watch time and average view duration matter more than raw views for a YouTube channel.

X. If you report on X, collect the numbers from its own analytics. It is in the template because many clients still have an account, but in my experience it rarely deserves more than one line in the summary.

Common social media reporting mistakes

These are the mistakes I see most often when reviewing other agencies’ reports.

• Leading with vanity metrics. Followers and likes up front, business outcomes buried on page eight. Flip it.
• Mixed date ranges. Instagram for the calendar month, TikTok for “last 28 days”. Every platform must cover the same reporting period.
• Changing definitions silently. Switching engagement rate formulas, or moving from impressions to views without a note, makes month over month comparisons meaningless.
• Summing reach and calling it unique people. Reach across platforms is not deduplicated. Label it “sum of platforms”.
• No commentary on drops. Clients notice a red number. If you do not explain it, they will invent their own explanation.
• Actions with no evidence. “Post more Reels” is not an action. “Test three Reel hooks in the checklist format because that format earned the most saves” is.
• Manual reporting takes too long. If a report takes a day to build, it gets sent late, and late reports feel like bad news even when the numbers are good.

How to automate your social media report in MYCONTENTLAB

A spreadsheet template is the right choice when you report on one or two accounts. Once you manage several clients, data collection eats the time you should spend on insights. That is the problem we built MYCONTENTLAB to fix, so here is what it does and does not do.

What it automates:

• Data collection. Connect Instagram, Facebook, TikTok, LinkedIn, YouTube, Threads and Pinterest, plus Meta Ads, TikTok Ads, LinkedIn Ads and Google Analytics, with read-only access. See the full list on the integrations page.
• Period comparisons. Analytics & AI Reporting compares each period with the previous one and with the same period last year, so the % change column fills itself.
• The first draft of the summary. AI writes the executive summary from your connected data. The figures come from the platforms, and you can review and edit the summary before it goes out.
• Report assembly and delivery. Per the reports documentation, you choose a date range, toggle platform sections on or off, add your own agency commentary, then export a PDF or a password-protected share link. You can schedule recurring weekly or monthly reports to client stakeholder email lists.
• Branding. White label puts your logo, colours and fonts on PDFs and the client portal. A custom domain with SSL is included on the Agency plan (£297/mo, up to 25 clients) and above.

Where to be realistic: X is not a native integration, so X numbers need to come in through CSV import. The AI summary is a starting point, not a finished opinion, and the action plan still needs your judgement. If you report on one account and enjoy spreadsheets, the free template is genuinely enough. If you need a publishing scheduler bundled with reporting, a social media management suite may suit you better than a reporting tool.

Every plan has a 14-day free trial, so you can rebuild one month of a client report in MYCONTENTLAB and compare it with your spreadsheet version.

Get the templates

Both files are free to use, edit and rebrand for your clients:

• Download the social media report template (.xlsx): works in Excel, Google Sheets and Numbers. Yellow cells are inputs; everything else calculates.
• Download the Docs-friendly version (.md): paste into Google Docs, Notion or Word.

For the wider reporting picture, read our guide on how to create a client report and our practical guide to digital marketing reporting in 2026.