A far lead is worth about two thirds of a near one. $20.62 of cash on the day per ≤ 25 mi lead against $17.89 at
100–200 mi — 13% less, and 26% less past 200 miles.
That is the discount a far lead has to come at before it earns its place.
Value starts falling inside the first hour. A 30–60 minute lead returns $19.93 against $20.66 inside
30 minutes, so the decay starts immediately rather than at the hour mark.
Distance costs you nothing in the room. Deal size barely moves across any band — the whole spread is
$2,365–$2,793, 18% — and close rate actually
RISES with distance, 70.0% at ≤ 25 mi to
82.3% at 100–200 mi.
Someone who drove two hours has already decided.
The entire loss is upstream — booking % 5.1% → 3.6%
and show rate 64.2% → 52.2%. So the fix for
distance is confirmations, reminders and appointment times, not the pitch or the price.
Cash up front does not move with distance either. $929 / $1,061 / $1,001 / $1,013 /
$1,087 per sale, sitting at 36.8%–40.5%
of the deal in every band. A far client puts down what a near one does.
18–24 writes the most revenue per lead — and Under 18 brings the most cash. 18–24 tops revenue at $65.21 per lead but puts down only
30.8% of the deal on the day, against
41.8% for Under 18. They finance it. With
42.3% of financed money never collected (→ /finance-cohort), that
revenue lead is largely fictional — on cash, Under 18 wins at
$23.79 per lead.
The oldest bands are the best customers who never turn up. 55 + buys the biggest packages
($2,867) and pays the highest share up front
(45.4%), but books at just
1.8%. A Under 18 lead is worth
2.6× a 55 + one.
What the unit is. Ad spend is held per SUPPLIER and never per distance or age, so a true cost-per-lead by band
is not derivable from anything we hold. The RATIO is, and it is all a bid decision needs.
Run the report with --cpl <dollars> — what a ≤ 25 mi lead costs today — to
turn the pay column into money.
Basis. Every number hangs off the LEAD, in the month the lead came in.
Booking % = bookings ÷ leads. Show rate = (on calendar − didn’t show) ÷ on calendar.
Lead→Show % = showed ÷ leads — the net output of the leads bought.
Why “on calendar” is the show denominator. The bookings feed carries no appointment
date, so a booking made for a shoot next month would otherwise count as a show. The roster is
keyed to the APPOINTMENT date and is pulled only up to today, so it holds exactly the
appointments that have already come round. Cancellations count against the rate, same as
/show-rate and the CRM’s own Show Rate report.
Distance. Miles = straight line from the lead’s zip centroid to the studio; Florida
codes take whichever of Parkland / Orlando is nearer. Drive time = the 3-digit prefix table from
studio1_drive_pop.xlsx. A zip with no geocode, or a prefix not on the drive table, gets its own
row rather than being quietly dropped.
Excluded. Recycled codes (never bought, and a re-contact of an old lead is a different
question) and codes with no city (no studio to measure from).
Nov 26 is a part month — marked * — and immature on both
rates: those leads have not finished booking, and most of the appointments they did book are
still in the future. Read the last complete month.
Rates on fewer than 25 in the denominator are dimmed. Counts sit in their own columns and in
the CSV — hover any rate to see the numbers behind it.
The answer, in five lineswhole period · first vs last band with real volume
Show rate by distance — ≤ 25 mi 64.2% vs
200 mi + 52.6%: the first band is higher
by 11.5 points. Show rate by drive time — ≤ 30 min 63.4% vs
4 h + 53.7%: the first band is higher
by 9.7 points. Show rate by age — Under 18 65.1% vs
55 + 54.2%: the first band is higher
by 11.0 points. Booking % by distance — ≤ 25 mi 5.1% vs
200 mi + 3.1%: the first band is higher
by 2.0 points. Booking % by drive time — ≤ 30 min 4.9% vs
4 h + 3.3%: the first band is higher
by 1.6 points. Booking % by age — Under 18 4.6% vs
55 + 1.8%: the first band is higher
by 2.8 points.
What a lead is worthcash up front per lead — the number that sets what you can pay
A ≤ 25 mi lead returns $20.62 of cash on the day. A 100–200 mi
lead returns $17.89 — 13% less.
Whatever you pay for the near one, that is the discount the far one has to come at before it
earns its place. Full chain on the Lead value tab; what that is worth in real money, against
what we actually pay, on What we can pay.
By distancewhole period
Band
Leads
Bookings
Booking %
On calendar
Didn't show
Showed
Show rate
Lead→Show %
≤ 25 mi
96,092
4,923
5.1%
5,120
1,835
3,285
64.2%
3.4%
25–50 mi
50,268
2,375
4.7%
2,463
984
1,479
60.0%
2.9%
50–100 mi
36,944
1,522
4.1%
1,665
729
936
56.2%
2.5%
100–200 mi
28,665
1,043
3.6%
1,229
587
642
52.2%
2.2%
200 mi +
10,307
317
3.1%
361
171
190
52.6%
1.8%
No zip / not geocoded
5,326
179
3.4%
199
91
108
54.3%
2.0%
All bands
227,602
10,359
4.6%
11,037
4,397
6,640
60.2%
2.9%
By drive timewhole period
Band
Leads
Bookings
Booking %
On calendar
Didn't show
Showed
Show rate
Lead→Show %
≤ 30 min
114,097
5,632
4.9%
5,870
2,149
3,721
63.4%
3.3%
30–60 min
32,281
1,584
4.9%
1,624
637
987
60.8%
3.1%
1–2 h
31,937
1,265
4.0%
1,373
594
779
56.7%
2.4%
2–3 h
20,455
809
4.0%
926
430
496
53.6%
2.4%
3–4 h
15,088
606
4.0%
699
325
374
53.5%
2.5%
4 h +
9,089
301
3.3%
352
163
189
53.7%
2.1%
Prefix not on the drive table
4,655
162
3.5%
193
99
94
48.7%
2.0%
All bands
227,602
10,359
4.6%
11,037
4,397
6,640
60.2%
2.9%
By agewhole period
Band
Leads
Bookings
Booking %
On calendar
Didn't show
Showed
Show rate
Lead→Show %
Under 18
93,888
4,343
4.6%
4,470
1,558
2,912
65.1%
3.1%
18–24
42,272
2,651
6.3%
2,923
1,243
1,680
57.5%
4.0%
25–34
32,964
1,819
5.5%
1,968
851
1,117
56.8%
3.4%
35–44
26,658
920
3.5%
999
447
552
55.3%
2.1%
45–54
19,988
411
2.1%
449
194
255
56.8%
1.3%
55 +
11,819
213
1.8%
227
104
123
54.2%
1.0%
All bands
227,589
10,357
4.6%
11,036
4,397
6,639
60.2%
2.9%
By cityso a band can be read against the city it sits in
City
Leads
Bookings
Booking %
On calendar
Showed
Show rate
Lead→Show %
Boston
23,234
1,275
5.5%
1,248
768
61.5%
3.3%
Dallas
28,573
1,458
5.1%
1,655
986
59.6%
3.5%
Houston
28,963
1,210
4.2%
1,363
840
61.6%
2.9%
New York
31,578
1,372
4.3%
1,419
803
56.6%
2.5%
Chicago
32,350
1,378
4.3%
1,491
947
63.5%
2.9%
Nashville
19,372
1,009
5.2%
1,193
676
56.7%
3.5%
Florida
40,411
1,742
4.3%
1,734
1,072
61.8%
2.7%
Orlando
23,121
915
4.0%
934
548
58.7%
2.4%
All cities
227,602
10,359
4.6%
11,037
6,640
60.2%
2.9%
What a lead is worth, and how much more or less you can pay for one. It decomposes
exactly: cash per lead = booking % × show rate × close % × cash up front per sale.
Every link is in the table, because two bands can arrive at the same value for opposite
reasons and only the chain says which.
The unit is an index, not a price. We have ad spend per SUPPLIER, never per
distance, so a true cost-per-lead by band is not derivable from anything we hold — but the
RATIO is, and it is all you need: if a band returns 60% of the cash per lead, pay 60% of what
you pay now and you stand exactly where you stand today. Run with
--cpl 30 (what a ≤ 25 mi lead costs you) to turn the last column into dollars.
Cash is Total Deposit — what actually landed on the day, booking deposit included.
Revenue is the contracted package price. Steer on cash: the gap between them is finance, and
42.3% of financed money is never collected.
Seen is a viewing that happened, so Close % is sold ÷ seen — the room's
conversion, not the lead's. Sales are pulled to today, so the part month understates.
What this actually says
A far lead is worth about two thirds of a near one. $20.62 of cash on the day per ≤ 25 mi lead against $17.89 at
100–200 mi — 13% less, and 26% less past 200 miles.
That is the discount a far lead has to come at before it earns its place.
Value starts falling inside the first hour. A 30–60 minute lead returns $19.93 against $20.66 inside
30 minutes, so the decay starts immediately rather than at the hour mark.
Distance costs you nothing in the room. Deal size barely moves across any band — the whole spread is
$2,365–$2,793, 18% — and close rate actually
RISES with distance, 70.0% at ≤ 25 mi to
82.3% at 100–200 mi.
Someone who drove two hours has already decided.
The entire loss is upstream — booking % 5.1% → 3.6%
and show rate 64.2% → 52.2%. So the fix for
distance is confirmations, reminders and appointment times, not the pitch or the price.
Cash up front does not move with distance either. $929 / $1,061 / $1,001 / $1,013 /
$1,087 per sale, sitting at 36.8%–40.5%
of the deal in every band. A far client puts down what a near one does.
18–24 writes the most revenue per lead — and Under 18 brings the most cash. 18–24 tops revenue at $65.21 per lead but puts down only
30.8% of the deal on the day, against
41.8% for Under 18. They finance it. With
42.3% of financed money never collected (→ /finance-cohort), that
revenue lead is largely fictional — on cash, Under 18 wins at
$23.79 per lead.
The oldest bands are the best customers who never turn up. 55 + buys the biggest packages
($2,867) and pays the highest share up front
(45.4%), but books at just
1.8%. A Under 18 lead is worth
2.6× a 55 + one.
What the unit is. Ad spend is held per SUPPLIER and never per distance or age, so a true cost-per-lead by band
is not derivable from anything we hold. The RATIO is, and it is all a bid decision needs.
Run the report with --cpl <dollars> — what a ≤ 25 mi lead costs today — to
turn the pay column into money.
The chain, by distancewhole period · 2026-06-01 → 2026-11-17
Band
Leads
Booking %
Show rate
Seen
Sold
Close %
Avg deal
Cash up front / sale
Cash % of deal
Revenue / lead
Cash / lead
Index
≤ 25 mi
96,092
5.1%
64.2%
3,045
2,132
70.0%
$2,526
$929
36.8%
$56.05
$20.62
1.07
25–50 mi
50,268
4.7%
60.0%
1,379
964
69.9%
$2,623
$1,061
40.5%
$50.29
$20.35
1.05
50–100 mi
36,944
4.1%
56.2%
872
651
74.7%
$2,646
$1,001
37.8%
$46.63
$17.65
0.91
100–200 mi
28,665
3.6%
52.2%
615
506
82.3%
$2,706
$1,013
37.4%
$47.77
$17.89
0.93
200 mi +
10,307
3.1%
52.6%
176
145
82.4%
$2,793
$1,087
38.9%
$39.30
$15.29
0.79
No zip / not geocoded
5,326
3.4%
54.3%
100
70
70.0%
$2,291
$1,059
46.2%
$30.11
$13.92
0.72
All bands
227,602
4.6%
60.2%
6,187
4,468
72.2%
$2,590
$985
38.0%
$50.84
$19.33
1.00
Index = this band's cash per lead ÷ the all-band average ($19.33).
Revenue per lead averages $50.84. A lead that never books still counts in the denominator — that is the point of cash per lead.
So how much can we pay?priced off the ≤ 25 mi lead, whose price you already know
Band
Leads
Cash / lead
Pay this % of a ≤ 25 mi lead
≤ 25 mi
96,092
$20.62
100%
25–50 mi
50,268
$20.35
99%
50–100 mi
36,944
$17.65
86%
100–200 mi
28,665
$17.89
87%
200 mi +
10,307
$15.29
74%
The chain, by drive time
Band
Leads
Booking %
Show rate
Seen
Sold
Close %
Avg deal
Cash up front / sale
Cash % of deal
Revenue / lead
Cash / lead
Index
≤ 30 min
114,097
4.9%
63.4%
3,454
2,411
69.8%
$2,555
$977
38.3%
$54.00
$20.66
1.07
30–60 min
32,281
4.9%
60.8%
918
651
70.9%
$2,479
$988
39.9%
$49.98
$19.93
1.03
1–2 h
31,937
4.0%
56.7%
723
536
74.1%
$2,718
$984
36.2%
$45.62
$16.52
0.85
2–3 h
20,455
4.0%
53.6%
473
360
76.1%
$2,619
$924
35.3%
$46.09
$16.26
0.84
3–4 h
15,088
4.0%
53.5%
355
298
83.9%
$2,779
$1,058
38.1%
$54.88
$20.90
1.08
4 h +
9,089
3.3%
53.7%
179
150
83.8%
$2,700
$1,108
41.1%
$44.56
$18.29
0.95
Prefix not on the drive table
4,655
3.5%
48.7%
85
62
72.9%
$2,661
$947
35.6%
$35.44
$12.62
0.65
All bands
227,602
4.6%
60.2%
6,187
4,468
72.2%
$2,590
$985
38.0%
$50.84
$19.33
1.00
Index = this band's cash per lead ÷ the all-band average ($19.33).
Revenue per lead averages $50.84.
So how much can we pay?priced off the ≤ 30 min lead
Band
Leads
Cash / lead
Pay this % of a ≤ 30 min lead
≤ 30 min
114,097
$20.66
100%
30–60 min
32,281
$19.93
96%
1–2 h
31,937
$16.52
80%
2–3 h
20,455
$16.26
79%
3–4 h
15,088
$20.90
101%
4 h +
9,089
$18.29
89%
The chain, by age
Band
Leads
Booking %
Show rate
Seen
Sold
Close %
Avg deal
Cash up front / sale
Cash % of deal
Revenue / lead
Cash / lead
Index
Under 18
93,888
4.6%
65.1%
2,657
1,966
74.0%
$2,716
$1,136
41.8%
$56.87
$23.79
1.23
18–24
42,272
6.3%
57.5%
1,596
1,116
69.9%
$2,470
$762
30.8%
$65.21
$20.12
1.04
25–34
32,964
5.5%
56.8%
1,050
751
71.5%
$2,365
$870
36.8%
$53.87
$19.82
1.03
35–44
26,658
3.5%
55.3%
521
368
70.6%
$2,623
$958
36.5%
$36.21
$13.22
0.68
45–54
19,988
2.1%
56.8%
245
182
74.3%
$2,694
$1,104
41.0%
$24.53
$10.05
0.52
55 +
11,819
1.8%
54.2%
117
84
71.8%
$2,867
$1,302
45.4%
$20.37
$9.25
0.48
All bands
227,589
4.6%
60.2%
6,186
4,467
72.2%
$2,590
$985
38.0%
$50.83
$19.33
1.00
Index = this band's cash per lead ÷ the all-band average ($19.33).
Revenue per lead averages $50.83.
So how much can we pay?priced off the Under 18 lead
Band
Leads
Cash / lead
Pay this % of a Under 18 lead
Under 18
93,888
$23.79
100%
18–24
42,272
$20.12
85%
25–34
32,964
$19.82
83%
35–44
26,658
$13.22
56%
45–54
19,988
$10.05
42%
55 +
11,819
$9.25
39%
A lead is worth
$26.61
contribution over its whole life
Paying now
$18.91
$750,000 ÷ 39,653 fresh leads a month
Headroom
$7.69
ads are 71% of what a lead is worth
Contribution margin
47.8%
on banked revenue, after non-ad cost
The inputs (Neil, 21 Aug 2026, overridable with --revenue --cost --adspend --collected):
contracted revenue $3,500,000 a month · all cost $1,900,000including ad spend · ad spend $750,000 ·
63% of contracted eventually banked, cash on the day included.
You buy a lead once, so it is judged on everything it ever produces. A recycled or
rebooked sale is the same lead worked again, not a second free lead — and the cost of working it
again is already inside the non-ad cost. So the anchor is the P&L itself:
contribution per lead = banked revenue × contribution margin ÷ leads bought =
$26.61, and the All-bands row ties to it exactly.
Contribution margin is derived, not assumed: non-ad cost $1,150,000 against banked revenue
$2,205,000 leaves 47.8%.
Bands are scaled by what this report can measure and the P&L cannot — a band's own
contracted revenue per lead and its own banked share, relative to all bands. The lifetime column
applies an uplift of 1.54× over first-cycle revenue, derived as everything
the business books ($3,500,000) over what this report traces to a fresh lead
($2,267,228). It is applied evenly across bands, which assumes a far lead recycles
as well as a near one — the one real assumption in here, and worth testing separately.
Banked share is per band, not a flat 63%. Only the financed
balance is at risk, so a band that takes more cash on the day banks more of its sale. The blend is
decomposed once — cash banked in full, balance collecting at 40.3%
(the rate his 63% implies against a measured
38.0% cash share) — then rebuilt per band. Across distance the cash
share barely moves; across age it swings from 30% to 43%, which is worth points.
Max CPL is a BREAK-EVEN, not a target. Pay it and the lead washes its face after
every cost in the business; pay less and the difference is profit. It already credits the lead
with what it earns when it is worked again, because that is the same lead.
These ceilings charge the lead with FULL cost, which is the conservative read. Not
buying a lead only saves the cost that actually moves with volume — a studio and a salaried
viewer cost the same with one less booking in the diary. If only
50% of the $1,150,000 of non-ad cost is truly variable,
contribution per lead is $41.11 rather than $26.61 and
every ceiling below rises by 55%.
We do not hold that split anywhere, so both ends are shown rather than one invented number —
set it with --variable. It decides whether a marginal band is worth cutting, so
it is the single most valuable number still missing from this model.
Where the money actually comes from
The month, on banked money. $3,500,000 contracted becomes
$2,205,000 banked at 63%. Against
$1,900,000 of cost that is $305,000 of profit —
13.8% of the money that actually arrives, and
8.7% of what gets written.
A bought lead contributes $26.61 over its life. You pay
$18.91. $750,000 of ads buys 39,653 fresh
leads a month, and those leads are what the whole $3,500,000 eventually comes off —
first visit, recycled, rebooked, all of it. Headroom is
$7.69 a lead, and the ad line runs at
71% of what a lead is worth.
Only 65% of the revenue arrives on the first cycle.
$2,267,228 of the $3,500,000 traces to a lead's first run through the funnel;
the other $1,232,772 is the same people, worked again. On first-cycle
money alone a lead is worth only $17.23 — less than the
$18.91 it cost. The follow-up operation is not a bonus on top of the
lead economics; it is what makes them work at all. Anything that damages re-contact yield
takes the margin with it.
Day one is roughly break-even on cash, by design. A lead returns
$19.33 of cash on the day against $18.91 paid for it, so the
ads are nearly covered before a single instalment. Everything after that is the finance book
and the follow-up — which is why collection rate and re-contact are the two levers that move
profit, not CPL.
The mix matters more than the price. You pay one $18.91 for leads whose
ceiling runs from $11.41 to $30.83 by
age, and $20.73 to $28.99 by
distance. Shifting spend toward the cells that clear $18.91 is worth more than
negotiating the price down.
1 · Ceiling by distance and CITYstart here — the same band is worth a different amount in each city
Conversion, show rate and deal size all differ by city, so the ceiling does too,
and the national ladder further down is an average of eight different behaviours. Read a ROW to
see what a city will bear at that distance, a COLUMN to see one city's whole ladder.
Cells under 1,500 leads are dimmed, under 300 are blank. Coloured against the
$18.91 blended price — which is itself a national average, which is the point.
Band
Boston
Dallas
Houston
New York
Chicago
Nashville
Florida
Orlando
All cities
≤ 25 mi
$31.85
$32.11
$27.87
$25.97
$25.86
$40.23
$31.02
$25.16
$28.99
25–50 mi
$24.01
$32.38
$34.40
$21.87
$28.64
$43.14
$19.59
$27.21
$26.93
50–100 mi
$27.72
$32.39
$25.62
$24.81
$26.18
$31.91
$24.43
$16.09
$24.36
100–200 mi
$30.37
$26.15
$22.06
$13.35
$23.30
$31.69
$26.01
$25.07
$24.86
200 mi +
—
$29.02
$27.71
$15.73
$15.25
$17.35
$36.01
$5.25
$20.73
No zip / not geocoded
$27.57
$27.72
$25.91
$9.22
$15.82
$9.41
$7.52
—
$16.98
All bands
$28.36
$31.09
$27.84
$23.18
$25.53
$33.68
$24.85
$21.08
$26.61
2 · What you should pay against what you DOmeasured value meets measured price
The only place in this report where both sides are measured. Ceiling is this report;
price is USA Models dashboard child+adult per-city tables (manual browser ingest 2026-08-18), 2026-06-26 → 2026-08-14. Kids vs adult because
that is the split the supplier quotes in — and it is the sharpest cut in the data.
Read the margin column, not the price. A cheap lead in a city that converts badly can be
worse than an expensive one in a city that converts well, which is exactly why a single national
CPL target misleads.
Caveats. One supplier and one window, so it does not cover Alan, Lead Pronto or Boost —
their prices come in a different shape and are not merged here rather than being merged badly.
Orlando has no row in the supplier feed. And the ceiling is FULL-COST: see the note above on what
happens if part of the $1,150,000 does not actually move with volume.
City
Kids — ceiling
Kids — paid
Kids — margin
Adults — ceiling
Adults — paid
Adults — margin
Boston
$35.95
$33.51
+$2.43
$23.53
$23.66
$-0.14
Dallas
$37.34
$21.34
+$16.01
$27.45
$22.18
+$5.27
Houston
$32.14
$19.03
+$13.11
$25.10
$22.47
+$2.64
New York
$24.14
$9.43
+$14.72
$21.68
$13.88
+$7.80
Chicago
$29.11
$25.18
+$3.93
$23.56
$18.77
+$4.79
Nashville
$44.12
$36.62
+$7.50
$27.31
$19.95
+$7.36
Florida
$27.93
$12.73
+$15.20
$20.51
$15.51
+$5.00
Orlando
$24.01
—
—
$20.87
$16.10
+$4.77
3 · The national ladder, by distanceevery city averaged together — use the per-city table above to actually set a bid
Band
Leads
Contracted / lead
Cash on the day
Banked share
Banked / lead, 1st cycle
Banked / lead, lifetime
Max CPL
vs $18.91 paid now
≤ 25 mi
96,092
$56.05
36.8%
62.3%
$34.90
$53.87
$28.99
+$10.07
25–50 mi
50,268
$50.29
40.5%
64.5%
$32.42
$50.04
$26.93
+$8.01
50–100 mi
36,944
$46.63
37.8%
62.9%
$29.33
$45.27
$24.36
+$5.45
100–200 mi
28,665
$47.77
37.4%
62.7%
$29.93
$46.21
$24.86
+$5.95
200 mi +
10,307
$39.30
38.9%
63.5%
$24.96
$38.53
$20.73
+$1.82
No zip / not geocoded
5,326
$30.11
46.2%
67.9%
$20.44
$31.56
$16.98
$-1.93
All bands
227,602
$50.84
38.0%
63.0%
$32.03
$49.45
$26.61
+$7.69
4 · By drive time
Band
Leads
Contracted / lead
Cash on the day
Banked share
Banked / lead, 1st cycle
Banked / lead, lifetime
Max CPL
vs $18.91 paid now
≤ 30 min
114,097
$54.00
38.3%
63.1%
$34.09
$52.63
$28.32
+$9.40
30–60 min
32,281
$49.98
39.9%
64.1%
$32.04
$49.46
$26.61
+$7.70
1–2 h
31,937
$45.62
36.2%
61.9%
$28.24
$43.60
$23.46
+$4.55
2–3 h
20,455
$46.09
35.3%
61.4%
$28.28
$43.66
$23.49
+$4.58
3–4 h
15,088
$54.88
38.1%
63.0%
$34.59
$53.40
$28.73
+$9.82
4 h +
9,089
$44.56
41.1%
64.8%
$28.88
$44.58
$23.99
+$5.07
Prefix not on the drive table
4,655
$35.44
35.6%
61.6%
$21.82
$33.68
$18.12
$-0.79
All bands
227,602
$50.84
38.0%
63.0%
$32.03
$49.45
$26.61
+$7.69
5 · By agebanked share moves most here — 18–24 finances, 55+ pays up front
Band
Leads
Contracted / lead
Cash on the day
Banked share
Banked / lead, 1st cycle
Banked / lead, lifetime
Max CPL
vs $18.91 paid now
Under 18
93,888
$56.87
41.8%
65.3%
$37.12
$57.30
$30.83
+$11.92
18–24
42,272
$65.21
30.8%
58.7%
$38.29
$59.11
$31.80
+$12.89
25–34
32,964
$53.87
36.8%
62.3%
$33.54
$51.78
$27.86
+$8.95
35–44
26,658
$36.21
36.5%
62.1%
$22.49
$34.71
$18.68
$-0.24
45–54
19,988
$24.53
41.0%
64.8%
$15.89
$24.53
$13.20
$-5.72
55 +
11,819
$20.37
45.4%
67.4%
$13.73
$21.20
$11.41
$-7.51
All bands
227,589
$50.83
38.0%
63.0%
$32.03
$49.44
$26.60
+$7.69
6 · Max CPL · distance × kids/adultsthe bid table — two columns, because a child campaign and an adult campaign are what actually get bought
This is the same raw data as the six-band table below, folded in two instead of
six. Use this one to set a bid and the one below to decide whether an adult decade is
worth buying at all. Green clears the $18.91 blended CPL being paid now; red does
not. A cell under 300 leads is left blank rather than priced off noise.
Distance
Kids (under 18)
Adults (18+)
All ages
≤ 25 mi
$34.44
$25.52
$28.99
25–50 mi
$31.46
$23.58
$26.90
50–100 mi
$28.07
$21.58
$24.36
100–200 mi
$28.24
$22.08
$24.86
200 mi +
$25.32
$17.57
$20.73
No zip / not geocoded
$11.39
$21.75
$16.98
All distances
$30.83
$23.63
$26.60
6b · The same matrix, age split six waysgreen clears what you pay now, red does not
Distance
Under 18
18–24
25–34
35–44
45–54
55 +
All ages
≤ 25 mi
$34.44
$34.22
$28.54
$22.43
$13.41
$10.75
$28.99
25–50 mi
$31.46
$30.64
$29.55
$17.16
$15.81
$9.99
$26.90
50–100 mi
$28.07
$29.99
$29.96
$11.15
$13.22
$14.65
$24.36
100–200 mi
$28.24
$29.60
$23.80
$19.73
$12.53
$13.79
$24.86
200 mi +
$25.32
$31.30
$14.63
$13.35
$4.59
$7.87
$20.73
No zip / not geocoded
$11.39
$24.83
$26.87
$21.58
—
—
$16.98
All distances
$30.83
$31.80
$27.86
$18.68
$13.20
$11.41
$26.60
7 · Ceiling by drive time and city
Band
Boston
Dallas
Houston
New York
Chicago
Nashville
Florida
Orlando
All cities
≤ 30 min
$31.50
$33.46
$28.48
$25.02
$26.20
$41.55
$24.07
$24.05
$28.32
30–60 min
$24.51
$28.07
—
$24.27
$30.82
$11.77
$28.89
$22.24
$26.61
1–2 h
$24.98
$23.37
$30.35
$27.20
$22.80
$23.77
$25.43
$15.49
$23.46
2–3 h
$22.09
$50.65
$21.96
$17.61
$20.63
$29.26
$22.39
$26.24
$23.49
3–4 h
$39.87
$27.00
$29.69
$13.27
$22.76
$37.78
—
$31.63
$28.73
4 h +
$30.33
$45.92
$26.11
$15.33
$17.64
$20.62
—
$18.41
$23.99
Prefix not on the drive table
$31.98
$13.04
$19.65
$14.51
$19.68
$12.15
$32.08
—
$18.12
All bands
$28.36
$31.09
$27.84
$23.18
$25.53
$33.68
$24.85
$21.08
$26.61
8 · Ceiling by age and city
Band
Boston
Dallas
Houston
New York
Chicago
Nashville
Florida
Orlando
All cities
Under 18
$35.95
$37.34
$32.14
$24.14
$29.11
$44.12
$27.93
$24.01
$30.83
18–24
$30.64
$37.66
$32.67
$24.75
$32.67
$42.25
$28.08
$27.71
$31.80
25–34
$27.42
$30.59
$30.49
$26.41
$25.91
$30.61
$24.58
$27.43
$27.86
35–44
$17.07
$18.21
$16.34
$18.30
$22.10
$24.74
$15.86
$17.76
$18.68
45–54
$17.96
$20.40
$14.68
$12.62
$10.14
$9.33
$10.47
$12.04
$13.20
55 +
$8.89
$12.47
$16.88
$8.84
$7.38
$10.46
$13.24
$11.28
$11.41
All bands
$28.36
$31.09
$27.84
$23.18
$25.53
$33.68
$24.85
$21.08
$26.60
Basis. Every number hangs off the LEAD, in the month the lead came in.
Booking % = bookings ÷ leads. Show rate = (on calendar − didn’t show) ÷ on calendar.
Lead→Show % = showed ÷ leads — the net output of the leads bought.
Why “on calendar” is the show denominator. The bookings feed carries no appointment
date, so a booking made for a shoot next month would otherwise count as a show. The roster is
keyed to the APPOINTMENT date and is pulled only up to today, so it holds exactly the
appointments that have already come round. Cancellations count against the rate, same as
/show-rate and the CRM’s own Show Rate report.
Distance. Miles = straight line from the lead’s zip centroid to the studio; Florida
codes take whichever of Parkland / Orlando is nearer. Drive time = the 3-digit prefix table from
studio1_drive_pop.xlsx. A zip with no geocode, or a prefix not on the drive table, gets its own
row rather than being quietly dropped.
Excluded. Recycled codes (never bought, and a re-contact of an old lead is a different
question) and codes with no city (no studio to measure from).
Nov 26 is a part month — marked * — and immature on both
rates: those leads have not finished booking, and most of the appointments they did book are
still in the future. Read the last complete month.
Rates on fewer than 25 in the denominator are dimmed. Counts sit in their own columns and in
the CSV — hover any rate to see the numbers behind it.
Booking % by monthstraight-line miles from the lead’s zip centroid to the studio · bookings ÷ leads, lead cohort
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
≤ 25 mi
6.2%
5.4%
5.6%
5.4%
5.0%
2.4%
5.1%
25–50 mi
5.4%
4.7%
5.3%
5.0%
4.9%
2.8%
4.7%
50–100 mi
4.6%
4.0%
5.0%
5.2%
3.9%
1.9%
4.1%
100–200 mi
4.3%
3.0%
4.2%
4.2%
3.5%
2.5%
3.6%
200 mi +
3.4%
2.0%
3.7%
4.4%
3.4%
2.0%
3.1%
No zip / not geocoded
4.0%
2.3%
3.1%
5.0%
4.5%
1.6%
3.4%
All bands
5.3%
4.4%
5.2%
5.0%
4.4%
2.4%
4.6%
Show rate by month(on calendar − didn’t show) ÷ on calendar
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
≤ 25 mi
65.8%
64.2%
63.7%
63.9%
62.3%
67.0%
64.2%
25–50 mi
60.8%
61.3%
57.8%
58.8%
62.8%
56.7%
60.0%
50–100 mi
59.5%
58.0%
55.7%
55.6%
51.2%
62.5%
56.2%
100–200 mi
50.9%
59.5%
48.9%
50.5%
51.3%
66.7%
52.2%
200 mi +
59.8%
40.8%
52.4%
56.8%
48.4%
100.0%
52.6%
No zip / not geocoded
56.9%
60.5%
48.4%
55.6%
43.3%
100.0%
54.3%
All bands
61.9%
61.4%
59.2%
59.3%
58.2%
63.3%
60.2%
Lead→Show % by monthshowed ÷ leads — booking and showing combined
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
≤ 25 mi
4.4%
3.8%
4.0%
3.8%
3.1%
0.6%
3.4%
25–50 mi
3.6%
3.1%
3.5%
3.6%
3.0%
0.7%
2.9%
50–100 mi
3.2%
2.7%
3.2%
3.3%
2.1%
0.5%
2.5%
100–200 mi
2.7%
2.1%
2.7%
2.8%
2.1%
0.6%
2.2%
200 mi +
2.3%
1.1%
1.9%
2.8%
2.3%
0.4%
1.8%
No zip / not geocoded
2.5%
1.5%
2.0%
3.2%
2.3%
0.3%
2.0%
All bands
3.6%
3.0%
3.5%
3.5%
2.7%
0.6%
2.9%
Leads by monththe volume behind the rates above
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
≤ 25 mi
16,769
17,859
18,841
14,419
15,821
12,383
96,092
25–50 mi
8,614
10,653
9,305
6,528
7,786
7,382
50,268
50–100 mi
5,773
6,712
7,246
5,025
6,933
5,255
36,944
100–200 mi
4,293
5,468
4,073
5,130
6,465
3,236
28,665
200 mi +
2,685
2,907
1,145
1,492
1,373
705
10,307
No zip / not geocoded
1,623
1,551
744
462
572
374
5,326
All bands
39,757
45,150
41,354
33,056
38,950
29,335
227,602
Whole periodcounts and rates, each in its own column
Band
Leads
Bookings
Booking %
On calendar
Didn't show
Showed
Show rate
Lead→Show %
≤ 25 mi
96,092
4,923
5.1%
5,120
1,835
3,285
64.2%
3.4%
25–50 mi
50,268
2,375
4.7%
2,463
984
1,479
60.0%
2.9%
50–100 mi
36,944
1,522
4.1%
1,665
729
936
56.2%
2.5%
100–200 mi
28,665
1,043
3.6%
1,229
587
642
52.2%
2.2%
200 mi +
10,307
317
3.1%
361
171
190
52.6%
1.8%
No zip / not geocoded
5,326
179
3.4%
199
91
108
54.3%
2.0%
All bands
227,602
10,359
4.6%
11,037
4,397
6,640
60.2%
2.9%
Show rate by citywhole period — is the gradient real everywhere, or one city’s story?
Band
Boston
Dallas
Houston
New York
Chicago
Nashville
Florida
Orlando
All cities
≤ 25 mi
65.5%
61.4%
66.2%
60.0%
66.9%
61.8%
67.0%
66.1%
64.2%
25–50 mi
59.5%
61.6%
62.5%
51.3%
60.3%
59.9%
59.8%
61.9%
60.0%
50–100 mi
57.1%
52.0%
49.5%
52.5%
64.9%
54.7%
60.2%
52.2%
56.2%
100–200 mi
52.1%
49.1%
54.9%
47.1%
53.6%
52.1%
54.1%
53.9%
52.2%
200 mi +
66.7%
65.0%
55.2%
40.7%
51.6%
42.6%
50.0%
38.5%
52.6%
No zip / not geocoded
57.1%
58.5%
53.6%
55.6%
64.0%
42.1%
35.7%
0.0%
54.3%
All bands
61.5%
59.6%
61.6%
56.6%
63.5%
56.7%
61.8%
58.7%
60.2%
Booking % by citywhole period
Band
Boston
Dallas
Houston
New York
Chicago
Nashville
Florida
Orlando
All cities
≤ 25 mi
6.2%
5.5%
4.1%
5.0%
4.6%
6.7%
5.5%
4.6%
5.1%
25–50 mi
5.4%
5.5%
5.0%
4.4%
4.8%
7.0%
3.5%
4.2%
4.7%
50–100 mi
4.5%
4.9%
4.2%
4.0%
4.1%
4.3%
4.2%
3.6%
4.1%
100–200 mi
4.0%
3.6%
3.3%
2.7%
3.1%
4.6%
3.6%
3.9%
3.6%
200 mi +
2.5%
3.8%
4.3%
2.4%
2.0%
2.4%
3.7%
2.2%
3.1%
No zip / not geocoded
5.7%
4.7%
4.8%
2.1%
2.7%
2.5%
2.6%
0.5%
3.4%
All bands
5.5%
5.1%
4.2%
4.3%
4.3%
5.2%
4.3%
4.0%
4.6%
Basis. Every number hangs off the LEAD, in the month the lead came in.
Booking % = bookings ÷ leads. Show rate = (on calendar − didn’t show) ÷ on calendar.
Lead→Show % = showed ÷ leads — the net output of the leads bought.
Why “on calendar” is the show denominator. The bookings feed carries no appointment
date, so a booking made for a shoot next month would otherwise count as a show. The roster is
keyed to the APPOINTMENT date and is pulled only up to today, so it holds exactly the
appointments that have already come round. Cancellations count against the rate, same as
/show-rate and the CRM’s own Show Rate report.
Distance. Miles = straight line from the lead’s zip centroid to the studio; Florida
codes take whichever of Parkland / Orlando is nearer. Drive time = the 3-digit prefix table from
studio1_drive_pop.xlsx. A zip with no geocode, or a prefix not on the drive table, gets its own
row rather than being quietly dropped.
Excluded. Recycled codes (never bought, and a re-contact of an old lead is a different
question) and codes with no city (no studio to measure from).
Nov 26 is a part month — marked * — and immature on both
rates: those leads have not finished booking, and most of the appointments they did book are
still in the future. Read the last complete month.
Rates on fewer than 25 in the denominator are dimmed. Counts sit in their own columns and in
the CSV — hover any rate to see the numbers behind it.
Booking % by monthdrive hours from the 3-digit zip prefix table · bookings ÷ leads, lead cohort
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
≤ 30 min
5.8%
5.0%
5.4%
5.3%
4.9%
2.6%
4.9%
30–60 min
5.8%
5.3%
5.6%
5.1%
4.8%
2.7%
4.9%
1–2 h
4.4%
4.1%
4.8%
4.6%
3.9%
1.6%
4.0%
2–3 h
4.5%
3.4%
4.9%
4.7%
3.7%
2.2%
4.0%
3–4 h
4.9%
2.8%
4.5%
5.3%
3.8%
2.9%
4.0%
4 h +
4.4%
2.1%
4.3%
3.6%
3.3%
2.0%
3.3%
Prefix not on the drive table
3.6%
2.3%
4.0%
4.9%
5.1%
2.3%
3.5%
All bands
5.3%
4.4%
5.2%
5.0%
4.4%
2.4%
4.6%
Show rate by month(on calendar − didn’t show) ÷ on calendar
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
≤ 30 min
64.4%
63.5%
62.5%
62.9%
64.0%
60.3%
63.4%
30–60 min
63.8%
62.0%
57.4%
63.0%
56.9%
66.0%
60.8%
1–2 h
61.6%
57.5%
57.4%
53.4%
51.3%
65.5%
56.7%
2–3 h
50.3%
59.1%
50.4%
52.3%
55.2%
65.2%
53.6%
3–4 h
50.8%
65.2%
55.7%
52.4%
48.8%
56.3%
53.5%
4 h +
63.8%
35.3%
52.9%
55.6%
45.8%
100.0%
53.7%
Prefix not on the drive table
50.0%
50.0%
48.3%
44.4%
45.5%
100.0%
48.7%
All bands
61.9%
61.4%
59.2%
59.3%
58.2%
63.3%
60.2%
Lead→Show % by monthshowed ÷ leads — booking and showing combined
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
≤ 30 min
4.1%
3.5%
3.8%
3.7%
3.1%
0.6%
3.3%
30–60 min
4.0%
3.6%
3.6%
3.7%
2.6%
0.7%
3.1%
1–2 h
3.0%
2.8%
3.1%
3.0%
2.1%
0.4%
2.4%
2–3 h
2.8%
2.4%
3.1%
2.9%
2.3%
0.6%
2.4%
3–4 h
3.0%
2.2%
3.1%
3.4%
2.4%
0.5%
2.5%
4 h +
3.2%
0.8%
2.8%
2.9%
1.8%
0.6%
2.1%
Prefix not on the drive table
2.1%
1.5%
2.5%
2.7%
2.9%
0.6%
2.0%
All bands
3.6%
3.0%
3.5%
3.5%
2.7%
0.6%
2.9%
Leads by monththe volume behind the rates above
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
≤ 30 min
20,418
22,886
21,920
16,475
18,162
14,236
114,097
30–60 min
5,223
5,964
6,112
4,414
5,525
5,043
32,281
1–2 h
5,494
5,952
5,979
4,225
5,569
4,718
31,937
2–3 h
3,034
4,125
3,717
3,107
4,124
2,348
20,455
3–4 h
2,052
2,678
2,089
2,855
3,543
1,871
15,088
4 h +
2,088
2,193
969
1,529
1,501
809
9,089
Prefix not on the drive table
1,448
1,352
568
451
526
310
4,655
All bands
39,757
45,150
41,354
33,056
38,950
29,335
227,602
Whole periodcounts and rates, each in its own column
Band
Leads
Bookings
Booking %
On calendar
Didn't show
Showed
Show rate
Lead→Show %
≤ 30 min
114,097
5,632
4.9%
5,870
2,149
3,721
63.4%
3.3%
30–60 min
32,281
1,584
4.9%
1,624
637
987
60.8%
3.1%
1–2 h
31,937
1,265
4.0%
1,373
594
779
56.7%
2.4%
2–3 h
20,455
809
4.0%
926
430
496
53.6%
2.4%
3–4 h
15,088
606
4.0%
699
325
374
53.5%
2.5%
4 h +
9,089
301
3.3%
352
163
189
53.7%
2.1%
Prefix not on the drive table
4,655
162
3.5%
193
99
94
48.7%
2.0%
All bands
227,602
10,359
4.6%
11,037
4,397
6,640
60.2%
2.9%
Show rate by citywhole period — is the gradient real everywhere, or one city’s story?
Band
Boston
Dallas
Houston
New York
Chicago
Nashville
Florida
Orlando
All cities
≤ 30 min
65.3%
61.3%
66.4%
60.8%
65.8%
61.9%
64.1%
60.1%
63.4%
30–60 min
59.6%
60.4%
—
53.6%
65.5%
38.9%
62.2%
65.3%
60.8%
1–2 h
59.4%
54.1%
56.0%
50.5%
65.3%
49.5%
61.7%
54.0%
56.7%
2–3 h
48.9%
52.3%
56.4%
59.7%
53.4%
51.1%
50.9%
55.4%
53.6%
3–4 h
54.8%
52.7%
52.9%
36.6%
56.3%
56.2%
—
54.5%
53.5%
4 h +
64.7%
63.2%
60.4%
43.2%
51.1%
42.7%
40.0%
60.0%
53.7%
Prefix not on the drive table
50.0%
56.3%
41.5%
43.8%
54.5%
40.0%
48.0%
50.0%
48.7%
All bands
61.5%
59.6%
61.6%
56.6%
63.5%
56.7%
61.8%
58.7%
60.2%
Booking % by citywhole period
Band
Boston
Dallas
Houston
New York
Chicago
Nashville
Florida
Orlando
All cities
≤ 30 min
6.3%
5.6%
4.2%
4.7%
4.6%
6.8%
4.3%
4.3%
4.9%
30–60 min
5.2%
5.1%
—
4.9%
4.9%
3.5%
5.0%
4.4%
4.9%
1–2 h
4.4%
3.7%
4.7%
4.3%
3.8%
3.1%
4.0%
3.4%
4.0%
2–3 h
3.9%
5.2%
3.7%
3.5%
3.5%
4.7%
4.0%
4.0%
4.0%
3–4 h
4.9%
4.1%
3.3%
3.4%
3.6%
4.9%
—
3.3%
4.0%
4 h +
4.3%
4.6%
4.3%
2.1%
2.6%
2.9%
2.6%
3.5%
3.3%
Prefix not on the drive table
5.5%
3.6%
3.6%
3.1%
2.3%
2.1%
6.8%
1.9%
3.5%
All bands
5.5%
5.1%
4.2%
4.3%
4.3%
5.2%
4.3%
4.0%
4.6%
Basis. Every number hangs off the LEAD, in the month the lead came in.
Booking % = bookings ÷ leads. Show rate = (on calendar − didn’t show) ÷ on calendar.
Lead→Show % = showed ÷ leads — the net output of the leads bought.
Why “on calendar” is the show denominator. The bookings feed carries no appointment
date, so a booking made for a shoot next month would otherwise count as a show. The roster is
keyed to the APPOINTMENT date and is pulled only up to today, so it holds exactly the
appointments that have already come round. Cancellations count against the rate, same as
/show-rate and the CRM’s own Show Rate report.
Distance. Miles = straight line from the lead’s zip centroid to the studio; Florida
codes take whichever of Parkland / Orlando is nearer. Drive time = the 3-digit prefix table from
studio1_drive_pop.xlsx. A zip with no geocode, or a prefix not on the drive table, gets its own
row rather than being quietly dropped.
Excluded. Recycled codes (never bought, and a re-contact of an old lead is a different
question) and codes with no city (no studio to measure from).
Nov 26 is a part month — marked * — and immature on both
rates: those leads have not finished booking, and most of the appointments they did book are
still in the future. Read the last complete month.
Rates on fewer than 25 in the denominator are dimmed. Counts sit in their own columns and in
the CSV — hover any rate to see the numbers behind it.
Booking % by monththe age on the lead record — the model’s age, not the parent’s · bookings ÷ leads, lead cohort
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
Under 18
5.8%
4.5%
5.8%
5.5%
4.1%
2.2%
4.6%
18–24
7.2%
6.3%
6.7%
6.4%
6.3%
3.8%
6.3%
25–34
6.0%
5.2%
6.0%
5.6%
5.9%
3.5%
5.5%
35–44
3.3%
3.5%
3.7%
3.8%
4.0%
1.6%
3.5%
45–54
1.9%
1.9%
2.0%
2.4%
2.6%
1.6%
2.1%
55 +
1.7%
1.7%
1.5%
2.0%
2.2%
1.3%
1.8%
All bands
5.3%
4.4%
5.2%
5.0%
4.4%
2.4%
4.6%
Show rate by month(on calendar − didn’t show) ÷ on calendar
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
Under 18
70.1%
67.1%
63.2%
60.1%
63.7%
63.3%
65.1%
18–24
55.8%
57.1%
60.2%
61.5%
52.5%
55.9%
57.5%
25–34
57.7%
56.0%
55.4%
56.9%
57.2%
68.6%
56.8%
35–44
53.7%
61.5%
52.0%
53.3%
54.9%
77.8%
55.3%
45–54
56.8%
57.1%
54.4%
58.2%
55.1%
66.7%
56.8%
55 +
45.0%
45.8%
57.7%
63.3%
57.4%
60.0%
54.2%
All bands
61.9%
61.4%
59.2%
59.2%
58.2%
63.3%
60.2%
Lead→Show % by monthshowed ÷ leads — booking and showing combined
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
Under 18
4.3%
3.3%
4.2%
3.8%
2.6%
0.5%
3.1%
18–24
4.5%
4.3%
4.6%
4.6%
3.8%
0.8%
4.0%
25–34
3.9%
3.2%
3.8%
3.6%
3.6%
0.8%
3.4%
35–44
2.1%
2.2%
2.3%
2.4%
2.2%
0.5%
2.1%
45–54
1.4%
1.2%
1.5%
1.8%
1.3%
0.5%
1.3%
55 +
1.0%
1.0%
0.9%
1.5%
1.2%
0.4%
1.0%
All bands
3.6%
3.0%
3.5%
3.5%
2.7%
0.6%
2.9%
Leads by monththe volume behind the rates above
Band
Jun 26
Jul 26
Aug 26
Sep 26
Oct 26
Nov 26 *
All months
Under 18
16,223
19,817
14,551
11,562
17,280
14,455
93,888
18–24
7,672
7,769
8,079
7,101
6,820
4,831
42,272
25–34
6,259
6,347
7,410
5,405
4,597
2,946
32,964
35–44
4,563
5,010
5,858
4,337
4,343
2,547
26,658
45–54
3,279
3,970
3,760
2,617
3,258
3,104
19,988
55 +
1,758
2,234
1,696
2,031
2,648
1,452
11,819
All bands
39,754
45,147
41,354
33,053
38,946
29,335
227,589
Whole periodcounts and rates, each in its own column
Band
Leads
Bookings
Booking %
On calendar
Didn't show
Showed
Show rate
Lead→Show %
Under 18
93,888
4,343
4.6%
4,470
1,558
2,912
65.1%
3.1%
18–24
42,272
2,651
6.3%
2,923
1,243
1,680
57.5%
4.0%
25–34
32,964
1,819
5.5%
1,968
851
1,117
56.8%
3.4%
35–44
26,658
920
3.5%
999
447
552
55.3%
2.1%
45–54
19,988
411
2.1%
449
194
255
56.8%
1.3%
55 +
11,819
213
1.8%
227
104
123
54.2%
1.0%
All bands
227,589
10,357
4.6%
11,036
4,397
6,639
60.2%
2.9%
Show rate by citywhole period — is the gradient real everywhere, or one city’s story?
Band
Boston
Dallas
Houston
New York
Chicago
Nashville
Florida
Orlando
All cities
Under 18
67.0%
66.0%
70.0%
58.2%
68.9%
59.7%
67.3%
65.5%
65.1%
18–24
58.4%
56.4%
58.8%
53.8%
62.3%
55.1%
54.1%
59.2%
57.5%
25–34
56.1%
60.8%
54.4%
53.7%
60.3%
56.9%
50.7%
58.3%
56.8%
35–44
58.8%
45.7%
54.0%
56.0%
56.3%
55.2%
61.0%
56.9%
55.3%
45–54
60.9%
52.1%
55.4%
64.3%
62.3%
48.4%
56.5%
59.4%
56.8%
55 +
40.9%
52.4%
66.7%
62.5%
62.5%
42.3%
57.6%
52.4%
54.2%
All bands
61.5%
59.6%
61.6%
56.6%
63.5%
56.7%
61.8%
58.7%
60.2%
Booking % by citywhole period
Band
Boston
Dallas
Houston
New York
Chicago
Nashville
Florida
Orlando
All cities
Under 18
6.1%
5.3%
4.1%
4.1%
4.1%
5.6%
4.4%
3.7%
4.6%
18–24
6.9%
6.6%
5.8%
6.1%
5.9%
7.4%
6.2%
5.7%
6.3%
25–34
6.3%
6.3%
5.1%
5.5%
5.0%
6.1%
5.0%
5.3%
5.5%
35–44
3.9%
4.0%
2.7%
3.1%
3.5%
3.9%
3.2%
3.4%
3.5%
45–54
2.3%
2.2%
2.1%
2.2%
2.2%
2.3%
1.7%
1.7%
2.1%
55 +
1.9%
2.1%
2.4%
1.0%
1.4%
1.5%
2.0%
1.7%
1.8%
All bands
5.5%
5.1%
4.2%
4.3%
4.3%
5.2%
4.3%
4.0%
4.6%
Distance and age crossed, whole period — does distance bite harder on a child
shoot than an adult one? Read a ROW to see what age does at a fixed distance, a COLUMN to see
what distance does at a fixed age. Cells under 25 in the denominator are dimmed; hover any
rate for the counts behind it.
Cash per lead · distance × kids/adultsthe buyable shape — distance bites an adult lead far harder than a child one
Distance
Kids (under 18)
Adults (18+)
All ages
≤ 25 mi
$25.59
$17.46
$20.62
25–50 mi
$24.98
$16.97
$20.34
50–100 mi
$22.58
$13.94
$17.65
100–200 mi
$21.27
$15.12
$17.89
200 mi +
$21.34
$11.12
$15.29
No zip / not geocoded
$11.55
$15.94
$13.92
All distances
$23.79
$16.20
$19.33
Show rate · distance × kids/adults
Distance
Kids (under 18)
Adults (18+)
All ages
≤ 25 mi
68.7%
61.1%
64.2%
25–50 mi
66.3%
55.5%
60.0%
50–100 mi
60.1%
53.6%
56.2%
100–200 mi
55.8%
49.6%
52.2%
200 mi +
60.4%
48.0%
52.6%
No zip / not geocoded
73.3%
48.7%
54.3%
All distances
65.1%
56.8%
60.2%
Booking % · distance × kids/adults
Distance
Kids (under 18)
Adults (18+)
All ages
≤ 25 mi
5.5%
4.9%
5.1%
25–50 mi
4.8%
4.6%
4.7%
50–100 mi
4.1%
4.1%
4.1%
100–200 mi
3.5%
3.7%
3.6%
200 mi +
2.7%
3.4%
3.1%
No zip / not geocoded
1.9%
4.6%
3.4%
All distances
4.6%
4.5%
4.6%
Cash per lead · distance × agethe two effects compound — this is the one that ranks the combinations
Distance
Under 18
18–24
25–34
35–44
45–54
55 +
All ages
≤ 25 mi
$25.59
$21.62
$20.12
$16.99
$9.27
$8.11
$20.62
25–50 mi
$24.98
$20.24
$22.67
$11.18
$14.01
$8.11
$20.34
50–100 mi
$22.58
$16.82
$19.15
$6.88
$10.57
$14.42
$17.65
100–200 mi
$21.27
$18.58
$16.61
$15.09
$8.88
$10.12
$17.89
200 mi +
$21.34
$21.76
$9.76
$5.22
$2.05
$4.56
$15.29
No zip / not geocoded
$11.55
$17.35
$24.74
$9.77
$0.00
$0.00
$13.92
All distances
$23.79
$20.12
$19.82
$13.22
$10.05
$9.25
$19.33
Best and worst combinations
Best three:
≤ 25 mi · Under 18 — $25.59 per lead on 37,300 leads
25–50 mi · Under 18 — $24.98 per lead on 21,164 leads
25–50 mi · 25–34 — $22.67 per lead on 6,864 leads
Worst three:
50–100 mi · 35–44 — $6.88 per lead on 4,435 leads
25–50 mi · 55 + — $8.11 per lead on 2,497 leads
≤ 25 mi · 55 + — $8.11 per lead on 4,874 leads
≤ 25 mi · Under 18 is worth 3.7× 50–100 mi · 35–44.
Distance and age are separate effects and they stack, so the spread across the matrix is far
wider than either dimension on its own. Cells under 2,000 leads are excluded from this
ranking and dimmed in the table — a thin cell will always look extreme.
Show rate · distance × age
Distance
Under 18
18–24
25–34
35–44
45–54
55 +
All ages
≤ 25 mi
68.7%
63.0%
58.9%
59.4%
67.2%
56.3%
64.2%
25–50 mi
66.3%
55.4%
55.8%
57.0%
52.8%
52.3%
60.0%
50–100 mi
60.1%
53.9%
58.9%
42.7%
52.9%
56.1%
56.2%
100–200 mi
55.8%
47.0%
50.8%
55.3%
47.5%
51.7%
52.2%
200 mi +
60.4%
54.7%
41.7%
41.4%
35.3%
43.8%
52.6%
No zip / not geocoded
73.3%
51.6%
41.0%
53.3%
25.0%
100.0%
54.3%
All distances
65.1%
57.5%
56.8%
55.3%
56.8%
54.2%
60.2%
Booking % · distance × age
Distance
Under 18
18–24
25–34
35–44
45–54
55 +
All ages
≤ 25 mi
5.5%
6.7%
6.0%
3.7%
2.2%
1.9%
5.1%
25–50 mi
4.8%
6.6%
5.6%
3.7%
2.1%
1.8%
4.7%
50–100 mi
4.1%
5.9%
5.5%
3.1%
2.1%
1.5%
4.1%
100–200 mi
3.5%
5.3%
4.3%
3.0%
1.9%
1.8%
3.6%
200 mi +
2.7%
5.1%
3.5%
2.4%
1.3%
2.4%
3.1%
No zip / not geocoded
1.9%
5.5%
4.6%
4.4%
1.2%
0.8%
3.4%
All distances
4.6%
6.3%
5.5%
3.5%
2.1%
1.8%
4.6%
Joins. bookings 10,359 of 13,259 feed rows landed on a lead in this window,
roster 11,037 of 18,585, no-show 4,397 of 7,883,
viewings 6,187 of 9,603 carrying 4,468 sales.
Unmatched rows belong to leads from outside the window — the appointment and sales feeds run to
today, so they carry earlier and later cohorts too, and RECYCLED leads are excluded from this
report entirely. They are not lost bookings or lost sales. The money here is therefore the
economics of FRESH bought leads, which is exactly the basis a cost-per-lead decision needs.
Coverage. 1,544 of 227,602 leads had no readable zip,
3,782 had a zip with no geocode and 3,111 a prefix not on the drive
table — each sits in its own band rather than being folded into a real one.
13 leads had no usable age and are left out of the age tables entirely
(they still count in the distance tables). Dropped before any of this: 74,873
recycled, 5,766 with no city.