Square Appointments Reporting
With Square Appointments Plus, you have access to Appointments Reporting, which includes the Team Performance report.
The Team Performance Report allows you to:
Measure your team member or business performance, whether you manage a team or you’re a sole proprietor.
See real-time performance metrics for retention and pre-booking, based on appointments data (not based on sales).
The Team Performance report includes two metrics: client retention and pre-booking. Both metrics look only at appointment visits which are defined as appointments that are not canceled or marked as “no-show.”
The maximum date range for this report is one year. Recurring appointments are not yet fully supported in metric calculations and are only included in calculations once they are paid or edited (rescheduled or service/team member change).
Client Retention
Client retention is a ratio defined as the number of returning clients divided by the number of total clients. A return client is defined as a client that visited within a year before the date range. Total clients is the number of clients that had a visit in a date range.
For example, assume:
The date range is set to Jan 1, 2022 - March 31, 2022.
Only one client had appointments during that date range.
| Example | Client rate | Calculation | Explanation |
|---|---|---|---|
| Client came in for their first appointment visit in December 2021 and for a second appointment in March 2022 | 100% | 1 returning client divided by 1 total client | The client is considered a returning client within the date range |
| Client came in for their first appointment visit in January 2021 and for a second appointment in March 2022 | 0% | 0 returning clients divided by 1 total client | The client is considered a new client within the date range because they did not visit within a year before the date range |
| Client came in for their first appointment visit in January 2019 and for a second appointment in March 2022 | 0% | 0 returning clients divided by 1 total client | The client is considered a new client within the date range because they did not visit within a year before the date range |
Pre-booking
Pre-booking is a ratio defined as the number of visits when the client pre-booked divided by their total number of visits. To qualify as a pre-booking, a client must book at least one future appointment within 24 hours of their current appointment end time.
Pre-booking helps you measure whether you or your staff successfully secure a future appointment with the client at a current appointment. If the future appointment booked is canceled or marked as no-show, the current appointment will no longer count as pre-booked since that future appointment is no longer secured.
If there were previously booked future appointments, the current appointment does not count as pre-booked. A future appointment must be booked within the time range described above.
For example, assume:
The date range is set to Jan 1, 2022 - March 31, 2022.
Only one client had appointments that year.
The client came in for an appointment visit on January 1, 2022.
At the January 1 appointment, the client pre-books their next appointment for April 2022.
| Example | Pre-booking rate | Calculation | Explanation |
|---|---|---|---|
| Client had no other additional action. | 100% | 1 visit with a pre-book divided by 1 total visit | The client pre-booked at the January 1 appointment |
| Client has another appointment visit on January 15, 2022 and doesn’t pre-book at the January 15 visit. | 50% | 1 visit with a pre-book divided by 2 total visits | The client pre-booked at the January 1 appointment but not the January 15 appointment |
| Prior to the January visit, the client already had an appointment booked for May 2022. | 100% | 1 visit with a pre-book divided by 1 total visit | The previously booked appointment in May does not count as a pre-booking since it was not booked within the 24 hour time range. |
| Prior to the January visit, the client already had a monthly recurring appointment scheduled for the 15th of every month starting April 2022. | 100% | 1 visit with a pre-book divided by 1 total visit | The previously booked recurring appointments do not count as a pre-booking since it was not booked within the 24 hour time range. |
| The client cancels or no-shows the April 2022 appointment. | 0% | 0 visits with a pre-book divided by 1 total visit | The future appointment is no longer booked; therefore a pre-booking no longer occurred |
Filters
Use the date range, location, team member, or service filters to adjust your report for specific metrics.
Use the display by service or by team member drop-down option to easily compare metrics across all services or all team members in one table.
You can see the following columns in the table:
Client retention
Total clients
Pre-booking
Total appointments
Note: When filtering by location, team member, or service, metrics will calculate based only on appointments that match those filters. Display by service or team member will not show rows for services or team members when there are no appointments that match the selected service or team filter.
Permissions
By default, each team member can view their own metrics. When a new team member is created, they will also be able to view their own metrics. For team members to have visibility into all team members’ metrics, you will need to edit their permissions. To do so:
1. Go to Team > Permissions in your Square Dashboard.
2. Select Edit Permissions.
3. Select Reports and check the boxes for View Appointment Reports and View all team member’s reporting.