Top Guest Report
Report Description: The Top Guest Report is designed to identify and rank the most valuable individual patrons. By surfacing guests who contribute the highest personal revenue and night counts, this report enables management to transition from transactional interactions to personalised relationship building. It also serves as a critical tool highlighting previously loyal high-spenders who have stopped returning, allowing for proactive outreach.
Date Range: Current day and up to 365 days in the past
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Guest Name |
Identifies the unique individual by their First name last name |
Not Applicable |
Not Applicable |
|
Company |
Company name based on reservations and should be from latest reservation |
Not Applicable |
Not Applicable |
|
Loyalty Tier |
Displays the guest's status (e.g., Diamond, Platinum). Sort to prioritise service for your highest-tier members. |
Not Applicable |
Not Applicable |
|
Guest Tier |
Guests details |
Not Applicable |
Not Applicable |
|
Number of Stays |
Count of reservation for that respective guest |
Not Applicable |
Not Applicable |
|
Number of Nights |
Checkout date - Checkin date |
Not Applicable |
Not Applicable |
|
Number of Cancelled Reservations |
Count of reservations cancelled for that respective guest |
Not Applicable |
Not Applicable |
|
Number of No Shows |
Count of reservations No show for that respective guest |
Not Applicable |
Not Applicable |
|
Number of Guests |
Number if adults + no of children from all reservations |
Not Applicable |
Not Applicable |
|
Room Revenue |
Identifies the total room rate revenue made by the guest |
Not Applicable |
Not Applicable |
|
F&B Revenue |
Identifies the total spends on F&B made by the guest |
Not Applicable |
Not Applicable |
|
Other Revenue |
other than Room rent and F&B should be considered other revenue |
Not Applicable |
Not Applicable |
|
Total Revenue |
Total of RR, F&B and Other revenue |
Not Applicable |
Not Applicable |
Misc Report Information:
Available Features:
-
Export: ability to download and save the file into an alternate format.
-
Filter: filter a range of data based on criteria defined by the user.
-
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
Available Configuration:
-
User Preferences: allows the user to customise their report view by repositioning or removing columns.
-
Property Preferences: allows the property to customise the report view for all users by repositioning or removing columns.