What is a sales funnel? How to define the stages from New to Won

In the weekly sales meeting, the manager asks three questions: how many open opportunities do we have, which stage is each one waiting in, and what will close this month? The salespeople answer from memory; the figures don’t add up, one opportunity looks “hot” to two people at once, and another stays on the list even though nobody has touched it for months. The meeting feels like an interrogation, and the question “what will close this month?” often goes unanswered. A funnel whose stages are defined in a shared language turns that meeting from guesswork into a look at the records.

A sales funnel is a model that shows the stages prospects go through from first contact to sale and how many opportunities remain at each stage. Some customers drop out at every stage, which is why the shape resembles a funnel. In this article we explain how to define the stages of the funnel, how it differs from a pipeline and how to track an open opportunity.

What is the difference between a sales funnel and a sales pipeline?

The two terms are often used interchangeably and, in practice, look at the same records. The difference lies in the perspective:

How do you define the stages of a sales funnel?

Stage names vary by industry, but every stage needs to be tied to an action. “The customer seems interested” is a feeling; “a demo was held” is an event. The six stages below are a common definition in B2B sales and carry the same names as the opportunity stages in YazSis CRM AI.

Sales funnel technique: five rules that keep the stages working

1. Tie each stage to an event. An opportunity moves to the next stage only when a defined event has happened, not because of a mood.
2. Give every opportunity an owner, an amount and an expected close date. Without these three pieces of information, the totals mean nothing.
3. Write down the next step for every opportunity. A step with a date, such as “send the revised quote on Friday”.
4. Record why an opportunity was lost. Price, timing or a competitor? Loss reasons are the most valuable data for the next period.
5. Review the funnel every week. Weed out opportunities that have been sitting in the same stage for a long time; either move them forward or close them.

A funnel should show where an opportunity really is, not how the salesperson feels about it.

A fictional example: at a small company selling software services, two salespeople interpret the “quote sent” stage differently. One moves a customer to this stage after giving a verbal price; the other only after sending a written quote. When the manager looks at the total number of quotes, the figure is inflated and the month-end forecast misses. Once the stage is defined as “written quote sent to the customer”, the two salespeople’s figures start speaking the same language and the forecast moves closer to reality.

Where does the funnel leak, and how do you read it?

A funnel makes the movement between stages visible. Every transition loses some opportunities, and each loss points to a different question:

• From New to Contact: Prospects cannot be reached. The problem is often the quality of the contact details or the timing of the calls.
• From Contact to Demo: The need does not match, or you are not talking to the decision-maker. Review your criteria for qualifying prospects.
• From Demo to Quote: Scope or budget does not become clear. Follow-up after the demo may have fallen short.
• From Quote to Won: Price, a competitor or timing. This is where loss-reason notes are most useful.

The question a manager should ask in the funnel meeting is not “who made a sale?” but “why is this opportunity waiting in this stage?” The first looks at the result; the second looks at the action that could change it. Reading the funnel this way needs no complex analysis. Looking at the number of opportunities in each stage and spotting where there is a clear drop compared with the previous stage shows you where to focus. The transition with the drop is the first problem to solve; improving the other transitions will not pay off until that one is fixed.

Common mistakes when setting up a funnel

• Defining too many stages and filling none of them in regularly.
• Tying stages to the salesperson’s guess rather than to an event.
• Deleting lost opportunities or closing them without a reason.
• Never updating the expected close date, so an opportunity still looks “about to close” after the date has passed.
• Treating the funnel as a report for the manager only, with nothing in it for the salesperson; yet a reminder of the next step makes the salesperson’s work easier.

How do you track a sales opportunity?

Opportunity tracking is the daily routine that keeps the funnel alive. Over the life of an opportunity, the sequence is as follows:

• When a conversation goes well, an opportunity is opened and linked to the customer record.
• The amount, the owner and the expected close date are entered for the opportunity.
• After each contact, the stage is updated and the next step is written down.
• When the quote goes out, it is linked to the opportunity; versions and approval status stay on record.
• An opportunity still open after its expected close date is flagged as overdue and reviewed.
• The outcome is recorded at closing: if the opportunity is won, delivery begins; if it is lost, the reason is recorded.

Can you run a funnel in Excel or on paper?

Yes. An Excel sheet with a stage column and a pivot table gives a team of a few salespeople a workable funnel. The difficulty is keeping the records up to date. The summary has to be refreshed by hand every time, the sheet does not flag overdue opportunities on its own, and two people can enter the same opportunity in different stages. Paper or WhatsApp, on the other hand, gives you no way of collecting stage information; the manager has to ask the same questions from scratch in every meeting. The way to keep a funnel reliable in Excel is to limit the stage column to a drop-down list, treat the amount and expected close date as mandatory, and refresh the summary before the weekly meeting. If that discipline holds, the sheet will do for a long time; if it does not, changing tools will not solve the problem either.

What does the funnel look like in YazSis solutions?

YazSis CRM AI shows opportunities in the New, Contact, Demo, Quote, Won and Lost stages, in both board and list views. The deal board shows opportunities spread across the stages, with amounts and expected close dates; overdue opportunities are marked in red. A won opportunity can optionally open a collection record. Salespeople call the next company on their call list, record the outcome, and a positive conversation becomes an opportunity.

If you want to run your sales flow in your own portal, the Sales / Quotation & Customer Management module brings registering the customer, opening an opportunity, preparing the quote, completing approval and reporting on the sale together in one shared flow. Sales managers see how many opportunities are in each stage, and which sales have closed, in the same report.

Defining stages is not a one-off job; as your sales process changes, the funnel changes too. When you add a new product or channel, check again whether the stages are still tied to the right events. Start by writing your stages down using the table above, tie an event to each one, and work with only these definitions for a month. To see how opportunities appear on record, take a look at the YazSis CRM AI page.