Booked & Banked  ·  Sample Audit

What we found inside
Knot & Co.’s
booking history.

This is a sample audit built on entirely fictional data for a made-up massage therapy studio. The business, the owner, and every number in this report are invented. The methodology and report format are real.

Illustrative sample — Knot & Co. is a fictional business. All figures are invented.

Knot & Co. Massage  ·  Ottawa, ON  ·  2-therapist studio, 3 years
53%
clients never
returned
18.7%
cancellation
rate
7.1×
repeat vs.
one-time LTV
$41K+
recoverable
annually
Context

Two therapists. Fully booked.
Still leaving money behind.

Knot & Co. is a two-therapist massage studio in Ottawa run by its owner, Diane, and one associate therapist. By year three, both chairs were running near capacity most weeks. Diane had built a loyal core of regulars and a strong reputation on Google. She wasn’t struggling — she just had a nagging feeling the numbers weren’t telling her the full story.

When we pulled the data, that feeling turned out to be right. More than half of all clients had visited once and disappeared. Nearly one in five bookings was cancelled with no fee recovered. And the two therapists were spending a disproportionate amount of time on 60-minute relaxation massages when 90-minute deep tissue sessions generated 60% more revenue per hour.

Findings

Three gaps. All of them
had a dollar amount.

1
53% of clients booked once and were never seen again
Of 428 unique clients in three years of records, 227 had exactly one appointment on file. There was no follow-up email, no rebooking nudge, and no lapse protocol. Clients who came in for a 60-minute session, had a great experience, and then drifted off — not to a competitor, just to nothing — because no one reached back out.
What this means: The average one-time client spent $110 at Knot & Co. A client who returns 4 or more times over 18 months spends an average of $780. That $670 gap, multiplied across 227 lapsed clients, represents the single largest recoverable opportunity in the business.
227
lapsed clients
2
18.7% cancellation rate with no deposit — and two therapists absorbing the loss
Across 1,847 scheduled appointments, 346 were cancelled or no-showed. With two therapists on the floor, a last-minute cancellation doesn’t just cost one session — it creates a gap in both schedules that’s rarely filled on short notice. Knot & Co. had a posted cancellation policy on its website but no enforcement mechanism and no deposit at booking.
What this means: At an average ticket of $115, those 346 cancelled sessions represent $39,790 in listed appointment value. Even recovering 40% of that through a $40 booking deposit would add over $13,800 to annual revenue with zero new clients required.
$39,790
cancellation value
3
60-minute sessions filled the calendar — 90-minute deep tissue sessions filled the bank
The service mix analysis showed that 60-minute relaxation massages accounted for 61% of all bookings but only 44% of total revenue. Meanwhile, 90-minute deep tissue and hot stone sessions made up 24% of bookings but generated 39% of revenue — and had a measurably higher rebooking rate (68% vs. 41%). The most profitable clients were the ones booking the longest sessions.
What this means: A targeted upsell prompt at checkout — “Would you like to add 30 minutes for a full back and neck release?” — converting just 4 sessions per week from 60 to 90 minutes would add approximately $9,100 annually. No new clients. No added hours. Just a different mix.
+$9.1K
mix opportunity
The opportunity
Recoverable revenue — conservative estimates
+$22K
from recovering 20% of lapsed clients via a 3-touch re-engagement email sequence over 12 months
+$13.8K
from a $40 booking deposit reducing net cancellation loss by ~40% annually
+$9.1K
from service mix shift — 4 additional 90-minute upgrades per week through checkout prompts
$87,200
base annual revenue (fictional year 3) from 1,501 completed appointments across both therapists
Base revenue: $87,200  ·  Projected after implementation
~$132,100 / year
+51% uplift
Average client lifetime value  ·  repeat vs. one-time
Repeat client
$780 avg LTV
One-time client
$110
A 7.1× LTV gap means every client who books once and never returns costs the business the equivalent of six future visits. The goal isn’t to acquire more clients — it’s to move more clients from the bottom row to the top.
How we built this
Data source
Booking system CSV
3 years of appointment records from Jane App
Appointments analysed
1,847 records
March 2022 — Feb 2025
Turnaround
4 business days
From CSV upload to written report
Format delivered
PDF + Word report
Numbered findings + 60-min strategy call
Your turn

What does your
data actually say?

Every business we’ve looked at has had something sitting in the numbers. We don’t know what yours are — but we’d like to find out.

Start your free intake →
Or DM us “AUDIT” on Instagram  ·  @bookedandbanked