Blog · Finance metrics and formulas
Click to lead conversion rate measures accepted leads against eligible campaign clicks. Use ad and lead exports to define the numerator, compare mature click cohorts, and reconcile the result before changing campaign spending.
Click to lead conversion rate is accepted leads divided by the eligible campaign clicks that produced them. Use the same campaign scope and follow-up window on both sides, and say whether a lead means any submission or a unique inquiry that passes a written acceptance rule. A rate without those definitions is difficult to compare or act on.
Click to lead conversion rate = Accepted leads attributed to eligible clicks / Eligible clicks × 100
For this article, accepted means a unique new business inquiry with valid contact information that meets the campaign's written business-fit rule. It does not imply that sales has created an opportunity or that marketing has completed every qualification step.
Google's conversion-rate definition divides conversions by eligible ad interactions and explains that multiple conversion actions can produce multiple conversions per interaction. A click-to-lead report therefore needs a narrower scope: click interactions in the denominator and the agreed lead outcome in the numerator. Do not silently include video views, purchases, newsletter events, or unrelated website actions.
For downstream qualification, use the distinct lead-to-MQL conversion rate. The next sales handoff belongs in lead-to-opportunity conversion rate. Neither uses campaign clicks as its starting population.
The marketing owner should write the counting policy before examining which campaign wins. The export then needs enough detail to apply that policy consistently.
| Export | Fields to retain | Why they matter |
|---|---|---|
| Advertising clicks | Click date, campaign identifier, eligible click count | Establishes the starting population and reporting period |
| Lead register | Lead identifier, originating click or campaign, submission date | Connects the outcome to its acquisition cohort |
| Acceptance review | Duplicate flag, acceptance status, exclusion reason, review date | Separates usable inquiries from repeated or ineligible submissions |
| Attribution notes | Attribution rule, follow-up window, unmatched records | Explains how credit and unresolved records were handled |
Use the same campaign identifiers in both files. If the lead export has only campaign-level attribution, describe the result as a campaign comparison with that limitation. It cannot prove the match between each individual click and each accepted lead.
Document unmatched leads separately. They may be valid inquiries, but assigning all of them to the best-performing campaign would invent evidence. A blank campaign is a reconciliation problem, not permission to drop the row without explanation.
A US commercial-services company compares August 2026 click cohorts. Each click has a full 30-day opportunity to produce an accepted inquiry before the report is prepared. These are illustrative company figures, not external benchmarks.
The exclusions below are sequential and mutually exclusive: duplicate submissions are removed first, then other ineligible submissions are removed from what remains. Accepted leads equal submissions minus those exclusions.
| Campaign | Eligible clicks | Submission rows | Duplicate rows | Other ineligible rows | Accepted leads | Click to lead rate |
|---|---|---|---|---|---|---|
| Brand search | 4,000 | 320 | 20 | 60 | 240 | 6.00% |
| Nonbrand search | 6,000 | 360 | 30 | 150 | 180 | 3.00% |
| Paid social | 5,000 | 250 | 25 | 125 | 100 | 2.00% |
| Total | 15,000 | 930 | 75 | 335 | 520 | 3.47% |
With those columns in A through G, calculate accepted leads in F2:
=C2-D2-E2
Calculate the rate in G2, then format the cell as a percentage:
=IF(B2=0,"",F2/B2)
Fill both formulas through row 4. The total in G5 is:
=IF(SUM(B2:B4)=0,"",SUM(F2:F4)/SUM(B2:B4))
It gives 520 / 15,000 = 3.47%, rounded to two decimal places. The simple average of the campaign rates is 3.67%, which gives equal importance to differently sized click populations. Use the underlying counts when combining campaigns.
The lead accounting identity is:
Submission rows = Duplicate rows + Other ineligible rows + Accepted leads
Here, 75 + 335 + 520 = 930. That must tie to the submitted-record export for the same cohort and attribution rule. The click total must independently tie to the advertising export after any documented platform eligibility exclusions.
The raw submission rate tells a different story:
| Campaign | Submission rate | Accepted-lead rate |
|---|---|---|
| Brand search | 320 / 4,000 = 8.00% | 240 / 4,000 = 6.00% |
| Nonbrand search | 360 / 6,000 = 6.00% | 180 / 6,000 = 3.00% |
| Paid social | 250 / 5,000 = 5.00% | 100 / 5,000 = 2.00% |
| Total | 930 / 15,000 = 6.20% | 520 / 15,000 = 3.47% |
A form-only report overstates the accepted-inquiry outcome in every campaign here. That does not make the submission report wrong; it makes its label and purpose different.
Google's conversion counting guidance distinguishes counting every conversion from counting one conversion per ad click. That setting is useful context, but one per click does not by itself prove one unique lead across all clicks. Reconcile duplicate inquiries using the lead register and your written counting unit.
The broader distinction between denominators is covered in win rate, close rate, and conversion rate.
Brand search has the highest accepted-lead rate in this example. That supports reviewing its offer and audience, but it does not establish that expanding its budget would produce the same result. People already looking for the company may differ from people discovering it through a broader campaign.
For nonbrand search and paid social, inspect rejection reasons before changing the landing page. An inquiry outside the service area suggests a different review from a valid prospect who submitted twice. Ask the lead owner to distinguish targeting, form usability, acceptance rules, and attribution coverage.
Compare acquisition cost and subsequent sales outcomes in separate measures before reallocating spending. A high early-stage rate alone cannot establish profitable growth. The qualified-lead conversion rate follows a later stage and should retain its own starting population.
Covirage is not affiliated with Google.
Bring a file or Google Sheet with eligible campaign clicks, attributed lead records, dates, and acceptance flags. Covirage maps the columns, its tools compute and check the campaign rates, and the external AI model explains the comparison with every figure traced to its rows. Create a free Covirage account, set up your business, and bring a sample of your own export.
See Covirage for sales insights for the supporting approach.
Only if the report explicitly measures submission events. For an accepted-lead measure, remove duplicate submissions and apply a written eligibility rule. Keep the raw submission rate alongside it so the team can distinguish form response from usable new business inquiries.
No. A click is an advertising interaction, while a session is a period of website activity. Repeat clicks, incomplete page loads, and measurement differences can prevent the counts from matching. Label a sessions-based result separately and retain its own denominator.
A useful target depends on the campaign audience, offer, lead acceptance rules, and follow-up window. Compare similar campaigns under stable definitions first. A higher rate can come from existing customer demand or looser qualification, rather than more productive acquisition spending.
Use click date for a cohort rate that asks what a group of campaign clicks eventually produced. Submission-date reporting answers an operational workload question. Keep both views if needed, but do not divide leads from one view by clicks from the other.