The Weekly Booked Trend report provides a weekly summary of booking activities. It highlights key metrics such as occupancy (%), total occupied rooms, paid room nights (RN), gross room revenue (GRR), paid average daily rate (ADR), cancellation rate (%), etc. This report provides hotels clear insights into last week's booking performance (including booking pick-up and pace). This data can be used to assess trends that support quick strategic decisions to optimise revenue. By default, the report displays data from the completed week prior to the current date (e.g., if today is July 9 (Wed), then the last week's data would cover June 30 (Mon) - July 6 (Sun)).
Each tab's data can be filtered by channel. To view specific channel data, select one or more channels from 'Channel' selection at the top-left of the page, then click 'Apply' to update the data.
This report consists of five tabs:
- Last Week's Pick Up – This tab displays booking pick-up data from last week as of last Sunday.
- Pace – This tab compares today's performance this year (TY) with the same period last year (STLY), along with last year's actual data (LYA), to show whether the hotel is performing better than during the same period last year.
- Last 8 Week Trends – This tab presents booking trends data from eight weeks prior to last week as of last Sunday.
- Last 6 Months Trends – This tab presents booking trends data from past six months plus the current month.
- Definitions used in this report – This tab contains the explanations and meanings of key terms and metrics used throughout the report.
Last Week's Pick Up
This tab displays an overview of weekly performance from the last completed week, covering Monday through Sunday.
For example: if users access the report on July 9 (Wed), the displayed data will cover June 30 (Mon) - July 6 (Sun).
The upper section of the page shows three key metrics that summarise last week's performance:
- Room Nights Picked Up LW
- ADR Picked Up LW
- Room Revenue Picked Up LW
Users can access more detailed data through the following sections:
- Last Week’s Pickup by Stay Month
- Last Week’s Pickup by Guest Country
- LW Picked Up by Channel (Table)
- Gross and Net Daily Room Night Pickup by Channel (Table)
Pace
This tab compares on-the-books (OTB) Pace from this year (TY) with the same period last year (STLY) and last year's actual data (LYA) to determine whether performance is ahead, behind, or the same.
Note: For hotels that just joined ZUZU, there would only be TY data.
The data covers the last 3 months (L3M), including the current month, plus the next 9 months (N9M).
To view more detailed OTB Pace data, users can apply the ‘Time Grain (OTB Pace)’ filter next to the ‘Channel’ selection.
This tab includes three line charts and three data tables:
- Paid RN OTB Pace vs Same Time Last Year and Last Year Actuals (L3M + Next 9M)
- GRR OTB Pace vs Same Time Last Year and Last Year Actuals (L3M + Next 9M)
- Paid ADR OTB Pace vs Same Time Last Year and Last Year Actuals (L3M + Next 9M)
- TY OTB (L3M + Next 9M)
- STLY OTB (L3M + Next 9M)
- LY Actuals (L3M + Next 9M)
Users can customise the line chart view based on specific reporting preference. For example, if users want to focus only on Last Year Actuals data, they can use the Inv filter and select 'Last Year Actuals (LY)'. To restore the full view, use the All filter.
Last 8 Week Trends
This tab displays data from the eight weeks prior to the week currently viewed. Users can find the following data in this tab:
- Gross and Net Weekly RN Pickup (Chart)
- Gross and Net Weekly RN Pickup by Channel (Table)
- These compare the weekly totals of gross and net room night pickups for each of the eight weeks prior to last week. For example: if users access the data on July 9 (Wed), last week refers to June 30 (Mon), and the eight weeks before last week begin on May 12 (Mon).
- L8W Cancellation Rate
- This section shows last week's cancellation rate (in %), along with a trendline displaying cancellation rates over the past eight weeks.
- Cancelled Reservations % by Channel (Table)
- This section compares average cancellation rates from each channel for the past 1 week, 4 weeks, and 8 weeks.
This tab also includes pickup and booking trends for the last eight weeks, such as:
- Book Trends - L8W RN pickup by Channel
- L8W GRR Picked Up by Channel
- Book Trends - L8W RN pickup by Stay Month
- L8W GRR Picked Up by Stay Month
Last 6 Months Trends
This tab displays data covering the last six months (L6M), including the current month (TM/This Month).
For example: if users access the report on July 9, the data covers January 2025 until June 2025, plus this month (July 2025).
- Channel Production RN Booked L6M + TM (chart)
- Channel Production GRR and ADR Booked L6M + TM (chart)
- Channel Production RN Booked L6M + TM (Table)
- Channel Production GRR Booked L6M + TM (Table)
- Book Trends - L6M + TM RN Picked Up by Stay Month
- Book Trends - L6M + TM GRR Picked Up by Stay Month
Downloading the report
The entire page in each tab of the Weekly Booked Trend report can be downloaded as an image or exported as a PDF file by clicking the three horizontal dots in the top right corner and selecting the preferred format.
Each view can also be downloaded individually by clicking the three dots in the top-right corner of that view. A dropdown menu will appear with options to download the file as a CSV, pivoted CSV, Excel file, or image.
Can't find your answer? Contact the ZUZU Helpline
Tags: Weekly Booked Trend, hotel's weekly data, hotel’s weekly performance, entire week data, graphs, line chart, tables, revenue optimisation based on weekly data, optimization, last week data pickup, booking trend, booking metrics, booking pace, booking demand, booking season, booking channels, weekly booking performance, raw occupancy, paid RN, paid ADR, GRR, cancellation trendline, time grain, channel selection, INV filter