Orkas Orkas
Home Blog Guide
Guide

Monthly Client Report Template: What to Include and How to Write It

The six sections a client actually reads, what belongs in each, and a Word + Excel template already filled in — the real files, no email required.

If you run an agency, freelance, or handle marketing for a handful of clients you bill every month, you have written this report before. You pulled the numbers, pasted the charts, wrote a paragraph nobody asked for, and sent it. Then nothing happened. No reply, no questions, no renewal conversation.

The problem usually is not the template. It is that the report answers a question the client never asked.

Skip to the end Have this report generated instead of written Orkas runs the two-step recipe in this guide — the workbook computes, the document is written from it. Free, open source, runs on your machine.
Download Orkas — free

Why clients don't read your monthly report

Open a typical agency report and count the metrics. Thirty is common. Impressions, reach, sessions, bounce rate, average position, follower growth, engagement rate, click-through rate, cost per click — each one accurate, each one on its own slide, none of them adding up to a sentence.

Now count the conclusions. Usually zero.

Here is what that looks like in practice — an excerpt from the kind of report that gets skimmed and filed:

Channel Performance — July
Impressions: 148,220 (+8.2%) · Reach: 41,905 (+3.1%) · Sessions: 2,180 (+14.4%) · Bounce rate: 51.3% (−2.0%) · Avg. session duration: 1m 42s (+6s) · Pages/session: 2.4 · New users: 1,612 (+11.8%) · Followers: 4,431 (+96) · Engagement rate: 3.9% (−0.2%) · Avg. position: 14.2 (−0.8) · CTR: 2.1% (+0.1%) · CPC: $3.01 (−$0.14)

Overall, performance continues to trend positively across channels. We will continue optimising and monitoring performance into August.

Twelve accurate numbers and two sentences that commit to nothing. Nothing in it is false. Nothing in it is useful either, because it never says which of those numbers mattered, what any of them changed, or what anyone should do differently. A client reading it learns that their marketing happened.

That gap is the whole problem. A report full of metrics and empty of judgment reads as evidence that you were busy. Your client did not hire you to be busy. They hired you because they have a business problem and not enough hours, and when they open your report they are asking three questions in this order:

  • Where did my money go?
  • Did anything get better?
  • What happens next month?

Everything else is supporting material. If your report does not answer those three in the first thirty seconds, the rest will not get read — and the reader who does not get an answer starts wondering what they are paying for. Client reports get ignored, then they get questioned, and the questioning is where retainers die. A monthly report is how accountability actually shows up — and accountability is one of only three things a client is buying when they hire anyone.

The rest of this guide is a structure that answers those three questions first, a filled-in example you can copy, the order to actually write it in, and the mistakes that make good work look thin. There are downloadable Word and Excel files at the end. No email required.

What to include in a marketing report

Six sections. In this order. The order matters more than the content, because it front-loads the answers.

1. The one-line verdict

One sentence: was this month good or bad, and why. Write it as a claim, not a summary. "July was ahead of target on enquiries and cheaper per enquiry than June" is a verdict. "Here is our July performance report" is a title pretending to be a sentence.

2. Performance against the goal

What you promised, what you delivered. This is the only section where a number is mandatory. If you did not set a goal at the start of the engagement, set one now and say so — a report with no target is a report with no way to be wrong, and clients can feel that.

3. What was done

Deliverables, not hours. "Rebuilt the service page and rewrote the three highest-traffic listings" is a deliverable. "14 hours of SEO work" is an invoice line. Clients bought outcomes; showing them time worked invites them to price your time.

4. The data

Three to five metrics. Not thirty. Every metric gets one sentence of interpretation underneath it, and the sentence has to say something a spreadsheet could not. If you cannot write an interpretation for a metric, that metric does not belong in the report.

5. Next month

Specific actions with a specific target. "Continue optimising" is not an action. "Build a pricing page for the Invisalign query, which has 1,510 impressions at position 11.8" is an action, and it is one your client can agree or object to — which is the point.

6. What you need from the client

Anything blocking you, and what you need to unblock it. Most freelancers leave this out to seem self-sufficient. It is the section that most reliably gets a reply, and it moves responsibility for stalled work to where it belongs.

What to leave out

Deciding what to cut is harder than deciding what to include, and it is where most reports go wrong. Three categories almost never earn their place.

Metrics that move without you. Follower count, impressions on a brand term, direct traffic. If the number would look roughly the same had you done nothing, reporting it as a result is a claim you cannot support.

Platform screenshots. A pasted GA4 dashboard or a rank-tracker export is raw material, not analysis. If a screenshot is genuinely the clearest way to show something, crop it to the one thing you are pointing at.

Anything you cannot interpret. This is the test that catches everything else. Write the sentence underneath the metric first; if the sentence turns out to be "this went up," the metric is not telling you anything and it will not tell the client anything either.

The checklist

  • Does section 1 state a verdict, not a topic?
  • Does section 2 contain a promised number and a delivered number?
  • Are the items in section 3 things the client received, not time you spent?
  • Does every metric in section 4 have a sentence under it?
  • Could the client disagree with something in section 5?
  • Is section 6 non-empty, or genuinely nothing?

Client report format: a filled-in example

A client report example is more useful than a client report template, because the difficulty is never the headings — it is knowing what belongs under them. Empty templates are easy to find and hard to use. Here is the format filled in for a fictional client — Northside Dental, a practice running local SEO, Google Ads, and social. The numbers are synthetic but internally consistent, which means you can trace every figure to the one it came from.

1. Verdict

"July delivered 47 enquiries against a target of 40, and cost per enquiry fell from $54.86 to $44.26. Growth came from organic search and Google Ads. The clearest opportunity next month is converting Invisalign price demand into booked appointments."

Why it reads this way: a number, a direction, and a next step, in one sentence. A client who reads nothing else knows where they stand.

2. Against goal

Promised 40 qualified enquiries. Delivered 47. That is 117.5% of target, seven enquiries ahead.

Why it reads this way: promised and delivered sit next to each other. No adjectives.

3. What was done

  • Maintained local SEO pages and business listings for high-intent dental services
  • Ran and tuned the Google Ads acquisition campaign, judged on qualified enquiries rather than impressions
  • Published and distributed social content to catch brand and service questions
  • Consolidated channel, session, appointment, and search data into this report

Why it reads this way: four deliverables, no hours. Each one names what the client got.

4. The data

  • Enquiries: 47, up 27.0% from 37 in June. Organic 19, Google Ads 22, social 6.
  • Cost per enquiry: $44.26, down 19.3% from $54.86. Volume went up and efficiency improved at the same time, which does not always happen.
  • Sessions: 2,180, up 14.4% from 1,905. Traffic grew slower than enquiries, which points to better traffic quality or better page conversion rather than simply more visitors.
  • Appointment conversion: 66.0% — 31 appointments from 47 enquiries. Worth splitting booked from unbooked next month to find where follow-up leaks.
  • SEO opportunity: "invisalign cost" drew 1,510 impressions and 22 clicks — a 1.5% click-through rate at average position 11.8. The demand exists; the ranking and the click-through do not match it.

Why it reads this way: five metrics, five interpretations. The last one is not a performance metric at all — it is the evidence for section 5. That is deliberate: the data section should hand the next section its argument.

5. Next month

  • Build or rewrite a page for "invisalign cost" that answers price range, what drives the price, treatment steps, and booking terms
  • Match the title and the top of the page to price intent, and add local service details, FAQs, and a clear booking entry point
  • Track impressions, average position, click-through rate, page enquiries, and appointments for that query separately, and compare against this month's baseline

Why it reads this way: one focus, not five. It names the query, cites the evidence from section 4, and says how it will be measured — so next month's report has a scoreboard already agreed.

6. Needed from the client

  • Confirm the publishable Invisalign price range, payment options, and first-consultation policy
  • Provide two or three anonymised case results with permission to use before-and-after material
  • Confirm how booking calls and forms are actually handled, so the marketing promise matches what happens at the practice

Why it reads this way: each item is a decision only the client can make. None of them is a complaint.

How to write a client report

Most advice on how to write a monthly report describes the sections and stops there. The sections are the easy part. Read in order one through six. Write in almost the opposite order. Writing top-to-bottom is why reports take three hours and still end up saying nothing — you spend the whole time in the data and arrive at the conclusion exhausted.

Step 1: Pull the data first, and stop

Get every number into one place before you write a word. Channel enquiries and spend, sessions, conversions, and whatever search data you have. Do not interpret while you gather; you will anchor on the first interesting thing you see.

Step 2: Write section 5 before anything else

Look at the numbers and answer one question: what should we do next month? This is the hardest part of the report and the part clients actually pay for, so give it your attention while you still have some. It also forces you to find the story in the data rather than describing the data.

Step 3: Work backwards to section 1

Once you know the recommendation, the verdict almost writes itself, because the verdict is the reason the recommendation makes sense. In the example above, the recommendation is a pricing page, so the verdict ends on unconverted price demand. Conclusion and recommendation should agree — writing them in this order makes that automatic instead of a checking step.

Step 4: Fill sections 2, 3, 4, and 6 last

These four are transcription, not thinking. Section 2 is two numbers. Section 3 you already know because you did the work. Section 4 is the data you pulled in step 1, cut down to the three to five metrics that support the verdict. Section 6 is whatever you were waiting on.

Step 5: Cut

Delete every metric without an interpretation. Delete every sentence containing "continue to," "ongoing," or "as always." Then read section 1 alone and ask whether it would be enough on its own. If it would, the report is done.

How long this should take

The order matters because it changes the cost. Writing top-to-bottom, most people spend the bulk of their time in section 4 formatting numbers, then rush section 5 — inverting the value. Working backwards puts the thinking first and reduces the rest to filling in fields.

Track where your own time goes for one report and the split is usually stark. Gathering and reformatting numbers takes the largest share. Writing the interpretation takes the smallest. That ratio is backwards, and it is almost entirely fixable, because the large half is mechanical.

The fix is not working faster. It is building the spreadsheet once so that the derived figures — month-over-month change, cost per outcome, attainment against target — are formulas rather than things you recompute. Next month becomes a data refresh. The only genuinely fresh work is the part that requires judgment, which is the part worth billing.

One warning about speed: a fast report is not the goal. A report that takes twenty minutes and says nothing is worse than one that takes two hours and changes a decision, because the first one teaches your client that the report is a formality. Speed is only valuable if you spend what you save on section 5.

What changes by discipline

The six-section structure does not change whether you report on SEO, social, or an integrated retainer. Only section 4 changes. Here is what swaps in and out.

DisciplineIncludeLeave out
SEO report for clientsImpressions, clicks, ranking bands rather than single positions, indexation, and the queries with demand you are not yet capturingRank-tracker screenshots. Clients cannot read them, and a position on its own does not say whether anyone clicked
Social media reportsReach, saves and shares, and clicks through to the site — the actions that indicate intentFollower count and likes. They move without your help and they do not convert
Integrated marketing reportsContribution by channel and cost per acquisition, resolved into a single verdictEach channel's native dashboard stacked in sequence. Three dashboards is not a report

For the SEO side, the numbers worth reporting mostly live in Google Search Console's performance report, and it is worth being precise about what its columns mean — impressions and position are defined more narrowly than most people assume, and average position in particular is an average over impressions, not a rank you hold. For recurring delivery, Looker Studio will connect to most of these sources directly, though a live dashboard is a supplement to a report, not a replacement — dashboards show, reports conclude.

The question behind all three disciplines is the same: does this metric change what we do next month? If not, it belongs in the appendix or nowhere.

How often to send it, and what to automate

Monthly for the client, weekly for you. They are different documents with different jobs, and merging them produces something too long for the client and too slow for you. The client report is a decision document sent once a month. Your own weekly check is a working document; it can be ugly and nobody else needs to see it.

Send within five working days of month end. Later than that and the recommendations are about a month the client has stopped thinking about.

On automation, the line is clean: the data can be automated, the conclusions cannot. Pulling numbers, computing month-over-month changes, and formatting a workbook are mechanical and should never be done by hand twice. Deciding which three metrics matter this month, and what they mean for next month, is the part the client is paying a person for.

The boundary is easier to see with an example. "Cost per enquiry fell 19.3%" is arithmetic — a formula should produce it, and no human should ever type that number. "Cost per enquiry fell because the ads account stopped bidding on a broad match term that was drawing price shoppers" is a conclusion, and it requires knowing what you changed and why. Automate the first sentence. Never automate the second, and be suspicious of any tool that offers to.

In practice that means the spreadsheet should be built once with live formulas so that next month is a data refresh rather than a rebuild — and the document should be generated from the spreadsheet, so the numbers in the prose cannot drift from the numbers in the workbook. The files at the end of this guide are built that way, and the two-step recipe that produces them is printed in full below so you can run it against your own clients rather than retyping ours.

Automate the mechanical half Let the numbers assemble themselves Orkas pulls the figures, computes the comparisons, and drafts the document — so the hour you spend goes into section 5, where the client's money actually is.
Download Orkas — free

Six mistakes that make good work look thin

1. Numbers without conclusions

Bad: "Sessions: 2,180 (+14.4%)."
Good: "Sessions: 2,180, up 14.4%. Traffic grew slower than enquiries, which suggests better traffic quality rather than simply more visitors."

2. Hiding the bad month

Bad: burying a 20% decline on page four under a heading about "channel dynamics."
Good: putting it in section 1 with the reason and the response. Clients forgive bad months. They do not forgive finding out late — and a decline they discover themselves costs you the assumption that you would have told them.

3. Changing metrics every month

Bad: reporting engagement rate in June, reach in July, impressions in August.
Good: the same core metrics every month, so trends are visible. Rotating metrics reads as choosing whichever number looks best, whether or not that is what happened.

4. No specific next action

Bad: "Continue optimising and monitor performance."
Good: "Build a pricing page for the Invisalign query and track it separately against this month's baseline." A recommendation the client cannot disagree with is not a recommendation — it is a sentence that survives review by not saying anything. It also leaves you with nothing to be measured against next month, which feels safe and reads as drift.

5. Hours instead of deliverables

Bad: "14 hours of SEO, 6 hours of content."
Good: "Rebuilt the services page and rewrote the three highest-traffic listings." Reporting hours invites clients to price your time instead of your outcomes.

6. A report longer than the contract

Bad: 24 slides for a $2,000 retainer.
Good: two pages. Length signals effort to you and signals padding to the reader. If the work was genuinely broad, the summary should still be short and the detail should be an appendix. Volume is also the most common substitute for a verdict: it is easier to send thirty slides than to write the one sentence that could be wrong.

The monthly client report template

Two files — a Word document and an Excel workbook. No email required, no signup, no watermark. Together they are a marketing report template you can put in front of a client this week, and unlike most client report templates you will find, the Word file arrives with the example above already filled in.

Download the templates Word template (.docx) Excel workbook (.xlsx) No email, no signup. Synthetic sample data, already labelled.
  • monthly-client-report.docx — a client report template in Word, the six-section report, filled in with the example above so you can see the format working rather than guessing at empty headings. Replace the content; keep the structure.
  • monthly-client-report.xlsx — the same report as an Excel workbook, in three sheets. Data entry for your monthly figures by channel. Summary, where every derived metric is a live formula: change the target cell and the attainment rate follows. SEO sample, showing the query table that feeds section 4. Two native charts, editable, not screenshots.

Both use synthetic sample data and are labelled as such, so nothing has to be scrubbed before you reuse them. The assumptions block in the workbook holds the reporting period, currency, metric definitions, and the editable target — change the target there and every comparison updates.

How to use them

  1. Open the workbook, replace the data entry sheet with your month, and set your target in the assumptions block
  2. Read the summary sheet and pick the three to five metrics that support one verdict
  3. Open the document, write section 5 first, then section 1, then fill the rest
The faster path Generate your own instead of editing ours The two templates below are a good month one. From month two, running the recipe against your own client data takes less time than filling them in.
Download Orkas — free

Generate this report for your own clients

Both files were generated rather than hand-built, and the recipe is short enough to print. A template you can regenerate is worth more than a template you have to edit, because next month you want your own numbers in your own structure — not ours with the figures swapped. So here is the whole thing.

Step 1 — the workbook. Give this to ExcelWriter:

Build a client monthly report workbook with three sheets:

1) Data entry: enquiries and spend by channel (organic / paid search /
   social) for this month and last month, plus sessions, booked
   appointments, and phone calls.
2) Summary: compute attainment against target, cost per enquiry and its
   month-over-month change, enquiry growth, session growth, and
   appointment conversion rate. Every derived figure must be a live
   formula. Put the target in an editable cell and have the formulas
   reference it.
3) SEO sample: query / impressions / clicks / CTR (as a formula) /
   average position.

Add an assumptions block: reporting period, currency, metric
definitions, editable target, and a label marking the data as synthetic.

Charts must be native and editable: a channel enquiry bar chart starting
at zero, and a cost-per-enquiry comparison. Enquiries and spend are
different units — do not put them on the same primary axis, split them
into two charts. Bind data series to value columns only; the category
label column is the category axis, not a series.

Step 2 — the document. Then give this to DocWriter:

Write that workbook up as a client monthly report in Word, in six
sections: verdict / against goal / what was done / the data / next
month / needed from the client. Every metric in the data section gets
one sentence of interpretation, not just a number. "Next month" must be
a specific action — never "continue optimising".

Change the channel names and the metrics to match your client and run it again. The reason it comes out consistent is the order: the workbook computes, then the document is written from the workbook, so the numbers in the prose cannot drift from the numbers in the cells. That is the failure the two-step sequence exists to prevent — someone updates a chart and forgets the paragraph above it.

Both agents run inside Orkas on your own machine — your client data never leaves it. If you would rather not run anything, the two files above work perfectly well as ordinary templates; nothing in them depends on the tool that made them.

Ready when you are Run this recipe on your own clients ExcelWriter and DocWriter are both included. Paste the two prompts above, swap in your channels, and the report builds itself.
Download Orkas — free

Frequently asked questions

What is a client report?

A client report is a recurring document a service provider sends to a paying client summarising what was done, what it produced, and what happens next. In marketing it is usually monthly and covers the channels under retainer. The term is used differently in other fields — in nursing and clinical work "client report" refers to a patient's reported symptoms, and in financial services "client reporting" describes portfolio statements sent to investors. This guide is about the marketing sense: the report an agency or freelancer sends to the businesses they bill.

What should an SEO report include?

Impressions, clicks, and click-through rate for the queries you are targeting; ranking bands rather than individual positions; indexation status if pages have been added or changed; and — most usefully — the queries where demand exists but you are not yet capturing it. That last item is what turns an SEO report into a plan. Leave out rank-tracker screenshots and any keyword list longer than the client will read. A position with no click data attached does not tell anyone whether the ranking is worth having.

How often should I send client reports?

Monthly, within five working days of month end. Weekly reporting to clients is almost always a mistake: marketing results are too noisy at that interval, so weekly reports either manufacture significance from noise or admit there is nothing to say. Keep a weekly check for yourself — it can be a spreadsheet nobody else sees — and reserve the client-facing document for the cadence at which the numbers actually mean something.

What is the difference between a client report and a status report?

A client status report answers "where are things." A client report answers "was this worth it." Status reports track tasks and are appropriate for project work with a defined end. Client reports evaluate outcomes against a goal and are appropriate for retainers. If you are on retainer and sending status reports, you are describing activity to someone who is trying to evaluate return — which is the fastest way to have your scope questioned.

Can I use these templates commercially?

Yes. Use them with your clients, rebrand them, change the structure, charge for the work you do in them. There is no attribution requirement and no licence to read. The sample data is synthetic and labelled, so there is nothing to remove before you reuse the files.

How long should a client report be?

Two pages, or roughly 600 to 900 words, for a typical monthly retainer. Long enough to state a verdict, show the evidence, and commit to a next step; short enough that the client reads all of it. If the work genuinely spanned many channels, keep the report at two pages and move the detail into an appendix nobody is obliged to open. Length reads as effort to the person who wrote it and as padding to the person who did not.

If the monthly report is the part of your month you most resent, the fix is usually not a better template — it is moving the mechanical half out of your hands so the hour you spend goes into section 5, where the client's money actually is. If the report keeps showing a client who is not worth the hours, that is a pricing problem rather than a reporting one — work out what you should be charging. Orkas is one way to do that; a well-built spreadsheet you never rebuild is another. Either is better than starting from a blank page on the first of the month.