On this page7 sections
Growth Operations ResearchA bounded record review, not an industry benchmark.

Measuring the Age of Unresolved Pipeline Reviews

A bounded measurement design for pipeline review age, with a frozen population and a dated review.

Published ••3 min read
Measuring the Age of Unresolved Pipeline Reviews research illustration

Published November 5, 2026.

Question and scope

How long does a pipeline deal wait between documented reviews before it is advanced, stalled, or closed? The scope is the pipeline record in one growth team during a defined period, not an industry benchmark. The measure matters because an unreviewed deal can look active while nobody has spoken to the customer in weeks. This note does not judge whether the deal will close or whether the representative performed well. The narrow purpose is to describe the age of unresolved reviews and the stage where time accumulates.

Population and unit

Start with a dated export of deals that entered the pipeline during the review window. Record the source, stage, owner, last review date, next action, and expected close date. Include deals that were closed or removed during the window so the review can compare open and closed items. The unit is one deal, not one account. An account with several opportunities has several units, and each should be tracked separately when it has its own owner and stage. If the team tracks the account as one opportunity, keep the account as the unit and note the reduced precision. Exclude test deals and deals that were cancelled before review. Record the exclusions so the denominator can be reproduced.

Definitions and measures

A review begins when a documented customer conversation or internal review record is created. A deal closes when it is won, lost, or removed with a reason. A stage change without evidence is not a review. Compute age in whole days from the last review date to the review date for open deals, and from entry to close for closed deals. Report the median, the 75th percentile, and age bands such as under seven days, seven to fourteen days, fourteen to thirty days, and over thirty days. Split the age into customer wait and internal wait. Customer wait is the time since the last customer contact. Internal wait is the time since the last internal review. The split shows whether the deal is stalled with the customer or inside the team.

Evidence and data limits

Each deal needs the account reference, stage, owner, last contact, next action, and close evidence. If the review was recorded after the fact, mark the date as reconstructed. A reconstructed date is weaker evidence than a system timestamp. Preserve stalled and removed deals. Removing them can make the pipeline look healthier while hiding a pattern of inactivity. If the stage reason is free text, group it into a controlled list before analysis and keep the original text. Keep customer and commercial details in the approved system. The analysis file should use a deal reference rather than copying pricing or contact information.

Interpretation limits

A short review age does not prove that the deal is healthy. A deal can be reviewed often without a clear next action. Pair the timing measure with a sample of next-action quality before declaring the pipeline strong. A long review age does not prove that the deal is lost. The customer may have asked for a pause, or the team may be waiting for a budget cycle. Report the conditions present during the window. Avoid ranking representatives by review age. Deal mix, source, and customer timing all affect the path. The useful question is whether the cadence gives each deal a clear owner and next step.

Review cadence

Run a baseline review, then repeat after any change to the pipeline stages, the review cadence, or the team structure. A monthly cadence is practical for a steady team, while a quarterly review may be enough for a small pipeline. End each review with a decision record: change the review window, add a next-action requirement, assign a backup owner, or leave the process unchanged. Archive the export, the coding sheet, and the notes so the measurement can be repeated.

Sources

Sources

  1. https://www.ftc.gov/business-guidance/advertising-marketing
  2. https://www.nist.gov/cyberframework
  3. https://www.sba.gov/business-guide/grow-your-business
  4. https://www.dol.gov/
  5. https://www.census.gov/