Start with the fields that matter
Many owners avoid tracking because they picture a giant CRM with too many fields. A simple tracker can start in a spreadsheet and still make a big difference.
The best tracker is the one the business will actually use every day.
Recommended lead tracker columns
- Date received
- Customer name
- Phone or email
- Lead source, such as Google, website, Facebook, referral, or repeat customer
- Service requested or customer need
- Status, such as new, contacted, quoted, booked, won, lost, or follow-up needed
- Next step
- Follow-up date
- Estimated value, if useful
- Notes
A tracker without a next step becomes a list. A tracker with next steps becomes a simple sales system.
How to use it each week
Review the tracker at least once or twice a week. Look for new leads that have not been contacted, quotes that need follow-up, and old leads that should be closed out or revived.
Over time, the tracker also shows which lead sources are working. If most good leads come from Google, referrals, or one Facebook post, that is useful marketing information.
When to automate it
Once the manual tracker makes sense, automation can help. A website form can add a row. A notification can alert the owner. AI can summarize the request. A reminder can be created for follow-up.
The right order is important: understand the workflow first, then automate the parts that are repetitive or easy to miss.