Back to Salon Industry Statistics
Data & tools · Salon And Spa

Seasonal Demand Patterns Template

A spreadsheet template for recording seasonal demand month by month: the columns that matter, the disruption log beside it, and how to keep it usable next year.

Cited Canadian evidence asset (template).

Most seasonal analysis fails at the spreadsheet, not at the arithmetic. The rows do not line up, a closed fortnight is missing, nobody wrote down that the second chair arrived in March, and by the second year the file has been copied three times with slightly different columns. A template is worth having because it fixes those decisions once.

What the template has to hold

The file needs four things: one row per period with no gaps, a count of demand, a measure of the capacity that demand met, and a note column for anything that broke the normal pattern. Everything else is optional.

Period | Booked | Kept | Hours booked | Staffed hours | Status | Capacity change | Note
2025-01 |        |      |              |               |        |                 |
2025-02 |        |      |              |               |        |                 |
2025-03 |        |      |              |               |        |                 |

Keeping the rows empty until the export is pulled is deliberate. A template people fill from memory stops being a record.

The columns, and why each earns its place

Booked and kept are separate because the distance between them is the no-show problem, and that problem has its own fixes. A month that looks soft on bookings and normal on kept appointments is a different month from one where both fell.

Hours booked matters as soon as the service mix moves. A shift toward longer appointments keeps the calendar full while reducing the count, and a template that only counts appointments will read that shift as falling demand.

Staffed hours is the capacity side. Without it, a quiet month and a month that was quiet because two chairs were empty look identical.

Status records whether the period was open normally, open on reduced hours, or closed. This column prevents the most common error in the whole exercise, which is treating a shutdown as low demand.

Capacity change is a note about the business rather than the market: a chair added, a room lost, a practitioner on leave for a stretch.

Filling a row without guessing

Pull the export on the same day each period, from the same system, with the same filters, and write the export date in a corner cell. Then fill one row per period before looking at any totals. Filling a whole year at once invites pattern-matching, and pattern-matching is how a spreadsheet starts agreeing with whatever the owner already believed.

Where a number cannot be sourced, leave it blank and say why in the note column. A blank with a reason is a prompt to fix the process. An estimate with no note is a number that will be treated as fact in eight months.

The disruption log beside it

A second sheet, short and plain, listing anything that changed the shape of a period: closures, promotions, renovations, staffing changes, a competitor opening or closing nearby, unusual weather if it kept people home.

Each entry gets a date range, a one-line description, and whether it lifted or suppressed demand as far as anybody can tell. Speculation is acceptable here as long as it is labelled as speculation. The log exists so that next year's reader does not have to reconstruct history from a spike with no explanation.

Keeping it usable next year

Name the file with the base window inside the filename, and keep one file rather than one per year. Freeze the header row. Do not add a column mid-year without filling it backwards, because a half-populated column is worse than an absent one.

Write two lines at the top: the period length, and the rule for closed periods. Anybody who opens the file should be able to reproduce the numbers without asking a question.

Handing it over

A template that only one person understands is a single point of failure in a business where people change roles. Hand it over with three sentences: where the export comes from, which columns the arithmetic uses, and what the note column is for. Then ask the person receiving it to fill one row while you watch. If they hesitate, the template is not finished.

The completed template feeds the seasonal demand patterns calculator directly, and the checklist covers the checks worth running before the numbers are used. Where a pattern points to coverage, an AI receptionist for salons answers around the clock, books appointments, captures caller details, and escalates urgent calls to a person.

Frequently asked questions

Can the template live in the booking system instead of a spreadsheet?

Partly. A booking export can supply appointments and hours, but it will not record that a fortnight was shortened for a holiday or that a chair was out of service. The template keeps those notes beside the counts, which is what makes the counts readable a year later.

How many rows should the template hold?

One row per period for the whole base window, with no gaps. If a period was closed, the row stays and says so. Deleting the quiet rows is the fastest way to make a seasonal pattern look flatter than reality.

Should the template include revenue?

Only as a separate column, and only if the books are closed the same way each period. Mixing revenue into a demand count turns two questions into one confusing number, and it makes the template depend on an export the front desk cannot produce.