[Eng] Report & Analysis

Screen Name

Report & Analysis

Open Link

Summary

This interface allows users to generate revenue reports and analyze data based on various criteria such as stay dates, departure dates, booking sources, room types, and more.

Screen

Fields Description

1. Filters:

a. Date Range – the time period for querying data (default: the last 7 days)

Start Date: Enter or select the start date (e.g., 15-04-2025)
End Date: Enter or select the end date (e.g., 21-04-2025)
👉 This is a required step to generate reports for your desired time frame.

b. Other Optional Filters:

Booking Source: Filter by booking channel (e.g., OTA, TA, Direct)
Property: Filter by hotel or branch
Room Type: Filter by room category
Rate Plan: Filter by pricing/package plan
Length of Stay (LOS): Filter by number of nights stayed
Market: Filter by market segment
Nationality: Filter by guest nationality
Status: Filter by booking status

📌 Users can check the boxes to enable any filters based on their analysis needs.

2. Setup for Grouping and Display Metrics:

a. Group By:

You can group data by various dimensions such as:

Occupancy Date
Day of Week
Rate Plan
Room Type
Package
Distribution Channel
Market, etc.

b. Compare with Same Time Last Year:

Tick this option to compare data with the same period from the previous year.

c. Displayed Values:

Choose what metrics to display, such as:

Revenue on Book
Booking Count
Room Nights, and more.

d. Report By:

Choose the basis of your report, such as Booking Date, Arrival Date, Departure Date, etc.

3. Click [Generate] to Create the Report

After selecting all the necessary criteria, click the Generate button to create the report.

You can view the report in three formats:

a. Chart View:

Choose between bar chart or line chart using the icons on the interface.
Hover over the bars or lines to see specific data values.
Select which date type to view (e.g., Departure Date, Arrival Date, Booking Date, etc.)

b. Table View:

Switch to the “Table” tab to see data in a detailed table format.
Click “Add new values to the table” to select additional metrics for display.
Then click “Export” to download the file.

c. Booking List:

View a list of all bookings that match your selected filters.
Customize which columns are displayed by ticking/unticking boxes in the menu on the right (as shown in the image).
Click the “Export” button to download the file.