Value stream mapping
Sales funnel value stream map
Sales funnel value stream map is licensed CC BY 4.0. Attribution: Katafacts (katafacts.com).
Customise with AISkill file ↓1 · What it is
What it is
A sales funnel is a value stream — not something value stream mapping merely applies to, but structurally the same thing. Stage conversion is first-pass yield: a deal that doesn't advance is a defect the same way a part failing inspection is. A stalled deal sitting between two stages is work-in-process inventory, with all the same costs — capital tied up, quality risk, and a signal something's obstructing flow. Stage time is lead time. This is the strongest of the commercial lens mappings for exactly that reason: almost nobody in revenue teams runs this arithmetic on their own funnel, even though the CRM already has every number it needs.
2 · When to use it
When to use it — and when not to
Use it when
- You can pull real per-stage timestamps from the CRM — when a deal actually entered and left each stage — not just a quarter-end pipeline snapshot.
- The segment is bounded: one deal source, one team, or one product line with a genuinely comparable sales motion, not the whole pipeline blended together.
- You want a defensible flow-efficiency number instead of an impression that deals 'take too long,' with a specific stage named as the constraint.
Not when
- You only have secondhand or quarter-end data — go pull actual per-stage CRM timestamps first; a funnel VSM built from memory inherits every gap in that memory, same as any other VSM.
- The pipeline blends deal types with genuinely different natural cycles (self-serve and enterprise in one map) — this is product family analysis (master-plan §2.3) again: scope down to one comparable segment first.
- You're trying to redesign the sales process before measuring the current one — you can't fix a flow you haven't quantified, and 'the process feels broken' isn't a finding.
3 · How to fill it in
How to fill it in
- Scope
- State what's in and out in a sentence or two — which deal source or segment, which start and end stage (typically SQL to closed-won/lost). A funnel mapped with no stated boundary quietly blends every deal type into numbers that describe none of them.
- Process steps
- List each pipeline stage in order with its process time (time actually being worked — calls, proposal drafting) and wait time after it (time stalled before the next stage starts). Add a defect rate (the % of deals that don't advance — your stage conversion loss, inverted) and a WIP count (deals currently stalled at that boundary) only where your CRM actually has the data — leave them out rather than estimate.
- Lead time · Process time · Flow efficiency
- Lead time, process time, and flow efficiency are computed for you from the stage data. A funnel's flow efficiency is usually strikingly low — often single digits — because almost all of a deal's time in the pipeline is spent waiting, not being actively worked. That's not a bug in the calculation; it's the finding.
- Waste — the eight wastes
- Waiting, inventory (stalled-deal WIP), and defects (conversion loss) are quantified directly from your stage data. The other five wastes stay qualitative until your notes give them something concrete — for a funnel, non-utilized talent and extra-processing are the two worth watching for in practice.
- Where the wait concentrates
- Ranked automatically by wait-time contribution — which stage is where deals actually stall. Override to cost or impact if a smaller number of large deals matters more to the forecast than raw time, the same axis discipline as a deal A3's Pareto.
- Countermeasures
- Rank by impact and effort, and name the specific finding each one addresses — the stage with the largest wait, the stage capping capacity, or a named conversion-loss finding. 'Reps should move faster' doesn't trace to a finding; a specific process gap at a specific stage does.
4 · What good looks like
What good looks like
The example below is a full worked funnel analysis: real per-stage timing across a six-stage outbound pipeline, a lead time and flow-efficiency figure with the arithmetic shown, the stage that caps throughput and the stage where deals stall worst, waste findings that quantify conversion loss and stalled-deal WIP directly from the stage data, and countermeasures that each name the specific stage-level finding they close.
Same example, as a downloadable xlsx workbook.
Download .xlsxValue stream map — current state
Mid-market outbound pipeline — current-state analysis
Jordan Ellis, Sales Manager · 2026-03-16
Team: Priya Anand, RevOps, Sam Cole, Sales Enablement · Sponsor: Renee Okafor, VP Sales
Scope
Scope runs from a lead reaching SQL (sales-qualified) status to closed-won or closed-lost, for outbound-sourced mid-market deals only. Excludes pre-SQL marketing nurture and post-close onboarding — those are separate value streams with their own owners.
Process steps
| Step | Process time (hours) | Wait after (hours) | Operators | Defect % | WIP after |
|---|---|---|---|---|---|
| Lead qualification | 2 | 24 | 1 | 40% | — |
| Discovery call | 3 | 96 | 1 | 35% | — |
| Solution demo | 4 | 120 | 1 | 25% | 22 |
| Proposal & pricing | 6 | 168 | 2 | 30% | — |
| Negotiation | 5 | 72 | 1 | 15% | — |
| Contract signed | 2 | 0 | 1 | — | — |
Lead time · Process time · Flow efficiency
Lead time
502 hours
Process time
22 hours
Flow efficiency
4.38%
2 + 3 + 4 + 6 + 5 + 2 (process time) + 24 + 96 + 120 + 168 + 72 + 0 (wait time) = 502 hours
22 / 502 × 100 = 4.38%
Capacity constraint
Proposal & pricing
6 hours · 1.20% of lead time
Largest wait contributor
Proposal & pricing
168 hours · 33.47% of lead time
WIP flags
- Discovery call — Wait time here is 19.12% of total lead time, above the 15% flag threshold — this is where WIP is piling up.
- Solution demo — Wait time here is 23.90% of total lead time, above the 15% flag threshold — this is where WIP is piling up.
- Proposal & pricing — Wait time here is 33.47% of total lead time, above the 15% flag threshold — this is where WIP is piling up.
Waste — the eight wastes
- Defects82.6 %
Rolled throughput yield across the 5 steps with a recorded defect rate is 17.40% — about 82.60% of units need rework or scrap somewhere in the stream, so first-pass output is lower than any single step suggests.
(1 - 40/100) × (1 - 35/100) × (1 - 25/100) × (1 - 30/100) × (1 - 15/100) × 100 = 17.40% yield — from Lead qualification (40%), Discovery call (35%), Solution demo (25%), Proposal & pricing (30%), Negotiation (15%); defects = 100 − 17.40 = 82.60%
- OverproductionQualitative
Not quantified from step timings. On the next walk, look for producing more than the next process pulls, or running ahead of takt — batches built early, reports nobody reads.
- Waiting480 hours
Work sits idle for 480 hours in total across this value stream, queued after 5 of 6 steps.
24 + 96 + 120 + 168 + 72 + 0 = 480 hours
- Non-utilized talentQualitative
Not quantified from step timings. Look for operators' process knowledge or improvement ideas going unused — people closest to the work with no route to change it.
- TransportationQualitative
Not quantified from step timings. Look for unnecessary movement of material or information between steps — handoffs, re-keying, files shuttled between systems.
- Inventory22 units
22 units of work in progress sit in queues after 1 of 6 steps — every one of them is finished effort not yet paid for.
Solution demo (22) = 22 units
- MotionQualitative
Not quantified from step timings. Look for unnecessary operator movement within a step — reaching, searching, walking to fetch what the work needs.
- Extra-processingQualitative
Not quantified from step timings. Look for doing more to the product or information than the customer actually values — extra approvals, duplicate checks, unused detail.
Where the wait concentrates
Ranked by cost
- Proposal & pricing168
- Solution demo120
- Discovery call96
- Negotiation72
- Lead qualification24
- Contract signed0
Countermeasures
Pre-approve standard pricing tiers for deals under a set contract-value threshold so they skip the two-approver review entirely; keep the full review only for genuinely custom terms.
Linked finding: Proposal & pricing — largest wait contributor at 33.47% of lead time, and the capacity constraint at 6 hours of active work per deal
Impact: high · Effort: medium · Owner: Priya Anand · Due: 2026-04-06
Cap the number of deals allowed to sit between Solution demo and Proposal at any time, pulling the next demo only when a proposal slot frees up, instead of running demos as fast as reps can book them.
Linked finding: Solution demo — 22 units of WIP queued, wait time 23.90% of lead time
Impact: medium · Effort: medium · Owner: Jordan Ellis · Due: 2026-04-13
Tighten the SQL handoff criteria with marketing so fewer poorly-fit leads enter the pipeline only to drop out at qualification — add one firmographic checkpoint before a lead is marked SQL.
Linked finding: Defects — 17.40% rolled throughput yield across 5 stages; Lead qualification is the single largest contributor at 40% drop-off
Impact: medium · Effort: low · Owner: Sam Cole · Due: 2026-04-06
5 · Common mistakes
Common mistakes
Stage timing comes from 'days since deal created' instead of actual stage-entry and stage-exit timestamps.
Deal-age conflates every stage into one number and hides exactly where the time actually goes — the whole point of mapping the funnel is naming which stage is the problem, not confirming the pipeline overall feels slow.
Every stage gets flagged as a bottleneck.
Same vital-few discipline as canonical VSM (master-plan §1.3): naming the one or two stages actually worth acting on beats cataloguing every stage with nonzero wait.
Conversion loss (the defect rate) is estimated from a rep's gut sense of 'about half fall through' instead of pulled from CRM stage-history.
Reps' recall skews toward memorable losses, not typical ones. The CRM's actual stage-transition history is the ground truth here, the same way direct observation is for a shop-floor VSM.
The pipeline segment mixes deal types with genuinely different natural cycles.
A funnel mapped with no scope boundary blends a two-week self-serve deal and a six-month enterprise deal into an average that describes neither — same failure mode as an unscoped operational value stream.
Countermeasures target the stage that's easiest to change organizationally, not the one the data names as the constraint.
The capacity constraint or largest wait contributor is where the funnel actually loses time and deals. A politically easy fix elsewhere feels productive and moves nothing.
6 · What it connects to
What it connects to
upstream
Ideal Customer Profile / qualification standard work
Defines what actually earns SQL status — the funnel VSM's start boundary is only meaningful if that definition is consistently applied before deals enter the mapped segment.
Demand takt calculator
The pull-vs-push discipline behind demand generation (master-plan §4.2) applies directly to a funnel's WIP findings: generating leads faster than the funnel's constraint can absorb them is inventory, not pipeline health.
downstream
Deal A3
The funnel map's capacity constraint or largest wait contributor is exactly the kind of bounded, data-backed problem a deal A3 exists to close in depth.
Pipeline daily/weekly management board
Once a stage-level finding is named, it belongs on the team's regular pipeline review as a tracked leading indicator, not just re-measured once at quarter-end.
7 · Where AI helps
Where AI helps
Judgement — stays yours
- Deciding where to draw the funnel segment's scope boundary
- Judging whether a stage-level countermeasure is actually feasible given real approval/resourcing constraints
- Committing to which stage-level finding to act on first
Analysis — AI helps
- Drafting waste narratives from raw CRM stage-history exports
- Pressure-testing whether a proposed countermeasure actually addresses the named stage-level finding
- Ranking countermeasures by impact and effort
Drudgery — automated
- Computing lead time, flow efficiency, and every calculation shown alongside them
- Identifying the capacity constraint and the largest wait contributor from stage data
- Quantifying stalled-deal WIP and conversion-loss (defect) waste wherever the CRM data supports it
- Exporting to xlsx in the house format
9 · Rate this kata
