Ad spend % of revenue
18.4%
$3,674,347 of ads on $19,960,099 signed · 20.5% on attributed
Cash on the day % of ad spend
198.2%
$7,282,709 of deposits on $3,674,347 of ads · 178.6% on attributed
Ad spend
$3,674,347
Jan–Jun · 6 months with usable cost data
Revenue signed
$19,960,099
attributed to these months’ leads $17,893,684
On finance
$12,677,390
63.5% still to be collected
Spend against revenue, and cash on the day against spend — month by month
Everything signed in the month — whoever's lead it was. This is the
business's actual month and matches the sales figures you already know
(June $3,479,174).
| Month |
Ad spend |
Revenue signed |
Ad spend
% of revenue |
|
Deposits taken |
Cash on the day
% of ad spend |
|
| January 2026 |
$537,414 |
$3,070,014 |
17.5% |
|
$1,152,703 |
214.5% |
|
| February 2026 |
$629,700 |
$3,189,726 |
19.7% |
|
$1,141,143 |
181.2% |
|
| March 2026 |
$706,433 |
$3,567,472 |
19.8% |
|
$1,189,375 |
168.4% |
|
| April 2026 |
$726,208 |
$3,016,026 |
24.1% |
|
$1,053,411 |
145.1% |
|
| May 2026 |
$558,209 |
$3,637,688 |
15.3% |
|
$1,399,393 |
250.7% |
|
| June 2026 |
$516,384 |
$3,479,174 |
14.8% |
|
$1,346,685 |
260.8% |
|
| ALL 6 MONTHS |
$3,674,347 |
$19,960,099 |
18.4% |
|
$7,282,709 |
198.2% |
|
Ad spend % of revenue — what share of the sale value the ads cost. Lower is better.
Cash % of ad spend — deposits taken against the ad bill. The white line is 100%: below it the ads cost more than the cash they returned.
Only what the CRM can trace back to that month's leads
— the ROI report's own attribution. It runs ~7% under the billed figure even on fully settled
months, because walk-ins, previous clients, re-books and no-code sales have no lead to attribute to,
and further under on recent months whose leads are still converting. Use this one to judge whether
the ads paid back; use the one above for the business's revenue.
| Month |
Ad spend |
Revenue from that month’s leads |
Ad spend
% of revenue |
|
Cash up front |
Cash on the day
% of ad spend |
|
| January 2026 |
$537,414 |
$2,858,485 |
18.8% |
|
$1,035,438 |
192.7% |
|
| February 2026 |
$629,700 |
$2,655,600 |
23.7% |
|
$956,124 |
151.8% |
|
| March 2026 |
$706,433 |
$3,062,180 |
23.1% |
|
$1,004,425 |
142.2% |
|
| April 2026 |
$726,208 |
$2,853,523 |
25.4% |
|
$1,050,608 |
144.7% |
|
| May 2026 |
$558,209 |
$3,365,150 |
16.6% |
|
$1,319,560 |
236.4% |
|
| June 2026 |
$516,384 |
$3,098,746 |
16.7% |
|
$1,197,604 |
231.9% |
|
| ALL 6 MONTHS |
$3,674,347 |
$17,893,684 |
20.5% |
|
$6,563,759 |
178.6% |
|
Ad spend % of revenue — what share of the sale value the ads cost. Lower is better.
Cash % of ad spend — deposits taken against the ad bill. The white line is 100%: below it the ads cost more than the cash they returned.
Over January 2026 – June 2026 you spent $3,674,347
on ads against $19,960,099 of revenue signed —
18.4%.
Deposits taken over the same months were $7,282,709, so the ads returned
198.2% of their own cost
in same-day cash. The remaining $12,677,390 is on finance and still has to be collected.
On the CRM's attributed basis those become 20.5% and
178.6% — lower, because $2,066,415 of the revenue can't be
traced to a lead that arrived in these months.
Under the ads: 344,020 leads → 18,393 bookings, at
$10.68 a lead and $200 a booking.
The same months in full — leads, bookings, shows
| Month leads arrived |
Ad spend |
Leads |
Booked |
Showed |
$ sold |
Cash up front |
Up front % of sold |
Ad spend % of sold |
Cash per $1 of ads |
Cost per lead |
Cost per booking |
Cohort |
Cost data |
| January 2026 |
$537,414 ◆ |
63,165 |
3,184 5.0% |
1,456 45.7% |
$2,858,485 |
$1,035,438 |
36.2% |
18.8% |
$1.93 |
$8.51 |
$169 |
settled |
from the CRM |
| February 2026 |
$629,700 |
55,534 |
2,790 5.0% |
1,386 49.7% |
$2,655,600 |
$956,124 |
36.0% |
23.7% |
$1.52 |
$11.34 |
$226 |
settled |
complete |
| March 2026 |
$706,433 |
59,454 |
3,075 5.2% |
1,489 48.4% |
$3,062,180 |
$1,004,425 |
32.8% |
23.1% |
$1.42 |
$11.88 |
$230 |
settled |
complete |
| April 2026 |
$726,208 † |
57,568 |
2,912 5.1% |
1,499 51.5% |
$2,853,523 |
$1,050,608 |
36.8% |
25.4% |
$1.45 |
$12.61 |
$249 |
settled |
99% — usable |
| May 2026 |
$558,209 |
55,486 |
3,258 5.9% |
1,724 52.9% |
$3,365,150 |
$1,319,560 |
39.2% |
16.6% |
$2.36 |
$10.06 |
$171 |
settled |
complete |
| June 2026 |
$516,384 † |
52,813 |
3,174 6.0% |
1,669 52.6% |
$3,098,746 |
$1,197,604 |
38.6% |
16.7% |
$2.32 |
$9.78 |
$163 |
settled |
99% — usable |
| TOTAL — 6 usable months |
$3,674,347 |
344,020 |
18,393 5.3% |
9,223 50.1% |
$17,893,684 |
$6,563,759 |
36.7% |
20.5% |
$1.79 |
$10.68 |
$200 |
| |
The shape of it
$ sold by that month's leads
Cash up front (paid at signing)
Ad spend that bought them
By supplier — who pays for themselves in cash
| Supplier | Ad spend | Leads | Booked | Showed |
$ sold | Cash up front | Up front % |
Cost per lead | Cash per $1 of ads |
|---|
| Alan |
$1874k |
125,986 |
7,415 5.9% |
3,602 48.6% |
$6954k |
$2589k |
37.2% |
$14.87 |
$1.38 |
| Blue Rooms |
$446k |
47,960 |
3,721 7.8% |
2,138 57.5% |
$4186k |
$1701k |
40.6% |
$9.30 |
$3.81 |
| Neil recycled — not bought |
$2.4k |
79,718 |
2,807 3.5% |
1,251 44.6% |
$2274k |
$790k |
34.7% |
— |
free |
| Lead Pronto |
$679k |
42,544 |
2,121 5.0% |
1,071 50.5% |
$2127k |
$680k |
32.0% |
$15.96 |
$1.00 |
| Boost |
$651k |
40,420 |
1,864 4.6% |
875 46.9% |
$1666k |
$526k |
31.6% |
$16.12 |
$0.81 |
| Other |
$22.1k |
5,158 |
372 7.2% |
226 60.8% |
$533k |
$207k |
38.8% |
$4.28 |
$9.38 |
| Organic not bought |
$0 |
2,234 |
93 4.2% |
60 64.5% |
$153k |
$70.0k |
45.7% |
— |
free |
| TOTAL |
$3674k |
344,020 |
18,393 5.3% |
9,223 50.1% |
$17894k |
$6564k |
36.7% |
$10.68 |
$1.79 |
Ad spend by supplier, by month
| Supplier | Jan | Feb | Mar | Apr | May | Jun | Usable-months total |
|---|
| Alan | $372k | $366k | $360k | $417k | $233k | $126k | $1874k |
| Blue Rooms | — | — | — | $36.3k | $148k | $262k | $446k |
| Boost | $101k | $142k | $205k | $116k | $55.7k | $32.4k | $651k |
| Lead Pronto | $40.4k | $122k | $141k | $158k | $121k | $96.7k | $679k |
| Neil | $2.4k | — | — | — | — | — | $2.4k |
| Other | $22.1k | — | — | — | — | — | $22.1k |
| TOTAL | $537k | $630k | $706k | $726k | $558k | $516k | $3674k |
$ sold and up-front % by city, by month
| City | Jan | Feb | Mar | Apr | May | Jun | Total |
|---|
| Florida | $523k 37.4% | $545k 39.5% | $801k 34.6% | $670k 38.8% | $1143k 41.9% | $972k 39.8% | $4655k 39.0% |
| Dallas | $565k 41.6% | $398k 42.3% | $434k 35.0% | $398k 49.1% | $439k 47.4% | $389k 49.6% | $2623k 43.9% |
| New York | $494k 32.3% | $430k 32.8% | $420k 31.9% | $378k 31.5% | $454k 37.5% | $311k 35.1% | $2488k 33.5% |
| Houston | $347k 40.5% | $367k 32.8% | $442k 30.8% | $397k 24.7% | $476k 31.5% | $419k 27.2% | $2449k 31.0% |
| Chicago | $338k 31.6% | $410k 34.9% | $480k 33.3% | $467k 37.8% | $327k 38.4% | $398k 37.5% | $2420k 35.6% |
| Nashville | $317k 32.9% | $278k 32.2% | $236k 28.9% | $289k 32.6% | $252k 30.0% | $264k 46.1% | $1637k 33.8% |
| Boston | $274k 34.3% | $227k 34.5% | $249k 31.1% | $254k 42.1% | $274k 40.6% | $344k 35.8% | $1622k 36.4% |
| ALL CITIES | $2858k 36.2% | $2656k 36.0% | $3062k 32.8% | $2854k 36.8% | $3365k 39.2% | $3099k 38.6% | $17894k 36.7% |
The other frame — money signed in the month, whoever's lead it was
| Month signed | Sales | Revenue signed |
Deposits taken | Deposit % of revenue | Avg sale |
vs the cohort figure |
|---|
| January 2026 |
1,437 |
$3,070,014 |
$1,152,703 |
37.5% |
$2,136 |
$211,529 |
| February 2026 |
1,513 |
$3,189,726 |
$1,141,143 |
35.8% |
$2,108 |
$534,126 |
| March 2026 |
1,668 |
$3,567,472 |
$1,189,375 |
33.3% |
$2,139 |
$505,292 |
| April 2026 |
1,394 |
$3,016,026 |
$1,053,411 |
34.9% |
$2,164 |
$162,503 |
| May 2026 |
1,780 |
$3,637,688 |
$1,399,393 |
38.5% |
$2,044 |
$272,538 |
| June 2026 |
1,721 |
$3,479,174 |
$1,346,685 |
38.7% |
$2,022 |
$380,428 |
| TOTAL | 9,513 |
$19,960,099 | $7,282,709 |
36.5% | $2,098 |
$2,066,415 |
How these numbers are built
• $ sold and Cash up front come from the CRM's own ROI report
(report-roidatalib.php): Of showed leads, Total $ sold and
Total Paid Up Front, per marketing code.
• This is a lead cohort, and that is deliberate. The ROI report's date range filters on when the
lead arrived, then follows those leads to what they sold. Ad spend and leads are the same-month
thing — February's ads bought February's leads — so matching February's spend against what February's
leads sold is the honest comparison. Matching it against sales signed in February would be
comparing it mostly against January's leads. Both frames are on this page; the cohort is the primary one.
• A recent month is a floor, not a verdict. Its leads are still converting — the Cohort column
says how settled each month is. Don't read a fresh month as a decline.
• Ad spend prefers the CRM's own figure, and falls back to the suppliers. The ROI report has a
Total $ Marketing Spend column. It is filled in for January only — $537,414 across
80 codes, complete across every supplier (Alan $371,696 · Boost $100,747 · Lead Pronto $40,428 ·
Other $22,099 · recycled $2,444). Whoever was entering it stopped, and it reads $0.00 for every code from
February onwards. Months marked from the CRM (◆) use that figure.
• Every other month falls back to real invoiced supplier cost: Alan actual $/city/month, Boost
actual $/code/day (Five Chickens Supabase ad_costs), Blue Rooms actual $/campaign/day
(USA Models), Lead Pronto at its real blended $16.85/lead × that month's LP
leads. Recycled (5AB/6AB/CMN/N1N) and organic codes = $0, not bought.
Filling the CRM column in again is the single fix that would retire all of that scraping — and it is the
only source that has never had a coverage gap.
• Nothing here is estimated. Spend coverage is measured per day, per supplier, and each hole is
sized against that supplier's own daily run-rate — to decide whether a month is usable, never to top it up.
Only suppliers that had leads that month can make it short. A month under ~97% covered shows its spend greyed
with no percentages, and is excluded from every total.
• Cash per $1 of ads = up-front cash ÷ ad spend. Under $1.00 means the ads cost more than the cash
they brought in — the shortfall is funded from collections on older finance agreements.
• Cost data currently reaches: Alan 2026-07-23 · Blue Rooms 2026-08-20 ·
Boost 2026-06-26. Supplier weeks run Friday–Thursday and are split across month boundaries
pro-rata by day.
• Supplier and city are derived from the marketing code with the canonical detectSource /
detectCity every other lead report uses.