A pipeline is a list of opportunities organized by stage, with criteria for advancing and a next action. Even a simple table is useful when updated with evidence, helping the team see where opportunities stall.
Start with five stages with clear conditions
A simple framework includes new contact, confirmed need, proposal sent, terms under discussion and order completed. At confirmed need, identify the problem the customer wants solved, timing and contact. At proposal sent, retain the actual proposal and points awaiting feedback.
Terms under discussion requires specific exchanges about scope, timing or implementation, rather than simply “I’ll take a look.” Completed orders need clear internal criteria, distinct from order confirmation and full payment. Deferred or discontinued opportunities should have separate statuses so the open list does not become inflated.
What does each row need?
Basic fields: opportunity ID, business or contact, need, lead source, stage, owner, most recent exchange, next action, update date and reason for postponement or discontinuation. If estimated value is recorded, include its basis and the relevant proposal version.
An opportunity without an owner or next action is easily forgotten. Store only data needed for work, limit viewing rights by role and avoid placing customer information in a public table. When a business has multiple projects, define how to separate them without double counting.
Hypothetical scenario: more contacts do not necessarily mean more opportunities
Assume 40 opportunities are followed through a full chosen cycle. Twenty have confirmed needs, 12 receive proposals and 6 complete orders under the internal definition. Contact-to-need conversion is 20/40 = 50%; need-to-proposal is 12/20 = 60%; proposal-to-completion is 6/12 = 50%. Overall conversion is 6/40 = 15%.
These figures only illustrate the calculation. Do not divide this month’s quotations by this month’s completed orders from different cohorts and conclude a conversion rate. The hypothetical cohort raises questions: what information is missing from the 20 unqualified contacts; what are the 8 opportunities without proposals waiting for; and which terms are holding up the 6 incomplete proposals?
Read nextA bottleneck at quotations: use the seven-item information checklistReview through questions and evidence
In a review, ask for each opportunity: what is the latest information, who is the customer waiting for, what is the team waiting for, does the next action have an owner, and is the expected date confirmed? Cross-check exchange history rather than relying on a confidence estimate.
Time at each stage is a signal to investigate, with no universal benchmark across industries. An annual-budget project differs from an order for an approaching event. Opportunities with no remaining demand should be stopped or deferred with a reason, rather than prolonged to keep the table looking good.
Read nextA bottleneck at responses: choose a suitable follow-up templateChoose one bottleneck to improve
If there are many contacts but few real needs, review sources and screening questions. If needs are clear but proposals are slow, review preparation ownership and missing information. If many quotations fail to progress, examine scope clarity, approval procedures and follow-up content.
Test a change within a sufficiently small scope, record a baseline and observation period. In before-and-after comparisons, disclose differences in lead sources, seasonality and products; an increased ratio alone does not establish causation. After completion, hand necessary information to customer care so the experience remains continuous when responsibility changes.
Read nextAfter order completion: build a path for customers to return- Each stage needs real-world criteria to avoid the impression that a deal is nearly closed.
- Compare conversion within the same cohort and allow enough follow-up time.
- Record reasons for stalling to choose improvements, rather than merely increasing contacts.
A pipeline organizes work and questions needing clarification. It has value only when statuses reflect an opportunity’s actual progress.
Suggested actions
Frequently asked questions
Do you need CRM software to manage a pipeline?
Start with a spreadsheet with appropriate permissions and an update owner. As volume or complexity grows, assess tools against actual needs such as history, assignments and reports.
Can opportunity value be counted as revenue?
No. It is the expected value of work still under discussion. Confirmed orders, completed orders, revenue and collected cash must be distinguished under the business’s recognition methods.
Does an opportunity staying at one stage mean sales performance is poor?
There is insufficient evidence to conclude that. The customer may be awaiting budget or implementation timing. Check the reason, criteria and next action before evaluating performance.
Series: From a price inquiry to a B2B order
- B2B quotations: Seven details that make customer decisions easier
- Following up after a quotation: five conversation templates that create a next step
- The B2B sales pipeline: find bottlenecks from first contact to completed orders
Sources and updates
Original guidance from Bài Học Kinh Doanh. Conversation templates and scenarios are designed for practice; figures are explicitly hypothetical, not survey results or industry benchmarks.
Last updated: 1 Oct 2026




