β οΈ Mockup with sample data β designed to facilitate the KPI conversation. Numbers, trends, and clinic splits are illustrative and not from production systems.
Headline KPIs Β· Last 12 Months
Total Marketing Spend
$4.2M
β² 8.2% vs prior period
Total Inquiries
12,540
β² 11.4% vs prior period
Attended NPVs
6,418
β² 6.1% vs prior period
Attributed Revenue
$84.1M
β² 9.8% vs prior period
Blended ROI
19.0x
β² 1.2x vs prior period
Marketing Funnel Last 12 months Β· all channels
Spend vs. Attributed Revenue by Month
Channel Mix β Attended NPVs
CAC by Channel
Avg LTV by Channel
Clinic Performance β Attended NPVs vs Target
Top Movers β last 30 days
| KPI | Clinic | Current | Ξ vs prior |
|---|---|---|---|
| Attended NPV rate | Boston | 81.4% | β² 4.2 pp |
| Cost per attended NPV (Digital) | Houston | $614 | βΌ $58 |
| Physician referral inquiries | Colorado | 412 | β² 18% |
| No-show rate | Atlanta | 12.8% | β² 2.1 pp |
| Meta CPL | Northern Virginia | $87 | β² $14 |
| Google branded CTR | Minneapolis | 9.4% | β² 1.1 pp |
| Website β Lodus handoff | All | 14.6% | β² 0.8 pp |
Spend
Digital Ad Spend
$2.84M
β² 6.4% YoY
Budget: $2.95M Β· 96% pacing
Physician Referral Spend
$1.36M
β² 12.1% YoY
Budget: $1.40M Β· 97% pacing
Spend vs. Budget
96.4%
$155K under budget
All channels combined
Spend Needed to Hit NPV Target
$4.6M
β² $400K gap to target
7,200 NPV goal Β· $639/NPV historical
Spend by Channel β last 12 months
Spend vs. Budget by Clinic
Reach
Impressions
142M
β² 9.1% vs prior
Click-Through Rate (CTR)
2.18%
β² 0.21 pp vs prior
Cost per Click (CPC)
$0.92
β² $0.07 vs prior
Impressions & CTR Trend
CPC by Channel & Clinic
| Clinic | Meta CPC | Google CPC | Blended | Ξ vs prior |
|---|---|---|---|---|
| Colorado | $0.84 | $1.12 | $0.96 | β² $0.04 |
| Northern Virginia | $1.06 | $1.38 | $1.18 | β² $0.14 |
| Houston | $0.71 | $0.94 | $0.81 | βΌ $0.05 |
| Boston | $0.92 | $1.21 | $1.05 | β² $0.02 |
| Atlanta | $0.78 | $0.99 | $0.87 | βΌ $0.03 |
| Minneapolis | $0.82 | $1.04 | $0.91 | βΌ $0.01 |
Visit Volume
Total Visits
28,940
β² 7.2%
Digital Visits
11,576
β² 12.4%
Physician Referral Visits
8,973
β² 5.1%
Patient + Insurance Referrals
6,225
β² 3.8%
Unattributed / Other
2,166
β² 1.4% (investigate)
Channel Attribution Share
Visits by Channel β last 12 months
Cost Efficiency
Cost per Visit β Digital
$245
βΌ $18 vs prior
Cost per Visit β Physician
$152
βΌ $9 vs prior
Cost per Visit β Blended
$145
βΌ $11 vs prior
Attribution by Clinic (% of visits)
Scheduling Conversion
Call Center Inquiries
7,840
β² 4.3%
RingCentral
Total Appointments
11,210
β² 8.1%
Lodus + SF + RC
Inquiry β Scheduled NPV
65.3%
β² 2.1 pp
Scheduled NPVs
8,190
β² 9.4%
Scheduled vs. Target
94%
Target: 8,700
Attended Conversion
Attended NPVs
6,418
β² 6.1%
Attended NPV Rate
78.4%
β² 1.3 pp
Cancellation Rate
11.2%
βΌ 0.6 pp
No-Show Rate
10.4%
β² 0.4 pp
Full-Funnel Conversion
51.2%
β² 1.8 pp
Inquiry β Attended
Inquiry β Scheduled β Attended (trend)
Conversion Rate by Channel
Clinic Scorecard β Scheduling & Attendance
| Clinic | Inquiries | Sched NPV | Attended NPV | Sched Rate | Attended Rate | No-Show | vs Target |
|---|---|---|---|---|---|---|---|
| Colorado | 2,140 | 1,485 | 1,182 | 69.4% | 79.6% | 9.8% | 98% |
| Northern Virginia | 1,890 | 1,234 | 974 | 65.3% | 78.9% | 10.1% | 96% |
| Houston | 2,510 | 1,672 | 1,348 | 66.6% | 80.6% | 9.4% | 101% |
| Boston | 1,560 | 1,062 | 865 | 68.1% | 81.4% | 8.7% | 97% |
| Atlanta | 1,940 | 1,184 | 874 | 61.0% | 73.8% | 12.8% | 87% |
| Minneapolis | 1,500 | 1,553 | 1,175 | 75.6% | 75.7% | 11.6% | 92% |
Lifetime Value
Avg LTV β Digital
$12,400
β² 3.2%
1.4 cycles avg
Avg LTV β Physician
$18,650
β² 4.8%
1.9 cycles avg
Avg LTV β Patient Ref.
$14,820
β² 2.1%
1.6 cycles avg
Avg Time to Convert
42 days
βΌ 3 days
Inquiry β attended NPV
Return on Investment
Revenue β Digital
$33.6M
β² 11.2%
Revenue β Physician
$38.4M
β² 8.9%
Digital ROI
11.8x
β² 0.6x
Physician ROI
28.2x
β² 1.4x
CAC β Digital
$442
βΌ $24 vs prior
CAC β Physician
$152
βΌ $9 vs prior
LTV : CAC β Digital
28:1
Healthy
LTV : CAC β Physician
123:1
Healthy
Revenue Attribution by Channel
LTV vs CAC by Channel
Payor Mix
Service Mix by Acquisition Channel
Traffic Overview
Total Sessions
1.84M
β² 14.2%
Unique Visitors
1.21M
β² 13.1%
New : Returning
68 : 32
stable
Engagement Rate
54.2%
β² 2.4 pp
Avg Session Duration
2:14
β² 0:18
Sessions by Traffic Channel
Sessions Trend β Mobile vs Desktop
Conversion Actions
Schedule Page Sessions
96,420
β² 8.2%
"Request a Call" Clicks
14,210
β² 11.4%
Phone Number Clicks
28,540
β² 6.7%
Website β Lodus Handoff
14.6%
β² 0.8 pp
Top Landing Pages by Sessions
| Landing Page | Sessions | Engagement | CTA Click % |
|---|---|---|---|
| / (home) | 312,540 | 48.2% | 4.8% |
| /treatments/ivf/ | 184,210 | 62.1% | 9.2% |
| /locations/colorado/ | 98,640 | 58.4% | 11.4% |
| /treatments/egg-freezing/ | 86,210 | 64.7% | 8.6% |
| /treatments/iui/ | 54,820 | 55.3% | 6.4% |
| /locations/houston/ | 52,140 | 57.1% | 10.8% |
| /about/our-team/ | 48,720 | 51.8% | 3.2% |
| /blog/ | 42,640 | 42.6% | 1.8% |
Service Page Engagement by Treatment
Physician Form Submissions
Patient Portal & Pay-My-Bill Clicks
Top Site Search Queries
| egg freezing cost | 2,140 |
| ivf success rates | 1,820 |
| insurance coverage | 1,540 |
| locations near me | 1,210 |
| fertility consultation | 980 |
| donor egg | 820 |
Paid Media β Combined
Total Paid Media Spend
$2.84M
β² 6.4% YoY
Spend Pacing vs Budget
96.2%
On track
Total Clicks
3.09M
β² 8.4%
Blended CPL
$226
βΌ $18
Paid β Lodus Booking
3.8%
β² 0.4 pp
Spend by Platform & Month
Performance by Platform
| Platform | Spend | Clicks | CTR | CPC | CPL | Conv % |
|---|---|---|---|---|---|---|
| Meta | $1.18M | 1.42M | 1.84% | $0.83 | $254 | 3.2% |
| Google Search | $1.66M | 1.67M | 8.42% | $0.99 | $208 | 4.4% |
| Combined | $2.84M | 3.09M | 3.18% | $0.92 | $226 | 3.8% |
Meta
Meta Spend
$1.18M
β² 7.1%
Meta Impressions
78M
β² 11.2%
Meta CTR
1.84%
β² 0.18 pp
Meta CPM
$15.20
β² $0.80
Meta β Spend by Campaign
Meta β Prospecting vs Retargeting
Google
Google Spend
$1.66M
β² 5.8%
Google Impressions
64M
β² 6.4%
Google CTR
8.42%
β² 0.42 pp
Google CPC
$0.99
β² $0.06
Google β Branded vs Non-Branded
Google β Device Performance Split
Top Converting Google Search Queries (sample)
| Search Query | Type | Impressions | Clicks | CTR | CPC | Conv |
|---|---|---|---|---|---|---|
| ccrm fertility | Branded | 142,000 | 38,400 | 27.0% | $0.62 | 1,840 |
| ivf clinic near me | Non-Brand | 88,200 | 9,420 | 10.7% | $3.20 | 412 |
| egg freezing colorado | Non-Brand | 54,800 | 7,640 | 13.9% | $2.84 | 318 |
| fertility doctor houston | Non-Brand | 42,140 | 5,820 | 13.8% | $2.94 | 241 |
| ccrm reviews | Branded | 38,400 | 12,820 | 33.4% | $0.58 | 488 |
| donor egg program | Non-Brand | 28,140 | 3,420 | 12.2% | $3.42 | 142 |
π MOR view β matches the working-session outline (slide 4). Channels-as-rows, current vs. target, efficiency, and budget benchmark.
Marketing Efficiency Across Channels
Channel performance vs. target Β· last month (Apr 2026)
| Channel | Leads / Inquiries | Inquiry β Scheduled NPV | Scheduled β Attended NPV | Efficiency | Benchmark | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Current | vs Target | Current | vs Target | Current | vs Target | CAC | Margin | ROI | Spend | Budget | To hit NPV target | |
| Digital | 1,180 | β² +4% | 58.2% | βΌ β1.8 pp | 75.4% | β² +0.9 pp | $442 | 62% | 11.8x | $236K | $245K | $268K |
| Physician referral | 820 | β² +7% | 82.1% | β² +2.3 pp | 84.2% | β² +1.1 pp | $152 | 68% | 28.2x | $118K | $120K | $125K |
| Patient referral | 340 | β² +3% | 74.0% | β² +0.6 pp | 81.4% | β² +0.4 pp | $84 | 65% | 42.1x | $24K | $24K | $26K |
| Other (insurance + unattr.) | 210 | βΌ β2% | 68.0% | βΌ β1.4 pp | 77.9% | β² +0.2 pp | $98 | 60% | 34.6x | $14K | $14K | $16K |
| Total / Blended | 2,550 | β² +5% | 67.4% | β² +0.4 pp | 79.1% | β² +0.8 pp | $246 | 64% | 19.0x | $392K | $403K | $435K |
Spend Waterfall β what's needed to hit NPV target
Andy Sussman "upwards waterfall": current spend β gap to budget β gap to NPV-target spend
Key takeaways
- Physician referral is the highest-ROI channel (28.2x) and on-budget β consider increasing budget allocation.
- Digital inquiry-to-scheduled rate slipped 1.8 pp vs target β investigate call center handoff.
- $43K additional spend needed across channels to hit the monthly NPV target of 7,200.
- "Other" lead volume down 2%, mostly insurance referrals β flag for benefits team.
π MOR view β matches slide 5. By-channel: service mix, payor mix, LTV, time-to-convert.
Marketing Outcomes Across Channels
Channel outcomes Β· last month
| Channel | Service mix | Payor mix | LTV | Time to convert | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| IVF | IUI | Egg Frz | Genetic | Donor | Self-pay | Commercial | Progyny/Carrot | Avg LTV | vs Prior | Days | |
| Digital | 48% | 18% | 22% | 6% | 6% | 42% | 38% | 20% | $12,400 | β² +3.2% | 38 |
| Physician referral | 62% | 14% | 8% | 10% | 6% | 28% | 54% | 18% | $18,650 | β² +4.8% | 48 |
| Patient referral | 55% | 17% | 15% | 7% | 6% | 36% | 48% | 16% | $14,820 | β² +2.1% | 41 |
| Other | 58% | 15% | 8% | 10% | 9% | 30% | 52% | 18% | $11,200 | β flat | 46 |
| Blended | 54% | 16% | 15% | 8% | 7% | 35% | 46% | 19% | $14,820 | β² +3.5% | 42 |
LTV by channel
Time to convert (days)
Key takeaways
- Physician referrals over-index on IVF (62%) and have the highest LTV β protect this channel.
- Digital over-indexes on egg freezing (22%) and self-pay (42%) β younger demographic.
- Time to convert is fastest via digital (38 days) β useful for short-horizon NPV pulls.
- Progyny / Carrot share is consistent ~18-20% across channels β Progyny growth could lift LTV.
π MOR view β matches slide 6. Inquiry sources (Lodus, PSC, Web form) with the MOR funnel + efficiency view.
Source Mix and Efficiency
Inquiry source performance Β· last month
| Source | Leads / Inquiries | Inquiry β Scheduled NPV | Scheduled β Attended NPV | Efficiency | |||||
|---|---|---|---|---|---|---|---|---|---|
| Current | vs Target | Current | vs Target | Current | vs Target | CAC | Margin | ROI | |
| Lodus (digital booking) | 1,420 | β² +6% | 62.8% | βΌ β2.4 pp | 76.1% | β² +0.6 pp | $418 | 62% | 12.4x |
| PSC (call center) | 780 | β² +4% | 71.4% | β² +1.8 pp | 81.2% | β² +1.4 pp | $184 | 64% | 22.6x |
| Web form | 350 | β² +9% | 54.2% | βΌ β1.1 pp | 73.8% | βΌ β0.4 pp | $262 | 61% | 14.8x |
| Total | 2,550 | β² +5% | 65.3% | βΌ β1.0 pp | 78.4% | β² +0.8 pp | $246 | 64% | 19.0x |
Source share β last 12 months
Key takeaways
- Lodus drop-off flagged: inquiry-to-scheduled rate down 2.4 pp β investigate booking-link friction.
- PSC outperforms across the funnel (71% scheduled, 22.6x ROI) β call center quality is the lever.
- Web form volume up 9% but lowest scheduled rate (54%) β lead-quality vs. follow-up speed?
- Open question (slide 6): break out scheduled β attended by no-show vs. cancellation.
π MOR view β matches slide 7. Meta and Google with the full MOR funnel and benchmark.
Digital Channel Deep Dive β Meta and Google
Paid platform performance Β· last month
| Platform | Leads / Inquiries | Inquiry β Scheduled NPV | Scheduled β Attended NPV | Efficiency | Benchmark | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Current | vs Target | Current | vs Target | Current | vs Target | CAC | Margin | ROI | Spend | Budget | To hit NPV target | |
| Meta | 510 | β² +6% | 54.8% | βΌ β2.1 pp | 74.2% | β² +0.5 pp | $486 | 60% | 10.4x | $98K | $102K | $112K |
| Google Search | 670 | β² +3% | 60.6% | βΌ β1.4 pp | 76.4% | β² +1.2 pp | $412 | 64% | 13.0x | $138K | $143K | $156K |
| Digital total | 1,180 | β² +4% | 58.2% | βΌ β1.8 pp | 75.4% | β² +0.9 pp | $442 | 62% | 11.8x | $236K | $245K | $268K |
Spend efficiency β Meta vs Google
Key takeaways
- Google Search is more efficient (CAC $412 vs $486, ROI 13.0x vs 10.4x) β concentrated on bottom-funnel intent.
- Both platforms slipped vs. inquiryβscheduled targets β call center capacity may be the bottleneck.
- $32K combined additional spend needed to hit digital NPV target.
- Working-backwards waterfall (slide 7): NPV target β required attended NPVs β required leads β required clicks β required spend.
π MOR view β matches slide 8. LTV-by-channel bar chart with CAC, LTV:CAC, ROI footer.
Lifetime Value (LTV) by Channel
Key question: Which channels generate the highest LTV customers, and are we investing proportionally?
Key takeaways
- Physician referral generates 50% higher LTV than digital β driven by IVF service-mix and commercial payor mix.
- Patient referral has the best LTV:CAC (176:1) β these patients self-select for higher commitment.
- Digital ROI (11.8x) is healthy but the lowest β investment is still proportional given volume.
- Investment imbalance: digital takes 60% of spend but produces 40% of revenue β physician referral is under-invested.
Channel summary
| Channel | Avg LTV | CAC | LTV : CAC | ROI | Share of spend | Share of revenue |
|---|---|---|---|---|---|---|
| Digital | $12,400 | $442 | 28 : 1 | 11.8x | 60% | 40% |
| Physician referral | $18,650 | $152 | 123 : 1 | 28.2x | 29% | 46% |
| Patient referral | $14,820 | $84 | 176 : 1 | 42.1x | 6% | 10% |
| Other | $11,200 | $98 | 114 : 1 | 34.6x | 5% | 4% |
| Blended | $14,820 | $246 | 60 : 1 | 19.0x | 100% | 100% |