How to Audit Your Sales Funnel for Silent Deal Leakage
Most pipelines don't lose deals with a bang. They lose them quietly: a deal stalls at Proposal, nobody updates the stage, and three months later it's still sitting there as if it's live. By the time the number looks wrong, the leak has been running for a quarter.
A funnel leakage audit finds those gaps stage by stage, instead of waiting for the forecast to miss and guessing why. It's a two-hour exercise with a CRM export, not a consulting engagement, and it usually surfaces the same two or three problem areas every time.
Start with stage-to-stage conversion, not the total
Pull conversion rates between each adjacent stage over the last two quarters: Qualified to Discovery, Discovery to Proposal, Proposal to Negotiation, Negotiation to Closed Won. A funnel-wide win rate hides the problem; a stage-by-stage view shows exactly where deals are falling off. If Proposal to Negotiation is the weak link, that's a different fix (probably pricing or a missing champion) than if deals are dying between Discovery and Proposal, which usually points to weak qualification letting the wrong deals in early.
How do you separate real losses from stale deals?
Pull every open deal with no activity in the last 30 days. Some of these are genuinely still moving, just slower than your stage age assumes. Most are not: they lost momentum weeks ago and nobody marked them Closed Lost because that felt like giving up on the number. Left alone, these inflate your pipeline coverage and make your forecast look healthier than it really is, right up until the quarter closes and they never converted.
For example, imagine a deal sitting in Proposal for three months with no logged activity, and a rep who says it is still warm. Ask one question: what is the next step, and on what date? If there is a scheduled step with a named person on the buyer side, leave the deal open and keep an eye on it. If there is no date, no reply to recent outreach and no one moving it on either side, mark it closed lost with a real reason. Doing this consistently gives you a pipeline number you can trust, and it frees the rep to work deals that are actually alive.
Check where reps actually spend their time
Compare hours logged (calls, emails, meetings) against each stage. A common pattern: reps pour effort into early-stage prospecting because it feels productive, then under-invest in late-stage deals that need a champion check-in or a procurement nudge to actually close. If your time allocation doesn't match where deals are getting stuck, that's a coaching issue, not a tooling one, and no amount of new pipeline fixes a bottleneck that's really about follow-through.
Are your loss reasons honest?
Look at the loss-reason field across the last 100 closed-lost deals. If "No Decision" or "Lost to Competitor" accounts for the vast majority, the field isn't being filled in honestly; it's being filled in quickly. Push reps for a one-line note on what actually happened. Without that detail, you can't tell whether the leak is pricing, timing, a weak champion, or a feature gap, and each of those calls for a completely different fix.
Fix the exit criteria, not just the reporting
The audit itself doesn't stop the leak; tightening what it takes to move a deal forward does. For each stage, write down the one or two things that must be true before a deal advances, for example a confirmed budget owner before Proposal, or a signed mutual close plan before Negotiation. Deals that can't meet the bar stay where they are instead of drifting forward on hope, which keeps your stage-by-stage numbers honest the next time you run the audit.
Turn the findings into a standing review, not a one-time report
A single audit tells you where the leak was last quarter. The value compounds when you rerun the same four checks (stage conversion, stale deals, time allocation, loss reasons) on a fixed schedule and track whether the same stage keeps showing up. A leak that keeps recurring at the same point in the funnel, quarter after quarter, is telling you something structural about how deals move through your process, not something you can coach away one rep at a time.
You'll know the audit worked when stage-to-stage conversion stops swinging wildly between quarters and the stale-deal pull comes back mostly empty instead of full of forgotten opportunities. That stability is the real signal, more than any single quarter's win rate, because it means deals are moving through a process rather than surviving one.
Rerun these four checks on a fixed schedule:
- Compare conversion between each pair of adjacent stages over recent quarters, and note which stage keeps showing up as the weak link.
- Pull every open deal with no recent activity, and close or move back the ones that lost momentum weeks ago.
- Compare where reps spend their logged time against the stages where deals actually get stuck.
- Read a sample of closed-lost deals and push reps for a one-line note when the loss reason is generic.
What Good Looks Like
Good practice measures conversion stage by stage, not funnel-wide, so you can see exactly where deals stop moving instead of guessing from a single win rate.
Building The Capability (5-Stage Skill Ladder)
How to Get Started
Frequently Asked Questions
How often should a funnel leakage audit run?
Quarterly for most teams, with a lighter monthly check on stale deals in between. Doing it only at year-end means you're auditing the same leak for twelve months before you catch it, which is long enough for it to reshape your whole forecast.
What counts as a stale deal versus a slow one?
No logged activity, no next step, and no reply to outreach for 30 days or more is a reasonable line for most B2B cycles. A deal can be genuinely slow and still active if there's a scheduled next step; the difference is whether anyone, on either side, is still moving it.
Should the audit change how reps are coached, or how deals are scored?
Both, but start with coaching. If the audit shows deals consistently dying at the same stage across multiple reps, that's a process gap you can fix once. If it's concentrated in one rep's pipeline, it's a coaching conversation about qualification or follow-up discipline.
About the numbers
This guide doesn't quote a sourced benchmark. Figures in it are estimates or general guidance, so check them against your own numbers.
Related Guides
Where Your Outbound Funnel Actually Leaks: Stage-by-Stage Benchmarks
Realistic conversion numbers for each stage of a cold outbound funnel, and how to tell whether a low number means a real problem or normal variance.
Compensating Reps in a Product-Led Funnel Without Breaking Self-Serve
Commission an AE for every upgrade and reps start salting self-serve signups to claim credit. How to structure comp so product-led growth keeps working.
Getting Sales-Ready for an Enterprise Procurement Review
What to have prepared before an enterprise procurement or security review reaches your deal, so it becomes a formality instead of a two-month delay.
Gong vs Clari: Which One Flags a Deal at Risk Sooner
How Gong and Clari differ in surfacing deals that are quietly slipping, and which one fits a small revenue team versus a large multi-segment org.
What to Do When Your Buyer's Leadership Changes Mid-Deal
A worked example for re-engaging a deal fast when the buyer's leadership changes, instead of waiting and losing momentum to inertia.
What Lost Deals Can Tell You About Your Competitors
How to mine closed-lost deals for real competitive intelligence, instead of relying on a loss-reason dropdown nobody trusts.