If you've ever tried to figure out where your customers came from by digging through chat threads and a spreadsheet that hasn't been updated in three weeks, you've felt the problem this solves. Tracking every enquiry from first message to closed sale should be automatic — not a weekly project nobody wants. Here's the simple system that does it.

The problem with spreadsheets

Spreadsheets fail on the two things they're asked to do: they require someone to type in the data, and they require someone to remember to. Enquiries arrive at 11pm, on Sundays, while someone is on a job. By the time anyone opens the spreadsheet, the details are stale, the source is forgotten, and the follow-up that should have happened yesterday has already slipped.

The one-system rule

Every enquiry lives in one place — a CRM — and nowhere else. The moment an enquiry arrives (message, form, call), it's in the system, attached to its source. Nobody types anything to create it. The spreadsheet of leads gets retired, not because spreadsheets are evil, but because the system already did its job.

What each enquiry carries

Four things, captured automatically or with minimal input:

  • The conversation — the full message thread, attached to the record.
  • The source — where it came from: ad, search, referral, listing, walk-in.
  • The stage — where it is right now: new, sorted, quoted, follow-up, closed.
  • The next action — what should happen next, and who owns it.

Those four pieces let anyone pick up any enquiry and know exactly what's going on — without asking the person who handled it last.

How the tracking stays honest

Two habits keep the tracking real. First, the stage changes happen at real moments — when a quote is sent, when a viewing is booked, when a deal closes — not at end-of-week summaries. Second, the closed-customer step is mandatory: every enquiry ends as either a customer or a clear no, so the numbers you report are the numbers that happened.

What you get from it

One honest answer every week: how many enquiries, from where, at what cost, and how many became customers. No digging, no debate, no stale spreadsheet. The tracking system's real payoff isn't the report — it's that growth becomes something you can see while it's happening, instead of something you reconstruct after the fact.