Sales funnel length: average deal time and how to shorten it
Funnel length shows how much time on average passes from the appearance of a lead to the final outcome — a won or lost deal. It is an indicator of the speed of the sales process and the quality of customer interaction: the shorter the cycle while conversion and margin are maintained, the faster the company recoups its marketing investment and the more reliably it forecasts revenue.
What the Metric Measures
The metric reflects how fast a lead moves through the stages: receiving the inquiry, qualification, demo/proposal, negotiations, signing/payment. It helps find bottlenecks and assess the team's workload and the impact of seasonality, price changes, or promotions.
Calculation
- Average deal time = sum of the durations of all closed deals for the period / number of such deals
- Also look at the median — it is less sensitive to "long tails"
- For detailed control, calculate time in stage (time-in-stage) and the share of deals that get stuck longer than a set threshold
- Use a cohort approach: compare deals from leads that came in during the same period
- Track separately the "to win" metric and the "to any outcome" metric — lost deals may close on a different timeline
Calculation example
25 deals closed in a month; in total 1,125 days passed from first contact to payment. Average deal time = 1,125 / 25 = 45 days. If the median is 30 days, a few very long deals pull the average up — review those first.
Data Sources
A CRM with timestamps for transitions between statuses, call and correspondence logs, billing/payment services to record the moment of payment, request systems in B2B. It is important to have uniform stage definitions and automatic time recording.
Interpretation
A shorter funnel with unchanged or higher conversion means growing operational efficiency. A sharp lengthening is a signal of a "jam" at a certain stage, a lack of resources, a weak offer, or complicated conditions (approvals, legal procedures, logistics). Compare segments: large deals naturally have longer cycles, while repeat customers have shorter ones.
Useful Breakdowns
- Acquisition channels and campaigns
- Products/pricing plans and deal size
- Managers and teams, regions
- New vs. repeat customers, SMB vs. enterprise
- Funnel stages (where exactly time accumulates)
Dashboard Visualizations
- Line or bar chart of average/median deal time by period
- "Time funnel": duration of each stage with conversion percentages
- Distribution (histogram) of deal times highlighting the "long tails"
- "Manager × stage" heatmap to find bottlenecks
- Cumulative time-to-win curves by channel/segment
How to Set Targets
Set an SLA for first contact (minutes/hours), time thresholds at key stages, and a target median cycle by segment. Review the benchmarks quarterly, taking into account seasonality, product changes, and the lead mix.
Common Mistakes
- Counting only won deals (survivor bias)
- Mixing calendar and business days
- Different stage definitions across teams
- Ignoring time zones
- Incorrect handling of reassignments between managers
- No control over "stalled" deals
Questions for Discussion
- At which stage do we lose the most time, and why?
- Are we meeting the first-contact SLA?
- Which automations or templates will cut the time needed to prepare a proposal?
- What should we change in agreeing on terms to remove 1–2 days from the cycle this month?