Report Builder β Guest and Campaign Level Reports
Guest Level and Campaign Level reports in the Report Builder display results as a ranked table β one row per guest or campaign β rather than the time-series format used by Organization, Employee, and Category Level reports. This overview explains how the table works, what KPIs are available for each level, and how ranking, filtering, and export differ from other report types.
Note: For step-by-step instructions on building and saving a custom report, see Report Builder β Build a Custom Report.
On this page
- How it works
- Table structure
- Filters and ranking
- Guest profile link
- Export
- Example Guest Level KPIs
- Example Campaign Level KPIs
- Related articles
Before you begin
- Your organization must have Report Builder enabled.
- Your security role must include the Read permission under Reports KPI Builder to view custom reports.
- Guest Level and Campaign Level reports are created in the Report Builder. To create one, see Report Builder β Build a Custom Report.
How it works
When you open a saved Guest Level or Campaign Level report, the modern reporting platform displays a ranked table instead of the KPI summary cards and time-based comparison columns shown in other report types.
Each row represents one guest or one campaign. Each column represents one KPI you selected when building the report. The table is pre-sorted by the Sort by KPI you chose when saving the report, and a Total row at the bottom summarizes each KPI column across all rows in the result set.
Two behavioral differences from other report levels are important to understand:
- No comparison columns. Guest Level and Campaign Level reports do not display a previous-period column or a current-period-last-year column. Each KPI shows a single value for the selected time period.
- No Breakdown. The Breakdown control available in Organization, Employee, and Category Level reports is not available here.
Table structure
The table has a fixed set of identifier columns followed by one column per KPI.
Guest Level reports show:
| Column | Description |
|---|---|
| Guest Code | The unique code assigned to the guest in Zenoti. |
| Guest Name | The guest's full name, displayed as a link. Selecting the name opens the guest's profile in a new browser tab. |
| One column per KPI | Each KPI you added when building the report appears as a separate column. |
Campaign Level reports show:
| Column | Description |
|---|---|
| Campaign Name | The name of the campaign. |
| One column per KPI | Each KPI you added when building the report appears as a separate column. |
Total row
A Total row appears at the bottom of the table and aggregates each KPI column across all rows that match the current filters and ranking.
For Guest Level reports, the Total row uses specific labels inside two Yes/No KPI columns when those KPIs are present:
- Under the Is New Guest column, the Total row label reads Total new guests.
- Under the Has Visit column, the Total row label reads Total guests with visit.
These are labels within the Total row, not additional rows below it.
Pagination
The table pages through results and displays the position in the format <start> to <end> of <total> and Page <current> of <total>. Pagination controls appear at the bottom of the table.
Note: Export CSV exports every row that matches the active filters and ranking β not only the rows visible on the current page. See Export below.
Filters and ranking
Guest Level and Campaign Level reports offer the following controls above the table.
Time period
The same time period presets available in other report types are available here, with one exception: Fiscal Week is not offered for Guest Level or Campaign Level reports. Available presets are This Year, This Quarter, This Month, This Week, Yesterday, Last 7 Days, Last 30 Days, and Custom (up to 12 months, with yesterday as the latest date).
Center filter
The center filter works the same way as in other report types. Select one or more centers to scope the data.
Guest or campaign filter
- Guest Level reports β the filter defaults to All Guests and shows the count of guests selected when you narrow it. Use the Search guest name,code,phone,email field to find specific guests.
- Campaign Level reports β the filter defaults to all campaigns and shows the count selected. Use the Search campaigns... field to find specific campaigns.
Show β ranking
The Show control ranks the table to display either the top or bottom performers by a chosen KPI.
| Control | Behavior |
|---|---|
| Top <n> | Shows the highest-ranked rows by the selected KPI. |
| Bottom <n> | Shows the lowest-ranked rows by the selected KPI. |
| ranked by | Determines which KPI the ranking is based on. Select a KPI using the Select KPI dropdown. |
The value of <n> is set at the organization level. You choose whether to show the top or bottom results β you do not choose the number of rows.
When you open a report, the table is already ranked by the Sort by KPI you specified when saving the report. Changing the ranked by KPI updates the ranking without changing which KPIs appear as columns.
Guest profile link
In Guest Level reports, selecting a guest's name in the Guest Name column opens that guest's profile in a new browser tab. This allows you to act on report findings β for example, reviewing a high-value guest's history or following up on a guest identified as lapsed β without leaving the report.
Export
Selecting Export CSV downloads the table as a CSV file. The export includes every row that matches the active filters and ranking, not only the rows visible on the current page.
Important: Export CSV is unavailable when no guests or campaigns are selected. Ensure at least one guest or campaign is included in the filter before attempting to export.
Guest Level and Campaign Level reports export to CSV only. They do not offer an Excel export.
Example Guest Level KPIs
The following KPIs are examples of what is available when building a Guest Level report. The on-screen names and definitions below are the exact labels and descriptions used in the product.
| KPI name | Definition |
|---|---|
| Lifetime Service Visit Count | The number of days the guest made a service or day-package purchase, from their first purchase through the date. |
| Lifetime Service Visit Value (Inc. Tax) | Lifetime spend on service and day-package purchases, including tax. |
| Lifetime All-Purchase Value (Inc. Tax) | Lifetime spend across services, products, memberships, gift cards and packages, including tax. |
| Is New Guest | Whether the guest is a first-time visitor with no prior purchases. |
| Has Visit | Whether the guest completed a paid service or day-package purchase (a closed invoice). |
| Visit Frequency | The average number of days between the guest's visits. |
These are examples from the KPI Library. The full set of available KPIs depends on your organization's configuration.
Example Campaign Level KPIs
The following KPIs are examples of what is available when building a Campaign Level report.
| KPI name | Definition |
|---|---|
| Email Notifications Sent | The number of email messages sent to guests by the campaign, counted whether or not they were opened, delivered or answered. |
| SMS Notifications Sent | The number of SMS messages sent to guests by the campaign, counted whether or not they were opened, delivered or answered. |
| Push Notifications Sent | The number of push notifications sent to guests by the campaign, counted whether or not they were opened, delivered or answered. |
| WhatsApp Notifications Sent | The number of WhatsApp messages sent to guests by the campaign, counted whether or not they were opened, delivered or answered. |
| Guests Recovered | Lapsed guests who were re-activated and made a purchase after receiving the campaign's notification. |
| Attributed Invoices | Invoices from guests who received the notification and then completed a purchase. |
| Attributed Sales | Revenue before tax on attributed invoices, after discounts, across all payment methods. |
These are examples from the KPI Library. The full set of available KPIs depends on your organization's configuration.