How to Calculate Cohort-Based Sales Cycle

Cohort-based sales cycle measures the average amount of time between when an opportunity or deal is created, and when it is closed won, tracked by the created date of the opportunity.  To calculate cohort-based sales cycle, you first isolate all the deals that you won that were created in a particular period. Then, for each one, you track the number of days between when it was created and when it was closed.  You sum up all those days from all the opps, and then divide by the number of opps won.

For example, if you had 50 deals that were won, that were created in Q2, and the total number of days from creation to closed won for all of them combined was 1,000, then your sales cycle would be 1,000 / 50 = 20 days.

To measure cohort-based sales cycle with Salesforce data, you need to run a report of opportunities created in the period you want to measure, which are closed won.  Count how many opps that is. Then, for each opp, calculate the number of days between Created Date and Close Date. Sum up that total number of days. Then divide the number of days by number of opps you won.

To measure cohort-based sales cycle with HubSpot CRM data, you need to run a report of deals created in the period you want to measure, which are closed won.  Count how many deals that is. Then, for each deal, calculate the number of days between Created Date and Close Date. Sum up that total number of days. Then divide the number of days by number of deals you won.

Rekener can automate cohort-based sales cycle calculations, and can break conversion rates down by sales rep, opportunity type, industry, product, or any other dimension.  Check out our Sales Rep Scorecard app to see how Rekener calculates cohort-based sales cycle by sales rep automatically.

Read this article to see how to measure sales cycle overall.

Add new comment

Your comment will appear soon!

Gregory Keshian

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

Subscribe

Get the best BizOps content delivered to your inbox twice a month.