- Published
- Byline
- GoHighLevel Partners Editorial
- Filed under
- GoHighLevel Automation
Short and specific: what was done, what changed, and what happens next — with every figure traceable to something you could show.
Accomplishment report in Google Sheets: what a client should see monthly
Most agency reporting fails in one of two directions. It is either a dashboard export nobody reads — forty metrics with no argument in them — or a paragraph of reassurance with no numbers behind it. What a client actually wants is short and specific: what was done, what changed, and what happens next.
A spreadsheet is a good home for that, not because it is sophisticated but because it is transparent, cheap to produce, and can be traced back to source. It is a different document from an audit trail of what automations did: that one exists so you can debug an automation, and this one exists so a client can decide whether to keep paying.
Three sections, and nothing else
| Section | What it holds | What it answers |
|---|---|---|
| Done | Work completed this period, in plain terms | What am I paying for? |
| Changed | A small set of numbers, with the previous period beside them | Is it working? |
| Next | What happens in the coming period, and anything you need | What now? |
The third section is the one agencies leave out and the one clients value most, because it is the only part that describes the future. It is also where you ask for the thing that has been blocking work for three weeks, in writing, where it is on the record.
Choose few numbers, and keep them
A report with forty metrics communicates that nobody decided which mattered. Choose four or five that connect to the outcome the client cares about, and report the same ones every period — a metric that appears in a good month and vanishes in a bad one destroys trust in all the others.
The useful ones are usually further down the chain than the ones that are easy to collect. Leads is easy; qualified leads is better; booked appointments is better again; work won is what the client is actually buying. measuring pipeline conversion is the framing, and pipeline stages and exit criteria is what makes each of those countable rather than a matter of opinion.
Show the previous period, and the direction
A number on its own is not information. Twenty-two leads is good or bad depending entirely on what last month was, and a client with no comparison will supply their own — usually an optimistic memory. Put the previous period in the next column and let the comparison do the work.
Where a number moved for a reason that is not performance, say so in the same row. A tracking change, a consent banner going live, a seasonal effect: all of these move numbers without anything improving or worsening. why platform conversion counts differ and reading a funnel exploration both describe measurement changes that look exactly like results, and a report that does not flag them is teaching the client something untrue.
Build it so it is not an hour of copying every month
A report assembled by hand is a report that arrives late and eventually stops. Structure the sheet as a raw data tab that is appended to, and a presentation tab that reads from it, so the monthly job is refreshing data rather than rebuilding a document.
Getting the data in has three routes, in increasing order of effort and control: an export pasted into the raw tab, building an integration without code writing rows automatically, or a direct pull using getting API access safely. a webhook payload is the mechanism for appending a row the moment something happens rather than in a batch. Start with the export — a report that exists beats an integration that is still being built.
The numbers have to be defensible
Every figure in the report should be traceable to something you could show if asked. That is a discipline rather than a formality: a number nobody can source is a number that gets quietly rounded in the right direction over time.
Two habits keep it honest. Record the definition of each metric beside it — what counts as a lead, what counts as qualified — because those definitions drift and the drift looks like growth. And make sure the underlying data is maintained: a report on appointments is only as good as what each appointment status claims, and a report on list size means nothing without keeping the contact database usable.
Write the commentary, and keep it short
Numbers do not explain themselves. Two or three sentences per section, saying what you think happened and what you are doing about it, turns a spreadsheet into a conversation. Avoid the two failure modes: a wall of explanation when the results are poor, and silence when they are good.
Report the bad periods plainly. A client who finds out a month late that something stopped working loses confidence in every report that preceded it, and that is a much larger loss than the bad month. This is one of the more direct contributors to the mechanics of retention, and it is closely tied to whether what drives a monthly fee feels justified from the client’s side.
Make it repeatable
- One tab for raw data, appended never overwritten.
- One tab for the client view, formulas only.
- The same metrics, in the same order, every period.
- Previous period beside current, always.
- A definitions note for every metric.
- A fixed day of the month, so it arrives before it is asked for.
Write the process down — structure, owners and exceptions in an SOP is the shape — because reporting is the first thing to slip when the month is busy, and the whole value of it is that it is regular. A report that arrives on the same day every month is evidence of a business being run; one that arrives when chased is evidence of the opposite, regardless of what the numbers say.
Frequently Asked Questions
What should a monthly client report contain?
Three sections and nothing else: what was done, what changed with the previous period beside it, and what happens next. The third is the one most often omitted and the one clients value most, because it is the only part describing the future.
How many metrics should be in the report?
Four or five, chosen because they connect to the outcome the client is buying, and the same ones every period. Forty metrics communicates that nobody decided which mattered, and a metric that appears in good months and vanishes in bad ones destroys trust in all the others.
Why include the previous period?
Because a number alone is not information. Without a comparison the client supplies their own, usually an optimistic memory. Put last period in the adjacent column and note any reason a figure moved that was not performance, such as a tracking or consent change.
Is a spreadsheet good enough, or do I need a dashboard?
A spreadsheet is often better. It is transparent, cheap to produce, and every figure can be traced to a source. A dashboard that nobody reads and nobody can audit is worse than a short sheet with five numbers and three sentences of commentary.
How do I stop the report taking an hour every month?
Separate a raw data tab that is only appended to from a presentation tab of formulas, so the monthly job is refreshing data rather than rebuilding a document. Start with a pasted export; automate the collection later if the report has proved it is read.
Should I report a bad month?
Plainly and promptly. A client who discovers a month late that something stopped working loses confidence in every report before it, which costs far more than the bad month itself. Say what happened and what you are doing about it.
How is this different from an automation audit log?
Different audience and different purpose. An audit trail exists so you can debug what an automation actually did. This report exists so a client can decide whether the arrangement is working. Mixing them produces a document that serves neither.
We build your GoHighLevel account for you
CRM, pipelines, funnels, SMS and automation — configured for your business, not left for you to figure out.
- Setup (one-time)$850
- Ongoing (per month)$38.80
No obligation quote · reply within 1 business day
This site is independently operated and is not officially affiliated with, endorsed by, or sponsored by HighLevel LLC. We do not receive referral commissions — this is our own flat-fee implementation service.