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!
Greg is COO and Co-Founder at Rekener. Greg’s career has been focused on using data to grow recurring revenue businesses. Before joining Rekener, he served as VP of Operations at ZeroTurnaround, where he built its strategy and operations practice, ran customer success and renewals, helped to grow and coach its high-velocity sales organization, and optimize its marketing efforts. Prior to that, he ran the BizOps and marketing functions for the AVOKE call center analytics business, a SaaS company within BBN Technologies. He got his start using data to improve sales and marketing efforts while at AppNeta. Greg is also a member of the Revenue Collective.
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.