Where the Handoff Breaks: Auditing a Lead-to-Revenue Waterfall
Objective: Given stage-by-stage counts from a real lead-to-revenue waterfall, calculate the conversion rate between every stage and use the lesson's own diagnostic logic to decide whether the break is an MQL-definition problem or a sales follow-up problem.
You're the marketing analyst at Klaviyo, the Boston-founded email and SMS marketing automation SaaS company (130,000+ customers at IPO). Sales keeps saying marketing's leads are weak. Marketing keeps saying sales isn't following up. RevOps has asked you to pull the actual waterfall numbers before the next QBR (quarterly business review) so the argument has data instead of opinions.
Build the stage-to-stage conversion table first, do not jump to a conclusion before the numbers are in front of you. Then apply the lesson's own example logic (a low MQL-to-SQL rate next to a healthy SQL-to-opportunity rate points at MQL definition, not sales effort) to name the actual broken stage.
Before you start
What you'll need
Free path (everything below is enough to finish)
No account friction, and a simple divide-and-flag calculation doesn't need anything heavier.
The process
1 step
Step 01 of 01
The lesson's waterfall runs reach to awareness to engaged to MQL to SQL to opportunity to negotiation to closed won to customer to renewal, and the conversion rate between each pair of stages, not the raw counts, is what reveals where the system is actually breaking.
Given last quarter's stage counts below, which single stage-to-stage transition is the real problem, and is it an MQL-definition issue or a sales follow-up issue?
Procedure
- List every waterfall stage in order down one column with its raw count
- Add a second column computing (this stage / previous stage) as a percentage
- Flag any transition below half the average of the other transitions
- Compare the flagged transition's neighbors: is the stage right before it (definition) or right after it (follow-up) more likely at fault
- Write one sentence naming the broken stage and the fix owner
Klaviyo, Q2 waterfall (excerpt) Reach 48,000 Awareness 19,200 (40%) Engaged 6,720 (35%) MQL 2,150 (32%) SQL 108 (5%) <-- flagged Opportunity 32 (30%) Negotiation 9 (28%) Closed Won 4 (44%)
Healthy
MQL-to-SQL and SQL-to-opportunity both sit within a normal range of each other (roughly 25-35%), so the break, if any, is isolated to one clear transition.
Unhealthy
MQL-to-SQL sits at 5% while SQL-to-opportunity sits at 30%, a healthy rate right after it, meaning the leads that do get accepted convert fine, the problem is what counts as an MQL in the first place, not sales effort.
What this means
A stage with a low conversion rate feeding into a stage with a normal conversion rate points backward, at the definition or hand-off gate, not forward at the team receiving it.
So what do I do about it?
| Symptom | Action | Effort |
|---|---|---|
| MQL-to-SQL conversion is far below every other transition in the waterfall | Bring the MQL definition back to RevOps for a joint marketing-sales review before blaming either team's execution | 30 min |
Final deliverable
A stage-to-stage waterfall conversion table with the broken transition flagged and one sentence naming whether it's a definition problem or a follow-up problem.
See a reference example
Adyen, Q2 waterfall diagnosis (excerpt) Flagged transition: SQL to Opportunity (9%), well below the 30%+ seen at every other stage. Diagnosis: MQL-to-SQL conversion (33%) and Opportunity-to-Negotiation (31%) both look healthy, so the break sits specifically at SQL to Opportunity, this is a sales qualification or follow-up issue, not an MQL-definition issue, since the stage right before it is converting normally.
Success criteria
You're done when you can:
- Computes a stage-to-stage percentage for every transition in the waterfall, not just the overall funnel conversion
- Correctly identifies the single most-flagged transition rather than several
- States whether the cause is a definition problem or a follow-up problem, and justifies it using the neighboring stage's conversion rate