If You Can't Trace Your Last 10 Deals, You Don't Have Marketing. You Have a Marketing Expense.
Most owner-operators can name their ad spend down to the dollar. Almost none can name what it produced. Here's how to fix that in 30 days, with the actual math.
By Yasmin & Arsen | P&C Marketing Agency | Reading time: 8 minutes
A business owner we spoke with last month had been spending $8,000 a month on Google Ads. For 14 months. That's $112,000.
We asked him three questions.
How many of your last 10 customers came from those ads? He didn't know.
What's your average cost per closed deal from that channel? He didn't know.
What does your agency report on each month? Impressions. Click-through rate. Conversions, with conversions defined as form fills including spam.
$112,000 of spend. Zero attribution. Fourteen months of decisions made by feel.
This isn't a marketing problem. It's a tracking problem dressed up as a marketing problem, sold to him as an agency problem.
And it's the most common diagnosis we make.
Why Stage 5 is where most pipelines die
In our 5-Stage Pipeline framework, revenue tracking is the final stage. Traffic, lead capture, qualification, and sales conversion all sit upstream of it. Stage 5 is the one that closes the loop — the one that takes the dollar that left your bank account in ad spend and traces it back to the dollar that landed in your bank account as revenue.
80% of the SMB pipelines we audit are broken here. Not at lead capture. Not at qualification. Here.
This matters because every decision upstream of Stage 5 is downstream of Stage 5's data. If you don't know what produced revenue, you can't reallocate spend toward what produced revenue. You're optimising in the dark.
Owner-operators are smart, busy people. They tolerate this because the people they hired to fix it have an interest in keeping it broken. A pipeline that can't be traced is a pipeline that can't be held accountable. That's good for the agency. Bad for the business.
Reports versus tracking: the difference that matters
A marketing report tells you what happened. A tracking system tells you why, and what to do next.
The distinction is not pedantic. It's the entire game.
Here's the same campaign, viewed two ways:
| Metric | What the report shows | What a tracking system shows |
|---|---|---|
| Spend | $8,000 | $8,000 |
| Clicks | 3,847 | 3,847 |
| Conversions | 142 (form fills) | 142 form fills → 38 qualified → 11 closed |
| Revenue produced | Not shown | $34,000 deposited |
| Cost per deposit | Not shown | $727 |
| Average ticket | Not shown | $3,090 |
| ROAS | Not calculated | 4.25x |
The left column is what most SMBs receive monthly. The right column is what they actually need.
The left column makes you feel like you have visibility. The right column lets you make a decision.
If your monthly marketing report ends with a graph and not a sentence about deposited revenue, you have a report. You don't have tracking.
The four leaks we find every time
Across the pipelines we've audited — dental practices, HVAC companies, dealerships, law firms, med spas, roofing contractors — Stage 5 fails in the same four ways. Memorise these. They're the audit you can run on yourself this afternoon.
Leak 1: No source attribution past form-fill
Lead comes in. Form-fill is recorded. Then nothing. The CRM doesn't carry the source field through to the closed-deal record, so even if you close the lead three weeks later, you've lost the link back to the channel that produced it.
Symptom: your sales team and your marketing team disagree about which channel works. Both think they're right. Both are guessing.
Fix: a mandatory 'lead source' field on every CRM record, populated automatically from UTM parameters, and inherited by the deal record. Five-hour engineering job. Permanent payoff.
Leak 2: Sales follow-up windows over 24 hours
A lead that waits 48 hours for a callback is worth roughly half of a lead that gets called in 5 minutes. Most owner-operated businesses we audit have stated SLAs of "same day" and actual response times of 1.8 business days.
That's not a sales problem. That's a tracking problem — because if you don't measure response time, you can't manage it. If you do measure it, the average drops within a week. We've seen it happen ten times out of ten.
Leak 3: No closed-loop reporting from CRM back to ad platform
Google Ads and Meta both optimise on the conversion data you feed them. If you only feed them form-fills, they optimise for form-fills, including the bad ones. If you feed them deposited revenue, they optimise for that instead.
Most SMBs never connect the two. The platforms keep showing them "conversions" — which means form-fills, including the tire-kickers and the spam. The platforms have no idea which of those form-fills became real deals, because nobody told them.
Offline conversion tracking, properly installed, will reshape your ad performance within 30 days. Most agencies skip it because it requires touching the client's CRM. Inconvenient, so it doesn't get done.
Leak 4: "Reporting" that's actually just dashboards
A dashboard with eleven graphs is not a tracking system. It's wallpaper.
A tracking system produces one sentence: "Spent $X, produced $Y in deposited revenue from Z deals at an average ticket of $W. Best channel was [name]. Worst was [name]. Recommended reallocation: shift $A from B to C."
If your monthly report doesn't compress to that sentence, your report is not tracking. It's theatre.
The 30-day fix
Here is the methodology, in order. Do not skip steps. Do not rearrange them. The order matters because each step exposes the data the next step needs.
Week 1: Audit what you have
1. Pull the last 90 days of marketing spend by channel. One spreadsheet. Total at the bottom.
2. Pull the last 90 days of closed deals. One spreadsheet. Revenue total at the bottom.
3. Try to match them. For each closed deal, write the source. If you can't, mark it "unknown."
4. Count the unknowns. That percentage is your tracking gap. If it's over 30%, your pipeline is invisible.
Week 2: Install the source field
Add a single mandatory field to every lead and deal record in your CRM: lead source. Populate it with UTM parameters for paid channels. Populate it manually for referrals and walk-ins. Make it non-skippable.
Then go back 90 days and fill in what you can. You'll get maybe 60% coverage. That's enough to start.
Week 3: Connect CRM to ad platforms
Install offline conversion tracking in Google Ads. Connect Meta's Conversions API to your CRM. Send deposited-revenue values, not form-fill counts.
Within seven days of doing this, the ad platforms will start showing you which campaigns produce real revenue, not which produce form-fills. Performance reshapes itself without you touching a single ad creative.
Week 4: Reallocate
Look at your tracking. Cut the worst-performing 20% of spend. Move it to the best-performing 20%.
Don't touch the middle 60%. That's the data you need to keep collecting.
Set one number to track over the next 90 days: cost per deposited dollar, blended across all channels. Drive it down. That's the whole game.
The boring truth
A working pipeline isn't loud. It's quiet.
Leads come in steadily. Sales close at predictable rates. The owner can tell you, on any given Tuesday, the cost per deposited dollar, the average ticket size, and which channel is producing it.
Boring? Yes. Profitable? Also yes.
The businesses that survive the next downturn are the ones that can answer those three questions in 30 seconds. The ones that can't, won't.
If you're an owner-operator running a $500K to $5M business, and you can't trace your last 10 deals back to a source, you don't have a marketing problem. You have a Stage 5 problem. And it's fixable in 30 days.
Want us to map your pipeline?
Send us your website and the last 90 days of marketing spend. We'll send back a 10-minute Loom showing exactly where revenue is leaking and what we'd do about it.
No call required. No pitch unless you ask for one. You keep the audit whether you hire us or not.
P&C is a marketing accountability firm. We make marketing measurable in revenue, not impressions. We work with owner-operated businesses across Canada, the UK, and the US.
Related reading:
→ The Revenue Pipeline Most SMBs Don't Know They're Missing (pillar)
→ The 5-Minute Pipeline Self-Audit (free PDF, no email gate)