So, you've exported your customer or visit data from Waitwhile but now you want to know exactly what the columns actually mean? You've come to the right place!
The Waitwhile CSV export file can include anywhere between 30-60 columns depending on how you have configured your locations (e.g. if you're using Resources, Services or have added custom guest options).
Here is a quick rundown of each data column you may encounter:
Each visit has a unique identifier
NAME, FIRST_NAME, LAST_NAME, PHONE, EMAIL, NOTES, PARTY_SIZE
Hopefully self-explanatory 😀
Hash key that Waitwhile generates uniquely for each individual person. If the same person visits you multiple time, they will have the same Customer ID across all their visits.
If you're using the "Customer ID" input field when you register your customers, this is where you will find that value. It's typically some identifier that you use in your business.
This is the ID (short and long) of the location/waitlist where the visit took place.
This is the ID of your Waitwhile account.
This indicates if the visit currently is on a waitlist ("WAITING"), is a booking ("BOOKED"), is being served ("SERVED") or if the visit is over ("COMPLETED"). It can just be one of those 4 visit states.
These are additional status attributes for the visit to indicate the status of the visit. Values can be "NOSHOW", "CONFIRMED", "ARRIVED", "DELAYED", "EXPIRED" (if the visit was automatically timed out based on your auto-remove settings), "FLAGGED" (if one of your users manually blacklisted the customer)
For bookings, this is the scheduled date and time of the booking.
For bookings, this is the duration of the appointment. It can be based on the selected Service's duration.
The current position (place in line) in the waitlist of the guest visit.
The original position in the waitlist of the guest when the guest visit was first added.
If the visit was added via the web app ("WEB_APP"), native iOS or Android app ("IOS", "ANDROID") or through the API ("API").
For bookings, if the visit was a time block.
The time when a guest visit was added to the waitlist
The time when a guest visit was served (from the waitlist or booking)
The time when a served visit was marked as "completed".
The time when a guest visit was removed by a user
The time when a guest visit was cancelled (can be a waitlist visit or booking visit)
The time when a guest visit was marked as a no-show (can be a waitlist visit or booking visit)
The time a guest visit was sent the Alert (via SMS or email) by a user on your account. This is helpful if you want to understand e.g. how long time it takes for a guest on average to return and be served after they were alerted.
The time a guest indicated that they have arrived (by e.g. replying "arrived" to a text message) or using the Sign-in screen.
The time a guest indicated that they were Confirmed.
The time a guest visit was flagged by one of your account users.
The time a guest visit was imported via the Customers page or API.
The time a guest visit was automatically removed / expired per your Auto-Remove settings under Waitlist Settings > Auto-remove.
The wait time provided by you to the guest when they joined the waitlist.
The actual wait time for a guest visit. I.e. the time elapsed between the time they were first waitlist (WAITLIST_TIME) and until they were served (SERVE_TIME). This will only show a value for guests that were served.
The actual time that a guest was served. I.e. the time elapsed between the SERVE_TIME and the COMPLETED_TIME.
When the visit was first created. This is normally the same as either the WAITLIST_TIME or DATE field.
When the visit was last modified.
Which user on your account added the visit.
Which user on your account last updated the visit.
RESOURCE_ID, RESOURCE_NAME,, RESOURCE_EXTERNAL_ID
Information about the resource (e.g. "John Doe" or "Table 5") that was assigned to serve the guest visit.
Information about the category of the resource that was assigned (e.g. "Staff" or "Tables").
Information about the service (e.g. "Haircut" or "Shopping Appointment") that the guest selected when they signed up.
Information about the category of the Service that was assigned (e.g. "Salon Services" or "Store Services").
DATA_FIELD_ID, DATA_FIELD_NAME, DATA_FIELD_INPUT_TYPE
If you've added other fields to your guest registration form (under e.g. Waitlist Settings > Customer info) these will appear here including the values from the guest.