The pipeline coverage formula, why the common three-times rule is a guess, how to derive the multiple your team actually needs from its own stage conversion history, the coverage by rep and by stage that comes out, and the gap to target in dollars that a sales leader can act on with weeks left.
Every sales leader knows the pipeline coverage ratio and most use three times because somebody said so once. The team's own history says what the multiple should be, per stage and per rep, and the answer is rarely three. This guide gives the formula, the derivation, and the gap that comes out.
Coverage = open pipeline closing in the period ÷ remaining target
Per team, per rep, per stage. And the multiple the team needs:
Needed multiple at stage s = 1 ÷ historical conversion of stage-s pipeline held at this week
Rep and opportunity identifiers only. Weekly pipeline exports are the source; a live view with no history cannot derive the multiple.
At week w of each past period, per stage, the share of pipeline value that closed within the period:
| Stage | Conversion at week 4, last 6 periods | Needed multiple | Range |
|---|---|---|---|
| Proposal | 42% | 2.4 | 2.1 to 2.9 |
| Negotiation | 68% | 1.5 | 1.3 to 1.7 |
| Discovery | 11% | 9.1 | 6 to 14 |
The team's blended multiple at week four is 2.8. Discovery-stage pipeline is worth a tenth of its face value for this period, which is why counting it at face value makes coverage look fine until week ten.
Per rep, weighted by stage:
Expected close = Σ stage pipeline × stage conversion Gap = remaining target − expected close
| Rep | Remaining target | Pipeline (face) | Naive coverage | Expected close | Gap |
|---|---|---|---|---|---|
| R-04 | $400,000 | $1.3m | 3.3× | $290,000 | $110,000 |
| R-11 | $350,000 | $800,000 | 2.3× | $370,000 | none |
| R-17 | $300,000 | $1.1m | 3.7× | $150,000 | $150,000 |
Rep R-17 has the best naive coverage and the worst gap, because the pipeline is all discovery. Rep R-11 has the worst naive coverage and no gap, because it is all negotiation. The three-times rule got both wrong.
Σ reps' pipeline = team pipeline, by stage
And every opportunity is in one stage with one close date. An opportunity with a close date in the past and an open stage is stale, fails a check, and is listed before it inflates anyone's coverage.
One multiple for all stages. The discovery-heavy rep looks covered.
Next-period pipeline counted. Close dates outside the period are next period's coverage.
Stale opportunities left in. Past close dates, still open. List and clean.
Multiple from fewer than four periods. Show the range; a narrow one from two periods is luck.
Mapped once, the weekly pipeline exports, the closed results and the targets produce the conversion history, the needed multiples, and the gap per rep every week. Covirage builds this from the exports as they are. The sales insights solution describes the setup, and the forecast bias guide covers the rep-level calibration that sits beside coverage.
It is not wrong so much as unjustified. A team that converts 40 percent of week-four pipeline needs 2.5 times; one that converts 20 percent needs 5. Three is right for a team that converts a third, and most teams have never checked.
Take the pipeline as it stood at the same week of past periods, per stage, and the share of it that closed in that period. The needed multiple per stage is one over that share. Four periods is the floor, and the range is shown.
It is coverage for next period, not this one. Coverage for the current period counts only opportunities with a close date inside it; the rest are shown separately as next-period coverage.