XPRNS · patterns · services pack ← all loops

WHAT LEADS TO WHAT — Salon / clinic / appointment services

374 clients across 253 days

228 minutes of desk work replacedpython -m loops patterns salon_bookings.csv --pack servicessalon_bookings.csv
10spending less1questions nearly answerable

Do this 2

  1. These are still coming, so this is a conversation at the chair rather than a win-back campaign.
  2. A rush is only worth staffing for if the people in it return. This says whether yours do.
10spending less

10 regulars are quietly spending less than they used to

do something
27 regulars who moved
10 spending less 37%17 spending more 63%

These are still coming, so this is a conversation at the chair rather than a win-back campaign.

7 lines
  • Rosa Pike (7 visits) — was $145.00 a visit, now $47.50 (-67%)
  • Ada Quill (6 visits) — was $190.00 a visit, now $65.00 (-66%)
  • Hana Frost (6 visits) — was $142.50 a visit, now $55.00 (-61%)
  • Zeb Vance (9 visits) — was $127.50 a visit, now $55.00 (-57%)
  • Ada Ortiz (6 visits) — was $145.00 a visit, now $65.00 (-55%)
  • Sam Ives (6 visits) — was $145.00 a visit, now $65.00 (-55%)
  • Measured against each person's own earlier visits, not against anybody else. 17 moved the other way.

Discount-acquired clients may come back less often — 75% against 83%, on too few to call

indicative evidencekeep an eye on
came back for a second visit
on an offer75% of 127
at full price83% of 247
at full price — 83%
5 lines
  • First visit on an offer — 75% came back (95 of 127)
  • First visit at full price — 83% came back (205 of 247)
  • Not yet separable from chance. on an offer sits on 127 clients; it would take about 140 in that group to settle whether this is real.
  • Reported as a lead rather than a finding. Worth watching, not worth restructuring around.
  • Two groups, compared against each other across 374, both with 12+ people.

Clients who first came in on a quiet day come back more often — 87% against 76%

keep an eye on
came back for a second visit
a quiet day87% of 141
a busy day76% of 233
a busy day — 76%

A rush is only worth staffing for if the people in it return. This says whether yours do.

4 lines
  • First came in on a quiet day — 87% came back (123 of 141)
  • First came in on a busy day — 76% came back (177 of 233)
  • Range for a quiet day is 81%-92%, and the gap against the other group holds at both ends. That is why it is here.
  • Two groups, compared against each other across 374, both with 12+ people.
1questions nearly answerable

1 question this file is close to answering, the nearest about a month away

2 lines
  • whether the discount buys customers who stay — one more month of files, on 127 of the 140 it needs
  • Estimated from your own arrival rate of about 56 new clients a month. Nothing here is withheld — these are questions your data cannot answer yet.

Not in this export

Each of these needs a column your file does not have. They are named rather than silently reported as zero, because a confident nought is the one thing a brief must never print.

How this was read