Sales pipeline: how to structure it, manage it and forecast closes

A sales pipeline is the visual and quantitative representation of all opportunities in progress, organized by stage of the sales process. It's the map that shows where each deal stands, what needs to happen next and how much revenue is at stake.

The problem is that most existing pipelines don't reflect reality. They're full of opportunities that should have been discarded, with no clear progression criteria and outdated data. The result is a revenue forecast that's useless.

What defines a healthy sales pipeline

A healthy pipeline has four characteristics:

1. Only qualified opportunities get in: a lead that doesn't meet minimum criteria shouldn't become an opportunity in the funnel — it takes up space, distorts metrics and creates an illusion of volume.
2. Stages with objective criteria: the sales rep doesn't decide alone whether an opportunity moves forward. There are defined criteria — meeting held, need confirmed, budget identified.
3. Up-to-date data: if the CRM doesn't reflect what's happening in real conversations, the pipeline is fiction.
4. Cleaned regularly: stalled opportunities with no prospect of closing need to be discarded or moved to re-warming.

How to structure the pipeline stages

There's no universal structure — the stages should reflect your customer's buying process, not your internal sales process.

A typical structure for consultative B2B sales:

• Lead: contact identified, not yet qualified.
• Contact made: first contact done, waiting for a reply.
• Meeting scheduled: meeting commitment confirmed.
• Discovery completed: need mapped, fit confirmed.
• Proposal sent: solution and terms formally presented.
• Negotiation: adjustments to scope, timeline or price in progress.
• Won / Lost: outcome recorded with a reason.

Each stage needs:

• Entry criterion: what has to have happened for the opportunity to get here.
• Required action: what the sales rep must do while the opportunity is in this stage.
• Exit criterion: what has to happen for the opportunity to move forward or drop out.
• Maximum time: how long an opportunity can stay in this stage without action.

Free NEXO SCORE assessment (2 min)
Take the free assessment

How to manage the pipeline day to day

Pipeline management isn't a weekly review in a meeting. It's continuous monitoring with targeted intervention when something goes off pattern.

Daily review (5–10 minutes)

The manager checks:

• New opportunities created.
• Opportunities that have exceeded the time limit in their current stage.
• Opportunities close to closing that need attention.

Weekly pipeline review (30–45 minutes)

With the team:

• Late-stage opportunities: what's holding up the close?
• Old opportunities in early stages: qualify, advance or discard?
• This week's forecast: which closes are realistic?

Monthly process review (60 minutes)

Based on the month's data:

• At which stage do opportunities die most often?
• What do won opportunities have in common?
• Is the sales cycle within expectations?

See how to track the pipeline metrics that really matter.

How to calculate and interpret the conversion rate by stage

Conversion rate by stage reveals where the funnel leaks. It's calculated by dividing the number of opportunities that moved forward from a stage by the total that entered it.

Example: if 100 opportunities reached the "Proposal sent" stage and 30 moved on to "Negotiation," the conversion rate at that stage is 30%.

A sharp drop at a specific stage points to a process problem at that point — the wrong message, a proposal that doesn't address the main objection, a poor handoff between SDR and closer.

How to use the pipeline to forecast closes

A pipeline-based revenue forecast takes into account:

• Volume of opportunities by stage
• Average value of each opportunity
• Historical conversion rate from each stage to close

Simplified formula: Sum of (Value of each opportunity × Stage conversion probability)

Example: 5 opportunities in "Negotiation" with an average value of R$ 20,000 and a historical conversion rate of 70% = R$ 70,000 projected.

This projection is reliable when the pipeline data is reliable. If the funnel is full of ghost opportunities, the forecast will be too optimistic — and the target will disappoint every month.

Learn how to improve your sales close forecast with real pipeline data.

The graveyard funnel: the biggest enemy of forecasting

A graveyard funnel is a pipeline full of opportunities with no movement — leads that should have been discarded months ago but keep taking up space and inflating the numbers.

Signs of a graveyard funnel:

• Opportunities in the same stage for more than twice the average sales cycle.
• Last contact more than 30 days ago.
• No next action defined.
• Opportunities with a zero value or an outdated estimate.

The solution isn't to clean the funnel once — it's to create a weekly hygiene routine and clear discard criteria.

Integrating the pipeline and the CRM

A pipeline without a CRM is a spreadsheet. A CRM without a process is empty data. The combination works when:

• Every opportunity in the pipeline has a recorded interaction history.
• Changing stages requires the criterion to be met, not just a click from the sales rep.
• The manager sees the pipeline in real time, not after an alignment meeting.
• Automations trigger actions when opportunities stall.

Nexo's solution organizes the sales funnel with integrated process and technology.

Tools for visualizing the sales pipeline

How you visualize the pipeline affects how you manage it. The most common formats:

Kanban (columns by stage)

The most intuitive for the sales rep. Each opportunity is a card that moves between columns. It makes it easy to see what's in each stage and spots buildup visually right away.

Filtered list

Useful for managers who need granularity — filtering by sales rep, stage, deadline, value. It allows more detailed analysis than kanban.

Funnel chart

Shows volume and conversion rate between stages. Ideal for identifying where the funnel leaks. It doesn't replace kanban for operational management, but complements it for strategic analysis.

Most CRMs offer all three formats. Ideally, the sales rep uses kanban day to day and the manager uses the funnel chart in the weekly review.

Pipeline per sales rep vs. consolidated pipeline

Effective management looks at both:

• Pipeline per sales rep: shows individual health — who has a full funnel, who has an empty pipeline, who has stalled opportunities.
• Consolidated pipeline: shows the health of the operation — how much revenue is at stake, what the month's forecast is, where the whole team's bottleneck is.

A manager who only looks at the consolidated pipeline misses the individual diagnosis. One who only looks at the pipeline per sales rep misses the view of the operation.

How to align the pipeline with sales targets

A healthy pipeline isn't just full — it's adequate for the target. The relationship between pipeline and target works like this:

• If the historical conversion rate of the full funnel is 25%, you need 4x the target value in pipeline to hit it.
• If the monthly target is R$ 100,000 and the conversion rate is 25%, the pipeline needs R$ 400,000 in qualified opportunities.

This calculation — called pipeline coverage — should be tracked weekly. A pipeline below 2x the target is a warning sign.

To build real revenue predictability, a well-structured and monitored pipeline is the non-negotiable starting point.

Common pipeline management mistakes that cost revenue

Even experienced teams make systematic mistakes in pipeline management:

Confusing activity with progress: lots of calls and messages don't mean the opportunity is moving forward. Progress is measured by the stage criterion being met, not by the volume of contacts.

Keeping opportunities out of optimism: "this lead is going to close, it's just a matter of time" is the main reason for a graveyard funnel. Without an objective discard criterion, hope wins over data.

Forecasting the best-case scenario: a manager who only presents the number they want to happen loses credibility. A forecast with a range (pessimistic/base/optimistic) is more useful and more honest. To go further, see how to improve sales forecast accuracy.

Neglecting mid-sized opportunities by focusing on the big ones: the big opportunity that's going to "save the month" rarely does. A healthy pipeline has balanced volume, not dependence on one or two closes.

Pipeline reviews with no decisions: a pipeline meeting that ends with only a status update isn't management — it's an oral report. Every review should end with defined actions, an owner and a deadline.

The pipeline as a capacity planning tool

The pipeline isn't just for forecasting revenue — it's for forecasting resource needs:

• A pipeline growing faster than the team's capacity creates a service bottleneck.
• A shrinking pipeline signals the need to reinforce demand generation before the target is affected.
• A pipeline concentrated in a few high-value opportunities signals risk — losing a single opportunity can compromise the month.

A manager who reads the pipeline as a planning instrument makes proactive decisions. One who only uses it to demand results misses the tool's real value.

Talk to a Nexo revenue engineering specialist
Take the free assessment

If the pipeline doesn't exist in an organized form yet, structuring comes before forecasting. See how Nexo's sales structuring works.