A sales funnel is the sequence of stages a buyer goes through from first contact to purchase. It shows how many deals reach each stage, where buyers decide not to buy and where they are left waiting. To find a delay, you need to link the stage to a specific event in the purchase and see how long a deal has gone without progress.
The funnel is drawn, with amounts under the columns. The business owner looks at the largest column and expects the money to arrive soon. But the label “Negotiations” covers both a buyer discussing the terms and one who has been sent a proposal but has not replied. The amount is combined, but the grounds for expecting the money are different.
I think it is too early to expect such a funnel to answer “where is the money stuck?” First, we need to establish why the deals were placed in each column. Otherwise, a new report will only add up the old assumptions more neatly.
The sales funnel in plain words
A funnel helps you trace enquiries through to an outcome. At the start are people interested in your offer. Then some will decline, some will keep talking, and some will buy. The narrowing itself is normal: your product does not suit everyone who enquires.
There are two different views of a funnel. The first follows one group of enquiries: how many reached discussion, agreement and purchase. The second shows the department as it stands now: which deals are at each stage today. Both views look similar on screen. But they answer different questions.
The first shows what proportion of the deals you started reached an outcome. The second shows what the department is working on and where work has built up. If many deals are at the stage of agreeing terms today, that does not yet prove a poor conversion rate: a large group of buyers has recently arrived there. An empty column does not prove success either: deals leave it both when buyers pay and when they decide not to buy.
That is why I add another question to “how much money is here?”: what happened to the deals that were here before? Without it, a simple picture can all too easily become a way to reassure the business owner.
Sales funnel stages: what allows a deal to move forward
Sales funnel stages are defined by how people buy from you. The following sequence suits a service sale that involves an initial discussion:
- Enquiry received — there is a request and a way to contact the person. A repeat message about the same request does not create a new deal.
- Need confirmed — you have established what the buyer needs and that the offer suits them. Sending a presentation does not in itself confirm this.
- Proposal discussed — the buyer has reviewed the option, raised questions or confirmed that it suits them. An email with no reply remains an action by the salesperson.
- Terms agreed — the parties have agreed on what the service includes, its cost and the purchase process. Unresolved disagreements must remain visible.
- Payment received — receipt has been confirmed in the accounts. If it is an advance payment, it is labelled as such; the full order value is not recorded as money received.
This is a basis for discussion with the team, not a compulsory set of names. When a purchase does not require an initial meeting, an extra stage will only slow down the process. If a site inspection is required before a supplier can be chosen, it is worth giving it a separate stage: an inspection has someone responsible for carrying it out, a date and a result that shapes the proposal.
For each transition, write down what fact allows it, where that fact is recorded and who is responsible for obtaining it. For example, confirmation from the buyer allows a move to agreed terms. The salesperson attaches the email or marks the relevant part of the conversation. The head of sales does not have to guess what the status means.
Labels such as “Call”, “Remind” and “Write” are best left for tasks. These are carried out at different stages and say nothing by themselves about readiness to buy. Otherwise, a diligent employee will move the deal record further along simply because they have contacted the customer more often.
A decision not to buy must also have a way out of the funnel, with a reason recorded. If the buyer has named a future date to resume the conversation, save it separately. But a customer's silence gives you no grounds to choose a new purchase date for them.
Sales funnel example: the proposal was sent, but the purchase has not moved forward
Let's take a service sale that includes an initial meeting. The buyer describes the task, the salesperson discusses it, prepares a proposal, agrees the terms and receives payment.
The most interesting point here is sending the proposal. The salesperson has finished a substantial piece of work. It is tempting to select the next stage in the CRM system. But the buyer has not yet said whether the proposed solution suits them.
The department needs to take different actions depending on the reply:
- The buyer says the proposal leaves out part of the task. The salesperson clarifies the requirements and agrees on the correction. Evidence of progress is the buyer's confirmation that the new version meets their needs.
- The proposal is suitable, but someone else on the customer's side is reviewing it. The salesperson finds out how the decision is made and agrees how to pass the necessary materials to that person. Forwarding them does not in itself mean agreement.
- There is no reply. The salesperson finds out whether the buyer is still interested and which means of contact is available. Until there is a reply, it is not even clear whether the proposal is being discussed within the company.
If all these deals sit at “Agreeing terms”, the size of the column is almost useless for deciding what work to do. One buyer needs a revised version, another needs information to make a decision, and contact needs to be restored with the third. A general instruction to “keep pushing” points to none of these actions.
A sample note for the first case reads: “The proposal is missing part of the service requested. The salesperson clarifies what is included with the person delivering the service and sends a revised version by the date agreed with the buyer. Move to the next stage once the buyer has confirmed what is included.” We take the amount from the current proposal and the deadline from the agreement. No probability made up to suit the salesperson's mood.
If the revision needs input from the person delivering the service and they have no time, the constraint is already inside your company. Moving the deal record or making the salesperson call the buyer more often is not enough here. The head of sales must agree a deadline for preparing it or tell the customer straight away that the company will not provide the service as specified.
Sales funnel analysis: find where and why progress stops
Sales funnel analysis starts with the part where the way deals move has changed. Fewer deals move on to discussing the proposal, agreement takes longer, more buyers decline after a meeting — each observation calls for its own review. One overall conversion rate for the department does not identify where the delay is.
Start with this sequence:
- Choose a consistent purchase process: one product and a comparable type of customer. Review first purchases and repeat orders separately if they follow different steps.
- Find the stage where fewer deals move on or more spend a long time waiting. Compare it with previous sales of the same type, rather than someone else's “norm”.
- Open the deals at this stage along with their correspondence and calls. Find the last confirmed event on the buyer's side.
- Establish what needs to happen next and whose action is holding it up. Separately mark deals where the cause is still unknown.
- Choose an action that addresses the cause you found and a sign that will show a change.
I start with deals where the promised deadline for an action has passed, and with large amounts showing no confirmed progress. But alongside them I also look at deals that successfully passed through the same part: how did the purchase process, the customer's requirements and the salesperson's actions differ? Otherwise, it is easy to call a normal step a problem when it is also present in successful deals.
Long waits need explanation. The buyer gave a decision date in advance — the salesperson records the agreement and prepares everything needed. Our company promised an answer and failed to provide it — the head of sales gets the answer from the person responsible for the work. The customer stopped responding — the team restores contact and does not pass off uncertainty as a discussion of terms.
Each situation has its own result. A prepared answer must reach the buyer; restored contact must establish the current status of the purchase; an agreed meeting must take place. A note saying “sent a reminder” completes none of these tasks.
If all this is visible in CRM but the actions stay the same, a separate problem begins: how the head of sales uses the data. That is covered in the article “Our funnel is not fully set up.” And what did the head of sales do after that?. Here, we first make sure the funnel itself distinguishes the reasons for waiting.
Sales funnel analytics: which measures to track together
By sales funnel analytics below, we mean the measures the department calculates regularly. They should help you choose which part to review. I see no point in adding a measure just because CRM can produce it.
For a start, this set is enough:
- Number of deals at a stage and their total value — the amount of work and potential sales at this point. This is the value of the proposals, with no promise that the whole amount will be received.
- Conversion rate between stages — the number of deals that moved forward divided by the number that entered the starting stage, multiplied by 100%. We calculate it for one selected group and state the observation date. If no deals entered the stage, we do not calculate the conversion rate.
- Time at a stage — separately for deals that have passed through it and those currently waiting. The average time for completed transitions will not show old deals that have not moved anywhere.
- Overdue commitments — what was promised by a specific date and has not been done. The date must relate to a real action.
- Decisions not to buy and their reasons — where the sale ended, exactly what the buyer said and what confirms it. An unknown reason remains unknown.
If the group includes recent enquiries, some are still following the normal purchase process. Show separately how many deals reached payment, how many ended with a decision not to buy and how many remain open. Otherwise, today's figure will look final, even though buyers are still making their decisions.
Do not divide the number of payments this month by the number of enquiries in the same month without linking them. Money also came in from older deals; new enquiries still have their own stages ahead of them. This produces a ratio of two numbers from which you cannot judge the outcome for a particular stream of enquiries.
Another trap is adding up the amounts at each stage in a report on one group's journey. One deal has passed through several columns in sequence, and its value is repeated. In the current list of active deals, it must be counted once. Show payments received separately from the value of what is still being sold.
Comparing salespeople requires the same conditions. If one handles repeat orders and another starts relationships with new buyers, the difference in conversion rates does not prove a difference in sales ability. Compare similar sales first.
Sales funnel report: a template for the business owner
A sales funnel report must separate the value of potential sales from the reasons for delay. I need a document that makes it clear what work the head of sales is already responsible for and what decision is still mine to make. A list of amounts by stage does not provide that.
Below is a template you can fill in with your own data:
- Period and scope: which enquiries are included, which purchase process is being considered and the date the data was captured.
- Current position: the number and total value of deals at each stage; payments received on a separate line.
- Changes: how many deals moved forward, how many ended with a decision not to buy and how many are still waiting. If the proposal amount changed, this is shown separately from progress.
- Point of delay: the stage, the deals and the value of their proposals. Separately, missed commitments and waits until a date agreed with the customer.
- Confirmed cause: what is visible in the deal record and the conversation. Where there is no explanation, the question that needs an answer is recorded.
- Head of sales' decision: who takes a specific action, by what date and what result must follow.
- Business owner's decision: what lies outside the head of sales' authority and what options they propose, with the consequences for the deal.
In the example with the incomplete proposal, the last line stays empty if the head of sales has arranged the correction with the person delivering the service. The business owner gets involved when the company must decide whether to take on extra work on new terms. The presence of a delay is not in itself a reason to pass it on to the owner.
When reviewing such a report for the first time, open any amount in the delays line. It should open up into a list of specific deals, and each deal into a confirmed event and an assigned action. If explaining it means calling the whole department again, the report has not yet been put together.
When the funnel still does not explain where money is stuck
The stage names have already been agreed, but the deal record and the conversation still give different versions of what is happening. The salesperson recorded agreement; the buyer asked for a revision. Summary figures alone are not enough: the head of sales needs to compare the record with what was said and choose what to work on now.
RENTROP has AI ROP — a service that increases sales by 20–30 % from the first day. It shows where money is stuck: it analyses calls and correspondence alongside the deal record, shows failures by stage with a quote and sends a report to the business owner in Telegram.
After an honest review, the amount in the active funnel sometimes falls: deals that had already ended with a decision not to buy have been removed. This is unpleasant, but the head of sales is now responsible for work with the remaining buyers. Money in a drawn funnel promises nothing until you can name, for every amount, the buyer and the event that will bring them closer to buying.