You can track lead sources without a CRM using a single spreadsheet with five columns: source, date contacted, stage, outcome, and notes. This gives you everything a paid CRM gives you for the purpose of knowing which channels actually produce, until your lead volume or team size outgrows what a spreadsheet can handle.
Here's the exact system, and the point at which it's genuinely time to pay for something more.
Why Tracking Matters More Than the Tool You Use It In
The value of tracking isn't the software — it's the discipline of logging every lead with where it came from. A business running three channels but not tracking source has no way to know if channel one is producing 80% of results and channels two and three are wasted effort, or the reverse. Untracked lead gen is just activity; tracked lead gen is a system you can actually improve.
This is the exact gap covered in how to build a lead generation engine — tracking is one of the four core parts of a working engine, and it's the part most commonly skipped because it feels like admin work rather than "real" lead gen.
The Five-Column System
Set this up in Google Sheets, Excel, or even Notion — the tool matters less than using it consistently.
| Column | What Goes Here | Why It Matters | |---|---|---| | Source | Where the lead came from (cold email, referral, Google Business Profile, WhatsApp, event) | Tells you which channels are actually producing | | Date contacted | First-touch date | Lets you measure sales cycle length by source | | Stage | Contacted → Replied → Interested → Proposal sent → Won/Lost | Shows you where leads are getting stuck | | Outcome | Won, lost, or ghosted (with reason if known) | The single most useful column for improving targeting over time | | Notes | Anything specific — objections raised, what worked in the pitch | Turns individual leads into pattern recognition over time |
That's it. No pipeline stages beyond what fits a simple dropdown, no automation, no integrations. One row per lead, updated as it moves.
Setting It Up in 15 Minutes
- Create a spreadsheet with the five columns above as headers.
- Add data validation dropdowns for "Source" and "Stage" so entries stay consistent (free-text entries like "insta," "Instagram," and "IG" from different sessions will quietly break your source analysis later).
- Add a new row the moment you make first contact with a lead — not at the end of the week from memory. Delayed logging is where most tracking systems fail; details get lost or skipped entirely.
- Review weekly, not daily. A quick weekly scan tells you which source produced replies this week; daily checking just creates noise without enough data to act on.
What to Actually Look At Each Week
Once you have a few weeks of data, three views matter more than the raw row count:
Leads by source. A simple count or pivot table by the Source column shows you where your pipeline is actually coming from — often surprising, since the channel that feels most active isn't always the one producing results.
Conversion rate by source. Not just volume — divide "Won" by total leads per source. A channel producing fewer leads but a much higher conversion rate may be worth more time than a high-volume, low-conversion one. This is the practical version of the idea covered in lead quality vs. lead quantity — you can't tell which situation you're in without source-level tracking.
Time in each stage. If leads are piling up at "Replied" and stalling before "Proposal sent," that's a follow-up problem, not a sourcing problem — and it's invisible without a tracking system that shows stage, not just outcome.
A Simple Formula for Weekly Review
Once your sheet has data, this three-question review takes under ten minutes:
- Which source produced the most replies this week?
- Which source has the best Won-to-Contacted ratio over the last month?
- Are any leads stuck in "Replied" or "Interested" for more than two weeks with no follow-up logged?
Answering these consistently is what separates a tracking system from a spreadsheet nobody opens.
When a Spreadsheet Stops Being Enough
A spreadsheet works fine for a solo operator or small team handling up to roughly a few dozen active leads at a time. Signs it's time to move to a lightweight paid CRM:
- Multiple people need to update lead status simultaneously and keep colliding
- You need automated follow-up reminders because manual tracking is falling behind
- You want integrations (email tracking, calendar booking) that a spreadsheet can't do natively
- Lead volume has grown past what's easy to scan in a single view
Even then, most freelancers and small agencies are well served by a free-tier or low-cost CRM rather than an enterprise platform — the tracking principles above transfer directly, just with automation layered on top. See lead generation tools compared for where the free-to-paid line actually sits across different tool categories.
Tracking Ties Directly Into Follow-Up Discipline
The reason tracking matters so much isn't just reporting — it's that most conversions happen on the 2nd through 5th touch, spaced over about three weeks, not the first message. Without a tracking system, it's nearly impossible to remember who needs a follow-up and when. The complete guide to cold outreach in 2026 covers the follow-up cadence in detail; the spreadsheet above is what makes that cadence actually executable instead of aspirational.
Track Sources From the First Lead
Tracking is most valuable when it starts on day one, not after a few months of guessing which channel is working. If part of your pipeline involves cold outreach to local businesses, Runvax gives you a ready-made source (the tool itself) and a personalized message for each prospect, so the "Source" and "Date contacted" columns are easy to fill in consistently from the very first row. Free to start, no credit card required.