Free template

The monthly X client report template

The report agencies and freelancers send clients each month: what to include, how to calculate every metric, a worked example and a free CSV for Google Sheets or Excel.

Updated November 22, 2026. Free, no sign-up.

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.

Metrics in the X client report, with formulas
MetricFormulaWhat it tells the client
Net follower changeEnd followers − start followersFollowers gained minus followers lost
Follower growth rateNet follower change ÷ start followers × 100Comparable across account sizes
Impressions per postImpressions ÷ posts publishedAverage reach of one post
Engagement rateEngagements ÷ impressions × 100Share of views that led to an interaction
Link click-through rateLink clicks ÷ impressions × 100How often a view became a visit
Reply rate (outreach)Conversations ÷ leads contacted × 100Share of contacted leads who answered
ChangeThis month − last monthShown 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

Example X client report with made-up numbers
MetricThis monthLast month
Followers at start4,1203,930
Followers at end4,3864,120
Net follower change+266+190
Follower growth rate6.46%4.83%
Posts published3834
Impressions182,400151,300
Impressions per post4,8004,450
Engagements5,2904,240
Engagement rate2.90%2.80%
Profile visits2,1401,820
Link clicks610540
Link click-through rate0.33%0.36%
Leads found4638
Leads contacted3127
Conversations96
Reply rate (outreach)29.0%22.2%
Calls booked32

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.

FAQs

Questions

Straight answers.

What should a monthly X report for a client include?

A short summary, audience growth, what was published, reach and engagement against last month, traffic and pipeline, the top five posts, what you learned and next month's plan. The template above has a row for each.

How do I calculate engagement rate on X?

Divide engagements by impressions and multiply by 100. Use the totals for posts published in the month, and compare with last month calculated the same way.

Where do the numbers come from?

Follower counts, impressions, engagements, profile visits and link clicks come from X's own analytics or your social media tool. Leads, conversations and calls come from your lead list and the client's calendar or CRM.

Can I use the template in Google Sheets or Excel?

Yes. Download the CSV, then in Google Sheets choose File, Import, Upload, or open it directly in Excel. The growth rate, per-post, rate and change columns are spreadsheet formulas that fill in as you type the month's numbers.

Are the example numbers real?

No. The example report uses made-up numbers for a fictional client so you can check the formulas. Replace every number with the client's own.

Can Xholic build this report for me?

Yes. Xholic builds a monthly report for each client X account from its stored analytics: followers, posts, impressions and engagement rate against last month, top posts, replies, leads and next month's focus, with your agency's name, logo and color. You can share it as a link, save it as a PDF or email it to the client every month. Client reporting

Let Xholic write the report for you

Xholic builds each client's monthly X report from stored analytics, with your branding, and can email it on the 1st.

No card needed · Nothing to cancel

See the agency plan

Live demo: no sign-up or login needed · takes about 2 minutes