Hotel Rates Benchmark Dataset

On this page you will learn how the data is stored in Benchmark Hotel Rates Dataset and how to interpret the differents table fields.

Overview

The data used corresponds to the search and book transactions for the last 30 days that meet the following criteria:ç

  • Check-in dates by week, starting current week and up to 6 months.
  • Requests for 1 room and 2 adults.
  • Hotels have been mapped against at least another Seller in TravelgateX.

Price is per night in euros (€) and only from net transactions. Total search and book requests with net prices are also included in the report, both your organization’s requests and those to your competitors.

This dataset is updated weekly.


Tables

Descriptions of each table and their correspondent fields are found below:

hotel_rates_weekly_seller

This table contains the total of searches (with net and unknown commission) and ok bookings requests and the minimum price for search and booking requests for my organization and all my competitive set (compset). The metrics are aggregated by check in week, market source, hotel and destination of the hotel.

Fields

  • checkin_week (TIMESTAMP). Week by check-in date in UTC (format: YYYY-MM-DD hh:mm:ss). Date shown corresponds to Monday day.
  • market (STRING). Source market code (ISO 3166-2).
  • hotel_code (STRING). Own hotel code.
  • hotel_name (STRING). Own hotel name.
  • search_ok_net (NUMBER). Quantity of searches with available options and net price.
  • search_ok_net_compset (NUMBER). Quantity of searches with available options and net price in the competitive set.
  • search_ok_unknown (NUMBER). Quantity of searches with available options and unknown price type.
  • search_ok_unknown_compset (NUMBER). Quantity of searches with available options and unknown price type. in the competitive set.
  • search_nok (NUMBER). Quantity of searches without available options.
  • search_nok_compset (NUMBER). Quantity of searches without available options in the competitive set.
  • min_amount_search_net (FLOAT). Minimum price in euros (€) returned in searches requests for the above conditions.
  • min_amount_search_net_compset (FLOAT). Minimum price in euros (€) returned in searches requests for the above conditions in the competitive set.
  • booking_ok (NUMBER). Quantity of bookings with net price.
  • booking_ok_compset (NUMBER). Quantity of bookings with net price in the competitive set.
  • min_amount_booking_net (FLOAT). Minimum price in euros (€) returned in bookings requests for the above conditions.
  • min_amount_booking_net_compset (FLOAT). Minimum price in euros (€) returned in bookings requests for the above conditions in the competitive set.
  • country (STRING). Country destination code (ISO 3166-2).
  • zone_1 (STRING). Administrative first level zone. E.g. Comunidad de Madrid
  • zone_2 (STRING). Administrative second level zone E.g. Madrid city

Preview

checkin_week market hotel_code hotel_name search_ok_net search_ok_net_compset search_ok_unknown search_ok_unknown_compset min_amount_search_net min_amount_search_net_compset booking_ok booking_ok_compset min_amount_booking_net min_amount_booking_net_compset country zone_1 zone_2
2022-07-11 00:00:00 UTC IT 12345 Hotel Faro & Beach Club 358 450 20 35 53,3 48,2 23 39 55,90 54,22 SP Comunidad de Madrid Madrid city
2022-07-11 00:00:00 UTC SP 54321 Hilton Sandton 852 421 28 25 102,75 109,20 23 39 105,42 103,18 ZA Gauteng City of Johannesburg Metropolitan Municipality