How pipeline value is calculated
Add up the expected value of every opportunity in your CRM that is still live — not yet won, not yet lost. That total is your raw pipeline value. It is a snapshot of a moment, so it rises when new opportunities are created and falls whenever a deal closes in either direction.
Most teams also keep a weighted version, where each deal is discounted by the probability attached to its stage before being added up. A first conversation counts for a fraction of its value; a signed-off proposal counts for most of it. Weighting makes the total more realistic, but only if those stage probabilities were set from your own closed history rather than picked because they looked sensible.
Why pipeline value matters
It is the earliest honest signal that marketing is working. Revenue arrives after the sales cycle has run, so on a long cycle a campaign that started in the spring shows up in the accounts much later. Pipeline created moves immediately, which lets you judge a channel while there is still time to change it.
It also turns a revenue target into a marketing target. Once you know your win rate and your typical sales cycle length, you can work backwards from the revenue you need to the amount of open pipeline you must be holding today, and from there to how many enquiries each channel has to produce. That chain is what stops lead targets being invented.
Where pipeline value goes wrong
Stale records are the standard problem. Deals that nobody wants to mark as lost sit in the pipeline with old close dates, quietly inflating the total until the number is fiction. If your pipeline only ever grows, it is not being maintained.
Optimistic values do the same damage more subtly. When the amount on a record is the largest version of the project rather than the version actually being discussed, every forecast built on it is wrong in the same direction. So does double counting: the same buyer entered twice through two channels appears as two opportunities.
The last mistake is treating pipeline as revenue. It is a measure of opportunity, and a large pipeline with a low win rate is a queue of work you will not be paid for.
How to act on it
Set hygiene rules and enforce them: every open deal has a realistic close date, a date that has passed forces a decision, and an opportunity with no activity for an agreed period is closed as lost. A smaller true pipeline is far more useful than a large imaginary one.
Then report pipeline created by source, not just pipeline held. That single split tells you which campaigns bring opportunities worth having rather than enquiries worth counting, and it is only possible if your forms, calls and ad platforms write cleanly into the CRM — which is a CRM integration question before it is a reporting one.