By The Tool Trial Editorial Team
Most leads are not lost to competitors. They are lost because nobody could say, on a Tuesday afternoon, which inquiries were still open and who was supposed to do something about them.
Inquiries arrive by phone, web form, text, and profile page. Each lives in a different inbox, and none of them tells you what happens next. A tracker is one table answering four questions: what came in, what state it is in, what the next action is, and who owns it.
This is a manual system. It is a spreadsheet, or a table in whatever tool you already have. It sends nothing, scores nothing, and decides nothing.
This is practical editorial guidance, not legal advice, and it does not guarantee compliance with any law, rule, or platform policy.
What this tracker is — and what it is not
It is a status board, not a CRM. Its job is to make open work visible. If a tool you already pay for does this well, use that — the design below is what matters, not the software.
It is not a contact database. The point is to store as little as possible about people while still being useful. Several fields exist specifically to keep information out.
It does not send anything. No email, no text, no automated customer reminder. Every message a person receives is written and sent by a person, deliberately.
It does not score or predict. No lead quality rating, no likelihood-to-close percentage, no AI-assisted ranking. A stage says where something is, not how promising it is.
It is untested, and no result is claimed. Nothing here promises more bookings, more revenue, faster response, or recovered leads. No such measurement exists.
What to prepare before you use it
Four things, and none of them is software.
Decide who owns the table. One person keeps it current. Shared ownership means nobody updates it.
List the channels inquiries actually arrive through. Phone, web form, text, profile message, walk- in, referral. You cannot log what you have not accounted for.
Write down which contact channels your business controls. A phone line you answer, an email you monitor, a form on your own site. These are the only channels the tracker should point to.
Decide who may contact someone, and on which channel. This is a business decision, not a spreadsheet field. The field only records what was decided.
The essential fields
Fifteen columns. Each one exists to answer a question you will actually ask.
| Field | What it holds |
|---|---|
| Lead reference | An internal identifier such as LEAD-2026-0142. Not a name |
| Date received | When the inquiry arrived |
| Inquiry source | The channel it came through — phone, form, text, profile, referral |
| Service category | What kind of work was asked about, in your own terms |
| Service-area status | Whether it is inside the area you serve: yes, no, or unclear |
| Contact permission status | What the person actually agreed to, and through which channel |
| Preferred approved channel | The channel you may use, chosen from channels you control |
| Assigned owner | The person responsible for the next action |
| Current stage | One of the nine stages below |
| Last contact date | When someone from the business last made contact |
| Next action | One specific thing, phrased as a verb |
| Next follow-up date | The date that action is due |
| Outcome | Booked, not booked, or blank while open |
| Minimal notes | The shortest useful line. Not a transcript |
| Do-not-contact status | Yes or no. Yes overrides everything else |
Use an internal reference, not a person’s name, as the key. A name is often unnecessary for knowing what to do next, and using a reference keeps the working table usable by anyone without exposing more than the task requires.
Store only what the next action needs. Do not add full names when a reference will do, and do not add street addresses, medical information, financial details, identity documents, conversation transcripts, or information about third parties. If the work genuinely requires a detail, keep it where such records belong — not in the status board.
The follow-up stages
Nine stages. No scores, no predictions, no automatic movement between them.
| Stage | What it means | When to use it | Allowed next action | How it ends |
|---|---|---|---|---|
| New | Logged, nothing checked yet | The moment an inquiry is recorded | Review the inquiry | Someone reviews it |
| Verification needed | Something must be confirmed before contact | Service area, permission, or the request itself is unclear | Check the missing item | The question is answered |
| Ready for follow-up | Verified and cleared to contact | Area confirmed, permission confirmed, owner assigned | Make the first contact | Contact is made |
| Contacted | The business has reached out | A person sent or made the approved contact | Wait, or set a follow-up date | A reply arrives, or the date passes |
| Awaiting reply | Ball is in their court | Contact made, response expected | Wait until the follow-up date | They reply, or the date arrives |
| Follow-up due | The date arrived with no reply | The follow-up date has passed | Make one further approved contact | Contact is made, or the lead is closed |
| Booked | Work or an appointment is scheduled | Confirmed by the customer | Hand off to whoever delivers | It leaves the tracker |
| Closed — not booked | Finished without a booking | Declined, gone quiet after your limit, or out of area | None. Record the outcome | It stays closed |
| Do not contact | The person asked not to be contacted | Any request to stop, on any channel | None. Stop contact | It does not end |
Do not contact is not a pause. It is terminal, it overrides every other stage, and no follow-up date applies to it.
How to log a new inquiry
Log it the same day, in under a minute. Assign the reference, record the date and source, note the service category in a few words, and set the stage to New.
Then leave it. Logging is not deciding. The temptation is to check the service area, guess at the budget, and write three lines of impressions while it is fresh — which produces a table full of opinions instead of a table full of open work.
If you already know something is missing, set the stage to Verification needed and write the specific question in the next action.
How to define the next action
A next action is one specific thing, phrased as a verb, that a named person can do on a named date.
“Follow up” is not a next action. Neither is “check in.” Both describe an intention. “Call to confirm the address is inside our service area” is an action, because you can tell whether it happened.
Every open record needs three things together: an action, an owner, and a date. Two out of three produces a lead that quietly stops moving. If you cannot name all three, the correct next action is usually to find out what is missing.
One next action at a time. A record with four planned steps is a plan, not a status board, and plans age badly.
A short daily routine
Five minutes, at a consistent time.
- Log anything that arrived since yesterday and set it to New.
- Open the records whose follow-up date is today or earlier.
- For each one, do the action, or move the date with a reason.
- Update the stage and the last contact date for anything you acted on.
- Anything set to Do not contact — confirm it is out of the follow-up list.
The habit that matters is step 3. A date that slides repeatedly without a reason is how a lead becomes permanently open without anyone deciding to close it.
The weekly review
Once a week, look at the table as a whole rather than record by record.
Check for records with no owner, no date, or no next action. Check for anything sitting in one stage longer than your own limit, and for Verification needed items waiting on an answer nobody chased. Close what should be closed — the most common weakness of a manual tracker is not missed follow-ups but records nobody was willing to mark Closed — not booked.
Then confirm the table still contains only what it needs. If notes have grown into transcripts, trim them.
Privacy and data minimization
As an editorial safeguard, we recommend keeping this table as small as it can be while still telling you what to do next.
Record the minimum. Use the internal reference as the key. Leave out full names where they are not needed, and leave out addresses, health information, financial details, identity documents, and anything about people other than the person who contacted you.
Notes are one line. Not a conversation record. If a detail matters enough to keep at length, it belongs in your business records, not in a shared status board.
Limit who can open it. Access belongs to the people who work the leads. Do not publish the table, do not share it publicly, and do not paste it into anything you do not control.
Nothing here is privacy-law advice. What you may collect, keep, or store depends on your business and your obligations, and this article does not assess either.
Permission and official channels
Logging an inquiry is not permission to contact someone however you like. The tracker records what a person agreed to; it does not create that agreement.
Use only channels your business owns and controls — a line you answer, an address you monitor, a form on your own site. Record which channel was approved, and use that one.
Check permission before sending email or messages. Two U.S. agencies publish relevant material, both cited below. The FTC’s CAN-SPAM guidance concerns commercial email, including honoring an opt-out request within ten business days. The FCC’s guidance concerns autodialed and prerecorded calls and texts, which require prior consent, and states that a person may opt out at any time even if they previously consented.
Neither is a compliance verdict on your business. Requirements depend on what you send and how, so confirm the rules that apply to you before any commercial outreach. This article does not assess your obligations and does not guarantee compliance.
Honor a request to stop, immediately and on every channel. Set the stage to Do not contact, and treat it as permanent unless the person themselves says otherwise.
When to stop following up
Decide your limit in advance, before a specific lead makes it personal. A common shape is a small number of approved contacts across a set number of weeks, then close.
Stop earlier when the person asks you to stop, when the request is outside what you do or where you work, or when you cannot establish that you have permission to make contact.
Closing is not failure. A record marked Closed — not booked is finished work; a record left open forever is a decision nobody made.
When a simple sheet is no longer enough
A table stops being the right tool when several people need to write to it at once, when you need a real history of what was said, when access must be restricted per person, or when the volume means the daily routine no longer fits in five minutes.
Those are reasons to look at something else — not reasons to bolt automation onto a spreadsheet. We do not recommend a specific product, and we have not tested any tool for this purpose.
A synthetic example
This example is fictional. No real business, customer, inquiry, or transaction is involved, and it is not evidence of how this tracker performs.
A fictional two-person cleaning service receives a web-form inquiry about a recurring booking. It is logged the same day as LEAD-EXAMPLE-004, source Web form, category Recurring clean, stage New, with no name recorded because none is needed yet.
The next morning it moves to Verification needed — the form left the location unclear — with the next action “Confirm the address is inside the service area”, owner Owner, due that day. Once confirmed, it becomes Ready for follow-up, with the approved channel recorded as the business phone line.
After the first call it becomes Awaiting reply with a date four days out. The outcome column stays blank, because nothing has been agreed and a tracker that records optimism is not a tracker.
Final takeaway
The value is not in the columns. It is in a table small enough that someone updates it daily, honest enough to show what is stalled, and disciplined enough to close what is finished.
Related resources, once they exist: a full lead follow-up workflow from new inquiry to booked call, follow-up email templates, and guidance on using AI for follow-up with human approval — all planned, none published yet.
Sources
- Federal Trade Commission — CAN-SPAM Act: A Compliance Guide for Business:
https://www.ftc.gov/business-guidance/resources/can-spam-act-compliance-guide-business - Federal Communications Commission — Stop Unwanted Robocalls and Texts:
https://www.fcc.gov/consumers/guides/stop-unwanted-robocalls-and-texts
Both pages were checked on 2026-08-12. The FTC page supports what is said above about commercial email: that the law covers commercial messages, and that an opt-out request must be honored within ten business days. The FCC page supports what is said about autodialed and prerecorded calls and texts: that they require prior consent, and that a person may opt out at any time in any reasonable manner even if they previously gave consent.
Neither page addresses lead tracking, spreadsheets, or how a business should record inquiries, and neither is cited for anything beyond the statements above. The tracker design, the fifteen fields, the nine stages, the routines, and every privacy recommendation are editorial guidance developed by The Tool Trial, not requirements from either agency.
This article is not legal advice and does not establish that any practice complies with CAN-SPAM, the TCPA, or any other law or rule. Requirements change and depend on your circumstances; check the current official guidance before starting commercial outreach.