Skip to content

Free template

Social media report template

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.
MetricThis monthSums of PlatformsLast monthChangeThis minus lastChange %TargetNote
Followers, all platforms8,9208,3455756.9%9,000Instagram and TikTok each added more than 200
Posts published1816212.5%16Two more short videos than planned
Reach94,50066,90027,60041.3%90,000Most of the growth came from TikTok
Engagements4,9303,6201,31036.2%5,000Likes, comments, shares and saves
Engagement rate (by reach)5.2%5.4%-0.2%-3.6%5%Change is in percentage points
Link clicks3262616524.9%300Instagram sent the most; TikTok very few
Inquiries or leads64250%6Count from your inbox or booking tool
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.

Which numbers to report

Where each number lives in the apps and which ones matter for your goal: the social media metrics guide. To check one post or account, use the engagement rate calculator.

Next: plan the 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.

Your next post is one question away.

Alpine Reach finds posts that beat their creator’s usual results, turns them into ideas for your brand and drafts them in your voice.

7 days free, then $49.90 a month