Using Business Intelligence Canned Reports : Report Parameters : Appointment reports
  

Appointment reports

These reports give an indication of how many booked Appointments there were, how many of the Customers actually arrived at their Appointment, if they arrived late, and for how long they waited before they were called to their Appointment.
Appointment Booking
This report is used to get information about when Appointments are booked, no matter if the Appointment time has yet occurred, or not.
With this report, you can also see if there is any difference in Appointments booked at different times, for example if there are periods when the Appointments are booked closer to the Appointment time. This report also monitors changes, such as cancellations and reschedules.
All data is combined and shown on the same page.
The following data is shown:
Name
Definition
Date
Shows Day, Week, Month, Year or Weekday, depending on the View parameter.
Total number of bookings
The number of Appointments booked during the selected period, no matter if they have been cancelled or not.
Note: That is when the Appointment was booked, not the date for the Appointment.
Number of changes
The number of times that the same Appointments as above have been changed. Each change is counted.
Number of cancellations
The number of Appointments that were cancelled. These must be the same Appointments included in the bookings so that the whole report covers exactly the same Appointments.
Number of still open appointments
This is the same as the number of bookings minus the number of cancellations.
Average number of days between booking and appointment
The average booking time in days (one decimal).
Average number of days between cancellation and appointment time
The average number of days between a cancellation and the Appointment time.
 
 
Appointment Booking Time per Period
This report is used to get detailed information on exactly how long time in advance Appointments were booked. Also, you can, for example, find out the percentage of Customers that book their Appointments less than two days in advance.
All data is combined and shown on the same page.
 
The following data is shown:
Name
Definition
Date
Shows Day, Week, Month, Year or Weekday, depending on the View parameter. The report shows Appointments booked the selected date, not Appointments that are expected to take place the selected dates.
Intervals
Number of Appointments booked the within this time before the Appointment start time. The specified time is the end of the interval. For example, above the first column are Appointments booked 0-2 days before the Appointment, the next are those booked 2-4 days, etc.
Cancellations
The number of Appointments included in the report that were cancelled.
Changes
The number of Appointments included in the report that have been changed since they were booked.
Totals
Sum of the columns.
%
Percentage
Acc %
Accumulated percentage
 
Appointment Overview
This report is used to get an overview of all Appointments that have been served. The report shows a sum of all selected Branches.
All data is combined and shown on the same page.
 
The following data is shown:
Name
Definition
Date
Shows Day, Week, Month, Year or Weekday, depending on the View parameter.
Number of booked appointments
Number of Appointments that were booked for the selected date.
Customers that did arrive
Number of journeys that had an Appointment and where the journey reached event VISIT_CREATE.
% of customers that did arrive
Calculated value.
Late arrivals
Number of Appointments where the Customer arrived late.
Number of customers that responded to call
Number of Customers that actually arrived at the Counter.
Average waiting time
Average waiting time for all transactions where the Customer arrived to the Appointment.
Average waiting time after appointment time
Average Appointment waiting time.
Average transaction time
Average transaction time.
Average number of days in advance the appointment was booked.
The average booking time in days (one decimal).
Totals
Sum of columns, for averages this is the average of all Customers, not the average of the shown averages.
Average
For columns with numbers this is the same as the average of the column. For columns already containing average values this is the average for all included transactions, not for the column.
 
 
Appointment Service Overview
This report is used to get an overview of all Appointments that have been served (or expected to be served). It shows information per Service, i.e more detailed information than the Appointment Overview report.
Here, you can compare the transaction time with the booked Appointment length, to find out how well the reserved time slots are working. Also, you can compare the Appointments for different Services, for example to see if certain Services are booked longer in advance than others, or if there are differences in the number of late arrivals. You can also see the average number of Customers per Appointment and Service.
All data is combined and shown on the same page.
 
The following data is shown:
Name
Definition
Date
Shows Day, Week, Month, Year or Weekday, depending on the View parameter.
Services
Services served by an Appointment Queue.
Number of booked appointments
Number of Appointments that were booked for the selected date.
Customers that did arrive
Number of journeys that had an Appointment and where the journey reached event VISIT_CREATE.
% of customers that did arrive
Calculated value.
Late arrivals
Number of Appointments where the Customer arrived late.
Average waiting time
Average waiting time for all transactions where the Customer arrived to the Appointment.
Average waiting time after appointment time
Average Appointment waiting time.
Average transaction time
Average transaction time.
Number of appointments that took longer time than booked appointment time.
This is the number of Appointments that took longer time than the booked Appointment time.
% of appointments that took longer time than booked appointment time
Same as above, but percentage instead of number.
Average difference in time between transaction time and appointment length
This is the average difference in time between transaction time and the booked Appointment length in hh:mm:ss. Positive value if the Appointments in average take longer than the booked length and a negative value if the Appointments in average take a shorter time than the booked Appointment length.
Average number of days in advance the appointment was booked
The average booking time in days (one decimal).
Average number of customers per appointment
The average number of Customers per Appointment
Totals
Sum of columns. For averages, this is the average of all Customers, not the average of the shown averages.
Average
For columns with numbers this is the same as the average of the column. For columns already containing average values this is the average for all included transactions, not for the column.
 
Appointment Waiting Time per Period
This report is used to get detailed information on the Appointment Time.
All data is combined and shown on the same page.
 
The following data is shown:
Name
Definition
Date
Shows Day, Week, Month, Year or Weekday, depending on the View parameter.
Called before appointment time
Number of Customers that were called before the Appointment time.
Intervals
Number of Customers with an Appointment waiting time within each interval. The column shows the end of the interval.
Totals
Sum of the columns.
%
Percentage
% Cumulative
Accumulated percentage