Where's the bottleneck in my sales funnel?
Leads come in but deals are not closing. The problem is rarely at the top or the bottom of your funnel. It is in the middle, at a specific stage where deals stall, go dark, or fall out. Here is how to find exactly where.
The short answer
Your bottleneck is the pipeline stage with the biggest drop in conversion rate. If 80% of leads become qualified but only 30% of qualified leads get a demo, the bottleneck is between qualification and demo. To find it, you need to calculate the conversion rate between each consecutive deal stage and look for the steepest drop.
Why funnel bottlenecks silently kill your revenue
You have 50 leads in pipeline worth $400,000. Your close rate is 25%, so you expect $100,000. But what if 60% of those leads are stuck in “Proposal Sent” with no follow-up? Your expected revenue is not $100,000. It is much less, and your forecast is wrong.
Bottlenecks compound. If your demo-to-proposal conversion drops from 70% to 50%, that does not just affect that stage. It reduces the number of deals that reach negotiation, which reduces closed-won deals, which reduces revenue. A 20-point drop at one stage can cut your closed revenue by 30-40%.
The fix is different for every stage. A bottleneck at qualification means your lead sources are off. A bottleneck at proposal means your pricing or timing is wrong. A bottleneck at negotiation means your sales process needs work. You cannot fix the right thing until you know where the problem is.
What a funnel conversion analysis measures
For each consecutive pair of stages in your pipeline, you are calculating: how many deals entered stage A, and of those, how many made it to stage B? Typical B2B benchmarks from HubSpot funnel reports:
- MQL to SQL: 30-50% is healthy. Below 30% suggests your marketing is generating unqualified leads.
- SQL to Opportunity: 40-70%. A big drop here usually means sales qualification criteria are off.
- Opportunity to Proposal: 50-80%. Deals that make it to opportunity should mostly get proposals. If not, reps may be creating deals too early.
- Proposal to Closed Won: 20-40% for B2B SaaS. This is where pricing, competition, and urgency have the biggest impact.
How to find your funnel bottleneck in HubSpot (step by step)
HubSpot has a built-in funnel report, but it has limitations. Here is how to build the analysis:
- 1Go to Reports → Create custom report
Select “Funnel report” as the report type. Choose “Deals” as the object. Select your pipeline.
- 2Add your deal stages in order
Add each stage from your pipeline as a step in the funnel. HubSpot will show you how many deals entered each stage and the conversion rate between stages. Important: HubSpot can only calculate conversion for deals that actually passed through each stage. Deals that skip stages are excluded.
- 3Set the date range
Use the last 90 days to get enough deal volume for meaningful conversion rates. With fewer than 20 deals, the percentages will not be reliable.
- 4Identify the biggest drop
Look at the conversion rate between each pair of stages. The pair with the lowest conversion rate is your bottleneck. But also look at absolute numbers: a 40% drop between two stages with 100 deals is a bigger problem than a 60% drop between stages with 5 deals.
- 5Cross-reference with deal activity
For deals that stalled at the bottleneck stage, open each one and check the activity timeline. Are there follow-ups logged? How many days did the deal sit in that stage? This tells you whether the bottleneck is a process problem (no follow-up) or a qualification problem (wrong deals entering the stage).
Total time: 1-2 hours. The funnel report takes 15 minutes, but investigating why deals are stalling at the bottleneck stage requires opening individual deal records.
What it takes to track funnel health every month
A bottleneck is only useful if you track it over time. Did your intervention work? Is the conversion rate improving? Every month you need to:
- Re-run the funnel report with updated date ranges.
- Compare this month's conversion rates to last month's.
- Investigate any new drops to determine root cause.
- Cross-reference with your accounting data: are deals that pass through the funnel actually getting invoiced and paid?
The CRM tells you where deals stall. It does not tell you whether the deals that made it through actually turned into revenue. For that, you need to connect to QuickBooks.
Or find your bottleneck automatically, every month
Bottomline connects to your CRM and calculates conversion rates between every deal stage. It highlights the bottleneck stage, shows how it compares to last month, and flags deals that are currently stalled there.
Bottleneck: Demo to Proposal (29%). Down from 44% last month. 7 deals currently stalled at this stage.
Because Bottomline also connects to your accounting software, it follows the deals all the way through to payment. You see the full funnel from first lead to collected revenue, not just the CRM stages.