Revised Date:
Report Description: Provides a view of group performance and pickup trends compared to contracted room allocations on a per-stay-date basis. This report eliminates the need for manual reservation counting by providing automated metrics like Rooms Remaining and Pickup Percentage. It serves as a critical tool for sales and revenue teams to monitor inventory, manage cutoff dates, and analyze historical actualized pickup for post-stay reconciliation and performance audits.
Date Range: This report can render data for up to 365 days in the past.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
The specific stay date for which the group data is being viewed |
Not Applicable |
Not Applicable |
|
Group Number |
The unique identifier assigned to the group block |
Not Applicable |
Not Applicable |
|
Group Name |
The name or title of the group block |
Not Applicable |
Not Applicable |
|
Group Status |
Displays the current status of the group (e.g., Checked In, Hold, Cancelled) |
Not Applicable |
Not Applicable |
|
Allocated Rooms |
Total number of rooms contracted/blocked for the group on this date |
Not Applicable |
Not Applicable |
|
Reserved Allocations |
Number of rooms from the block that have been picked up/booked |
Not Applicable |
Not Applicable |
|
Rooms Remaining |
The number of unbooked rooms left in the allocation for this date |
Not Applicable |
= (Allocated Rooms) - (Reserved Allocations) |
|
Pickup Percent |
The percentage of the allocated block that has been booked |
Not Applicable |
= (Reserved Allocations / Allocated Rooms) * 100 |
|
Rolling Indicator |
Displays "Yes" if the cutoff type is set to Rolling; otherwise "No" |
Not Applicable |
Not Applicable |
|
Total Reserved Rooms |
Cumulative total of reservations associated with the group |
Not Applicable |
Not Applicable |
|
Release Type |
Determine how and when unpicked-up rooms are sent back to general inventory (e.g., No Cutoff, Cutoff By Date). |
Not Applicable |
Not Applicable |
|
Release Cutoff Date |
The hard deadline date by which group rooms must be booked before they are released. |
Not Applicable |
Not Applicable |
|
Release Days Prior to Arrival |
The designated number of days before the stay date that unbooked rooms automatically release back to the hotel. |
Not Applicable |
Not Applicable |
Misc Report Information:
Available Features:
-
Export: Ability to download and save pickup data for sales meetings or client performance reviews.
-
Filter: Ability to filter by Group Status, Date Range, or specific Group Numbers.
-
Calculation Logic: * Rooms Remaining: Automatically updates as reservations are made or cancelled.
-
Pickup Percent: If Allocated Rooms is 0, this field will appear as blank or 0 to avoid calculation errors.
-
-
Grouping: Ability to view data grouped by: Group Name, Group Number, or Status.
Available Configuration:
-
User Preferences: Allows users to customize their view by repositioning metric columns.
-
Property Preferences: Allows the property to standardize the view for all Sales and Revenue users.
Baseline Configuration:
Property Preferences Settings:
-
Following columns to be disabled for initial deployment: None.