One pipeline number

Sales, finance and marketing each walk into the forecast meeting with a different pipeline number. Pour the open opportunities in at the top. Each sieve holds back the deals one rule doesn't count, and what lands in the tray is the number to report.

Download the sample file

Your file stays in this browser tab. Nothing gets uploaded or saved, and it's gone when you close the tab.

poured in: every open opportunity closing by the date above, at full contract value.

Qualified pipeline:

The sieves

Switch a sieve off to see what it holds back. The order matters: a deal is caught by the first sieve that stops it, so nothing is counted twice.

What each sieve caught

Tap a sieve in the drawing or open a list here. Each list shows the largest deals first.

Tallowtree's three numbers

On October 1, Tallowtree's CEO asked for fourth-quarter pipeline and got three answers.

TeamPipelineHow they counted
Sales$7.46MEverything open in the CRM, the top of the sorter
Finance$1.30MWhat reaches the tray with every sieve on
Marketing$5.57MAnything marketing sourced or touched in 90 days, at contract value

Marketing's number overlaps both of the others, so it can't be added to anything. Inside the tray, marketing sourced 18 deals worth $594K. That's the number marketing should own.

Write it down

The fix is one written definition. The other two numbers keep their jobs under names nobody can confuse with it.

Qualified pipeline
New and expansion deals past the early stages, closing this quarter, active in the last 45 days, at one year of value. The forecast, the board deck and coverage ratios use this, and only this is called pipeline.
Open opportunity total
Everything open in the CRM. For reps and managers cleaning up their deals. Not reported upward.
Marketing-sourced qualified pipeline
The part of qualified pipeline that started with a marketing lead. Marketing's target.

If you want this for your own numbers, I take on a few outside projects. I reconcile the numbers from your CRM, write the definition with your teams, and set up the one report that computes it. Fixed price $2,000, scoped in writing first. Hire me on Upwork.