XPRNS · end of day · services pack ← all loops

END OF DAY — Salon / clinic / appointment services

2026-07-31

27 minutes of desk work replacedpython -m loops eod salon_bookings.csv --pack servicessalon_bookings.csv
25%of booked services46clients overdue4servicesnormal4 against a usual 54clients

Do this 3

  1. Run the lapsed list before the next quiet day.
  2. Pair Balayage with Cut & Colour rather than discounting them separately.
  3. Ask at the desk. Signing up the un-enrolled half is the cheapest thing on this page.
4services

4 services across 4 clients, $635.00

4services
4clients
$635.00taken
$158.75per service
3 lines
  • 4 records, 4 clients identifiable
  • $635.00 taken, $158.75 per service
  • 1 record across the file has no name or contact — counted in the money, not in the clients
normal4 against a usual 5

A normal day: 4 services against a usual 5 (1-12)

usual 4.6 4
1 usual range · services 12
1 line
  • Compared against all 252 comparable period(s) in this export.
25%of booked services

1 service booked in did not turn up (25%)

do something
15% — reminder problem above here
25% of booked services
1 line
  • Above 15% is usually a reminder problem rather than a customer problem.
46clients overdue

46 clients are now overdue against their own pattern

do something
46 clients
19 overdue 41%27 long gone 59%

Run the lapsed list before the next quiet day.

5 lines
  • Zeb Pike (3 visits) — 180 days, usually 26
  • Femi Jansen (3 visits) — 164 days, usually 33
  • Gus Ives (3 visits) — 149 days, usually 30
  • Tess Nowak (1 visits) — 247 days, usually 54
  • Elin Ives (4 visits) — 141 days, usually 31

47% of everyone who buys Balayage also buys Cut & Colour

keep an eye on
of Balayage clients
Cut & Colour47% · 75 people
Blow Dry39% · 62 people
Treatment38% · 61 people

Pair Balayage with Cut & Colour rather than discounting them separately.

3 lines
  • Cut & Colour — 47% of Balayage clients (75 people)
  • Blow Dry — 39% of Balayage clients (62 people)
  • Treatment — 38% of Balayage clients (61 people)

Programme members spend $13.67 more a visit than everyone else

keep an eye on
median spend a visit
members$110.00
everyone else$96.33

Ask at the desk. Signing up the un-enrolled half is the cheapest thing on this page.

4 lines
  • Members — $110.00 a visit, 3 visits each
  • Everyone else — $96.33 a visit, 2 visits each
  • 215 of 374 clients in this file are enrolled (57%).
  • Joining is something regulars do. This says members are worth more, not that the programme made them so.
4clients

4 of 4 clients had been in before (100%)

4 clients
4 been in before 100%
1 line
  • 0 first-timer(s). Measured against 252 earlier day(s) in this file — anyone whose first visit predates the export reads as new here.
3regulars in

3 of today's clients are regulars (3+ visits)

3 lines
  • Nia Vance (6 visits)
  • Nia Tran (5 visits)
  • Ivo Slater (5 visits)

Top service: Balayage (2, 50% of today)

services
Balayage50%
Cut & Colour25%
Colour25%
3 lines
  • Balayage — 2 (50%)
  • Cut & Colour — 1 (25%)
  • Colour — 1 (25%)

Josie led on takings today ($255.00 against Mika's $190.00)

thin evidence
taken
Josie$255.00
Del$190.00
Mika$190.00
4 lines
  • Josie — 2 services, $255.00
  • Del — 1 service, $190.00
  • Mika — 1 service, $190.00
  • One day is one day. This is worth acting on as a trend, not tonight.

How this was read