When I run outreach for a client, I’m generating leads on their behalf across multiple channels at the same time. LinkedIn prospecting, Google Ads, cold email sequences, referral programmes — each one producing contacts at different rates, at different quality levels, with very different conversion patterns.
The problem every agency and consultant faces is this: where does all of that go?
The leads I generate from LinkedIn are in one place. The inbound leads the client is getting from their own network are somewhere else — usually in someone’s inbox or WhatsApp. The follow-up status of each one is in someone’s head. And when either of us wants to know how the pipeline is performing, someone has to spend thirty minutes pulling it together from three different places.
This is the problem the shared lead tracker solves.
Kindly fill the below form to get the free tracker
Takes less than a minute
One Place for Everything
The first thing I set up at the start of any outreach engagement is a shared Google Sheet built specifically for that client. From that point on, it becomes the single source of truth for every lead, regardless of where it came from.
When I add a lead from a LinkedIn prospecting session, it goes into the tracker. When the client gets an inbound enquiry — from their website, from a referral, from a conversation at an event — they add it to the tracker. Every lead, every channel, one place. None of this is automated; someone has to enter it. But that’s actually the point. The act of entering a lead forces a moment of intentionality: who is this person, what do they need, what’s the next step? Leads that get entered get followed up. Leads that sit in an inbox often don’t.
This matters because the alternative — leads scattered across inboxes, spreadsheets, and memory — means things get missed. A warm lead doesn’t get followed up because it fell off the bottom of someone’s email. A conversation that stalled two months ago never gets picked up again because nobody can remember where it was left. A promising contact from an event gets lost because the notes were in a phone that got upgraded.
The tracker eliminates all of that. If it happened, it’s in the sheet.
What I Add, What the Client Adds
The sheet is genuinely collaborative, and that’s where it becomes more than just a spreadsheet.
My side of the work shows up in real time. Every contact I research and reach out to, every response I log, every stage update I make — the client can see all of it without me having to send a report. They can open the sheet on a Monday morning and see exactly what outreach activity happened the previous week: how many new leads were added, which ones responded, where each conversation stands.
The client’s side of the work shows up the same way. When they take a call with someone I’ve introduced them to, they can update the stage, add notes from the conversation, and set the next follow-up date. When they get an inbound lead from their own network that sits outside my outreach activity, they add it to the same sheet. I can see that update the moment it happens, which means I can adjust the outreach strategy based on what’s actually converting, not just what I’m generating.
This two-way visibility is what turns a tracking sheet into a genuine working relationship. We’re not in separate systems looking at different versions of the pipeline. We’re looking at the same data, and we’re both contributing to it.
Understanding What’s Converting
The other thing the shared tracker makes possible is a clear picture of which leads are actually turning into customers — and where they came from.
Every lead in the system is tagged with its source. LinkedIn outreach, Google Ads, cold email, referral, exhibition, website — wherever it came from, that’s recorded. As leads move through the pipeline and some of them convert, the source data comes with them.
The dashboard shows the split at every stage. How many leads from each channel made it to a demo? How many made it to a proposal? How many closed? The conversion rate from lead to won deal, broken down by source, is the number that tells you where to invest more and where to pull back.
This is data that simply doesn’t exist if leads from different channels are living in different places. When everything flows into the same tracker, the picture assembles itself automatically.
The Follow-Up System That Stops Things Being Missed
The most common reason good leads don’t convert isn’t the quality of the initial outreach. It’s the follow-up — or rather, the lack of it.
B2B sales rarely close on the first contact. The buying decision takes time, budgets need approving, stakeholders need convincing. A lead that goes quiet isn’t necessarily a lost lead — it might just need the right follow-up at the right moment, three weeks or three months later.
The tracker handles this with a follow-up date on every contact. That date turns red when it’s overdue. It turns amber when it’s due today or tomorrow. Every morning, both the client and I can open the sheet and see exactly who needs to be contacted that day.
The client doesn’t have to rely on me to remember. I don’t have to rely on them. The sheet makes the overdue follow-ups impossible to miss, and the result is a pipeline where nothing quietly dies from neglect.
What the Dashboard Shows at Any Moment
Without doing any manual analysis, the dashboard gives us both a live read on the state of the pipeline:
The total number of leads in the system. The active pipeline value — what’s currently in play. The weighted pipeline — the same number adjusted for probability at each stage, which is the more honest figure to plan against. The closed won value — what has actually converted into revenue. The win rate — the percentage of closed deals that went the right way. The average deal size — which tells us how many leads we need at the top of the funnel to hit a revenue target.
Below those headline numbers, a stage breakdown shows how much value sits at each point in the funnel and where deals are stalling. A source breakdown shows which acquisition channels are producing not just leads, but revenue.
These numbers update automatically every time a row in the pipeline changes. There’s no reporting process, no waiting until end of month, no reconciling different spreadsheets. The picture is always current.
Why a Google Sheet and Not a CRM
The honest answer is: for most early-stage outreach engagements, a CRM is more infrastructure than the situation needs.
Setting up a shared CRM means creating accounts, configuring pipelines, agreeing on a pricing plan, and usually some form of onboarding. A sheet is live in minutes, shared with a single link, and the client doesn’t need to learn new software or remember a new password.
That said, there are two clear signals that it’s time to move to a proper CRM, and I think it’s worth being direct about them.
The first is team size. The moment a client has more than one or two people actively working leads, a shared sheet starts showing its limits. Two salespeople can coordinate around a single sheet with some discipline. Three or more, and you start getting into conflicts, missed updates, and confusion about who owns which lead. A CRM built for multi-user sales teams handles this properly — lead assignment, activity ownership, visibility controls — in a way a sheet simply can’t.
The second is automation. If the client needs leads automatically flowing in from a web form, email sequences triggering based on pipeline stage, or notifications firing when a deal moves — that’s a CRM job. The sheet is manual by design. Every entry requires a human decision, which is a feature when the pipeline is small and manageable, but a bottleneck when the volume grows or the process needs to run without someone sitting at a keyboard.
If either of those two things is true from the start, I’d skip the sheet and go straight to a CRM. But for a focused outreach engagement where the team is small and the process is still being figured out, the sheet is the right starting point — and everything in it exports cleanly when the time comes to upgrade.
The Bigger Picture Over Time
As the tracker accumulates data over weeks and months, it starts answering bigger questions.
Which industries are converting best for this client? Which job titles are most likely to say yes? Which channels produce leads that close quickly versus leads that drag on forever? Which deal sizes are most common?
These aren’t questions I can answer from a week of data. But they become answerable over a full campaign cycle — and the answers shape every decision about where to focus the outreach, how to structure the messaging, and where the budget should go.
Marketing that can show a clear path from activity to revenue is marketing that gets continued investment. The lead tracker is the simplest, most practical way to make that path visible — for me, and for the client.
Reuben Noronha is Managing Director of Proximite Group, a B2B digital marketing consultancy based in Dubai. He works with SaaS and professional services businesses across the UAE and UK on lead generation, outreach strategy, and sales pipeline development.
Tags: Lead Generation · CRM · B2B Marketing · Outreach · Pipeline Management · Google Sheets · Client Reporting · Conversion Tracking · Sales Operations
