New clients are the fuel for a med spa's growth, but not every channel delivers them at a price that pays off. A flood of cheap-looking leads from one channel can cost more per acquired client than a quieter, higher-intent one — and the only way to know is to put spend and acquired clients side by side. This dashboard shows what each new client costs by channel and whether their first visit, and their return, justify the spend.
What this report answers
How many new clients did each channel — paid social, Google Ads, referral program, organic, local events, influencer — actually acquire, and what did each one cost? Is CAC trending up as channels saturate? Does the first visit alone pay back acquisition, and which channels clear that bar? And do the clients a channel brings in come back for a second visit, the early signal that they'll retain rather than churn after a one-time promo?
The metrics that matter
CAC is allocated spend over new clients — a SUM over a COUNT, so it aggregates correctly by channel, location, or month. First-visit revenue-to-CAC ratio is the fastest payback read: above 1 means the first visit already covers acquisition. But the second-visit return rate is the metric that separates good channels from vanity ones — a channel can hit a low CAC by attracting deal-seekers who never come back, and only the return rate exposes that.
Why the data is trapped across the systems
This is the report no aesthetics platform can produce, because the spend doesn't live in the booking system at all. New clients and their first and second visits sit in Boulevard, PatientNow, Square, or Mangomint; the spend sits in Meta, Google Ads, and influencer invoices. Joining cost to outcome — per channel, per client — is exactly the cross-system stitch that owners do in spreadsheets if they do it at all.
How to read it
Read CAC by channel against the revenue-to-CAC ratio, not in isolation: a low CAC channel that returns less than 1x on the first visit and has a weak second-visit rate is buying churn. The spend-versus-new-clients scatter shows which channels scale efficiently and which hit diminishing returns. Shift budget toward channels with payback above 1x and strong second-visit return, and treat low-return channels as awareness, not acquisition.
The sample on this page uses entirely synthetic spend and acquisition data — no real ad accounts or patient information.
Metrics it tracks
| Metric | What it means |
|---|---|
| New Clients Acquired | New clients acquired in the period across all channels. |
| Total Marketing Spend | Marketing spend allocated to new-client acquisition for the period. |
| Cost per New Client (CAC) | Allocated spend ÷ new clients — the blended cost to acquire one client. |
| First-Visit Revenue | Revenue generated by new clients on their first visit. |
| First-Visit Revenue-to-CAC Ratio | First-visit revenue ÷ marketing spend — whether the very first visit already pays back acquisition. |
| Second-Visit Return Rate | New clients who returned for a second visit ÷ new clients — the early signal that acquisition is sticky. |
Used by: Owner and marketing manager
Frequently asked questions
How do I calculate customer acquisition cost (CAC) for a med spa?
CAC is total marketing spend divided by the number of new clients acquired, ideally split by channel. This report allocates spend per acquired client so you can compare cost per new client across paid social, Google, referrals, organic, events, and influencer — and against the revenue each channel's clients generate.
Why can't my booking system calculate cost per new client?
Because the cost lives outside it. Boulevard, PatientNow, Square, and Mangomint know your new clients and their visits, but your marketing spend sits in Meta, Google Ads, and influencer invoices. CAC requires joining those two sources per channel, which is the cross-system work this template does for you.
What does the first-visit revenue-to-CAC ratio tell me?
It's first-visit revenue divided by marketing spend. Above 1 means a new client's very first visit already pays back what it cost to acquire them — a strong, fast-payback channel. Below 1 means you're betting on retention to recoup the cost, which is why the second-visit return rate sits right beside it.
Build this report on your own data
Clone this Med spas template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →