Share:

Ad Spend vs Revenue vs Cash Up Front

Month on month · January 2026 – June 2026 · revenue & cash from the CRM ROI report, by the month the lead arrived · generated 12 Nov 2026, 09:55  ·  download CSV
Note — Apr 98.8% covered (Blue Rooms missing 6 days (has 2026-04-07–2026-04-30, ≈$9,082 unrecorded)); Jun 99.0% covered (Boost missing 4 days (has 2026-06-01–2026-06-26, ≈$4,987 unrecorded)). Marked †; too small to change the picture.
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
Jan26
$2860k
$1036k
$537k
Feb26
$2657k
$956k
$630k
Mar26
$3065k
$1006k
$706k
Apr26
$2858k
$1052k
$726k
May26
$3380k
$1328k
$558k
Jun26
$3118k
$1201k
$516k
$ 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
SupplierAd spendLeadsBookedShowed $ soldCash up frontUp front % Cost per leadCash 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
SupplierJanFebMarAprMayJunUsable-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
CityJanFebMarAprMayJunTotal
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 signedSalesRevenue signed Deposits takenDeposit % of revenueAvg 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
TOTAL9,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.