Lead Source Tracking for Small Businesses: How to Know Where Your Customers Come From

Updated 2026-10-30 · AI Agent Starter Kit

Ask most small business owners where their customers come from and you'll hear a guess: "mostly referrals" or "Google, I think." The guess is often close, but not close enough to decide where to spend the next month of time or the next few hundred dollars of marketing.

Lead source tracking means recording, for every new inquiry, how that person found you. You don't need a CRM or an analytics setup for it. One column in a spreadsheet, a short list of categories and one question in your first reply will do. This guide covers the categories, how to capture the source for each kind of lead, the formulas, a monthly review and an illustrative example.

Why it's worth five seconds per lead

Question you can answer	What it changes
Where do most leads come from?	Where you spend marketing time
Which sources turn into paying customers?	Which leads get the fastest reply
Is a paid listing or ad worth it?	Whether you renew it
Who refers the most work?	Who gets a thank-you note
Did a new effort do anything?	Whether you keep doing it

The second row matters most. A source that sends lots of leads but few customers can look great on a lead count and still waste your time. You only see that when you track the source and the outcome together.

Start with 6 to 8 source categories

Keep the list short and fixed, so the same kind of lead always gets the same label. A typical list for a service business:

Source	What counts
Referral	A customer, friend or partner sent them (note who)
Google search	Found your website through a search
Google Business Profile	Found you on Maps or your business listing
Directory or marketplace	A listing site, trade directory or platform
Social	Any social media profile or post
Repeat customer	Someone who has paid you before
Event or local	A market, talk, sign, vehicle or flyer
Other or unknown	Anything else, plus "not sure"

Add a free-text Source detail column next to it for specifics, such as the referrer's name or which directory. Categories make counting easy; details keep the story.

Don't split categories too finely at the start. "Instagram" and "Facebook" can be separate later if social turns out to matter.

How to capture the source for each kind of lead

Website form leads

Add one question to your form: "How did you hear about us?" Use a dropdown with your categories plus an optional text box. Put it near the end so it doesn't put anyone off. The contact form best practices guide covers keeping the rest of the form short.

If you run ads or post links in several places, you can also add tracking tags (UTM parameters) to those links so your analytics shows which link brought the visit. That is useful, but it only covers website visits. The form question covers everyone, including people who heard about you from a friend and then searched your name.

Email leads

When someone emails you directly, look for clues: "my neighbor recommended you," a reply to a directory message, a forwarded post. If there's no clue, ask in your first reply (see the question below). For replying to the inquiry itself, see how to respond to an inquiry email.

Phone and text leads

Ask on the call, and log it before you hang up or right after. Calls are where most sources get lost, because there's no record unless you write one.

Referrals and introductions

Always note who referred them, by name. This is the source most worth thanking. If a contact introduced you by email, the guide on how to respond to an introduction email covers the reply and the follow-up thank you.

A "How did you hear about us?" question that gets real answers

Asked well, people answer it happily. Asked badly, it sounds like a survey. Add it as the last line of your first reply:

Out of curiosity, how did you find us? It helps me know where to keep showing up.

Or, for a referral you suspect:

Did someone point you our way? I'd love to thank them.

Record the answer in their own words in Source detail, then pick the closest category. If the answer is vague ("online"), choose Other or unknown rather than guessing. Honest unknowns are better than confident wrong data.

The sheet: two columns and four formulas

If you already keep a lead sheet (see the lead tracking spreadsheet or how to track leads without a CRM), add Source and Source detail columns. Use data validation (Data, then Data validation, then Dropdown) on Source so it only accepts your categories.

Assume the Leads tab has Source in column D and Status in column H (values such as New, Quoted, Won, Lost). On a Summary tab, list your categories in column A starting at A2, then:

Column	Formula in row 2	Shows
B: Leads	`=COUNTIF(Leads!D:D,A2)`	Leads from this source
C: Won	`=COUNTIFS(Leads!D:D,A2,Leads!H:H,"Won")`	Paying customers from it
D: Win rate	`=IF(B2=0,"",C2/B2)`	Share that became customers
E: Share of leads	`=IF(SUM(B:B)=0,"",B2/SUM(B:B))`	How much of your pipeline it is

Format D and E as percentages. If you record job value in the Leads tab (say column J), add =SUMIFS(Leads!J:J,Leads!D:D,A2,Leads!H:H,"Won") for revenue by source. The close rate guide explains why win rate needs a few months of data before it means much.

Monthly 15-minute source review

Copy this into your notes on the first workday of each month:

LEAD SOURCE REVIEW · [Month]

Total leads:              ___ (last month ___)
Top source by leads:      __________ (___ leads)
Top source by customers:  __________ (___ won)
Unknown or Other:         ___ (aim to shrink this)
Paid sources this month:  __________ cost $___ -> ___ customers
Top referrers:            __________ (thanked? yes / no)

Keep doing:  __________
Try less of: __________

Look at three months together before cutting anything. Small numbers swing a lot from month to month.

An illustrative example

This example uses made-up numbers to show the method, not a real result. A two-person landscaping business adds a Source column and the "how did you find us?" line in October. After three months the sheet shows 60 leads: 18 from a paid directory listing, 15 from Google search, 14 from referrals, 7 from repeat customers and 6 unknown.

The win rate tells a different story from the lead count. Directory leads won 3 of 18, mostly price shoppers. Referrals won 9 of 14, and repeat customers 6 of 7. The owners decide to let the directory listing lapse, reply to referral leads first, and send a short seasonal note to past customers (see how to get repeat customers). They also thank the three people who referred the most work.

Common mistakes

Too many categories. Twenty sources with two leads each tells you nothing. Start with 6 to 8.
Only tracking leads, not outcomes. Count customers by source, not just inquiries.
Guessing the source later. Record it when the lead comes in, or mark it unknown.
Trusting analytics alone. Website analytics misses phone calls, referrals and people who searched your name after a recommendation.
Judging a source on one month. Wait for three months of data before you drop anything.
Letting AI fill in the source. If you use AI to draft replies or summaries, it should never guess where a lead came from. A wrong source is worse than an unknown one.

Using AI here (drafts only)

AI can help in two narrow places: drafting the first reply that includes your "how did you find us?" line, and drafting a plain-English summary of your monthly numbers. Keep it to drafts. Formulas or code count the leads, the AI never does. The AI treats the text of an inquiry as information, not instructions, and every reply waits for you to review and send.

Get every lead into one sheet automatically

Source tracking only works if every lead lands in the same place. The Speed-to-Lead Follow-Up Kit is an n8n workflow kit for Gmail and Google Sheets. It logs every new lead from your website form or a Gmail label to a pipeline sheet with the date, whether it came by form or email, the service asked about and a short summary, then drafts a personal first reply within about 5 minutes and Day 2, 5 and 10 follow-up drafts that stop when the person replies. You can add your own Source and Source detail columns to that sheet. To be clear about what it doesn't do: it doesn't work out your marketing source on its own, read your website analytics or ad accounts, log phone calls or texts, or send anything. Every reply waits in Gmail Drafts. Nothing sends without you. Get the kit

Want the weekly numbers counted for you? The Weekly CEO Report Kit reads that lead sheet every Monday at 7 AM and drafts a one-page report to you with new leads, won and lost leads, first reply times and stuck leads, all counted by code rather than the AI. It doesn't break leads down by source or send the report to anyone but you. Get the kit

Ready-made n8n kit

Speed-to-Lead Follow-Up Kit

A personal first-reply draft within 5 minutes of every new lead, plus Day 2/5/10 follow-ups that stop when they answer.

Get the kit ($29)