Document
Simple Service Business Lead Tracker
A plain-language tracker structure for service businesses that need one visible place for open inquiries, callbacks, quotes, and stale opportunities.
Simple Service Business Lead Tracker
You do not need a perfect CRM to start fixing follow-up.
You need one trusted place where open opportunities stop depending on memory.
This tracker can live in a spreadsheet, CRM, board, database, or simple internal page. The tool matters less than whether every open item has the same minimum fields.
Required fields
Use these columns first:
- received date
- client or company name
- contact person
- phone or email
- source
- request type
- status
- owner
- next step
- follow-up date
- last touch
- notes
- outcome
If a field does not help the team take action, leave it out for now.
Useful statuses
Start with plain statuses the team understands:
- new
- replied
- needs callback
- waiting on client
- quote needed
- quote sent
- booked
- stale
- closed won
- closed lost
- bad fit
Avoid vague statuses like open, active, or pending unless everyone agrees what they mean.
Daily review view
Every day, the team should be able to filter for:
- new requests not answered
- follow-ups due today
- callbacks due today
- quotes sent but not followed up
- stale open items
- items with no owner
- items with no follow-up date
This is where the time savings usually starts. The team stops rebuilding the list from inboxes and memory.
Weekly cleanup view
Once a week, review:
- anything stale for more than 7 days
- records with no outcome
- leads that should be closed
- repeat sources of missing context
- statuses nobody uses
- handoffs that keep needing clarification
The goal is not to keep every lead forever. The goal is to know what is still alive.
The rule that makes it work
Every open opportunity needs:
- status
- owner
- next step
- follow-up date
- outcome when closed
If one is missing, the item is fragile.
First implementation
Do not migrate everything first.
Start with the last 20 real inquiries or quotes. Put them into the tracker and ask:
- who still needs a reply?
- who needs a quote follow-up?
- who said to call later?
- what can be closed?
- what has no owner?
That first pass usually shows the follow-up leak faster than a long strategy session.