Cost per Lead

Excel Formulas › E-commerce & Marketing

All versions

Cost per lead (CPL) is marketing spend over the leads it generated — the efficiency of demand generation, before any of those leads convert to customers.

Quick formula: CPL from spend and leads:
=marketing_spend / leads_generated
Spend divided by leads. Combine with lead-to-customer rate to back into a true cost per customer.

The example

$3,000 spend, 240 leads.

AB
1ItemValue
2Spend3000
3Leads240 → $12.50

The formula

The formula:

=B2 / B3 // spend ÷ leads

How it works

How it works:

  1. Divide marketing spend by leads generated for CPL.
  2. Tie it to quality: a cheap lead that never converts isn’t cheap.
  3. Cost per customer = CPL / lead_to_customer_rate — the number that matters.
  4. Compare CPL by channel to fund the sources that produce convertible leads.

Cheap leads can be expensive customers. A $5 CPL that converts at 1% costs $500 per customer; a $20 CPL converting at 8% costs $250. Always carry CPL through the funnel — CPL / lead-to-customer rate — before declaring a channel efficient.

Try it: interactive demo

Live demo

Spend, leads, lead-to-customer rate.

CPL · Cost/customer

Variations

Cost per customer

Through the funnel:

=CPL / lead_to_customer_rate

By channel

Compare sources:

=SUMIF(channel, "Search", spend) / SUMIF(channel, "Search", leads)

Leads from a budget

Forecast:

=budget / CPL

Pitfalls & errors

Quality over price. A cheap lead that never converts costs more per customer.

Define a lead. Form fill vs qualified lead give different CPLs — be consistent.

Zero leads. No leads gives #DIV/0!.

Practice workbook

📊
Download the free Cost per Lead practice workbook
A CPL sheet with the cost-per-customer, by-channel, and forecast variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate cost per lead in Excel?
Divide marketing spend by leads generated: =marketing_spend / leads_generated. $3,000 over 240 leads is $12.50.
How does CPL relate to cost per customer?
Cost per customer = CPL / lead-to-customer rate. A cheap lead that rarely converts can mean an expensive customer.
How do I compare CPL by channel?
Use SUMIF: spend by channel over leads by channel to fund the most efficient sources.

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

Related formulas: Customer acquisition cost · Lead-to-customer rate · Cost per click