Blog · Finance metrics and formulas
Lead generation conversion rate measures visits or clicks becoming valid leads. Work through a source-level example, remove spam and duplicates, and reconcile the result to the original exports.
Lead generation conversion rate is valid leads divided by the eligible visits or clicks that generated them. The useful comparison starts with a named denominator and a written rule for spam and duplicate submissions. A rate based on every form submission can look strong while sending little usable demand to sales.
Lead generation conversion rate = Valid leads / Eligible visits or clicks × 100
For a landing-page report, use eligible sessions on the pages where the offer appeared. For an advertising report, use the tracked ad interactions that could produce the recorded leads. Keep the denominator's name in the column heading rather than using the word traffic for both.
The distinction follows the underlying measures. Google Analytics defines a session as a period of interaction with a website or app. Google Ads defines conversion rate using conversions divided by eligible ad interactions. Those are different starting points, so an advertising rate need not equal a landing-page rate.
This example measures accepted new leads per landing session. Each accepted lead is assigned to its originating session, and a session can contribute at most one accepted lead. The contact is also counted only once within the reporting campaign and month. This makes the result a response yield for that defined audience and offer.
Later sales stages have their own denominators. Use stage conversion for the general distinction, and lead-to-MQL conversion when the question is whether captured leads satisfy marketing's qualification rules.
Bring a landing-session export and a form-submission export for the same campaign, date range, and reporting timezone. The session file needs session ID, session date, source, and landing page. The submission file needs submission ID, submission timestamp, contact identifier, originating session ID, source, and the review outcome.
Agree on the outcome rules before looking at source performance:
Make those outcomes mutually exclusive. Review spam first, then find duplicates among the remaining submissions. That prevents a repeated spam record from being subtracted twice. Preserve the original rows and add review columns; deleting exclusions removes the evidence needed to prove the total.
Assign a retained contact to the source of its earliest accepted submission. A later email click should not move an earlier paid-search lead into email. Leave unmatched sessions in an explicit unresolved group until they can be assigned or excluded under a stated rule. Never distribute them across sources just to make the comparison look complete.
A US industrial distributor reviews January 2026 landing sessions and submissions. All sessions are eligible for the same offer, and all submitted leads have a matched originating session. This is an illustrative operating example, with no claim that the rates represent an industry benchmark.
| Source | Eligible sessions | Raw submissions | Spam | Duplicates | Valid leads | Valid leads / sessions |
|---|---|---|---|---|---|---|
| Paid search | 10,000 | 600 | 60 | 40 | 500 | 5.00% |
| Organic search | 6,000 | 360 | 12 | 18 | 330 | 5.50% |
| 4,000 | 280 | 20 | 10 | 250 | 6.25% | |
| Total | 20,000 | 1,240 | 92 | 68 | 1,080 | 5.40% |
For paid search, valid leads are 600 − 60 − 40 = 500. Its rate is 500 / 10,000 × 100 = 5.00%. The company total is 1,080 / 20,000 × 100 = 5.40%; percentages are rounded to two decimal places.
With the table's columns in A through G and the sources in rows 2 through 4, calculate valid leads in F2 and the rate in G2:
=C2-D2-E2
=IF(B2=0,"",F2/B2)
Fill down and format G as a percentage. A blank rate when sessions are zero signals that the ratio is undefined. Treat it as a data question rather than silently replacing it with zero.
The total rate is:
=SUM(F2:F4)/SUM(B2:B4)
The raw submission rate would be 1,240 / 20,000 = 6.20%. Cleaning removes 160 submissions, or 12.90% of the raw count, and leaves a lower but more useful measure of accepted demand.
First, reconcile the outcomes to the source file. Valid leads plus spam plus duplicates must equal raw submissions for every source. For the total, 1,080 + 92 + 68 = 1,240. Any gap means a row is missing, unreviewed, or assigned more than one outcome.
Second, prove that the source rates rebuild the overall result. Weight each source's unrounded rate by its sessions:
=SUMPRODUCT(B2:B4,G2:G4)/SUM(B2:B4)
This returns the same 5.40% as the ratio of total leads to total sessions. Do not average source percentages without their traffic weights.
Third, tie the session total to the original landing-page report with the same filters. Tie the valid contact count to the accepted CRM records. A CRM import failure can leave marketing with an accepted lead that sales never received; that is a handoff problem, not a reason to change the session denominator.
The click-to-lead conversion rate page owns the detailed click-based calculation. Keep that result separate when ad clicks and recorded website sessions differ.
Covirage is not affiliated with Google.
Bring your session totals and lead export, with source identifiers and explicit spam and duplicate review columns, to Covirage. Covirage maps the columns; its tools compute and check the source totals and conversion rates, 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 sales insights for the related work on lead and customer outcomes.
Use clicks when evaluating the response to an advertising interaction, and visits when evaluating a landing page. Label the denominator beside the result. A click-based rate and a visit-based rate answer different questions, even when both use the same accepted leads.
Only if your written definition treats them as distinct prospects. A common operational rule retains the earliest accepted submission for a contact within a campaign period. Preserve the later records as exclusions so the cleaned count still reconciles to the original form export.
A high response rate can come from a strong offer, easier form, or different audience. It does not establish that the leads become customers. Read the result alongside qualification and customer outcomes before increasing spend or reducing the information a form collects.