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 group | Fresh leads | Ad spend | Bookings |
1 · Cost per booking | Attendance (appt basis) | Shows expected | 2 · Cost per show |
Sales in window | 3 · Money upfront | 4 · Revenue per deal |
5 · Collected per deal | Collected of contracted |
| Blue Rooms KIDS | 32,703 | $468,591 | 2,222 | $211 | 67.5% 1,866 appts | 1,499 | $313 | 1,639 | $930 | $2,170 | $1,137 | 52.38% |
| Blue Rooms ADULT | 23,199 | $298,533 | 1,454 | $205 | 59.1% 1,235 appts | 859 | $348 | 865 | $742 | $1,977 | $910 | 45.97% |
| Blue Rooms GOOGLE | 25,381 | $364,620 | 562 | $649 | 59.5% 580 appts | 334 | $1,092 | 342 | $729 | $2,076 | $896 | 43.15% |
| Alan ADULT | 25,823 | $382,189 | 1,131 | $338 | 51.3% 1,380 appts | 580 | $659 | 967 | $707 | $1,947 | $897 | 46.07% |
| Lead Pronto LP2 | 19,156 | $372,130 | 918 | $405 | 60.1% 830 appts | 552 | $674 | 633 | $620 | $1,957 | $821 | 41.95% |
| Lead Pronto other | 2 | $34 | 0 | — | 100.0% 1 appts | 0 | — | 1 | $50 | $50 | $50 | 100.00% |
| Recycled | 0 | — | 0 | — | 53.7% 1,210 appts | 0 | — | 762 | $662 | $1,933 | $850 | 43.94% |
| TOTAL bought | 126,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 group | Deals | Taken on the day | Per deal |
Booking deposit | Card | Cash | PayPal / Pay Later |
Took nothing | of contracted |
| Blue Rooms KIDS | 844 | $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 ADULT | 486 | $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 GOOGLE | 202 | $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 ADULT | 566 | $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 LP2 | 379 | $185,148 | $489 | $19,225 10.38% | $150,310 81.18% | $13,113 7.08% | $2,500 1.35% | 0 0.00% | 14.95% |
| Recycled | 444 | $239,306 | $539 | $19,325 8.08% | $207,060 86.53% | $8,221 3.44% | $4,700 1.96% | 0 0.00% | 16.24% |
| TOTAL | 2,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 group | Deals with a 1st instalment due | 1st instalment PAID | 1st missed |
Deals with 3 due | All 3 paid | At least 1 of 3 paid | None of the 3 paid |
| Blue Rooms KIDS | 824 | 62.50% | 309 | 504 | 48.21% | 81.15% | 18.85% |
| Blue Rooms ADULT | 467 | 55.46% | 208 | 253 | 44.27% | 79.05% | 20.95% |
| Blue Rooms GOOGLE | 196 | 55.61% | 87 | 107 | 43.93% | 81.31% | 18.69% |
| Alan ADULT | 549 | 55.37% | 245 | 343 | 39.36% | 77.26% | 22.74% |
| Lead Pronto LP2 | 369 | 55.56% | 164 | 209 | 39.23% | 74.16% | 25.84% |
| Recycled | 433 | 55.89% | 191 | 254 | 44.09% | 77.95% | 22.05% |
| TOTAL | 2,405 | 57.88% |
1,013 | 1,416 | 43.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
| Measure | Source | Watch out for |
| Cost per booking | lead_costs.json per code per month ÷ the name+code booking join | Only Jun 2026, Jul 2026, Aug 2026 — the months whose spend is genuinely invoiced |
| Cost per show | each roster row joined back to its lead on name + code; cancels count as did-not-show | The 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 upfront | daily_sales.deposit | The deposit taken on the day, not the first instalment |
| Total revenue | daily_sales.price | CONTRACTED. A matured finance contract banks ~60% of the sale, the blended book ~65%. Never read this as money |
| Collected per deal | ledger.paid + deposit, or price for paid-in-full | Collection is still running on recent deals, so this RISES with age — it is not a final figure |
| First / first 3 payments | schedules.json payment_debit lines | CRM, 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.