Lead Tracking: One Sheet, Seven Columns, No CRM Yet

Every article in this series ends up pointing at the same missing object: the follow-up piece assumes you know when each lead arrived, the qualification piece assumes you know what happened to them, the budget piece assumes you know which customers came from ads. In most small businesses none of that is written anywhere. Leads live in one person's WhatsApp, half a notebook, and memory. The fix is one sheet, seven columns, and a two-minute habit.

This is deliberately not a pitch for a CRM. A CRM is worth it once the habit exists. Bought before the habit, it becomes an expensive place where leads go unrecorded. The sheet builds the habit; the software can inherit it later.

The seven columns

• Date and time the enquiry arrived, not the day you got around to logging it
• Name and number, enough to find the conversation again
• Source: where they came from. Ask every single one: "By the way, how did you find us?" The answer is one of five or six strings: Google ad, Google search, Facebook, referral, walk-in or repeat
• What they wanted, in five words: "Delhi-Toronto senior fare", "name correction", "group booking"
• First reply time: when someone actually answered them
• Status, one word from a fixed list: new, talking, quoted, won, lost, quiet
• Value, filled in only when won, the margin if you know it and the booking amount if you don't

Nothing else. Every extra column you add is a reason someone stops filling it in. The sheet's whole power is that it stays alive.

Who fills it, and when

Whoever answers the enquiry logs it, immediately, before replying if possible. The rule that makes this stick is blunt: an enquiry that is not on the sheet does not exist, and nobody gets credit for closing a lead that was never logged. Two minutes per lead, and the rule survives busy days precisely because it is small.

One person owns the sheet weekly, usually the owner at first. Owning it means fifteen minutes every Monday: mark the leads that went quiet, chase the ones stuck at "quoted", and read the week's numbers.

What the sheet starts telling you within a month

Which source actually pays. Thirty leads from Facebook and two bookings; eleven leads from Google and six bookings. That single comparison, impossible without the source column, reallocates budget better than any dashboard.

Where leads die. Count the statuses. Many "new" that never became "talking" is a reply-speed problem. Many "quoted" that never became "won" is a pricing or follow-up problem. Many "talking" that drift to "quiet" is a qualification problem. Each has a different fix, and the sheet points at the right one instead of the loudest one.

What a lead is worth per source. Total value won from a source divided by its lead count. This is the number the ad-budget arithmetic needs, and it comes free from columns three and seven.

The Monday fifteen minutes

Read four numbers aloud, weekly, same order: leads in, median first-reply time, quotes out, bookings won. Write them at the top of the week's section. When a number moves, ask why once, fix one thing, and check next Monday whether it moved back. That loop, repeated, is most of what a marketing consultant would do for you, running on a spreadsheet that costs nothing.

When to graduate to real software

When the sheet has survived three months and any of these is true: two or more people update it at once and overwrite each other, lead volume passes a few hundred a month, or you need automatic reminders because Monday chasing takes an hour. Move to a CRM then, and import the sheet, because by that point you know exactly which fields matter and which reports you read. The tool serves the habit instead of replacing it.

FAQ

My team says they have no time to log leads. What then?

Logging takes less time than one WhatsApp reply. The honest translation of "no time" is "no consequence": pair the rule that unlogged leads earn no credit with the owner visibly reading the sheet every Monday, and the time appears.

Should phone calls go on the sheet too?

Yes, every enquiry regardless of channel: calls, WhatsApp, walk-ins, Facebook messages. The sheet is only trustworthy if it is complete, and sources can only be compared when they are all present.

Customers sometimes name two sources, like "saw the ad, then a friend confirmed". Which do I log?

Log the first touch, the thing that started it, and keep a habit of noting the second in the "wanted" cell when it seems to matter. Perfect attribution does not exist even at large companies; consistent good-enough attribution beats none by a mile.