Stage-Weighted Pipeline Coverage Targets by Deal Type

Why a single multiplier fails

A 3x or 4x coverage rule assumes every deal in the pipeline has the same probability of closing and that deals are evenly distributed across stages. Neither is true in any real funnel.

If 60% of your pipeline sits in Stage 1 (qualified, not yet scoped), your 4x number looks healthy on a dashboard while your actual closable pipeline is a fraction of that. Conversely, a rep with £500k of late-stage deals against a £150k target looks over-covered until you notice three of those deals have not moved in 45 days.

The fix is not a better multiplier. It is stage-specific coverage targets, segmented by deal type, calibrated to your actual win rates and cycle length.

---

Step 1: Know your stage win rates

Before using the targets below, pull 12 months of closed data and calculate cumulative win rate from each stage. If you do not have this yet, use the defaults in the table and refine quarterly.

Typical cumulative win rates by stage (new business, B2B SaaS or complex services):

Your numbers will differ. Run your own cohort before Q-end reviews.

---

Step 2: Apply stage-weighted coverage targets

Coverage target = quota / cumulative win rate at that stage.

A rep with a £100k quarterly quota needs the following pipeline value at each stage to have a statistically sound chance of hitting number, assuming deals convert at the default rates above:

New business (net new logos)

The entire funnel does not need to meet every row simultaneously. The point is: if your rep has thin Stage 2 and Stage 3 cover today, Stage 1 volume does not rescue the quarter.

Renewal (existing contract, same scope)

Renewal win rates are structurally higher. Default cumulative win rates: Stage 1 (at-risk identified): 50-60%, Stage 2 (renewal scoped, decision maker confirmed): 75-85%, Stage 3 (commercials agreed): 90%+.

Watch point: renewals inflate pipeline health scores on mixed-funnel dashboards. If you report new business and renewal coverage in one number, you will systematically overstate how much true new revenue is in play.

Expansion (upsell or cross-sell into existing accounts)

Expansion sits between new business and renewal in difficulty. Default cumulative win rates: Stage 1 (opportunity identified, sponsor engaged): 25-35%, Stage 2 (solution scoped, budget discussed): 45-60%, Stage 3 (proposal out): 65-75%.

---

Step 3: Adjust for sales cycle length

Coverage thresholds assume deals that can close within the quarter. If your average sales cycle is longer than 90 days, early-stage deals carry no in-quarter value regardless of their value on paper.

---

The four failure modes

1. Thin early-stage cover

What it looks like: Late-stage pipeline is fine this quarter. Stage 1 and 2 are empty or have not had new entries in 4+ weeks.

Why it matters: You will hit this quarter and miss the next two. Early-stage drought is a lagging indicator of pipeline collapse in 60-90 days.

Warning sign: New Stage 1 entries per week have dropped more than 30% over the past month.

Diagnostic question for the review: "What went into Stage 1 in the last 14 days? What is the rep's plan to get [X deals] scoped before end of month?"

2. False comfort from stale late-stage deals

What it looks like: Stage 4 and 5 coverage looks strong, but several deals have not had a next step logged in 21+ days.

Why it matters: Stale late-stage deals are not pipeline. They are aspirations. A deal with no active next step and no recent engagement has an effective win rate close to zero, regardless of stage label.

Warning sign: Any Stage 4+ deal with last activity more than 21 days ago and no confirmed next step in the CRM.

Diagnostic question for the review: "What happened in that deal in the last three weeks? What is the next specific action, who owns it, and what is the date?"

3. Renewal inflation

What it looks like: Total pipeline coverage looks healthy, but new business cover is actually 1.5x or below when separated out.

Why it matters: Renewals are mostly retained revenue. Reporting them alongside new business makes new business gaps invisible until it is too late to recover.

Warning sign: More than 40% of pipeline value is renewals on a new business quota.

Diagnostic question for the review: "If we strip out all renewals, what is our new business coverage at Stage 3 and above?"

4. Single-rep concentration risk

What it looks like: Team-level coverage looks fine, but one rep holds 60%+ of the late-stage pipeline. Other reps are thin across all stages.

Why it matters: If that rep's deals slip, the whole team misses. The manager sees a healthy aggregate number until week 10, then has no recovery options.

Warning sign: One rep accounts for more than 50% of Stage 4+ pipeline by value.

Diagnostic question for the review: "If [rep name]'s three biggest deals all slip to next quarter, what does the team number look like? Who else has closable deals?"

---

Monday pipeline review decision table

Use this table to call a coverage problem in under five minutes. Check each row. Any "No" triggers the diagnostic for that failure mode before moving on.

---

When NOT to use this framework

• Teams under 6 months old with fewer than 20 closed deals in the dataset. You do not have reliable win rate data by stage. Use a flat 4x rule and track actively closed deals to build the dataset.
• Transactional sales with cycles under two weeks. Stage weighting adds complexity without value. Track weekly opportunity volume instead.
• Any team where stage definitions are not enforced consistently in the CRM. Fix stage hygiene first. Weighted coverage built on inconsistent stage labels will produce numbers that are worse than useless: they will look authoritative while being wrong.

---

Calibration cadence