This report provides an overview of the hotel's performance by various channels. It includes performance metrics like the number of room nights, Average Daily Rate (ADR), Gross Room Revenue for a specific date range. By default, it displays this data on a daily basis, but it can also be adjusted to aggregate the performance metrics by week, month, quarter, year, or a custom period.
Users can choose to view the data based on its Booked Date or Stay Date, by clicking on the respective tabs at the top of the Room nights chart.
1. Booked Date: Data sorted by Booked Date will show the bookings which were created on those dates.
2. Stay Date: Data sorted by Stay Date will show the bookings which stayed at the property on those dates/nights.
This report is divided into two main sections. Charts are displayed at the top half of the page, while the bottom half contains data tables.
Charts:
(1) Room nights by Booked/Stay date chart
(2) Room nights distribution in percentages by Booked/Stay date chart
(3) Gross revenue distribution in percentages by Booked/Stay date chart
Data Tables:
(4) Channel Production by Booked/Stay date
(5) Channel Production Monthly by Booked/Stay date
(6) Channel Production Totals by Booked/Stay date
(1) The Room Nights by Booked/Stay date chart shows the total room nights in stacked bar charts, grouped by the booking channel name(s) and the dates (Booked or Stay Date).
(2) The Room Nights distribution in percentages by Booked/Stay date chart shows the total room nights in percentages in stacked bar charts, grouped by the booking channel name(s) and the dates (Booked or Stay Date).
For example, according to the percentage of bookings booked on 1 Jan 2024, Agoda has the highest share of the room nights (43%).
(3) The Gross revenue distribution in percentages by Booked/Stay date chart shows the percentage of revenue of bookings which were booked through each channel, on each date period.
For example, the highest gross revenue by percentage share (48%) was generated from Booking.com on 1 Jan 2024.
(4) The Channel Production (by Booked/Stay Date) table displays the data by day, and groups the rows by Booked Date or Stay Date, along with the corresponding channel names from which the bookings were made, for the selected date range.
(5) The Channel Production Monthly (by Booked/Stay Date) table displays the data by month, according to the dates selected.
For example, if the selected dates are 1 Jan to 9 Jan 2024 and bookings were received from the channels Booking.com, Traveloka, and Ctrip, there will be 3 rows of data in the table and the data will reflect aggregated metrics under "Jan 2024", containing the data from 1 Jan to 8 Jan 2024.
To retrieve the data from a specific date and time range, customise the time period from the report filters, located at the top of the page.
(6) The Channel Production Totals (by Booked/Stay Date) table displays the aggregated metrics for the entire date range selected, grouped by the channel names.
For example, if the selected dates are 1 Jan to 9 Jan 2024 and bookings were received from just two channels, Booking.com and Traveloka, there will be two rows of total data. The first row shows the total aggregated metrics from 1 Jan to 8 Jan 2024 for Booking.com. The second row shows the total aggregated metrics from 1 Jan to 8 Jan 2024 for Traveloka.
Channel Filter
Within the Channel Production report, users can use an additional filter to view the data for specific channels. The channel names that can be selected depend on each hotel. To include all channels, click 'Select all'.
Booking type
Users can also choose to include or exclude some booking types. There are 3 options: Prepay, Postpay, and Others (which includes all channel names without the Prepay or Postpay suffix). For example: Hotel Walk-in, BEIScheduled, GoogleScheduled.
Always remember to click on the master Apply button after changing the selected filters.
Scenario 1:
Hotel wants to view in the chart, the total number of room nights booked per date, for the period of 1 Jan to 8 Jan 2024, for all booking types and all channels through which bookings were made.
Explanation:
- The Time Filter is set to 'Custom' as the range type, configured with a Specific Date/Time starting on 1 Jan (inclusive) and ending on 9 Jan* (exclusive), organised on a daily basis. All channels and booking types are selected.
*To include 8 Jan, the end date must be set to January 9th with timestamp 00:00:00, NOT January 8th. - The chart displays the data based on the ‘Booked Date’. Click on ‘Stay Date’ if the user wishes to view the chart based on the Stay Date, with the same settings.
- The total number of bookings made from various channels are grouped by Day.
- Users can also select which channels to be included or excluded in the chart by clicking on the Inv button. Read this article about Chart Filters to learn more about this functionality.
Scenario 2:
a. Hotel wants to view the Channel Production by Stay Date table for the period of 1 Jan to 8 Jan 2024, for only 4 channels (Agoda, Booking.com, Tiket.com, Traveloka), which have been prepaid and the data displayed are grouped by day.
Explanation:
- The Time Filter is set to 'Custom' as the range type, configured with a Specific Date/Time starting on 1 Jan (inclusive) and ending on 9 Jan* (exclusive), organised on a daily basis. The channels that should appear are only Agoda, Booking.com, Tiket.com, and Traveloka, exclusively for bookings with Prepay as the booking type.
*To include 8 Jan, the end date must be set to January 9th with timestamp 00:00:00, NOT January 8th. - The table displays data for each channel, grouped by each 'Stay Date'.
b. Hotel wants to view aggregated data from the Channel Production Monthly and Channel Production Totals, both sorted by Booked Date, for the period of 1 Jan to 1 Mar 2024, for only 4 channels (Agoda, Booking.com, Tiket.com, Traveloka), including all booking types.
Explanation:
- The Time Filter is set to 'Custom' as the range type, configured with a Specific Date/Time starting on 1 Jan (inclusive) and ending on 2 Mar* (exclusive). The channels that should appear are only Agoda, Booking.com, Tiket.com, and Traveloka.
*To include 1 Mar, the end date must be set to March 2nd with timestamp 00:00:00, NOT March 1st. - Channel Production Monthly by Booked Date: There will be 3 rows of total data; "Jan 2024", "Feb 2024", and "Mar 2024".
- Channel Production Totals by Booked Date: There will be 4 rows of total data, reflecting the channel names that are included in this report: Agoda, Booking.com, Tiket.com, and Traveloka.
Downloading the Report
The entire page of the Channel Production Report can be downloaded as an image by clicking the three horizontal dots at the upper right corner of the page.
Each of the views can be downloaded individually as well, by clicking on the three dots at the top-right corner of each view. A dropdown list will appear with three options: as a .CSV file, an Excel file, and an image.
Can't find your answer? Contact the ZUZU Helpline
Tags: Channel production report, channel production, hotel performance, performance metrics, room nights, average daily rate, ADR, gross room revenue, room nights chart, booked date, bookings, stay date, distribution in percentages, data, specific date, time range, time period, report filters, channel filter, booking type, scenario, explanation, specific date/time, timestamp 00:00:00