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

Measuring Stage Age by Lead Source in a Sales Pipeline

A bounded measurement design for comparing stage age across lead sources in a sales pipeline.

Published ••3 min read
Measuring Stage Age by Lead Source in a Sales Pipeline research illustration

Published November 7, 2026.

Question and scope

Do deals from some lead sources stay in a pipeline stage longer than deals from other sources? The scope is the pipeline record in one growth team during a defined period, not an industry benchmark. The measure matters because a source that produces slow-moving deals may need a different qualification or follow-up path. This note does not judge whether a source is good or bad. The narrow purpose is to describe stage age by source and the deals that explain the difference.

Population and unit

Start with a dated export of deals that entered the pipeline during the review window. Record the source, stage-entry date, current stage, owner, amount, and next action. Include closed and removed deals so the review can compare the full path. The unit is one deal in one stage. A deal that passed through three stages creates three units, because each stage can have a different age. If the export shows only the current stage, note that the earlier stages are not observable. Exclude test deals and deals with no source value. Record the exclusions so the denominator can be reproduced.

Definitions and measures

Stage age is the number of whole days from the stage-entry date to the review date. A stage move is a documented change supported by a customer or internal event. An edit without a move does not reset the clock. Report the median, the 75th percentile, and age bands by source. Also report the share of deals beyond the team's review threshold. A single average per source can hide a long tail. Split the age by stage and by owner. A source may look slow because most of its deals sit in one stage, or because one owner carries a difficult segment. The split shows where the difference sits.

Evidence and data limits

Each deal needs the source, stage-entry date, current stage, last contact, and next action. If the stage-entry date is missing, mark the deal as unverified rather than estimating from the last edit. Preserve the original source value. If the source was later corrected, record both values and the reason. A corrected source can change the segment comparison. Keep customer and pricing details in the approved system. The analysis file should use a deal reference rather than copying commercial terms.

Interpretation limits

A higher stage age does not prove that a source is poor. The source may produce larger deals that require more review. Report the deal size and stage mix beside the age. A lower age does not prove that the source is strong. Deals may be moving quickly because they are small or because the stage definitions are loose. Pair the age measure with a sample of stage-move evidence. Avoid ranking sources on a single month. Use several periods and report the sample size. A small source can produce an extreme result that does not repeat.

Review cadence

Run the review quarterly, then repeat after any change to qualification, routing, or stage definitions. End with one process change, one owner, and one recheck date. Archive the export and the coding sheet so the measurement can be repeated. Keep the observation window beside the finding so the next review compares like with like.

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/