Where exactly are deals dying in my funnel?
You're generating leads. Some become deals. But somewhere between first contact and closed won, deals are dying. Here's how to find exactly where.
The short answer
Run a deal stage funnel report. This shows how many deals enter each stage and how many advance to the next one. The stage with the biggest drop-off is where your deals are dying. Fix that stage and your entire pipeline improves.
One leaky stage can waste your entire pipeline
Imagine you generate 50 new leads a month. 30 become qualified deals. 20 get proposals. But only 4 close. The problem isn't lead volume. The problem is that 16 out of 20 proposals go nowhere. That's an 80% drop-off at one stage.
If you could improve that one stage from 20% conversion to 35%, you'd close 7 deals instead of 4. That's a 75% increase in revenue from fixing one bottleneck, not from generating more leads or hiring more reps.
But you can't fix what you can't see. Most business owners know their overall close rate. Very few know their stage-by-stage conversion. The funnel report is the single most useful tool in sales analytics.
Funnel metrics that pinpoint the problem
- Stage-to-stage conversion rate. What percentage of deals that enter Stage A advance to Stage B? Compare this across all stages. The lowest conversion rate is your bottleneck.
- Drop-off count per stage. Not just the percentage but the raw number. Losing 5 out of 50 deals at Discovery is less damaging than losing 12 out of 20 at Proposal.
- Lost reasons by stage.Why are deals dying at that stage? “No response” is a follow-up problem. “Went with competitor” is a positioning problem. “Budget” is a qualifying problem.
How to find your funnel bottleneck in HubSpot
- 1Create a Deal Stage Funnel report
Go to Reports → Create report. Search for “Deal stage funnel.” Select your pipeline. HubSpot shows the number of deals that passed through each stage and the conversion rate between stages.
- 2Identify the biggest drop-off
Look at each stage transition. If Discovery to Qualified converts at 65% but Proposal Sent to Closed Won converts at 18%, your proposals are the problem. Focus your improvement efforts on the stage with the lowest conversion.
- 3Check lost reasons at the bottleneck stage
Go to Reports → Analytics Tools → Sales Analytics. Select Deal lost reason analysis. Filter for deals that were lost from your bottleneck stage. The top reasons tell you what to fix.
- 4Filter by rep, source, or deal type
Use the funnel report filters to see if the bottleneck is universal or specific. Maybe outbound deals die at Proposal but referral deals don't. Maybe one rep converts well at that stage and others don't. These slices reveal whether the problem is process, people, or lead quality.
Total time: 15-20 minutes. The funnel report is available in Sales Hub Professional. Lost reason analysis requires that reps are actually logging lost reasons when they close deals.
How to find your funnel bottleneck in Salesforce
- 1Run an Opportunity History report
Go to Reports → New Report → Opportunity History. Group by Stage. For each stage, count the number of opportunities that entered and the number that advanced to the next stage. The difference is your drop-off.
- 2Use Stage Conversion in Revenue Intelligence
If enabled, go to Analytics → Revenue Intelligence → Stage Conversion. This pre-built view shows conversion percentages between each stage with trend data. It's the fastest way to spot your bottleneck.
- 3Analyze lost reasons at the bottleneck
Create an Opportunity report filtered for Closed Lost. Add the “Stage” field to see at which stage deals were lost. Group by the stage before loss and add the “Loss Reason” field. This tells you why deals die at each stage.
Total time: 15-25 minutes. Opportunity History gives the raw data. Revenue Intelligence gives the polished view (Enterprise and above).
Connect funnel drop-offs to revenue impact
Knowing where deals die is useful. Knowing how much money those dead deals represent is actionable. Take the average deal value at your bottleneck stage, multiply by the number of drop-offs per month, and apply your post-bottleneck close rate. That's the revenue you're leaving on the table. Cross-reference with your QuickBooks or Xero revenue to see what improving that one stage would mean in real collected dollars.
Monthly effort to monitor your funnel
A funnel review takes 15-20 minutes per month. The bigger investment is in actually fixing the bottleneck: updating your proposal process, improving qualification criteria, or coaching reps on a specific stage transition. The funnel report tells you where to invest that effort.
Or see exactly where deals die, every month, automatically
Bottomline builds your funnel analysis from CRM data every month and highlights the biggest bottleneck with the dollar impact.
Bottleneck: Proposal Sent to Negotiation. 78% of proposals go unanswered. Estimated revenue impact: $47,200/month.
No custom reports, no manual counting. One section of your monthly report tells you where deals die, why, and how much it's costing you. Fix the bottleneck, and you see the improvement reflected the following month.