Share:

Distance & Age — booking % and show rate

Does the show rate rise as the client gets closer? And does age move it? · 2026-06-01 → 2026-11-17 · Download every band × month and band × city (CSV)
Leads
227,602
2026-06-01 → 2026-11-17 · 6 months
Booking %
4.6%
10,359 bookings
Show rate
60.2%
6,640 of 11,037 appointments due
Lead→Show %
2.9%
the net output of the leads

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.
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

BandLeadsBookingsBooking % On calendarDidn't showShowed Show rateLead→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

BandLeadsBookingsBooking % On calendarDidn't showShowed Show rateLead→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

BandLeadsBookingsBooking % On calendarDidn't showShowed Show rateLead→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

CityLeads BookingsBooking %On calendar ShowedShow rateLead→Show %
Boston23,234 1,2755.5% 1,248768 61.5%3.3%
Dallas28,573 1,4585.1% 1,655986 59.6%3.5%
Houston28,963 1,2104.2% 1,363840 61.6%2.9%
New York31,578 1,3724.3% 1,419803 56.6%2.5%
Chicago32,350 1,3784.3% 1,491947 63.5%2.9%
Nashville19,372 1,0095.2% 1,193676 56.7%3.5%
Florida40,411 1,7424.3% 1,7341,072 61.8%2.7%
Orlando23,121 9154.0% 934548 58.7%2.4%
All cities227,602 10,3594.6% 11,0376,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

BandLeadsBooking %Show rate SeenSoldClose % Avg dealCash up front / saleCash % of deal Revenue / leadCash / leadIndex
≤ 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

BandLeadsCash / 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

BandLeadsBooking %Show rate SeenSoldClose % Avg dealCash up front / saleCash % of deal Revenue / leadCash / leadIndex
≤ 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

BandLeadsCash / 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

BandLeadsBooking %Show rate SeenSoldClose % Avg dealCash up front / saleCash % of deal Revenue / leadCash / leadIndex
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

BandLeadsCash / 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,000 including 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.
BandBostonDallasHoustonNew YorkChicagoNashvilleFloridaOrlandoAll 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 — ceilingKids — paidKids — margin Adults — ceilingAdults — paidAdults — 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

BandLeadsContracted / lead Cash on the dayBanked share Banked / lead, 1st cycleBanked / lead, lifetime Max CPLvs $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

BandLeadsContracted / lead Cash on the dayBanked share Banked / lead, 1st cycleBanked / lead, lifetime Max CPLvs $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

BandLeadsContracted / lead Cash on the dayBanked share Banked / lead, 1st cycleBanked / lead, lifetime Max CPLvs $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.
DistanceKids (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

DistanceUnder 1818–2425–3435–4445–5455 +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

BandBostonDallasHoustonNew YorkChicagoNashvilleFloridaOrlandoAll 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

BandBostonDallasHoustonNew YorkChicagoNashvilleFloridaOrlandoAll 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

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
≤ 25 mi6.2%5.4%5.6%5.4%5.0%2.4%5.1%
25–50 mi5.4%4.7%5.3%5.0%4.9%2.8%4.7%
50–100 mi4.6%4.0%5.0%5.2%3.9%1.9%4.1%
100–200 mi4.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 geocoded4.0%2.3%3.1%5.0%4.5%1.6%3.4%
All bands5.3%4.4%5.2%5.0%4.4%2.4%4.6%

Show rate by month(on calendar − didn’t show) ÷ on calendar

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
≤ 25 mi65.8%64.2%63.7%63.9%62.3%67.0%64.2%
25–50 mi60.8%61.3%57.8%58.8%62.8%56.7%60.0%
50–100 mi59.5%58.0%55.7%55.6%51.2%62.5%56.2%
100–200 mi50.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 geocoded56.9%60.5%48.4%55.6%43.3%100.0%54.3%
All bands61.9%61.4%59.2%59.3%58.2%63.3%60.2%

Lead→Show % by monthshowed ÷ leads — booking and showing combined

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
≤ 25 mi4.4%3.8%4.0%3.8%3.1%0.6%3.4%
25–50 mi3.6%3.1%3.5%3.6%3.0%0.7%2.9%
50–100 mi3.2%2.7%3.2%3.3%2.1%0.5%2.5%
100–200 mi2.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 geocoded2.5%1.5%2.0%3.2%2.3%0.3%2.0%
All bands3.6%3.0%3.5%3.5%2.7%0.6%2.9%

Leads by monththe volume behind the rates above

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
≤ 25 mi16,76917,85918,84114,41915,82112,38396,092
25–50 mi8,61410,6539,3056,5287,7867,38250,268
50–100 mi5,7736,7127,2465,0256,9335,25536,944
100–200 mi4,2935,4684,0735,1306,4653,23628,665
200 mi +2,6852,9071,1451,4921,37370510,307
No zip / not geocoded1,6231,5517444625723745,326
All bands39,75745,15041,35433,05638,95029,335227,602

Whole periodcounts and rates, each in its own column

BandLeadsBookingsBooking % On calendarDidn't showShowed Show rateLead→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?

BandBostonDallasHoustonNew YorkChicagoNashvilleFloridaOrlandoAll cities
≤ 25 mi65.5%61.4%66.2%60.0%66.9%61.8%67.0%66.1%64.2%
25–50 mi59.5%61.6%62.5%51.3%60.3%59.9%59.8%61.9%60.0%
50–100 mi57.1%52.0%49.5%52.5%64.9%54.7%60.2%52.2%56.2%
100–200 mi52.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 geocoded57.1%58.5%53.6%55.6%64.0%42.1%35.7%0.0%54.3%
All bands61.5%59.6%61.6%56.6%63.5%56.7%61.8%58.7%60.2%

Booking % by citywhole period

BandBostonDallasHoustonNew YorkChicagoNashvilleFloridaOrlandoAll cities
≤ 25 mi6.2%5.5%4.1%5.0%4.6%6.7%5.5%4.6%5.1%
25–50 mi5.4%5.5%5.0%4.4%4.8%7.0%3.5%4.2%4.7%
50–100 mi4.5%4.9%4.2%4.0%4.1%4.3%4.2%3.6%4.1%
100–200 mi4.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 geocoded5.7%4.7%4.8%2.1%2.7%2.5%2.6%0.5%3.4%
All bands5.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

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
≤ 30 min5.8%5.0%5.4%5.3%4.9%2.6%4.9%
30–60 min5.8%5.3%5.6%5.1%4.8%2.7%4.9%
1–2 h4.4%4.1%4.8%4.6%3.9%1.6%4.0%
2–3 h4.5%3.4%4.9%4.7%3.7%2.2%4.0%
3–4 h4.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 table3.6%2.3%4.0%4.9%5.1%2.3%3.5%
All bands5.3%4.4%5.2%5.0%4.4%2.4%4.6%

Show rate by month(on calendar − didn’t show) ÷ on calendar

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
≤ 30 min64.4%63.5%62.5%62.9%64.0%60.3%63.4%
30–60 min63.8%62.0%57.4%63.0%56.9%66.0%60.8%
1–2 h61.6%57.5%57.4%53.4%51.3%65.5%56.7%
2–3 h50.3%59.1%50.4%52.3%55.2%65.2%53.6%
3–4 h50.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 table50.0%50.0%48.3%44.4%45.5%100.0%48.7%
All bands61.9%61.4%59.2%59.3%58.2%63.3%60.2%

Lead→Show % by monthshowed ÷ leads — booking and showing combined

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
≤ 30 min4.1%3.5%3.8%3.7%3.1%0.6%3.3%
30–60 min4.0%3.6%3.6%3.7%2.6%0.7%3.1%
1–2 h3.0%2.8%3.1%3.0%2.1%0.4%2.4%
2–3 h2.8%2.4%3.1%2.9%2.3%0.6%2.4%
3–4 h3.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 table2.1%1.5%2.5%2.7%2.9%0.6%2.0%
All bands3.6%3.0%3.5%3.5%2.7%0.6%2.9%

Leads by monththe volume behind the rates above

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
≤ 30 min20,41822,88621,92016,47518,16214,236114,097
30–60 min5,2235,9646,1124,4145,5255,04332,281
1–2 h5,4945,9525,9794,2255,5694,71831,937
2–3 h3,0344,1253,7173,1074,1242,34820,455
3–4 h2,0522,6782,0892,8553,5431,87115,088
4 h +2,0882,1939691,5291,5018099,089
Prefix not on the drive table1,4481,3525684515263104,655
All bands39,75745,15041,35433,05638,95029,335227,602

Whole periodcounts and rates, each in its own column

BandLeadsBookingsBooking % On calendarDidn't showShowed Show rateLead→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?

BandBostonDallasHoustonNew YorkChicagoNashvilleFloridaOrlandoAll cities
≤ 30 min65.3%61.3%66.4%60.8%65.8%61.9%64.1%60.1%63.4%
30–60 min59.6%60.4%—53.6%65.5%38.9%62.2%65.3%60.8%
1–2 h59.4%54.1%56.0%50.5%65.3%49.5%61.7%54.0%56.7%
2–3 h48.9%52.3%56.4%59.7%53.4%51.1%50.9%55.4%53.6%
3–4 h54.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 table50.0%56.3%41.5%43.8%54.5%40.0%48.0%50.0%48.7%
All bands61.5%59.6%61.6%56.6%63.5%56.7%61.8%58.7%60.2%

Booking % by citywhole period

BandBostonDallasHoustonNew YorkChicagoNashvilleFloridaOrlandoAll cities
≤ 30 min6.3%5.6%4.2%4.7%4.6%6.8%4.3%4.3%4.9%
30–60 min5.2%5.1%—4.9%4.9%3.5%5.0%4.4%4.9%
1–2 h4.4%3.7%4.7%4.3%3.8%3.1%4.0%3.4%4.0%
2–3 h3.9%5.2%3.7%3.5%3.5%4.7%4.0%4.0%4.0%
3–4 h4.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 table5.5%3.6%3.6%3.1%2.3%2.1%6.8%1.9%3.5%
All bands5.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

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
Under 185.8%4.5%5.8%5.5%4.1%2.2%4.6%
18–247.2%6.3%6.7%6.4%6.3%3.8%6.3%
25–346.0%5.2%6.0%5.6%5.9%3.5%5.5%
35–443.3%3.5%3.7%3.8%4.0%1.6%3.5%
45–541.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 bands5.3%4.4%5.2%5.0%4.4%2.4%4.6%

Show rate by month(on calendar − didn’t show) ÷ on calendar

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
Under 1870.1%67.1%63.2%60.1%63.7%63.3%65.1%
18–2455.8%57.1%60.2%61.5%52.5%55.9%57.5%
25–3457.7%56.0%55.4%56.9%57.2%68.6%56.8%
35–4453.7%61.5%52.0%53.3%54.9%77.8%55.3%
45–5456.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 bands61.9%61.4%59.2%59.2%58.2%63.3%60.2%

Lead→Show % by monthshowed ÷ leads — booking and showing combined

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
Under 184.3%3.3%4.2%3.8%2.6%0.5%3.1%
18–244.5%4.3%4.6%4.6%3.8%0.8%4.0%
25–343.9%3.2%3.8%3.6%3.6%0.8%3.4%
35–442.1%2.2%2.3%2.4%2.2%0.5%2.1%
45–541.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 bands3.6%3.0%3.5%3.5%2.7%0.6%2.9%

Leads by monththe volume behind the rates above

BandJun 26Jul 26Aug 26Sep 26Oct 26Nov 26 *All months
Under 1816,22319,81714,55111,56217,28014,45593,888
18–247,6727,7698,0797,1016,8204,83142,272
25–346,2596,3477,4105,4054,5972,94632,964
35–444,5635,0105,8584,3374,3432,54726,658
45–543,2793,9703,7602,6173,2583,10419,988
55 +1,7582,2341,6962,0312,6481,45211,819
All bands39,75445,14741,35433,05338,94629,335227,589

Whole periodcounts and rates, each in its own column

BandLeadsBookingsBooking % On calendarDidn't showShowed Show rateLead→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?

BandBostonDallasHoustonNew YorkChicagoNashvilleFloridaOrlandoAll cities
Under 1867.0%66.0%70.0%58.2%68.9%59.7%67.3%65.5%65.1%
18–2458.4%56.4%58.8%53.8%62.3%55.1%54.1%59.2%57.5%
25–3456.1%60.8%54.4%53.7%60.3%56.9%50.7%58.3%56.8%
35–4458.8%45.7%54.0%56.0%56.3%55.2%61.0%56.9%55.3%
45–5460.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 bands61.5%59.6%61.6%56.6%63.5%56.7%61.8%58.7%60.2%

Booking % by citywhole period

BandBostonDallasHoustonNew YorkChicagoNashvilleFloridaOrlandoAll cities
Under 186.1%5.3%4.1%4.1%4.1%5.6%4.4%3.7%4.6%
18–246.9%6.6%5.8%6.1%5.9%7.4%6.2%5.7%6.3%
25–346.3%6.3%5.1%5.5%5.0%6.1%5.0%5.3%5.5%
35–443.9%4.0%2.7%3.1%3.5%3.9%3.2%3.4%3.5%
45–542.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 bands5.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

DistanceKids (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

DistanceKids (under 18)Adults (18+)All ages
≤ 25 mi68.7%61.1%64.2%
25–50 mi66.3%55.5%60.0%
50–100 mi60.1%53.6%56.2%
100–200 mi55.8%49.6%52.2%
200 mi +60.4%48.0%52.6%
No zip / not geocoded73.3%48.7%54.3%
All distances65.1%56.8%60.2%

Booking % · distance × kids/adults

DistanceKids (under 18)Adults (18+)All ages
≤ 25 mi5.5%4.9%5.1%
25–50 mi4.8%4.6%4.7%
50–100 mi4.1%4.1%4.1%
100–200 mi3.5%3.7%3.6%
200 mi +2.7%3.4%3.1%
No zip / not geocoded1.9%4.6%3.4%
All distances4.6%4.5%4.6%

Cash per lead · distance × agethe two effects compound — this is the one that ranks the combinations

DistanceUnder 1818–2425–3435–4445–5455 +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

DistanceUnder 1818–2425–3435–4445–5455 +All ages
≤ 25 mi68.7%63.0%58.9%59.4%67.2%56.3%64.2%
25–50 mi66.3%55.4%55.8%57.0%52.8%52.3%60.0%
50–100 mi60.1%53.9%58.9%42.7%52.9%56.1%56.2%
100–200 mi55.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 geocoded73.3%51.6%41.0%53.3%25.0%100.0%54.3%
All distances65.1%57.5%56.8%55.3%56.8%54.2%60.2%

Booking % · distance × age

DistanceUnder 1818–2425–3435–4445–5455 +All ages
≤ 25 mi5.5%6.7%6.0%3.7%2.2%1.9%5.1%
25–50 mi4.8%6.6%5.6%3.7%2.1%1.8%4.7%
50–100 mi4.1%5.9%5.5%3.1%2.1%1.5%4.1%
100–200 mi3.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 geocoded1.9%5.5%4.6%4.4%1.2%0.8%3.4%
All distances4.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.