A retention figure is only as good as the records underneath it. Most of the work in producing a trustworthy number is not arithmetic; it is auditing the inputs before the division happens. Run this list in order, once, and then again whenever the figure moves in a way nobody can explain.
Audit the client list first
- One record per person. Duplicates arrive when a client books by phone with a mobile number and online with a home number, and they double-count that client in the group who were due.
- Choose an identity key and hold to it. A normalised mobile number is the usual choice, with email as a fallback for clients who book without one.
- Remove the placeholders. Walk-in records, cash-sale records, and test entries made during setup are not clients, and they cannot lapse.
- Mark inactive records. A client who asked to be removed, moved away, or died should be excluded rather than counted as a failure to return.
- Note shared numbers. Two members of one household booking on a single phone need separate records with the number repeated, or they will look like one client who visits twice as often.
- Check the display name field is usable. A list you cannot read by eye will not be checked by anyone, and an unchecked list drifts within a few months.
Audit the calendar
- Every appointment lives in one system. A paper book beside an online calendar guarantees visits that never reach the count.
- Cancellations are logged as cancellations. Deleting them is the single most common reason a rate looks better than the business feels.
- Reschedules are logged as reschedules. The original slot was released and a new one taken; treating that as a cancellation and then counting the new visit describes the same client twice in two directions.
- No-shows are marked as no-shows. They are a different failure from a cancellation and they belong on their own line.
- Past appointments are not edited after the fact. Corrections belong in a note, not in a silent change to a date, because the history is the evidence.
Audit the definition in writing
- Who counts as due, in one sentence
- How long the window is, and why that length was chosen
- Whether a cancelled-then-rebooked visit counts as a return
- Which date keys the cohort, when a cohort is being used
- Where the definition is stored, so the next person to run the numbers uses the same one
A definition that lives only in someone's head leaves with that person.
Audit the comparison
- Same definition, same window, same segments on both sides of any comparison.
- Season against season. This month against the same month a year earlier survives a slow stretch; this month against last month mostly measures the calendar.
- Small groups move. Treat a change in a group of a few clients as a question, not a finding.
- Note what else changed in the same month: a price change, a new staff member, a booking channel switched on or off, a holiday week.
Audit the follow-up
The checklist is not finished when the number is correct. It is finished when someone has read it.
- One named person owns the figure and its explanation.
- The lapsed list is worked, not just counted, with a call or a message to each client.
- The rebooking-at-the-desk figure sits beside the rate, because that is the lever the front desk controls.
- Last month's notes are read before this month's number is discussed.
Elevoi supports the last item on that list: it answers calls, offers openings to the clients who ring back, and records what happened against the client. The retention rate benchmarks calculator covers the arithmetic once the inputs pass this audit.