Sales Pipeline Metrics: The Few That Actually Matter

Eight pipeline metrics worth tracking, how to calculate each one, and what to do when the number looks wrong, plus the two metrics that matter when you sell with partners.

May 27, 2024 · By Joseph Lamoureux

Sales Pipeline Metrics: The Few That Actually Matter

There’s no shortage of sales metrics. The trouble is that most teams track too many and act on too few. A handful of pipeline metrics, calculated consistently and read together, tells you almost everything you need to know: whether there’s enough pipeline, whether it’s converting, and whether it’s moving fast enough.

Here are the eight worth tracking, with formulas and a worked example for each.

1. Qualified pipeline value

What it is: the total value of open deals that have passed qualification.

Why it matters: it’s the raw material for next quarter’s revenue. Unqualified interest doesn’t count; keep it visible, but separate.

Watch for: a big number made of a few very large deals. A pipeline of $1 million made of two $500,000 deals is far riskier than one made of thirty smaller ones.

2. Weighted pipeline (forecast)

Formula: closed revenue + the sum of each open deal’s value × its probability.

Example: $100,000 closed, plus a $200,000 deal at 50% and a $50,000 deal at 20%, gives a forecast of $100,000 + $100,000 + $10,000 = $210,000.

Watch for: probabilities that are really optimism. If the weighted forecast is consistently higher than what you actually close, your confidence levels need recalibrating. Recordbook calculates this automatically from each deal’s stage and confidence; see sales forecasting.

3. Pipeline coverage

Formula: qualified pipeline for a period ÷ revenue target for that period.

Example: $900,000 of qualified pipeline against a $300,000 quarterly target is 3× coverage.

What’s enough: roughly 1 ÷ your win rate. If you win 25% of qualified deals, you need about 4× coverage. Generic rules of thumb (“always 3×”) are a starting point; your own win rate is better.

4. Win rate

Formula: deals won ÷ (deals won + deals lost), over a period.

Example: 12 won and 36 lost last quarter is a 25% win rate.

Watch for: a high win rate because lost deals are never closed. Dead deals left open make the win rate look better and the pipeline look bigger. Measure win rate from qualified deals onward, so you’re not comparing it with every cold lead.

5. Average deal size

Formula: total revenue from won deals ÷ number of won deals.

Why it matters: it tells you how many deals you need, and whether you’re drifting toward smaller (often less profitable) customers or larger (often slower) ones.

6. Sales cycle length

Formula: average number of days from when a deal is created (or qualified) to when it’s closed won.

Why it matters: it tells you how far ahead you need to build pipeline. If deals take 90 days, next quarter’s revenue has to be in the pipeline today.

Watch for: deals that have been open far longer than your average cycle. They’re usually stalled, not slow.

7. Stage conversion rates

Formula: deals that moved from one stage to the next ÷ deals that entered the first stage, for each pair of stages.

Example: if 40 deals reached Proposal and 16 moved to Commit, Proposal-to-Commit conversion is 40%.

Why it matters: it shows where deals die. A sharp drop at one stage points to a specific problem: weak qualification, unclear pricing, a slow approval step.

8. Pipeline velocity

Formula: (number of qualified deals × win rate × average deal size) ÷ sales cycle length in days.

Example: 40 deals × 25% × $30,000 ÷ 90 days = about $3,333 of revenue per day.

Why it matters: it combines the other metrics into one number and shows which lever helps most. Adding 10 deals, raising win rate by 5 points or cutting the cycle by 15 days each move velocity; compare which is most realistic for your team.

Two metrics for teams that sell with partners

If partners bring you into deals or work them alongside you, add two more:

Partner-sourced and partner-influenced pipeline: qualified pipeline that a partner originated, and pipeline a partner helped move. Track them separately; they mean different things and are often measured differently in partner programs.
Co-sell win rate: win rate on deals worked with a partner, compared with deals you work alone. If it’s higher, that’s the case for investing more in partners.

Both depend on recording the source and the partner on every deal when it’s created. Recordbook’s attribution fields and tags make that part of the deal record; see custom reports with tags. For AWS co-sell specifically, the sourced-versus-influenced distinction also decides what counts in ACE; the AWS ACE guide explains why.

Reading the metrics together

Coverage low, win rate fine: you need more pipeline. Focus on generating qualified deals.
Coverage fine, forecast short: deals are early-stage or low-confidence. Focus on advancing them.
Coverage fine, win rate falling: look at qualification and the stage where conversion drops.
Everything fine, revenue late: the cycle is lengthening. Look for stalled deals and slow approval steps.

Getting the data right

Every metric here depends on three habits: closing lost deals promptly, keeping close dates current, and recording stage and value accurately. Without them the metrics are precise and wrong. How to improve sales pipeline management covers the weekly review that keeps the data honest.

Common questions

What is a good pipeline coverage ratio?

Roughly one divided by your win rate on qualified deals. At a 25% win rate you need about 4× your target in qualified pipeline; at 33%, about 3×.

How often should I calculate pipeline metrics?

Look at coverage and the forecast weekly, as part of the pipeline review. Win rate, deal size and cycle length move slowly, so monthly or quarterly is enough.

Which metric matters most for a small business?

Coverage against target. If there isn’t enough qualified pipeline, nothing else can make up for it, and it’s the earliest warning you’ll get.

Try it on your own pipeline

Recordbook is free to start. Every feature is on every plan, and adding your team or your partners costs nothing extra. Create your free workspace.