How to Track Your No-Show Rate in Acuity Scheduling

No. Acuity Scheduling (formerly Squarespace Scheduling) lets you mark an appointment as a no-show, and its prevention toolkit — cards on file, cancellation policy text, reminder emails and SMS — is real. But there is no report that counts no-shows or calculates a rate. No cancellation analytics either. The status lives on each individual appointment, and nothing aggregates it.

Worse, the one report Acuity does ship actively hides the problem: the built-in revenue report excludes cancelled and no-show appointments from its totals. Your numbers look healthier than your calendar actually was, because the appointments that cost you money simply vanish from the reporting. We break down everything Acuity does and doesn't report in our guide to Acuity Scheduling reports.

Any no-show rate is only as good as your marking discipline. If half your team cancels missed appointments and the other half marks them no-show, your rate is fiction. Fix the process before touching a spreadsheet:

1. Define what counts. A no-show never arrived and never told you. A late cancellation gave notice, just not enough to refill the slot. Keep the two statuses distinct — they have different causes and different fixes.
2. Mark, don't cancel or delete. When a client doesn't arrive, mark the appointment as a no-show in Acuity. Cancelling it merges it into a different bucket; deleting it destroys the record entirely.
3. Do it same-day. An end-of-day sweep takes two minutes. Reconstructing last month's no-shows from memory takes an afternoon and produces guesses.
4. Assign one owner per calendar or location. Shared responsibility is how appointments fall through — one person closes out each day's schedule.
5. Write the rule down. Two sentences in your front-desk playbook (“no arrival and no contact = mark no-show, same day”) beats re-litigating it every week.

The formula is simple: no-show rate = (no-shows ÷ booked appointments) × 100. “Booked” means every appointment scheduled to happen in the period — completed ones plus the no-shows themselves. Appointments cancelled well in advance can be excluded, since those slots had a chance to be refilled.

1. Export your appointment list from Acuity for the period you're measuring (a month is the practical unit) as a CSV or spreadsheet.
2. Open it in Google Sheets or Excel and confirm the export includes an appointment status or a way to identify no-shows, plus service, date, and calendar/staff columns.
3. Count the no-shows — a filter or a formula like =COUNTIF(status_range, "no-show") does it.
4. Count total booked appointments for the same period (again: include the no-shows, exclude early cancellations).
5. Divide and multiply by 100. If you booked 200 appointments and 14 were no-shows, your rate is 7%.
6. Segment it with a pivot table: rate by service, by day of week, and by staff member or calendar. This is where the actionable findings live.
7. Log the headline number in a running tracker each month so you can see the trend, not just the snapshot.

There is no universal standard, and published figures vary widely by methodology. The ranges below reflect what appointment businesses commonly report — treat them as orientation, not lab-grade statistics:

Three patterns hold almost everywhere: new clients no-show more than repeat clients, longer lead times mean higher no-show risk, and appointments with money attached — deposits, cards on file, prepayment — get missed less. And whatever your absolute number, the trend is the real signal: a rate that climbs two or three months in a row is a problem at 5% just as much as at 15%.

If you want to put a dollar figure on your rate — usually the fastest way to get the team taking the marking discipline seriously — work through what no-shows actually cost your business.

The spreadsheet method works, and if you run it faithfully every month you're ahead of most Acuity businesses. But it has structural weaknesses that show up exactly when the number matters most:

• It's backward-looking. You learn March was a bad month in April, after the empty slots already happened.
• It's manual, so it gets skipped. The export-filter-pivot ritual loses to a busy week, and a tracker with gaps can't show a trend.
• Segmentation is a chore. Rate by service by weekday by staff means rebuilding pivots every period — so most people stop at the headline number.
• Definitions drift. Staff turnover and inconsistent marking quietly change what the number means from one quarter to the next.
• There's no forward view. A spreadsheet can't tell you what next month's no-shows are likely to look like.

Tecton Scheduler layers on top of your existing Acuity Scheduling account — it doesn't replace it. It syncs your appointments and services from Acuity on demand or on a schedule, then does the counting you'd otherwise do in a spreadsheet:

• The no-show analytics dashboard shows no-shows for today, the last 7 days, the last 30 days, and the month — with prior-period comparisons and sparklines, alongside bookings, cancellations, revenue, average ticket, and new clients.
• The demand heatmap breaks activity down by day and hour, so the “Monday 9am problem” is visible instead of buried in a pivot table.
• The booking and no-show forecast projects no-shows (plus bookings, revenue, and cancellations) over 7, 30, and 90 days with ranges and your busiest and quietest days — the forward view a spreadsheet can't give you.
• The notifications feed keeps reschedules, fees charged, and failed cards in one read-tracked stream, so schedule changes don't slip past you.

Measurement is half the value; the other half is that the same tool acts on the number. Tecton gives clients a branded self-serve reschedule link that pulls live Acuity availability — so a client who would have silently skipped can move the appointment instead, with an optional fee collected via Square or Stripe at confirmation. Your no-show rate goes down because reschedules go up. Every plan is month-to-month with a free trial and about 15 minutes of setup — see pricing.