Pipeline Hygiene
Whether pipeline records are accurate and current — as distinct from pipeline health, which is whether the pipeline is any good.
Why it matters more than it sounds
Every pipeline metric is computed from these records. Coverage, weighted value, conversion, cycle length and forecast accuracy all inherit whatever inaccuracy sits in the opportunity set. Hygiene is not tidiness — it is the input quality of the entire forecasting apparatus.
The asymmetry that causes decay
The four checks
Past-dated opportunities: open records whose close date has passed. The simplest check and usually the largest single finding.
Dormant opportunities: no logged activity within a window appropriate to your cycle. Report the share of pipeline value, not just the count.
Over-age opportunities: older than the median sales cycle for their segment. These convert materially worse and should be reported separately from healthy pipeline.
Sub-hour stage transitions and skipped stages: indicators that the record is being updated in batches rather than as the deal moves.
A routine that holds
Flag automatically, decide manually. Force a choice — keep, re-date with a reason, or close — rather than closing records automatically and discarding slow but real deals.
Require a reason on re-dating. A close date moved three times without explanation is the clearest single predictor of a deal that will not close.
Report hygiene alongside coverage, always. Coverage computed over unhygienic pipeline is a number that improves as the situation worsens.
Make loss recording low-friction and low-blame. Where recording a loss is costly, it will not happen, and the pipeline will keep the record instead.
The measure to watch
Track the share of pipeline value sitting in flagged records over time. Rising coverage alongside rising flagged share means the coverage improvement is an artefact — which is a specific, checkable finding rather than a suspicion.
RELATED TERMS
Data Hygiene
The continuous practice of keeping records accurate, complete and current — as distinct from data quality, which is the state that practice produces.
Time in Stage
How long opportunities remain in each pipeline stage. The diagnostic that localises where deals actually stall.
Forecast Accuracy
How closely forecasts match actual results, measured consistently over time. The metric that separates disciplined forecasting from lucky forecasting.
Pipeline Coverage
The ratio of open pipeline value to the target for a period. Answers whether there is enough in play to hit the number at historical conversion rates.
COMMON QUESTIONS
- What is pipeline hygiene?
- Keeping opportunity records accurate — realistic close dates, current stages, and closure of deals that are no longer live. Every downstream forecast and conversion metric depends on it.
- How do you measure pipeline hygiene?
- Four checks: opportunities past their close date, opportunities with no activity in a defined window, opportunities older than the median sales cycle, and stage transitions completed in under an hour.
- Why does pipeline hygiene decay?
- Because closing a deal as lost has an immediate visible cost to the seller and no immediate benefit. Absent a routine that forces the decision, records accumulate in a state that flatters coverage.
- Should hygiene be enforced with automation?
- Automatic closure of stale opportunities is blunt and discards real deals with slow buying cycles. A better pattern is automatic flagging with a required human decision — keep, re-date with a reason, or close.
FURTHER READING
How to Audit CRM Data Quality
Six measures that require no tooling, no interpretation and no targets — and that together tell you whether the reporting built on this database can be trusted.
Dysfunctional Consequences of Revenue Performance Measurement: Three Distortion Mechanisms
Ridgway's 1956 finding — that performance measures reliably produce behaviour optimising the measure rather than the goal — applied to revenue metrics, with a diagnostic for detecting distortion in data an organisation already holds.
Learn how to apply this: CRM Admin 101
Definitions are the vocabulary. The courses are where you learn to operate it, with the interactive audit tools.
See the course