Blog · Finance metrics and formulas · Software
Calculate SaaS cost per lead from campaign and CRM exports, then follow the same leads into opportunities and customers. This worked example connects lead costs to acquisition cost and gross-profit payback.
Average cost per lead for SaaS is attributable marketing spend divided by eligible leads generated. Calculate it by campaign, then follow those same prospects through qualification, opportunities and won customers. A cheaper lead only helps when the conversion and customer economics support the acquisition spending.
Agree on what counts as a lead and which costs belong to the campaign. Salesforce's CPL explanation uses marketing spend divided by leads generated; the important reporting choice is to preserve the same scope across comparisons.
For this example, an eligible lead is a distinct new-business prospect company with contact information. Deduplicate repeated registrations and exclude existing customers. Assign each company to one acquisition campaign under a documented rule, so it cannot be credited to both campaigns in the total.
Keep qualification separate from opportunity creation. Salesforce's lead and opportunity guide distinguishes early prospects from viable deals that have progressed through evaluation. Your marketing and sales leaders must agree on the criteria used in their own reporting.
The general cost per lead page owns the core metric; cost per lead by industry addresses broader comparisons. Here the job is to connect SaaS campaign results to customer economics.
Bring campaign spending, lead records, opportunity history and won-customer revenue and delivery costs. Retain campaign ID, lead-company ID, creation date, qualification date, opportunity ID, outcome and reporting cutoff. Count companies once at each milestone, even when several contacts or opportunities exist.
Consider leads generated in the first quarter of 2026, followed through September 30, 2026. The hypothetical US SaaS company treats the campaigns as sufficiently mature for this review and keeps unresolved opportunities in its supporting records. Qualification means sales accepted the prospect's fit and active need; an opportunity requires a documented deal and next step.
Put these inputs in columns A:I, with Search on row 2 and Webinars on row 3. Amounts are USD. Marketing spend includes media or event costs and allocated marketing labor; additional acquisition costs include sales effort and commissions assigned to these prospects through the cutoff, without duplicating marketing costs.
| Column | Input | Search | Webinars |
|---|---|---|---|
| A | Campaign | Search | Webinars |
| B | Marketing spend (USD) | 12,000 | 9,000 |
| C | Eligible leads | 120 | 300 |
| D | Qualified leads | 60 | 45 |
| E | Companies reaching opportunity | 24 | 9 |
| F | New customers won | 6 | 3 |
| G | Additional acquisition costs (USD) | 6,000 | 4,500 |
| H | Monthly revenue per won customer (USD) | 500 | 500 |
| I | Delivery gross margin | 80% | 80% |
Use the same cost-of-revenue policy for both cohorts. The separate SaaS gross margin page explains that classification question.
Enter these Excel formulas on row 2 and fill down. Microsoft's formula guide documents the cell references and arithmetic operators used here. Each destination cell is identified before its expression; enter only the expression beginning with =.
J2 = B2/C2
K2 = B2/D2
L2 = B2/E2
M2 = F2/C2
N2 = (B2+G2)/F2
O2 = H2*I2
P2 = N2/O2
Covirage is not affiliated with Microsoft or Salesforce.
| Output | Search | Webinars |
|---|---|---|
| J: Cost per eligible lead (USD) | 100.00 | 30.00 |
| K: Cost per qualified lead (USD) | 200.00 | 200.00 |
| L: Marketing cost per opportunity company (USD) | 500.00 | 1,000.00 |
| M: Lead-to-customer conversion | 5.0% | 1.0% |
| N: Cohort acquisition cost per customer (USD) | 3,000.00 | 4,500.00 |
| O: Monthly gross profit per customer (USD) | 400.00 | 400.00 |
| P: Simple gross-profit payback (months) | 7.50 | 11.25 |
Calculations use unrounded inputs; currency and payback are displayed to two decimals. Webinars have lower CPL, but no advantage at the qualified-lead stage. Their weaker conversion and additional acquisition spending produce higher acquisition cost per customer.
Payback assumes constant monthly gross profit, no churn and no expansion. It measures months of service gross profit needed to recover acquisition cost; it excludes the time spent selling and does not represent bank cash collection timing. See customer acquisition cost for the full cost boundary and average SaaS CAC for comparable acquisition benchmarks.
Combined CPL is $21,000 divided by 420 leads, or $50. The simple average of $100 and $30 is $65, which gives campaigns with different lead volumes equal weight. In a total row, divide total spend by total leads.
Also reverse the payback arithmetic. Search's 7.50 months × 6 customers × $400 monthly gross profit equals $18,000 of acquisition spending. Webinars' 11.25 × 3 × $400 equals $13,500. Tie those costs to the allocation schedule and tie won companies to the customer register.
Suppose management chooses an eight-month gross-profit payback limit for this decision. At $400 monthly gross profit, allowable acquisition cost is $3,200 per customer. After subtracting additional acquisition costs per win, Search has $2,200 available for marketing and Webinars $1,700. At observed lead-to-win conversion, their corresponding CPL limits are $110 and $17.
Those are company assumptions, not industry standards. Search's $100 CPL fits this limit; Webinars' $30 does not. Marketing and sales should investigate qualification and conversion before assuming that cheaper registrations justify more spending.
Bring campaign spending, CRM outcomes and a prepared customer revenue-and-delivery-cost export with a common cohort cutoff. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for SaaS teams for the supporting industry context.
A useful target depends on conversion, contract economics and the acquisition costs that remain after lead generation. Work backward from an approved acquisition-cost or payback limit. Compare external averages only when channel, customer segment, lead qualification and cost scope match your own calculation.
Report both with clear labels. Standard CPL divides the defined marketing spend by eligible leads; cost per qualified lead divides that spend by leads meeting agreed criteria. Keep qualification rules stable so a changing denominator does not masquerade as better campaign performance.
No. CPL divides marketing spend by leads, while customer acquisition cost includes the defined sales and marketing costs of winning new customers. A lead is an intermediate result. Conversion losses and additional sales effort can make a low-CPL campaign expensive at the customer stage.
Group leads by acquisition cohort and retain a reporting cutoff for subsequent opportunities and wins. Compare cohorts with similar time to mature. Keep open opportunities visible and label immature results instead of dividing this month's lead spending by customers acquired from unrelated earlier campaigns.