Your month in one file: the headline numbers against last month, each platform side by side, the posts that worked and what you will change. Copy the numbers in; the changes and rates work themselves out.
The Google Sheets copy goes to your own Drive with every dropdown, color and formula working. No sign-up, no email.
January 2027
Compared with December 2026
Reach
94,500+41%
Last month 66,900
Engagement rate
5.2%−0.2 pts
Last month 5.4%
Link clicks
326+25%
Last month 261
Inquiries
6+50%
Last month 4
Reach by platform
This monthLast month
Instagram38,40031,200
LinkedIn14,80012,900
TikTok41,30022,800
What the report includes
One month, four sheets.
Platforms holds the raw numbers from each app. Summary adds them up and sets them against last month and your targets. Top posts and Takeaways turn the numbers into decisions for next month.
social-media-report-template.xlsx
The month on one screen: the headline numbers against last month and your targets.
MonthJanuary 2027
Compared withDecember 2026
Main goal6 project inquiries
Social media report template, Summary sheet: The month on one screen: the headline numbers against last month and your targets.
A
B
C
D
E
F
G
5
Metric
This monthSums of Platforms
Last month
ChangeThis minus last
Change %
Target
Note
6
Followers, all platforms
8,920
8,345
575
6.9%
9,000
Instagram and TikTok each added more than 200
7
Posts published
18
16
2
12.5%
16
Two more short videos than planned
8
Reach
94,500
66,900
27,600
41.3%
90,000
Most of the growth came from TikTok
9
Engagements
4,930
3,620
1,310
36.2%
5,000
Likes, comments, shares and saves
10
Engagement rate (by reach)
5.2%
5.4%
-0.2%
-3.6%
5%
Change is in percentage points
11
Link clicks
326
261
65
24.9%
300
Instagram sent the most; TikTok very few
12
Inquiries or leads
6
4
2
50%
6
Count from your inbox or booking tool
13
14
15
Example rows from a made-up freelance designer. Overwrite them with yours.Purple values are formulasSwipe the sheet sideways to see every column.
How to use it
Report the month in one sitting.
1
Write the month, the month you compare it with and your main goal at the top of the Summary sheet.
2
On Platforms, copy this month's and last month's numbers from each app's analytics, one row per platform. Growth, change and engagement rate fill themselves in, and so do the Summary totals.
3
List your five best posts on Top posts, with one line on why each one worked.
4
Finish on Takeaways: what worked, what did not, and up to three actions for next month. Then duplicate the file for the next month.
Your next actions go straight into the content calendar template, which records reach and interactions per post, so next month's top posts are already listed.
FAQ
Questions about social media reports.
What should a social media report include?
A short summary of the month against the month before and your targets, the numbers for each platform (followers, reach, engagements, engagement rate, link clicks), the posts that did best and why, and what you will change next month. The template has one sheet for each part.
How often should I make a social media report?
Once a month is enough for one person or a small business. Weekly numbers move too much to tell you anything. Fill in the report in the first days of the new month, then duplicate the file for the next one so each month keeps its own copy.
Which engagement rate does the template use?
Engagements divided by reach: likes, comments, shares and saves, divided by the accounts that saw your posts. It compares fairly across platforms and across accounts of different sizes. If you report rate by followers or by impressions instead, change the formula in the Engagement rate column and say so in the report.
Does it work in Google Sheets?
Yes. Click Copy to Google Sheets, sign in to Google if asked, and choose Make a copy. The copy is saved to your own Drive with every sheet, the dropdowns and the formulas working. The Excel file also opens in Numbers and LibreOffice.
Can I turn the report into a PDF?
Yes. The sheets are set to fit the page width, so File, then Print, then Save as PDF gives a clean PDF in Excel, Google Sheets or Numbers. Most people send only the Summary and Top posts sheets.
Can I use it to report to clients?
Yes. Keep one copy per client per month, write the client's goal in the Main goal cell, and put the targets you agreed on in the Target column. The Takeaways sheet becomes your recommendations.