The more control and visibility you have into your sales pipeline, the more revenue you’ll bring in.
But what is a sales pipeline — and why is it so instrumental to selling success? In this guide, you’ll learn everything you need about sales pipeline management, including:
- Sales Pipeline Definition
- How to Build a Sales Pipeline
- Common Sales Pipeline Mistakes
- How to Clean Your Sales Pipeline
- Sales Pipeline Metrics
- Sales Pipeline Management
- How to Run a Sales Pipeline Review
- A Downloadable Sales Pipeline Template
The Definition of a Sales Pipeline
A sales pipeline encompasses every stage of your sales process. An opportunity moves from stage to stage of your pipeline based on concrete actions, which is usually represented visually in your CRM. Because sales processes differ from company to company (and even product to product), your sales pipeline should be unique and reflect the typical buyer’s journey.
Every opportunity will move through your sales pipeline at a different rate depending on their level of interest, urgency, how much research they’ve already done, and so forth. Certain prospects may even skip stages in your pipeline — for example, if a buyer proactively introduces you to the budget authority before you’ve asked, you’d move the deal straight from “initial connect” to “meeting with decision maker.”
Sales Pipeline vs. Sales Forecast
Sales pipelines are often confused with sales forecasts as well. While a pipeline includes every opportunity a salesperson is handling, no matter how new or mature it is, a sales forecast is an estimate of the opportunities likely to close in a given time period.
In addition, pipelines and forecasts have different purposes. Reps use their pipelines to keep track of where prospects are in the sales process and the appropriate actions they should take. Meanwhile, a forecast shows salespeople and sales managers how closely they’re trending to goal and how to prepare. If your forecast anticipates you’re going to miss your quota, you should double down on selling activities. If your forecast shows you’re on-track to make 150% of your quota, on the other hand, you’d want to scale back your efforts for this month and start laying the groundwork for an equally successful next month.
Sales Pipeline vs. Sales Funnel
People often use “sales pipeline” and “sales funnel” interchangeably. However, a funnel suggests the number of prospects you’re working with steadily drops off as the sales process goes on.
This metaphor reinforces the incorrect idea you need three times as many prospects at the top of your funnel as the bottom. A sales manager following this philosophy would ask his rep to connect with 300 buyers to close 100 deals.
According to sales educator and expert Jeff Hoffman, a wide-brim champagne glass is a better metaphor. You may have a ton of prospects entering the pipeline — but the vast majority should drop off after the qualification stage. After prospects have passed the critical point, most should become customers.
The most successful reps often have 1.25x or 1.5x the ratio of opportunities to deals in their pipelines.
How to Build a Sales Pipeline
Here are the basic steps to building a sales pipeline:
- Define the stages of your sales cycle.
- Identify how many opportunities typically continue to the next stage.
- Work backward to calculate the number of opportunities you need at every stage to hit your revenue goals.
- Pinpoint the common characteristics of opportunities that convert for every stage — both actions the rep takes (like sending a follow-up email) and prospect responses (agreeing to a demo).
- Create a sales process or adapt your existing one around these actions and numbers.
Now that you have an overview of the process, let’s dive into the specific steps.
Sales Pipeline Stages
While the quickest way to define your sales pipeline stages might be copying a template, it’s worth the time and effort to develop your own.
After all, the stages of the pipeline must match your prospect’s buying journey to effectively help you track progress and predict revenue.
Review the typical process your customers go through.
- Awareness: The buyer realizes they have a pain point or opportunity.
- Consideration: The buyer defines their paint point or opportunity, develops evaluation criteria and needs, and researches potential approaches.
- Decision: The buyer has finalized their strategy and is now comparing vendors/specific solutions.
To illustrate, check out this hypothetical buyer’s journey:
With that in mind, your sales pipeline stages might be:
- Connect: The buyer engages with your company, whether they open an email from a salesperson, attend a webinar, or download a piece of content
- Appointment set: The buyer agrees to a meeting to learn more about how you can help them.
- Appointment completed: They showed up to the meeting, and you confirmed next steps.
- Solution proposed: The buyer is interested in using your product to solve their pain point or capitalize on their opportunity.
- Proposal sent: The buyer reviews your proposal or contract.
The more complex your product, the longer your sales cycle will take — and the more stages there may be.
You should know how long prospects spend in each stage — both across the board and for closed/won deals. For example, maybe the average prospect spends two weeks in the demo stage, while prospects that eventually buy spend three weeks.
Knowing these benchmarks will help your reps and sales managers predict which opportunities are likeliest to close.
It’s also critical to establish yield probability (or conversion rate) per stage. Perhaps prospects are 75% likely to buy in the demo stage and 90% likely to buy in the negotiation stage. Once you’ve assigned these percentages to each stage, you can develop monthly and/or quarterly revenue estimates.
How to Determine Your Ideal Pipeline Size
Now you can work backwards to determine how many opportunities you need in each stage of your pipeline. Start with your target monthly or quarterly revenue divided by your average deal size. That tells you how many deals you need to win in a month or quarter.
Next, divide your target deal number by your yield probability per stage. If you need to win 135 deals, and your reps typically close 90% of deals in the negotiation stage, 150 opportunities must reach that stage in a month.
Repeat this process for every stage. Once you have total milestones, you can divide these goals by salesperson.
- 2,000 deals ÷ year = 167 deals per month
- 8,000 proposals ÷ year = 667 proposals per month
- 32,000 meetings ÷ year = 640 meetings per week
- 64,000 calls ÷ year = 256 calls per day
If you have a 100-person team, that translates to:
- 167 deals per month ÷ 100 reps = 2 deals per month
- 667 proposals per month ÷ 100 reps = 7 proposals per month
- 640 meetings per week ÷ 100 reps = 7 meetings per week
- 256 conversations per day ÷ 100 reps = 3 calls per day
Salespeople can use these benchmarks to objectively measure their progress against goal. However, keep in mind every rep’s conversion rates will vary by stage. If one of your salespeople struggles to prospect, but has an excellent demo-to-close rate, she’ll need to have fewer initial meetings than her peers to meet quota.
Sales Pipeline Mistakes
Keep your pipeline healthy by avoiding these common errors.
1) Letting your pipeline shrink
Because many reps dislike prospecting, it’s easy to fall into what sales expert Colleen Francis calls the “sales trap.”
You’re receiving a lot of business and will definitely hit your number this quarter. Unfortunately, you’ve been neglecting to prospect — which means next quarter, you’ll be faced with a dry pipeline.
To combat this, Francis recommends making sure your sales pipeline is always stable or growing. If there’s a large number of deals in the negotiation and agreement pending stages — but few in the demo stage, and even fewer in the discovery stage — you should immediately start prospecting.
In fact, there should always be more opportunities in the left part of your sales pipeline than the right. That’s because the number of prospects in each stage progressively decreases, while the probability of closing progressively increases.
You might have 100 prospects in the “lead” stage. Opportunities in this stage historically close at 5%.
Meanwhile, you might have 10 prospects in the “demo” stage — but there’s a 50% likelihood they’ll buy.
2) Losing Leads
If you don’t establish a standard follow-up process, leads will end up slipping through the cracks. That’s easy money you’re leaving on the table.
Give your team a system for following up with leads, including timing, cadence, and contact method.
For example, you might say:
- Every inbound lead is contacted within six hours or less
- Every lead receives 10-12 touches spread out over one month
- Every lead receives a variety of email, phone, and social media touches
- Every touch includes new information or resources
A uniform follow-up strategy also helps your reps maintain clean pipelines by telling them when to disqualify prospects. If a prospect hasn’t responded by the last touch, they should be removed from the pipeline.
Assigning tasks to each and every lead is another way to shore up a leaky leads bucket. Require your reps to attach new tasks to opportunities whenever they complete the existing one, so they also have a defined action item. That might be “send meeting agenda,” “call again in three days,” “comment on two blog posts,” etc.
3) Allowing Your Pipeline to Get Messy
Periodically cleaning up your pipeline is key if you want an accurate sales forecast. That’s because most forecasts use an opportunity’s stage to determine how likely it is to close — not its age.
Suppose you sent a proposal for a $2,000 deal to the buyer one month ago. He hasn’t returned any of your calls or emails since then, which suggests you’re not getting his business. However, since opportunities in the “negotiation” stage have a 90% close rate, your sales forecast would count this deal as $1,800 potential revenue in the next month.
That means your sales forecast is $1,800 off. And every stale deal will further widen the gap between expectations and reality.
How to Clean Up Your Sales Pipeline
1. Identify prospects who have been in your sales pipeline longer than your average sales cycle.
Use your judgment to determine whether they should be removed. For example, if you’re working with your champion to get the deal through their unusually complex legal review, you wouldn’t want to take that opportunity out — it might be taking more time than normal, but there’s a strong chance it will close.
2. Before you completely give up on a prospect, send them a sales breakup email. There are only three possible outcomes of a breakup email: They say they’re still interested, they say they’re not interested, or they don’t respond.
In the latter two scenarios, take them out of your pipeline. You can always put these contacts into a new list in your CRM, such as “Call back in one year.”
3. Make sure your data is up-to-date and accurate.
It’s sometimes necessary to move opportunities backwards in the sales pipeline. Maybe you previously identified the key stakeholders within the target account — but since then, two have left the company. You’ll need to move this deal back into the qualification stage until you identify the new decision maker.
In addition, verify close dates. Make sure they match up to your instincts; if the prospect says they’ll make a decision within the next two weeks, but she’s continually overestimated how quickly her team comes to a consensus, you should probably add a buffer to the close date.
Double-check opportunity dollar values as well. If these are too high, your sales forecast will be overly optimistic. Too low, and you’ll think you’re further from your goal than you really are.
4. Periodically review your sales pipeline for prospects who have gone radio silent, deals that have been stuck in one stage for longer than normal, and opportunities where you’ve lost progress.
Although it can be tempting to let these linger in your pipeline “just in case,” purge them. Not only will your sales forecast be more accurate — which will help you plan and make your sales manager happy — it’ll also be easier to focus on the deals you have a true chance of closing.
Do this exercise every week to month, depending on the length of your sales cycle.
Sales Pipeline Metrics
Use these metrics to gauge the health of your sales pipeline — and from there, the health of your team, department, and/or business.
- Number of deals in your pipeline: How many qualified opportunities you’re currently juggling
- Average deal size: The mean value of a contract
- Pipeline value: The total value of every qualified opportunity in your pipeline
- Sales velocity: The average time deals stay in your pipeline before they’re won
As your salespeople become more knowledgeable, your marketing team learns which channels to use to attract the best fit prospects, and your business becomes more well-known in its space, your sales cycle should decrease.
To grow, your pipeline value must increase. Average deal size, the number of deals, and/or conversion rates must go up.
Pipeline velocity is the speed at which leads move through your sales pipeline. The formula is:
Number of deals in your pipeline x overall win rate percentage x average deal size ($) / length of sales cycle (days)
Suppose you have 50 opportunities in your sales pipeline. Your average win rate is 40%, and your average deal size is $10,000. From initial contact to signed proposal, the sales process usually takes 70 days.
Your pipeline velocity = 50 x .4 x 10,000 / 70, or $2,587.14
That means approximately every day, $2,587.14 is moving through your sales pipeline. Obviously, the higher your velocity, the better.
There are four main levers you can pull to increase pipeline velocity. Unsurprisingly, they correlate to the four factors of the equation.
- Number of total opportunities: Move the needle on this input by amping up your prospecting efforts. If this number goes down, something may be wrong with your lead generation strategy.
- Win rate: Improve this metric by asking your salespeople to rigorously qualify and investing in sales training and sales enablement.
- Deal size: Help your reps sell bigger deals by teaching them how to upsell and cross-sell or target larger customers.
- Sales cycle: Identify the key steps that move prospects from stage to stage and make sure every member of your team is following those. Counterintuitively, “fast-tracking” an opportunity usually results in a longer sales cycle — the rep is forced to go back and make up for the qualification, discovery, and/or customized presentation she skipped, if she gets the chance at all.
In addition to pipeline velocity, keep a close eye on your conversion rates by stage. This allows you to see where prospects are dropping out of your sales funnel.
Suppose 60% of your prospects go from the sales presentation stage to the proposal stage. Why do 40% of them drop out? It’s normal to have attrition between stages, but you might investigate if there’s a larger problem. Perhaps your salespeople aren’t effectively conveying your product’s value, or they haven’t done enough needs analysis to tie their presentation to their prospects’ pain points.
If you don’t both monitor and investigate these metrics, you might not uncover pressing problems in time.
What Is Sales Pipeline Management?
Sales pipeline management essentially means estimating how much money you’ll make from your current sales opportunities.
In order to calculate this, you’ll need to know:
- How many opportunities your sales reps are actively working
- Which stage is each opportunity is in
- How many opportunities typically pass from one stage to the next
- The average deal size
- Average sales cycle length
If you don’t have these data points yet — or your go-to-market strategy is in flux, so your numbers are constantly changing — you can make informed guesses. To give you an idea, perhaps you just shifted upmarket. Based on preliminary research, early sales, and talking to other companies selling similar products, you might predict your new sales cycle will last five months.
Of course, the more historical data you have, the more accurate your predictions will be.
Luckily, a CRM can calculate these metrics for you. Not only can you compare your team’s current performance to previous months, quarters, or years, you can also analyze each of your salespeople individually. Perhaps one of your salespeople has an impressive connect-to-qualification rate but a poor close rate. He may need coaching on negotiation. Another salesperson, meanwhile, might struggle to prospect effectively. Help her identify and contact potential buyers.
How to Run a Sales Pipeline Review
High-performing teams use sales pipeline reviews to keep the entire organization working in sync.
Sales Pipeline Reviews vs. Sales Forecast Reviews
Both forecast reviews and pipeline reviews are critical to your team’s success, but make sure you’re not tackling them both in the same meeting.
A forecast review should focus on the deals likely to close in a given time period. This meeting helps managers predict whether their team will hit its quota.
The purpose of a sales pipeline review is to help deals move through the sales process as efficiently as possible. An effective sales pipeline review looks at fresh sales opportunities. Sales managers often make the mistake of jumping in to help in the later stages of the sales process, but by this time, it’s often too late for them to influence the outcome of a deal. If they truly want to make an impact, they should help reps strategize while the opportunity is still new.
Sales Pipeline Review Agenda
Depending on the size of your team, the length of your sales process, and how quickly new opportunities enter your reps’ pipelines, choose a bimonthly, monthly, or weekly cadence.
Each review should last approximately 30-60 minutes. You can either focus on the most important deals or review all opportunities in the beginning stages of the process — whatever works best for your team and structure.
1. Before the sales pipeline review, use your CRM to analyze how your rep is doing. It’s important to walk in prepared so you don’t waste valuable time getting caught up in the meeting itself.
2. Ask your rep to quickly summarize each deal. Give them positive feedback (especially if you observe they’ve applied previous advice), then delve into their assessment. The questions below may be helpful.
3. Develop an action plan for the deal and confirm their next steps. These steps should be added to the CRM, which will keep them accountable and help them avoid a memory lapse.
Sales Pipeline Review Questions
Here are some questions sales managers should ask their reps during sales pipeline reviews:
- How can we accelerate the prospect’s decision making process for this deal?
- What risks are we facing, and how can we mitigate them?
- Which competitors are we up against, and how can we stand out?
- Which objections have you surfaced so far, and how can we build those into our strategy for closing?
- Why has this stalled? How can we increase urgency?
An Easy Sales Pipeline Template
A sales pipeline template lets you set up your own pipeline in a spreadsheet. It’s easy to get started: Simply plug in each deal, its expected value, and the probability of closing. You’ll see a weighted average for that deal.
This sales pipeline template also has columns for the assigned salesperson, the prospect’s contact information, and next steps.
While you can manage your sales pipeline in an Excel spreadsheet, it’s far easier to use a CRM. The HubSpot CRM gives you an up-to-date view of your sales pipeline, multiple ways to sort your deals, automatic activity tracking (so you don’t need to manually log calls or emails), and detailed contact records for every lead.
Master your sales pipeline, and you’ll master your results. You’ll be prepared for whatever comes your way — whether that’s a new competitor, a major opportunity, an industry shift, or an internal strategic change.