Pipeline Analysis: What the Numbers Are Telling You

Pipeline analysis is the process of examining your sales pipeline to understand where deals are won, lost, stalled, or misrepresented, so you can make better decisions about forecasting, resourcing, and revenue. Done well, it tells you not just what is in the pipeline, but whether any of it is real.

Most organisations have a pipeline. Far fewer have an honest picture of it. The gap between those two things is where revenue plans fall apart.

I have sat in enough quarterly business reviews to know that pipeline analysis is one of those disciplines that gets treated as a reporting exercise rather than a thinking exercise. Someone pulls a CRM report, the numbers go into a slide, and everyone in the room nods at a forecast that bears almost no relationship to what will actually close. The pipeline looks healthy. The quarter ends badly. Nobody is surprised, but nobody is honest about why either.

Why Most Pipeline Analysis Produces the Wrong Answers

The problem usually starts with data quality, not analytical capability. A pipeline full of wishful thinking will produce a wishful forecast regardless of how sophisticated your analysis is. I learned this early, running an agency where business development was partly my responsibility. We had a pipeline tracker. We updated it religiously. And we consistently overestimated what would close because nobody wanted to be the person who downgraded a deal they had personally championed.

That is a cultural problem, not a technical one. But it shows up in the numbers. Deals sit in the same pipeline stage for weeks without moving. Close dates get pushed repeatedly. Estimated values stay optimistic long after the signals have turned negative. The CRM becomes a record of what people hope will happen, not what is actually happening.

Effective pipeline analysis starts by treating the data with appropriate scepticism. Before you analyse anything, you need to ask whether the inputs are trustworthy. If they are not, fix that first. No amount of analytical sophistication rescues a dataset built on optimism and wishful thinking.

If you want a broader view of how these dynamics connect to commercial performance, the Sales Enablement and Alignment hub covers the organisational and strategic context in which pipeline health either improves or deteriorates.

The Metrics That Actually Matter in Pipeline Analysis

Total pipeline value is the number most people look at first. It is also the least useful on its own. A pipeline worth £5 million sounds healthy until you discover that 60% of it has been sitting in the same stage for four months, that your average deal takes 90 days to close, and that your historical win rate is 18%. Now that £5 million looks considerably less reassuring.

The metrics that tell you something useful are the ones that reveal movement, quality, and realistic probability.

Stage-by-Stage Conversion Rates

If you track nothing else, track how many deals move from each pipeline stage to the next, and how many fall out. This is where the real diagnostic value lives. A high conversion rate from initial meeting to proposal suggests your qualification is strong. A low conversion rate from proposal to negotiation suggests your proposals are not landing, your pricing is misaligned, or you are pitching to people who were never serious buyers.

When I was building out the agency’s new business function, we noticed that our conversion from proposal to final decision was reasonable, but our conversion from first contact to proposal was poor. We were spending significant time on scoping and writing for prospects who were not genuinely in-market. Fixing that single stage improved our overall win rate without changing anything else. The pipeline analysis told us where to look. The fix was a better qualification conversation.

Pipeline Velocity

Velocity measures how quickly deals move through your pipeline. It is calculated by combining the number of deals, average deal value, win rate, and average sales cycle length. The formula gives you a sense of how much revenue your pipeline is generating per unit of time, and whether that is accelerating or slowing down.

Velocity matters because it exposes problems that aggregate value hides. A pipeline can look large and static at the same time. Slow velocity often signals that deals are stalling at a particular stage, that your sales cycle has lengthened (often a sign of increased buyer caution or internal procurement complexity), or that your pipeline is being padded with low-probability deals to make the numbers look better.

Understanding velocity is especially important in sectors where sales cycles are long and complex. If you work in a manufacturing or industrial context, the manufacturing sales enablement considerations around deal velocity and stakeholder complexity are worth understanding separately, because the dynamics are genuinely different from a SaaS or professional services environment.

Pipeline Coverage Ratio

Coverage ratio compares the total value of your pipeline to your revenue target for the same period. If your target is £1 million and your pipeline contains £3 million of opportunities, your coverage ratio is 3:1. Whether that is healthy depends on your win rate. If you close 33% of what you pitch, a 3:1 ratio is exactly sufficient. If you close 20%, you need closer to 5:1 to hit the number.

Most organisations have a rough sense of their win rate but do not apply it rigorously to their coverage ratio calculation. They look at total pipeline value, compare it to target, and feel reassured. The more useful question is: given our actual historical win rate, do we have enough pipeline to hit the number? That question produces a very different conversation.

Deal Age and the Problem of Zombie Opportunities

Every pipeline has zombie deals. These are opportunities that have been sitting in the system for months, never formally lost, never progressed, just quietly inflating the pipeline value while consuming nobody’s attention. They are usually the result of salespeople not wanting to close out a deal they once believed in, or managers not wanting to see the pipeline shrink.

Deal age analysis is the process of identifying these opportunities and making a deliberate decision about each one. Is this deal genuinely still live? Has there been meaningful buyer engagement in the last 30 days? If the answer is no, the deal should be marked as lost or moved to a nurture status. Keeping it in the active pipeline distorts your forecast and your coverage ratio.

There are some persistent myths around what a healthy pipeline looks like and what pipeline hygiene actually requires. Many of those myths are addressed directly in the sales enablement myths piece, which is worth reading alongside this one if you are building or auditing a pipeline management process.

Where Marketing Fits Into Pipeline Analysis

This is the part that most pipeline analysis frameworks skip over, and it is where the commercial opportunity is largest. Pipeline analysis is typically treated as a sales function. Marketing generates leads, hands them over, and then watches from a distance while the sales team works them. If the pipeline is unhealthy, that is a sales problem.

That framing is wrong, and it is expensive. Pipeline quality is a joint responsibility. Marketing determines the quality of what enters the pipeline. Sales determines what happens to it once it is there. If your stage-one-to-stage-two conversion is poor, it might be because sales is not following up properly. Or it might be because marketing is generating leads that were never qualified to begin with. You cannot tell which without looking at both sides of the data.

This is why the benefits of sales enablement are most visible in pipeline metrics. When marketing and sales are genuinely aligned, the pipeline fills with better-qualified opportunities, conversion rates improve at each stage, and the forecast becomes more reliable. When they are not, the pipeline fills with volume that looks good on a dashboard but does not close.

I spent a period judging the Effie Awards, which are specifically about marketing effectiveness. One of the things that struck me consistently was how rarely the entries connected marketing activity to pipeline outcomes. There was plenty of evidence of awareness, reach, and engagement. Very little evidence of what happened downstream. The best entries were the ones that could show a clear line from campaign to commercial result. That discipline, tracing the impact of marketing through to pipeline and revenue, is what separates commercially useful marketing from activity that just looks busy.

Lead Scoring and Pipeline Entry Quality

One of the most direct ways marketing can improve pipeline quality is through rigorous lead scoring. If the criteria for what constitutes a sales-ready lead are vague, inconsistent, or not agreed between marketing and sales, the pipeline will fill with noise. Salespeople will spend time on leads that were never going to convert, and the pipeline data will reflect that waste.

Lead scoring criteria vary significantly by sector and business model. The considerations in a higher education context, for example, are quite different from those in a B2B technology sale. If you are working in or adjacent to education, the lead scoring criteria for higher education piece covers the specific signals and thresholds that matter in that environment.

The broader principle, though, is consistent across sectors: pipeline analysis should feed back into lead scoring. If you are seeing poor conversion at early pipeline stages, that is a signal that your lead scoring criteria are too loose. If you are seeing good conversion but low pipeline volume, the criteria may be too tight. The pipeline data tells you whether your entry filters are calibrated correctly.

Pipeline Analysis in SaaS Versus Other Business Models

The mechanics of pipeline analysis are broadly consistent across business models, but the emphasis shifts depending on how you acquire and retain revenue. In a SaaS business, pipeline analysis has to account for both new business and expansion revenue. The pipeline is not just about new logos. It includes upsell and cross-sell opportunities within the existing customer base, which often have higher conversion rates and shorter sales cycles than new business.

The SaaS sales funnel has specific characteristics that affect how pipeline stages are defined and how conversion rates should be interpreted. Free trials, product-led growth motions, and self-serve onboarding all create pipeline dynamics that do not exist in a traditional enterprise sales model. If you are applying pipeline analysis in a SaaS context, the stage definitions and the metrics that matter most will need to reflect those differences.

In a professional services or agency context, the pipeline is often less structured than in a product business. Deals are more bespoke, scoping is more fluid, and the line between a live opportunity and a speculative conversation is blurrier. That makes rigorous stage definition even more important, not less. Without clear criteria for what constitutes a qualified opportunity at each stage, the pipeline becomes a collection of vague possibilities rather than a useful forecasting tool.

The Role of Sales Collateral in Pipeline Progression

Pipeline analysis often reveals stalling at specific stages. A deal moves from initial meeting to proposal, and then sits. Another deal makes it to negotiation and stalls. When you see consistent stalling at the same stage across multiple deals, it is worth asking whether the problem is the sales process or the materials supporting it.

Sales collateral is one of the most underestimated levers in pipeline management. The right case study at the right stage of a deal can move it forward. The wrong proposal format can create friction that kills momentum. Sales enablement collateral, when it is built around the specific objections and questions that buyers have at each pipeline stage, directly improves conversion rates. When it is built around what marketing wants to say rather than what buyers need to hear, it sits unused in a folder somewhere.

When we were growing the agency from a small team to close to a hundred people, one of the things I noticed was that our win rate on larger pitches improved significantly when we stopped using generic credentials decks and started building pitch materials around the specific commercial problem the client had described. The pipeline data told us we were losing late-stage deals. The fix was not more pipeline. It was better materials for the stage where deals were dying.

Turning Pipeline Analysis Into a Forecasting Discipline

The practical output of pipeline analysis should be a more honest forecast. Not a more optimistic one. Not a more sophisticated model. A more honest one.

That means applying historical conversion rates to current pipeline by stage, not just multiplying total pipeline value by a rough win rate. It means discounting deals that have not progressed in 30 days. It means flagging deals where the close date has been pushed more than twice. It means distinguishing between committed deals, probable deals, and possible deals, and treating each category differently in the forecast.

The best forecasting I have seen is not the most technically sophisticated. It is the most honest. Teams that are willing to say “this deal is not as far along as it looks” and adjust the forecast accordingly are the ones that hit their numbers more consistently, because they are working from an accurate picture of where they actually are. Teams that inflate the forecast to avoid a difficult conversation end up having a much more difficult conversation at the end of the quarter.

Good pipeline analysis is not a one-time audit. It is a rhythm. Weekly deal reviews, monthly stage conversion analysis, quarterly pipeline health checks. The cadence matters because pipeline health changes quickly, and the signals that something is wrong are usually visible in the data weeks before they show up in the revenue line. The teams that catch those signals early have time to respond. The ones that only look at pipeline when the quarter is almost over do not.

If you are building or refining your sales enablement programme and want a broader frame for how pipeline analysis fits into the overall commercial system, the Sales Enablement and Alignment hub covers the full landscape, from strategy and structure through to measurement and execution.

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