The Deal Velocity Formula
Deal velocity measures the average number of days from opportunity creation to closed-won. The basic formula is:``` Deal Velocity (days) = Sum of Days to Close ÷ Number of Closed Deals ```
For a period, take every closed-won opportunity, calculate the number of calendar days between the opportunity create date and the close date, sum those values, and divide by the total deal count. This produces your average deal cycle in days.
Segmenting for Accuracy
A single blended average rarely produces actionable insight. Segment deal velocity by:
| Dimension | Why It Matters |
|---|---|
| Deal size band (SMB / Mid-Market / Enterprise) | Cycle length scales with deal size and buying complexity |
| Rep | Reveals coaching targets and productivity gaps |
| Lead source | Inbound deals often close faster than outbound |
| Product line or SKU | Complex products carry longer technical evaluation cycles |
| Quarter or fiscal period | Seasonality effects compress or extend cycles |
Setting Stage-Level SLA Thresholds
Average deal velocity at the opportunity level is a lagging indicator. Stage-level thresholds give you a leading signal. For each pipeline stage, calculate the median time-in-stage for deals that ultimately closed, then set a threshold at roughly the 75th percentile of that distribution. Deals sitting above the threshold are candidates for review or re-qualification.
This approach works alongside deal velocity metrics tracking at the stage level. It gives managers a concrete trigger for inspection rather than waiting for deals to miss a projected close date.
Connecting Deal Velocity to Forecasting
Deal velocity feeds directly into sales cycle length modeling. If your average deal cycle is 90 days and your quarter ends in 30 days, any deal entering the pipeline today cannot close this quarter without exceptional circumstances. This constraint is foundational to pipeline coverage calculations and commit-category rules.
When deal velocity degrades quarter over quarter, diagnose at the stage level before adjusting quotas or coverage ratios. A slowdown in early-stage progression is a different problem than a slowdown in late-stage negotiation.
Frequently Asked Questions
How do you calculate deal velocity?
Sum the number of days from opportunity creation to close-won date for all deals in a period, then divide by the number of deals. This gives you average deal velocity. Exclude outliers and lost deals from the denominator unless you are specifically measuring lost deal cycles.
Should deal velocity be calculated separately by deal size?
Yes. Enterprise deals will almost always carry a longer cycle than SMB deals. Blending them into a single average obscures both the true enterprise cycle and the SMB cycle, making the metric useless for stage-level SLA setting or rep benchmarking.
What is a stage-level SLA threshold?
A stage-level SLA threshold is the maximum number of days a deal should spend in a given pipeline stage before it is flagged for inspection. Setting these requires historical data on your average time-in-stage by deal segment.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like deal velocity formula into prescriptive action for your team.
Schedule a Demo