A good client report answers three questions fast: did the account grow, did it do anything for the business, and what happens next month. Most reports bury those answers under screenshots of dashboards. This template puts them first and keeps the rest to the numbers a client can act on.
It's built for X (Twitter) accounts that agencies, freelancers and ghostwriters run for clients, and works the same for an in-house team reporting to a founder.
Download the template
Download x-client-report-template.csv. It has one row per metric with its definition, how to calculate it, columns for this month and last month, a change column and a notes column for the client.
Copy it to Google Sheets: open Google Sheets, choose File → Import → Upload, pick the CSV and select Replace current sheet. In Excel or Numbers, just open the file. The growth rate, per-post, rate and change cells are formulas, so they fill in as you type each month's numbers.
The eight sections of a monthly X report
1. Summary
Three lines a busy client can read in ten seconds: the headline, two or three wins and the one thing you'll fix. Write it last, after the numbers.
2. Audience
Followers at the start and end of the month, the net change and the growth rate. Growth rate makes a small account and a big one comparable.
3. Publishing
How many posts and replies went out. Clients pay for output as well as results, and this row shows you delivered it.
4. Reach and engagement
Impressions, impressions per post, engagements and engagement rate, each against last month. Per-post numbers stop a busy month from hiding weaker posts.
5. Traffic and pipeline
Profile visits, link clicks and click-through rate, then leads found, contacted, conversations and calls. For a B2B client this is the section that justifies the retainer.
6. Top posts
The five best posts with a link and one line on why each worked: the hook, the format, the topic or the timing.
7. Learnings
The format and posting time that beat the account's normal, and what this month's test showed.
8. Next month
One focus, one or two planned tests, and what you need from the client: approvals, product news, customer stories or access.
Metric definitions and formulas
Use the same definitions every month, or the trend lines mean nothing. Count the totals for posts published in the month, not every post that happened to get views.
| Metric | Formula | What it tells the client |
|---|---|---|
| Net follower change | End followers − start followers | Followers gained minus followers lost |
| Follower growth rate | Net follower change ÷ start followers × 100 | Comparable across account sizes |
| Impressions per post | Impressions ÷ posts published | Average reach of one post |
| Engagement rate | Engagements ÷ impressions × 100 | Share of views that led to an interaction |
| Link click-through rate | Link clicks ÷ impressions × 100 | How often a view became a visit |
| Reply rate (outreach) | Conversations ÷ leads contacted × 100 | Share of contacted leads who answered |
| Change | This month − last month | Shown for every number in the report |
Example report
Here's the template filled in for a fictional B2B software client. Every number below is made up to show how the formulas fit together; it isn't data from a real account or a benchmark.
ExampleFictional client, made-up numbers
Summary
- Headline: the account grew 6.46% this month, up from 4.83%, and outreach booked 3 calls.
- Wins: impressions per post rose from 4,450 to 4,800, and the reply rate on outreach rose from 22.2% to 29.0%.
- To fix: link click-through rate fell from 0.36% to 0.33%; next month we'll test one clear link post a week.
Numbers
| Metric | This month | Last month |
|---|---|---|
| Followers at start | 4,120 | 3,930 |
| Followers at end | 4,386 | 4,120 |
| Net follower change | +266 | +190 |
| Follower growth rate | 6.46% | 4.83% |
| Posts published | 38 | 34 |
| Impressions | 182,400 | 151,300 |
| Impressions per post | 4,800 | 4,450 |
| Engagements | 5,290 | 4,240 |
| Engagement rate | 2.90% | 2.80% |
| Profile visits | 2,140 | 1,820 |
| Link clicks | 610 | 540 |
| Link click-through rate | 0.33% | 0.36% |
| Leads found | 46 | 38 |
| Leads contacted | 31 | 27 |
| Conversations | 9 | 6 |
| Reply rate (outreach) | 29.0% | 22.2% |
| Calls booked | 3 | 2 |
Top posts, learnings and next month
- Top post: a thread on a mistake the founder made pricing the product, which led the month on impressions.
- Best format: founder stories beat the account's normal; product announcements were below it.
- Next month's focus: two founder stories a week, one link post a week, and replies to 10 buyer conversations a week.
- Needs from the client: approval on the launch thread by the 10th and one customer story we can share.
How to make the report useful
- Lead with change, not totals. "Impressions per post up from 4,450 to 4,800" says more than "182,400 impressions".
- Explain every drop. A number that fell without a note reads as something you hoped they'd miss.
- Tie it to the business. For B2B clients, the pipeline rows matter more than likes. Agree on what counts as a lead in the first month.
- Keep it to one page. Link to posts instead of pasting screenshots.
- Send it on the same day every month, so the client expects it and reads it.
Automate it with Xholic
Filling this in by hand takes an hour or more per client. On every paid Xholic plan, including the agency plan, each client account gets a monthly report built from its stored analytics: followers, posts, impressions and engagement rate against last month, the top five posts, the best format and posting time, replies, leads found and contacted, DM results and next month's focus. It carries your agency's name, logo and color, opens as a link or prints to PDF, and can be emailed to the client on the 1st of each month. See client reporting or how agencies use Xholic.