Lead-to-customer rate is the share of all leads that become paying customers — the top-to-bottom funnel efficiency. Customers won over total leads, the number marketing and sales share.
The example
24 customers from 600 leads.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Customers | 24 |
| 3 | Leads | 600 → 4% |
The formula
The formula:
How it works
How it works:
- Divide customers won by total leads for the end-to-end conversion rate.
- It’s the product of every stage rate — usually a low single-digit percentage.
- Use it to work backwards: leads needed = target customers ÷ rate.
- Segment by source with
COUNTIFSto find the highest-converting channels.
Plan acquisition backwards from it. If you convert 4% of leads and need 50 customers, you need 50 / 0.04 = 1,250 leads. Tie that to CAC and channel conversion rates and the sheet becomes a demand-gen plan: how many leads, from which sources, at what cost, to hit the customer target.
Try it: interactive demo
Customers won and total leads.
Variations
Leads needed for a target
Work backwards:
By source
Best channel:
From stage rates
Product of stages:
Pitfalls & errors
All leads. Denominator is total leads, not just qualified ones (unless you mean MQL-to-customer).
Define a lead. Be consistent about what counts as a lead across periods.
It’s the funnel product. Equals all stage rates multiplied together.
Practice workbook
Frequently asked questions
How do I calculate lead-to-customer rate in Excel?
How many leads do I need for a customer target?
How does it relate to stage conversion?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class