A practical small-business guide
How to Track Where Your Leads Come From
See which enquiries turn into real work across forms, calls, referrals and campaigns. The useful answer starts with consistent records, not a bigger dashboard.
One lead. One record. Enough detail to make a better decision.
Separate where they found you from how they contacted you.
When a monthly report says half your leads came from “website form”, you have learned how people contacted you, not what brought them there. Google may be the source. The form is the conversion method. Someone might first hear about you through a referral, return through Google and finally call. Flatten that journey into one field and the report looks tidy while telling you very little.
I recommend keeping three modest views: first touch, latest touch and conversion method. This is not perfect attribution, and it does not need to be. It is enough to spot patterns, improve follow-up and make marketing decisions less dependent on memory.
Capture the minimum that answers a real question.
Clean reporting starts with dull, consistent labels. Use a controlled list for sources and statuses so “Google”, “google” and “Google Search” do not become three different rows. The medium and campaign fields below describe first touch; only add latest-touch versions if you know what decision they will support.
| Field | What it tells you |
|---|---|
| lead_id | A unique reference so one enquiry stays one record. |
| created_at | When the enquiry first arrived. |
| first_touch_source | The earliest known source, such as Google, referral or Facebook. |
| latest_touch_source | The most recent source before the enquiry. |
| medium | The first-touch channel type, such as organic, paid, email or referral. |
| campaign | The first-touch campaign name when one exists. |
| landing_page | The first page the person visited. |
| conversion_method | How they enquired: form, phone, email, booking or walk-in. |
| status | A small controlled list such as new, qualified, quoted, won or lost. |
| won_value | The value of won work, if useful and appropriate. |
Give web, phone and offline leads the same destination.
| Channel | Best capture | Simple fallback |
|---|---|---|
| Website form | Landing page, referrer and campaign tags in hidden fields | Ask “How did you hear about us?” as a short optional field |
| Phone call | Call source or tracking number, then add it to the same lead record | Use a required source field in the call note |
| Google Business Profile | Tag website and booking links so they are distinguishable | Use “Google Business Profile” as a consistent staff-selected source |
| Email or social | Tag campaign links and record the platform where the conversation began | Select the source when creating the lead |
| Referral or offline | Use a required source field, a simple QR code or a campaign code | Record “referral” first, then the referrer only where appropriate |
A six-step lead-source tracking system.
- 01
Agree on a small source list
Start with plain categories your team can use consistently. Google, referral, repeat customer, Facebook, email, event and unknown are more useful than dozens of overlapping labels.
- 02
Tag links you control
Add consistent campaign parameters to advertising, emails, social posts, QR codes and Google Business Profile links. Do not add campaign tags to links between pages on your own website.
- 03
Capture web context automatically
Pass landing page, referrer and campaign values through hidden form fields. Keep the visible form short and do not put personal information in a URL parameter.
- 04
Give calls and offline leads a path
Use a call source, dedicated number where justified, or one required field in the call note. Referrals and walk-ins need the same discipline as web forms.
- 05
Store one lead record
Send every channel to one CRM, Airtable base or spreadsheet. Preserve first touch, update latest touch, and keep the conversion method as a separate field.
- 06
Review outcomes monthly
Compare enquiries, qualified leads, quotes and won work by source. Fix missing or inconsistent data before adding a more elaborate dashboard.
Google Analytics can report traffic-source dimensions from automatic and manual tagging. Google's current documentation explains the available traffic-source fields and campaign parameters. Use that website data as an input, then connect it to the operational lead outcome.
Keep three views. Treat each as a clue, not a verdict.
- First touch
- Where the person first discovered you. Useful for understanding which channels create awareness.
- Latest touch
- The last known source before the enquiry. Useful for seeing which activity prompted action.
- Conversion method
- The form, phone call, email or booking that created the lead. Useful for improving the enquiry experience.
The monthly view
Put each source on one row. Review enquiries, qualified leads, quotes, wins, win rate, won value and records with no source. A channel that produces fewer but better-fit enquiries may matter more than the one with the largest raw count.
What not to claim
A source field does not prove causation. People move between conversations, devices and channels. Use the data to ask better questions, not to invent certainty the system cannot support.
Free practical workbook
Download the lead-source tracking workbook.
Open it in Excel or Google Sheets and you will find a guided setup, editable source lists, useful dropdowns, a filterable lead register and a formula-driven dashboard. Six clearly marked demonstration rows make the reports useful from the first click and are easy to replace.
Download the free workbookNeed a blank import file instead? Download the plain CSV .
The tracking breaks before the dashboard does.
Data mistakes
- Using vague values such as “online” or “internet”.
- Letting each person invent new spelling and categories.
- Overwriting the first source when a lead returns.
- Leaving phone, referral and walk-in leads outside the system.
System mistakes
- Adding campaign tags to internal website links.
- Depending on website analytics as the customer record.
- Building a dashboard before people use the fields consistently.
- Putting names, emails or phone numbers into URL parameters.
Privacy note
Collect only what you need, be clear about how it is used, restrict access, and avoid personal information in URLs. The OAIC publishes the current Australian Privacy Principles guidelines. This guide is operational guidance, not legal or privacy advice.
Lead-source tracking, asked and answered.
What is lead source tracking?
Lead source tracking is the practice of recording where an enquiry came from, how the person contacted the business, and what happened next. A useful record separates first touch, latest touch and conversion method instead of forcing everything into one vague source field.
What is the simplest way to track lead sources?
For a small business, start with one spreadsheet, Airtable base or CRM table and a controlled source list. Capture web campaign data automatically, make source a required field for phone and offline enquiries, and review won work by source once a month.
Can Google Analytics tell me where every lead came from?
No. Analytics can describe website traffic and tagged campaigns, but it will not automatically connect every phone call, referral, email conversation or offline enquiry to a won job. Keep analytics as one input and store the operational lead record in the system your team actually uses.
Should I use first-touch or last-touch attribution?
Keep both if your system allows it. First touch helps explain discovery, while latest touch helps explain the action that preceded the enquiry. Neither is perfect, so use them as decision aids rather than absolute proof that one channel caused a sale.
Do I need call-tracking software?
Not always. A required source field in a consistent call note may be enough at low volume. Dedicated tracking numbers become more useful when paid campaigns or several locations make the extra detail worth the cost and operational complexity.
What should I avoid putting in campaign parameters?
Do not put names, email addresses, phone numbers or other personal information in campaign parameters. URLs are copied, logged and shared widely. Use neutral campaign labels and review your collection and handling against current privacy obligations.
Tracking earns its keep when it changes what happens next.
A source label is more admin unless it improves a real decision: which calls need follow-up, which campaigns attract good-fit work and where enquiries fall out before a quote.
The related guides cover CRM, calendar and lead management automation, lead follow-up and quote automation, and call and voicemail capture.