Funnels and follow-up8 min readUpdated 1 November 2026
Simple lead tracking:
do you need a CRM?
Simple lead tracking for small businesses: what to record, when a spreadsheet is enough and when you need a CRM.
In this guide

Key takeaways
- Most small businesses do not know which marketing brings customers. A simple record fixes that.
- Start with a spreadsheet. Move to a CRM when volume or the team grows.
- Record the source, the dates and the outcome of every enquiry. That is enough to make better decisions.
Why track leads at all
If you do not record where enquiries come from and what happens to them, you end up guessing. You might spend on advertising that never brings anyone, or ignore a channel that quietly sends your best customers. Tracking turns hunches into decisions.
It also stops people falling through the cracks. A quote that has gone quiet is easy to forget when you are busy. A list that shows “quoted, not heard back, 3 days” reminds you to follow up.
What to record
- Date of the enquiry.
- Name and contact details.
- What they want.
- Source: Google search, Google Business Profile, Facebook, Instagram, referral, repeat customer, phone, other.
- Date you replied.
- Quote value and date.
- Outcome: won, lost or waiting, with a short reason.
- Date and value of the job, and whether you asked for a review.
Asking “How did you hear about us?” at the start of the conversation takes five seconds and is invaluable.
Start with a spreadsheet
A simple sheet with the columns above is enough for most businesses. Colour or filter by stage, and sort by the next follow-up date. Spend ten minutes each morning updating it. The habit matters more than the tool.
When a CRM is worth it
A CRM (customer relationship management tool) is simply a better place to keep the same information. Consider one when:
- More than one person handles enquiries.
- You are losing track of follow-ups.
- You want automatic replies, reminders and review requests.
- You want a clear view of where leads come from without manual work.
Read the numbers
Once a month, look at three things:
- How many enquiries came from each source. This tells you where to put effort.
- How many became jobs from each source. Volume is not value. A smaller source may send better customers.
- How long it took you to reply and follow up. This links straight to results. See speed to lead.
Keep data safe and lawful
Customer details are personal data. Keep them in a secure place, only for as long as you need them, and be clear about how you use them. Our guide to cookies and GDPR covers the basics.
What we set up for clients
At Brilliant, every form, call and message lands in one inbox, with the source recorded automatically. You get a monthly summary of where enquiries came from, so you can see which channels pay. See lead generation and automation.
Frequently asked questions
Is a spreadsheet really enough?
For a small number of leads a week, yes. The best system is the one you will actually keep up to date.
What is the most important thing to track?
The source of each enquiry and its outcome. Together they show which marketing is worth paying for.
Are there free CRMs?
Several offer free starter plans, though they differ in limits and in how they handle data. Choose one that suits your volume and check where the data is stored.
More questions? Browse all our FAQs.
Useful next: website and marketing glossary, practical checklists and the website ROI calculator.