How to calculate average time in stage
Average time in stage turns a vague sense that deals are slow into a precise benchmark for each stage. It is the basis for deal aging reports and for spotting where the pipeline bottlenecks.
Measured per stage, it reveals which step consistently takes longest, which is where process improvement or better enablement pays off most.
- Total days / deals The formula
- Per stage Where to measure
- Aging benchmark Flags stalls
Short answer
Average time in stage is how long deals typically spend in each pipeline stage. For a stage, sum the days each deal spent there and divide by the number of deals. If ten deals spent a combined 200 days in negotiation, the average is 20 days. It sets the benchmark for flagging stalled deals and diagnosing where the pipeline slows.
Step by step
Measure days per deal per stage
For each deal, record how many days it spent in each stage, from entry to advancing (or to now for open deals).
Sum days for a stage
Add the days all deals spent in a given stage over the period you are analyzing.
Divide by the number of deals
Average time in stage equals total days in the stage divided by the number of deals that passed through it.
Use it as an aging benchmark
Flag open deals sitting in a stage longer than its average. Those are the stalls a deal aging report and pipeline review should focus on.
Worked example
In the proposal stage, eight deals spent 15, 20, 25, 10, 30, 18, 22, and 20 days. The total is 160 days; divided by 8, the average time in proposal is 20 days.
Now any open deal sitting in proposal past 20 days is aging beyond the norm and worth attention. Comparing stages, if proposal averages 20 days but negotiation averages 45, negotiation is your slowest step and a candidate for process improvement.
How Ardovo handles it
Ardovo measures average time in stage from live deal history and flags deals exceeding it automatically. Rook surfaces the slowest stage and the aging deals within it, so your pipeline review starts with the stalls that matter.
Frequently asked questions
What is the average time in stage formula?
The total days all deals spent in a stage divided by the number of deals that passed through it. Measured per stage, it benchmarks how long deals normally take, which is the basis for flagging stalls.
How do I use average time in stage?
As an aging benchmark: flag open deals sitting in a stage longer than its average, since those are stalls. Comparing averages across stages also reveals your slowest step, a candidate for process improvement.
What is the difference between time in stage and sales cycle length?
Time in stage measures how long deals spend in a single stage; sales cycle length measures the total time from opportunity creation to close across all stages. Time in stage pinpoints where the cycle slows down.