Scheduled appointments
Record grain: appointment occurrence
Date basis: Appointment start date
Rules: Superseded occurrence excluded; recurring occurrences remain distinct
Appointments · Google Sheets sample
GoHighLevel Bookings & Attendance report template
Compare appointment outcomes and attendance by calendar. Use the resolved attendance definitions to distinguish a recorded no-show from an appointment whose outcome has not been entered.
Bookings & Attendance
Invented sample · Fixed as of October 13, 2026 · USD · America/Chicago
Change filters to explore the sample locally. No account connection.
Scheduled appointments9Appointment start date
Attended3Appointment start date
No-shows2Appointment start date
Show rate60%3 of 5 resolved appointments
Attendance outcomes over time
AttendedNo-showUnresolved
2026-10-01–2026-10-13 · Daily · Appointment start date
View chart data
| Group | Value | Attended | No-show | Unresolved |
|---|---|---|---|---|
| 2026-10-01 | 0 | 0 | 0 | 0 |
| 2026-10-02 | 1 | 1 | 0 | 0 |
| 2026-10-03 | 1 | 0 | 1 | 0 |
| 2026-10-04 | 1 | 0 | 0 | 1 |
| 2026-10-05 | 0 | 0 | 0 | 0 |
| 2026-10-06 | 1 | 1 | 0 | 0 |
| 2026-10-07 | 1 | 0 | 1 | 0 |
| 2026-10-08 | 1 | 0 | 0 | 1 |
| 2026-10-09 | 0 | 0 | 0 | 0 |
| 2026-10-10 | 0 | 0 | 0 | 0 |
| 2026-10-11 | 0 | 0 | 0 | 0 |
| 2026-10-12 | 0 | 0 | 0 | 0 |
| 2026-10-13 | 1 | 1 | 0 | 0 |
Show rate by calendar
View chart data
| Group | Value |
|---|---|
| Estimates | 100% |
| Consultations | 0% |
| Customer | Appointment date | Calendar | Assigned person | Status | Reason |
|---|---|---|---|---|---|
| Noah Davis | 2026-10-03 | Consultations | Jamie Chen | No-show | No-show |
| Ava Wilson | 2026-10-04 | Estimates | Sam Rivera | Unresolved | Attendance not recorded |
| Ethan Brooks | 2026-10-07 | Consultations | Sam Rivera | No-show | No-show |
| Sophia Lee | 2026-10-08 | Estimates | Alex Morgan | Unresolved | Attendance not recorded |
What the metrics mean
Attended
Record grain: appointment occurrence
Date basis: Appointment start date
Rules: Validated Attended status
No-shows
Record grain: appointment occurrence
Date basis: Appointment start date
Rules: Validated No-show status
Show rate
Record grain: appointment occurrence
Date basis: Appointment start date
Rules: Attended / (Attended + No-show); cancelled and unresolved excluded
Required data and boundaries
- Appointments and calendar scope
Show rate uses resolved attendance outcomes. Confirmed or unresolved appointments do not silently become attended appointments, and recurring occurrences retain their identities.
2 cancelled appointments excluded from show rate. Recurring occurrences remain separate; superseded bookings excluded.
Early access · These public previews use invented records. Join early access to discuss connecting your own GoHighLevel account.
From this sample to a connected report
Choose the template
Use the report whose definitions match the decision you need to make.
Check required inputs
Confirm source access, relevant mappings, history, and any configured goals.
Create the worksheet
The early-access design reuses compatible imports and creates a report worksheet.
Choose freshness
Select source refreshes deliberately. New executions transferring records add usage.
Related report samples
Bring your own reporting question.
Make this your reporting workflow.
Explore the samples now. Join the existing waitlist to request connected early access, or discuss a predictable subscription for larger workloads.