A roofing company gets a call on Tuesday, a web form on Wednesday, and a text on Thursday. By Friday, the owner remembers that one came from “somewhere online” and has no idea about the others. Nothing is wrong with the marketing. The problem is that nobody wrote anything down.
Learning how to track leads for a small business doesn’t require expensive software. It requires deciding what to record, recording it the same way every time, and looking at the results on a schedule. This guide walks through a simple version you can start this week.
What counts as a lead, and why the source matters
For tracking purposes, a lead is any person who contacts you or gives you their details to ask about your services. That includes phone calls, contact form submissions, texts, emails, chat messages, social media direct messages, and walk-ins.
The source is the path that brought them to you: a Google Business Profile listing, your website, a referral, a yard sign, a social post. Knowing the source helps you decide where to spend time and money, and which channels deserve attention. It also exposes a quieter problem: leads that arrive and never get a reply.
Step 1: Decide where every inquiry will be logged
Pick one place. A shared spreadsheet is enough for most small businesses. The tool matters less than the habit, and a log spread across sticky notes, voicemail, and three inboxes is the thing to fix first.
Create these columns:
- Date and time received
- Name and phone or email
- How they contacted you (call, form, text, email, message, in person)
- Source (how they found you)
- Service requested
- Status (new, contacted, quote sent, booked, lost, not a fit)
- Next step and date
- Outcome notes
Keep the list short. Every extra column is one more thing someone will skip on a busy day.
Step 2: Capture the source at each entry point
This is where most tracking falls apart, because each channel gives you different information.
Phone calls
Train whoever answers to ask, naturally, “How did you hear about us?” and to write the answer down in the customer’s own words. Choose a short list of source options so entries stay consistent: Google search, Google Maps, website, referral, social media, repeat customer, other.
If calls go unanswered, you lose both the lead and the source. A missed call automation setup can send a prompt reply so the person can tell you what they need, which gives you something to log.
Website forms
Add a required or optional “How did you hear about us?” field to your contact form, ideally a dropdown matching your spreadsheet categories. Also make sure submissions go to an inbox someone checks daily. If your site needs a clearer path to contact, the planning ideas in this five-page website guide are a useful starting point.
Texts, emails, and direct messages
These often arrive without context. Reply with a friendly question about what they need and how they found you, then log it. Don’t wait to enter details until a quote is sent; by then you will have forgotten.
Google Business Profile
Your profile can produce calls, website visits, and direction requests, and Google provides some performance data inside the profile. Treat that as a general signal of activity rather than a lead-by-lead record, since it won’t match names to outcomes. A well-built profile also helps people choose you; this guide to Business Profile categories, services, and description covers the basics.
Step 3: Use consistent labels
“Google,” “google search,” and “found you online” will be counted as three sources unless you decide otherwise. Agree on your labels and stick to them. When a customer’s answer is vague, pick the closest category and add a note. If someone says “a friend told me, then I checked your website,” record the referral as the source and mention the website in the notes.
Two examples in plain terms
A roofing company
Roofing inquiries often come by phone after a storm or an inspection, and jobs can take weeks to close. The log might show a caller on a Monday who said a neighbor recommended the company, a form submission asking about gutter repair, and a text from a yard sign. Each gets a row. The status column matters most here, because a quote sent ten days ago with no follow-up is easy to forget. Setting a next-step date keeps those estimates from going quiet. Roofers may also find the ideas on the marketing for roofers page relevant.
A salon
A salon sees more frequent, smaller bookings. The front desk logs a new client who says they found the salon on Google Maps, another who came through a friend, and a returning client who rebooked by text. Statuses are simpler (inquiry, booked, completed, no-show), and the useful question is different: which sources lead to booked appointments rather than just questions about pricing or availability.
Step 4: Follow up on a schedule
A tracking sheet only helps if it triggers action. Set simple rules, such as responding to new inquiries the same business day and checking the sheet each morning for anything marked “quote sent” or “contacted” with no update. Keep messages honest and useful, and respect customer preferences about contact. If you automate texts or emails, make sure you follow applicable consent and opt-out rules, and consult a qualified professional if you are unsure about requirements for your situation.
Step 5: Review monthly
Once a month, count inquiries by source, then count how many became booked work. Look for simple patterns:
- Which sources send the most inquiries?
- Which send the inquiries that actually book?
- How many leads were never contacted, or contacted late?
- How many were not a fit, and why?
The last two are often more actionable than the first. Fixing slow response is usually cheaper than buying more traffic.
What basic tracking can and can’t tell you
Be realistic about the limits. Self-reported sources are imperfect: people forget, simplify, or credit the last thing they saw. A customer might have seen your Google listing, visited your site twice, and then called after a referral, and you will only hear one part of that story. Small numbers also mislead. A month with ten leads can’t prove that one channel is better than another.
What a simple log does well is show volume, response gaps, and rough direction. It won’t prove which channel caused a sale, and it shouldn’t be treated as exact attribution. Use it to ask better questions, not to declare winners after a few weeks. For a broader view of how local channels fit together, see this piece on small business local marketing.
When to move beyond a spreadsheet
A spreadsheet starts to strain when several people handle inquiries, leads get dropped, or you want automatic reminders and replies. At that point a CRM and customer follow-up automation can reduce manual work. You can see how Digital Infinite approaches this on the How It Works page, or ask questions through the contact page. Until then, a clean log kept daily will teach you more than a complicated system nobody updates.
Frequently asked questions
What is the simplest way to track leads for a small business?
Keep one shared spreadsheet with a row for each inquiry. Record the date, name, contact method, the source the person reports or you can see, the service requested, and the outcome. Update it the same day, and review it monthly.
Do I need CRM software to track leads?
Not at first. A spreadsheet works while volume is low and one or two people handle inquiries. Consider a CRM when leads get missed, several people need the same records, or you want reminders and follow-up handled more consistently.
Can basic lead tracking tell me which marketing works best?
It can point to patterns, such as which sources produce more inquiries or booked jobs. It cannot prove cause. People often see several touchpoints before contacting you, and some will not remember or report how they found you.