ooligo
ENTRY TYPE · Definition

Sales cycle length

By Marius Bughiu Last updated 2026-11-02 RevOps

If a sales manager asks how long a win takes, measure the days from opportunity creation to the actual win and report the median. If the question is how long the current pipeline has been waiting, measure the age of the open opportunities. A team can close its recent wins quickly while older deals remain on the books.

Pick the starting line and the reporting date

Take every opportunity created in a defined period. Give each opportunity one row, one ID, a creation date and its status as of the reporting date. For a win or loss, subtract creation from the actual closing date. For an open opportunity, subtract creation from the reporting date. Use calendar days in the same reporting timezone, with a same-day close counting as zero.

A CRM’s close date can represent a forecast. HubSpot, for example, can populate that field even for an open deal. Check the recorded outcome and closing event before treating the date as an actual close. Keep rows with missing dates or conflicting statuses on an exception list and report the count. HubSpot deal properties

Work the nine-deal example

The RevOps workbook contains a fictional July 2026 creation cohort. Open the Sales cycle tab. All nine opportunities were created July 1–31. The snapshot is October 31, 2026.

Status on October 31CountWhat the days measureDays in ascending orderMedian
Won5Creation to win10, 20, 30, 40, 10030
Lost2Creation to loss15, 3525
Open2Creation to snapshot100, 120110

For the five wins, the middle value (P50) is 30 days. With Excel’s inclusive percentile calculation, P90 estimates the 90th percentile. It falls 60% of the way from the fourth value of 40 to the fifth value of 100. That gives 76 days. The longest observed win took 100 days. Five wins are enough to check the calculation, but too few to treat 76 days as a promise to a buyer. Microsoft’s percentile calculation

The two open opportunities have already waited 100 and 120 days. Their median age is 110 days, and their eventual outcomes are unknown. Report those two cases beside the five wins. Removing the 100-day win because it moved slowly would also change the median of the remaining wins to 25 days.

Use the numbers in a pipeline review

For the 120-day open deal, inspect its stage history and ask the owner which buyer decision is pending. Record the next action and due date. For several similar delays, test a change to that stage with a later cohort. Use the same start event and elapsed observation time, then compare counts of wins, losses and open deals alongside P50 and P90. A shorter median among a handful of early wins alone tells you little about the deals still in progress.

Use the deal stage definitions to agree where a stage starts. If you use cycle length in pipeline velocity, document which population and summary statistic you used.

The forecast meeting prep workflow shows how to follow up on a change between two snapshots. For the cost of acquiring and retaining a customer, the unit economics and LTV:CAC guides use the other example in the same workbook.