A Simple Way to Track Where Your Leads Actually Come From

12 September 2026·4 min read

Quick answer: You don't need an expensive CRM to know where your leads come from — you need one intake question, a basic grasp of UTM links, and a spreadsheet with the right columns. Ask every new enquiry how they found you, tag your links so the click itself tells you, and log both in one place you actually check. Below is the full lightweight setup. 📈

Most businesses can tell you roughly where their leads come from, in the same way you can roughly guess tomorrow's weather — it's a feeling, not a fact, and it's usually wrong in one direction or another. Ask most owners which channel actually drives enquiries and the honest answer is "referrals, I think, and maybe the ads?" That's not tracking, that's a hunch — and hunches get expensive right around the time you're asking for a bigger marketing budget. 💖

What most businesses get wrong

Overestimating word-of-mouth because it's the most memorable kind of lead, not necessarily the biggest.
Never asking new enquiries how they found the business — the simplest data source, left completely uncollected.
Running ads with no way to tell if a lead actually came from them, versus finding the business anyway.
Tracking leads in someone's head instead of anywhere written down and comparable over time.
Believing a big CRM is the only way to do this properly — it isn't, especially at a smaller scale.

The lightweight lead-source setup

Three parts, and none of them require new software:

1. The one intake question: ask "How did you hear about us?" the same way every time (phone, form, in person), with a short fixed list of options — Google search, Google Maps/GBP, Facebook/Instagram, referral (from who), ad, other — so answers are comparable later.
2. UTM basics, plainly: a UTM is just a tag added to the end of a link that tells your analytics which specific link someone clicked — so instead of knowing traffic came from "Facebook," you know it came from the Tuesday post versus the paid ad. Add a source, medium and campaign tag to any link you share off your own website.
3. The spreadsheet structure: one row per lead — Date, Name, Source (from the intake answer), Campaign/Link (from the UTM, if digital), Enquiry Type, Outcome (booked / quoted / lost) — updated the same day, not in a monthly batch.

Three real scenarios

Same setup, three different reasons to actually want the data:

A business relying on referrals, ads and organic search: after four weeks of the intake question, the spreadsheet shows referrals are real but smaller than assumed — about a quarter of leads, not the 'most of them' the owner believed. Organic search is actually the biggest source, just quieter and less memorable than a client saying 'a friend sent me.'

A business unsure if their ad spend is working: UTM-tagged links on the ad campaign show exactly how many leads clicked straight through, versus how many searched the brand name afterwards and came in through organic instead. The ad is working — it's just showing up in the organic column because people saw it, then googled the business rather than clicking the ad itself.

A business about to ask for a bigger marketing budget: six weeks of clean source data turns 'I think marketing is working' into 'organic search brought in eleven enquiries and three bookings last month, at zero extra spend' — a very different, much shorter conversation with whoever signs off the budget.

How UTMs actually work, step by step

Build one using a free campaign URL builder, or manually by adding ?utm_source=facebook&utm_medium=social&utm_campaign=spring-sale to the end of a link. Source is where it's posted (facebook, newsletter), medium is the type of channel (social, email, paid), and campaign is what this specific push is called. Check them landing correctly in your website's traffic source report before you rely on them. Keep a simple, consistent naming convention — facebook-post-14sep, not fb1 — so it still makes sense to you in six months.

💡 Ask the same question, the same way, every time. The intake question only works as data if it's consistent — if reception asks it one way and the online form asks it another, the answers can't be compared later.

Mistakes to avoid

Letting the source field be free text, which turns into twenty different spellings of "Facebook."
Forgetting to UTM-tag links in email newsletters, not just paid ads.
Only tracking digital leads and leaving referrals or phone enquiries out of the same sheet.
Updating the spreadsheet in a monthly batch instead of as leads actually come in.
Building the tracking sheet and then never actually looking at it.

Frequently asked questions

Do I really need a spreadsheet, or is a CRM worth it?

Honest trade-off: a spreadsheet is genuinely enough for most small businesses under roughly 50 leads a month. Past that, manual entry becomes the weak link, and a proper CRM starts paying for the time it saves.

What if a customer says they "just found us on Google" — is that useful?

It's still useful at a broad level, even without more detail — you can at least separate organic from paid from referral. Don't let the search for perfect data stop you from capturing good-enough data.

How long before this data is actually useful?

Four to six weeks gives you enough rows to see a real pattern, rather than noise from one unusually quiet or busy week.

Will UTMs mess up my website analytics if I get them wrong?

They won't break anything technically, but an inconsistent naming convention makes the reports messy to read later. It's worth deciding the format once, writing it down, and sticking to it.

Keep reading 🤍

Written by

Kate, founder of Chronically Online

I help Gold Coast and Brisbane businesses grow with branding, websites and marketing that actually works.

Work with me ✦