Revenue by Market Segment with Groups Report

The Revenue by Market Segment with Groups Report allows users to track the revenue generated from group reservations. This report also calculates and displays the revenue forecasted for rooms that have not been picked up for groups.

Perform the following steps to generate the report:

Navigate to Reports ➜ Dynamic Reports ➜ Revenue/Forecasting ➜ Revenue by Market Segment with Groups Report

Refer to the following table and fill in the fields.

Field	Description
Report Name	Revenue by Market Segment with Groups.
Property	Displays the current property by default. Users can select the required properties for which the report must be generated.
Start Date	Users can select the start date from which the report must be generated.
End Date	Users can select the end date up to which the report must be generated.
Include Unpicked Group Blocks	Disabled: The Rooms Sold column does not include the count of group blocks that are not picked up and Room Revenue does not include the revenue forecasted for the group block. Enabled: The Rooms Sold column includes the count of group blocks that are not picked up and Room Revenue includes the revenue forecasted for the group block. For example, if the group block = 10 and room rate = $100, then $1000 is the forecasted revenue for the group block.
Include Zero Balance Days	It is unchecked by default. When selected, the generated report includes the dates for which the columns have the value, 0.
Include Room Type	It is selected by default. When disabled, the generated report displays data under each Group By option selected without further bifurcating the data into various room types/categories.
Group By Date	This checkbox is unselected by default. When selected, the records are grouped and displayed in the ascending order of dates. A new row, Day Total, is added at the end of every date segment/group that displays the total of every column for the respective date segment/group. When the Group By Date checkbox is selected, the records are first grouped by dates followed by the option selected in the Group By field, that is, secondary grouping within every date for either the guest type or market segment is performed as selected by the user. When this checkbox is not selected, the records are grouped based on the option selected in the Group By field.
Group By	Users can select from the following options: Guest Type Market Segment
Segment Filter	Users can select from the market segments configured at the property.

Click Run to generate the report.

Click Save to save the report under User Favorites section.

Sample Report

Report Fields

This report displays the following fields:

Field	Description
Date	Displays each date in the selected date range.
Category	Displays the Guest Types & Segments configured at the property with an accordion. When expanded, all the reservations with the associated guest type are displayed.
Market Segment	Displays the market segment value associated with the reservation.
Guest Type	Displays the guest type value associated with the reservation.
Room Type	Displays the room type with which the reservation was booked.
Group Not Picked Up	Displays the count of the group rooms that are not picked up.
Rooms Sold	Displays the count of the group rooms that are assigned to the reservations.
Comp Rooms	Displays the count of the complimentary rooms.
Rooms Committed	Displays the count of bedded rooms that are assigned to reservations.
Non-Bedded Rooms Committed	Displays the count of non-bedded rooms that are assigned to reservations.
Group Unpicked Up Room Revenue	Displays the revenue generated from rooms that have not been picked up for a group.
Room Revenue	Displays the room revenue for the group blocks including rooms that are not picked up.
ADR	Displays the Average Daily Rate calculated as follows: Total Room Revenue/Total Rooms Sold.
Total Guests	Displays the total number of guests associated with the reservation.
Group Picked Up Room Revenue	The revenue generated from the rooms that are picked up for a group. This column can be sorted.
Picked Up ADR	The Average Daily Rate (ADR) calculated as follows: Total Picked Up Room Revenue/Total Picked Up Rooms. This column can be sorted.
Unpicked Up ADR	The Average Daily Rate (ADR) calculated as follows: Total Unpicked Up Room Revenue/Total Unpicked Up Rooms. This column can be sorted.