Social Media Report Template

A filled social media report example, not an empty grid

The builder above loads pre-filled with a complete monthly report for a fictional brand, so you can see a finished social media report example before you type anything: five channels, real arithmetic, a drafted summary and a flagged biggest mover. Press Start blank when you want to replace it with your own numbers, or Load example to bring the sample back.

That is the difference between this and the template files that dominate this search. A downloadable spreadsheet hands you empty cells for engagement rate, follower growth and the change versus last month, and expects you to work them out yourself in another tab. This one takes the raw counts your analytics screens actually show — posts, followers, reach, engagements, clicks — and computes every derived figure, including the comparison against published benchmarks, which no static template can do because it does not know what a good number looks like.

What a social media report template should include

A social media report proves what happened in a finished period. That is a narrower job than it sounds, and it is worth separating from the two things people confuse it with: an audit diagnoses the state of an account right now, and a strategy decides what to do next. If you need the first, the social media audit template is the right tool. This one is for the period that has already closed. Metric by metric, it should carry:

• Posts published. The volume line. Without it, no engagement rate is comparable to a benchmark, and nobody can tell whether a rise in engagements came from better posts or just more of them.
• Reach, views or impressions. Distribution, under whichever name the platform uses. Keep the names distinct rather than merging them into one "reach" column — impressions count repeats and reach does not.
• Engagement rate, not engagement count. A count grows with audience size and so proves nothing. A rate is comparable month to month and against a benchmark, which is why the builder above shows both and compares only the rate.
• Follower growth in absolute and percentage terms. Plus 900 followers means something different on 3,000 than on 300,000, so a report needs both numbers side by side.
• Link clicks and click-through rate. The first metric on the list that a finance team recognises. Tag the links with UTM parameters and the clicks become attributable in analytics rather than estimated.
• Conversions, where you can honestly attribute them. Sign-ups, sales, bookings, demo requests. Report them with the attribution window stated, or leave the row out — an invented conversion number is the fastest way to lose a client's trust in every other figure.
• Top posts. Three of them, with the metric that made each one top and one sentence on why. This is the section clients screenshot.

Which of those become your headline numbers depends on what the account is for. Our guide to social media KPIs works through choosing three or four to report on rather than all of them, which is the single biggest improvement most reports can make.

How to fill out the report, step by step

1. Pick the variant and name the two periods. Every figure in the report is a comparison, so the comparison period is not optional. For a campaign report, the comparison is the baseline window before launch.
2. Open each platform's own analytics. Instagram Insights, TikTok Analytics, LinkedIn page analytics, YouTube Studio, Meta Business Suite. Use the platform's own figures rather than a third-party tool's, so the client can reproduce your numbers.
3. Enter five numbers per channel, twice. Posts, followers, reach or views, engagements, link clicks — for this period and the one before. Blank cells are skipped rather than counted as zero, so a channel you do not track does not drag the totals down.
4. Read the rates, not the counts. The engagement rate column is the one to look at, and the benchmark badge next to it tells you whether the number is normal for that platform.
5. Edit the drafted summary. The template writes a first draft from your figures. Rewrite it in your voice, cut anything the client will not act on, and keep the causal claim honest — "we posted three more Reels" is a fact, "Reels caused the growth" usually is not.
6. Export and send. PDF for the client, CSV for your own records, the slide outline when the report has to be presented rather than read.

The six sections a client actually reads

Structure the document in this order and you will not have to explain it. It is the shape almost every professional social report converges on, and the export follows it:

• Executive summary — four to six sentences. Assume this is all that gets read.
• Headline numbers — the three or four KPIs, each with its change.
• Channel breakdown — one row per platform, rates and deltas.
• Goal review — what the period was supposed to achieve, and whether it did.
• Next period — three actions, each traceable to a number above it.
• Appendix — top posts, definitions, and where every figure came from.

An "earned media" or reach-value line is common in agency reports, and the builder can add one, but it is switched off by default and framed as a range. No platform publishes a rate for what organic reach is worth, so any single figure is somebody's estimate dressed as a fact — and clients budget against these numbers.

How to write the executive summary

This is the part every downloadable template leaves as an empty box, and the part the client reads first. Four sentences, in this order, each one anchored to a figure already in the report:

1. Volume and outcome. "In May we published 80 posts across five channels, reaching 655,400 accounts and earning 23,316 engagements and 4,460 link clicks."
2. The one move that mattered. "The biggest change was TikTok engagements, up 62.5% on April, driven by the three recipe videos rather than by posting more often."
3. The one problem, named without drama. "Facebook link clicks fell 14.8%, which is the only line in this report that needs a decision rather than a note."
4. Quality against a benchmark. "Engagement held inside the published benchmark band on every channel we report on."

Those numbers are from the worked example loaded in the builder, so you can see exactly which cells each sentence came from. The template drafts these four sentences from your own figures; the judgement about what mattered is still yours, and it should be, because that judgement is what a client is paying for.

Why this template's engagement rate differs from your spreadsheet

Two things go wrong in almost every hand-built social media report, and both make the numbers look better than they are.

First, the denominator is different on every platform. Engagement rate is measured differently on every platform — per follower on Instagram and Facebook, per view on TikTok, per impression on LinkedIn. Compare like with like or the comparison is meaningless. In the published studies this template compares against, Instagram runs at 0.37%–0.55% measured per follower, Facebook at 0.05%–0.20% per follower, TikTok at 3.75%–4.40% per view, and LinkedIn at 3.25%–7.00% per impression. LinkedIn's number is not roughly ten times Instagram's because LinkedIn is ten times better — it is a different fraction. The builder reads the correct denominator for each platform and never prints a blended rate across them.

Second, benchmarks are per-post averages and monthly reports are totals. A month of engagements divided by your follower count is approximately the per-post rate multiplied by the number of posts, so an account that posted twenty times will look extraordinary against a per-post benchmark. On follower-denominated platforms this template divides by post count before comparing. On view- and impression-denominated platforms the post count cancels out, because both sides of the fraction scale with it. If you want the long version of that arithmetic, we wrote it up in how to calculate engagement rate, and the engagement rate calculator does a single post or account if a full report is more than you need.

Benchmark sources: Socialinsider's platform benchmark studies for Instagram, TikTok, LinkedIn and Facebook, and the Quid (formerly Rival IQ) 2026 Social Media Industry Benchmark Report for YouTube, whose 0.21% figure is a single published median rather than a range. None of these bands is published by a platform; all are independent estimates, and each one's sample size and data period is listed in the table inside the builder. Last verified 2026-09-24.

Nine platforms, including the ones templates forget

Threads, Bluesky and Pinterest appear in almost no social media report template, which is awkward if you actually post there. All three are in the channel list here, alongside Instagram, TikTok, LinkedIn, YouTube, Facebook and X. Where a platform has no published engagement benchmark — X, Threads, Pinterest and Bluesky do not — the template still calculates your rate and shows the denominator it used, then declines to render a verdict rather than inventing a bar to clear. A report that admits what it does not know is worth more than one that guesses confidently.

From reporting on posts to publishing them

Reporting is the easy half. The work is everything that happens before the numbers exist: writing for each network, adapting one idea to nine, keeping a consistent voice and getting it all scheduled. That is what Outfeed AI does. It is a chat-first AI social media manager: describe the post, it writes it in your brand voice, shows a per-platform preview, then schedules and publishes to Instagram, TikTok, LinkedIn, X, Facebook, Threads, YouTube, Pinterest and Bluesky from the same conversation.

Starter is $29 a month and Pro is $59 a month, both flat rather than per seat — unlike Hootsuite and Sprout Social, which bill per seat from their entry tier. Outfeed AI only charges per seat at the Agency tier, at $149 per seat per month, and Enterprise is custom. The free trial runs 3 days and includes 100 AI credits; a card is required to start it.