Sales funnel calculator

The sales funnel and its conversion rates (a conversion rate calculator, stage by stage)

A sales funnel (your pipeline, seen in volumes) describes a prospect’s path from first touch to signature in ever-narrower stages: contacts attempted, conversations, meetings held, proposals sent, customers signed. At every stage, part of the volume stays behind. A stage’s conversion rate is the share that moves on to the next one; the overall conversion rate is the share of initial contacts that ends up as customers.

The close rate (or win rate) usually refers to the last transition: customers signed over proposals sent, or over meetings held depending on the team. That is why a close rate cannot be compared between companies without stating its denominator. In the tool you name your own stages: the rate shown between two bands is always the one of your definitions.

With the starting example, 2,000 contacts attempted give 400 conversations (20%), 120 meetings held (30%), 80 proposals (67%) and 24 customers (30%). The overall rate is 24 ÷ 2,000 = 1.2%. These numbers are an example: replace them with yours, the tool compares them with no market average.

What a call, a conversation and a meeting are worth

Dividing the period’s revenue by a stage’s volume gives the expected value of one unit at that stage, at current rates. In the example, 24 customers at $4,000 make $96,000: each contact attempted is worth $48, each conversation $240, each meeting held $800, each proposal $1,200. That is not what a meeting brings for sure, it is what it brings on average once the losses of the following stages are counted.

This reading changes decisions: a cancelled meeting “worth” $800 deserves a follow-up; an hour of prospecting that produces five conversations is worth $1,200; a list of 500 numbers is worth $24,000 of expected revenue. The tool also shows the reverse reading, “1 customer = 17 conversations”, useful for setting activity targets.

Where the funnel leaks: volume or rate?

Two stages compete for the title of “leak”, and they are not always the same. The stage that loses the most volume is almost always at the top, where everything is still wide: 1,600 contacts stay behind between “contacts attempted” and “conversations”. The stage with the lowest rate can be at the bottom: 30% of signatures on 80 proposals only lose 56 units, but each of them was worth $1,200.

The tool shows both and explains the difference, because the right answer depends on what an improvement costs. Gaining points at the top usually takes more volume or better targeting; gaining points at the bottom takes work on discovery, the proposal and negotiation. The sensitivity ranking settles it: it says what one point brings at each stage.

Why reason in points rather than relative percentages

A funnel is multiplicative: customers = contacts × rate 1 × rate 2 × rate 3 × rate 4. Improving any rate by 10% in relative terms (from 20% to 22%, or from 60% to 66%) increases customers by 10%. A simulator that ranks stages in relative terms therefore ranks nothing: all stages are equal, by construction.

In absolute points the hierarchy appears. Going from 20% to 21% is a 5% relative increase; going from 67% to 68% is only 1.5%. A point of conversion weighs more the lower the stage is. That is what the tool computes: for each stage, the extra customers and revenue with one more point of conversion, the other stages unchanged, then it ranks. For comparison it also shows what 10% more volume at the top of the funnel gives.

A point remains easier or harder to gain depending on the stage. The tool does not know that; you do. The ranking gives the value of a point, and it is up to you to set it against the effort it takes.

Closing the gap to a target

With a revenue or customer target over the same period, the tool computes the gap and two ways to close it, one stage at a time: more volume at the top of the funnel at current rates, or the number of points to gain at a single stage, everything else unchanged. When a stage would have to exceed 100% to get there alone, it says so: that path does not exist.

In practice you combine. In the example, going from 24 to 30 customers takes either 500 more contacts, or 5 points on the first transition (from 20% to 25%), or 7.5 points on the last one. A realistic plan mixes a bit of volume and a few points at the most sensitive stage.

How to measure each stage properly

Rates are only as good as the volumes. Four rules avoid most mistakes.

1. 1

   Define every stage in writing

   Is a “conversation” a pick-up, or an exchange with the right person? Is a “meeting” booked or held? Fix the definition, then count the same way for everyone and for the whole period. The tool’s renamable stages are there for that.

2. 2

   One period, the same everywhere

   All volumes must cover the same period: the quarter’s contacts and the quarter’s customers. If the sales cycle is long, part of the quarter’s customers come from the previous quarter’s contacts: enter the cycle length, the tool reminds you, and prefer a period two to three times longer than the cycle.

3. 3

   Cohort or snapshot

   The most accurate method follows a cohort: January’s 2,000 contacts and what became of them six months later. The snapshot (all of the month’s volumes) is simpler and enough to steer, provided you are consistent. Do not mix the two from one month to the next.

4. 4

   The same people at every stage

   If meetings include those brought by marketing or referrals, the “conversations → meetings” rate is inflated by entries that never went through the previous stage. Either add them at the top of the funnel or take them out, but not in the middle: the tool flags stages with more volume than the previous one.

The levers, stage by stage

The tool’s ranking says where a point is worth the most. Here is what you pull to gain it.

• Contacts → conversations

  Reachability: call at the right times, insist over several attempts, clean the list (wrong numbers, duplicates), show a local number, chain calls with no idle time to multiply attempts in the same hour.

• Conversations → meetings

  The opener and qualification: a short pitch, a discovery question in the first minute, a precise time slot rather than “let’s talk again”, and the right person, not the switchboard.

• Meetings → proposals

  Attendance and discovery: confirm the day before, follow up no-shows the same day, qualify need, budget and decision before writing anything, propose only to those with a project.

• Proposals → signatures

  Negotiation and follow-up: a short proposal with an expiry date, a scheduled follow-up, objections handled by voice before sending, and a decision meeting rather than a “did you have time to look?” email.

The mistakes that distort the analysis

• Mixing periods

  A month of contacts and a year of customers give an absurd overall rate. Align the periods, or lengthen them until they cover the sales cycle.

• Counting booked and held meetings together

  A booked meeting that never happens converted nothing. Count the held ones, or make them two stages: the show rate is a lever in its own right.

• Attacking the lowest rate without looking at volume

  A low rate on a small stage can bring less than a point gained on a wide stage. Read the sensitivity ranking before choosing.

• Ranking stages in relative terms

  “+10% everywhere” gives the same result everywhere: that is a property of multiplication, not information. Reason in points.

• Comparing with out-of-context benchmarks

  A 30% close rate does not mean the same thing measured on proposals or on first meetings, in complex sales or small tickets. The only reliable comparison is your own, from one period to the next.

• Forgetting side entries

  Referrals, inbound requests, trade shows: if they enter in the middle of the funnel, the intermediate rates are wrong. Count them at the top or separately.

Going further

The tools that take over once the funnel has been read.

• How many calls does your target take? The other direction: start from the customers to sign and work back to the calls, hours and reps needed.
• Cost per Meeting Calculator What each meeting costs to obtain, to set against what it is worth here.
• LTV to CAC Calculator What a customer brings over their lifetime, against what they cost to acquire.
• Sales Cadence Generator More attempts per contact, better spread out: the first lever at the top of the funnel.
• When to call your prospects The time slots where people pick up, prospect by prospect.
• All free tools Phone number validator, call scorecard, quota calculator and the others.