Guide · By PostBoost team · · Markdown
Short answer: a good social media report template has eight sections: a header, a three-sentence summary, the goals, totals (posts, views, engagements, engagement rate), a line per network, the top posts, audience growth and the next steps. Use one engagement rate formula and print it on the page, because the method moves the number more than a month of work does. Export one row per post as a CSV and the free social media report generator fills in the totals, the network table, the top 5 posts and your best weekday in your browser.
The 8 sections of a social media report
Most templates you can download are slide decks with 15 placeholder charts. A report a client reads fits on one or two pages and answers three questions: what happened, why, and what we do next. These eight sections cover that.
| # | Section | What goes in it |
|---|---|---|
| 1 | Header | Client or brand, period (e.g. 1-31 October 2026), accounts included, who prepared it |
| 2 | Summary | Three sentences: the result, the main reason, the next move |
| 3 | Goals | Each goal with its target and this period's number |
| 4 | Totals | Posts, views, engagements, engagement rate, with the formula |
| 5 | Per network | The same four numbers for each network, sorted by engagements |
| 6 | Top posts | The 5 posts with the most engagements, with date, network and the first line |
| 7 | Audience | Followers and follower growth per account |
| 8 | Next steps | Two to four actions for next period, each tied to a number above |
1. Header
Write the exact date range, not "October", and list the accounts. A reader who compares two reports needs to see that they cover the same days and the same accounts.
2. Summary
Write it last. One sentence for the result ("Engagements rose on Instagram and fell on LinkedIn"), one for the reason you can show ("the three carousels made up half of Instagram's engagements"), one for the decision ("more carousels, fewer link posts"). A client who reads only this paragraph should still know what you recommend.
3. Goals
List the goals agreed at the start: views, followers, clicks to the site, leads. Put the target next to the actual number. If a goal has no number yet, say so instead of leaving it out. For sales and leads, tag every link with UTM parameters so your analytics can credit social, and see the social media ROI guide for turning that into a return; the social media ROI calculator does the sum from attributed revenue and costs.
4. Totals
Four numbers: posts published, views, engagements and engagement rate. Under them, one line that says what you counted, for example: "Engagements = likes + comments + shares. Engagement rate = engagements ÷ views × 100."
5. Per network
A small table with one row per network and the same four columns. This is where a report earns its keep: an average across Instagram and LinkedIn hides that one is growing and the other is not.
6. Top posts
The five posts with the most engagements, with the date, the network and the first line of the text. Add one line on why you think each one worked, and mark it as your reading, not a fact. If one post or format clearly failed, show it too.
7. Audience
Followers at the end of the period and the change since the last report, per account. Follower counts move slowly, so this section is short; the social media audit checklist covers the deeper look at profiles and audiences once a quarter.
8. Next steps
Two to four actions, each tied to a number in the report: "Post carousels on Tuesday and Sunday, the two best weekdays", not "keep improving content". Next month's report starts by checking them.
Copy this template
Paste this into a doc and replace the brackets. The numbers are the totals from our sample file, explained below.
SOCIAL MEDIA REPORT: [Client], 1-30 September 2026
Accounts: [Facebook Page, Instagram, LinkedIn Page, X] Prepared by: [name]
SUMMARY
[Result in one sentence.] [Main reason in one sentence.] [Next move in one sentence.]
GOALS
[Goal 1]: target [x], actual [y]
[Goal 2]: target [x], actual [y]
TOTALS
Posts: 30 Views: 102,675 Engagements: 3,343 Engagement rate: 3.26%
Engagements = likes + comments + shares + clicks. Rate = engagements / views x 100.
PER NETWORK
Network Posts Views Engagements Rate
Facebook 7 29,414 1,079 3.67%
Instagram 8 26,113 1,006 3.85%
X 7 26,209 817 3.12%
LinkedIn 8 20,939 441 2.11%
TOP POSTS
1. [date] [network] [first line of the post]: [engagements]
...
AUDIENCE
[Account]: [followers] followers, [+/- change] since last report
NEXT STEPS
1. [Action tied to a number above]
2. [Action]
For a spreadsheet version, keep one row per post with these columns, which open in Excel and Google Sheets as they are:
date,network,text,views,likes,comments,shares,clicks
2026-09-01,linkedin,Product tip: schedule a week of posts in one sitting,2737,108,2,3,0
One engagement rate method per report
The same posts give different rates depending on what you count. Our sample CSV has 30 posts with 102,675 views, 2,671 likes, comments and shares, and 672 clicks:
| What you count as an engagement | Engagements | Rate (÷ views) |
|---|---|---|
| Likes + comments + shares | 2,671 | 2.60% |
| Likes + comments + shares + clicks | 3,343 | 3.26% |
Nothing about the posts changed between those two lines. If last month's report counted clicks and this month's doesn't, the rate "drops" by two thirds of a point for no reason. Dividing by followers or reach instead of views changes it again; engagement rate by reach vs followers walks through the options, and the engagement rate calculator shows all of them side by side. Pick one, write it under the totals and keep it.
This report also shows your own numbers, not industry benchmarks. Benchmarks use other formulas and other audiences, so the comparison that means something is this month against your last report.
Impressions are now views on Meta
If your reports go back more than a year, check the metric name. Meta's Graph API v22.0 changelog deprecated Instagram's impressions and plays and added views; from 21 April 2025, requests for impressions on media created on or after 2 July 2024 return an error. For Facebook Pages, Meta deprecated impressions in the Page Insights API from 15 November 2025, replaced by views on all API versions. Views include repeat displays, so a month measured in views and a month measured in impressions are not the same metric: add a note when your comparison crosses the switch.
Worked example: the sample file
We ran the 30-post sample (1-30 September 2026, four networks) through the social media report generator. Its result:
- Totals: 30 posts, 102,675 views, 3,343 engagements, 3.26% engagement rate. The file has a clicks column, so the tool adds clicks to likes, comments and shares, and the page says which counts it used.
- Per network: Instagram had the highest rate (3.85%), Facebook the most engagements (1,079), LinkedIn the lowest rate (2.11%).
- Top post: a Facebook customer story on 27 September with 308 engagements.
- Best weekday: Tuesday, with 156 engagements per post on average across 5 posts. Sunday was second with 130.
That is enough to write the summary and the next steps: "Instagram had the best rate and the customer story the best single post; LinkedIn's rate trails, so next month we test the customer story format there and post more on Tuesdays." With 4 or 5 posts per weekday, treat the weekday result as a hint to test, not a rule; how often to post explains why a few posts per slot prove little.
Getting the numbers into the template
From each network. Every network has its own export. On LinkedIn, for example, a Page admin opens Analytics, picks the tab (Content, Visitors, Followers or Competitors), clicks Export, selects a timeframe and exports again to get an XLS file (LinkedIn Help). Rename the columns to the layout above, or keep them: the generator lets you map each field to any column from a menu.
From the generator. Drop the CSV on /tools/social-media-report-generator, check the column mapping, add a title, period and client name, then copy the summary, download it as CSV or print it to PDF. The file is read in your browser and not uploaded. Files are limited to 1 MB and 5,000 rows. Developers can send already mapped rows to the same tool without an API key:
curl -X POST "https://postboost.co/app/api/tools/social-media-report-generator" \
-H "Content-Type: application/json" \
-d '{"rows": [{"date": "2026-09-01", "network": "linkedin", "views": 2737, "likes": 108, "comments": 2, "shares": 3}]}'
The response has posts, views, engagements, engagement_rate, engagements_from (which counts were added), networks, top_posts, weekdays and best_weekday (docs).
Let PostBoost export the report
If your accounts are connected to PostBoost, the numbers are already collected. Go to Tools, Insights, Reports:
- Under New report, choose the Format: PDF (branded) or CSV. For a CSV, choose the CSV rows: One row per post and account or One row per account.
- Pick a Period (Last month, This month, Last week, This week, Last 3 months, This year), or set Or from and to for a custom range of up to 366 days.
- Tick the Accounts to include, or leave them all unticked for every account, and click Create report.
The PDF has a Summary (Followers, Follower growth, Posts on the networks, Published from here), an Accounts table with followers, growth and posts, and the Top posts (the 10 with the most engagements, with views, likes, comments, shares and engagement rate). Under Report branding you set the Name on the report, a Colour (#RRGGBB), a logo (PNG or JPEG, up to 1 MB) and Footer text, and you can hide the "Generated with PostBoost" line, so the client sees your agency on the header.
The posts CSV has one row per published post and account, up to 500 posts per report, with the columns published_at, account, network, text, views, likes, comments, shares, engagements and engagement_rate. Its engagement rate counts likes, comments and shares over views, the first method in the table above. That CSV maps in the report generator with no changes, when you want a text summary for an email.
Your AI agent can request the same report through the API with one call (reports docs):
curl -X POST "https://postboost.co/app/api/{workspaceUuid}/reports/exports" \
-H "Authorization: Bearer YOUR_API_TOKEN" \
-H "Content-Type: application/json" \
-d '{"format": "pdf", "period": "last_month"}'
The file is ready when the call returns; download it from download_url with the same token within 7 days. On plans that include the PostBoost MCP server, the same operation is the createReportExport tool, so an agent can be asked "Create last month's PDF report for this workspace and give me the download link." See analytics and reports for what PostBoost tracks per account and per post.
Do this in PostBoost
Free tools for this guide
Free tool
Free social media report generator
Turn a CSV of post metrics into a one-page social media report: totals, engagement rate, networks, top 5 posts, best weekday. Copy, download or print it.
Free tool
Social media ROI calculator
Calculate social media ROI from attributed revenue, ad spend, tools, labor and content costs. See the formula with your numbers and each cost's share.
Free tool
Engagement rate calculator for Instagram, TikTok and LinkedIn
Calculate engagement rate by followers, reach or impressions, for one post or several. See the formula with your own numbers. Free, in your browser.
FAQ
What should a social media report include?
For a monthly report: a header with the period and the client, a three-sentence summary, the goals and how far you got, totals (posts, views, engagements, engagement rate), a line per network, the top posts, follower growth per account and the next steps. Leave out any metric nobody will act on.
How do I calculate engagement rate in a report?
Pick one formula, write it on the report and keep it every month. A common one is engagements ÷ views × 100, where engagements are likes, comments and shares. Adding clicks raises the number: on our 30-post sample file the rate is 2.60% without clicks and 3.26% with them, from the same posts.
Is there a free social media report template for Excel or Google Sheets?
Use one row per post with the columns date, network, text, views, likes, comments, shares and clicks. That layout opens in Excel and Google Sheets, and the free PostBoost social media report generator turns the same CSV into the totals, network table, top 5 posts and best weekday.
How often should I send a social media report?
Monthly suits most clients and managers, because a month holds enough posts for the averages to mean something. Weekly works as an internal check on what is going out. Whatever you choose, compare each report with the previous one of the same length.
Why did my impressions turn into views?
Meta replaced impressions with views. In the Instagram API, impressions stopped for media created on or after 2 July 2024 from 21 April 2025, and Meta deprecated impressions in the Facebook Page Insights API from 15 November 2025, both replaced by views. Views count repeat displays, so don't compare a views month with an impressions month as if they were one metric.
Can PostBoost create the report for me?
Yes. Under Tools, Insights, Reports you can export a PDF with your logo, name and colour (summary, accounts, top 10 posts) or a CSV of up to 500 published posts, for a preset period or any range up to 366 days. The same report can be requested through the API.
Sources
- Meta for Developers: Graph API v22.0 changelog, Instagram impressions and plays deprecated, views added
- Meta for Developers: Page Insights API updates (15 August 2025)
- LinkedIn Help: Export your LinkedIn Page analytics report
- PostBoost docs: client reports (PDF and CSV export)
- PostBoost docs: social media report generator API