KPI Tree

Metric Definition

Total worth of open deals

Pipeline Value = Sum of (Deal Value x Stage Win Probability) for all open deals
Deal ValueExpected contract or annual value of each open opportunity
Stage Win ProbabilityLikelihood of closing based on the current pipeline stage

Track from

Metric GlossarySales Metrics

Sales pipeline value

Sales pipeline value is the combined monetary worth of all open opportunities in a sales pipeline at a given moment. It tells you how much potential revenue is in play and whether there is enough to hit the target. Weighting each deal by its stage probability turns a raw total into a realistic forecast of what will actually close.

8 min read

Generate AI summary

What is sales pipeline value?

Sales pipeline value is the combined monetary worth of all open opportunities in a sales pipeline at a given moment. It answers a simple question for any revenue leader: how much potential revenue is currently in play? Counted as a raw total it sums the full value of every open deal. Counted as a weighted total it multiplies each deal by its probability of closing, which gives a far more honest forecast.

The raw and weighted views serve different purposes. Raw pipeline value shows the ceiling, the most that could close if every deal won. Weighted pipeline value shows the realistic expectation, since a deal at the proposal stage is much more likely to close than one at first contact. If you have ten deals worth 50,000 pounds each, raw pipeline is 500,000 pounds, but if their average win probability is 30 per cent the weighted value is 150,000 pounds.

Pipeline value is most useful when read against the target. A common rule is that open pipeline should cover the quota gap by three to four times, because not every deal will close. A team that needs 1,000,000 pounds and holds only 1,200,000 pounds of raw pipeline is almost certainly short once probabilities are applied.

Definition note

Always state whether a pipeline value is raw or weighted. A raw total flatters the forecast because it treats a first call and a signed-off proposal as equally likely. The weighted total is what you should plan against.

How to calculate sales pipeline value

Weighted sales pipeline value is calculated by multiplying each open deal value by its stage win probability and summing the results across the whole pipeline. Raw pipeline value is the simpler sum of every open deal value with no probability applied.

For example, take four open deals. A 100,000 pound deal at discovery with a 10 per cent probability contributes 10,000 pounds. A 60,000 pound deal at qualification at 25 per cent contributes 15,000 pounds. An 80,000 pound deal at proposal at 50 per cent contributes 40,000 pounds. A 40,000 pound deal in negotiation at 75 per cent contributes 30,000 pounds. The raw pipeline is 280,000 pounds but the weighted pipeline is 95,000 pounds. That gap is exactly why weighting matters for any credible forecast.

  1. 1

    List every open opportunity

    Pull all deals that are currently open. Exclude closed won and closed lost, since pipeline value measures future revenue still in play, not past results.

  2. 2

    Attach a value to each deal

    Use a consistent value basis such as first year contract value or annual recurring revenue. Mixing one-off and recurring values in the same total distorts the number.

  3. 3

    Apply a stage win probability

    Assign each stage a probability based on your historical conversion from that stage to closed won, not on rep optimism. Use real conversion data so the weighting reflects reality.

  4. 4

    Sum for raw and weighted totals

    Add the raw deal values for the ceiling and the probability-weighted values for the realistic forecast. Report both so the team sees the spread.

Sales pipeline value in a metric tree

Pipeline value is a single headline number that hides a lot of moving parts. A metric tree breaks it into the drivers that actually move it, so when the number falls you can see whether the cause is fewer new deals, smaller deal sizes, stalled stages, or rising losses. Each branch maps to a different team and action.

Metric tree insight

A falling pipeline value usually has one dominant cause, but the headline number cannot tell you which. The tree separates new pipeline created from deal size, stage progression, and leakage, and KPI Tree attaches a RACI owner to each branch so the right team is alerted the moment their driver moves, then the verified impact loop confirms the fix took hold.

Sales pipeline value benchmarks

The most useful benchmark for pipeline value is coverage, the ratio of open pipeline to the revenue target for the period. Coverage requirements depend on win rate, since a lower win rate needs more pipeline to hit the same number. As a rough guide, divide three by your win rate to find the raw coverage you need.

Win rateRaw pipeline coverage neededRead
15%About 6x to 7x quotaLow win rate, large pipeline required
25%About 4x quotaCommon B2B benchmark
35%About 3x quotaEfficient, qualified pipeline
50%+About 2x quotaHigh intent or expansion motion

Benchmark note

Coverage below the benchmark for your win rate means the target is at risk no matter how large the raw number looks. Coverage far above it can signal bloated pipeline full of stalled deals that will never close.

How to improve sales pipeline value

Growing pipeline value in a healthy way means adding qualified deals, raising deal size, keeping deals moving, and cutting leakage, not stuffing the pipeline with unqualified opportunities that inflate the raw number and never close. Use the metric tree to find which driver is holding the number back, then act on that one.

Create more qualified pipeline

Increase the volume of well qualified opportunities through marketing and outbound. Adding unqualified deals lifts the raw total but lowers win rate, so the weighted value barely moves.

Raise average deal value

Sell higher tiers, more seats, and multi-year terms, and control discounting with deal desk governance. A larger average deal lifts pipeline value without needing more deals.

Keep deals progressing

Deals that stall in one stage drag weighted value down even when raw value holds. Find the stages where deals dwell longest and remove the friction that keeps them stuck.

Cut pipeline leakage

Track closed lost value and dormant deals as their own driver. Tighter qualification at entry and earlier disqualification of dead deals keep the pipeline honest and the forecast reliable.

Common mistakes when tracking sales pipeline value

  1. 1

    Reporting raw value as the forecast

    Raw pipeline treats every deal as equally likely to close. Presenting it as the expected number sets a target the team cannot hit once probabilities apply.

  2. 2

    Using optimistic stage probabilities

    Probabilities set by rep confidence rather than historical conversion inflate the weighted value. Base each stage on real closed won data so the forecast holds up.

  3. 3

    Letting stalled deals sit in pipeline

    Deals that have not moved in months keep counting toward pipeline value and mask the true gap to target. Age out or disqualify dormant deals on a regular cadence.

  4. 4

    Mixing value bases

    Combining one-off project values with recurring revenue in a single pipeline total makes the number impossible to interpret. Keep the value basis consistent across all deals.

Related metrics

Sales Pipeline Velocity

Sales Metrics
ApolloAttioHubSpotSalesforce

Metric Definition

Pipeline Velocity = (Opportunities × Deal Value × Win Rate) / Sales Cycle Length

Sales pipeline velocity measures how quickly deals move through your pipeline and generate revenue. It combines the four core levers of sales performance into a single metric that reveals the rate at which your pipeline converts to closed revenue.

View metric

Win Rate

Sales Metrics
ApolloHubSpotSalesforce

Metric Definition

Win Rate = (Closed-Won Deals / Total Closed Deals) × 100

Win rate measures the percentage of sales opportunities that result in a closed-won deal. It is the single most revealing metric of sales effectiveness, indicating how well your team converts qualified pipeline into revenue.

View metric

Average Deal Size

Sales Metrics
ApolloSalesforce

Metric Definition

Average Deal Size = Total Revenue from Closed Deals / Number of Closed Deals

Average deal size measures the mean revenue value of closed-won deals. It is a fundamental sales metric that directly influences pipeline velocity, quota planning, and the economics of your go-to-market model.

View metric

Quota Attainment

Sales Metrics
Salesforce

Metric Definition

Quota Attainment = (Actual Revenue Closed / Quota Target) × 100

Quota attainment measures the percentage of a sales target that a rep or team achieves in a given period. It is the primary performance metric for sales organisations, connecting individual and team output to revenue goals.

View metric

Metric trees for sales teams

Metric Definition

Sales pipeline value sits at the heart of a sales team metric tree, and this guide shows how to connect open deal worth to the conversion and velocity drivers your team can act on.

View metric

Conversion rate decomposition

Metric Definition

Pipeline value only converts to revenue through stage conversion, so this decomposition helps you trace how much of your open deal worth is likely to close.

View metric

See what is really inside your pipeline number

Build sales pipeline value as a metric tree in KPI Tree, breaking it into new pipeline, deal size, stage health, and leakage with an owner on each branch, so a drop in the forecast reaches the team that can act on it.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business