Skip to content
KatafactsBeta

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

Value 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

StepProcess time (hours)Wait after (hours)OperatorsDefect %WIP after
Lead qualification224140%
Discovery call396135%
Solution demo4120125%22
Proposal & pricing6168230%
Negotiation572115%
Contract signed201

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 callWait time here is 19.12% of total lead time, above the 15% flag threshold — this is where WIP is piling up.
  • Solution demoWait time here is 23.90% of total lead time, above the 15% flag threshold — this is where WIP is piling up.
  • Proposal & pricingWait 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

Rate this kata