Lead → Show → Revenue (full ROI)

4-Group Comparison — Blue Rooms KIDS vs Other vs all other leads vs Recycled (selected range) · $ = Blue Rooms only here (Lead Pronto cost shows on the By-Supplier, Per-City & Codes tabs)

Group	Leads	Booked	Book %	Showed	Show %	Lead→Show %	Spend $	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
Blue Rooms KIDS	26,625	1,742	6.5%	830	47.6%	3.1%	$229,059	$10.11	$276	$1,743,547	$2,101	7.6x
Blue Rooms Other	15,170	860	5.7%	349	40.6%	2.3%	$139,379	$11.31	$399	$632,942	$1,814	4.5x
All other leads	29,470	1,543	5.2%	652	42.3%	2.2%	$498,725	$14.83	$765	$1,173,555	$1,800	2.4x
Recycled	19,464	596	3.1%	182	30.5%	0.9%	$19,464	$1.00	$107	$318,111	$1,748	16.3x

“All other leads” = every non-Blue-Rooms source combined (Alan, Lead Pronto, Organic, …), excluding recycled. “Recycled” = the re-marketed 5AB / 6AB / CMN / N1N leads, shown on its own. Same maturity caveat applies — pick a settled range for true show rates.

Maturity read

Windowwindows trail from your end date · longest = most settled · show reads low until appointments happen — and revenue lags even further (sale + payment come after the show)	Leads	Booked	Book %	Showed	Show %	Lead→Show %	$ Sold	Rev/Show $
8 weeks settled	90,729	4,741	5.2%	2,013	42.5%	2.2%	$3,868,155	$1,922
6 weeks	69,072	3,396	4.9%	1,310	38.6%	1.9%	$2,502,432	$1,910
4 weeks	46,166	1,996	4.3%	641	32.1%	1.4%	$1,180,705	$1,842
2 weeks maturing	23,982	636	2.7%	88	13.8%	0.4%	$175,539	$1,995
1 week maturing	12,599	155	1.2%	10	6.5%	0.1%	$21,550	$2,155

Lead→Show % by Supplier

Supplier8 wk = settled/true rate · shorter cols = recent direction	8 wk ✓	6 wk	4 wk	2 wk	1 wk
Blue Rooms KIDS	3.1%	2.6%	1.8%	0.5%	0.1%
Lead Pronto	2.3%	1.9%	1.3%	0.3%	0.1%
Blue Rooms Other	2.3%	2.0%	1.4%	0.3%	0.0%
Alan	2.2%	2.0%	1.6%	0.5%	0.2%
Organic	1.9%	1.1%	0.8%	0.5%	1.3%
Neil	0.9%	0.8%	0.6%	0.2%	0.0%

Lead→Show % by City

City8 wk = settled/true rate · shorter cols = recent	8 wk ✓	6 wk	4 wk	2 wk	1 wk
Dallas	2.5%	2.2%	1.8%	0.3%	0.1%
Boston	2.4%	2.1%	1.5%	0.4%	0.0%
Houston	2.3%	1.9%	1.4%	0.5%	0.0%
Florida	2.3%	1.8%	1.3%	0.3%	0.1%
Nashville	2.2%	1.8%	1.5%	0.6%	0.3%
New York	1.9%	1.7%	1.0%	0.2%	0.0%
Chicago	1.9%	1.9%	1.4%	0.3%	0.0%

Book % by Supplier

Supplier8 wk = settled · booking matures fast, mostly set by ~3 weeks	8 wk ✓	6 wk	4 wk	2 wk	1 wk
Blue Rooms KIDS	6.5%	6.0%	5.1%	3.2%	1.6%
Lead Pronto	5.3%	4.6%	4.0%	2.2%	0.9%
Blue Rooms Other	5.7%	5.3%	4.4%	2.5%	1.0%
Alan	5.3%	5.4%	5.1%	3.4%	1.6%
Organic	3.9%	3.2%	3.5%	2.5%	2.5%
Neil	3.1%	2.8%	2.7%	1.7%	0.8%

Book % by City

City8 wk = settled	8 wk ✓	6 wk	4 wk	2 wk	1 wk
Dallas	5.4%	5.1%	4.8%	3.1%	1.3%
Boston	5.9%	5.7%	5.3%	3.2%	1.6%
Houston	5.0%	4.7%	4.3%	3.1%	1.6%
Florida	5.3%	4.8%	4.0%	2.2%	1.1%
Nashville	5.8%	5.3%	4.5%	2.8%	1.5%
New York	5.0%	4.7%	4.0%	2.5%	0.9%
Chicago	4.5%	4.6%	4.1%	2.4%	0.8%

By Supplier

Supplierselected range · ranked by Lead→Show% · cost = Blue Rooms/Lead Pronto/Alan/Recycled/Organic (Recycled+Organic $1/lead; Boost removed) · revenue ($ Sold / Rev-per-Show / ROAS) from CRM ROI feed	Leads	Booked	Book %	Showed	Show %	Lead→Show %	Spend $	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
Blue Rooms KIDS	26,625	1,742	6.5%	830	47.6%	3.1%	$229,059	$10.11	$276	$1,743,547	$2,101	7.6x
Lead Pronto	10,646	560	5.3%	247	44.1%	2.3%	$138,718	$13.03	$562	$448,181	$1,814	3.2x
Blue Rooms Other	15,170	860	5.7%	349	40.6%	2.3%	$139,379	$11.31	$399	$632,942	$1,814	4.5x
Alan	17,918	948	5.3%	388	40.9%	2.2%	$359,101	$16.27	$926	$679,724	$1,752	1.9x
Organic	906	35	3.9%	17	48.6%	1.9%	$906	$1.00	$53.29	$45,650	$2,685	50.4x
Neil	19,464	596	3.1%	182	30.5%	0.9%	$19,464	$1.00	$107	$318,111	$1,748	16.3x

By City

Cityselected range · ranked by Lead→Show% · $ Sold = revenue per city; cost is per-supplier (see Per-City tab)	Leads	Booked	Book %	Showed	Show %	Lead→Show %	$ Sold	Rev/Show $
Dallas	11,267	614	5.4%	287	46.7%	2.5%	$489,799	$1,707
Boston	8,677	509	5.9%	209	41.1%	2.4%	$389,018	$1,861
Houston	11,918	591	5.0%	273	46.2%	2.3%	$554,825	$2,032
Florida	26,570	1,398	5.3%	598	42.8%	2.3%	$1,291,829	$2,160
Nashville	8,384	484	5.8%	182	37.6%	2.2%	$316,375	$1,738
New York	11,626	586	5.0%	226	38.6%	1.9%	$432,413	$1,913
Chicago	12,287	559	4.5%	238	42.6%	1.9%	$393,896	$1,655

Per-City Leaderboards — each city's lead types ranked by Lead→Show% (cities ranked separately)

Dallas 11,267 leads · 5 lead types · city Lead→Show 2.5%

Lead type	Leads	Book %	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
Blue Rooms KIDS	1,775	8.3%	53.4%	4.5%	$9.60	$173	$151,099	$1,913	11.1x
Blue Rooms Other	1,827	7.8%	50.0%	3.9%	$7.36	$157	$95,600	$1,346	8.6x
Alan	3,742	6.0%	46.0%	2.8%	$14.21	$670	$201,650	$1,958	2.9x
Lead Pronto	1,317	4.0%	28.3%	1.1%	$11.35	$997	$18,050	$1,203	1.2x
Neil	2,606	1.8%	40.4%	0.7%	$1.00	$137	$23,400	$1,232	9.0x

Boston 8,677 leads · 6 lead types · city Lead→Show 2.4%

Lead type	Leads	Book %	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
Blue Rooms KIDS	2,547	7.4%	45.2%	3.3%	$18.78	$499	$171,552	$2,018	4.0x
Lead Pronto	1,488	7.1%	44.8%	3.2%	$17.91	$567	$95,196	$2,025	3.6x
Blue Rooms Other	1,067	6.0%	32.8%	2.0%	$16.54	$633	$44,300	$2,110	3.3x
Alan	1,866	5.3%	36.4%	1.9%	$17.48	$1,009	$46,770	$1,299	1.3x
Neil	1,609	3.2%	37.3%	1.2%	$1.00	$84.68	$29,200	$1,537	18.1x
Organic	100	2.0%	50.0%	1.0%	$1.00	$100	$2,000	$2,000	20.0x

Houston 11,918 leads · 5 lead types · city Lead→Show 2.3%

Lead type	Leads	Book %	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
Blue Rooms KIDS	3,779	6.8%	53.1%	3.6%	$7.92	$186	$311,575	$2,274	12.2x
Lead Pronto	1,351	4.6%	53.2%	2.4%	$12.63	$517	$69,525	$2,107	4.1x
Alan	2,844	4.7%	41.8%	2.0%	$19.14	$1,267	$99,375	$1,775	1.4x
Blue Rooms Other	1,460	4.5%	39.4%	1.8%	$13.33	$592	$44,100	$1,696	2.9x
Neil	2,484	2.9%	29.6%	0.8%	$1.00	$118	$30,250	$1,440	12.2x

Florida 26,570 leads · 6 lead types · city Lead→Show 2.3%

Lead type	Leads	Book %	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
Blue Rooms KIDS	9,188	6.4%	46.3%	3.0%	$6.42	$186	$620,765	$2,266	12.2x
Blue Rooms Other	4,941	5.8%	42.8%	2.5%	$11.12	$378	$250,192	$2,051	5.4x
Lead Pronto	3,319	4.5%	47.3%	2.1%	$11.23	$525	$142,810	$2,011	3.8x
Organic	788	4.2%	48.5%	2.0%	$1.00	$49.25	$43,650	$2,728	55.4x
Alan	4,036	5.3%	37.3%	2.0%	$16.40	$974	$150,150	$1,901	2.0x
Neil	4,298	2.9%	28.6%	0.8%	$1.00	$119	$84,262	$2,341	19.6x

Nashville 8,384 leads · 5 lead types · city Lead→Show 2.2%

Lead type	Leads	Book %	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
Lead Pronto	1,432	7.8%	36.6%	2.9%	$18.03	$630	$57,350	$1,399	2.2x
Blue Rooms KIDS	1,996	7.2%	39.6%	2.9%	$21.70	$634	$106,375	$1,866	2.9x
Alan	1,812	6.2%	40.7%	2.5%	$15.74	$719	$72,700	$1,580	2.2x
Blue Rooms Other	1,252	4.6%	40.4%	1.8%	$15.27	$594	$54,350	$2,363	4.0x
Neil	1,892	3.1%	25.9%	0.8%	$1.00	$126	$25,600	$1,707	13.5x

New York 11,626 leads · 5 lead types · city Lead→Show 1.9%

Lead type	Leads	Book %	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
Blue Rooms KIDS	4,707	6.2%	47.3%	3.0%	$8.31	$244	$265,099	$1,907	7.8x
Lead Pronto	292	3.8%	45.5%	1.7%	$7.81	$456	$12,100	$2,420	5.3x
Alan	898	3.7%	42.4%	1.6%	$8.25	$922	$28,489	$2,035	2.2x
Neil	3,537	4.4%	27.1%	1.2%	$1.00	$84.21	$82,125	$1,955	23.2x
Blue Rooms Other	2,192	4.2%	28.0%	1.2%	$9.03	$634	$44,600	$1,715	2.7x

Chicago 12,287 leads · 6 lead types · city Lead→Show 1.9%

Lead type	Leads	Book %	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
Blue Rooms Other	2,431	6.3%	39.2%	2.5%	$11.78	$387	$99,800	$1,663	4.3x
Lead Pronto	1,447	4.6%	52.2%	2.4%	$10.16	$420	$53,150	$1,519	3.6x
Blue Rooms KIDS	2,633	4.5%	50.0%	2.2%	$12.79	$447	$117,082	$1,984	4.4x
Alan	2,720	4.9%	40.6%	2.0%	$19.49	$1,109	$80,590	$1,492	1.3x
Neil	3,038	2.9%	34.1%	1.0%	$1.00	$101	$43,274	$1,442	14.2x
Organic low vol	18	0.0%	—	0.0%	$1.00	—	—	—	—

Codes by City — every marketing code, grouped under its city (volume-first; recycled …R folded into parent)

Dallas 31 codes · 11,267 leads · city Lead→Show 2.5%

Code	Supplier	Leads	Booked	Book %	Showed	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
#DAL6AB	Neil	1,387	26	1.9%	8	30.8%	0.6%	$1.00	$173	$7,950	$994	5.7x
#DALP2	Lead Pronto	1,317	53	4.0%	15	28.3%	1.1%	$11.35	$997	$18,050	$1,203	1.2x
#DALKIDSX	Blue Rooms KIDS	1,264	132	10.4%	72	54.5%	5.7%	$10.66	$164	$133,549	$1,855	11.3x
#DAL3CX1F	Alan	1,175	67	5.7%	30	44.8%	2.6%	$14.21	$557	$71,550	$2,385	4.3x
#DAL1FX	Blue Rooms Other	854	96	11.2%	53	55.2%	6.2%	$11.57	$159	$72,750	$1,373	8.6x
#DALN1N	Neil	618	11	1.8%	6	54.5%	1.0%	$1.00	$103	$5,400	$900	8.7x
#DALSNAP	Blue Rooms Other	558	36	6.5%	14	38.9%	2.5%	$4.30	$157	$17,800	$1,271	8.1x
#DALKX	Blue Rooms KIDS	511	16	3.1%	7	43.8%	1.4%	$5.86	$262	$17,550	$2,507	9.6x
#DAL3CX1M	Alan	505	46	9.1%	27	58.7%	5.3%	$14.21	$266	$57,050	$2,113	7.9x
#DAL5AB	Neil	442	3	0.7%	2	66.7%	0.5%	$1.00	$221	$4,000	$2,000	9.0x
#DALGX	Blue Rooms Other	415	10	2.4%	4	40.0%	1.0%	$1.89	$131	$5,050	$1,263	9.7x
#DAL3DE1F	Alan	247	25	10.1%	13	52.0%	5.3%	$14.21	$270	$26,050	$2,004	7.4x
#DAL3DE1M	Alan	223	20	9.0%	9	45.0%	4.0%	$14.21	$352	$9,600	$1,067	3.0x
#DAL3DE2F	Alan	202	11	5.4%	6	54.5%	3.0%	$14.21	$478	$8,600	$1,433	3.0x
#DALFB31M	Alan	190	4	2.1%	1	25.0%	0.5%	$14.21	$2,700	$100	$100	0.0x
#DAL3CX3F	Alan	166	2	1.2%	0	0.0%	0.0%	$14.21	—	—	—	—
#DALCMN	Neil	159	7	4.4%	3	42.9%	1.9%	$1.00	$53.00	$6,050	$2,017	38.1x
#DAL3DE3F	Alan	157	8	5.1%	5	62.5%	3.2%	$14.21	$446	$5,650	$1,130	2.5x
#DALFB33F	Alan	147	3	2.0%	1	33.3%	0.7%	$14.21	$2,089	$4,000	$4,000	1.9x
#DALFB31F	Alan	141	9	6.4%	3	33.3%	2.1%	$14.21	$668	$6,400	$2,133	3.2x
#DAL3CX3M	Alan	85	2	2.4%	0	0.0%	0.0%	$14.21	—	—	—	—
#DAL3CX2F	Alan	83	4	4.8%	1	25.0%	1.2%	$14.21	$1,180	$1,500	$1,500	1.3x
#DAL3DE2M	Alan	77	8	10.4%	5	62.5%	6.5%	$14.21	$219	$8,100	$1,620	7.4x
#DALFB32F	Alan	65	2	3.1%	0	0.0%	0.0%	$14.21	—	—	—	—
#DALFB32M	Alan	61	0	0.0%	0	—	0.0%	$14.21	—	—	—	—
#DAL3CX2M	Alan	58	5	8.6%	1	20.0%	1.7%	$14.21	$824	$50.00	$50.00	0.1x
#DAL3DE3M	Alan	57	2	3.5%	0	0.0%	0.0%	$14.21	—	—	—	—
#DAL3DE	Alan	53	2	3.8%	0	0.0%	0.0%	$14.21	—	—	—	—
#DALFB33M	Alan	42	4	9.5%	1	25.0%	2.4%	$14.21	$597	$3,000	$3,000	5.0x
#DAL4AB	Alan	7	0	0.0%	0	—	0.0%	$14.21	—	—	—	—
#DALKIDS	Alan	1	0	0.0%	0	—	0.0%	$14.21	—	—	—	—

Boston 34 codes · 8,677 leads · city Lead→Show 2.4%

Code	Supplier	Leads	Booked	Book %	Showed	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
#BOSKIDSX	Blue Rooms KIDS	2,200	162	7.4%	77	47.5%	3.5%	$17.15	$444	$159,002	$2,065	4.7x
#BOSLP2	Lead Pronto	1,487	105	7.1%	47	44.8%	3.2%	$17.91	$567	$95,196	$2,025	3.6x
#BOS6AB	Neil	822	22	2.7%	3	13.6%	0.4%	$1.00	$274	$6,000	$2,000	7.3x
#BO3CX1F	Alan	424	36	8.5%	13	36.1%	3.1%	$17.48	$570	$11,900	$915	1.6x
#BOSN1N	Neil	411	8	1.9%	5	62.5%	1.2%	$1.00	$82.20	$6,000	$1,200	14.6x
#BOSGX	Blue Rooms Other	388	9	2.3%	4	44.4%	1.0%	$19.32	$990	$5,550	$1,388	1.4x
#BOSKX	Blue Rooms KIDS	347	26	7.5%	8	30.8%	2.3%	$31.05	$1,025	$12,550	$1,569	1.5x
#BOSSNAP	Blue Rooms Other	346	27	7.8%	7	25.9%	2.0%	$19.48	$840	$19,050	$2,721	3.2x
#BOS1FX	Blue Rooms Other	333	28	8.4%	10	35.7%	3.0%	$11.62	$345	$19,700	$1,970	5.7x
#BOS5AB	Neil	251	10	4.0%	4	40.0%	1.6%	$1.00	$62.75	$6,500	$1,625	25.9x
#BOIG23F	Alan	231	6	2.6%	1	16.7%	0.4%	$17.48	$4,037	$250	$250	0.1x
#BO3CX1M	Alan	194	17	8.8%	6	35.3%	3.1%	$17.48	$565	$3,600	$600	1.1x
#BOIG22F	Alan	161	3	1.9%	1	33.3%	0.6%	$17.48	$2,814	$720	$720	0.3x
#BOIG21F	Alan	127	9	7.1%	3	33.3%	2.4%	$17.48	$740	$6,050	$2,017	2.7x
#BOSCMN	Neil	125	11	8.8%	7	63.6%	5.6%	$1.00	$17.86	$10,700	$1,529	85.6x
#BOIG23M	Alan	111	0	0.0%	0	—	0.0%	$17.48	—	—	—	—
#BO3CX3F	Alan	99	1	1.0%	1	100.0%	1.0%	$17.48	$1,730	$4,000	$4,000	2.3x
#BOSA1K	Organic	94	2	2.1%	1	50.0%	1.1%	$1.00	$94.00	$2,000	$2,000	21.3x
#BOIG22M	Alan	91	4	4.4%	3	75.0%	3.3%	$17.48	$530	$10,050	$3,350	6.3x
#BOIG21M	Alan	82	5	6.1%	1	20.0%	1.2%	$17.48	$1,433	$2,500	$2,500	1.7x
#BO3CX3M	Alan	61	1	1.6%	0	0.0%	0.0%	$17.48	—	—	—	—
#BOFB33F	Alan	48	2	4.2%	0	0.0%	0.0%	$17.48	—	—	—	—
#BO3CX	Alan	42	6	14.3%	2	33.3%	4.8%	$17.48	$367	$4,250	$2,125	5.8x
#BO3CX2M	Alan	41	1	2.4%	0	0.0%	0.0%	$17.48	—	—	—	—
#BO3CX2F	Alan	36	2	5.6%	1	50.0%	2.8%	$17.48	$629	$400	$400	0.6x
#BOFB31M	Alan	33	2	6.1%	1	50.0%	3.0%	$17.48	$577	$50.00	$50.00	0.1x
#BOFB32F	Alan	25	0	0.0%	0	—	0.0%	$17.48	—	—	—	—
#BOFB31F	Alan	24	1	4.2%	1	100.0%	4.2%	$17.48	$419	$250	$250	0.6x
#BOIG2	Alan	11	3	27.3%	2	66.7%	18.2%	$17.48	$96.12	$2,750	$1,375	14.3x
#BOFB33M	Alan	9	0	0.0%	0	—	0.0%	$17.48	—	—	—	—
#BOFB32M	Alan	8	0	0.0%	0	—	0.0%	$17.48	—	—	—	—
#BOS4AB	Alan	8	0	0.0%	0	—	0.0%	$17.48	—	—	—	—
#BOSA1M	Organic	6	0	0.0%	0	—	0.0%	$1.00	—	—	—	—
#BOSLP1	Lead Pronto	1	0	0.0%	0	—	0.0%	—	—	—	—	—

Houston 31 codes · 11,918 leads · city Lead→Show 2.3%

Code	Supplier	Leads	Booked	Book %	Showed	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
#HOUKIDSX	Blue Rooms KIDS	3,244	242	7.5%	134	55.4%	4.1%	$6.19	$134	$311,075	$2,321	17.3x
#HOULP2	Lead Pronto	1,351	62	4.6%	33	53.2%	2.4%	$12.63	$517	$69,525	$2,107	4.1x
#HOU6AB	Neil	1,187	28	2.4%	9	32.1%	0.8%	$1.00	$132	$9,025	$1,003	7.6x
#HOUN1N	Neil	735	21	2.9%	6	28.6%	0.8%	$1.00	$123	$6,125	$1,021	8.3x
#HOUGX	Blue Rooms Other	573	11	1.9%	2	18.2%	0.3%	$14.12	$2,647	$1,000	$500	0.2x
#HOUKX	Blue Rooms KIDS	535	16	3.0%	3	18.8%	0.6%	$23.73	$2,515	$500	$167	0.1x
#HOU3CX1F	Alan	499	33	6.6%	16	48.5%	3.2%	$19.14	$597	$40,850	$2,553	4.3x
#HOUSNAP	Blue Rooms Other	485	30	6.2%	10	33.3%	2.1%	$16.62	$725	$19,200	$1,920	2.6x
#HOU5AB	Neil	465	11	2.4%	4	36.4%	0.9%	$1.00	$116	$7,100	$1,775	15.3x
#HOU1FX	Blue Rooms Other	402	25	6.2%	14	56.0%	3.5%	$8.29	$204	$23,900	$1,707	8.4x
#HOU3DE3F	Alan	299	9	3.0%	4	44.4%	1.3%	$19.14	$1,431	$7,925	$1,981	1.4x
#HOU3DE2F	Alan	296	10	3.4%	4	40.0%	1.4%	$19.14	$1,416	$4,500	$1,125	0.8x
#HOUFB31M	Alan	273	10	3.7%	3	30.0%	1.1%	$19.14	$1,742	$4,100	$1,367	0.8x
#HOU3DE1M	Alan	241	15	6.2%	5	33.3%	2.1%	$19.14	$923	$750	$150	0.2x
#HOU3CX1M	Alan	223	17	7.6%	7	41.2%	3.1%	$19.14	$610	$14,550	$2,079	3.4x
#HOU3DE1F	Alan	211	14	6.6%	8	57.1%	3.8%	$19.14	$505	$6,750	$844	1.7x
#HOUFB31F	Alan	198	5	2.5%	0	0.0%	0.0%	$19.14	—	—	—	—
#HOUCMN	Neil	97	11	11.3%	2	18.2%	2.1%	$1.00	$48.50	$8,000	$4,000	82.5x
#HOUFB33F	Alan	96	7	7.3%	2	28.6%	2.1%	$19.14	$919	$4,000	$2,000	2.2x
#HOUFB33M	Alan	82	2	2.4%	2	100.0%	2.4%	$19.14	$785	$5,000	$2,500	3.2x
#HOU3DE2M	Alan	72	3	4.2%	1	33.3%	1.4%	$19.14	$1,378	$2,500	$2,500	1.8x
#HOUFB32M	Alan	72	2	2.8%	1	50.0%	1.4%	$19.14	$1,378	$400	$400	0.3x
#HOU3DE	Alan	65	1	1.5%	1	100.0%	1.5%	$19.14	$1,244	$4,000	$4,000	3.2x
#HOUFB32F	Alan	56	3	5.4%	0	0.0%	0.0%	$19.14	—	—	—	—
#HOU3DE3M	Alan	51	0	0.0%	0	—	0.0%	$19.14	—	—	—	—
#HOU3CX3F	Alan	34	0	0.0%	0	—	0.0%	$19.14	—	—	—	—
#HOU3CX2F	Alan	29	2	6.9%	1	50.0%	3.4%	$19.14	$555	$50.00	$50.00	0.1x
#HOU3CX3M	Alan	22	1	4.5%	1	100.0%	4.5%	$19.14	$421	$4,000	$4,000	9.5x
#HOU3CX2M	Alan	17	0	0.0%	0	—	0.0%	$19.14	—	—	—	—
#HOU4AB	Alan	7	0	0.0%	0	—	0.0%	$19.14	—	—	—	—
#HOUFB3	Alan	1	0	0.0%	0	—	0.0%	$19.14	—	—	—	—

Florida 44 codes · 26,570 leads · city Lead→Show 2.3%

Code	Supplier	Leads	Booked	Book %	Showed	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
#FLKIDSX	Blue Rooms KIDS	8,075	562	7.0%	268	47.7%	3.3%	$5.34	$144	$600,365	$2,240	15.6x
#ORLP2	Lead Pronto	1,952	96	4.9%	48	50.0%	2.5%	$9.73	$396	$96,960	$2,020	5.1x
#FL1FX	Blue Rooms Other	1,761	132	7.5%	56	42.4%	3.2%	$11.80	$332	$97,950	$1,749	5.3x
#ORL1FX	Blue Rooms Other	1,625	106	6.5%	49	46.2%	3.0%	$7.21	$217	$117,242	$2,393	11.0x
#FL6AB	Neil	1,386	35	2.5%	10	28.6%	0.7%	$1.00	$139	$23,512	$2,351	17.0x
#FLP2	Lead Pronto	1,367	54	4.0%	23	42.6%	1.7%	$13.36	$794	$45,850	$1,993	2.5x
#ORL6AB	Neil	1,140	15	1.3%	3	20.0%	0.3%	$1.00	$380	$11,050	$3,683	9.7x
#ORLFB32F	Alan	889	29	3.3%	8	27.6%	0.9%	$16.40	$1,822	$17,500	$2,188	1.2x
#FL01	Organic	788	33	4.2%	16	48.5%	2.0%	$1.00	$49.25	$43,650	$2,728	55.4x
#FLN1N	Neil	731	29	4.0%	7	24.1%	1.0%	$1.00	$104	$19,875	$2,839	27.2x
#FLGX	Blue Rooms Other	648	4	0.6%	1	25.0%	0.2%	$16.58	$5,901	$400	$400	0.1x
#FLKX	Blue Rooms KIDS	599	18	3.0%	6	33.3%	1.0%	$20.87	$1,252	$20,400	$3,400	2.7x
#ORLKX	Blue Rooms KIDS	514	12	2.3%	0	0.0%	0.0%	$13.57	—	—	—	—
#FL3CX1F	Alan	473	51	10.8%	19	37.3%	4.0%	$16.40	$408	$36,350	$1,913	4.7x
#FL5AB	Neil	405	8	2.0%	4	50.0%	1.0%	$1.00	$101	$5,100	$1,275	12.6x
#ORLN1N	Neil	365	7	1.9%	3	42.9%	0.8%	$1.00	$122	$10,100	$3,367	27.7x
#ORLGX	Blue Rooms Other	348	3	0.9%	2	66.7%	0.6%	$12.44	$1,443	$6,550	$3,275	2.3x
#FL4IG32F	Alan	343	9	2.6%	2	22.2%	0.6%	$16.40	$2,812	$6,500	$3,250	1.2x
#ORLSNAP	Blue Rooms Other	340	26	7.6%	8	30.8%	2.4%	$13.53	$530	$12,550	$1,569	3.0x
#FLFB32F	Alan	320	11	3.4%	2	18.2%	0.6%	$16.40	$2,624	$2,100	$1,050	0.4x
#ORLFB31M	Alan	264	11	4.2%	3	27.3%	1.1%	$16.40	$1,443	$4,150	$1,383	1.0x
#FL3CX1M	Alan	241	37	15.4%	18	48.6%	7.5%	$16.40	$220	$27,300	$1,517	6.9x
#ORLFB31F	Alan	233	10	4.3%	4	40.0%	1.7%	$16.40	$955	$10,000	$2,500	2.6x
#ORLCMN	Neil	221	27	12.2%	6	22.2%	2.7%	$1.00	$36.83	$7,600	$1,267	34.4x
#FLSNAP	Blue Rooms Other	219	14	6.4%	6	42.9%	2.7%	$19.60	$650	$15,500	$2,583	4.0x
#ORL4IG32F	Alan	190	7	3.7%	4	57.1%	2.1%	$16.40	$779	$2,050	$513	0.7x
#ORL4IG33F	Alan	186	2	1.1%	2	100.0%	1.1%	$16.40	$1,525	$6,800	$3,400	2.2x
#ORL4IG31F	Alan	167	8	4.8%	3	37.5%	1.8%	$16.40	$913	$8,600	$2,867	3.1x
#FL4IG31F	Alan	159	11	6.9%	4	36.4%	2.5%	$16.40	$652	$9,550	$2,388	3.7x
#FLFB31M	Alan	131	7	5.3%	2	28.6%	1.5%	$16.40	$1,074	$5,500	$2,750	2.6x
#FL4IG31M	Alan	129	8	6.2%	3	37.5%	2.3%	$16.40	$705	$5,700	$1,900	2.7x
#FLFB31F	Alan	124	2	1.6%	0	0.0%	0.0%	$16.40	—	—	—	—
#ORL4IG31M	Alan	39	5	12.8%	3	60.0%	7.7%	$16.40	$213	$8,050	$2,683	12.6x
#FL3CX2F	Alan	33	1	3.0%	0	0.0%	0.0%	$16.40	—	—	—	—
#FLCMN	Neil	32	5	15.6%	3	60.0%	9.4%	$1.00	$10.67	$7,025	$2,342	219.5x
#ORL4IG32M	Alan	31	0	0.0%	0	—	0.0%	$16.40	—	—	—	—
#FL3CX3F	Alan	22	0	0.0%	0	—	0.0%	$16.40	—	—	—	—
#FL3CX2M	Alan	21	3	14.3%	2	66.7%	9.5%	$16.40	$172	—	—	—
#ORL4IG33M	Alan	20	0	0.0%	0	—	0.0%	$16.40	—	—	—	—
#ORL5AB	Neil	18	0	0.0%	0	—	0.0%	$1.00	—	—	—	—
#FL4AB	Alan	11	0	0.0%	0	—	0.0%	$16.40	—	—	—	—
#FL3CX3M	Alan	7	0	0.0%	0	—	0.0%	$16.40	—	—	—	—
#ORL4AB	Alan	2	0	0.0%	0	—	0.0%	$16.40	—	—	—	—
#ORLKIDS	Alan	1	0	0.0%	0	—	0.0%	$16.40	—	—	—	—

Nashville 30 codes · 8,384 leads · city Lead→Show 2.2%

Code	Supplier	Leads	Booked	Book %	Showed	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
#NAKIDSX	Blue Rooms KIDS	1,534	129	8.4%	52	40.3%	3.4%	$21.56	$575	$90,875	$1,748	3.0x
#NALP2	Lead Pronto	1,432	112	7.8%	41	36.6%	2.9%	$18.03	$630	$57,350	$1,399	2.2x
#NA6AB	Neil	994	29	2.9%	5	17.2%	0.5%	$1.00	$199	$11,050	$2,210	11.1x
#NASGX	Blue Rooms Other	722	7	1.0%	2	28.6%	0.3%	$15.98	$3,356	$4,500	$2,250	0.7x
#NAN1N	Neil	542	8	1.5%	3	37.5%	0.6%	$1.00	$181	$2,900	$967	5.4x
#NASKX	Blue Rooms KIDS	462	15	3.2%	5	33.3%	1.1%	$22.42	$1,256	$15,500	$3,100	2.5x
#NA3CX1F	Alan	281	21	7.5%	5	23.8%	1.8%	$15.74	$885	$8,050	$1,610	1.8x
#NASSNAP	Blue Rooms Other	274	23	8.4%	8	34.8%	2.9%	$17.99	$567	$23,150	$2,894	5.1x
#NA1FX	Blue Rooms Other	256	27	10.5%	13	48.1%	5.1%	$10.87	$186	$26,700	$2,054	11.0x
#NA5AB	Neil	218	10	4.6%	4	40.0%	1.8%	$1.00	$54.50	$9,100	$2,275	41.7x
#NAIG22F	Alan	198	9	4.5%	4	44.4%	2.0%	$15.74	$779	$6,050	$1,513	1.9x
#NAIG23F	Alan	191	3	1.6%	0	0.0%	0.0%	$15.74	—	—	—	—
#NAFB33F	Alan	153	11	7.2%	5	45.5%	3.3%	$15.74	$482	$5,700	$1,140	2.4x
#NACMN	Neil	138	11	8.0%	3	27.3%	2.2%	$1.00	$46.00	$2,550	$850	18.5x
#NAFB31F	Alan	138	10	7.2%	4	40.0%	2.9%	$15.74	$543	$4,800	$1,200	2.2x
#NAIG21F	Alan	129	9	7.0%	5	55.6%	3.9%	$15.74	$406	$6,125	$1,225	3.0x
#NA3CX1M	Alan	96	11	11.5%	6	54.5%	6.3%	$15.74	$252	$10,575	$1,763	7.0x
#NA3CX3F	Alan	89	2	2.2%	1	50.0%	1.1%	$15.74	$1,401	$400	$400	0.3x
#NAFB31M	Alan	88	10	11.4%	6	60.0%	6.8%	$15.74	$231	$13,525	$2,254	9.8x
#NAFB32F	Alan	88	6	6.8%	2	33.3%	2.3%	$15.74	$693	$3,950	$1,975	2.9x
#NAIG21M	Alan	79	6	7.6%	1	16.7%	1.3%	$15.74	$1,244	$4,000	$4,000	3.2x
#NAIG23M	Alan	56	0	0.0%	0	—	0.0%	$15.74	—	—	—	—
#NA3CX2F	Alan	44	3	6.8%	2	66.7%	4.5%	$15.74	$346	$3,000	$1,500	4.3x
#NA3CX3M	Alan	44	1	2.3%	1	100.0%	2.3%	$15.74	$693	$1,500	$1,500	2.2x
#NAIG22M	Alan	43	2	4.7%	2	100.0%	4.7%	$15.74	$338	$3,025	$1,513	4.5x
#NAFB32M	Alan	32	5	15.6%	2	40.0%	6.3%	$15.74	$252	$2,000	$1,000	4.0x
#NA3CX2M	Alan	28	1	3.6%	0	0.0%	0.0%	$15.74	—	—	—	—
#NAFB33M	Alan	22	0	0.0%	0	—	0.0%	$15.74	—	—	—	—
#NA4AB	Alan	12	3	25.0%	0	0.0%	0.0%	$15.74	—	—	—	—
#NATC	Alan	1	0	0.0%	0	—	0.0%	$15.74	—	—	—	—

New York 31 codes · 11,626 leads · city Lead→Show 1.9%

Code	Supplier	Leads	Booked	Book %	Showed	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
#NYKIDSX	Blue Rooms KIDS	3,666	265	7.2%	131	49.4%	3.6%	$7.84	$209	$244,999	$1,870	8.9x
#NY6AB	Neil	1,940	76	3.9%	21	27.6%	1.1%	$1.00	$92.38	$41,225	$1,963	21.3x
#NYKX	Blue Rooms KIDS	1,041	29	2.8%	8	27.6%	0.8%	$11.15	$820	$20,100	$2,513	3.1x
#NYGX	Blue Rooms Other	860	13	1.5%	0	0.0%	0.0%	$9.29	—	—	—	—
#NYN1N	Neil	732	20	2.7%	5	25.0%	0.7%	$1.00	$146	$12,900	$2,580	17.6x
#NY1FX	Blue Rooms Other	715	58	8.1%	21	36.2%	2.9%	$7.34	$244	$35,150	$1,674	6.9x
#NY5AB	Neil	631	32	5.1%	9	28.1%	1.4%	$1.00	$70.11	$15,175	$1,686	24.0x
#NYSNAP	Blue Rooms Other	617	22	3.6%	5	22.7%	0.8%	$10.96	$1,162	$9,450	$1,890	1.6x
#NYLP2	Lead Pronto	292	11	3.8%	5	45.5%	1.7%	$7.81	$456	$12,100	$2,420	5.3x
#NYCMN	Neil	234	27	11.5%	7	25.9%	3.0%	$1.00	$33.43	$12,825	$1,832	54.8x
#NYIG23F	Alan	170	5	2.9%	4	80.0%	2.4%	$8.25	$351	$8,540	$2,135	6.1x
#NYFB33F	Alan	164	2	1.2%	1	50.0%	0.6%	$8.25	$1,353	$4,000	$4,000	3.0x
#NYIG22F	Alan	91	7	7.7%	5	71.4%	5.5%	$8.25	$150	$11,449	$2,290	15.3x
#NY3CX1F	Alan	64	7	10.9%	1	14.3%	1.6%	$8.25	$528	$4,000	$4,000	7.6x
#NYFB32F	Alan	58	2	3.4%	1	50.0%	1.7%	$8.25	$478	$50.00	$50.00	0.1x
#NYFB31F	Alan	57	3	5.3%	2	66.7%	3.5%	$8.25	$235	$450	$225	1.0x
#NYIG21F	Alan	43	1	2.3%	0	0.0%	0.0%	$8.25	—	—	—	—
#NYFB33M	Alan	40	0	0.0%	0	—	0.0%	$8.25	—	—	—	—
#NYIG23M	Alan	38	0	0.0%	0	—	0.0%	$8.25	—	—	—	—
#NY3CX1M	Alan	37	0	0.0%	0	—	0.0%	$8.25	—	—	—	—
#NYIG22M	Alan	32	1	3.1%	0	0.0%	0.0%	$8.25	—	—	—	—
#NYFB31M	Alan	30	0	0.0%	0	—	0.0%	$8.25	—	—	—	—
#NYIG21M	Alan	22	2	9.1%	0	0.0%	0.0%	$8.25	—	—	—	—
#NYFB32M	Alan	19	1	5.3%	0	0.0%	0.0%	$8.25	—	—	—	—
#NY4AB	Alan	9	0	0.0%	0	—	0.0%	$8.25	—	—	—	—
#NY3CX2F	Alan	7	2	28.6%	0	0.0%	0.0%	$8.25	—	—	—	—
#NYIG2	Alan	7	0	0.0%	0	—	0.0%	$8.25	—	—	—	—
#NY3CX3F	Alan	5	0	0.0%	0	—	0.0%	$8.25	—	—	—	—
#NY3CX2M	Alan	3	0	0.0%	0	—	0.0%	$8.25	—	—	—	—
#NY3CX3M	Alan	1	0	0.0%	0	—	0.0%	$8.25	—	—	—	—
#NYIG4	Alan	1	0	0.0%	0	—	0.0%	$8.25	—	—	—	—

Chicago 30 codes · 12,287 leads · city Lead→Show 1.9%

Code	Supplier	Leads	Booked	Book %	Showed	Show %	Lead→Show %	CPL $	Cost/Show $	$ Sold	Rev/Show $	ROAS
#CHIKIDSX	Blue Rooms KIDS	2,062	109	5.3%	54	49.5%	2.6%	$10.99	$351	$102,182	$1,892	5.4x
#CHI6AB	Neil	1,846	39	2.1%	8	20.5%	0.4%	$1.00	$231	$10,675	$1,334	5.8x
#CHILP2	Lead Pronto	1,447	67	4.6%	35	52.2%	2.4%	$10.16	$420	$53,150	$1,519	3.6x
#CHI1FX	Blue Rooms Other	1,182	106	9.0%	44	41.5%	3.7%	$9.54	$227	$71,400	$1,623	7.2x
#CHIN1N	Neil	854	27	3.2%	14	51.9%	1.6%	$1.00	$61.00	$19,649	$1,404	23.0x
#CHIGX	Blue Rooms Other	649	15	2.3%	6	40.0%	0.9%	$15.04	$918	$7,700	$1,283	1.4x
#CHIIG23F	Alan	609	20	3.3%	8	40.0%	1.3%	$19.49	$1,484	$13,550	$1,694	1.1x
#CHISNAP	Blue Rooms Other	600	32	5.3%	10	31.3%	1.7%	$13.85	$774	$20,700	$2,070	2.7x
#CHIKX	Blue Rooms KIDS	571	9	1.6%	5	55.6%	0.9%	$21.99	$1,486	$14,900	$2,980	2.0x
#CHIIG22F	Alan	386	15	3.9%	9	60.0%	2.3%	$19.49	$836	$20,250	$2,250	2.7x
#CHICMN	Neil	332	22	6.6%	8	36.4%	2.4%	$1.00	$41.50	$12,950	$1,619	39.0x
#CHI3CX1F	Alan	322	29	9.0%	15	51.7%	4.7%	$19.49	$418	$15,240	$1,016	2.4x
#CHIIG21F	Alan	317	14	4.4%	2	14.3%	0.6%	$19.49	$3,089	$3,550	$1,775	0.6x
#CHIFB33F	Alan	304	9	3.0%	2	22.2%	0.7%	$19.49	$2,962	$6,500	$3,250	1.1x
#CHI3CX1M	Alan	158	21	13.3%	10	47.6%	6.3%	$19.49	$308	$13,550	$1,355	4.4x
#CHIIG21M	Alan	134	10	7.5%	4	40.0%	3.0%	$19.49	$653	$550	$138	0.2x
#CHIFB33M	Alan	97	3	3.1%	1	33.3%	1.0%	$19.49	$1,890	—	—	—
#CHI3CX3F	Alan	91	2	2.2%	1	50.0%	1.1%	$19.49	$1,773	$3,000	$3,000	1.7x
#CHIFB31F	Alan	57	2	3.5%	1	50.0%	1.8%	$19.49	$1,111	$4,000	$4,000	3.6x
#CHIFB31M	Alan	55	1	1.8%	0	0.0%	0.0%	$19.49	—	—	—	—
#CHIFB32F	Alan	46	2	4.3%	0	0.0%	0.0%	$19.49	—	—	—	—
#CHI3CX3M	Alan	37	0	0.0%	0	—	0.0%	$19.49	—	—	—	—
#CHI3CX2F	Alan	31	1	3.2%	0	0.0%	0.0%	$19.49	—	—	—	—
#CHIFB32M	Alan	30	2	6.7%	1	50.0%	3.3%	$19.49	$585	$400	$400	0.7x
#CHIA1M	Organic	18	0	0.0%	0	—	0.0%	$1.00	—	—	—	—
#CHI3CX2M	Alan	17	1	5.9%	0	0.0%	0.0%	$19.49	—	—	—	—
#CHIIG22M	Alan	16	1	6.3%	0	0.0%	0.0%	$19.49	—	—	—	—
#CHI4AB	Alan	9	0	0.0%	0	—	0.0%	$19.49	—	—	—	—
#CHI5AB	Neil	6	0	0.0%	0	—	0.0%	$1.00	—	—	—	—
#CHIIG23M	Alan	4	0	0.0%	0	—	0.0%	$19.49	—	—	—	—

Lead→Show % = showed ÷ leads (= Book% × Show%) — the share of paid leads that actually turned up, the real bottom line. A lower booking rate with a better show rate can beat a higher booking rate that no-shows (e.g. 6%×75% = 4.5% beats 7.5%×50% = 3.75%).
The maturity windows trail from your selected end date; show rate lags booking (the appointment happens later), so the 1–2 week rows read low — those appointments mostly haven't happened yet. Read the 8-week row as the true rate. Tip: for reliable show rates in the breakdowns, pick a range that ended a few weeks ago — very recent leads haven't shown yet. Recycled (…R) codes: bookings, shows & revenue fold into the parent; leads aren't recounted.
Revenue — $ Sold = contract value of sales from showed leads · Paid Up Front = cash collected at the sale · Rev/Show = $ sold ÷ showed · ROAS = $ sold ÷ spend (shows only where we have cost loaded). Revenue lags even more than the show rate — the sale lands after the appointment, and payment-plan cash arrives over months — so recent ranges understate revenue more than they understate show rate. Read a settled range (ended ≥8 wk ago) for true revenue. All from the same CRM ROI report. NEW — trial; /roi and /roi-cpl are unchanged.

Leads → Booked → Showed → Sold