Lead to MQL conversion rate: formula and qualification rules

Lead to MQL conversion rate measures the share of eligible leads that reaches a written marketing qualification threshold within a stated follow-up window. Keep the qualification rule, creation cohort, and observation time consistent before comparing sources or calling a movement an improvement.

The formula and the qualification rule

Lead to MQL conversion rate = Distinct eligible leads first qualifying as MQL within the window / Distinct eligible starting leads × 100

An MQL is a marketing-qualified lead. HubSpot's lifecycle documentation defines this stage around marketing's judgment that a lead is ready for sales. That does not establish a universal score or a universal conversion target; the company must write its own operational rule.

The rule should specify qualifying business characteristics, engagement evidence, mandatory fields, exclusions, and the first qualifying event. Assign a version name and effective date. A lead must meet every required condition, not just whichever condition is easiest to export.

This page measures the marketing handoff. The next lead-to-opportunity measure tests whether eligible lead cohorts reach actual opportunities. Use both to avoid celebrating a qualification increase that sales cannot turn into viable deals.

The export fields you need

Start with one eligible, deduplicated row per lead, including people who never qualified. Export the lead ID, created date, original source, first MQL date, qualification rule version, and the evidence supporting that first event.

A current lifecycle value cannot replace the first MQL date. Someone now classified as a customer may already have qualified, while someone currently classified as an MQL might have entered that stage only after the reporting deadline. Retain stage history and any rule corrections rather than reconstructing dates from today's label.

Choose the counting unit in advance. A person-based lead cohort and an account-based cohort can produce different denominators. Deduplicate repeat imports, but do not automatically collapse all the contacts at a company into one lead.

For a source report, freeze the intake source at creation. Keep blank sources in an explicit unassigned group. Otherwise the denominators will no longer reconcile to the cohort total.

A worked example with a fixed deadline

An illustrative US commercial-services company uses rule MQL-A: confirmed business fit and an engagement score of at least 70. The score is an operational qualification input, not a probability of purchase. The table preserves the score evidence at first qualification; for leads that never qualify, it shows the assessment at the export date.

The company measures April 2026 intake, allowing 14 elapsed days after each lead's created date. Its export date is May 31, 2026. Even a lead created on April 30 reaches the full deadline on May 14, 2026, so the creation cohort is mature.

M03 has a high engagement score but fails the fit condition. M04 and M10 qualify after their deadlines. M06 qualifies on the last permitted day and counts. A day-zero qualification would also count under this elapsed-day convention.

The unrestricted rate is 20.0 percentage points higher because it answers a different timing question. Both figures can be useful, but they need distinct labels.

Rebuild the result in a spreadsheet

Put eligible rows on Leads, with ID in A, source in B, created date in C, first MQL date in D, and rule version in E. Leave missing dates blank. The dated MQL evidence should already have been checked against the written rule; a current score cannot prove what was true on an earlier date.

On Settings, B1 contains 14, B2 contains =DATE(2026,5,31), and B3 contains MQL-A. F2 flags a mature lead, while G2 flags a timely first qualification:

=--AND(ISNUMBER(C2),Settings!$B$2>=C2+Settings!$B$1)
=--AND(F2=1,E2=Settings!$B$3,ISNUMBER(D2),D2>=C2,D2<=C2+Settings!$B$1)

For this sheet of eligible April leads all assessed under MQL-A, fill down through row 11 and calculate:

=IF(SUM(F2:F11)=0,"",SUM(G2:G11)/SUM(F2:F11))

For a source label in I2, use:

=IF(COUNTIFS(B2:B11,I2,F2:F11,1)=0,"",COUNTIFS(B2:B11,I2,G2:G11,1)/COUNTIFS(B2:B11,I2,F2:F11,1))

Microsoft's COUNTIFS guidance explains that a row counts only when every specified criterion matches. Covirage is not affiliated with HubSpot or Microsoft.

Display percentages to one decimal place, retaining unrounded values in calculations. The source counts are too small to establish channel performance; they make the denominator and timing rules visible.

Reconcile outcomes and choose the next question

Every starting lead belongs to a mutually exclusive bucket: timely first MQL, late first MQL, or never qualified by export. Here 5 + 2 + 3 = 10, matching the cohort. Source starts add to the denominator and source timely outcomes add to the numerator.

The company rate comes from summed counts, following the same principle as stage conversion. It is not the simple average of source percentages. Compare subsequent cohorts under the same rule before investigating source-level changes.

If an acquisition channel produces many leads but few MQLs, inspect fit failures and missing evidence. If MQL conversion rises while opportunity conversion weakens, review whether the threshold still describes sales-ready prospects. For the earlier acquisition step, see click-to-lead conversion; it uses a different starting population.

Where it goes wrong

• Thresholds change without a visible break. A new score cutoff or fit rule changes the measure itself.
• Current stage substitutes for history. Advanced contacts disappear from MQL counts, while late qualifiers enter too soon.
• Unqualified leads are removed after assessment. That deletes the failures the rate is meant to reveal.
• Recycled leads are counted repeatedly. First qualification is one event per eligible starting lead.
• Rule versions are mixed. Split the report or reassess a common cohort under a consistent rule with preserved evidence.

Compare qualification cohorts in Covirage

Bring your lead export or Google Sheet with creation dates, sources, first qualification dates, and the written rule version. Covirage maps the columns; its tools compute and check cohort outcomes, 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.