Sales Pipeline: What It Is, How to Build One, and How to Measure It

"How much are we going to bill next month?" — if the answer at your company is a shrug, this article is for you. A sales pipeline is the representation of all your sales opportunities organized by stage, from first contact to close. It tells you three things no messy spreadsheet can: how much money is in play, where deals are getting stuck, and how much you'll actually bill. It's the difference between managing sales and watching sales go by.

What a sales pipeline is (and what it isn't)

Think of it as a conveyor belt: opportunities come in one end, move through stages, and exit the other end as a deal won or lost. At any moment you can look at the belt and know exactly what's on it.

What it's not:

• It's not your contact list. A contact is a person; an opportunity is a concrete chance to sell, with an amount and an estimated date.
• It's not the marketing funnel. The funnel measures volume from the ad to the lead; the pipeline starts where the funnel ends.
• It's not a formality for the salesperson. It's the single most important financial forecasting tool an SMB has: your cash flow for the next 60-90 days is written right there.

The stages: how to design them without copying templates

The most common mistake is copying the 5 generic stages from a tutorial. The right stages come out of your process, with one golden rule: each stage must correspond to a verifiable fact, not a salesperson's gut feeling. "Interested" is not a stage (says who?); "meeting scheduled with a date" is.

A reasonable starting point for B2B:

1. New lead — came in through some channel, nobody has talked to them yet.
2. Contacted / qualified — there was a conversation and they meet the minimum requirements (budget, real need, a decision-maker to talk to).
3. Meeting / discovery completed — the meeting happened, not "it's going to be scheduled."
4. Proposal sent — there's a document with an amount and scope in the client's hands.
5. Negotiation — the client responded to the proposal and price, timeline, or scope is being discussed.
6. Closed: won or lost — always with a reason recorded when it's lost.

Adapt it to your reality: a real estate agency adds "property visit"; an accounting firm adds "document review"; a factory adds "sample approved." Between 5 and 7 stages is the healthy range — with 10 nobody keeps them updated, with 3 you can't see anything.

Realistic conversion rates (real numbers)

Conservative ranges we see in B2B SMBs across LATAM with an organized process:

Transition	Typical rate	Warning sign
New lead → qualified	40-60%	<30%: the channel brings in junk
Qualified → meeting	50-70%	<40%: first contact arrives too late
Meeting → proposal	60-80%	<50%: you're meeting with non-decision-makers
Proposal → won	30-50%	<15%: you quote everyone without qualifying
Qualified lead → won (overall)	15-30%	<10%: review the entire process

A worked example: a B2B consultancy with an average ticket of USD 4,000 receives 40 leads a month. With the rates above: 40 leads → 20 qualified → 12 meetings → 9 proposals → 3-4 sales, USD 12,000-16,000 in new monthly revenue. If you want to double your billing, you already know you need 80 leads or you need to improve an intermediate rate — and the pipeline tells you which one is weakest.

How to calculate pipeline value (the math you need to do)

The nominal value (adding up every amount) lies: an opportunity that just came in isn't worth the same as one in negotiation. You use the weighted value:

Weighted value = Σ (each opportunity's amount × its stage probability)

The probabilities come from your history (or from conservative estimates until you have one):

Opportunity	Amount	Stage	Probability	Weighted value
Distributor A	USD 8,000	Negotiation	60%	USD 4,800
Firm B	USD 3,500	Proposal sent	40%	USD 1,400
Factory C	USD 15,000	Meeting completed	20%	USD 3,000
Retailer D	USD 2,000	Qualified	10%	USD 200
Nominal total: USD 28,500			Weighted:	USD 9,400

That USD 9,400 is your realistic forecast — a third of the number that had you excited. Doing this math by hand every week is exactly why most people never do it; a CRM shows it in real time. It's one of the core reasons to move from a spreadsheet to a custom CRM.

Not sure what your pipeline is worth today? Book a 30-minute meeting and we'll show you what your sales process would look like on a real-time dashboard.

When a lead is dead (and what to do with it)

A pipeline inflated with zombie opportunities is worse than having no pipeline: it makes you project revenue that won't exist. Practical criteria:

• By time: if your average sales cycle is 30 days and an opportunity has gone 90 days without changing stage, it's dead.
• By silence: 5 or more contact attempts across at least 2 channels with no response at all.
• By disqualification: they told you they bought from someone else, there's no budget this year, or the contact disappeared.

What to do: mark it as lost with a reason, never delete it. That history is worth gold: the "lost to budget" deals are the first list to write to in 6 months, ideally with an automated re-engagement sequence that doesn't depend on someone remembering.

The metrics to review every week

Five numbers, fifteen minutes every Monday:

1. Weighted pipeline value — is it enough for your revenue target 60-90 days out? Rule of thumb: you need 3-4 times your monthly goal in nominal pipeline.
2. New opportunities this week — if nothing comes in at the top, in 60 days nothing comes out at the bottom.
3. Stalled opportunities — everything that's gone more than X days without moving a stage, with the name of the salesperson responsible.
4. Close rate for the last period — against your own history, not someone else's benchmarks.
5. Loss reasons — the quarter's pattern (price, timing, competition) is your free improvement plan.

When a spreadsheet is still enough (honesty first)

We're not going to tell you that you need software no matter what. A well-built spreadsheet is enough if: you sell alone or with one other person, you handle fewer than 20 live opportunities, and your sales cycle is short. With discipline, it works.

The spreadsheet breaks down when: there are 3+ salespeople stepping on each other's leads, nobody updates it because it's a chore, you can't calculate the weighted value without an hour of formulas, and each client's history lives in each salesperson's personal WhatsApp. If that sounds familiar, take a look at the 7 signs your company already needs a CRM — you'll probably check several.

Your pipeline, in a system built for your process

The generic stages of off-the-shelf CRMs are the digital equivalent of the copied template: they force you to sell the way "the average company" sells. At Deepyze we build custom CRMs where the pipeline replicates your exact stages, your qualification rules, and your stall alerts — integrated with your management system and with automations that keep the pipeline clean without manual effort.

We work with a fixed price agreed before a single line of code is written, a team in your time zone, and staged deliveries. Tell us about your sales process and within 24 hours you'll have a concrete proposal for leaving the spreadsheet behind.