The Reservation sources report

The Reservation sources report allows properties to:

Track and review the performance of channel reservations.
View multiple sources per reservation.
Analyze more than just company and travel agency per reservation; unlock other distribution sources such as GDS and CRS.
Consider revenue per source.

Note: If you want Mews to automatically log reservation sources that channel managers send, including distribution sources: GDS, CRS, etc., select the Enable more granular reporting option in your integration settings. You can learn about tracking your reservation sources in Mews here.

Once Mews logs reservation sources sent from channel managers, you can use the report to make informed decisions regarding your future distribution investments.

To view the Reservation sources report:

Go to the main menu > Reservations > Reservation sources report.

Reservation sources report example screenshot

In this article you can learn about:

Setting the filters in the report
Understanding the fields in the report
- Fields in the Detailed mode
- Fields in the Totals mode
Exporting the report

Setting the filters in the report

Service: Choose the service you want to view the report for.
Mode: Select the mode in which you want to view the report. The two modes display different data columns.
- Detailed: View individual bookings including all details for a more in-depth analysis.
- Totals: Summarize information to analyze report data more quickly and generally.
Filter: Select one filter option to narrow your results by reservation type:
- Arrival: All past, current, and future confirmed reservations, sorted by date of arrival.
- Canceled: All canceled bookings fully within the selected interval, sorted by date of arrival.
- Confirmed: All confirmed bookings, regardless of current status and sorted by date of confirmation.
- Covering: Guests in house for the full duration of the selected interval, arriving before Start and departing after End.
- Created: Bookings created within the selected interval, sorted by date and time of creation.
- Departure: All reservations departing within the selected interval, sorted by date of departure.
- Inquired: All reservation inquiries.
- Inquired confirmed: All confirmed reservation inquiries, sorted by date of arrival.
- Optional: All optional bookings, sorted by release date.
- Optional confirmed: All confirmed optional bookings, sorted by date of arrival.
- Overlapping: All reservations arriving, departing, and staying over within the selected interval, sorted by date of arrival.
- Stay over: Not arriving nor departing, but staying for at least two nights within the selected interval.
- Staying: Arriving and staying over, but not departing, within the selected interval.
- Updated: All reservations updated within the selected interval.
Start: Select a start date and time to restrict results to a specific time period.
End: Select an end date and time to restrict results to a specific time period.

Note: You can click on the time to set any time including more than 15-minute intervals.

Status: Select any of the options below to filter results by reservation status:
- Canceled
- Checked in
- Checked out
- Confirmed
- Inquired
- Optional
Options:
- Include additional expenses: Any additional charges not related to stay or products, for example, cancelation fees.
- Include products: Include stay product revenue in report results, displayed in an additional column.
- Include space charges: Include space charge revenue in report results.
Values:
- Gross value: Booking cost including tax.
- Net value: Booking cost alone, excluding tax.
- Tax value: Tax on bookings only.
Group by: Choose the way you want the report to sort and display the results.
- Company: View reservations connected to company profiles within your property.
- Granular reservation source: View results according to the reservation origin, before a channel manager sent it to Mews. The report displays reservations grouped by combined sources.
- Mother company: View all reservations connected to mother company profiles within your property, including revenue from all other child companies.
- Rate: View results according to the rate types defined at your property.
- Rate group: View results according to the rate groups defined at your property.
- Reservation origin details: View results according to the booking method of a reservation before it was passed to Mews from a channel manager like D-Edge.
- Reservation source: View results according to the reservation origin before a channel manager sent it to Mews. The report displays reservations once per source.
- Travel agency: View reservations connected with travel agencies defined at your property.
Rate: Select a particular rate to view results related only to it.
Rate group: Select a particular rate group to view results related only to it.
Type: View only results connected to a particular profile type.
- Company: Any reservation connected to a company profile; filtering by mother companies includes both child companies and all travel agency contracts that may be connected.
- Customer: Any reservation connected only to a customer profile.
- Travel agency: Any reservation connected to a travel agency.
Company: Select one specific company to view results with respect to that profile; if selecting a mother company, note that the child companies appear in results.
Travel agency: Select one particular travel agency to view results with respect to that profile; if selecting a travel agency that is a mother company to other travel agencies, note that the child companies appear in results.

Understanding the fields in the report

Fields in the Detailed mode

In Detailed mode, the report groups reservations by channel source.

The information that the report displays always depends on which option you choose to filter by, i.e., Arrival, Canceled, Confirmed.

When you select the Detailed mode filter, the report displays the following columns:

Number: Unique reservation number that the system automatically generates and assigns to the booking. Mews sends all guest confirmations with this number, which you can use directly in the search field to find a specific booking.
Reservation status: An icon representing the current reservation status. You can hover over this icon to view the written form of status.
Customer: Name of the reservation owner which Mews displays with classification icons.
- Click on the name for a direct link to that customer's profile,
- Hover over the icons to view the written label for each.
- Companions: Number of companions, including the reservation owner, listed in icon x number format.
Created: Date and time of booking creation.
Arrival: Date and time of arrival.
Departure: Date and time of departure.
Space: Assigned space number.
Space category: Space category listed in its shortened format.
- Hover over the short name to view the full title of any space category.
- If the data in this column includes an arrow, such as SR -> 4BD, then the space category of the assigned space is different than the space category requested during the booking process.
Source: An icon representing the source of the reservation data. Hover over the icon to view the source details.
Rate: Selected rate listed in its shortened format. Hover over the short name to view the full title of the assigned rate.
Products: Any additional products added to reservation listed in quantity x short name format.
- Hover over the short name to view the full name of any product;
- In case of stay products, the report may list them in quantity x time unit x short name format.
Company: Name of company for business travelers or company-related bookings. Click on the company name for a direct link to company profile.
Travel agency: Name of travel agency for bookings associated with any OTA. Click on travel agency name for a direct link to company profile.
Rate: Average rate.
Total: Total amount due for booking.
CC: Credit card icon appears for customers having card details in their profile.
- Click this icon to go directly to the customer billing screen.
- Hover over this icon to view last 4 digits, card type and card expiry details.

Fields in the Totals mode

In Totals mode, you can view the revenue and commission per channel source.

The information that the report displays always depends on which option you choose to filter by, i.e., Arrival, Canceled, Confirmed.

When you select the Totals mode filter, the report displays the following columns:

Days/Nights:
- Inquired: Number of days/ nights booked for inquired reservations in a given time period.
- Optional: Number of days/ nights booked for optional reservations in a given time period.
- Confirmed: Number of days/ nights booked for confirmed reservations in a given time period.
- Canceled: In Totals mode, display may show nights in the canceled column even if you don't select the 'Canceled' filter.
  - Note: This happens for reservations that were cut short and therefore have some of their nights canceled. However, since the reservation itself is not canceled, you see no numbers as canceled in the column for reservations. the canceled column thus displays only those nights that are canceled in confirmed reservations.
- All: Total number of days/ nights booked for reservations in a given time period.

Average night rate:
- Inquired: Average rate per paid occupied space for inquired reservations in a given time period.
- Optional: Average rate per paid occupied space for optional reservations in a given time period.
- Confirmed: Average rate per paid occupied space for confirmed reservations in a given time period.
- Canceled: Average rate per paid occupied space for canceled nights for confirmed reservations. You can view this column filled only if there are canceled nights in the Days/Nights column.
- All: Average rate per paid occupied space for all reservations in a given time period.
Reservations:
- Inquired: Number of inquired reservations in a given time period.
- Optional: Number of optional reservations in a given time period.
- Confirmed: Number of confirmed reservations in a given time period.
- Canceled: Number of canceled reservations in a given time period.
- All: Total number of reservations in a given time period.
Total amount:
- Inquired: Total amount of money received for inquired reservations in a given time period.
- Optional: Total amount of money received for optional reservations in a given time period.
- Confirmed: Total amount of money received for confirmed reservations in a given time period.
- All: Total amount of money received for all reservations in a given time period.