Skip to content

A client reporting template you can check against the leads

Start with a free, ungated CSV that opens in Excel or Google Sheets. Use one row per lead to connect its source and campaign to the recorded outcome. The template tracks leads and contract values; it does not calculate collected revenue, profit or advertising return.

Illustrative records only. These are invented examples, not customer results. The table shows selected columns from the blank CSV.
Lead IDSourceCampaignOutcomeRecorded contract valueCurrency
DEMO-01GoogleSearch AWon1,200USD
DEMO-02MetaCampaign BOpen—USD
DEMO-03GoogleSearch CWon800CAD
DEMO-04UnknownUnknownUnknown—USD

What the client reporting template includes.

The download contains ten column headings and no customer records. Keep a separate file or clearly separated table for each client. Record the reporting period and timezone alongside the table before adding data.

  • Lead ID identifies the original record. Lead date is its submission date; Source and Campaign preserve what was actually recorded.
  • Service area holds known geographic context. Outcome and Outcome date describe the recorded result and when it was entered.
  • Recorded contract value and Currency describe the agreed job amount. Next action explains the follow-up or missing evidence.

Fill one row per original lead.

Use stable identifiers rather than names as your record key. If the same lead appears in a form export and a CRM export, reconcile the two records before treating them as separate enquiries. Record zero only when the amount is known to be zero.

  • Preserve unknown source, campaign, outcome or amount as unknown. A blank amount is not a zero-valued sale.
  • Choose consistent outcome names and document how your client’s CRM stages map to them.
  • Use dates with an explicit year and agree on a timezone. Keep submission dates separate from outcome dates.

Read the example without overstating the result.

The illustrative table has four lead records: two won, one open and one with an unknown outcome. Won contract value is USD 1,200 and CAD 800, shown separately. Adding them into a single revenue total would mix currencies and confuse contracts with payments.

  • The open record stays open. The unknown outcome needs investigation; neither is automatically lost.
  • The example does not contain ad spend, collected payments, refunds or costs, so it cannot support ROAS or profit ROI.
  • Before sharing a summary, open the original records and confirm that the dates, outcomes and amounts match the selected client.

Turn the rows into a useful client conversation.

Start the review with the client’s question: which campaigns generated enquiries, which leads have recorded wins, and which records need attention? Summarize counts by source and campaign, then keep a direct path back to the rows behind each total.

  • State the selected period, timezone and whether you grouped by submission or outcome date.
  • List missing sources, unrecorded outcomes and exclusions with the summary instead of hiding them.
  • Agree the next action and responsible person for each unresolved record. Avoid publishing personal contact details in a shared report.

Know when the spreadsheet needs a separate financial view.

A won job and a payment answer different questions. If your client asks about collected revenue or return, reconcile payments and refunds to the original work, record the relevant costs, and use a consistent currency and reporting scope. This lead template has no payment ledger.

  • Keep contract amounts, money collected and advertising conversion values under separate labels.
  • Do not calculate return from incomplete costs or an unmatched advertising period.
  • In Attrival, return on ad spend uses the sold value recorded on leads tied to the client’s ads, kept apart from any payment ledger you run elsewhere. Ad spend can come from connected Google Ads, TikTok, Pinterest and X accounts; Meta Ads is not open yet.

Move from a template to a client workspace when needed.

Use the spreadsheet while the reporting process is simple enough to review manually. If you need separate client access, a repeatable campaign drill-down or reviewed imports, prepare the file for the intended Attrival workspace rather than copying a combined agency total.

  • Choose the historical-lead import for individual lead records, or a separate spreadsheet report for lead-level or monthly-summary reporting.
  • Map the columns, review duplicates and dates, and confirm the destination before importing. No particular column name guarantees an automatic match.
  • Imports are snapshots. The CSV has no formulas, automation or live connection, and importing historical records does not start follow-up messages.

From the blog

See every blog post

Move the template into a client workspace.