Pipeline Hygiene vs Pipeline Health
August 1, 2026
Pipeline hygiene measures whether the data is maintained. Pipeline health measures whether the business is performing. Conflating them produces the most common diagnostic error in revenue reporting: treating a data problem as a performance problem.
Two different questions get asked of the same dashboard. Is the pipeline data trustworthy, and is the pipeline any good? Answering the second before establishing the first is the most common diagnostic error in revenue reporting, and it reliably produces interventions aimed at the wrong system.
The distinction
Pipeline hygiene is a property of the record: whether close dates are current, stages accurate, amounts maintained, ownership correct. Pipeline health is a property of the business: coverage against target, stage conversion, velocity, win rate.
The dependency
Four hygiene measures that need no interpretation
None of these requires a target or a judgement. Each is arithmetic on the record.
| Measure | Calculation | What a high figure implies |
|---|---|---|
| Stale close dates | Open opportunities with a close date in the past | Coverage is inflated by pipeline that no longer exists |
| Inactivity | Open opportunities with no activity within one typical cycle | Deals are abandoned rather than lost; win rate is overstated |
| Stage stagnation | Stage unchanged beyond one typical stage duration | Stage no longer describes the deal's real position |
| Missing fields | No owner, amount, or required qualifying field | Routing, forecasting and reporting all degrade together |
Source: Measures proposed here
Why conflating them is expensive
The two conditions present identically on a dashboard and require opposite responses.
A pipeline appearing to convert poorly may be converting normally while carrying significant volume that should have been closed months ago. The apparent conversion problem is an arithmetic artefact of a stale denominator. The correct intervention is a hygiene process; the intervention usually applied is pressure on the sales team, which does not clean the data and does erode trust in the reporting.
The reverse error is subtler and more damaging. Closing stale opportunities improves every ratio computed from open pipeline, so an organisation that cleans up while genuinely declining can register as improving — and will act on that reading.
The sequencing rule
Method: separating the two in one afternoon
Compute the four hygiene measures on current open pipeline. Record them with the date.
Recompute your headline conversion metric twice: once on all open pipeline, once excluding records failing any hygiene measure.
Compare. A large gap means your reported conversion is substantially an artefact of record quality rather than a description of performance.
If the gap is large, fix hygiene before interpreting any health metric — and say so to whoever is asking about conversion.
Re-run monthly. The gap between the two figures is itself the metric worth tracking; it should shrink.
Making hygiene structural
Hygiene achieved by campaign decays predictably, because nothing about the system changed. Three things make it hold: a named owner for each measure, definitions encoded in the system rather than stated in a document, and a standing view surfacing violations continuously so the periodic purge is replaced by continuous small correction.
The underlying principle generalises well beyond pipeline. A measure nobody owns will drift, and the drift is discovered at the moment the measure is needed for a decision.
Where this fails
Very long sales cycles make the staleness measures noisy — a close date twelve months out is not stale in an eighteen-month enterprise cycle. Calibrate every threshold to your own median cycle length rather than to a fixed number of days, or the panel will generate false findings and be ignored.
COMMON QUESTIONS
- What is pipeline hygiene?
- Whether the pipeline record reflects reality: close dates current, stages accurate, amounts maintained, ownership correct. It is a property of the data, not of the business.
- How do you measure pipeline hygiene?
- Four measures needing no interpretation: open opportunities with a close date in the past, those with no activity within a typical cycle, those whose stage has not changed beyond a typical stage duration, and those missing an owner or amount.
- Why does poor hygiene make conversion metrics unreliable?
- Because health metrics are computed from the record. With stale records in the denominator, a genuine decline cannot be distinguished from a maintenance lapse — the metric becomes unfalsifiable rather than merely imprecise.
- How do you keep pipeline clean without a quarterly cleanup?
- Give each hygiene measure a named owner, encode the definitions in the system rather than a document, and surface violations continuously in a standing view — replacing the periodic purge with continuous small correction.
WHERE THIS HAS BEEN APPLIED
Client work and research from RevOps HQ, our consulting practice.
Go deeper: CRM Admin 101
The interactive tools behind this writing — process builders, inventories and the audit export — live inside the membership.
See the course