If You Can't Trace Your Last 10 Deals, You Don't Have Marketing. You Have a Marketing Expense.
Knowing your ad spend is not the same as knowing what it produced. Here is a 30-day plan for improving attribution, with a worked example.
By Yasmin & Arsen | P&C Marketing Agency | Reading time: 8 minutes
Consider a business spending $8,000 a month on Google Ads for 14 months. That is $112,000. Here is an example of how an attribution gap can obscure what that money produced; the figures are illustrative.
Start with three questions.
How many of your last 10 customers came from those ads?
What's your average cost per closed deal from that channel?
What does your agency report on each month? Impressions. Click-through rate. Conversions, with conversions defined as form fills including spam.
If the first two answers are unknown, the example represents $112,000 of spend without a reliable link to sales.
Before concluding that the ads are failing, establish whether tracking can show what they produced.
That is the Stage 5 question.
Why Stage 5 matters to the whole pipeline
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.
A gap here can obscure the value of traffic, lead capture and qualification, even when those stages are working.
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 need reporting they can use to challenge decisions. A pipeline that cannot be traced makes it harder to hold marketing accountable, regardless of who manages it.
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 is an illustrative monthly campaign viewed two ways. Assume $8,000 spend, 3,847 clicks, 142 enquiries, 38 qualified leads, 11 closed deals and $34,000 deposited revenue. Calculated figures are rounded:
| 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 shows activity. The right column connects that activity to the example sales outcomes.
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.
Four Stage 5 leaks to check
These four checks apply to businesses that need to connect enquiries to sales. Use them to review your own pipeline; they do not depend on an industry benchmark.
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. Implementation time depends on the systems involved. Test that the source survives through to the closed deal.
Leak 2: Sales follow-up windows over 24 hours
A promised response time is not the same as an actual response time. Compare enquiry and callback timestamps, then assess close rates by response window in your own data.
Measuring response time makes delays visible. Improving it requires clear ownership, capacity and follow-up; measurement alone does not guarantee a faster response or a higher close rate.
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 can connect advertising to downstream outcomes. Its effect on performance depends on data quality, volume, sales-cycle length and how the bidding strategy uses it.
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.
A 30-day implementation plan
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 the records support. Leave unverified sources marked unknown; report the actual coverage achieved.
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.
Verify that closed-deal values arrive in the ad platforms and are attributed as expected. Reporting and optimisation timelines depend on data quality, platform processing and the sales cycle; a performance improvement is not automatic.
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.
That visibility supports better decisions. Profitability still depends on acquisition costs, delivery costs and margins.
Answering those questions puts a business in a stronger position to decide where to cut or invest when conditions change.
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. The 30-day plan above is a starting point; completion depends on access, integrations and the state of your data.
Want us to map your pipeline?
The Foundations Audit examines your marketing investment, attribution gaps and commercial priorities. Scope and fees are provided in your proposal.
We assess fit first, then agree paid scope, access and timing. An enquiry creates no commitment.
P&C is a marketing accountability firm. We make marketing measurable in revenue, not impressions. Our services are available to owner-operated businesses across Canada, the UK, and the US.