How to build a sales pipeline: stages, conversion and control

What a sales pipeline is and why you need one

A sales pipeline (often called a sales funnel) is a model that shows which stage of the buying process each prospect has reached. Many enquiries enter at the top; as they move through proposal, negotiation and contract, some of them become customers. It narrows like a funnel because part of the opportunities naturally drop out at every stage.

In many companies sales still live in a salesperson's memory, a spreadsheet and messenger chats. In that situation, a manager can only guess the answer to “how much will we sell this month?”. A pipeline answers three practical questions: how many open opportunities there are and what they are worth, at which stage you lose the most prospects, and which salesperson is overloaded or needs help.

How to define your pipeline stages

Stages should mirror the customer's decision path, not your org chart. A typical B2B sequence looks like the list below, but adapt it to your business: for a distributor “sample delivered” may be decisive, for a services firm “meeting or initial audit held” may be the key step.

• Lead: an enquiry has arrived, with contact details and source recorded.
• First contact: the salesperson has spoken to the prospect and identified the need and the decision-maker.
• Proposal sent: prices and terms have been presented in writing.
• Negotiation: discounts, payment terms or volumes are being discussed.
• Trial or sample: the customer is testing the product (not every business has this stage).
• Contract and first order: the agreement is formalised and the first sale has happened.

Exit criteria and time limits for every stage

The most common pipeline problem is subjective stage changes: one salesperson moves a prospect to “negotiation” after the first call, another only once price is on the table. The result is numbers you cannot compare across the team. Prevent this with written exit criteria for each stage: what exactly must happen before a card moves to the next column.

Time limits matter just as much. An opportunity that sits in the same stage for weeks is usually dead, yet it stays in the pipeline and inflates the forecast. Review overdue opportunities weekly: either plan the next step or close them with a reason.

• A criterion should be a verifiable fact, such as “proposal sent by email” or “customer accepted the sample”.
• Every open opportunity should have an owner, a next step and a date for that step.
• Set a maximum time per stage; for example, a new lead should be contacted within one or two working days.
• When an opportunity is lost, always record why: price, competitor, no budget, no response.

How to measure conversion and find the bottleneck

Conversion shows what percentage of opportunities reaching one stage move on to the next. Overall lead-to-customer conversion is useful, but stage-to-stage rates are what drive decisions, because they show where the problem actually is.

A stage with a sharply lower rate is your bottleneck. If few first contacts turn into proposals, the cause is often lead quality or poor needs discovery. If you lose many deals after the proposal, look at pricing, the format of the offer and follow-up discipline. Compare figures over at least a monthly period, since a few days of data are very sensitive to random swings.

• Stage-to-stage conversion: for example, what share of prospects who received a proposal move into negotiation.
• Average time in stage: where opportunities get stuck.
• Sales cycle length: average days from first enquiry to contract.
• Conversion by source: the quality of leads from the website, referrals, calls and social media.
• Loss reasons breakdown: whether most losses come from price or from slow responses.
• Results by salesperson: conversion rates of different people at the same stage.

Common mistakes

Most mistakes we see in consulting projects are about management, not technology. However good the system, a pipeline is only as valuable as the accuracy and timeliness of the data the team puts into it.

• Treating the pipeline as a reporting tool for management only: if salespeople do not see their own to-do list in it, they will not keep it updated.
• Deleting lost opportunities: without loss reasons there is nothing to analyse.
• Leaving the estimated value empty: without amounts there is no forecast.
• Changing stages too often: if the structure changes every month, periods cannot be compared.
• Forgetting what happens after the sale: whether a customer stays active after the first order is also part of the pipeline.

How the sales pipeline works in SBT CRM

In SBT CRM the “Sales pipeline” section puts leads and customers on one board. The first five stages belong to leads: Lead, First contact, Proposal sent, Negotiation, Trial product given. The next four reflect the customer's status: Contract, Active customer, At-risk customer and Lost customer. These four change automatically based on order and debt data rather than by hand, so the pipeline keeps tracking the customer after the sale.

• Each card shows how many days it has been in the stage, the amount and the owner; cards that exceed the stage time limit turn red.
• Moving to a stage automatically creates a task for the owner; an admin sets limits and task names in the “Sales rules” settings.
• The “Conversion analysis” tab shows how many reached each stage in the selected period and the “% of previous” rate.
• A lead can only be moved to “Lost” with a reason, and a reason is also required for a lost deal.
• The “Reports” section has monthly, quarterly, annual and per-seller reports on deals, which can also be emailed on a schedule.

A short plan to get started

When building a pipeline from scratch, do not try to find the perfect structure on day one. Start simple, collect data for a month or two, then adjust stages and limits based on real numbers.

The SBT Consulting & Solutions team helps at every step, from mapping your sales process to setting up stages, rules and reports in SBT CRM. You can find more about the system at crm.sbt.az.

• Review your last 20–30 successful sales and write down the steps the customer actually went through.
• Choose 5–7 stages and write a one-sentence exit criterion for each.
• Prepare a short list of loss reasons.
• Move all open opportunities into the system at once and assign owners.
• In the first month, focus on data quality; start analysing results from the second month.

Frequently asked questions

How many stages should a sales pipeline have?

For most B2B companies 5–7 stages are enough. Too few and the process is invisible; too many and salespeople stop updating cards on time, so data quality drops.

What is a good pipeline conversion rate?

There is no universal benchmark: it depends on your industry, price point, lead sources and sales cycle length. The most reliable comparison is against your own historical figures for the same source and period.

Is a sales pipeline the same as a sales funnel?

They describe the same model from two angles. A pipeline usually refers to the list of open opportunities and their stages, while a funnel emphasises the conversion view of how many prospects drop out along the way.

Can I manage a sales pipeline in Excel?

A small team can start that way. But a spreadsheet sends no reminders, keeps no history of stage changes, and quickly goes stale when several people edit the same file. As the team grows, a CRM is the more reliable option.