In this article
Start with an operational qualification definition
“Good lead” is too vague for a useful comparison. Define the actual business condition: eligible service area, relevant need, accepted budget or another agreed criterion. Record who assigns the status and when the decision is made.
Use a small set of mutually understood stages. A submitted form, a contacted person, a qualified lead and a closed customer represent different milestones. If the team changes those definitions, mark the date so the analyst does not interpret a classification change as improved marketing.
Include an unknown or pending status. A salesperson who has not reviewed a lead has not established that it is unqualified. Mixing pending leads with rejected leads makes recent campaigns look artificially weak.
Export only what the analysis needs
A campaign-level quality review often does not require names, personal email addresses or full sales notes. Aggregate the authorized CRM data by acquisition cohort and campaign where possible. Use secure handling appropriate to the data you are authorized to share.
| Export field | Purpose |
|---|---|
| Campaign identifier | Maps outcomes to the campaign being reviewed |
| Lead acquisition period | Defines comparable cohorts |
| Submitted leads | Establishes the starting denominator |
| Reviewed leads | Shows how complete the quality assessment is |
| Qualified leads | Counts outcomes under the agreed rule |
| Closed customers | Separates sales from preliminary qualification |
| Observation date | Shows how much time the cohort has had |
Document unmapped outcomes. If some leads cannot be matched to a campaign, retain them in an unmapped group. Assigning them to the most likely campaign would create a confident but unsupported result.
Compare qualification coverage before qualification rate
Consider a hypothetical campaign with one hundred submitted leads. Sales has reviewed forty, and twenty are qualified. The qualification rate among reviewed leads is fifty percent; the review coverage is forty percent. It is not yet established that fifty of all one hundred leads are qualified.
Another campaign may have ninety percent review coverage. Comparing only the two qualification rates hides the fact that one estimate describes a much less complete sales review.
Ask whether the reviewed subset was selected systematically. If sales prioritized the most promising leads, the reviewed group may overstate the quality of the full cohort. The analyst should identify this selection issue instead of extrapolating automatically.
Match spend to the cohort carefully
Cost per qualified lead uses campaign spend and qualified leads from a compatible acquisition period. If a CRM export groups qualification dates while the ad report groups lead-acquisition dates, the numerator and denominator can describe different populations.
For a hypothetical cohort with $1,200 of acquisition spend and twelve confirmed qualified leads, the observed cost per qualified lead is $100. If many outcomes remain pending, label the figure provisional. Do not compare it with a fully reviewed older cohort as though both are final.
A closed-customer analysis takes longer still. Preserve cohort age and sales-cycle context. Recent leads may be valuable without having had time to close.
Find the next operating action
A quality review can reveal a sales-process problem rather than an advertising problem. Low review coverage calls for follow-up ownership. High qualification but low appointment attendance calls for another investigation. High closed revenue with an apparently expensive form CPA can justify a different optimization discussion.
Write the next action with an owner and required evidence. “Improve lead quality” is not an actionable conclusion. “Review the pending leads from this acquisition week before reallocating budget” is.
Repeat the export consistently so trends reflect business changes rather than different report methods. Retain the export timestamp and qualification definition with each review.
Use 1ClickReport without assuming a CRM connector
Use 1ClickReport for connected campaign analysis and supply the aggregated quality summary as context in an appropriate supported workflow. This article does not claim a native CRM integration or automatic lead-to-sale matching.
If the supported workflow cannot ingest the file directly, provide the small aggregated table as text. Keep its source and definitions alongside the figures.
Review the connected campaign spend alongside this authorized, aggregated lead-quality table. Verify campaign mapping and acquisition dates. Calculate review coverage, qualification rate among reviewed leads and provisional cost per qualified lead. Keep pending and unmapped outcomes visible. Do not infer individual identities or assume a CRM connection. Recommend the next evidence-gathering or operating action.Frequently asked questions
Do I need a CRM integration for this review?
No. A consistent authorized export can support the analysis, with manual preparation and clearly stated limits.
Are pending leads unqualified?
Not necessarily. Preserve pending status until the agreed review establishes an outcome.
Can the analyst automatically match every lead to an ad?
That capability is not claimed here. Supply verified campaign mapping and retain an unmapped category when needed.
Sources and research notes
Platform statements are linked below. The checklists, worked examples and analyst prompts are original editorial frameworks. Examples labeled hypothetical are not customer results. Research checked October 13, 2026; account availability may differ.