Back to Salon Industry Statistics
Data & tools

Client Lifetime Value Benchmarks Template

A worksheet layout for client lifetime value, with the columns to keep, how to fill them period by period, and which fields stay empty at the start.

Cited Canadian evidence asset (template).

A template earns its keep by making the same columns appear in the same order every period, so that the comparison is between businesses and not between spreadsheets. The layout below is deliberately plain. One summary row per cohort, a detail tab underneath, and a short block of definitions at the top that nobody is allowed to edit quietly.

The worksheet columns

Column What it holds Where it comes from
Cohort label Month and year of first visit First-visit field
Clients acquired Count of first visits in that month Booking export
Completed visits Visits by that cohort to date Booking export
Service revenue Collected service revenue from those visits Payment records
Average value per visit Service revenue divided by completed visits Calculated
Visits per client Completed visits divided by clients acquired Calculated
Value to date per client Service revenue divided by clients acquired Calculated
Dormant count Clients with no visit past the threshold Calculated
Notes Definition changes, one-off events Written by hand

Nine columns is enough. Every additional column is a place for a definition to drift.

Filling in a row

Start at the left. The cohort label is fixed once written and never revised, because a cohort is a group of people defined by when they arrived, not by what they have done since.

Clients acquired comes from the first-visit count for that month. If the first-visit field is missing for older records, the row either starts at the point the field became reliable or it is left blank with a note. A row built on guessed dates is worse than a missing row, because it will be compared against better data later.

Completed visits and service revenue are pulled for the whole cohort, not for a fixed window after acquisition. That is what makes the rows comparable: a cohort from two years ago has had longer to accumulate visits, and the column shows the accumulation rather than hiding it.

The calculated columns are formulas, never typed. The moment one is typed, the file stops being a template.

Columns that stay empty for a while

A cohort acquired last month has almost no value to report. Its visits per client sit near one, its value to date per client equals roughly a single ticket, and the dormant count is meaningless.

Leave those cells blank or mark them as immature rather than filling them with a zero. A zero reads as a failure in a chart, and someone will eventually act on it.

The same applies to the projected lifetime column, if you add one. It belongs on a separate tab, clearly labelled as a projection, so that observed value and forecast value never sit side by side without a heading between them.

Keeping the file honest

Three habits protect the template. Add a row, never overwrite one. Record any change of definition in the notes column on the date it happened, with the period it applies from. And keep a copy of the raw export beside the worksheet so a row can be rebuilt without asking the booking system for history it may no longer hold.

If a definition does change, start a new sheet rather than editing the old one. Two sheets with a stated break are easier to read than one sheet with an invisible discontinuity.

Review cadence

Fill the worksheet monthly, because the export is cheap then and the memory of what happened is fresh. Read it quarterly, which is the interval at which a cohort has usually shown whether it is settling in.

At each reading, look at two things: whether the newest mature cohort is tracking above or below the one before it, and whether the dormant count is rising faster than the acquired count. Those two observations cover most of what a lifetime value exercise is for.

Elevoi feeds the left-hand columns. Calls are answered at any hour, bookings land in the live calendar, caller details are captured and SMS confirmations sit against the appointment, so a first visit is recorded rather than remembered. Escalation to a person keeps urgent calls from becoming notes in a voicemail box.

Pair the worksheet with the checklist before the first fill, and keep the explainer nearby for the horizon question.

Frequently asked questions

Where should the template live?

In the same place as the booking export, with the period in the filename. A worksheet that travels by message thread loses its definitions within a month.

One row per client or one row per cohort?

One row per cohort, with a separate detail tab holding the client-level records. The summary row is what you compare; the detail tab is what you check when a row looks wrong.

Can the template be used for a single practitioner?

Yes, and it is easier there, because the cohort is smaller and duplicates are rarer. The columns do not change with size.