Download this template free
No sign-up needed. Word and Excel files also open in Google Docs, Google Sheets and Apple Pages/Numbers. Letter size (8.5 × 11 in).
Social Media Report
Summary
[Two or three sentences: overall performance, the biggest win and the main focus for next month.]
| Platform | Followers | Last month | Growth | Reach | Engagements | Engagement rate | Link clicks | Posts |
|---|---|---|---|---|---|---|---|---|
| TikTok | ||||||||
| YouTube | ||||||||
| Total |
| Post | Platform | Reach | Engagements | Why it worked |
|---|---|---|---|---|
What worked
What didn't
Next month's actions
Preview of the template. Highlighted [brackets] show text to replace.
How to write a monthly social media report
- Pull the numbers from each platform’s analytics at the same time each month.
- Enter followers, reach, engagements, clicks and posts for each platform. The template calculates growth and engagement rate.
- Pick your top three posts and note why they worked: topic, format, timing or hook.
- Summarize in plain language. Lead with what matters to your boss or client.
- Turn insights into actions for next month.
Make your report useful, not just long
- Tie metrics to goals. If the goal is website traffic, lead with link clicks, not likes.
- Compare to last month and to the same month last year where possible.
- Explain the “why” behind big changes.
- Keep it to one or two pages. Busy readers want the highlights.
Plan next month’s posts with our social media content calendar.
Frequently asked questions
How do I calculate engagement rate?
A common method is engagements (likes, comments, shares, saves) divided by reach, multiplied by 100. Some marketers divide by followers or impressions instead. Pick one method and use it consistently.
Which social media metrics matter most?
It depends on your goals. For awareness, track reach and follower growth. For engagement, track engagement rate and comments. For sales, track link clicks, website traffic and conversions from social.
Where do I find my social media analytics?
Each platform has built-in analytics, such as Meta Business Suite for Facebook and Instagram, LinkedIn Page analytics, TikTok Analytics and YouTube Studio. Website traffic from social appears in Google Analytics.
Related templates and guides
Social Media Content Calendar
Plan a month of posts across every platform, including dates, captions, visuals, links, hashtags and status, in one shared spreadsheet.
TemplateKPI Dashboard Template
Track your most important business numbers each month against their targets. The Excel version calculates the variance and percentage of target for every KPI.
TemplateMarketing Campaign Brief
A one- to two-page brief that aligns everyone on a campaign's objective, audience, message, channels, budget, timeline and how success will be measured.
TemplateMarketing Plan Template
A practical marketing plan for small businesses. Define your goals and audience, pick your channels, set a budget and track what works.