How to Calculate Stage to Stage Duration
Stage to Stage Duration measures the average amount of time it takes for opportunities or deals to move from one stage to the next. For example, if a rep had had 100 opportunities that moved from Stage 1 to Stage 2 in the sales process, and the total number of days between Stage 1 and 2 (if you added them all up) was 1,000 days, then the Stage 1 to Stage 2 Duration would be 1,000 days / 100 opps = 10 days.
To measure Stage to Stage Duration with Salesforce data,
you need to use both Opportunity and Opportunity History data. For each Opportunity, you want to determine the date that the opp made it to each stage. This will be indicated by an Opportunity History record existing in the stage in question. You want to use the Created Date of the first Opportunity History record that is in that stage. Meaning, if you are tracking the date an opp moved to Stage 2, then you would look at the earliest created date of any Opportunity History record in Stage 2 for that opp. You also need to track how many opps have made it to each stage.
To calculate the average Stage Duration, you need to subtract the Stage 1 Date from the Stage 2 Date for each opp that made it to Stage 2. Then, you need to sum up that total number of days. Then, divide the total number of days, by the number of opportunities that made it to Stage 2.
To measure Stage to Stage Duration with HubSpot CRM data,
you need to use data from the Deal object with DealStage History data. For each Deal, you want to determine the date that the deal made it to each stage, which will be indicated in the DealStage History.
To calculate the average Stage Duration, you need to subtract the Stage 1 Date from the Stage 2 Date for each deal that made it to Stage 2. Then, you need to sum up that total number of days. Then, divide the total number of days, by the number of deals that made it to Stage 2.
Rekener can calculate Stage to Stage Duration automatically,
and can measure it by sales rep, by account, or any other breakdown. Check out our Sales Rep Scorecard app to see how Rekener can track Stage Duration by sales rep automatically. Rekener calculates the duration from stage to stage for all of your stages, as well as duration from each stage to close for all your stages.
Add new comment
Your comment will appear soon!
Greg is COO and Co-Founder at Rekener. Greg’s entire career has been focused on using BizOps to grow recurring revenue businesses. Before joining Rekener, he served as VP of Operations at ZeroTurnaround, where he built its BizOps practice and team. He did the same for the AVOKE call center analytics business, a SaaS company within BBN Technologies. He got his start in BizOps for recurring revenue businesses while at AppNeta.
Sales Rep Scorecards
Rekener Sales Rep Scorecards is the quickest and easiest way to get all of your sales rep reporting done...period.Learn More
Get the best BizOps content delivered to your inbox twice a month.