ATTENDANCE LOG FIELD GUIDE

Delete the sample rows before using this sheet. Keep the file private.
Use booking references instead of duplicating names or contact details.

Outcome: attended, no-show, cancelled in advance, or cancelled late.
Define late cancellation according to your published policy and use it consistently.
Known reason: facts shared by the client; otherwise write unknown.
Follow-up: the action taken, not speculation about the person.
Opening refilled: yes, no, or not applicable.

No-show rate = no-shows / (attended + no-shows).
Example: 3 no-shows and 47 attended = 3 / 50 = 6%.
Exclude cancelled visits from that denominator and report cancellations separately.
Use comparable dates and definitions when comparing periods.
This spreadsheet is a manual worksheet, not a beesolo analytics export.