This article describes the Occupancy Report grouped by Loyalty Membership Type, which shows occupancy and Tariff Quoted revenue figures rolled up per Loyalty Membership Type for the selected period.
Overview
The Occupancy Report grouped by Loyalty Membership Type shows one row per Loyalty Membership Type (for example, Gold, Silver, Bronze) with the count of reservations, nights, occupancy percentage, and revenue contribution for the selected date range. Use this layout to compare the relative contribution of each loyalty tier and inform tier-design or marketing decisions.
For the full description of the report, the report options panel, the Data Sources & Calculations that govern shared columns, and how the Operational Revenue model differs from Financial Revenue, see the main Occupancy Report article.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.
Important! The Occupancy by Loyalty Membership Type layout calculates revenue from Tariff Quoted on each reservation, NOT from posted Operational Revenue transactions. Sundries, Periodic, and Repeat Charges are not included in the Gross / Nett Revenue figures on this layout. To see Operational Revenue (the full posted figure), use Occupancy By = Category or No Group.
Please Note! The Loyalty Membership Type option only appears when Loyalty Memberships are configured for the property. If you do not see this option in the Occupancy By dropdown, your property may not have Loyalty Memberships enabled or no membership types have been set up.
Use Cases
- Tier contribution analysis - the Loyalty Program owner runs the report for the previous quarter to see how each membership tier is performing relative to the others and to the unmembership baseline.
- Member acquisition ROI - compare the revenue and reservation count contributed by members vs guests with no loyalty membership to quantify the programme's revenue impact.
- Tier-design review - if a tier (for example, Silver) is consistently underrepresented relative to adjacent tiers, that may indicate the tier benefits, signup threshold, or marketing position needs adjustment.
How to Access
In the side menu of RMS, go to Reports > Management > Statistics > Occupancy.
On the Report Options panel set Occupancy By to Loyalty Membership Type. Select Build.
Column Headers
The columns below appear on the report output when Occupancy By is set to Loyalty Membership Type. The Source / Calculation column references the concepts under Data Sources & Calculations in the main Occupancy Report article rather than repeating them here.
| Column | Description | Source / Calculation |
|---|---|---|
| Loyalty Membership Type | Membership tier name. | Setup > Loyalty Programme > Membership Types. |
| Reservations | Count of reservations linked to this Membership Type during the selected period. | Reservation count where Loyalty Membership Type matches the row. |
| Nights | Unit-nights consumed by reservations on this Membership Type. | See Used capacity. |
| Occupancy % | Occupancy percentage for this Membership Type. | (Nights ÷ Available Nights) × 100. |
| Gross Revenue | Tariff Quoted revenue including taxes for reservations on this Membership Type. | Sum of Tariff Quoted on each reservation, grouped by Membership Type. |
| Nett Revenue | Tariff Quoted revenue excluding taxes. | Gross Revenue − Taxes. |
| Tariff % | This Membership Type's share of the report's total Gross Revenue. | (Row Gross Revenue ÷ Report Total Gross Revenue) × 100. |
Please Note! The Occupancy Report's footer notice on this variant reads: "Revenue figures represent Tariff Quoted for all reservations. Sundries, Periodic and Repeat Charges are not included. Rooms marked as maintenance are not counted as available on this report unless you have chosen the option 'Include Maintenance in Avail for Occupancy' under Property Information. Day use reservations are not counted as used unless you have chosen the option 'Include Day Use in Used for Occupancy' under Property Information."
Related Reports
- Occupancy Report - the main report article covering report options, Data Sources & Calculations, and all Occupancy By variants.
- Occupancy & Revenue Comparison Report - compares occupancy and revenue across two date ranges.
Related Articles
- Operational Revenue - full reference for the revenue model the main Occupancy Report uses (note: this variant uses Tariff Quoted instead).
- Occupancy Calculation Rule - Property Occupancy vs Category Occupancy property setting.
Comments
0 comments
Please sign in to leave a comment.