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.

Sales Pipeline Sankey Diagram: Editable Template (opportunities)
FromToAmount (opportunities)
CreatedQualified600
CreatedDisqualified400
QualifiedDemo held450
QualifiedReturned to nurture150
Demo heldProposal sent270
Demo heldReturned to nurture70
Demo heldLost110
Proposal sentNegotiation160
Proposal sentLost80
Proposal sentStalled30
NegotiationWon100
NegotiationLost60

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,60

How it works

  1. List the stages and the exits

    Write down each stage and each way an opportunity can leave it.

  2. Take a cohort

    Use opportunities created in one period, so each one is counted once.

  3. Count the movements

    Count how many moved to the next stage and how many left by each exit.

  4. 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.

Edit this pipeline Sankey

More in Sankey diagrams