Blog · Finance metrics and formulas
Lead to opportunity conversion rate measures eligible leads that reach a defined opportunity stage. Calculate it from dated CRM exports, compare sources after equal follow-up, and reconcile every starting lead to an outcome.
Lead to opportunity conversion rate measures the share of eligible starting leads that reaches a defined opportunity stage within a stated observation window. Use a lead-creation cohort and count distinct leads, rather than dividing this month's opportunity total by this month's unrelated lead intake.
Lead to opportunity conversion rate = Distinct eligible leads reaching an opportunity within the window / Distinct eligible starting leads × 100
Define an opportunity in business terms before calculating. It might require a confirmed need, an identified sales owner, and an accepted next step recorded against a deal. The threshold belongs in the report notes, alongside the cohort dates and follow-up window.
Salesforce's explanation of leads and opportunities describes opportunities as qualified prospects considered viable business deals. That distinction supports requiring evidence of a deal, rather than treating every inquiry as pipeline.
This is an intake measure. A meeting-to-opportunity rate starts later, with meetings already held, and answers a different question. Likewise, lead-to-MQL conversion measures marketing qualification before the opportunity threshold.
Use the lead export plus the opportunity identifiers and first qualifying opportunity dates. Retain converted and unconverted records. A current open-leads list alone cannot establish the denominator because successful records may have left that list.
Keep these fields: lead ID, lead created date, original source, eligibility reason, first qualifying opportunity ID, and first qualifying opportunity date. Preserve blank dates as missing outcomes. If a lead maps to several opportunities, use its earliest qualifying date and retain the other relationships for audit.
Choose whether the starting unit is a person, company, or inquiry. Here it is a distinct lead person. Deduplicate repeat imports using the company's identity rules, with a separate exception list for uncertain matches. Do not merge unrelated people just because they work for the same company.
The following illustrative company measures January 2026 leads for opportunity creation within 30 elapsed days of each lead's creation. Its dated export is March 31, 2026, so every January lead has a complete window. A January 31 lead reaches that deadline on March 2, 2026.
First reconcile the starting file. Exclusions below are mutually exclusive and applied in the listed order.
| Eligibility step | Rows removed | Rows remaining |
|---|---|---|
| Raw lead-export rows | 0 | 12 |
| Duplicate imported rows | 2 | 10 |
| Internal test lead | 1 | 9 |
| Existing opportunity mistakenly imported as a new lead | 1 | 8 |
| Eligible starting leads | 4 | 8 |
The exclusion check is 12 − 2 − 1 − 1 = 8. A legitimate new lead that sales later rejects stays in those eligible rows.
| Lead | Original source | Created | First opportunity | Elapsed days | Within window |
|---|---|---|---|---|---|
| L01 | Paid search | January 1, 2026 | January 15, 2026 | 14 | 1 |
| L02 | Paid search | January 2, 2026 | February 10, 2026 | 39 | 0 |
| L03 | Paid search | January 3, 2026 | None | — | 0 |
| L04 | Referral | January 4, 2026 | January 9, 2026 | 5 | 1 |
| L05 | Referral | January 5, 2026 | January 20, 2026 | 15 | 1 |
| L06 | Referral | January 6, 2026 | None | — | 0 |
| L07 | Event | January 7, 2026 | February 5, 2026 | 29 | 1 |
| L08 | Event | January 8, 2026 | February 7, 2026 | 30 | 1 |
Day zero is the created date; an opportunity on the final day counts. The company uses dates in one reporting time zone throughout. With timestamps, apply the same elapsed-time convention consistently.
| Calculation step | Arithmetic | Result |
|---|---|---|
| Count eligible leads | 3 paid search + 3 referral + 2 event | 8 |
| Count timely conversions | 1 paid search + 2 referral + 2 event | 5 |
| Divide outcomes by starts | 5 / 8 | 0.625 |
| Express as a percentage | 0.625 × 100 | 62.5% |
The late conversion remains useful pipeline, but it is outside this rate's deadline. Counting it would change the question being answered.
Put the eligible rows on Leads, with ID in A, source in B, created date in C, and first opportunity date in D. Use genuinely blank cells for missing dates, rather than the word None. On Settings, B1 contains 30 and B2 contains =DATE(2026,3,31).
E2 flags a mature starting lead; F2 flags a timely opportunity:
=--AND(ISNUMBER(C2),Settings!$B$2>=C2+Settings!$B$1)
=--AND(E2=1,ISNUMBER(D2),D2>=C2,D2<=C2+Settings!$B$1)
Fill down through row 9. Because this sheet contains only the eligible January cohort, its total rate is:
=IF(SUM(E2:E9)=0,"",SUM(F2:F9)/SUM(E2:E9))
For a source named in H2, calculate the source rate:
=IF(COUNTIFS(B2:B9,H2,E2:E9,1)=0,"",COUNTIFS(B2:B9,H2,F2:F9,1)/COUNTIFS(B2:B9,H2,E2:E9,1))
Microsoft documents COUNTIFS as counting rows where all the supplied criteria match. Covirage is not affiliated with Salesforce or Microsoft.
| Original source | Eligible leads | Timely opportunities | Conversion |
|---|---|---|---|
| Paid search | 3 | 1 | 33.3% |
| Referral | 3 | 2 | 66.7% |
| Event | 2 | 2 | 100.0% |
| Total | 8 | 5 | 62.5% |
Round displayed percentages to one decimal place and retain unrounded ratios in formulas. These tiny illustrative groups demonstrate the arithmetic; they do not establish which channel deserves a larger budget.
Every eligible lead must land in exactly one outcome bucket: timely opportunity, opportunity after the deadline, or no opportunity as of export. Here 5 + 1 + 2 = 8, matching the eligible population. Source denominators also add to the same total, and source numerators add to the same timely conversions.
The company rate is total converted leads divided by total starts. Do not average the displayed source percentages. The underlying stage conversion principle is that every numerator must belong to its denominator.
Use this report to investigate qualification and handoffs, then inspect opportunity quality and subsequent wins before reallocating spend. The wider revenue operations measures connect those handoffs to later sales outcomes.
Bring a dated CRM export or Google Sheet containing lead IDs, original sources, creation dates, and linked opportunity dates. Covirage maps the columns; its tools compute and check eligible cohorts and source comparisons, and 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 data.
See sales insights for the supporting sales reporting context.
Count the business event your metric defines, supported by an opportunity record or equivalent evidence. A lead may become a contact without meeting your opportunity criteria. Reconcile the opportunity identifier and creation date rather than relying on a generic converted status.
Leads disqualified after entering the eligible cohort normally remain. Otherwise weaker sources can appear stronger simply because more failures were removed. Exclude only records outside the written starting population, such as duplicate imports or internal test submissions.
Choose a window that fits the company's actual qualification cycle and keep it fixed for the comparison. Longer sales processes may need longer observation. Show immature cohorts separately until all their leads have had the full window.
Yes, depending on your attribution rules. A lead-based rate can count several distinct eligible leads as converted if each has qualifying evidence. Separately report distinct opportunities so the company does not confuse converted people with newly created deals.