It’s the 3rd of the month, 9 p.m. You’ve got Instagram Insights, YouTube Studio, LinkedIn analytics, the ads manager and a CRM export open in five tabs. You paste numbers into an 18-slide deck, and by midnight you realize you still can’t answer the one question the client will ask: “So, is it working or not?”
Most social media reports fail in one of two ways. Either they’re a dump of screenshots where the reader has to find the meaning, or they’re five upbeat slides of “reach up 34%” that end, a couple of months later, with “let’s pause the project.” Both cost you an evening, and neither explains what the money is buying.
Below: a six-block template that takes five minutes to read, where each number comes from, and how to compare months and present a bad one honestly.
The three questions every report answers
Whoever reads it — a café owner, a marketing director or a client — wants three answers:
- Is this making money, or at least leading to it? Leads, sales, cost per lead.
- What did you do, and what worked? Conclusions, not a list of posts.
- What’s next, and what do you need from me? Decisions, approvals, budget.
Anything that doesn’t answer these goes to the appendix or gets cut. Reach for each of 16 posts, likes on every Story, a screenshot of the profile grid — that’s your working data, not the report.
The template: six blocks on one or two pages
Use Google Docs, Notion or 5–7 slides; the order matters more than the format. The example is a skincare clinic in September.
1. The month in three lines. Main result, main reason, one decision you need:
September: 180 leads from social (+18% vs August), cost per lead $25, down from $29. Growth came from Reels showing treatment prices. We need approval for $300 to boost the two best videos.
2. Business metrics. Four to six rows, always with the target and last period:
| Metric | September | August | Target | Note |
|---|---|---|---|---|
| Leads from social | 180 | 152 | 170 | Instagram 64%, Facebook 22%, LinkedIn 14% |
| Sales attributed to social | 54 | 46 | 50 | CRM as of October 3 |
| Cost per lead (CPL) | $25 | $29 | ≤ $27 | Ads + management fee |
| Revenue from social | $9,720 | $8,280 | — | A floor, not the full picture |
If social sales aren’t tracked, say so and show the metric closest to money: link-in-bio clicks, DMs, site visits. How to tie posts to revenue without expensive tooling, and how to calculate CPL and ROMI, is covered in our guide to social media metrics.
3. Platforms. One row per network, the same 4–5 columns: net followers (gained minus lost), reach, engagement rate by reach, saves and shares, link clicks. Identical columns beat completeness: the reader should compare platforms at a glance.
4. What worked and what didn’t. Top three posts and the worst one, each with a number and a hypothesis. “Carousel ‘5 questions to ask before your first facial’ — 410 saves vs a usual 60: a checklist people want to keep.” The flop proves you analyze rather than cherry-pick.
5. Experiments. What you tested, how you measured it, what happened, what you decided. One or two a month is healthy; zero for three months is a warning sign.
6. Plan and requests. Three to five concrete steps for next month, plus what you need from the reader: new treatment photos by the 10th, approval for a reviews series, CRM access.
Where the numbers come from and how long it takes
| Source | Where to look | What to pull |
|---|---|---|
| Instagram, Facebook | Meta Business Suite → Insights | Reach, followers, interactions; CSV export |
| YouTube | YouTube Studio → Analytics → Advanced mode | Views, watch time, subscribers; export to Google Sheets |
| Threads | Insights in the app | Views, replies, reposts, followers |
| Page analytics | Impressions, clicks, followers; export | |
| Website | Google Analytics 4 | Sessions and conversions by social UTM tags |
| Sales | CRM or order sheet | Deals with “social” as the source |
What every Instagram metric means, and which ones belong in a report, is in our breakdown of Instagram Insights.
Two habits that save hours:
- Pull numbers on the 2nd or 3rd, not the 1st. Stats for the last days of the month are still settling, and late-month leads turn into sales a few days later.
- Keep a running sheet all month. Five minutes every Friday beats three hours of digging: with it, the report takes 30–60 minutes to assemble; without it, half a day.
A Looker Studio dashboard makes sense if you report weekly or juggle many clients. Its free connectors cover Google Analytics, YouTube and Google Sheets; Instagram and Facebook need a paid third-party connector. And a dashboard never replaces blocks 1 and 4 — clients pay for conclusions, not charts.
How to compare months honestly
- Mind the calendar. February has 28 days, March has 31: an 11% difference out of thin air. Show daily averages for reach and leads, or add a note.
- Don’t compare only with last month. For seasonal businesses, January after the holidays always looks like a crash. Add a column for the same month last year or a three-month median.
- Split organic and paid. If you started ads in September, a 60% jump in reach is the budget’s doing, not the content’s. Show them as two separate rows.
- One engagement rate formula, always. If you change it, say so in the table. Why formulas give such different results is explained in our post on engagement rate.
- Followers are net. 1,400 gained and 900 lost is +500, not +1,400.
How to present a bad month
Everyone has them: an algorithm shift, a client who sent no photos for a month, a bestseller out of stock. A report where everything always goes up raises more suspicion than an honest dip.
The formula: fact → cause → what you’ve already done → when to expect results.
Instagram reach fell 27% in July: we published 9 Reels instead of the planned 16 because the clinic shoot slipped by two weeks. We filmed 12 videos on July 28, and they’re already scheduled for August. We expect reach back at June levels by mid-month.
Don’t bury the drop in the appendix, swap metrics until one looks good, or blame “the algorithm” for everything. If the cause is on your side, say it first. The client will notice anyway, and your other numbers keep their credibility.
Client vs boss: what changes
| Agency or freelance client | Manager inside the company | |
|---|---|---|
| Core question | What am I paying for, and should I renew? | Where should we invest next? |
| Must-have block | Work delivered under the contract | Link to team goals and budget |
| Format | Document + 20–30 minute call | One page or 3–5 slides |
| Cadence | Monthly | Monthly + a short weekly note in chat |
Clients also need to see the volume of work: “16 posts and 8 Reels published, 340 comments and DMs handled.” It isn’t the headline, but without it you’ll eventually hear “what exactly are you doing?” Your boss cares more about how social affects sales and where people or budget are short.
A trick that works for both: send the report a day before the meeting and spend the meeting only on blocks 1, 4 and 6.
When the template won’t save you
- No agreed goal. If nobody defined success at the start, every report becomes an argument. Goal and 3–4 metrics first, reports second.
- No access to sales data. Without a CRM or at least an order sheet, block 2 stays empty. Say it plainly and propose a minimum: a social-only discount code or a “how did you hear about us?” question at checkout.
- An account under two or three months old. There’s nothing to compare with, and numbers jump with every post. Report on work delivered and early signals; save conclusions for later.
- Weekly reports for a small account. At 2,000 followers, week-to-week swings are noise. A couple of lines in chat weekly, a full report monthly.
If you rebuild block 3 every month, keep the numbers in one place: Repost21 shows account analytics for Instagram, YouTube and Threads next to the content calendar, so platform numbers and what you published sit in one view. Try it free — and keep writing blocks 1 and 4 yourself. That’s what clients pay for.