Share:

Deal economics by lead source

Jun 2026 – Aug 2026 · 126,262 bought leads, 6,287 bookings, 4,446 sales · built 2026-11-17 15:49 UTC
This is not built on Square, because Square cannot answer it. A Square payment row carries city · loc · id · at · status · amt · cust · brand · entry · reason — no name, no phone, no booking reference and no marketing code. cust is a Square customer id, and the import that would map those ids to our customers has never run live (all 45 square_customer_import logs say "live": false). So a Square payment cannot be attributed to a lead source. The CRM's own payment schedules hold the same money keyed by booking reference, and the booking reference carries the marketing code — so first payment and first-3-payment behaviour below is measured from the CRM. Run the Square customer import live and the two can be cross-checked.
Cost per booking
$300
across everything we buy
Cost per show
$499
show rate 64.15%
Money upfront per sale
$785
4,446 sales
Contracted per deal
$2,046
a promise, not cash
Collected per deal
$977
47.73% of contracted, so far
First instalment paid
57.88%
1,013 missed it

The five measures, by source

Source groupFresh leadsAd spendBookings 1 · Cost per bookingAttendance (appt basis)Shows expected2 · Cost per show Sales in window3 · Money upfront4 · Revenue per deal 5 · Collected per dealCollected of contracted
Blue Rooms KIDS32,703$468,5912,222$21167.5% 1,866 appts1,499$3131,639$930$2,170$1,13752.38%
Blue Rooms ADULT23,199$298,5331,454$20559.1% 1,235 appts859$348865$742$1,977$91045.97%
Blue Rooms GOOGLE25,381$364,620562$64959.5% 580 appts334$1,092342$729$2,076$89643.15%
Alan ADULT25,823$382,1891,131$33851.3% 1,380 appts580$659967$707$1,947$89746.07%
Lead Pronto LP219,156$372,130918$40560.1% 830 appts552$674633$620$1,957$82141.95%
Lead Pronto other2$340—100.0% 1 appts0—1$50$50$50100.00%
Recycled0—0—53.7% 1,210 appts0—762$662$1,933$85043.94%
TOTAL bought126,262 $1,886,063 6,287 $300 60.1% 5,891 appts 3,779 $499 4,446$785 $2,046$977 47.73%
Cost per booking and cost per show are that group's ad spend over what it produced. Showed is that group's own leads that went on to turn up — every roster row joined back to the lead that produced it, with cancellations counted as did-not-show. It is the same cohort as the bookings beside it, so booking → show reads as a real funnel: a lead only reaches the calendar if it was matched as booked, and only shows if it reached the calendar, so each step is smaller than the one before it. The roster name-match is not even across sources — Blue Rooms matches 85–89% of its roster rows on name + code, Lead Pronto 68% and Alan 62%. Where the match is weaker the on-calendar and showed counts are FLOORS, so Alan's and Lead Pronto's cost per show is if anything flattering rather than harsh. Appointments are read one month past the lead window; a lead booked in August that shoots in October is not in yet, so cost per show is a ceiling that falls with time. Money upfront is the deposit actually taken. Revenue per deal is the contracted price — a promise, not cash. Collected per deal is deposit plus what has actually been banked against the finance ledger, and for paid-in-full deals the price itself. Recycled leads are shown for their sales but carry no ad spend, so they have no cost per booking.

What was actually handed over on the day

$1,341,564 was taken on the day across 2,477 deals — $542 each, 14.75% of what was contracted. 84.45% of it went on a card, 9.30% as the booking deposit, 4.79% in cash and 1.46% on PayPal / Pay Later. 0 deals took nothing at all on the day.
Source groupDealsTaken on the dayPer deal Booking depositCardCashPayPal / Pay Later Took nothingof contracted
Blue Rooms KIDS844$519,605$616$42,125 8.11%$447,980 86.22%$22,930 4.41%$6,570 1.26%0 0.00%14.61%
Blue Rooms ADULT486$249,967$514$24,350 9.74%$211,414 84.58%$7,823 3.13%$6,380 2.55%0 0.00%14.62%
Blue Rooms GOOGLE202$115,342$571$12,050 10.45%$95,586 82.87%$5,806 5.03%$1,900 1.65%0 0.00%16.25%
Alan ADULT566$271,503$480$27,000 9.94%$227,676 83.86%$14,527 5.35%$2,300 0.85%0 0.00%14.42%
Lead Pronto LP2379$185,148$489$19,225 10.38%$150,310 81.18%$13,113 7.08%$2,500 1.35%0 0.00%14.95%
Recycled444$239,306$539$19,325 8.08%$207,060 86.53%$8,221 3.44%$4,700 1.96%0 0.00%16.24%
TOTAL2,477$1,341,564 $542 $124,750 9.30% $1,132,965 84.45% $64,199 4.79% $19,650 1.46% 0 0.00% 14.75%
Read off the payment_order block of each booking's schedule — the money taken at the sale, split by how it was taken. The Order line is the contract value, not a payment, and is excluded. This is the same figure as money upfront on the first tab: it reconciles to daily_sales.deposit on 99.9% of deals ($1,578,223 against $1,578,723 over the window), which is what proves the two are the same thing. Only deals carrying a finance schedule are counted here, so this is 2,477 of the 5,209 sales in the window — and that is why per deal reads lower than "money upfront" on the first tab. A paid-in-full sale has no schedule and hands over the whole price on the day, so excluding those pulls the average down. The first tab's figure is over all sales; this one is over financed sales, and the split by method is only knowable for the latter.

First payment, and the first three

57.88% of first instalments are paid — 1,013 of 2,405 deals missed the very first one. Of the 1,416 deals that have had three instalments fall due, 43.71% paid all three and 21.19% paid none of them.
Source groupDeals with a 1st instalment due1st instalment PAID1st missed Deals with 3 dueAll 3 paidAt least 1 of 3 paidNone of the 3 paid
Blue Rooms KIDS82462.50%30950448.21%81.15%18.85%
Blue Rooms ADULT46755.46%20825344.27%79.05%20.95%
Blue Rooms GOOGLE19655.61%8710743.93%81.31%18.69%
Alan ADULT54955.37%24534339.36%77.26%22.74%
Lead Pronto LP236955.56%16420939.23%74.16%25.84%
Recycled43355.89%19125444.09%77.95%22.05%
TOTAL2,40557.88% 1,0131,41643.71% 78.81%21.19%
Read off finance_cohort/schedules.json: the payment_debit lines for each booking reference, in date order. Only instalments that have come due appear, so a deal is judged on its first payment once it has one line and on the first three once it has three — nothing is counted as missed before it was owed. Only Junline and on the first three once it has three — nothing is counted as missed before it was owed.ndash;Aug sales whose third instalment has already fallen due qualify for the first-3 columns, so those denominators are small; anything under 30 deals is shown dim. Nothing here retries itself. A second attempt on a failed payment is always a person: a collector on the phone, or the customer paying a reminder we sent. Read a recovery as evidence someone made contact, never as a system re-presenting.

Chime and early-access cards

Card issuer data not built yet — run node scripts/reports/report_card_issuers.js.

What each number rests on, and what it is not

MeasureSourceWatch out for
Cost per bookinglead_costs.json per code per month ÷ the name+code booking joinOnly Jun 2026, Jul 2026, Aug 2026 — the months whose spend is genuinely invoiced
Cost per showeach roster row joined back to its lead on name + code; cancels count as did-not-showThe attendance RATE is measured the house way and reproduces the CRM's Show Rate report. Shows are then MODELLED as this cohort's bookings x that rate — attaching each show to its own lead was tried twice and abandoned: only 49% of roster rows attach and only 33.5% of no-shows do, so the attached subset is selected for people who turned up
Money upfrontdaily_sales.depositThe deposit taken on the day, not the first instalment
Total revenuedaily_sales.priceCONTRACTED. A matured finance contract banks ~60% of the sale, the blended book ~65%. Never read this as money
Collected per dealledger.paid + deposit, or price for paid-in-fullCollection is still running on recent deals, so this RISES with age — it is not a final figure
First / first 3 paymentsschedules.json payment_debit linesCRM, not Square — see the warning on the first tab
Sales in window: 5,209, of which 2,920 carry a finance ledger and the rest are paid-in-full or not yet ledgered. Recycled leads cost no new ad money and are excluded from every cost measure.