Read a Sales-Cycle Average With the Open Deals Still in View
A report based only on completed opportunities can describe those finished deals accurately while leaving the current workload out of sight. Before using a sales-cycle average to predict timing, ask which opportunities entered the calculation and what remains open. The average and the age of unfinished work answer different questions.
Define the beginning and ending events
Agree which event starts the clock and which event counts as completion. A first inquiry, a qualified opportunity and an accepted agreement are different milestones. Keep the definition stable across comparisons, and state whether the measure includes won, lost or other completed outcomes. Changing the start point can change the reported duration even when the underlying selling process has not become faster. Record the definition beside the result rather than relying on a familiar chart title.
Show what the finished group leaves out
Keep open opportunities visible with their current ages and status, without assigning them invented completion dates. If the newest or quickest cases finish first, their durations alone cannot describe every opportunity still underway. This does not mean the completed-deal average is useless; it means its scope must remain clear. Separate a description of observed completed work from a forecast that requires further judgment about the present pipeline.
Use the difference to ask a better planning question
Review whether a change reflects the mix of work, an altered definition or evidence of a changed process. A small sample or one unusually long case should be explained rather than quietly removed to improve the number. No fixed sales benchmark is required for this review. Keep the report’s limitations visible before turning it into staffing assumptions or a promise to a buyer. The method is general reporting guidance, not a claim about a current CloseRail forecasting feature.
Copyable worksheet
Use one row for each field. Mark unknown information clearly and retain the original records.
| Field | Your note |
|---|---|
| Clock-start event | ____________________ |
| Completion events included | ____________________ |
| Completed group and period | ____________________ |
| Open opportunities and current ages | ____________________ |
| Planning conclusion and limits | ____________________ |
Worked example
Illustrative example: a fictional team finishes two opportunities in ten days each while another has been open for sixty days. The completed average is ten days, but the team displays the open case separately. It does not announce that every current opportunity is likely to finish within that average.