All lessons in this course
Parts of a social media report
Readers want three answers. Did it work, why, and what happens next? Every part of the report serves one of those questions.
Screenshots of every chart make the reader do your work. Choose the numbers that matter, then explain them in plain words.
- 1GoalWhat last month was for.
- 2KPIsThree numbers against target.
- 3Top postsTwo or three, with the reason.
- 4LessonOne thing you learned.
- 5Next monthWhat changes and who does it.
Social media report template
Copy this table into a document or a slide. Each row is one or two lines, never a paragraph.
| Section | What to write | Example |
|---|---|---|
| Goal | One line with a number and a date | 20 trial bookings from Instagram in October |
| KPIs | Three numbers with last month, this month and target | Reach 4,600 to 5,140, target 5,000 |
| Top posts | Two or three posts and why they worked | Morning class reel with the class time in the first line |
| What we learned | One finding with evidence | Reels with a teacher's face got more saves than photos |
| Next month | Two or three actions with owners | Two reels a week, Maya films, Kofi writes |
| Numbers note | Formula, period and where the data came from | Engagement rate by reach, 1 to 31 October, Instagram insights |
Report lines to copy
Write the summary last, after you know the story. Put it at the top, because some readers read only that line.
Lines for each part of the report
- Summary
In __ we aimed for __. We reached __, which is __% of the target.
- KPI line
__ went from __ to __ (target __). Main reason: __.
- Top post
Best post: __ on __. It worked because __.
- Lesson
We learned that __. Evidence: __.
- Next month
Next month we will __, __ and __. Owner: __.
- Request
To do this, we need __ from you by __.
Numbers with a reason
A number alone leaves the reader to guess what it means. Add the change, the cause and what to repeat.
A reason can be a guess, as long as you call it one. "We think reach dropped because we posted less in week three" is honest, and next month's numbers can confirm or reject it.
If you report to a client, write their goal in their own words at the top. If you report to yourself, the same page stops a busy month from feeling like a good one.
A number alone
- Reach 5,140
- Engagement rate 6.1%
- 11 bookings
- The reader has to guess
A number with a reason
- Reach 5,140, up 12% after we started a weekly reel
- 6.1% by reach, above the 5.4% median
- 11 bookings, 7 of them from morning class reels
- The reader knows what to repeat
One-page layout and monthly routine
- 1
Export the numbers
Take the same date range from each network, the first to the last day of the month.
- 2
Fill the KPI rows
Put last month's numbers next to this month's, so the change is visible.
- 3
Choose top posts
Rank posts by your KPI, not by likes, and keep the top two or three.
- 4
Write the story
One lesson, one cause, one next step. Cut anything the reader cannot act on.
- 5
Send on a fixed day
For example, the third working day of each month, as a PDF or a short email.
Before you send
PostNext Analytics shows the last 7, 30 or 90 days. On paid plans it also gives you CSV and PDF export and email reports.
Report mistakes
MistakeTwelve pages of screenshots
FixKeep one page. Add extra charts in an appendix only if someone asks.
MistakeNumbers with nothing to compare against
FixShow last month and the target next to every number.
MistakeHiding a bad month
FixSay what dropped, why you think it dropped and what you will try next.
MistakeDifferent date ranges for each network
FixUse the same calendar month for every network.
Your task this week
- 1
Copy the template table into a document.
- 2
Fill it in for last month with your three KPIs and top posts.
- 3
Send it to your client, your manager or your business partner.
You are done when a one-page report for last month is sent, or saved with a date if you work alone.