Lead Tracking: the five stages most small businesses skip, and where the spreadsheet stops working

Lead tracking is the record of every enquiry from the moment it arrives until it is won, lost or parked, with a timestamp on each step. Five stages make it work: capture into one place, a first response with a clock, qualification against written criteria, a follow-up sequence with an end, and a close-out state. Most small businesses skip three.

The demand behind this topic has a shape worth naming. Google's autosuggest for "lead tracking", pulled from South Africa on 20 September 2026, returns ten suggestions and all ten are genuine. After the head term come "software", "meaning", "spreadsheet", "system", "sheet", "dashboard", "spreadsheet template" and "tools". That is an owner running leads from a spreadsheet, or about to, and wondering whether it will hold. This post lays out the five stages a lead passes through, what the research says about the two stages where the money is actually lost, where a spreadsheet stops being able to do the job, and how the whole thing runs with less typing. It sits between two posts already on this site: speed to lead, which is about the clock on stage two, and client onboarding, which is what happens after stage five when the answer is yes.

Key takeaways

• A lead tracking process has five stages: capture, first response, qualification, follow-up, close-out. The first and the last are the ones most businesses do not have at all.
• The clock matters more than the script. In the Harvard Business Review audit of 2,241 companies, 37 percent replied to a web enquiry within an hour and 23 percent never replied. In the 2007 vendor study analysed by Oldroyd, the odds of making contact drop five times between a five-minute and a ten-minute response.
• Following up on an enquiry is answering a question. Adding that person to a mailer is direct marketing, and POPIA section 69 permits electronic direct marketing only with consent or to an existing customer, with one lawful request for that consent.
• A follow-up sequence needs a written end. A lead that is never closed out is not a lead, it is a row nobody edits any more.
• A spreadsheet can hold the record. It cannot start a clock, send a reminder, keep a history of touches, or show two people the same lead at once. Those four are the reason lead tracking moves to a system.

What is lead tracking, and what is it not?

Lead tracking is not lead generation. Generation is the work of making enquiries arrive: adverts, referrals, a website, a listing. Tracking starts the second one lands and ends when the lead reaches a final state. The two get conflated because the same person usually does both, but the failure modes are different. A generation problem is an empty inbox. A tracking problem is a full inbox and no idea which of the enquiries in it were answered.

It is also not the same thing as a sales pipeline, although they overlap. A pipeline is the view of every open opportunity by stage and value. Lead tracking is the record behind each row in it, and it covers the leads that never became opportunities at all, which in most small businesses is the majority. If your pipeline view only shows the deals you are working, the leads you dropped in week one are invisible, and the reason they were dropped is unrecorded.

The five stages of a lead management process

Stage one: capture, once, into one record

Every enquiry writes into one record with the channel it arrived on, the time it arrived, what was asked, and who owns the reply. This is the stage most small businesses believe they have and do not. The website form goes to one inbox. The listing portal goes to another. WhatsApp goes to somebody's personal phone. Phone calls go nowhere. Each of those is a capture point, and none of them is a record, because a record is something a second person can open and read.

The test is simple: at 19:00 on a Thursday, can anyone in the business see every enquiry received that day in one list, without opening four apps? If the answer is no, the clock in stage two starts at whenever somebody next checks, not at the moment the customer asked. The WhatsApp CRM guide covers the single largest change here for most South African businesses, which is moving WhatsApp enquiries off a personal number and into a record.

Stage two: first response, with a clock on it

This is the stage the research is about, and the numbers hold up when read from their sources rather than from a roundup. The Harvard Business Review audit published in March 2011 sent a test web enquiry to 2,241 United States companies and timed the reply. 37 percent replied within an hour. 23 percent never replied. The widely quoted 42-hour average is the mean among the companies that did reply within 30 days, not the average business, because a quarter of the sample cannot be averaged in.

The 2007 study analysed by Dr James Oldroyd, copyright InsideSales.com and built on that company's own platform data across six companies, reports that "the odds of contacting a lead if called in 5 minutes versus 30 minutes drop 100 times" and that "the odds of qualifying a lead if called in 5 minutes versus 30 minutes drop 21 times". The line from the body of that paper that nobody quotes is the operational one: from five minutes to ten minutes, the contact odds decrease five times and the dial-to-qualify odds decrease four times. The decay is front-loaded. The same paper states plainly that it "did not address close ratios", so none of this is a conversion claim. It is a claim about whether you get the conversation at all.

The practical rule that falls out of it: the first response is an acknowledgement with a next step, sent inside the window you can actually keep, and the record shows when it went. The full trace of every speed-to-lead figure, including the one that has no source, is in speed to lead.

Stage three: qualify, against criteria you wrote down

Qualification is the decision about whether this enquiry is worth the next hour of your time, and it goes wrong in two directions. Without written criteria, every lead gets the same effort, which means the good ones get too little. With criteria that live in one person's head, nobody else can apply them, so the business qualifies leads only when that person is at their desk.

Four questions do the job for most service businesses: is the thing they want something you actually sell, is the timing real or someday, is the person asking the one who decides, and is there a concrete next step both sides have agreed to. The answer to each is recorded on the lead, not remembered. A lead that fails two of the four is not dropped; it is parked with a date, which is stage five's job.

There is a legal line inside this stage that most guides skip. Replying to a person about the thing they asked for is answering a question. Adding that person to your monthly mailer because they once enquired is direct marketing, and the Protection of Personal Information Act treats those differently. Section 69 permits direct marketing by electronic communication only where the person has consented or is an existing customer, and a non-customer may be approached to ask for that consent only once. Our section 69 guide reads the Act, the gazetted Form 4 and the Regulator's Guidance Note in full. The short version for lead tracking: the enquiry gives you the right to answer it, not the right to market to them forever.

Stage four: follow up, on a sequence with an end

A follow-up sequence is a numbered set of touches, each with a date, each recorded, and a defined last one. The reason the end matters is that without it the sequence never runs. Nobody sends the fourth follow-up because nobody decided there would be a fourth, so the third one goes out late, unrecorded, and the lead drifts.

The number that circulates here is that 77 percent of leads never get a response. The source is a February 2021 announcement by XANT of a report built on 14,000 companies and 55 million sales interactions, and what it actually says is narrower: "When teams lead with marketing automation, only 23% of leads get touched by sales reps." The condition is teams that lead with automation, and the meaning is touched by a sales rep, not never answered by any means. Quoted with both restored, it is still a useful warning: an automated sequence that nobody reads the replies to is not a follow-up process, it is a newsletter with a delay.

The working shape for a small business is short. Acknowledge on arrival. Answer or quote within the window you committed to. Follow up on the quote at a fixed interval, then once more, then decide. The quotation guide covers what the quote itself has to carry; the invoice follow-up sequence is the same discipline applied after the sale.

Stage five: close out, in writing

Every lead ends in one of a small number of written states: won, lost with a reason, parked with a return date, or closed because the person went silent. This is the stage that almost no spreadsheet has, and its absence is what makes the spreadsheet unreadable after three months. Rows do not get closed. They stop being edited, and six weeks later nobody can tell a lead that was won from one that was forgotten.

The first-hand version of this: our own register carries a status column, a follow-up-sent column and a reply column beside each proposal. The three of them together are the whole close-out. Which touch went out and when, what came back, and what the row is now. A lead the owner has closed is closed on the row, with the date and the reason, so nothing downstream drafts a chase against it. The rule that came out of running it is that a closed lead leaves the follow-up sweep entirely; softening the cadence is not closing.

Where a lead tracking spreadsheet stops working

A spreadsheet is a fine record and the right place to start, and four jobs it cannot do decide when it stops being enough.

Job	What a spreadsheet does	What the process needs
Start the clock	Records the time someone typed in	Records the time the enquiry arrived, on every channel, without a person in the loop
Remind	Nothing, unless someone reads it	The next touch surfaces on its date to the person who owns the lead
Keep the history	One cell per lead, overwritten	Every touch, reply and status change with its timestamp, in order
Share the view	One file, one editor at a time, or a copy nobody trusts	Two people see the same lead, and the owner is on the record

None of those is about size. A business with fifteen enquiries a month hits all four the first time the owner is away for a week. The honest test is the reminder row: if the next follow-up depends on someone remembering to open the file, the process is a good intention.

How lead tracking runs with less typing

The automation is not a chatbot. It is the five stages with the re-keying taken out, in the same dependency order as the business process automation map.

1. Captured once. Website form, WhatsApp, email and a logged phone call all write into the same lead record, with the arrival time set by the system. Nobody copies an enquiry from an inbox into a sheet, so stage one exists whether or not anyone is at a desk.
2. Reused. What the customer typed into the enquiry becomes the opening of the acknowledgement and the first line of the quote. The same text is not re-read, re-typed or paraphrased three times.
3. Routed. The lead is assigned on arrival by a rule you wrote: by service, by area, by whoever is on. The owner of the reply is on the record before anyone has read it.
4. Reminded. The follow-up dates are set from the record when the quote goes out. On each date the next touch surfaces to its owner, with the history beside it, and a reply from the customer pauses the sequence instead of talking over them.
5. Reported. Because every lead has a state, the question "how many enquiries did we get in August and what happened to each one" is a filter, not an afternoon.

That is the shape a CRM should give a small business, and it is also the checklist for choosing one: if a tool cannot do the five things above, it is a nicer spreadsheet. The CRM selection guide covers the POPIA questions that decide it, and the free CRM comparison covers what the free tiers actually hold.

Frequently Asked Questions

What is the difference between lead tracking and lead management?

Lead management is the whole discipline, from generation through to handover. Lead tracking is the record-keeping inside it: what arrived, when, what was done, and what state each lead is in now. You can manage leads badly with perfect tracking, but you cannot manage them well without it.

How quickly should a small business respond to a new lead?

Inside the window you can keep every time. The research shows the biggest drop in contact odds between five and ten minutes, and a quarter of audited companies never replied at all. An immediate acknowledgement with a promised time for the real answer beats a perfect reply on Thursday.

How many times should you follow up on a lead?

Decide the number before you start, record each touch, and end the sequence with a written state. Two to three follow-ups after a quote is common for service businesses. The count matters less than the fact that the last one is planned and the outcome is recorded.

Can I add someone who enquired to my email list?

Not automatically. Answering their enquiry is fine. Marketing to them electronically afterwards needs consent under POPIA section 69, or they must be an existing customer. You may ask a non-customer for consent once, in the prescribed form.

Is a lead tracking spreadsheet good enough to start with?

Yes, for the record. It fails at reminders, arrival timestamps, touch history and shared ownership. When any follow-up depends on someone remembering to open the file, the process has outgrown it.

The short version

Lead tracking is five stages, and the two most businesses skip are the first and the last: capturing every enquiry into one record with its arrival time, and closing every lead out in writing. The research is clear that the clock on the first response decides whether you get the conversation at all, and the law is clear that an enquiry is permission to answer, not to market. If you want to know how many enquiries arrived last month, how long each waited, and which of them are sitting in a state nobody wrote down, that is what a Business Autopsy maps, and a discovery call is where it starts.

Sources, read directly on 20 September 2026: Oldroyd, McElheran and Elkington, "The Short Life of Online Sales Leads", Harvard Business Review, March 2011 (audit of 2,241 companies, response-time shares), as traced in our speed-to-lead guide; Oldroyd and InsideSales.com, "Lead Response Management Study", 2007, 35 pages, primary PDF hosted by MarketingSherpa (contact and qualification odds, the five-to-ten-minute decay, and the statement that the study did not address close ratios); XANT, "XANT Releases Lead Response Report with Data from 55 Million Sales Interactions", PR Newswire, 17 February 2021 (the marketing-automation condition on the 23 percent figure); Protection of Personal Information Act 4 of 2013, section 69, as quoted in our section 69 guide; Google autosuggest for "lead tracking", client firefox, gl za, pulled 20 September 2026. Every quoted phrase is the publisher's own wording. No figure in this post is a price.