Blog · How-to guides · Insurance
Health insurance marketing analytics compares campaign leads, applications and confirmed enrollments. Build a comparable cohort report from aggregate campaign and enrollment exports, calculate stage conversion and acquisition cost, and reconcile the result.
Health insurance marketing analytics compares campaigns by following the same prospect cohorts from lead to application and confirmed enrollment. Start with aggregate campaign and enrollment exports, give every cohort the same follow-up window, and reconcile the stage counts before comparing costs.
The useful question is which campaigns produce completed enrollments at an acceptable acquisition cost, and where prospects stop progressing. A lead-volume report cannot answer that by itself.
Choose one unit before combining exports. In this example, a lead is one unique shopping case assigned to one acquisition campaign. It is not a covered life, an individual website visit or every form submission. A case covering several people still counts once.
Record what each stage means: a deduplicated lead, a submitted application and an enrollment confirmed by enrollment operations. Require those stages to be nested within the same lead cohort. Keep any separate plan-selection status visible rather than treating it automatically as completion.
That distinction has a practical basis. For Marketplace coverage, HealthCare.gov explains that coverage does not start until the first premium is paid. The report should use the applicable confirmed status in its supplied export, rather than infer active coverage from an application count. This is commercial funnel measurement, not an assessment of eligibility.
The wider insurance marketing analytics workflow covers campaign performance across insurance lines. Keep this report focused on health-plan enrollment stages.
Ask marketing for campaign cost by cohort and campaign. Ask enrollment operations for lead, application and confirmed-enrollment counts using those same keys. Include the acquisition-period label, follow-up age, reporting cutoff and completion definition with both files.
Freeze the campaign assignment rule before reviewing results. A first-source rule is workable for this example: each shopping case belongs to its original acquisition campaign throughout the funnel. A later reminder does not create another acquired lead.
Use separate cost and funnel summaries. Joining a campaign invoice onto every application row repeats the cost. Aggregate each source to cohort and campaign first, then match the resulting summaries. Keep unmatched campaigns and unattributed cases in an exception list so they cannot disappear from the total.
This is observed campaign performance. Research about why prospects prefer a plan belongs in marketing research analytics; the stage counts alone do not establish those reasons.
A fictional US brokerage compares September acquisition cohorts after each case has had a 45-day follow-up window. The supplied summaries contain these inputs. Campaign cost includes the same agreed media and campaign-service expense categories for every row.
| Campaign | Leads | Applications | Confirmed enrollments | Campaign cost (USD) |
|---|---|---|---|---|
| Search | 400 | 160 | 120 | 12,000 |
| Partner webinar | 200 | 100 | 80 | 6,000 |
| Display | 600 | 120 | 60 | 9,000 |
| Total | 1,200 | 380 | 260 | 27,000 |
Put these columns in A:E, with campaign rows on rows 2:4. In F:I, calculate application conversion, completion from application, enrollment from lead and cost per enrollment:
F2 =IF(B2=0,"",C2/B2)
G2 =IF(C2=0,"",D2/C2)
H2 =IF(B2=0,"",D2/B2)
I2 =IF(D2=0,"",E2/D2)
Copy the formulas down. Format F:H as percentages and I as currency. An empty denominator produces a blank result requiring review, not a zero acquisition cost.
If the supplied funnel summary has cohort in A, campaign in B and leads in C, the lead count for the campaign in A2 and cohort label in K1 can be assembled with:
=SUMIFS(Funnel!$C$2:$C$1000,Funnel!$A$2:$A$1000,$K$1,Funnel!$B$2:$B$1000,A2)
Microsoft documents SUMIFS as adding values that meet multiple criteria. Use the same criteria to summarize other stage columns, and summarize costs from the separate cost sheet. Covirage is not affiliated with Microsoft.
| Campaign | Application / lead | Enrollment / application | Enrollment / lead | Cost / enrollment (USD) |
|---|---|---|---|---|
| Search | 40.0% | 75.0% | 30.0% | 100.00 |
| Partner webinar | 50.0% | 80.0% | 40.0% | 75.00 |
| Display | 20.0% | 50.0% | 10.0% | 150.00 |
| Total | 31.7% | 68.4% | 21.7% | 103.85 |
Percentages are rounded to one decimal place and costs to two; calculations retain unrounded values. The total cost per enrollment is $27,000 divided by 260, or $103.85. Divide totals rather than averaging campaign ratios:
=SUM(E2:E4)/SUM(D2:D4)
The lead count must tie to the deduplicated acquisition report. Applications and confirmed enrollments must tie to enrollment operations using the same cohort and cutoff. The campaign costs must tie to the included expense lines, with exclusions documented.
Nested stages also provide an identity. The cohort contains 820 leads without an application, 120 applications without confirmed completion and 260 confirmed enrollments. Those mutually exclusive groups sum to 1,200. The middle group can include pending or withdrawn cases; it is not automatically a processing backlog.
Search's 40.0% application rate multiplied by its 75.0% completion rate equals its 30.0% enrollment rate. Apply that check to unrounded ratios for every campaign. A failed identity usually means the stages use different populations or repeated cases.
Display supplies the cheapest leads: $9,000 divided by 600 is $15.00 each. Its cost per enrollment is nevertheless $150.00. That points marketing and enrollment operations toward stage-level review before more lead buying. The partner webinar has the strongest observed enrollment conversion, but its audience and available volume may differ from paid advertising.
For questions about evaluating the reporting approach itself, use the insurance analytics software guide.
Bring aggregate campaign costs and enrollment-stage summaries with matching cohort labels and reporting cutoffs. Covirage maps the columns, and its tools compute and check the campaign comparisons; 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 export.
See Covirage for insurance brokers for the supporting business context.
Use the completion status confirmed by your enrollment operations team and label it explicitly. An application, plan selection and active enrollment can be different events. Preserve separate counts when the export distinguishes them, and keep the chosen definition consistent across campaigns.
Cost per lead helps assess initial acquisition expense, but it does not show how many prospects complete enrollment. Compare it with stage conversion and cost per confirmed enrollment. A cheaper source can become more expensive when fewer leads progress.
Group leads by acquisition cohort and measure each after the same elapsed follow-up period. Keep immature cohorts separate from completed comparisons. Save the cutoff date so a later enrollment update can be distinguished from a change in campaign performance.
The workflow uses campaign identifiers, aggregate prospect counts, stage counts, reporting dates and campaign costs. It does not require diagnoses, treatment details or medical claims. Enrollment operations supplies the stage definitions and the aggregate completion totals used in the comparison.