Funnel math that matters

Most sales dashboards are theater, charts that track activity, not outcomes. Funnel math, done right, answers one question: where is the bottleneck, and what's it worth to fix? Every operator should be able to look at their funnel and within 5 minutes know the highest-leverage conversion rate to work on this quarter.

The stages

Every sales funnel. B2B, B2C, transactional or consultative, reduces to roughly the same structure:

1. Suspects, addressable market you've reached in some way (impressions, reached leads)
2. Leads, expressed some interest (opened email, visited site, filled form)
3. Qualified, matches ICP, has real need, decision authority confirmed
4. Opportunity, specific deal in discussion, budget confirmed
5. Proposal, offer presented
6. Closed-Won, signed

Whatever you call them in your CRM, these are the 6 stages. Collapse adjacent stages if they're the same in your business, but don't add more.

The rates that matter

Five conversion rates, one per stage transition. This is your funnel:

Suspect → Lead:        Top-of-funnel effectiveness
Lead → Qualified:      Lead quality / qualification rigor
Qualified → Opp:       Discovery effectiveness
Opp → Proposal:        Solution fit / stakeholder management
Proposal → Closed-Won: Close rate / pricing effectiveness

Multiply them together and you have overall funnel conversion. Divide 1 / (overall conversion) and you have how many suspects you need per deal.

Where to look for the bottleneck

The bottleneck is whichever stage has:

• The lowest conversion rate relative to industry benchmark
• AND has moved materially versus prior periods (deterioration)
• OR is the earliest stage where you're losing outsized volume

Example. You have 1,000 suspects/month, 30% convert to leads, 40% qualify, 50% become opps, 60% get proposals, 30% close. That's 1,000 × 0.3 × 0.4 × 0.5 × 0.6 × 0.3 = 10.8 deals/month.

If you double qualified→opp from 50% to 100%, you double total deals, that's the highest-leverage fix. If you improve proposal→close from 30% to 35% (which is much harder), you gain 1.8 deals. Work the bottleneck.

Time in stage

Conversion rate isn't enough. Track time in stage too:

• Deals that sit in "Qualified" for > 60 days almost never close, they're dead
• Deals in "Proposal" for > 30 days have usually lost momentum
• Average time in stage by stage gives you cycle length

Cycle length × number of deals in motion = how much pipeline you need at any moment. If cycle = 90 days and you need 30 closed deals/quarter, your pipeline needs to be 30 / close rate worth of active opportunities at any given time.

Pipeline coverage ratio

How much pipeline do I need to hit my quarter's number?

Pipeline coverage = Weighted pipeline ÷ Quarterly quota

Rule of thumb: 3x coverage for a predictable SaaS business. 4–5x for longer sales cycles or newer products. Below 3x = you'll miss.

The trap: stuffing the top

When the number is at risk, the instinct is to pump up top-of-funnel volume. If your qualified→opp rate is 15%, doubling leads doubles waste before it doubles deals. Fix the conversion stage before turning the volume knob.

Segmentation

Always segment your funnel rates:

• By channel, inbound vs outbound vs partner referral have wildly different conversion
• By segment. SMB vs enterprise
• By rep, your top reps have very different close rates than your bottom reps; the top rates are achievable with training
• By product, different SKUs convert at different rates

What good looks like

• The team knows the 5 stage-to-stage conversion rates cold
• Pipeline coverage ratio reviewed weekly
• The bottleneck is identified explicitly each quarter and someone owns fixing it
• Stale deals get cleaned out (moved to Lost or restarted) every 30 days

Related: Pipeline design · Unit economics · Churn diagnostics