ZenotiHelp

Waitlist V2 reporting overview

ZTZenoti Docs Team Updated September 12, 2026 4 min readGuide

The waitlist V2 report gives front desk managers and operations staff a structured view of waitlist activity across one or more centers. It shows each waitlist group alongside the guest, service, appointment status, booking type, and financial details β€” making it possible to review how open slots were filled, track no-shows and turnaways, and measure the effectiveness of your waitlist process.

Before you begin

  • Your organization must have waitlist management enabled (waitlist version set to First in line).
  • You need access to the reports area of the appointment book module.
  • The report covers data within the date range and centers you specify. Ensure you have access to the centers whose data you want to review.

How it works

The waitlist V2 report retrieves waitlist group records for the centers, organization, and date range you provide. It returns two layers of information: a summary row for each waitlist group, and supporting detail rows for the add-ons and providers associated with each group.

Report scope and filtering

When you run the report, the system accepts the following inputs:

  • One or more center IDs β€” limits results to the selected centers.
  • Organization ID β€” scopes the query to your organization.
  • Date range β€” start and end dates for the waitlist activity you want to review.
  • Pagination controls β€” you can specify the number of records per page, the page number, and a maximum row count cap.

If you request only a record count (without detail rows), the report returns the total number of matching waitlist groups without returning the individual rows. This is useful when you want to check how many records exist before deciding whether to export or paginate through the full result set.

Status result set

Before returning detail rows, the report returns a status result that tells you:

  • The total record count β€” the number of waitlist group records matching your filters.
  • An output status β€” either success (when the result set is within the row count cap) or an over-limit indicator (when the number of matching records exceeds the configured maximum). When the over-limit status is returned, you should narrow your date range or filter to fewer centers before re-running the report.

Waitlist group detail

For each waitlist group within the requested page, the report returns the following information:

Column Description
Waitlist group ID The unique identifier for the waitlist group record.
Center name The center where the waitlist entry was created.
Service recurrence ID Links the waitlist entry to a recurring service slot, when applicable.
Recurrence start date and time The scheduled start of the recurring slot associated with this waitlist entry.
Recurrence end date and time The scheduled end of the recurring slot.
Guest name The name of the guest on the waitlist.
Service name The service the guest was waitlisted for.
Created date The date and time the waitlist entry was created.
Request source The channel through which the waitlist request originated (for example, front desk, Webstore, or CMA).
Appointment status The current status of the appointment associated with this waitlist entry. Valid values are NoShow, Confirmed, Turnaway, and Waitlist.
Appointment value The monetary value of the appointment.
Applicable no-show fee The no-show fee amount applicable to this appointment, if any.
Appointment booking type Indicates how the appointment was booked from the waitlist. Automatic means the system booked the appointment automatically when a slot opened (first-in-line FIFO). Manual means a front desk staff member manually booked the appointment from the waitlist. This field is blank when the booking type cannot be determined.

Add-on and provider detail

In addition to the waitlist group summary, the report returns supplementary result sets for each waitlist group:

  • Add-on detail β€” lists any add-on services associated with the waitlist group.
  • Provider detail β€” lists the providers assigned to services within the waitlist group.

This multi-result-set structure is consistent with how other waitlist queries work in Zenoti, allowing you to reconstruct the full picture of a waitlist group from a single report run.

Key features

  • Appointment booking type distinction β€” The report distinguishes between appointments booked automatically by the first-in-line engine and those booked manually by staff. This lets you measure how much of your waitlist conversion is handled by automation versus manual intervention.
  • Appointment status coverage β€” The four status values (NoShow, Confirmed, Turnaway, Waitlist) give you a complete view of how each waitlist entry resolved. You can identify guests who were notified but did not show up, guests who confirmed, guests who were turned away, and guests still on the waitlist.
  • Financial visibility β€” Appointment value and applicable no-show fee columns let you assess the revenue impact of waitlist activity and identify where no-show fees apply.
  • Pagination and count-only mode β€” For large date ranges or high-volume centers, you can retrieve only the record count first, then page through results in manageable batches. This prevents performance issues when reviewing large data sets.
  • Multi-center support β€” You can run the report across multiple centers in a single query, making it suitable for zone-level or organization-level reviews.
  • Add-on and provider context β€” The supplementary result sets for add-ons and providers give you the full service composition of each waitlist group, not only the primary service.
Was this article helpful?
Your feedback helps us improve our documentation.