Turnaways data model
The Turnaways data source provides information about all waitlists and turnaways, the final status of these requests, and other attributes of each request such as requested date and time slot and therapist.
When guests call in for appointments on busy days or during peak times, front-desk executives can capture the guests' requests in the waitlist. This information can later be used to convert the waitlist into a confirmed appointment when a guest's preferred slot becomes available.
If the guest's preferred time slot does not become available, the waitlist can then be converted to a turnaway. The front-desk executive can also directly mark the guest's request as a turnaway.
Example use cases
Number of turnaways over time
Number of turnaways by service
Requests by current status
Granularity of the data
At the most basic level, every waitlist or turnaway record is created as a separate row. When the status of a request changes, the record is updated to reflect the latest status. Furthermore, when a guest mentions multiple days or multiple times as preferred slots at the time when the waitlist is created, each slot gets created as a separate row.
In the following table, the pink rows display requests that have been converted to confirmed appointments. This is indicated by the turnaway status field for the respective record. The appointment start date time in center and appointment end date time in center fields indicate the start time and end time of the preferred slots mentioned by the guest at the time of waitlist creation. The corresponding appointment ID of the confirmed appointment is specified in the appointment id field. The turnaway date time in center field indicates the timestamp at which the request moved from waitlist to converted status.
The blue rows in the table display requests for which the status is TurnAway. The turnaway reason is also specified for those records.
In the table, the gray rows display requests for which the status is WaitList. One of the guests (Harry) specified multiple days as preferred slots. As a result, three different rows have been created for him. Another guest (Mike) also has a waitlisted request. Mike mentioned Michelle as the preferred therapist when the waitlist was created. This is reflected in the Therapist First Name field.
Note: This data source is only relevant for service appointments. Classes information does not flow into this data source. The corresponding information for Classes is captured in the Registrations data source.
Group | Description | Field | Definition | Examples/Notes | Data Type |
|---|---|---|---|---|---|
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | organization name | Formal name of the organization. | Massage Spa Express is the formal name of an organization. | varchar(512) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | organization account name | Domain name of the organization in Zenoti. | If you use the https://massagespa.zenoti.com URL to log in to Zenoti, massagespa is your account name. The formal name and domain name may be different. | varchar(256) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | center name | Center in which the waitlist/turnaway is recorded. | varchar(128) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | center company name | Name under which the center is registered. | Businesses, especially in a franchisee model, may register each center as a different company - such details are tracked on the Centers > General tab. | varchar(128) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | is center franchise | A flag that indicates whether the center is a franchisee. - True: center is a franchisee. - False: center is not a franchisee. | boolean | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | center cstn number | Central Sales Tax (CST) number of the center. | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | center tin number | Taxpayer Identification Number (TIN) number of the center. | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | center tot number | Transient Occupancy Tax (TOT) number of the center. | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | center service tax number | Service tax number of the center. | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | center vat number | Value Added Tax (VAT) identification number of the center. | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | center luxary tax number | Luxury tax number of the center. | varchar(80) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center in which the waitlist/turnaway entry is recorded. | minutes to add | Number of minutes that need to be added to UTC time to calculate the current time at the center. Timestamps that are generated by Tableau (for example, if you use filters such as Today and Tomorrow) are in UTC. As a result, you need this field to find out the current center time. Note: You do not need this field for timestamps that are directly in the data source - these timestamps are already in the centerÕs time zone. | integer | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest first name | First name of the guest for whom the waitlist/turnaway entry is created. | varchar(160) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest middle name | Middle name of the guest for whom the waitlist/turnaway entry is created. | varchar(128) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest last name | Last name of the guest for whom the waitlist/turnaway entry is created. | varchar(256) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest code | Unique code of the guest for whom the waitlist/turnaway entry is created. This maps to the guest code in a guest's profile in Zenoti. | varchar(128) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | user wid | System-generated value to uniquely identify each guest.This is generated in Analytics; it does not exist in the core system. | bigint | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest address 1 | Guest's address 1 details. | varchar(2048) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest address 2 | Guest's address 2 details. | varchar(2048) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest city | City to which the guest belongs. | varchar(128) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest state | State to which the guest belongs. | varchar(4096) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest country name | Country to which the guest belongs. | varchar(4096) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest zipcode | Zipcode of the guest's address. | varchar(128) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest type name | Indicates whether the guest is indeed a guest or an employee. | Possible values: - Guest - Employee - Internal Guest/Virtual Guest: Guests who made their first purchase on Webstore. | varchar(128) |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest email | Email ID of the guest. | varchar(256) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest mobile phone | Mobile phone number of the guest. | varchar(64) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest home phone | Home phone number of the guest. | varchar(64) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest phone code | Phone country code of the guest. | integer | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest gender | Gender of the guest. | varchar(14) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest dob | Date of birth of the guest. | timestamp | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | referred by guestid | User ID of the person who referred the guest. | varchar(36) | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest anniversary date | Marriage anniversary date of the guest. | timestamp | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | is guest inactive | A flag that indicates whether the guest is inactive. A guest is considered inactive if his/her profile has been removed from the system. - True: Guest is inactive. - False: Guest is active. | boolean | |
Guest | These fields detail the attributes of the guest for whom the waitlist/turnaway entry is created. | guest tags | Tags associated with the guest. | Tags can be set up for guests in their profile under the General tab. These will be comma-separated values if there are multiple tags. | varchar(65535) |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | createdby employee first name | First name of the employee who created the waitlist/turnaway entry. | varchar(160) | |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | createdby employee middle name | Middle name of the employee who created the waitlist/turnaway entry. | varchar(128) | |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | createdby employee last name | Last name of the employee who created the waitlist/turnaway entry. | varchar(256) | |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | createdby employee - code | Unique code of the employee who created the waitlist/turnaway entry.This code is taken from the employee's profile in Zenoti. | varchar(128) | |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | createdby employee code | Unique code of the employee who created the waitlist/turnaway entry. This code is taken from the employee's guest profile. When an employee's profile is created, Zenoti automatically creates their guest profile. Note: The employee code is usually the same as employee - code, unless someone manually changes it in the employee's guest profile. | DO NOT USE- THIS FIELD IS BEING DEPRECATED | varchar(128) |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | createdby employee gender | Gender of the employee who created the waitlist/turnaway entry. | varchar(14) | |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | createdby employee mobile phone | Mobile number of the employee who created the waitlist/turnaway entry. | varchar(64) | |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | createdby employee job name | Job name associated with the employee who created the waitlist/turnaway entry. | Therapist, Manager, Aesthetician etc. | varchar(1020) |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | createdby employee job code | Unique code associated with the job of the employee who created the waitlist/turnaway entry. | varchar(8000) | |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | is createdby employee inactive | A flag that indicates whether the employee who created the waitlist/turnaway entry is inactive. An employee is considered inactive if they have been removed from the system. - True: Employee is inactive. - False: Employee is active. | boolean | |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | createdby employee tags | Tags associated with the employee who created the waitlist/turnaway entry. | varchar(65535) | |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | therapist first name | First name of the employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | Therapist details are populated when a therapist is selected at the time of creating the waitlist/turnaway entry. If a therapist is not specifically selected at this time, these fields are populated with the Not Applicable or are left blank. | varchar(256) |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | therapist middle name | Middle name of the employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | Therapist details are populated when a therapist is selected at the time of creating the waitlist/turnaway entry. If a therapist is not specifically selected at this time, these fields are populated with the Not Applicable or are left blank. | varchar(256) |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | therapist last name | Last name of the employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | Therapist details are populated when a therapist is selected at the time of creating the waitlist/turnaway entry. If a therapist is not specifically selected at this time, these fields are populated with the Not Applicable or are left blank. | varchar(256) |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | therapist employee - code | Unique code of the employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. This code is taken from the employee's profile in Zenoti. | Therapist details are populated when a therapist is selected at the time of creating the waitlist/turnaway entry. If a therapist is not specifically selected at this time, these fields are populated with the Not Applicable or are left blank. | |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | therapist id | Unique identifier for the employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | Therapist details are populated when a therapist is selected at the time of creating the waitlist/turnaway entry. If a therapist is not specifically selected at this time, these fields are populated with the Not Applicable or are left blank. | varchar(256) |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | therapist code | Unique code of the employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. This code is taken from the employee's guest profile. When an employee's profile is created, Zenoti automatically creates their guest profile. Note: The code is usually the same as employee - code, unless someone manually changes it in the employee's guest profile. | DO NOT USE- THIS FIELD IS BEING DEPRECATED | varchar(128) |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | therapist gender | Gender of the employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | Therapist details are populated when a therapist is selected at the time of creating the waitlist/turnaway entry. If a therapist is not specifically selected at this time, these fields are populated with the Not Applicable or are left blank. | varchar(14) |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | therapist job name | Job name associated with the employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | Therapist details are populated when a therapist is selected at the time of creating the waitlist/turnaway entry. If a therapist is not specifically selected at this time, these fields are populated with the Not Applicable or are left blank. | varchar(1020) |
Employee | This group of fields describes the attributes of two types of employees: - Createdby: The employee who created the waitlist/turnaway entry. - Therapist: The employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | therapist job code | Unique code associated with the job of the employee who was requested to provide the service at the time of creating the waitlist/turnaway entry. | Therapist details are populated when a therapist is selected at the time of creating the waitlist/turnaway entry. If a therapist is not specifically selected at this time, these fields are populated with the Not Applicable or are left blank. | varchar(8000) |
Service | These fields detail the attributes of the service for which the waitlist/turnaway entry is created. | service name | Name of the service for which the waitlist/turnaway entry is created. | varchar(512) | |
Service | These fields detail the attributes of the service for which the waitlist/turnaway entry is created. | service length | Ideal time taken to complete the service (in minutes), as set up in Zenoti. | integer | |
Service | These fields detail the attributes of the service for which the waitlist/turnaway entry is created. | service category | Category of the service. This is set up as Sub-category in core. | For a Brazilian Wax service, the category could be Waxing and parent category could be Hair removal. | varchar(256) |
Service | These fields detail the attributes of the service for which the waitlist/turnaway entry is created. | service parent category | Parent category of the service. This is set up as Category in core. | For a Brazilian Wax service, the category could be Waxing and parent category could be Hair removal. | varchar(256) |
Service | These fields detail the attributes of the service for which the waitlist/turnaway entry is created. | service has variant | This flag indicates whether the service has a variant. - True: indicates that the service has a variant. - False indicates that the service does not have a variant. - Not Applicable. | A center has a service called Massage that has two variants - 30 minute massage and 60 minute massage. This flag would be True for the service Massage; while it would be False for these services: 30 minute massage and 60 minute massage. | varchar(14) |
Service | These fields detail the attributes of the service for which the waitlist/turnaway entry is created. | service is variant | This flag indicates whether the service is a variant. - True: indicates that the service is a variant. - False: indicates that the service is not a variant. - Not Applicable | A center has a service called Massage that has two variants - 30 minute massage and 60 minute massage. This flag would be False for the service Massage; while it would be True for these services: 30 minute massage and 60 minute massage. | varchar(14) |
Service | These fields detail the attributes of the service for which the waitlist/turnaway entry is created. | is addon | This flag indicates whether the service is an add-on. - True: indicates that the service is an add-on. - False: indicates that the service is not an add-on. | boolean | |
Service | These fields detail the attributes of the service for which the waitlist/turnaway entry is created. | service businessunit | Business unit to which the service belongs. | varchar(200) | |
Service | These fields detail the attributes of the service for which the waitlist/turnaway entry is created. | service tags | Tags associated with the service. | Tags can be created for a service in Organization view. These will be comma-separated values if there are multiple tags. | varchar(65535) |
Service | These fields detail the attributes of the service for which the waitlist/turnaway entry is created. | service price | List price of the service. | float | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | turnaway wid | Unique identifier for the waitlist/turnaway record. This is generated in Analytics; it does not exist in the core system. | bigint | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | created date in center | Date when the waitlist/turnaway entry is created. | date | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | created date time in center | Date and time at which the waitlist/turnaway entry is created. | timestamp | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | appointment start date in center | Start date of the time slot preferred by the guest at the time of creating the waitlist/turnaway entry. | date | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | appointment start date time in center | Start date and time of the time slot preferred by the guest at the time of creating the waitlist/turnaway entry. | It is possible that the guest mentions Any Time on a particular day for the preferred slot. In this case, the time gets populated as 00:00:00. | timestamp |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | appointment end date in center | End date of the time slot preferred by the guest at the time of creating the waitlist/turnaway entry. | date | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | appointment end date time in center | End date and time of the time slot preferred by the guest at the time of creating the waitlist/turnaway entry. | It is possible that the guest mentions Any Time on a particular day for the preferred slot. In this case, the time gets populated as 00:00:00. | timestamp |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | turnaway status | Current status of the record. Possible values: - WaitList - Converted - TurnAway | varchar(30) | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | appointment id | Appointment ID associated with a request when it gets converted to a confirmed appointment. This is only populated when the turnaway status value of the request is Converted. | varchar(36) | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | turnaway reason | Reason for marking the request as a turnaway. This is only populated when the turnaway status value of the request is Turnaway. | varchar(65535) | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | turnaway reason code | Unique code assigned to each turnaway reason. This is only populated when the turnaway status value of the request is Turnaway. | varchar(1024) | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | comments | Comments entered by the employee when the waitlist/turnaway entry is created. | varchar(16000) | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | turnaway date in center | Date on which the turnaway status value of the record is changed from either Waitlist to Converted or from Waitlist to Turnaway. | date | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | turnaway date time in center | Date and time at which the turnaway status value of the record is changed from either Waitlist to Converted or from Waitlist to Turnaway. | timestamp | |
Turnaway | These fields detail the attributes of the waitlist/turnaway entry. | void | Indicates whether the waitlist/turnaway record is valid. - True: void record - False: valid record | boolean |