How to use the Reservation sources report in Mews Operations

The Reservation sources report in Mews Operations allows properties to track and review the performance of channel reservations, view multiple sources per reservation and consider revenue per source. You can also use the report to analyze more than just company and travel agency per reservation by unlocking other distribution sources such as a Global Distribution System, or GDS, and a Central Reservation System, or CRS. A GDS is a network that travel agents use to book rooms; a CRS is a central system that distributes your rates and availability to booking channels. Once Mews Operations logs reservation sources sent from channel managers, you can use the report to make informed decisions regarding your future distribution investments. The report is for revenue, distribution and front office users at any property that receives reservations through channel managers, booking engines or travel agencies. You open the report from the Reservations section of the main menu in Mews Operations. The report shows a source only once Mews Operations has logged that source, so reservations created before source tracking was set up do not show granular sources.

 

ⓘ
Note
  • Ensure the Reservation sources report is only exportable by admins as the export can contain personally identifiable information, or PII, about the guests such as phone number, email, address and nationality.
  • If you want Mews Operations to automatically log reservation sources that channel managers send, including distribution sources such as GDS and CRS, select the Enable more granular reporting option in your channel manager integration settings. You can learn more about this setting in the Tracking your reservation sources in Mews help article.

To view the Reservation sources report:

  1. In Mews Operations, go to the main menu > Reservations > Reservation sources report. The main menu is the three horizontal lines icon at the top left.

 

 

 

In this article you can learn about:

 

Setting the filters in the report

The Reservation sources report in Mews Operations has the following filters:

  • Service: Select 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 the time to set any time, not only 15-minute intervals.

  • Status: Select any of the following options 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: Select 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 the reservation to Mews Operations. 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 a channel manager, for example D-Edge, passed the reservation to Mews Operations.

    • Reservation source: View results according to the reservation origin before a channel manager sent the reservation to Mews Operations. 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 that rate.

  • Rate group: Select a particular rate group to view results related only to that rate group.

  • 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 connected to those companies.

    • 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 you select a mother company, the child companies appear in results.

  • Travel agency: Select one particular travel agency to view results with respect to that profile; if you select a travel agency that is a mother company to other travel agencies, the child companies appear in results.

Understanding the fields in the report

The Reservation sources report in Mews Operations shows different columns in Detailed mode and in Totals mode.

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 select to filter by, for example Arrival, Canceled or Confirmed.

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

  • Number: Unique reservation number that Mews Operations automatically generates and assigns to the booking. Mews Operations 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 Operations displays with classification icons.

    • Click 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 the format of a person icon followed by the number, for example, a person icon and 2 means two guests.

  • 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 from 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.

    • For stay products, the report lists them in quantity x time unit x short name format.

  • Company: Name of company for business travelers or company-related bookings. Click the company name for a direct link to the company profile.

  • Travel agency: Name of travel agency for bookings associated with any Online Travel Agency, or OTA. An OTA is a website that sells rooms, for example Booking.com. Click the travel agency name for a direct link to the travel agency's company profile.

  • Rate: Average rate per night for the reservation.

  • Total: Total amount due for booking.

  • CC: CC stands for credit card. A credit card icon appears for customers having card details in their profile.

    • Click the credit card icon to go directly to the customer billing screen.

    • Hover over the credit card 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 select to filter by, for example Arrival, Canceled or 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, the Canceled column can show nights even if you don't select the Canceled filter. Note: Canceled nights appear 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. This column is 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, in the property's currency:

    • 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.

Exporting the report

To export the Reservation sources report in Mews Operations:

  1. In Mews Operations, go to the main menu > Reservations > Reservation sources report.

  2. Set the filters and click View report.

  3. Click Export, then select one of the following:

    • Export to Excel: To export the report as an Excel file.

    • Create export schedule: To create an export schedule for this report.

There are additional columns that you can view when you export the report to Excel, including:

  • IATA, which is the International Air Transport Association number of the travel agency

  • Group channel manager ID

  • Group channel confirmation number

  • Travel agency confirmation number

  • Average rate

When exporting the Reservation sources report, you can also view personally identifiable information about the guests, such as phone number, email, address and nationality. Ensure only the relevant users at your property can export this report.

You can learn more about setting up reservation source tracking in Tracking your reservation sources in Mews and about the Reservation overview report in The Reservation overview report.

 

Was this article helpful?
10



Feedback