Blog Strategy
Social media report for clients: a template and worked example
What to include, how to explain a difficult month and which decisions to propose. Compare two scenarios and download an editable template.
What a social media report should answer
A social media report for clients explains what happened during a defined period, what it means for the agreed objective and what the team will do next. A template makes that conversation consistent. Before filling it in, write one question: “Are we generating enquiries for this service?” or “Does our content help people understand the offer?” That question determines which measures belong in the report.
The reader should be able to find the conclusion and next decision without opening every post. Keep the supporting detail available: dates, accounts, links, definitions and data sources. A screenshot of a number without that context is difficult to revisit next month.
A worked example: reach grows while enquiries fall
Our fictional service business wants qualified enquiries: requests describing a need the team can serve. We compare two 30-day periods of organic activity. In this example, enquiries came from tagged website sessions and were checked for spam and duplicates; DMs are excluded.
The business published four more posts in September. Reach increased, but it received six fewer qualified enquiries. The initial finding is that visibility grew while the observed business outcome weakened. We do not yet know whether the offer, form or traffic mix caused the change.
Read the results before choosing an action
Fictional example. Download it and adapt it to your work.
September compared with August
A fictional service business. 1–30 August versus 1–30 September, organic activity only; definitions remain consistent.
| Measure | August | September | Change |
|---|---|---|---|
| Posts | 12 | 16 | +33.3% |
| Account reach | 20,000 | 28,000 | +40% |
| Tagged website sessions | 400 | 420 | +5% |
| Recorded qualified enquiries | 20 | 14 | −30% |
| Enquiries / sessions | 5% | 3.33% | −1.67 percentage points |
Decision: Check the form and offer before increasing posting frequency. Higher reach does not explain the drop in enquiries.
A second scenario using the same baseline
An alternative scenario, not another real month. August stays fixed so you can compare the meaning of the measures.
| Measure | August | Scenario B | Change |
|---|---|---|---|
| Posts | 12 | 12 | Unchanged |
| Account reach | 20,000 | 16,000 | −20% |
| Tagged website sessions | 400 | 360 | −10% |
| Recorded qualified enquiries | 20 | 24 | +20% |
| Enquiries / sessions | 5% | 6.67% | +1.67 percentage points |
Decision: Investigate which posts brought qualified enquiries. The observed improvement warrants a closer look; it does not establish a cause.
In the first scenario, the rate moves from 20 ÷ 400 = 5% to 14 ÷ 420 = 3.33%. That is a fall of 1.67 percentage points. The relative decline in the rate is approximately 33.3%. These describe the same movement using different units; do not swap them.
The rate is meaningful here because its numerator and denominator belong to the same journey and period. If you add phone enquiries that cannot be connected to those sessions, it is no longer a conversion rate for those sessions.
A structure you can reuse each month
- Objective and scope. The business goal, included accounts and comparison dates.
- Summary. One main observation, its limitation and the proposed decision.
- Measures. Current value, baseline, change and source for each figure.
- Relevant content. Specific posts that help explain the findings, with links and context.
- Next cycle. Actions with an owner, a deadline and a signal to review.
The workbook includes the baseline, both scenarios, and sheets for a summary, actions and evidence. A formula calculates the rate; the file does not connect to your accounts. Open it in Excel or import it into Google Sheets. Replace the data, keep the definitions and add links to the original evidence when preparing your own report.
How to explain a difficult month
A suitable summary for the first scenario would be: “We received 14 qualified enquiries, compared with 20 in the previous period. Reach increased by 40% and tagged sessions by 5%. We have not identified the cause of the decline. This week we will check the form and the posts that brought traffic, then test an offer with clearer terms.”
This acknowledges the outcome without inventing an explanation. If the website went down, prices changed or paid activity increased, record the date and supporting evidence. Do not automatically attribute a difference to the algorithm.
Assign the technical check to the website owner and the content review to the editorial owner. Agree what counts as a qualified enquiry before the next comparison. With small volumes, a handful of enquiries can move the percentage considerably: always show the absolute count.
Checks before you present
If the team still needs to agree what to measure, use the social media KPI template by goal to define the metric, its source and the decision it will inform.
Do not add the reach of individual posts and treat the result as distinct people: someone can see several posts. Keep platform measures, website sessions and recorded enquiries separate. Do not add rates or take simple averages of percentages with different denominators.
Tag campaign links consistently. Google explains how UTM parameters identify campaigns referring traffic to Analytics; tagging alone does not prove sales or attribute every visit to a post. Google documentation. You can build a UTM link and record its tags with the generator and template.
If a measure is unavailable, state that and explain what is needed to collect it. A zero says it was measured and did not happen. An empty cell should not imply the same thing.
Where AI can help
Ask an assistant for a first summary using the table and definitions. Request separate observations, hypotheses and next steps. Check calculations and references before sharing the report. Our article on analysing social media with ChatGPT using real data covers that review.
This template is a standalone resource, not an automatic HeyMark export. For a broader diagnosis, pair the monthly report with a social media audit.
What to take to the next meeting
Bring the summary and its supporting file. Finish with a specific decision: what changes, who owns it and when the result will be reviewed. The next report should return to that agreement and explain what the team could verify.
Plan your next post in HeyMark.
Keep the idea, review the draft with your team, and see how it performed in the accounts you connected.