How Do I Design a Simple Lead Tracking System That Doesn’t Take Over My Week? (for coaches and consultants)
How to build a simple lead tracking system that shows you who to follow up with, what to do next and what’s actually bringing in clients
Most lead tracking systems fail because they’re too complicated to keep up with. You don’t need more tools. You need a simple way to see where each lead is, what happens next, and which ones are turning into clients. When your system is light and tied to daily and weekly habits, it actually gets used and that’s what drives results.
Most coaches swing between two extremes.
On one side: everything lives in your head and your inbox. You “remember” who to follow up with… until you don’t. Good leads go cold because life happened.
On the other side: you open a giant CRM, dozens of columns, color codes, automations… and after one exhausting setup session, you never touch it again.
You don’t need a fancy system. You need a simple way to see who’s in front of you, where they’re at and what happens next that you can actually keep up with.
You design a simple lead tracking system by:
Deciding what questions it needs to answer,
Choosing one light tool and a daily/weekly habit, and
Reviewing those leads in a way that ties directly to revenue, not just “being organized.”
Step 1: Decide what you actually need to know
Most tracking bloat comes from trying to capture everything.
For a coaching or consulting business, you really need your system to answer just a few questions:
Where did this person come from?
Referral, social post, book, podcast, interview, workshop, website, etc.
Where are they in the conversation with you right now?
New lead, talking in DMs/email, call booked, call completed (yes / not yet / no).
What’s the next step and when?
Follow‑up message, send resource, proposal or no further action.
Which sources are actually turning into clients and cash?
So you know what to do more of and what to stop obsessing over.
Write these questions down. Your tracking system only exists to make them easy to answer in a few minutes, without digging through old messages.
Step 2: Pick one simple tool and one simple habit
The best system is the one you’ll use when you’re tired and busy.
Choose one of these as your “home”:
A simple spreadsheet (Google Sheets, Excel).
A basic kanban board (Trello, Notion, the deals board inside a light CRM).
Set it up with only a handful of columns or lanes, for example:
Name
Source
Current stage (Lead / Conversation / Call booked / Client / Closed)
Next action + date
That’s it. If you find yourself adding ten more fields, you’re probably building for ego, not usefulness.
Then attach a habit to it:
Daily (5-10 minutes):
Add any new leads.
Move people to the right stage based on what happened that day.
Add or adjust the next action and date.
Weekly (15-30 minutes):
Scan through all open leads.
Send the follow‑ups you promised.
Close out anyone who’s clearly a “no” for now.
Think of it like brushing your teeth for your pipeline. Small, consistent care beats occasional deep cleans after damage has already been done.
Step 3: Connect your lead tracking to real money decisions
A tracking system that doesn’t influence decisions is just decoration.
Once a week, look at your simple sheet or board and ask:
How many new people showed up this week and from where?
How many moved to “real conversation” or “call booked”?
How many became paying clients?
Which sources or activities led to those clients?
Now you can see:
“Podcast interviews brought in 3 great leads and 1 client.”
“Random reels with no clear topic brought in lots of noise, almost no calls.”
“Warm introductions from past clients have the highest close rate.”
You’ll spot the same pattern that shows up when people feel “growing but always broke”: often the problem isn’t traffic, it’s that you don’t know which inputs are actually turning into money. This fixes that.
With this view, next month’s focus becomes obvious: do more of what’s working, less of what isn’t and let your lead tracking be the quiet backbone instead of another job.
If you’re doing books, podcasts or interviews, this also lets you see which of those appearances are actually leading to clients, so you can prioritize the ones that matter and tie them into your simple path.
Common mistakes when trying to design a lead tracking system
Over‑building on day one
Creating a huge CRM setup with dozens of fields you’ll never update.Tracking trivia instead of decisions
Logging tiny details but not the things that change what you’ll do next.Letting everything live in DMs and your head
Assuming you’ll “remember” who to follow up with and when.Never closing a lead
Keeping people in limbo instead of clearly marking when it’s a “no” or “not now.”Reviewing once a quarter instead of weekly
Turning tracking into a painful catch‑up project instead of a light, regular habit.
30‑day plan to install a simple, usable lead tracking system
Week 1: Design on paper
Write the 3-4 key questions your system must answer (source, stage, next action, became a client?).
Choose your one tool: sheet or board.
Set up only the columns/lanes you truly need.
Week 2: Start logging every new lead
Any time someone shows interest (form, DM, email, event), add them the same day.
Fill in:
Name, source, current stage, next action + date.
Spend 5-10 minutes at the end of each workday updating where people moved.
Week 3: Add a weekly review ritual
Choose one time each week (for example, Friday afternoon) for a 20‑minute review.
During that time:
Move stale leads to “closed” if they’ve clearly gone cold.
Send needed follow‑ups.
Count how many people moved from “lead” to “call” to “client.”
Week 4: Make decisions from what you see
Look at your past 30 days:
Which sources brought leads?
Which sources actually brought clients?
Decide:
One source to double down on,
One activity to pause for a month.
Adjust your daily and weekly habits to reflect that focus.
If you want to see how this kind of simple tracking plugs into getting out of the “growing but always broke” pattern, I go deeper into that in Growing But Always Broke: Fix Your Cash Flow Before You Blame Marketing. And if you’re doing things like books, podcasts or interviews and want to make sure those appearances actually turn into the right clients, there’s a sister piece called How Can I Use a Book, Podcast Or Interviews To Get More Of The Right Clients?
FAQ: Simple lead tracking for coaches and consultants
Q: Do I really need special software or is a spreadsheet enough?
A spreadsheet is more than enough to start. Many six‑figure coaches run perfectly fine on a simple sheet or basic board, as long as they update it daily and review it weekly. Software helps when your volume and team grow, not before.
Q: How many stages should I track?
Keep it to the few you actually act on: new lead, in conversation, call booked, client, closed. If a stage doesn’t change how you behave, you probably don’t need it.
Q: How often should I update my lead list?
Daily for quick updates (adding new leads, moving stages, setting next actions) and weekly for review. Waiting weeks turns it into a chore and guarantees you’ll miss follow‑ups.
Q: What if I hate admin and always avoid this kind of work?
Shrink the task. Make it a 10‑minute “close the day” ritual with a timer. Pair it with something you like (your favorite drink, music) and keep the system so light that it feels like checking a few boxes, not doing paperwork.
If you want help designing a 90‑Day Conversion System Buildout you can test safely, with clear questions, clear lines and one simple path behind it, that is the work I do with established entrepreneurs, coaches and consultants.
Start with a Conversion Blueprint Call
About Engels
Engels J. Valenzuela helps profitable entrepreneurs, coaches and consultants turn more of their traffic and attention into clients by replacing scattered marketing with one clear path from first click to paying customer.
Read more about Engels
