Skip to content
The growth system: websites, Google and social
brilliant

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
  1. Why track leads at all
  2. What to record
  3. Start with a spreadsheet
  4. When a CRM is worth it
  5. Read the numbers
  6. Keep data safe and lawful
  7. What we set up for clients
Simple lead tracking: do you need a CRM?

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.

Get the 12-point website launch checklist.

Open it straight away, and we will email you a copy and one practical tip a month. Unsubscribe whenever you like.

By signing up you agree to get our emails. See our privacy policy.

Next step

Ready to put this into practice?

See lead generation and automation

Ready for more
customers?

Less hassle starts with your free plan: see it in 30 seconds, or book a quick call. No card needed to get started.

  • 30-day marketing guarantee
  • Live in 7 days
  • One fixed price