Pipeline to revenue conversion is the share of your qualified pipeline that ends up as closed-won revenue. Divide the dollars you won by the qualified pipeline dollars that entered the funnel in the same period, then multiply by 100. If $3 million of qualified pipeline produced $600,000 in wins, your conversion is 20%. The number only helps if you measure it the same way every quarter and break it down by stage, so you can see where the rest went.

This guide shows the formulas, a worked example, how to size the pipeline you need for a revenue target, and how to find the stage that costs you the most money. It is written for owners and leadership teams of mid-market companies who want revenue they can predict.

Dynamicgrowthsolutions
Find the Bottlenecks Behind Lost Revenue
Dynamic Growth Solutions uses real-time business data and stakeholder interviews to identify profit leaks and prioritize where to fix inefficiencies first.

Explore the ProfitDriver Analysis

TL;DR

Table of Contents

Pipeline value is not revenue

A sales pipeline shows where each prospect sits in your sales process. It helps you see next steps, roadblocks and delays, and gives a picture of potential revenue for forecasting. Pipeline value is the total dollar value of every deal currently in it. Forecast value adjusts that total using each deal’s probability of winning.

Neither figure is revenue. Under US GAAP, the FASB’s ASC 606 model has five steps: identify the contract, identify the performance obligations, determine the price, allocate it, and recognize revenue as you transfer control of the promised good or service. The practical effect for a service business is easy to see. On a 12-month consulting contract worth $60,000, the full amount is booked at signing, but only $5,000 is recognized each month as the work is delivered. The rest sits on the balance sheet as deferred revenue.

So “pipeline to revenue” really covers three steps: pipeline to closed-won (a sales measure), closed-won to recognized revenue (an accounting measure), and recognized revenue to cash (an operations measure). This article focuses on the first, then shows where the other two connect.

Pipeline value is not revenue

The three conversion formulas that matter

Use all three. Each answers a different question.

Metric Formula What it tells you
Stage conversion rate Deals that advanced ÷ deals that were in the stage at the start of the period × 100 Where deals stall or die
Win rate (deal count) Closed-won deals ÷ opportunities created in the same cohort × 100 How often you win
Dollar pipeline conversion Closed-won revenue ÷ qualified pipeline value × 100 How much of the money you chased you captured

The stage formula is easiest to see with numbers. If 80 deals were in Discovery at the start of the month and 32 reached Proposal by month-end, the stage conversion is 40%.

The dollar version can differ from the count version. In one published example, a mid-market cohort with $14.2 million in qualified pipeline produced $3.55 million in closed-won revenue, a 25.0% dollar conversion against a 15.8% deal-count win rate. The gap means the team was winning larger deals than it was losing. If your dollar rate is below your count rate, the opposite is happening: you win small and lose big.

Measure by cohort, and count every loss

Two habits distort most conversion reports.

Snapshots instead of cohorts. A cohort tracks deals that were created in a specific window. A point-in-time snapshot mixes deals from different months, which produces misleading rates. Pick a window, such as all opportunities created in Q1, and follow that group until every deal is won or lost.

Leaving out failures. Each stage’s denominator should include every deal that entered it, including stalled, lost and disqualified deals. Drop the losers and you get an artificially healthy pipeline. Deals still open should be excluded from decided outcomes, so you divide advanced deals by decided deals only, and end-to-end conversion is the product of the stage rates.

The same discipline applies upstream of sales. If marketing hands over leads that were never qualified, your early stage rates look terrible for reasons sales cannot fix. A clear process for qualifying inbound leads keeps the top of the funnel honest, and a website funnel analysis shows where visitors drop out before they ever become opportunities.

A worked example

This example is hypothetical, built to show the arithmetic. A $4 million services company creates 60 qualified opportunities in Q1, each worth about $50,000.

Stage Deals entering Deals advancing Stage conversion Deals lost Dollars lost
Qualified to Proposal 60 36 60% 24 $1,200,000
Proposal to Negotiation 36 20 55.6% 16 $800,000
Negotiation to Closed-won 20 12 60% 8 $400,000

End to end: 12 won ÷ 60 opportunities = 20% win rate. Closed-won revenue is 12 × $50,000 = $600,000, against $3,000,000 of qualified pipeline, so dollar conversion is also 20%. Multiply the stage rates (0.60 × 0.556 × 0.60) and you get the same 20%.

Now the useful part. The first stage loses the most dollars, $1.2 million. A five-point lift there is worth more than a five-point lift at negotiation, because more deals pass through it.

Weighted pipeline and forecasting

Total pipeline overstates what you will win. Weighted pipeline fixes that by multiplying each deal’s value by its close probability and adding the results. Pipedrive documents the same logic: weighted value equals total value times stage probability divided by 100, and a probability set on a specific deal overrides the stage default.

A $50,000 opportunity at 25% probability carries a weighted value of $12,500. Add the weighted values for all open deals, then add revenue already won, and you have an expected revenue figure to compare with your target.

Two cautions keep the forecast honest:

If your forecast depends on delivery staffing, the next constraint is whether you can serve what you win. Our guides to sales capacity planning and service delivery capacity planning cover that side.

How much pipeline you need: the coverage ratio

Coverage is qualified pipeline value divided by the revenue target for the same period. $600,000 of qualified pipeline against a $200,000 quota is 3:1 coverage. The planning rule runs the other way: required coverage equals 1 ÷ win rate. A 20% win rate calls for 5:1, about 33% for 3:1, and 50% for 2:1, per the same guide. A 25% win rate implies about 4x.

Win rates mapped to required pipeline coverage

Apply it to the example above. At a 20% win rate, a $500,000 quarterly target needs $2.5 million of qualified pipeline. If you have $1.5 million, you are at 3x, and no amount of closing skill closes the gap. You either build more pipeline or raise your conversion.

Use period-specific value. A three-year contract should count only the portion you expect to win and recognize in the period you are planning, not its total multi-year value.

Other metrics that explain the number

Conversion alone does not tell you why. Add these:

If velocity is flat while pipeline value grows, you are adding volume that is not converting, which usually points to qualification, not effort.

Find the bottleneck, then fix one thing at a time

A workable diagnostic sequence, adapted from a RevOps method:

  1. Measure stage conversion by cohort. Use the formulas above.
  2. Measure time in stage. Look at the median and the 75th and 90th percentiles. A long tail shows deals that are parked, not progressing.
  3. Watch accumulation. Count deals entering a stage per week against deals leaving it. When entries exceed exits for several weeks, it is an early warning that shows up weeks before conversion rates degrade, because deals must age before they are marked lost.
  4. Rank by dollars lost. Multiply deals lost at each transition by their value, as in the table above. The top row is your constraint.
  5. Diagnose, fix, re-measure. Find the root cause at that stage, apply one targeted change, and re-measure before moving to the next constraint.

Common root causes by stage: weak qualification at the top, proposals sent without a clear decision process in the middle, and discounting or legal delays at the bottom. They are different problems with different owners, which is why one blended win rate hides so much.

Where conversion leaks outside the pipeline

Owner-led companies often blame the sales team when the leak is elsewhere. Three places to check:

Our perspective

We see the same pattern in owner-led companies: the pipeline report looks busy, but the owner is still the one closing, approving discounts and rescuing stalled deals. Conversion stays flat because the process lives in one person’s head.

Our approach starts with a diagnostic before any program is sold. The ProfitDriver Analysis™ looks at real business data, interviews with stakeholders and the drivers behind results: people, systems and operations. The goal is a prioritized roadmap that shows where to fix inefficiencies first, which is the same logic as ranking pipeline stages by dollars lost.

Documented playbooks and delegation systems matter here. When stage criteria, handoffs and follow-up are written down, someone other than the owner can run them, conversion becomes measurable, and the business becomes easier to sell at a premium when you are ready to exit.

Andre

Find your biggest profit leak first

If your conversion numbers raise more questions than answers, the ProfitDriver Analysis™ is built for owner-led businesses with annual revenue between $3M and $5M. It identifies profit leaks, bottlenecks and underperforming areas, and gives you a prioritized roadmap for what to fix first.

Dynamicgrowthsolutions

If you want a structured, time-boxed push on a specific constraint, our Growth Sprint, Performance Sprint and Enterprise Sprint are one-off engagements. The Growth Sprint is published at $7,500 to $10,000 and the Performance Sprint at $15,000 to $20,000. You can also contact us to talk through where your pipeline is leaking.

FAQ

What is a good pipeline to revenue conversion rate?

It depends on your deal size, sales cycle and lead sources, so your own cohort history is the best benchmark. Published guides give ranges, but they mix industries and company sizes. Track your rate each quarter on the same definition and aim to improve it stage by stage.

What is the difference between pipeline and revenue?

Pipeline is the dollar value of deals still in progress. Revenue is what you have earned. Under ASC 606, revenue is recognized as you satisfy performance obligations, so even a signed contract produces revenue over time, not all at once.

How do I calculate pipeline coverage?

Divide qualified pipeline value by the revenue target for the same period. Then compare it with 1 ÷ your win rate. With a 20% win rate you need 5x coverage, so a $500,000 target requires $2.5 million in qualified pipeline.

Should I use weighted or unweighted pipeline?

Use both. Unweighted pipeline shows the size of the opportunity, and weighted pipeline shows a probability-adjusted forecast. Base the probabilities on your own stage-level history and revisit them each quarter.

Sources

Leave a Reply

Your email address will not be published. Required fields are marked *

BUSINESS PERFORMANCE ENGINE