Share:

CRM Leads — By Campaign Code

11/13/2026 → 11/19/2026  ·  8,872 leads in  ·  180 booked (2.0%)  ·  260 sales $482,230  ·  Spend $50,526  ·  ROI +854%
▸ How lead costs are calculated (click to show)
Spend Resolution — Priority Order
1. CRM ROI feed (pullROIData() → /report-roidatalib.php)
→ 839 codes returned
2. lead_costs.json perCode[code]
→ 7 code-specific overrides
3. lead_costs.json perSource[source]
→ applied to every code matching that source
4. $0 (no CRM / no fallback rate)
spend = rate × leadsIn
cpl = spend / leadsIn
cpb = spend / booked
roi = (salesVal − spend) / spend × 100
Rates currently loaded from lead_costs.json
PER SOURCE:
Lead Pronto $15/leadBlue Rooms $7.52/leadBoost $0 (no cost)Neil $0 (no cost)Alan $0 (no cost)
PER CODE (overrides):
#BOSKIDSX $18.51/lead#CHIKIDSX $8.62/lead#DALKIDSX $14.83/lead#FLKIDSX $4.72/lead#HOUKIDSX $5.43/lead#NAKIDSX $13.73/lead#NYKIDSX $5/lead
To update these rates:
Edit C:\Users\Home\Studio1-Automation\lead_costs.json → commit → push. Re-run report.
Total Leads In
8,872
11/13/2026 → 11/19/2026
Ad Spend
$50,526
CPL $6
Booked
180
2.0% conv  ·  CPB $281
Sales
260
$482,230 value
ROI
+854%
$431,704 net
Active Codes
126
31 unpriced  ·  8 cities
Lead Sources  6 suppliers · Total spend $50,526 · Overall ROI +854%
Source Codes Leads In Spend Method CPL Booked Conv% CPB Sales Sales $ ROI
Lead Pronto 8 942 $18,594 LP rate — wk 2026-08-28
carried forward · £→$ $20.02/lead
$19.74 16 1.7% $1,162 24 $41,549 +123%
Blue Rooms 30 4,247 $31,932 Fallback (per-code)
7 overrides
$7.52 110 2.6% $290 142 $249,805 +682%
Boost 1 0 — no spend data
1 code · $0
— 0 — — 1 $4,000 —
Neil 31 198 — no spend data
31 codes · $0
— 4 2.0% — 22 $42,849 —
Alan 86 3,222 — no spend data
86 codes · $0
— 48 1.5% — 68 $138,627 —
Organic 1 43 — no spend data
1 code · $0
— 2 4.7% — 3 $5,400 —
By Lead Type  what the money actually buys · PMax = PX/KX/GX together · MATURED cohort 2026-10-03 → 2026-11-02 · 55,394 leads · $860,358 cash
Lead type Codes Leads In Booked Conv% Showed Written $ Written / lead Cash up front Cash / lead
Alan / other 602 25,885 46.7% 1039 4.01% 417 $748,142 $28.90 $269,687 $10.42
Insta adults (1FX) 18 13,454 24.3% 763 5.67% 332 $558,355 $41.50 $217,464 $16.16
KIDSX (kids Meta) 8 9,266 16.7% 657 7.09% 295 $649,672 $70.11 $285,653 $30.83
Lead Pronto 109 6,191 11.2% 306 4.94% 133 $220,270 $35.58 $82,089 $13.26
Snapchat 16 472 0.9% 33 6.99% 13 $19,875 $42.11 $5,465 $11.58
PMax (PX/KX/GX) 86 126 0.2% 2 1.59% 0 $0 $0.00 $0 $0.00
Cash / lead is the number to buy on. This block deliberately uses a matured cohort (30 days ending 15 days ago) — not the week above — because a lead from this week has not shown yet, so its Conv% and cash both read near zero. “Written” is the CRM's Total $ sold (contract value), of which only ~36% lands as cash up front; the rest is financed and collected later. No cost column: the USA Models dashboard attributes spend only on “All Sources”, so spend splits kids vs adult but not PMax within them.
City Summary
City Leads In Spend CPL Booked Conv% CPB Sales Sales $ ROI Codes
Boston 811 $7,232 $8.92 21 2.6% $344 35 $51,514 +612% 15+4
Florida 1,192 $6,209 $5.21 26 2.2% $239 39 $59,799 +863% 17+4
Dallas 892 $5,954 $6.67 19 2.1% $313 19 $35,600 +498% 17+4
Nashville 518 $4,456 $8.60 10 1.9% $446 26 $57,900 +1199% 16+3
Houston 848 $4,371 $5.15 15 1.8% $291 31 $53,475 +1123% 17+4
Chicago 1,038 $6,577 $6.34 16 1.5% $411 39 $63,224 +861% 16+4
New York 1,690 $4,273 $2.53 22 1.3% $194 37 $87,361 +1944% 13+4
Orlando 733 $7,919 $10.80 6 0.8% $1,320 15 $37,475 +373% 11+4
Bookers  58 active · 10.8 avg daily (Mon–Fri) · 314 bookings · $15,350 deposits
Active Bookers
58
in date range
Avg Daily Active
10.8
working days only
Total Bookings
314
by bookers
Top Booker
Chyna-Rae C
15 bookings · New York
DayActiveBookings
Sat 11-14 wknd 1 1
Sun 11-15 wknd 5 5
Mon 11-16 8 9
Tue 11-17 8 8
Wed 11-18 6 7
Thu 11-19 22 28
Fri 11-20 15 21
Sat 11-21 wknd 10 13
Sun 11-22 wknd 17 27
Mon 11-23 21 27
Tue 11-24 14 16
Wed 11-25 18 24
Fri 11-27 12 15
Sat 11-28 wknd 33 53
Sun 11-29 wknd 26 40
Mon 11-30 9 10
Tue 12-01 4 4
Wed 12-02 1 1
Thu 12-03 2 2
Sat 12-05 wknd 1 1
Sun 12-06 wknd 2 2
City Bookers Bookings Deposits $ Top Booker Active Bookers
Boston 9 47 $2,400 Estrella D (7) Estrella D 7 Martha M 7 Jamie H 6 Jill S 6 Cheryl S 6 Joselyn P 5 Evan C 5 Lauren W 3 Kristie G 2
Dallas 5 33 $1,650 Michelle M (11) Michelle M 11 Alecia H 9 Bari M 5 Paola G 5 Corban A 3
Houston 7 34 $1,650 Stephen R (8) Stephen R 8 Eduardo G 8 Rosario A 5 Jeffrey S 5 Brian P 3 Jessica W 3 Jonathan M 2
New York 7 47 $2,275 Chyna-Rae C (15) Chyna-Rae C 15 Selina M 10 Kevin W 8 Mark L 4 Rob A 4 Charles B 3 Dalis F 3
Chicago 8 39 $1,925 Edmond M (8) Edmond M 8 Bobbie M 8 Andrew L 7 Carly L 7 Eva M 4 Sherri B 2 Perry K 2 Damien H 1
Nashville 4 23 $1,150 Miguel S (8) Miguel S 8 Kieran R 5 Debra S 5 Scott T 5
Florida 14 69 $3,200 Andrew B (9) Andrew B 9 Debbi H 9 Summer A 9 Jennifer D 7 David P 6 Monica E 6 Ali R 5 Alexandra M 4 Erica S 4 Steven M 3 Helen H 3 Hallie F 2 Victoria M 1 Sarah S 1
▸ Full booker detail (58 rows)
Booker Primary City Bookings Days Avg/Day Deposits $ Top Code Top Source
Chyna-Rae C New York 15 8 1.9 $800 #NYKIDSX Blue Rooms
Michelle M Dallas 11 6 1.8 $550 #ATKIDSX Blue Rooms
Hanna L Atlanta KIDS 10 5 2.0 $500 #ATKIDSX Blue Rooms
Selina M New York 10 8 1.3 $475 #ATKIDSX Blue Rooms
Andrew B Florida 9 4 2.3 $450 #FLKIDSX Blue Rooms
Debbi H Florida 9 4 2.3 $350 #ATKIDSX Blue Rooms
Alecia H Dallas 9 5 1.8 $450 #DALKIDSXP Alan
Summer A Florida 9 7 1.3 $400 #FLP2 Lead Pronto
Stephen R Houston 8 5 1.6 $400 #HOU1FX Blue Rooms
Edmond M Chicago 8 5 1.6 $375 #ATKIDSX Blue Rooms
Bobbie M Chicago 8 7 1.1 $400 #ATKIDSX Blue Rooms
Eduardo G Houston 8 5 1.6 $375 #ATKIDSXP Blue Rooms
Kevin W New York 8 6 1.3 $400 #NYLP2 Alan
Miguel S Nashville 8 5 1.6 $400 #NALP2 Lead Pronto
Estrella D Boston 7 6 1.2 $350 #BOS1FX Blue Rooms
Andrew L Chicago 7 5 1.4 $325 #CHI1FX Blue Rooms
Martha M Boston 7 5 1.4 $350 #BOS1FX Blue Rooms
Carly L Chicago 7 7 1.0 $400 #CHI1FX Blue Rooms
Jennifer D Florida 7 7 1.0 $300 #ORL1FX Alan
Lisa M Atlanta KIDS 6 4 1.5 $300 #ATKIDSX Blue Rooms
David P Florida 6 6 1.0 $275 #ORL1FX Blue Rooms
Jamie H Boston 6 4 1.5 $300 #BOSKIDSXP Blue Rooms
Jill S Boston 6 5 1.2 $300 #BOS1FX Blue Rooms
Cheryl S Boston 6 4 1.5 $300 #BOSLP2 Lead Pronto
Monica E Florida 6 6 1.0 $300 #ORL1FX Blue Rooms
Zebbie R Atlanta KIDS 5 3 1.7 $250 #HOUKIDSXP Alan
Bari M Dallas 5 5 1.0 $250 #DAL1FX Blue Rooms
Paola G Dallas 5 4 1.3 $250 #ATKIDSX Blue Rooms
Kieran R Nashville 5 3 1.7 $250 #NAKIDSXP Alan
Joselyn P Boston 5 4 1.3 $250 #BOS1FX Blue Rooms
Evan C Boston 5 4 1.3 $250 #BOS1FX Blue Rooms
Rosario A Houston 5 4 1.3 $250 #HOU1FX Blue Rooms
Jeffrey S Houston 5 4 1.3 $250 #HOU1FX Blue Rooms
Debra S Nashville 5 5 1.0 $250 #NA1FX Blue Rooms
Scott T Nashville 5 4 1.3 $250 #NA1FX Blue Rooms
Ali R Florida 5 2 2.5 $250 #FLKIDSX Blue Rooms
Alexandra M Florida 4 4 1.0 $200 #BOSLP2 Lead Pronto
Eva M Chicago 4 4 1.0 $200 #CHI1FX Blue Rooms
Mark L New York 4 4 1.0 $100 #NYCMN Neil
Rob A New York 4 4 1.0 $200 #NYKIDSX Blue Rooms
Erica S Florida 4 2 2.0 $200 #FLKIDSXP Alan
Lauren W Boston 3 3 1.0 $200 #BOSLP2 Lead Pronto
Corban A Dallas 3 3 1.0 $150 #DALP2 Lead Pronto
Brian P Houston 3 3 1.0 $125 #HOUCMN Neil
Jessica W Houston 3 2 1.5 $150 #HOU1FX Blue Rooms
Charles B New York 3 3 1.0 $150 #NYKIDSXP Alan
Dalis F New York 3 3 1.0 $150 #NY3CX1F Alan
Steven M Florida 3 2 1.5 $125 #FL1FX Blue Rooms
Helen H Florida 3 3 1.0 $150 #FLKIDSXP Alan
Kristie G Boston 2 2 1.0 $100 #BOSLP2 Lead Pronto
Sherri B Chicago 2 2 1.0 $75 #CHIFB32M Alan
Perry K Chicago 2 2 1.0 $100 #CHIKIDSXP Alan
Jonathan M Houston 2 2 1.0 $100 #HOU1FX Blue Rooms
Hallie F Florida 2 2 1.0 $100 #FLKIDSXP Alan
Francisco M Atlanta KIDS 1 1 1.0 $50 #ATKIDSXP Alan
Damien H Chicago 1 1 1.0 $50 #CHIKIDSXP Alan
Victoria M Florida 1 1 1.0 $50 #FLKIDSX Blue Rooms
Sarah S Florida 1 1 1.0 $50 #FLKIDSXP Alan
Boston 15 campaign codes  ·  811 leads in
811
Leads In
$7,232
Spend
$9
CPL
21
Booked
2.6%
Conv
$344
CPB
$51,514
Sales $
+612%
ROI
Fresh
786 leads
2.7% conv
21 booked
Spend $7,232 · CPL $9 · CPB $344 · ROI +612%
4AB / N1N
7 leads
0.0% conv
0 booked
No spend tracked
5AB / 6AB / CMN / TC
18 leads
0.0% conv
0 booked
No spend tracked
Campaign Code Source Leads In Volume Spend CPL Booked Conv% CPB Sales Sales $ ROI
#BOSKIDSX Blue Rooms 113
$2,092 $18.51 5 4.4% $418 9 $18,950 +806%
#BOSKIDSXP Alan 55
— — 2 3.6% — 5 $11,364 —
#BOSLP2 Lead Pronto 116
$2,877 $24.80 4 3.4% $719 5 $4,200 +46%
#BOS1FX Blue Rooms 291
$2,188 $7.52 10 3.4% $219 15 $16,950 +675%
#BO3CX1F Alan 15
— — 0 0.0% — 1 $50 —
#BOFB31M Alan 20
— — 0 0.0% — 0 — —
#BO3CX1M Alan 11
— — 0 0.0% — 0 — —
#BOS3AB Alan 144
— — 0 0.0% — 0 — —
#BOSSNAP Blue Rooms 7
$52.64 $7.52 0 0.0% — 0 — -100%
#BOFB32M Alan 5
— — 0 0.0% — 0 — —
#BOFB31F Alan 3
— — 0 0.0% — 0 — —
#BO3CX3M Alan 1
— — 0 0.0% — 0 — —
#BO3CX2F Alan 2
— — 0 0.0% — 0 — —
#BOSGX Blue Rooms 3
$22.56 $7.52 0 0.0% — 0 — -100%
#BOFB32F Alan 0
— — 0 — — 0 — —
Recycled / Unpriced  ·  4 codes  ·  25 leads
#BOSCMN Neil 4
— — 0 0.0% — 0 — —
#BOS6AB Neil 9
— — 0 0.0% — 0 — —
#BOSN1N Neil 7
— — 0 0.0% — 0 — —
#BOS5AB Neil 5
— — 0 0.0% — 0 — —