Sales Pipeline Sankey Diagram: Editable Template
Show how opportunities move between pipeline stages and where they leave: lost, disqualified, stalled or returned to nurture. Replace the counts with your own pipeline data.
A pipeline Sankey is not a funnel: opportunities can leave at any stage in different ways, and some return to nurture instead of being lost. Each exit is its own ribbon, so you see how the pipeline drains, not only how much.
Of 1,000 opportunities created, 600 are qualified and 400 are disqualified. From there they move through demo, proposal and negotiation, and at each stage some are lost, some are returned to nurture and a few stall.
Counting them as exits of different kinds matters: a returned lead may come back, a lost one will not. Define each exit before counting. The numbers are invented.
How to read this diagram
- 1,000 opportunities enter; 100 are won, 10% in this example.
- 400 are disqualified at the start and 220 return to nurture; only 250 are actually lost, across three stages.
- The demo is the largest single drop after qualification: 180 of 450 do not reach a proposal.
- Of 160 in negotiation, 100 are won (63%).
The data behind it
Invented figures for illustration. Not data about any real business.
| From | To | Amount (opportunities) |
|---|---|---|
| Created | Qualified | 600 |
| Created | Disqualified | 400 |
| Qualified | Demo held | 450 |
| Qualified | Returned to nurture | 150 |
| Demo held | Proposal sent | 270 |
| Demo held | Returned to nurture | 70 |
| Demo held | Lost | 110 |
| Proposal sent | Negotiation | 160 |
| Proposal sent | Lost | 80 |
| Proposal sent | Stalled | 30 |
| Negotiation | Won | 100 |
| Negotiation | Lost | 60 |
The same data as CSV
source,target,value
Created,Qualified,600
Created,Disqualified,400
Qualified,Demo held,450
Qualified,Returned to nurture,150
Demo held,Proposal sent,270
Demo held,Returned to nurture,70
Demo held,Lost,110
Proposal sent,Negotiation,160
Proposal sent,Lost,80
Proposal sent,Stalled,30
Negotiation,Won,100
Negotiation,Lost,60How it works
List the stages and the exits
Write down each stage and each way an opportunity can leave it.
Take a cohort
Use opportunities created in one period, so each one is counted once.
Count the movements
Count how many moved to the next stage and how many left by each exit.
Check the balance
Each stage should send on what it received, including exits.
Frequently asked questions
How is this different from a sales funnel chart?
A funnel shows stage totals. A Sankey also shows what happened to the opportunities that did not continue, and lets stages branch.
What about opportunities that skip a stage?
Draw a flow from the earlier stage straight to the later one. Skipping is a branch like any other.
Edit this pipeline Sankey
Open the example as your own chart and enter your pipeline counts.