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.
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:
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.
I guessed which column holds what from the headings. Fix any I got wrong.
Tap a sieve in the drawing or open a list here. Each list shows the largest deals first.
On October 1, Tallowtree's CEO asked for fourth-quarter pipeline and got three answers.
| Team | Pipeline | How they counted |
|---|---|---|
| Sales | $7.46M | Everything open in the CRM, the top of the sorter |
| Finance | $1.30M | What reaches the tray with every sieve on |
| Marketing | $5.57M | Anything 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.
The fix is one written definition. The other two numbers keep their jobs under names nobody can confuse with it.
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.