Revenue Waterfall: Where Your Pipeline Is Leaking

A revenue waterfall maps every stage a prospect moves through from first awareness to closed revenue, showing exactly how much volume enters, converts, and drops off at each step. It is the closest thing to an honest conversation your pipeline will ever have with you.

Most go-to-market teams think they have a demand problem. When you build a proper waterfall, you usually find they have a conversion problem. The leads are there. The handoffs are broken.

What Is a Revenue Waterfall?

A revenue waterfall is a structured model that tracks prospect volume through defined pipeline stages, from the first marketing touch through to closed revenue. Each stage has a conversion rate, a volume count, and an implied value. The waterfall shows you what percentage of prospects make it from one stage to the next, and where the largest absolute losses occur.

The SiriusDecisions Demand Waterfall, first published in 2006 and updated several times since, popularised the concept in B2B marketing. The framework has been adapted by hundreds of organisations into their own versions, but the core logic is the same: you cannot fix what you cannot see, and you cannot see anything useful if you are only looking at the top and bottom of the funnel.

In practice, a typical B2B revenue waterfall might include stages like: Inquiry, Marketing Qualified Lead, Sales Accepted Lead, Sales Qualified Opportunity, and Closed Won. The exact labels matter less than the definitions behind them. If your team cannot agree on what qualifies a lead to move from one stage to the next, the waterfall will lie to you.

If you are working through broader go-to-market questions alongside this, the Go-To-Market and Growth Strategy hub covers the commercial frameworks that sit around pipeline planning, including market entry, revenue model design, and growth architecture.

Why Most Teams Build Waterfalls Wrong

I have sat in enough pipeline reviews to know the pattern. Someone pulls a funnel report from the CRM, the numbers look roughly right, and the conversation moves on to which campaigns to run next quarter. The waterfall becomes a reporting artefact rather than a diagnostic tool.

The first failure is definitional inconsistency. Marketing counts a lead one way. Sales qualifies it another way. The CRM captures a third version. By the time you try to calculate a stage-to-stage conversion rate, you are dividing one fiction by another. The percentage looks precise. It means nothing.

Early in my agency career, I worked with a client who was convinced their top-of-funnel volume was too low. Every conversation came back to reach, impressions, and awareness spend. When we actually mapped the waterfall properly, they were generating more than enough inquiries. The problem was a 34% drop-off between Sales Accepted Lead and first meeting booked. Sales was accepting leads they had no intention of calling. The awareness budget was not the problem. The SLA between marketing and sales was the problem.

The second failure is treating all stage losses as equal. A 20% drop-off at inquiry-to-MQL is structurally different from a 20% drop-off at opportunity-to-close. The commercial impact of fixing each one is completely different. Teams that do not weight their waterfall by deal value end up optimising for the stages that feel urgent rather than the stages that matter most financially.

The third failure is measuring velocity without measuring volume. How long prospects take to move through each stage matters, but only once you know how many are making it through. Start with volume conversion rates. Layer in velocity data once you have the conversion picture right.

How to Define Waterfall Stages That Actually Hold

Stage definitions are where most waterfall projects fall apart before they start. The definitions need to be behavioural, not aspirational. “Ready to buy” is not a stage definition. “Has attended a product demo and has an identified budget holder” is a stage definition.

For each stage in your waterfall, you need four things agreed in writing before you build anything in the CRM. First, the entry criteria: what specific action or signal moves a prospect into this stage? Second, the exit criteria: what has to happen for them to progress to the next stage? Third, the owner: who is responsible for working prospects at this stage? Fourth, the SLA: how long can a prospect sit in this stage before it triggers a review or re-routing?

Without these four elements, your waterfall is a taxonomy, not a system. It will describe your pipeline without explaining it.

When I was running agencies, the most productive thing I ever did with a new client was spend the first two weeks mapping their existing stage definitions against their actual CRM data. Not to build reports. To find where the definitions had drifted from reality. Every time, without exception, there was at least one stage where the label said one thing and the data showed something completely different. That gap is usually where the revenue problem lives.

Reading the Waterfall: What the Numbers Are Actually Telling You

Once you have clean stage definitions and consistent data, the waterfall will show you three types of problems, each requiring a different response.

The first is a volume problem at the top. If you are generating fewer inquiries than your revenue targets require, you have a genuine demand generation gap. This is the one most marketing teams assume they have, and it is often the least common. Before you increase top-of-funnel spend, run the waterfall backwards from your revenue target. Calculate the inquiry volume you would need if every downstream conversion rate stayed the same. That number is your benchmark. If your current volume is already close, the problem is not at the top.

The second is a conversion problem in the middle. This is the most common finding. Prospects enter the pipeline but stall between marketing and sales, or between first meeting and qualified opportunity. Middle-of-funnel problems are usually process failures: unclear handoff criteria, slow follow-up, inconsistent qualification, or messaging that does not match where the buyer actually is in their decision process.

The third is a close rate problem at the bottom. If your waterfall shows strong volume and reasonable mid-funnel conversion but poor close rates, the problem is usually competitive positioning, pricing, or the quality of prospects being passed through. A high volume of poorly qualified opportunities closing badly is sometimes worse than lower volume of well-qualified ones, because it burns sales capacity and distorts your data.

BCG’s work on commercial transformation in go-to-market strategy makes a point that maps directly onto this: most commercial underperformance is not a market problem, it is an internal execution problem. The waterfall is where you find the execution gap.

Waterfall by Segment, Not Just by Total

One of the more instructive things you can do with a waterfall is break it down by segment before you try to fix anything at the aggregate level. Conversion rates by industry vertical, company size, lead source, and product line often tell completely different stories. A blended close rate of 22% might be hiding a 40% close rate from inbound organic leads and an 8% close rate from outbound cold prospecting. If you treat those as one number, you will make the wrong call on almost everything.

I spent several years managing significant paid media budgets across multiple verticals. The single most useful habit I developed was refusing to look at aggregate conversion data until I had seen the segment breakdown first. Aggregate numbers create false consensus. Segment data creates productive arguments, which is what you actually want in a planning meeting.

Segmenting the waterfall also helps you make smarter resource allocation decisions. If enterprise deals convert at half the rate of mid-market deals but at three times the deal value, the right resourcing decision is not obvious from the headline numbers. You need the waterfall broken down by segment, weighted by average deal value, to make that call with any confidence.

Tools like SEMrush’s growth toolset can help surface channel-level data that feeds into waterfall segmentation, particularly if you are trying to understand which acquisition sources produce the highest-quality pipeline rather than just the highest volume.

The Marketing and Sales Alignment Problem

Revenue waterfalls expose the marketing and sales alignment gap more clearly than any other tool. When the waterfall shows a sharp drop between MQL and Sales Accepted Lead, the instinctive response from marketing is that sales is not working the leads. The instinctive response from sales is that marketing is sending rubbish. Both are sometimes right. Neither is useful on its own.

The waterfall forces a more specific conversation. If sales is rejecting 60% of MQLs, the question is not “are these leads bad?” The question is: which specific criteria are failing? Is it company size? Industry fit? Job title? Buying stage? If you can answer that with data, you can fix the qualification model. If you cannot answer it with data, you are going to have the same argument every quarter.

One of the more useful things I have seen work is a joint waterfall review between marketing and sales leadership, run monthly, with a shared definition document on the table. Not a slide deck. An actual working document that both teams have signed off on and can amend. The friction of maintaining that document together is productive. It forces the conversation that most organisations avoid until the numbers get bad enough to demand it.

Forrester’s research on scaling agile commercial processes points to the same conclusion: alignment problems in go-to-market execution are almost always structural, not motivational. You do not fix them by asking people to collaborate more. You fix them by designing a process that makes misalignment visible before it becomes expensive.

Using the Waterfall to Set Realistic Targets

One of the most practical uses of a revenue waterfall is working backwards from a revenue target to set credible pipeline requirements. This sounds obvious. In practice, most organisations set revenue targets first and then reverse-engineer a pipeline number using assumptions that have never been validated against actual historical conversion rates.

If your close rate is 20% and your average deal size is £40,000, you need five qualified opportunities for every £40,000 of revenue. If your opportunity-to-close conversion is 20%, you need 25 sales accepted leads for every five opportunities. Build that logic all the way back to inquiry volume, and you have a demand generation target that is grounded in commercial reality rather than wishful thinking.

The waterfall also makes budget conversations more honest. When a CFO asks why marketing needs a particular budget, the answer should not be “to increase brand awareness.” The answer should be: “We need X inquiries to hit the revenue target. Our current cost per inquiry is Y. That requires a budget of Z, assuming our mid-funnel conversion rates hold.” That is a commercial argument. It is also a testable one, which is what makes it credible.

BCG’s work on scaling commercial operations emphasises the importance of building feedback loops into planning cycles. The waterfall is that feedback loop for revenue. It tells you whether your assumptions were right last quarter, which is the only honest basis for making assumptions about next quarter.

When the Waterfall Gives You the Wrong Answer

A revenue waterfall is only as good as the data feeding it. If your CRM hygiene is poor, if stage progression is being logged inconsistently, or if deals are being moved backwards and forwards to hit reporting deadlines, the waterfall will give you a confident-looking picture of something that is not real.

I have seen this happen more than once. A sales team under pressure to show pipeline growth starts moving deals forward prematurely. The waterfall shows healthy mid-funnel conversion. The close rate then collapses at the bottom. Leadership blames the sales process at the close stage. The real problem was data integrity two stages earlier.

The fix is not more reporting. It is audit. Periodically pull a sample of deals from each stage and manually verify whether they meet the stage definition. If they do not, you have a data quality problem, not a conversion problem, and the interventions required are completely different.

Hotjar’s approach to continuous feedback loops in growth processes is instructive here. The principle of validating assumptions with qualitative data alongside quantitative metrics applies directly to waterfall management. The numbers tell you where to look. They do not always tell you what you are looking at.

There is also the question of what the waterfall does not capture. It measures volume and conversion, but it does not measure intent, relationship quality, or the degree to which a deal is genuinely progressing versus politely stalling. A waterfall that shows 40 opportunities in the proposal stage is not the same as 40 opportunities that are genuinely going to close. Experienced sales leaders know this. The waterfall does not.

Connecting the Waterfall to Growth Strategy

The revenue waterfall is not a standalone tool. It is a diagnostic layer within a broader growth system. The decisions it informs, whether to invest in demand generation, fix mid-funnel conversion, improve qualification criteria, or rethink close-stage support, all connect back to your go-to-market strategy and how you have structured your commercial model.

Organisations that use the waterfall well treat it as a live instrument, not a quarterly report. They review it monthly, they segment it by every meaningful dimension they have, and they use it to arbitrate the inevitable disagreements between marketing, sales, and finance about where the revenue problem actually sits.

Growth hacking frameworks, like those covered in SEMrush’s analysis of growth hacking case studies, often focus on the top of funnel. The waterfall is a corrective to that instinct. Sometimes the most valuable growth move is not acquiring more prospects. It is converting the ones you already have.

If you are building or rebuilding your commercial planning process, the frameworks in the Go-To-Market and Growth Strategy hub sit directly alongside the waterfall as a planning tool. Market sizing, channel strategy, and revenue model design all need to connect to the pipeline mechanics the waterfall reveals.

The waterfall will not tell you where to go. It will tell you, with uncomfortable precision, whether you are actually getting there.

About the Author

Keith Lacy is a marketing strategist and former agency CEO with 20+ years of experience across agency leadership, performance marketing, and commercial strategy. He writes The Marketing Juice to cut through the noise and share what works.

Frequently Asked Questions