Time in Stage

What is Time in Stage?

Time in Stage measures the average amount of time a lead, deal, or opportunity spends in a specific stage of the sales pipeline or customer journey.

It helps sales and marketing teams identify bottlenecks, inefficiencies, or friction points in the process. For example, if opportunities consistently spend too long in the Proposal stage, it may indicate issues with pricing, product fit, or follow-ups.

How to Calculate Time in Stage?

You can calculate Time in Stage by measuring the difference between the date an opportunity enters a stage and the date it leaves that stage, then averaging this duration across all opportunities.

Steps to Calculate Time in Stage

  • Step 1 – Define pipeline stages (e.g., Lead → SQL → Opportunity → Negotiation → Closed).
  • Step 2 – Record the entry and exit time for each opportunity in every stage (usually through CRM).
  • Step 3 – Calculate stage duration. Subtract the entry date from the exit date for each opportunity in that stage.
  • Step 4 – Find the mean time across all opportunities for that stage.
  • Stage 5 – Compare stage durations across deals, segments, and reps to identify inefficiencies.

Formula to Calculate Time in Stage

Time in Stage = ∑ (Exit Date−Entry Date) ÷ Number of Opportunities in Stage

Benchmark for Time in Stage

The ideal Time in Stage should be <14 days, depending on sales cycle.

Related Metrics for Time in Stage

  • Sales Cycle Length
  • Conversion Rate by Stage
  • Pipeline Velocity
  • Win Rate

FAQ's

Sales Cycle Length measures the total duration of the sales process, while Time in Stage isolates how long opportunities spend in each specific stage.

It often signals friction in that stage, such as unclear value proposition, lack of urgency, misaligned pricing, or slow follow-ups from the sales team.

Averages are common, but medians can be more reliable since outliers (very long or very short deals) can skew the average.