Blog · Finance metrics and formulas · Sales teams
Calculate Google Ads spending per lead from campaign and CRM exports. Compare valid leads, qualified leads, and acquired customers without mixing their denominators.
Google leads cost is Google Ads spending divided by the valid leads attributed to that spending. Calculate it from a campaign export and a reconciled CRM lead count, then check qualified leads and acquired customers separately. The cheapest initial lead does not necessarily produce the cheapest customer.
Google Ads cost per lead = Campaign ad spend / Valid attributed leads
Cost per qualified lead = Campaign ad spend / Qualified attributed leads
Ad spend per acquired customer = Campaign ad spend / New attributed customers
These are three different questions. The first measures the cost of generating an accepted inquiry. The second measures the cost of an inquiry that passes the business's qualification criteria. The third follows the same lead cohort through a completed sale.
Keep ad spend as the numerator throughout this comparison. Agency fees, creative work, and sales labor belong in a separately labeled cost scope. The broader customer acquisition cost calculation explains that full acquisition boundary.
Do not assume that a platform conversion count equals a unique CRM lead count. Google's conversion counting documentation distinguishes counting every conversion from counting one conversion after an ad interaction. That choice does not replace the company's rules for merging duplicate CRM records across interactions.
Use one campaign-spend file and one lead file. The spend file needs campaign ID, campaign name, reporting dates, currency, and cost. The lead file needs lead ID, campaign ID, creation date, duplicate or exclusion status, qualification outcome, and linked new-customer outcome.
Join outcomes to campaign IDs rather than campaign names. A renamed campaign should retain its history. Before summing, make sure each spend row enters once: joining one campaign total directly to many individual leads can repeat the entire spend for every lead.
Write down what counts as a valid lead. In this example, an accepted inquiry has usable contact details, expresses interest in the service, and is not spam or a duplicate. Qualification then requires the company's service fit and purchasing criteria. An acquired customer is a new account with a completed sale, rather than an existing customer making another purchase.
The general cost per lead page covers the underlying measure; this calculation concentrates on reconciling Google campaign spending to those CRM outcomes.
Consider a US commercial maintenance company. These are illustrative July 2026 campaign costs and lead counts. All campaigns use the same selected 30-day lead-conversion window, and the linked customer outcomes are observed through September 30, 2026.
That observation date is part of the measurement. It prevents a recently created lead from being judged against a lead that has already had time to close. Google defines a conversion window as the period after an ad interaction during which a conversion is recorded; the window used here is a stated example policy, not a benchmark or required setting.
| Campaign | Ad spend (USD) | Raw inquiry records | Excluded records | Valid leads | Qualified leads | New customers |
|---|---|---|---|---|---|---|
| Brand Search | 6,000 | 80 | 16 | 64 | 32 | 8 |
| Category Search | 9,000 | 180 | 30 | 150 | 45 | 6 |
| Regional Search | 3,000 | 60 | 10 | 50 | 25 | 5 |
| Total | 18,000 | 320 | 56 | 264 | 102 | 19 |
The campaign names identify groups in the example. They do not establish that one type of search is generally better than another. The exclusions must be supported by retained status fields, so someone can explain why a submitted inquiry did not become an accepted lead.
Divide each campaign's spend by each relevant outcome count:
| Campaign | CPL calculation (USD) | Cost per qualified lead (USD) | Ad spend per customer (USD) |
|---|---|---|---|
| Brand Search | 6,000 / 64 = 93.75 | 6,000 / 32 = 187.50 | 6,000 / 8 = 750.00 |
| Category Search | 9,000 / 150 = 60.00 | 9,000 / 45 = 200.00 | 9,000 / 6 = 1,500.00 |
| Regional Search | 3,000 / 50 = 60.00 | 3,000 / 25 = 120.00 | 3,000 / 5 = 600.00 |
| Total | 18,000 / 264 = 68.18 | 18,000 / 102 = 176.47 | 18,000 / 19 = 947.37 |
Dollar ratios are rounded to cents after division. Category Search and Regional Search have identical initial CPL, yet their cost per customer differs substantially. The qualification and closing outcomes explain why.
Brand Search qualifies 32 / 64 = 50% of valid leads; Category Search qualifies 45 / 150 = 30%; Regional Search qualifies 25 / 50 = 50%. Their lead-to-customer rates are 8 / 64 = 12.5%, 6 / 150 = 4%, and 5 / 50 = 10%, respectively. Those percentages use the same valid-lead denominator.
First reconcile inquiry records: 320 raw records minus 56 excluded records equals 264 valid leads. Then match those accepted records to the CRM campaign groups. Each qualified lead and acquired customer must belong to the same accepted cohort, with exceptions investigated rather than silently reassigned.
Next reconcile spending: $6,000 + $9,000 + $3,000 = $18,000. That total must match the included campaign-export rows under the stated dates and currency. Explain any billing adjustments separately instead of changing the numerator without a record.
The pooled CPL must also equal the lead-weighted campaign CPL:
(93.75 × 64 + 60.00 × 150 + 60.00 × 50) / 264 = 68.18
The unweighted average, (93.75 + 60.00 + 60.00) / 3 = $71.25, answers a different question because it gives every campaign equal weight. Rebuild the company ratio from totals.
Regional Search deserves a capacity and quality review before additional budget is approved. Its historical results look favorable here, but the table does not prove that the next dollar will buy leads at the same rate. Brand Search may capture existing demand; attributed customers are not proof that advertising caused every sale.
Review qualification criteria with sales before calling a campaign inefficient. Use cost per qualified lead when acceptance quality is the immediate decision. For the revenue earned from these cohorts, continue with Google Ads ROAS; revenue per ad dollar still needs a margin check before it becomes a profit conclusion.
Bring your campaign-spend export and a sample of your own CRM lead records to Covirage. Covirage maps the columns, and its tools compute and check the lead costs and outcome totals; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See Covirage for sales teams for the same work across your sales files. Covirage is not affiliated with Google.
A useful cost per lead fits your own qualification rate, customer conversion rate, and customer contribution. Compare campaigns with the same lead definition and observation period. A low initial lead cost can still produce expensive customers when few leads qualify or buy.
Only when every included conversion action meets your documented lead definition. A combined count can contain purchases, calls, repeat submissions, and other actions. Review the action names and reconcile accepted lead records to your CRM before using the count as the denominator.
An ad-spend-only measure excludes agency fees. A broader campaign measure may include them if that scope is stated and applied consistently. Keep the two versions labeled separately, and avoid comparing a fully loaded campaign figure with another campaign's media-only figure.