Peter StuartGet in touch

How to track lead quality with a simple spreadsheet

By Peter Stuart · 31 October 2026 · 5 min read

You cannot tell whether a channel works without recording what happens to each enquiry. A spreadsheet is enough. It takes a minute per lead and turns opinions into numbers.

The columns

ColumnWhat to record
Date receivedThe day the enquiry arrived
SourceWhere it came from: your site, a lead supplier, Google Ads, referral
ServiceWhat they asked for
AreaTown or postcode area
ContactedYes or no, and when
Quote sentYes or no, and the amount
OutcomeWon, lost, no response, not suitable
Job valueWhat you earned if won
NotesWhy you lost, what the customer said

The numbers to work out

  • Contact rate: leads you reached divided by leads received.
  • Quote rate: quotes sent divided by leads reached.
  • Win rate: jobs won divided by quotes sent.
  • Cost per customer: what you paid for the leads divided by jobs won.
  • Revenue per lead: total job value divided by leads received.

Compare these across sources. A source that sends fewer leads but wins more may be the better buy.

Review weekly, not yearly

Spend ten minutes a week. Look for patterns. Are leads from one area poor? Do you win more when you reply within an hour? Are there services you keep getting asked for and don't offer?

Give feedback to your supplier

If a lead was outside your area or had fake details, tell the supplier with the evidence. A good one will use it to improve the source. If you are testing a new channel, ask whether they will agree a clear definition of a qualified lead first.

The test for any channel is cost per customer over a few months, not one good or bad week. See pay per lead vs Google Ads.

Related guides

Leads by service

Got a service and an area in mind?

Tell me what you do and where you cover. I'll tell you plainly whether a site could work for you.

Talk to me about your area