salon-ops
Find which salon clients are overdue for a rebook — read a client CSV (name, last visit, average interval), get the overdue list sorted worst-first, and send reminders before chairs sit empty. Comes with SMS/email reminder templates and a no-show policy wording block. Use when running a hair salon, barbershop, nail studio, or spa that lives on repeat bookings.
$ skillbank install salon-ops@1.0.0 # pins exactly 1.0.0 · README + changelog included
Salon Ops
Overview
Most salons lose money quietly: a client whose color fades at week six simply never rebooks, and nobody notices until the chair is empty on a Saturday. Salon Ops reads your client list, compares each client's last visit against their normal interval, and hands you a call-down list sorted by days overdue — worst first — plus the reminder templates and no-show policy to do something about it.
Everything runs on your own machine. The script reads your CSV and prints the report — nothing is uploaded anywhere.
Installation
1. Copy the salon-ops/ directory anywhere convenient. 2. Make the script executable (Unix):
chmod +x scripts/retention.py
No pip install needed — standard library only.
Configuration
The calculator reads a CSV with a header row:
name,last_visit_date,avg_interval_days
Jonah Park,2026-06-19,60
Amara Okafor,2026-07-19,42
name— client name.last_visit_date— ISO date (YYYY-MM-DD) of their most recent appointment.avg_interval_days— their normal gap between visits, in whole days.
Update the CSV after each appointment day — even a weekly export from your booking system works. Use --today YYYY-MM-DD to run the report as of a specific date (handy for testing or backdated runs).
Inputs
| Input | Required | Description | |-----------|----------|----------------------------------------------------------------| | clients | yes | CSV file with name,last_visit_date,avg_interval_days. | | --today | no | Report date (YYYY-MM-DD); defaults to the real today. |
Output: the overdue client list sorted by days overdue (most overdue first), with last visit, interval, days since visit, and days overdue per client, plus a count of clients still on track.
Worked example
$ cat clients.csv
name,last_visit_date,avg_interval_days
Jonah Park,2026-06-19,60
Amara Okafor,2026-07-19,42
Ben Ruiz,2026-08-28,28
Priya Nair,2026-08-13,45
Dana Cole,2026-09-07,21
$ ./scripts/retention.py clients.csv --today 2026-09-27
Rebooking report — 2026-09-27 (3 of 5 clients overdue)
Client Last visit Interval Days since Overdue
----------------------------------------------------------------
Jonah Park 2026-06-19 60 100 40
Amara Okafor 2026-07-19 42 70 28
Ben Ruiz 2026-08-28 28 30 2
Suggested outreach order: most overdue first.
On track: 2 client(s) still within their interval.
Jonah is 40 days past his 60-day interval — he gets the first text. Priya is exactly on her 45-day interval and Dana is well within hers, so neither is flagged.
Playbooks
- SMS and email reminder templates — 48-hour, day-of, and win-back messages for overdue clients.
- No-show policy wording — a fair, enforceable cancellation policy block for your booking page and intake forms.
Safety notes
This is a benign business tool. Client data never leaves your machine; the script makes no network calls. Sending SMS or email reminders is your action, through your own provider — the skill only drafts the words.
Version history
Changelog
1.0.0 — 2026-09-27
- Initial release:
scripts/retention.pyrebooking report (CSV in, overdue - Playbooks: SMS/email reminder templates and no-show policy wording.
list sorted by days overdue, optional --today override).