This report provides an overview of the hotel's performance. It includes performance metrics like room occupancy, Average Daily Rate (ADR), Revenue per Available Room (RevPAR), and 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.
The report displays data by Stay Date, and contains both historical and future information. A Stay Date that has passed will indicate “History” in the Date group column, the first column of the report. Conversely, a Stay Date in the future will have OTB indicated in the Date group column.
There are three tables found on the report: (1) History/OTB, (2) History/OTB Total by Month, and (3) History/OTB Totals.
(1) The History/OTB table displays the data by day, and groups the rows by Historica (Stay Dates have passed) and OTB (Stay Dates in the future). 
(2) The History/OTB Total by Month table displays the data by month, according to the dates selected.
Examples:
i. If the selected dates are 1 Oct to 16 Oct 2023, there will only be 1 row of data in the table and the data will reflect aggregated metrics under “2023 Oct” containing the data from 1 to 15 Oct 2023.
ii. If the selected dates are 1 Sep to 16 Oct 2023, there will be 2 rows of data in the table. The first row shows “2023 Sep” in the date column, and the data will reflect aggregated metrics for the whole month of September since all the dates in September were selected in the Time filter. The second row shows “2023 Oct” in the date column, but will contain the aggregated metrics from 1 to 15 Oct 2023 only.
iii. If the selected dates are 15 Sep to 16 Oct 2023, there will be 2 rows of data in the table. The first row shows “2023 Sep” in the date column, and the data will reflect aggregated metrics from 15 to 30 Sep 2023. The second row shows “2023 Oct” in the date column and will contain the aggregated metrics from only 1 to 15 Oct 2023.
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.
(3) The History/OTB Totals table displays the aggregated metrics for the entire date range selected for the report.
For example, if the selected dates are 1 Jan 2023 to 2 Jan 2024, there will be one row of total data that reflect aggregated metrics from 1 Jan 2023 until 1 Jan 2024. 
Always remember to click on the master Apply button after changing the selected filters. 
Scenario:
Hotel wants to view aggregated data from the History Forecast report for the period of 1 Jan to 1 Feb 2024, with the data 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 2 Feb* (exclusive), organised on a daily basis.
*To include February 1st, the end date must be set to February 2nd with timestamp 00:00:00, NOT February 1st. - The Time Grain is set to group data by day. The past dates are in the History group and the upcoming dates are in the OTB group.
- There will be 2 rows of data in the table: “2024 Jan” and “2024 Feb”.
- There will be only one row of total data that reflect aggregated metrics from 1 Jan to 1 Feb.
Downloading the Report
The History Forecast Report page can be downloaded as an image by clicking the three horizontal dots at the upper right corner of the page. 
Each of the tables 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: History forecast report, past bookings, future bookings, report, hotel's performance, ADR, average daily rate, room occupancy, daily revenue, revenue, OTB, history, stay dates, aggregated data, metric data, report filters, edit time range, time filter, time grain, time range, range type, timestamp 00:00:00, the history/OTB, the history/OTB total by month, the history/OTB totals