Share:

Lead Vintage — Cohort Analysis

2026-09-21 → 2026-11-22  ·  9 weeks  ·  109,011 leads  ·  3726 bookings  ·  1782 sales attributed
How to read this — Leads are bucketed by the week they arrived. Metrics only show once reliable:
< 4 days Fresh · 4–13 days Conv% ripe · 14–27 days +CPL · 28–55 days +CPB · 56+ days Matured (+ROI). Values marked * = early (dim). Attribution: (name + code) join back to lead's arrival week.
High orphan rate — 303/4029 bookings (8%) and 1201/2983 sales (40%) couldn't be matched to a lead. These likely came from leads older than 9 weeks — matured cohort accuracy may understate.
🏆 Winners by Stage
Best Conv% (1+ wk)
Boost
4.9%
booking rate, ripe cohorts
Best CPL (2+ wks)
Blue Rooms
$8.37
cheapest cost per lead
Best CPB (4+ wks)
Blue Rooms
$159
cheapest cost per booking
Best ROI (8+ wks)
Blue Rooms
+732%
fully matured cohorts only
Composite Lead Quality Score (matured cohorts · weighted ROI 50% + CPB 25% + CPL 15% + Conv% 10%)
#Source Score /100 Conv% CPL CPB Show% ROI Funnel
1 Blue Rooms 88.5 5.7% $8.19 $144 100.0% +732% 2,707 L · 154 B · 95 S · $184,650
2 Lead Pronto 64.1 3.4% $15.00 $435 100.0% +180% 1,567 L · 54 B · 30 S · $65,850
3 Alan 53.6 4.3% — — 100.0% — 4,394 L · 190 B · 122 S · $236,850
4 Boost 53.3 4.2% — — 100.0% — 552 L · 23 B · 19 S · $33,150
5 Neil 52.2 3.6% — — 100.0% — 1,521 L · 55 B · 21 S · $50,025
Cohort Matrix — Weekly × Source (metrics age-gated)
Arrival WkMaturityLead ProntoBlue RoomsBoostNeilAlan
Nov 16
0w ago
Fresh
318 leads
1 book · 0.3%*
381 leads
0 book · 0.0%*
151 leads
0 book · 0.0%*
156 leads
2 book · 1.3%*
1726 leads
0 book · 0.0%*
Nov 9
1w ago
Conv% ripe
1573 leads
29 book · 1.8%
CPL $15.00*
2773 leads
51 book · 1.8%
CPL $8.00*
800 leads
18 book · 2.3%
CPL —*
1098 leads
19 book · 1.7%
CPL —*
9755 leads
115 book · 1.2%
CPL —*
Nov 2
2w ago
+ CPL
1496 leads
61 book · 4.1%
CPL $15.00
CPB $368*
3800 leads
102 book · 2.7%
CPL $7.75
CPB $289*
637 leads
24 book · 3.8%
CPL —
CPB —*
1826 leads
31 book · 1.7%
CPL —
CPB —*
9004 leads
281 book · 3.1%
CPL —
CPB —*
Oct 26
3w ago
+ CPL
1300 leads
49 book · 3.8%
CPL $15.00
CPB $398*
2350 leads
132 book · 5.6%
CPL $7.94
CPB $141*
603 leads
34 book · 5.6%
CPL —
CPB —*
1647 leads
35 book · 2.1%
CPL —
CPB —*
8419 leads
289 book · 3.4%
CPL —
CPB —*
Oct 19
4w ago
+ CPB
1269 leads
53 book · 4.2%
CPL $15.00
CPB $359
17 sold · ROI +70%*
1839 leads
107 book · 5.8%
CPL $8.49
CPB $146
63 sold · ROI +1025%*
850 leads
45 book · 5.3%
CPL —
CPB —
28 sold · ROI —*
1951 leads
39 book · 2.0%
CPL —
CPB —
15 sold · ROI —*
6547 leads
232 book · 3.5%
CPL —
CPB —
129 sold · ROI —*
Oct 12
5w ago
+ CPB
1415 leads
60 book · 4.2%
CPL $15.00
CPB $354
34 sold · ROI +144%*
1992 leads
106 book · 5.3%
CPL $8.91
CPB $167
63 sold · ROI +563%*
681 leads
40 book · 5.9%
CPL —
CPB —
29 sold · ROI —*
3058 leads
90 book · 2.9%
CPL —
CPB —
38 sold · ROI —*
5644 leads
218 book · 3.9%
CPL —
CPB —
127 sold · ROI —*
Oct 5
6w ago
+ CPB
1502 leads
50 book · 3.3%
CPL $15.00
CPB $451
26 sold · ROI +137%*
2186 leads
123 book · 5.6%
CPL $8.93
CPB $159
68 sold · ROI +669%*
500 leads
38 book · 7.6%
CPL —
CPB —
27 sold · ROI —*
3566 leads
104 book · 2.9%
CPL —
CPB —
44 sold · ROI —*
4053 leads
183 book · 4.5%
CPL —
CPB —
121 sold · ROI —*
Sep 28
7w ago
+ CPB
1489 leads
64 book · 4.3%
CPL $15.00
CPB $349
39 sold · ROI +249%*
2438 leads
121 book · 5.0%
CPL $8.94
CPB $180
76 sold · ROI +493%*
558 leads
34 book · 6.1%
CPL —
CPB —
18 sold · ROI —*
3022 leads
90 book · 3.0%
CPL —
CPB —
48 sold · ROI —*
3897 leads
180 book · 4.6%
CPL —
CPB —
128 sold · ROI —*
Sep 21
8w ago
Matured (ROI)
1567 leads
54 book · 3.4%
CPL $15.00
CPB $435
30 sold · ROI +180%
2707 leads
154 book · 5.7%
CPL $8.19
CPB $144
95 sold · ROI +732%
552 leads
23 book · 4.2%
CPL —
CPB —
19 sold · ROI —
1521 leads
55 book · 3.6%
CPL —
CPB —
21 sold · ROI —
4394 leads
190 book · 4.3%
CPL —
CPB —
122 sold · ROI —
Each cell: leads · booked/conv · CPL · CPB · sold/ROI — only metrics ripe at that age. * = early indicator.
Source Deep Dive — Full Funnel per Weekly Cohort
Lead Pronto — 11,929 leads · 421 booked · 191 sold · $347,010 revenue +94% all-time ROI
Cohort Stage Leads CPL Spend Booked Conv% CPB Showed Show% Sold Sales $ Avg Deal ROI
Nov 16 0w Fresh 318 $15.00 $4,770 1 0.3% $4,770 1 100.0% 1 $3,500 $3,500 -27%
Nov 9 1w Conv% ripe 1573 $15.00 $23,595 29 1.8% $814 29 100.0% 3 $4,550 $1,517 -81%
Nov 2 2w + CPL 1496 $15.00 $22,440 61 4.1% $368 61 100.0% 18 $24,149 $1,342 +8%
Oct 26 3w + CPL 1300 $15.00 $19,500 49 3.8% $398 49 100.0% 23 $33,750 $1,467 +73%
Oct 19 4w + CPB 1269 $15.00 $19,035 53 4.2% $359 53 100.0% 17 $32,272 $1,898 +70%
Oct 12 5w + CPB 1415 $15.00 $21,225 60 4.2% $354 60 100.0% 34 $51,689 $1,520 +144%
Oct 5 6w + CPB 1502 $15.00 $22,530 50 3.3% $451 50 100.0% 26 $53,400 $2,054 +137%
Sep 28 7w + CPB 1489 $15.00 $22,335 64 4.3% $349 64 100.0% 39 $77,850 $1,996 +249%
Sep 21 8w Matured (ROI) 1567 $15.00 $23,505 54 3.4% $435 54 100.0% 30 $65,850 $2,195 +180%
All Cohorts (Lead Pronto) 11,929 $15.00 $178,935 421 3.5% $425 421 100.0% 191 $347,010 $1,817 +94%
Blue Rooms — 20,466 leads · 896 booked · 445 sold · $890,932 revenue +425% all-time ROI
Cohort Stage Leads CPL Spend Booked Conv% CPB Showed Show% Sold Sales $ Avg Deal ROI
Nov 16 0w Fresh 381 $7.07 $2,692 — — — — — — — — -100%
Nov 9 1w Conv% ripe 2773 $8.00 $22,176 51 1.8% $435 51 100.0% 6 $12,150 $2,025 -45%
Nov 2 2w + CPL 3800 $7.75 $29,444 102 2.7% $289 102 100.0% 19 $35,400 $1,863 +20%
Oct 26 3w + CPL 2350 $7.94 $18,654 132 5.6% $141 132 100.0% 55 $86,098 $1,565 +362%
Oct 19 4w + CPB 1839 $8.49 $15,620 107 5.8% $146 107 100.0% 63 $175,675 $2,788 +1025%
Oct 12 5w + CPB 1992 $8.91 $17,739 106 5.3% $167 106 100.0% 63 $117,577 $1,866 +563%
Oct 5 6w + CPB 2186 $8.93 $19,517 123 5.6% $159 123 100.0% 68 $150,132 $2,208 +669%
Sep 28 7w + CPB 2438 $8.94 $21,788 121 5.0% $180 121 100.0% 76 $129,250 $1,701 +493%
Sep 21 8w Matured (ROI) 2707 $8.19 $22,183 154 5.7% $144 154 100.0% 95 $184,650 $1,944 +732%
All Cohorts (Blue Rooms) 20,466 $8.30 $169,812 896 4.4% $190 896 100.0% 445 $890,932 $2,002 +425%
Boost — 5,332 leads · 256 booked · 152 sold · $266,450 revenue — all-time ROI
Cohort Stage Leads CPL Spend Booked Conv% CPB Showed Show% Sold Sales $ Avg Deal ROI
Nov 16 0w Fresh 151 — — — — — — — — — — —
Nov 9 1w Conv% ripe 800 — — 18 2.3% — 18 100.0% 1 — — —
Nov 2 2w + CPL 637 — — 24 3.8% — 24 100.0% 8 $13,750 $1,719 —
Oct 26 3w + CPL 603 — — 34 5.6% — 34 100.0% 22 $38,050 $1,730 —
Oct 19 4w + CPB 850 — — 45 5.3% — 45 100.0% 28 $48,600 $1,736 —
Oct 12 5w + CPB 681 — — 40 5.9% — 40 100.0% 29 $53,550 $1,847 —
Oct 5 6w + CPB 500 — — 38 7.6% — 38 100.0% 27 $50,250 $1,861 —
Sep 28 7w + CPB 558 — — 34 6.1% — 34 100.0% 18 $29,100 $1,617 —
Sep 21 8w Matured (ROI) 552 — — 23 4.2% — 23 100.0% 19 $33,150 $1,745 —
All Cohorts (Boost) 5,332 — — 256 4.8% — 256 100.0% 152 $266,450 $1,753 —
Neil — 17,845 leads · 465 booked · 185 sold · $357,784 revenue — all-time ROI
Cohort Stage Leads CPL Spend Booked Conv% CPB Showed Show% Sold Sales $ Avg Deal ROI
Nov 16 0w Fresh 156 — — 2 1.3% — 2 100.0% — — — —
Nov 9 1w Conv% ripe 1098 — — 19 1.7% — 19 100.0% — — — —
Nov 2 2w + CPL 1826 — — 31 1.7% — 31 100.0% 6 $9,225 $1,538 —
Oct 26 3w + CPL 1647 — — 35 2.1% — 35 100.0% 13 $28,225 $2,171 —
Oct 19 4w + CPB 1951 — — 39 2.0% — 39 100.0% 15 $27,475 $1,832 —
Oct 12 5w + CPB 3058 — — 90 2.9% — 90 100.0% 38 $53,134 $1,398 —
Oct 5 6w + CPB 3566 — — 104 2.9% — 104 100.0% 44 $66,925 $1,521 —
Sep 28 7w + CPB 3022 — — 90 3.0% — 90 100.0% 48 $122,775 $2,558 —
Sep 21 8w Matured (ROI) 1521 — — 55 3.6% — 55 100.0% 21 $50,025 $2,382 —
All Cohorts (Neil) 17,845 — — 465 2.6% — 465 100.0% 185 $357,784 $1,934 —
Alan — 53,439 leads · 1688 booked · 809 sold · $1,433,872 revenue — all-time ROI
Cohort Stage Leads CPL Spend Booked Conv% CPB Showed Show% Sold Sales $ Avg Deal ROI
Nov 16 0w Fresh 1726 — — — — — — — — — — —
Nov 9 1w Conv% ripe 9755 — — 115 1.2% — 115 100.0% 11 $23,150 $2,105 —
Nov 2 2w + CPL 9004 — — 281 3.1% — 281 100.0% 53 $82,411 $1,555 —
Oct 26 3w + CPL 8419 — — 289 3.4% — 289 100.0% 118 $202,714 $1,718 —
Oct 19 4w + CPB 6547 — — 232 3.5% — 232 100.0% 129 $212,525 $1,647 —
Oct 12 5w + CPB 5644 — — 218 3.9% — 218 100.0% 127 $220,471 $1,736 —
Oct 5 6w + CPB 4053 — — 183 4.5% — 183 100.0% 121 $223,119 $1,844 —
Sep 28 7w + CPB 3897 — — 180 4.6% — 180 100.0% 128 $232,632 $1,817 —
Sep 21 8w Matured (ROI) 4394 — — 190 4.3% — 190 100.0% 122 $236,850 $1,941 —
All Cohorts (Alan) 53,439 — — 1688 3.2% — 1688 100.0% 809 $1,433,872 $1,772 —
City × Source Matured Matrix (CPB-ripe+ cohorts only)
Source Metric BostonDallasHoustonNew YorkChicagoNashvilleFlorida
Lead Pronto Leads 7366326576011,1858252,606
CPL $15.00$15.00$15.00$15.00$15.00$15.00$15.00
Conv% 4.1%3.5%4.3%2.5%4.3%6.2%3.2%
CPB $368$431$352$601$349$243$465
ROI +128%-14%+311%+23%+217%+369%+109%
Blue Rooms Leads 9521,4831,4641,5811,2888012,765
CPL $7.52$7.52$7.52$7.52$7.52$7.52$7.52
Conv% 7.1%6.7%4.2%5.5%5.5%5.6%4.6%
CPB $105$113$178$137$136$134$165
ROI +1024%+1042%+873%+613%+1075%+1119%+537%
Boost Leads 283688437626273209625
CPL ———————
Conv% 6.7%5.7%3.4%6.2%4.8%9.1%5.8%
CPB ———————
ROI ———————
Neil Leads 1,2641,4831,8472,7041,8361,2042,780
CPL ———————
Conv% 3.6%2.9%2.6%3.3%2.8%3.5%2.2%
CPB ———————
ROI ———————
Alan Leads 2,3252,8252,7893,9133,8861,5666,223
CPL ———————
Conv% 5.0%4.6%4.1%3.6%3.6%4.5%4.1%
CPB ———————
ROI ———————
Top 40 Campaign Codes (all cohorts · ≥10 leads)
CodeSourceCity Leads CPL Spend Book Conv% CPB Show Show% Sold Sales $ ROI
#NYKIDSX Blue Rooms New York 4,659 $5.00 $23,295 150 3.2% $155 150 100.0% 61 $116,919 +402%
#ORL1FX Alan Florida 4,300 — — 108 2.5% — 108 100.0% 58 $113,350 —
#CHI1FX Alan Chicago 4,062 — — 138 3.4% — 138 100.0% 71 $119,649 —
#FLKIDSX Blue Rooms Florida 4,036 $4.72 $19,050 163 4.0% $117 163 100.0% 84 $146,949 +671%
#FL1FX Alan Florida 3,144 — — 111 3.5% — 111 100.0% 47 $84,099 —
#NY1FX Alan New York 3,140 — — 124 3.9% — 124 100.0% 66 $95,850 —
#DAL1FX Alan Dallas 3,012 — — 131 4.3% — 131 100.0% 72 $121,400 —
#BOS1FX Alan Boston 2,969 — — 141 4.7% — 141 100.0% 63 $111,496 —
#ORLP2 Lead Pronto Florida 2,863 $15.00 $42,945 68 2.4% $632 68 100.0% 32 $68,400 +59%
#ATKIDSX Blue Rooms Unknown 2,798 $7.52 $21,041 102 3.6% $206 102 100.0% 29 $55,282 +163%
#HOU1FX Alan Houston 2,777 — — 123 4.4% — 123 100.0% 64 $143,575 —
#FL3AB Alan Florida 2,602 — — 17 0.7% — 17 100.0% 8 $10,250 —
#NYKIDSXP Alan New York 2,194 — — 92 4.2% — 92 100.0% 27 $54,688 —
#DALKIDSX Blue Rooms Dallas 2,096 $14.83 $31,084 133 6.3% $234 133 100.0% 80 $151,100 +386%
#HOUKIDSX Blue Rooms Houston 2,070 $5.43 $11,240 80 3.9% $141 80 100.0% 44 $111,075 +888%
#CHIKIDSX Blue Rooms Chicago 2,000 $8.62 $17,240 101 5.1% $171 101 100.0% 66 $126,895 +636%
#CHILP2 Lead Pronto Chicago 1,941 $15.00 $29,115 83 4.3% $351 83 100.0% 39 $69,031 +137%
#NY3AB Alan New York 1,749 — — 6 0.3% — 6 100.0% 3 $1,775 —
#BOSKIDSX Blue Rooms Boston 1,741 $18.51 $32,226 103 5.9% $313 103 100.0% 49 $96,862 +201%
#NY6AB Neil New York 1,539 — — 42 2.7% — 42 100.0% 12 $22,775 —
#NALP2 Lead Pronto Nashville 1,468 $15.00 $22,020 82 5.6% $269 82 100.0% 46 $73,550 +234%
#NA1FX Alan Nashville 1,452 — — 70 4.8% — 70 100.0% 39 $67,550 —
#FLKIDSXP Alan Florida 1,375 — — 57 4.1% — 57 100.0% 17 $16,550 —
#CHI3AB Alan Chicago 1,322 — — 8 0.6% — 8 100.0% 4 $7,025 —
#BOSLP2 Lead Pronto Boston 1,210 $15.00 $18,150 43 3.6% $422 43 100.0% 18 $27,190 +50%
#FLP2 Lead Pronto Florida 1,192 $15.00 $17,880 41 3.4% $436 41 100.0% 11 $21,000 +17%
#CHIKIDSXP Alan Chicago 1,172 — — 49 4.2% — 49 100.0% 21 $33,750 —
#HOU3AB Alan Houston 1,158 — — 13 1.1% — 13 100.0% 5 $13,225 —
#DAL3AB Alan Dallas 1,121 — — 7 0.6% — 7 100.0% 2 $8,000 —
#NAKIDSX Blue Rooms Nashville 1,066 $13.73 $14,636 64 6.0% $229 64 100.0% 32 $85,850 +487%
#HOU6AB Neil Houston 1,029 — — 18 1.7% — 18 100.0% 4 $5,850 —
#FL6AB Neil Florida 1,006 — — 15 1.5% — 15 100.0% 7 $19,050 —
#DALP2 Lead Pronto Dallas 1,004 $15.00 $15,060 32 3.2% $471 32 100.0% 12 $19,900 +32%
#NYN1N Neil New York 991 — — 19 1.9% — 19 100.0% 8 $9,175 —
#CHI6AB Neil Chicago 973 — — 17 1.7% — 17 100.0% 8 $10,400 —
#AT1FX Alan Unknown 882 — — 9 1.0% — 9 100.0% 3 $5,620 —
#HOULP2 Lead Pronto Houston 876 $15.00 $13,140 35 4.0% $375 35 100.0% 19 $43,800 +233%
#DAL6AB Neil Dallas 838 — — 12 1.4% — 12 100.0% 4 $8,560 —
#CHIN1N Neil Chicago 801 — — 12 1.5% — 12 100.0% 7 $9,549 —
#ATKIDSXP Alan Unknown 801 — — 27 3.4% — 27 100.0% 6 $15,500 —
Time to Book — Days from Lead In → Appointment Date
Source Bookings Mean P25 Median P75 Max
Lead Pronto 421 5.0d 2d 3d 6d 38d
Blue Rooms 896 5.8d 2d 3d 7d 36d
Boost 256 4.3d 2d 3d 5d 28d
Neil 465 5.1d 1d 3d 7d 39d
Alan 1688 5.5d 2d 4d 7d 38d
Outliers over 120 days filtered. Median is usually the most reliable (not skewed by late conversions).
Diagnostics
Leads pulled
109,011
9 weeks
Bookings attribution
92.5%
3,726 of 4,029 linked to a lead
Sales attribution
59.7%
1,782 of 2,983 linked to a lead
No-shows pulled
2,686
used for show-rate calc
Attribution method: booking/sale joined to lead via normalized (name + marketing code). Name normalised = lowercase, trim, collapse spaces. Code normalised = upper, strip leading #, strip trailing R (recycled variant).
Spend source: lead_costs.json perCode × leads (priority) OR perSource × leads (fallback). CRM ROI feed is empty since Mar 9 (server-side issue) — see main leads report for detail.
Orphaned records: likely from leads older than the 9-week pull window. Older cohort metrics understate as a result.