Weighted pipeline

The definition

Weighted pipeline is the total value of your open deals after each deal is discounted by the probability of its current stage. A €20,000 deal in a stage with a 40 percent probability contributes €8,000. A €5,000 deal in a 90 percent stage contributes €4,500. Add every contribution together and you have the weighted pipeline value.

The logic is statistical, not personal. The probability does not say this deal has a 40 percent chance. It says that historically, 40 percent of deals that reached this stage went on to close. Weighted pipeline is therefore an expected value across the whole book. On any single deal it is wrong by definition. Deals close at 100 percent or at zero, never at 40. Across enough deals, the errors cancel and the total becomes useful.

Why it matters

Raw pipeline value flatters everyone. Take a team with €500,000 of open deals. Sounds healthy. Now weight it: €300,000 sits in an early qualification stage at 15 percent, €150,000 in proposal at 40 percent, and €50,000 in negotiation at 75 percent. The weighted total is €45,000 plus €60,000 plus €37,500, which is €142,500. If quarterly quota is €200,000, the honest conversation starts now, not in week eleven.

That is the job of the metric. It converts a feel-good gross number into an expected outcome you can compare against target. It also gives pipeline coverage its numerator and feeds the forecasting method this site recommends. Teams that skip the weighting stage discover their shortfall when the quarter ends. Teams that read the weighted number weekly discover it while there is still time to generate pipeline.

How to set it up in Pipedrive

The metric needs exactly one thing configured well: stage probabilities. Open the pipeline settings, enable deal probability, and set a percentage per stage. Base each percentage on history, not on optimism. The conversion report in Insights shows what share of deals entering each stage eventually won. Use those numbers, rounded to the nearest five. The full method, including exit criteria per stage, is in stages and probabilities.

Reading the number takes two forms. In the pipeline view, switch the footer display to weighted value and each stage shows its discounted total. For reporting, build an Insights deal report on open deals, summed by weighted value, split by expected close month. Put it on the team dashboard next to the unweighted total, so the gap between gross and expected stays visible. One warning: Pipedrive also allows a probability per individual deal, which overrides the stage number. Use that override rarely and with a note on the deal, or the metric quietly becomes opinion again.

Where teams get it wrong

The classic failure is stale probabilities. A stage set to 60 percent three years ago, while actual conversion has drifted to 35, inflates every report built on it. Recheck against Insights history twice a year. The second failure is rotting inventory: deals that stopped moving keep their full stage probability while their real chance decays toward zero. Weighted pipeline has no sense of time, so pair it with the deal rotting playbook to flush dead value out of the total. The third failure is small numbers. On a pipeline of ten deals the weighted total is statistical theatre, because one €100,000 deal at 40 percent is not €40,000 of anything. It is a coin flip with stakes.

Finally, beware the double discount. Some managers weight the pipeline and then apply a gut haircut on top, while reps sandbag stage placement to manage expectations. Now the number is discounted three times and nobody knows by how much. Pick one mechanism, make it the stage probabilities, and keep the judgement layer explicit and separate.

Questions