Social Media Report Generator

An export is not a report

Most social media reports are written to prove work happened: pages of screenshots, a number for everything the platform exports, a “highlights” slide that’s really the three least embarrassing metrics. The client skims it, says “looks good,” and the relationship quietly weakens at renewal — because a data dump gives them nothing to renew. A report is different in kind, not degree. It makes an argument: here’s what we set out to do, here’s what it earned you, here’s what we’re doing next and why. Clients renew arguments; nobody renews a spreadsheet. This tool is opinionated on purpose — it only lets you build the second kind.

The structure here is the one from our full guide, how to build a monthly social media report clients actually read. The tool turns that method into fill-in-the-blanks and does the arithmetic; the guide explains the reasoning behind each section in depth.

The five questions every report answers

The form is organized as five questions, answered in order. Answer them honestly and you have a report that reads in two minutes and survives being forwarded to the client’s boss.

1. 1

   What we set out to do

   One short paragraph naming the month’s focus in plain words. This is the bar everything below gets measured against — if you can’t write it, the numbers underneath are decoration, because there was nothing to measure them toward.

2. 2

   What happened

   The numbers block: a fixed set of metrics per channel, each shown against the previous period. The tool computes the engagement rate and the change for you. The discipline that makes this section trustworthy is keeping the metrics the same every month— a report whose metrics shift is a report that can’t be compared.

3. 3

   Why it happened

   Two or three sentences of real analysis per notable movement, entered as the “why” line on each channel. “Engagement rose because the two carousels out-saved everything this quarter” is analysis; “engagement was strong” is weather reporting.

4. 4

   What it earned

   Tracked sessions and the conversions the client actually counts — signups, leads, sales. This is the section the client’s boss reads, and the one most reports fudge. It only works if your links were tagged before the month started.

5. 5

   What’s next — and what we need from you

   Next period’s focus plus one decision, phrased as a question the client can answer in a single email. Reports that end with a decision get replies; reports that end with a chart get silence.

The numbers block: fewer metrics, attached to their method

The fastest way to lose a client’s trust is to be asked “how is this calculated?” in a meeting and not have a crisp answer. So the report prints the engagement-rate formula directly under the numbers — the method travels with the metric. The default block covers what an organic retainer needs: posts published, reach, engagement rate, saves and shares (the high-intent signals, kept separate from vanity likes), link clicks, and follower change last, as context rather than a headline.

Two rules keep it honest. Freeze the window— calendar month or trailing 30 days, but pick one and never switch, because a window that moves is a number that can’t be compared. And pair every rate with an absolute: a rising engagement rate on collapsing reach is a shrinking account wearing a flattering metric, which is exactly why the tool shows the rate and the reach it was earned on side by side. To pressure-test a channel’s engagement rate against platform benchmarks before it goes in the report, run it through the engagement rate calculator, which uses the same formula and hands you a methodology line to paste.

The earned section is won before the month starts

Question four — what did it earn— can’t be reconstructed after the fact. If the links you posted in May weren’t tagged, May’s traffic is an undifferentiated blob labeled “social / referral” in analytics, and no amount of reporting effort will split it into which campaign worked. The fix is unglamorous and done in advance: every outbound link gets UTM parameters before publishing, with one campaign name shared across channels and sources and mediums from a fixed vocabulary so they land where you expect in GA4’s default channel groupings. The UTM builder generates the whole channel set at once; the GA4 setup guide turns those tagged links into the saved exploration this section pulls from. Enter the sessions and conversions per source, and the tool totals them and computes the conversion rate.

Compare to a baseline, not to a borrowed benchmark

The report compares each channel to its own previous period, never to another channel and never to a generic industry table — a 1.2% rate on X by impressions and a 4% rate on Instagram by reach aren’t on the same scale, so putting them next to each other invents a story that isn’t there. For a new client with no history yet, build a trailing 90-day baseline over the first few months and measure against that. It’s the only benchmark that can see your niche, your audience size, and your content mix — the three things that make borrowed benchmarks useless.

One more honesty habit the tool is built for: annotate outliers, don’t erase them.A post went viral or a post flopped — note it in the outlier field, show the average with and without it, and move on. Clients forgive variance; they do not forgive discovering three months later that “average” quietly excluded the bad weeks.

From numbers to sent in about thirty minutes

Run with discipline, the monthly report is an assembly job, not a writing job. Pull the platform numbers into the form (the metrics and window never change, so neither does the query). Add the campaign sessions and conversions, already clean because the links were tagged on the way out. Write the focus paragraph, the why-lines, and the decision question — the only real writing in the document. Then copy the report as Markdown into your own template, or hit Print to save a one-page PDF. The expensive version of this job is the day spent reverse-engineering untagged links every month; set the vocabulary once and the report becomes the easiest argument you make all month.

Frequently asked questions