Skip to content

Eight client reporting mistakes that hide your agency’s results

Most reporting mistakes are not arithmetic errors. They come from combining records that answer different questions. Each mistake below explains what goes wrong in the client conversation and what to check instead.

1. Ending the report at leads and cost per lead.

A client pays for won work, not form fills. A report that stops at lead volume leaves the agency’s contribution open to doubt, and inexpensive leads that never close can look like success.

  • Carry each lead to its recorded outcome: open, won, lost or still unknown.
  • Report won work by original source and campaign alongside lead counts.
  • Keep leads without a recorded result visible instead of dropping them from the story.

2. Calling contract value collected revenue.

A signed contract, an invoice and a payment are different events. Reporting won contract value as revenue overstates results when work is cancelled, refunded or still unpaid.

  • Label the figure as won contract value unless payments have been reconciled.
  • Record payments and refunds against the original work before reporting collected revenue.
  • Treat a missing amount as missing, not as zero.

3. Adding different currencies into one total.

A client with work in USD and CAD has no single total until someone chooses a conversion rate and date. Adding the numbers silently creates a figure nobody can check.

  • Show a separate total for each currency.
  • If you convert, state the rate, its date and its source.
  • Check imported spreadsheets for a currency column before summing amounts.

4. Giving credit when the source is unknown.

Leads arrive without campaign parameters, by phone or through forwarded emails. Assigning them to the busiest campaign makes it look stronger than the records support.

  • Keep unknown source and campaign values as unknown.
  • Show how many leads have unknown attribution so the client sees the gap.
  • Fix capture at the form or call-tracking step rather than in the report.

5. Mixing submission dates with close dates.

A March report can mean leads submitted in March or jobs closed in March. Comparing one with the other makes conversion rates move for reasons unrelated to the campaigns.

  • State the date basis on every report.
  • Group leads by submission date and let later outcomes stay with that group.
  • Compare spreadsheet summaries with native reports only when they use the same date basis.

6. Counting the same lead twice.

The same enquiry can appear in a form export, the CRM and a call log. Combining exports without matching them inflates lead counts and makes cost per lead look better than it is.

  • Match records by a stable identifier, not by name or email address alone.
  • Explain skipped duplicates and exclusions before comparing totals.
  • Keep imported spreadsheet totals separate from native and CRM totals until they are reconciled.

7. Treating a refreshed report as a healthy CRM sync.

A report can load instantly and still show outcomes from a sync that failed days ago. The client then sees open leads that were already won or lost.

  • Check the last successful CRM sync, not only when the report was fetched.
  • Investigate failed or stalled syncs before the client review.
  • Mention known delays in the report rather than waiting for the client to find them.

8. Reporting return before the inputs are complete.

Return on ad spend from an ad platform uses that platform’s conversion value. Profit return needs collected payments, refunds and the direct and marketing costs of the work. Reporting either with missing inputs overstates the result.

  • Name the measure: platform ROAS, collected ROAS or profit ROI.
  • Wait for complete payment and cost records before reporting profit return.
  • Show which inputs are missing instead of filling them with estimates.

From the blog

See every blog post

Build a report that avoids all eight.