# Social Media Report Template: 8 Sections and a Free Generator

Published: 2026-11-10

**Key takeaways:** A monthly social media report needs eight sections: header, summary, goals, totals, a line per network, top posts, audience growth and next steps. Keep one engagement rate formula: the same 30 sample posts give 2.60% without clicks and 3.26% with them. A CSV of post metrics fills in the numbers.

**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](/tools/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](/learn/how-to-calculate-social-media-roi) for turning that into a return; the [social media ROI calculator](/tools/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](/learn/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.

```text
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:

```text
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](/assets/samples/social-report-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](/learn/engagement-rate-reach-vs-followers) walks through the options, and the [engagement rate calculator](/tools/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](https://developers.facebook.com/docs/graph-api/changelog/version22.0/) 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](https://developers.facebook.com/blog/post/2025/08/15/page-insights-api-updates/) 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](/tools/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](/learn/how-often-to-post-on-social-media) 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](https://www.linkedin.com/help/linkedin/answer/a551206/)). 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](/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:

```bash
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](/docs/free-tools/social-media-report-generator)).

## Let PostBoost export the report

If your accounts are connected to PostBoost, the numbers are already collected. Go to **Tools**, **Insights**, **Reports**:

1. 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**.
2. 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.
3. 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](/docs/reports)):

```bash
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](/features/analytics) for what PostBoost tracks per account and per post.

## Do this in PostBoost

- [Analytics](https://postboost.co/features/analytics): Account and post analytics for your social accounts in one place, and reports you can download as CSV or a branded PDF.

## Free tools for this guide

- [Free social media report generator](https://postboost.co/tools/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.
- [Social media ROI calculator](https://postboost.co/tools/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.
- [Engagement rate calculator for Instagram, TikTok and LinkedIn](https://postboost.co/tools/engagement-rate-calculator): 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](https://developers.facebook.com/docs/graph-api/changelog/version22.0/)
- [Meta for Developers: Page Insights API updates (15 August 2025)](https://developers.facebook.com/blog/post/2025/08/15/page-insights-api-updates/)
- [LinkedIn Help: Export your LinkedIn Page analytics report](https://www.linkedin.com/help/linkedin/answer/a551206/)
- [PostBoost docs: client reports (PDF and CSV export)](https://postboost.co/docs/reports)
- [PostBoost docs: social media report generator API](https://postboost.co/docs/free-tools/social-media-report-generator)

Canonical: https://postboost.co/learn/social-media-report-template
