Count salon bookings by person, not account
Group bookings stop distorting your no-show numbers because every chair and service is counted on its own.
Founders and leadership · Salons and beauty · On a schedule · Updated
Works with
- Slack
- Calendly
- Cal.com
- Airtable
- Microsoft 365
Slack
Calendly
Cal.com
Airtable
Microsoft 365How do you count salon bookings by person instead of by account?
To count salon bookings by person instead of by account, set a monthly Loop. Maito reads the booking system and attendance records, counts each person and service as one slot, links group bookings to the organizer, and posts corrected bookings, attendance and no-show rates in Slack.
How it's done today
The owner counts one account as one booking, so a bridal party of six looks like a single appointment.
What Maito does
- Split each booking into its service and stylist slots
- Link group bookings to the person who booked
- Check attendance for each slot
- Recalculate no-show and capacity numbers
Example
Loop run: 1st of the month · Booking recount
September, counted by slot instead of by account. • Account bookings: 412 • Individual slots: 538 (126 more, all from group bookings) • Attended: 507 • No-show slots: 31 (5.8%). The old report said 7.5% • Chair use: 71%, with Saturdays at 94% Catch: the Sep 26 bridal party was one account with 6 slots. One bridesmaid didn't come, and the old report counted all 6 services as a no-show: $540 of lost revenue instead of $90. That alone moved the rate by 1.2 points. Group bookings: 14 accounts, 41 slots. Largest was Zoe's Sep 26 party (6 slots, $810 total). From the booking system and the attendance records. Want the no-show list by stylist for the Monday huddle?
@Maito yes, and add which clients no-showed twice.
Three stylists had no-shows: Kim 14, Jo 9, Rae 8. Two clients no-showed twice (Alicia M. and Priya S.). Attached: no-shows-by-stylist.xlsx. A deposit policy is your call, so I haven't suggested one.
Maito (8:00 AM):
September, counted by slot instead of by account.
• Account bookings: 412
• Individual slots: 538 (126 more, all from group bookings)
• Attended: 507
• No-show slots: 31 (5.8%). The old report said 7.5%
• Chair use: 71%, with Saturdays at 94%
Catch: the Sep 26 bridal party was one account with 6 slots. One bridesmaid didn't come, and the old report counted all 6 services as a no-show: $540 of lost revenue instead of $90. That alone moved the rate by 1.2 points.
Group bookings: 14 accounts, 41 slots. Largest was Zoe's Sep 26 party (6 slots, $810 total).
From the booking system and the attendance records. Want the no-show list by stylist for the Monday huddle?
Zoe (8:12 AM):
yes, and add which clients no-showed twice.
Maito (8:14 AM):
Three stylists had no-shows: Kim 14, Jo 9, Rae 8. Two clients no-showed twice (Alicia M. and Priya S.). Attached: no-shows-by-stylist.xlsx. A deposit policy is your call, so I haven't suggested one.
How to set it up
- Ask your agent
“On the 1st of each month, recount last month's bookings, attended slots and no-shows by individual person and service, not by account. Post the corrected numbers in #owners.”
- Connect booking system
- Calendly
- Cal.com
- Connect spreadsheet
- Airtable
- Microsoft 365
Not connected yet? Your agent sends you a link to sign in.
What it won't do
It counts what the booking and attendance data record. It won't decide policies such as deposits.
Questions
One account can hold several people. A bridal party of six counts as one booking, and one missed guest looks like a full no-show.
Calendly or Cal.com for bookings, and an Airtable or Microsoft 365 spreadsheet for attendance.
Yes, if the booking data includes the stylist. It can attach a spreadsheet.
