Ad spend % of revenue
18.4%
$3,674,347 of ads on $19,960,199 signed · 20.5% on attributed
Cash on the day % of ad spend
198.2%
$7,283,009 of deposits on $3,674,347 of ads · 179.0% on attributed
Ad spend
$3,674,347
Jan–Jun · 6 months with usable cost data
Revenue signed
$19,960,199
attributed to these months’ leads $17,937,291
On finance
$12,677,190
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,274).
| 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,274 |
14.8% |
|
$1,346,985 |
260.8% |
|
| ALL 6 MONTHS |
$3,674,347 |
$19,960,199 |
18.4% |
|
$7,283,009 |
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,860,485 |
18.8% |
|
$1,035,688 |
192.7% |
|
| February 2026 |
$629,700 |
$2,656,650 |
23.7% |
|
$956,324 |
151.9% |
|
| March 2026 |
$706,433 |
$3,065,005 |
23.0% |
|
$1,005,800 |
142.4% |
|
| April 2026 |
$726,208 |
$2,857,823 |
25.4% |
|
$1,051,533 |
144.8% |
|
| May 2026 |
$558,209 |
$3,379,600 |
16.5% |
|
$1,328,010 |
237.9% |
|
| June 2026 |
$516,384 |
$3,117,728 |
16.6% |
|
$1,200,886 |
232.6% |
|
| ALL 6 MONTHS |
$3,674,347 |
$17,937,291 |
20.5% |
|
$6,578,241 |
179.0% |
|
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,199 of revenue signed —
18.4%.
Deposits taken over the same months were $7,283,009, so the ads returned
198.2% of their own cost
in same-day cash. The remaining $12,677,190 is on finance and still has to be collected.
On the CRM's attributed basis those become 20.5% and
179.0% — lower, because $2,022,908 of the revenue can't be
traced to a lead that arrived in these months.
Under the ads: 344,020 leads → 18,416 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,185 5.0% |
1,457 45.7% |
$2,860,485 |
$1,035,688 |
36.2% |
18.8% |
$1.93 |
$8.51 |
$169 |
settled |
from the CRM |
| February 2026 |
$629,700 |
55,534 |
2,792 5.0% |
1,389 49.7% |
$2,656,650 |
$956,324 |
36.0% |
23.7% |
$1.52 |
$11.34 |
$226 |
settled |
complete |
| March 2026 |
$706,433 |
59,454 |
3,079 5.2% |
1,492 48.5% |
$3,065,005 |
$1,005,800 |
32.8% |
23.0% |
$1.42 |
$11.88 |
$229 |
settled |
complete |
| April 2026 |
$726,208 † |
57,568 |
2,917 5.1% |
1,503 51.5% |
$2,857,823 |
$1,051,533 |
36.8% |
25.4% |
$1.45 |
$12.61 |
$249 |
settled |
99% — usable |
| May 2026 |
$558,209 |
55,486 |
3,266 5.9% |
1,730 53.0% |
$3,379,600 |
$1,328,010 |
39.3% |
16.5% |
$2.38 |
$10.06 |
$171 |
settled |
complete |
| June 2026 |
$516,384 † |
52,813 |
3,177 6.0% |
1,675 52.7% |
$3,117,728 |
$1,200,886 |
38.5% |
16.6% |
$2.33 |
$9.78 |
$163 |
settled |
99% — usable |
| TOTAL — 6 usable months |
$3,674,347 |
344,020 |
18,416 5.4% |
9,246 50.2% |
$17,937,291 |
$6,578,241 |
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,987 |
7,421 5.9% |
3,605 48.6% |
$6965k |
$2591k |
37.2% |
$14.87 |
$1.38 |
| Blue Rooms |
$446k |
47,960 |
3,730 7.8% |
2,145 57.5% |
$4201k |
$1707k |
40.6% |
$9.30 |
$3.83 |
| Neil recycled — not bought |
$2.4k |
79,717 |
2,808 3.5% |
1,257 44.8% |
$2284k |
$791k |
34.6% |
— |
free |
| Lead Pronto |
$679k |
42,544 |
2,123 5.0% |
1,073 50.5% |
$2127k |
$680k |
32.0% |
$15.96 |
$1.00 |
| Boost |
$651k |
40,420 |
1,866 4.6% |
877 47.0% |
$1672k |
$530k |
31.7% |
$16.12 |
$0.81 |
| Other |
$22.1k |
5,158 |
374 7.3% |
228 61.0% |
$534k |
$208k |
38.9% |
$4.28 |
$9.41 |
| Organic not bought |
$0 |
2,234 |
94 4.2% |
61 64.9% |
$154k |
$70.2k |
45.6% |
— |
free |
| TOTAL |
$3674k |
344,020 |
18,416 5.4% |
9,246 50.2% |
$17937k |
$6578k |
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 | $525k 37.3% | $545k 39.5% | $804k 34.6% | $670k 38.8% | $1146k 42.1% | $980k 39.5% | $4671k 38.9% |
| Dallas | $565k 41.6% | $398k 42.3% | $434k 35.0% | $398k 49.1% | $439k 47.4% | $393k 49.3% | $2626k 43.9% |
| New York | $494k 32.3% | $430k 32.8% | $420k 31.9% | $382k 31.4% | $457k 37.3% | $315k 34.9% | $2499k 33.4% |
| Houston | $347k 40.5% | $367k 32.8% | $442k 30.8% | $397k 24.7% | $476k 31.5% | $418k 27.2% | $2448k 31.0% |
| Chicago | $338k 31.6% | $411k 34.9% | $480k 33.3% | $467k 37.8% | $335k 38.8% | $399k 37.5% | $2429k 35.7% |
| Nashville | $317k 32.9% | $278k 32.2% | $236k 28.9% | $289k 32.6% | $252k 30.0% | $268k 45.8% | $1641k 33.8% |
| Boston | $274k 34.3% | $227k 34.5% | $249k 31.1% | $254k 42.1% | $274k 40.7% | $344k 35.9% | $1622k 36.5% |
| ALL CITIES | $2860k 36.2% | $2657k 36.0% | $3065k 32.8% | $2858k 36.8% | $3380k 39.3% | $3118k 38.5% | $17937k 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 |
$209,529 |
| February 2026 |
1,513 |
$3,189,726 |
$1,141,143 |
35.8% |
$2,108 |
$533,076 |
| March 2026 |
1,668 |
$3,567,472 |
$1,189,375 |
33.3% |
$2,139 |
$502,467 |
| April 2026 |
1,394 |
$3,016,026 |
$1,053,411 |
34.9% |
$2,164 |
$158,203 |
| May 2026 |
1,780 |
$3,637,688 |
$1,399,393 |
38.5% |
$2,044 |
$258,088 |
| June 2026 |
1,721 |
$3,479,274 |
$1,346,985 |
38.7% |
$2,022 |
$361,546 |
| TOTAL | 9,513 |
$19,960,199 | $7,283,009 |
36.5% | $2,098 |
$2,022,908 |
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.