Dataset Reference

On this page you will learn how the data is stored in Datasets.

Tables

Data is stored in multiple tables depending on the kind of info that wants to be queried. Descriptions of each table and their correspondent fields are found below:

insights_daily_(buyer|seller)

This table contains info from searches, quotes and bookings aggregated by day.

fields

  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • cache (BOOLEAN). It indicates if the source of request was the client or Speed-X to load info in cache (0=Client, 1=Speed-X).
  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • check_in (TIMESTAMP). Check in date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • nights (NUMBER). Length of stay.
  • market (STRING). Source market of paxes (ISO 3166-1 alpha-2).
  • num_rooms (NUMBER). Quantity of rooms.
  • adults (NUMBER). Quantity of paxes older than 12 years (12 is not included).
  • children (NUMBER). Quantity of paxes between 2 and 12 (both included).
  • infants (NUMBER). Quantity of paxes younger than 2 years (2 is not included).
  • search_ok (NUMBER). Quantity of searches that returned any available hotel for above key (search_date, check_in…).
  • search_nok (NUMBER). Quantity of searches that didn’t return any available hotels for above key.
  • quote_ok (NUMBER). Quantity of quotes that returned a correct result for above key.
  • quote_nok (NUMBER). Quantity of quotes that returned a wrong result for above key.
  • booking_ok_net (NUMBER). Quantity of confirmed bookings for above key where we have the net amount in EUR.
  • booking_ok_unknown (NUMBER). Quantity of confirmed bookings for above key where we have the amount in EUR but it may have applied commissions.
  • booking_nok (NUMBER). Quantity of failed bookings for above key.
  • min_amount_booking_net (NUMBER). Net amount of cheapest booking for above key.
  • max_amount_booking_net (NUMBER). Net amount of most expensive booking for above key.
  • tot_amount_booking_net (NUMBER). Total net amount of confirmed bookings for above key.
  • min_amount_booking_net (NUMBER). Amount of cheapest booking for above key when we don’t know if any commission is applied.
  • max_amount_booking_net (NUMBER). Amount of most expensive booking for above key when we don’t know if any commission is applied.
  • tot_amount_booking_net (NUMBER). Total amount of confirmed bookings for above key when we don’t know if any commission is applied.
  • hotels (STRUCT). Repeated field that contains info about hotels for above key.
    • code (STRING). Hotel unique ID.
    • search_ok_net (NUMBER). Quantity of searches with available options for above key and hotel with net price available.
    • search_ok_unknown (NUMBER). Quantity of searches with available options for above key and hotel with a price where we don’t know if any commission is applied.
    • search_nok (NUMBER). Quantity of searches without available options for above key and hotel.
    • min_amount_search_net (NUMBER). Net amount of cheapest option for that hotel.
    • max_amount_search_net (NUMBER). Net amount of most expensive option for that hotel.
    • tot_amount_search_net (NUMBER). Total net amount of searches for that hotel.
    • min_amount_search_unknown (NUMBER). Amount of cheapest option for that hotel (Commission not available).
    • max_amount_search_unknown (NUMBER). Amount of most expensive option for that hotel (Commission not available).
    • tot_amount_search_unknown (NUMBER). Total amount of searches for that hotel (Commission not available).
    • quote_ok_net (NUMBER). Quantity of quotes for above key and hotel with net price available.
    • quote_ok_unknown (NUMBER). Quantity of quotes for above key and hotel with a price where we don’t know if any commission is applied.
    • quote_nok (NUMBER). Quantity of failed quotes for above key and hotel.
    • min_amount_quote_net (NUMBER). Net amount of cheapest quote for that hotel.
    • max_amount_quote_net (NUMBER). Net amount of most expensive quote for that hotel.
    • tot_amount_quote_net (NUMBER). Total net amount of quotes for that hotel.
    • min_amount_quote_unknown (NUMBER). Amount of cheapest quote for that hotel (Commission not available).
    • max_amount_quote_unknown (NUMBER). Amount of most expensive quote for that hotel (Commission not available).
    • tot_amount_quote_unknown (NUMBER). Total amount of quotes for that hotel (Commission not available).
    • booking_ok_net (NUMBER). Quantity of bookings for above key and hotel with net price available.
    • booking_ok_unknown (NUMBER). Quantity of bookings for above key and hotel with a price where we don’t know if any commission is applied.
    • booking_nok (NUMBER). Quantity of failed bookings for above key and hotel.
    • min_amount_booking_net (NUMBER). Net amount of cheapest booking for that hotel.
    • max_amount_booking_net (NUMBER). Net amount of most expensive booking for that hotel.
    • tot_amount_booking_net (NUMBER). Total net amount of booking for that hotel.
    • min_amount_booking_unknown (NUMBER). Amount of cheapest booking for that hotel (Commission not available).
    • max_amount_booking_unknown (NUMBER). Amount of most expensive booking for that hotel (Commission not available).
    • tot_amount_booking_unknown (NUMBER). Total amount of booking for that hotel (Commission not available).

Preview

client_id provider_id cache search_date check_in nights nationality num_rooms adults children infants search_ok search_nok quote_ok quote_nok booking_ok_net booking_ok_unknow booking_nok min_amount_booking_net max_amount_booking_net tot_amount_booking_net min_amount_booking_unknown max_amount_booking_unknown tot_amount_booking_unknown hotels.code hotels.search_ok_net hotels.search_ok_unknown hotels.search_nok hotels.quote_ok_net hotels.quote_ok_unknown hotels.quote_nok hotels.booking_ok_net hotels.booking_ok_unknown hotels.booking_nok hotels.min_amount_search_net hotels.max_amount_search_net hotels.tot_amount_search_net hotels.min_amount_search_unknown hotels.max_amount_search_unknown hotels.tot_amount_search_unknown hotels.min_amount_quote_net hotels.max_amount_quote_net hotels.tot_amount_quote_net hotels.min_amount_quote_unknown hotels.max_amount_quote_unknown hotels.tot_amount_quote_unknown hotels.min_amount_booking_net hotels.max_amount_booking_net hotels.tot_amount_booking_net hotels.min_amount_booking_unknown hotels.max_amount_booking_unknown hotels.tot_amount_booking_unknown
client A provider X false 2019-01-13 00:00:00 UTC 2019-02-13 00:00:00 UTC 4 SE 1 1 null null 13 11 null null null null null null null null null null null 641443 13 null null null null null null null null null null null null null null null null null null null null null null null null null null
551568 null 11 null null null null null null null null null null null null null null null null null null null null null null null null null
client B provider Y false 2019-01-13 00:00:00 UTC 2019-01-18 00:00:00 UTC 2 CN 1 2 null null 6 1 3 null 1 null null 398.84 398.84 398.84 null null null 299 null null 1 null null null null null null null null null null null null null null null null null null null null null null null null
927 5 null null 3 null null 1 null null 198.84 598.84 2393.04 null null null 198.84 598.84 1196.52 null null null 398.84 398.84 398.84 null null null
203 null 1 null null null null null null null null null null 2548.26 2548.26 2548.26 null null null null null null null null null null null null

insights_agg_daily_(buyer|seller)

This table contains info similar to insights_daily_(buyer|seller) but with a bigger aggregation. The fields check_in, adults, children and infants have disapeared.

fields

  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • cache (BOOLEAN). It indicates if the source of request was the client or Speed-X to load info in cache (0=Client, 1=Speed-X).
  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • booking_window (NUMBER). It is an enumeration to describe how far away is the check-in date.
    • 1 = Last second (0-1 day).
    • 2 = Last minute (2-3 days).
    • 3 = About 1 week (4-7 days).
    • 4 = About 2 weeks (8-14 days).
    • 5 = About 1 month (15-30 days)
    • 6 = About 2 months (31-60 days).
    • 7 = About 3 months (61-90 days).
    • 8 = More than 3 months (90+ days).
  • nights (NUMBER). Length of stay.
  • market (STRING). Source market of the paxes (ISO 3166-1 alpha-2).
  • num_rooms (NUMBER). Quantity of rooms.
  • pax_type (NUMBER). It is an enumeration to describe a combination of paxes (adults + children + infants).
    • 1 = Solo (Adults = 1, children = 0 and infants = 0).
    • 2 = Couple (Adults = 2, children = 0 and infants = 0).
    • 3 = Family (Adults = 2, children + infants > 0).
    • 4 = Group (Adults > 2).
    • 5 = Other.
  • search_ok (NUMBER). Quantity of searches that returned any available hotel for above key (search_date, check_in…).
  • search_nok (NUMBER). Quantity of searches that didn’t return any available hotels for above key.
  • quote_ok (NUMBER). Quantity of quotes that returned a correct result for above key.
  • quote_nok (NUMBER). Quantity of quotes that returned a wrong result for above key.
  • booking_ok_net (NUMBER). Quantity of confirmed bookings for above key where we have the net amount in EUR.
  • booking_ok_unknown (NUMBER). Quantity of confirmed bookings for above key that have the amount in EUR but it may have commissions applied.
  • booking_nok (NUMBER). Quantity of failed bookings for above key.
  • min_amount_booking_net (NUMBER). Net amount of cheapest booking for above key.
  • max_amount_booking_net (NUMBER). Net amount of most expensive booking for above key.
  • tot_amount_booking_net (NUMBER). Total net amount of confirmed bookings for above key.
  • min_amount_booking_unknown (NUMBER). Amount of cheapest booking for above key when we don’t know if any commission is applied.
  • max_amount_booking_unknown (NUMBER). Amount of most expensive booking for above key when we don’t know if any commission is applied.
  • tot_amount_booking_unknown (NUMBER). Total amount of confirmed bookings for above key when we don’t know if any commission is applied.
  • hotels (STRUCT). Repeated field that contains info about hotels for above key.
    • code (STRING). Hotel unique ID.
    • search_ok_net (NUMBER). Quantity of searches with available options for above key and hotel with net price available.
    • search_ok_unknown (NUMBER). Quantity of searches with available options for above key and hotel with a price where we don’t know if any commission is applied.
    • search_nok (NUMBER). Quantity of searches without available options for above key and hotel.
    • min_amount_search_net (NUMBER). Net amount of cheapest option for that hotel.
    • max_amount_search_net (NUMBER). Net amount of most expensive option for that hotel.
    • tot_amount_search_net (NUMBER). Total net amount of searches for that hotel.
    • min_amount_search_unknown (NUMBER). Amount of cheapest option for that hotel (Commission not available).
    • max_amount_search_unknown (NUMBER). Amount of most expensive option for that hotel (Commission not available).
    • tot_amount_search_unknown (NUMBER). Total amount of searches for that hotel (Commission not available).
    • quote_ok_net (NUMBER). Quantity of quotes for above key and hotel with net price available.
    • quote_ok_unknown (NUMBER). Quantity of quotes for above key and hotel with a price over we don’t know if any commission is applied.
    • quote_nok (NUMBER). Quantity of failed quotes for above key and hotel.
    • min_amount_quote_net (NUMBER). Net amount of cheapest quote for that hotel.
    • max_amount_quote_net (NUMBER). Net amount of most expensive quote for that hotel.
    • tot_amount_quote_net (NUMBER). Total net amount of quotes for that hotel.
    • min_amount_quote_unknown (NUMBER). Amount of cheapest quote for that hotel (Commission not available).
    • max_amount_quote_unknown (NUMBER). Amount of most expensive quote for that hotel (Commission not available).
    • tot_amount_quote_unknown (NUMBER). Total amount of quotes for that hotel (Commission not available).
    • booking_ok_net (NUMBER). Quantity of bookings for above key and hotel with net price available.
    • booking_ok_unknown (NUMBER). Quantity of bookings for above key and hotel with a price where we don’t know if any commission is applied.
    • booking_nok (NUMBER). Quantity of failed bookings for above key and hotel.
    • min_amount_booking_net (NUMBER). Net amount of cheapest bookings for that hotel.
    • max_amount_booking_net (NUMBER). Net amount of most expensive bookings for that hotel.
    • tot_amount_booking_net (NUMBER). Total net amount of bookings for that hotel.
    • min_amount_booking_unknown (NUMBER). Amount of cheapest bookings for that hotel (Commission not available).
    • max_amount_booking_unknown (NUMBER). Amount of most expensive bookings for that hotel (Commission not available).
    • tot_amount_booking_unknown (NUMBER). Total amount of bookings for that hotel (Commission not available).

Preview

client_id provider_id cache search_date booking_window nights nationality num_rooms pax_type search_ok search_nok quote_ok quote_nok booking_ok_net booking_ok_unknow booking_nok min_amount_booking_net max_amount_booking_net tot_amount_booking_net min_amount_booking_unknown max_amount_booking_unknown tot_amount_booking_unknown hotels.code hotels.search_ok_net hotels.search_ok_unknown hotels.search_nok hotels.quote_ok_net hotels.quote_ok_unknown hotels.quote_nok hotels.booking_ok_net hotels.booking_ok_unknown hotels.booking_nok hotels.min_amount_search_net hotels.max_amount_search_net hotels.tot_amount_search_net hotels.min_amount_search_unknown hotels.max_amount_search_unknown hotels.tot_amount_search_unknown hotels.min_amount_quote_net hotels.max_amount_quote_net hotels.tot_amount_quote_net hotels.min_amount_quote_unknown hotels.max_amount_quote_unknown hotels.tot_amount_quote_unknown hotels.min_amount_booking_net hotels.max_amount_booking_net hotels.tot_amount_booking_net hotels.min_amount_booking_unknown hotels.max_amount_booking_unknown hotels.tot_amount_booking_unknown
client A provider X false 2019-01-13 00:00:00 UTC 3 4 SE 1 1 13 11 null null null null null null null null null null null 641443 13 null null null null null null null null null null null null null null null null null null null null null null null null null null
551568 null 11 null null null null null null null null null null null null null null null null null null null null null null null null null
client B provider Y false 2019-01-13 00:00:00 UTC 3 2 CN 1 2 6 1 3 null 1 null null 398.84 398.84 398.84 null null null 299 null null 1 null null null null null null null null null null null null null null null null null null null null null null null null
927 5 null null 3 null null 1 null null 198.84 598.84 2393.04 null null null 198.84 598.84 1196.52 null null null 398.84 398.84 398.84 null null null
203 null 1 null null null null null null null null null null 2548.26 2548.26 2548.26 null null null null null null null null null null null null

effective_bookings_(buyer|seller)

This table contains specific information about bookings done and their current status (Ok or cancelled).

fields

  • session_id (STRING). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • booking_date (TIMESTAMP). Booking date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • checkin_date (TIMESTAMP). Checkin date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • amount (NUMBER). Amount of bookings in EUR.
  • cancel_date (TIMESTAMP). Cancel date in UTC (format: YYYY-MM-DD hh:mm:ss) if the booking was cancelled elsewhere will be empty.
  • market (STRING). Source market of paxes (ISO 3166-1 alpha-2).
  • market_name (STRING). Source market’s name.
  • num_room (NUMBER). Quantity of rooms booked.
  • nights (NUMBER). Length of stay.
  • country (STRING). Country of destination (ISO 3166-1 alpha-2).
  • zone_1 (STRING). Main zone of destination.
  • zone_2 (STRING). Secondary zone of destination.
  • city (STRING). Last level of destination.
  • hotel_code (STRING). Hotel’s code in provider’s portfolio.
  • hotel_name (STRING). Hotel’s name in provider’s portfolio.

Preview

session_id client_id provider_id booking_date checkin_date amount cancel_date market market_name num_room nights country zone_1 zone_2 city hotel_code hotel_name
123456789012 client 1 provider 1 2018-03-28 12:21:18 UTC 2018-05-28 12:00:00 UTC 244.72 null IT Italy 1 3 US Utah Garfield County Panguitch 123 Hotel Test

daily_portfolio_seller

This table is used to know which hotels over supplier’s portfolio are being queried by the clients. This can be helpful to know which percentage over portfolio is being mapped by the client.

fields

  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • hotel (STRING). Hotel unique ID.
  • hotel_name_portfolio (STRING). Hotel name.
  • hotel_country_portfolio (STRING). Hotel Country Code (ISO Alpha-2 code).
  • status. It is an enumeration to describe the status of the hotel.
    • 0 = Hotel code queried but it doesn’t appear in provider’s portfolio. It can be due to a wrong mapping in the client’s system.
    • 1 = Hotel code not queried but it appears in provider’s portfolio. It can be due to a mismapping in the client’s system.
    • 2 = Hotel code queried and it appears in the provider’s portfolio.

Preview

client_id provider_id hotel hotel_name_portfolio hotel_country_portfolio status
client A provider X 1 hotel_1 ES 1
client A provider X 2 hotel_2 IT 2
client A provider X V null null 0
client B provider Y 1 hotel_1 FR 1

daily_stats

This table contains transactional info (response status, response time…) of requests between clients and providers.

fields

  • st_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss)
  • client_id (STRING). Client unique ID
  • provider_id (STRING). Provider unique ID
  • speed (BOOLEAN). It indicates if the source of the request was the client, or Speed-X to load info in cache (0=Client, 1=Speed-X).
  • avail_ok (NUMBER). Quantity of searches with available results.
  • avail_nok_results (NUMBER). Quantity of searches without available results.
  • avail_nok_provider (NUMBER). Quantity of searches with generic error from provider.
  • avail_nok_bad_request (NUMBER). Quantity of searches with error due a wrong request.
  • avail_nok_integration (NUMBER). Quantity of searches with error due a failure in the connector.
  • avail_nok_communication (NUMBER). Quantity of searches with error due a timeout.
  • avail_nok_others (NUMBER). Quantity of searches with errors different to those above.
  • avail_time (NUMBER). Total response time (in milliseconds) for all searches.
  • quote_ok (NUMBER). Quantity of quotes with available results.
  • quote_nok_results (NUMBER). Quantity of quotes without available results.
  • quote_nok_provider (NUMBER). Quantity of quotes with generic error from provider.
  • **quote_nok_bad_request. Quantity of quotes with error due to a wrong request.
  • **quote_nok_integration. Quantity of quotes with error due a failure in the connector.
  • quote_nok_communication (NUMBER). Quantity of quotes with error due to a timeout.
  • quote_nok_others (NUMBER). Quantity of quotes with errors different to those above.
  • quote_time (NUMBER). Total response time (in milliseconds) for all quotes.
  • book_ok (NUMBER). Quantity of correct bookings.
  • book_nok (NUMBER). Quantity of bookings with an error.
  • **book_time (NUMBER. Total response time (in milliseconds) for bookings.
  • cancel_ok (NUMBER). Quantity of correct cancellations.
  • cancel_nok (NUMBER). Quantity of cancellations with an error.
  • cancel_time (NUMBER). Total response time (in milliseconds) for cancellations.
  • other_ok (NUMBER). Quantity of transactions that cannot be included in one of above groups and that didn’t receive an error.
  • other_nok (NUMBER). Quantity of other transactions with an error.
  • other_time (NUMBER). Total response time (in milliseconds) for other transactions.

Preview

st_date client_id provider_id speed avail_ok avail_nok_results avail_nok_provider avail_nok_bad_request avail_nok_integration avail_nok_communication avail_nok_others avail_time quote_ok quote_nok_results quote_nok_provider quote_nok_bad_request quote_nok_integration quote_nok_communication quote_nok_others quote_time book_ok book_nok book_time cancel_ok cancel_nok cancel_time other_ok other_nok other_time
2018-03-28 12:00:00 UTC client 1 provider 1 false 372408 159272 571 30093 0 40 0 206883360 182 0 0 0 0 0 0 38166 3 0 31848 0 0 0 0 0 0
2018-03-28 12:00:00 UTC client 1 provider 2 false 50 10 0 0 0 0 0 48754 419 6 0 0 0 4 0 374301 5 0 41257 1 0 6080 172 0 5116
2018-03-28 12:00:00 UTC client 2 provider 1 false 548214 0 577 0 714 0 0 47457579 3719 32 0 0 0 0 0 327425 18 0 81757 6 4 31803 230 0 42614

daily_benchmarking_seller

This table contains different benchmarks of your organization for the TravelgateX marketplace. The benchmarks are based on the total of different and available hotels that have been requested, the total of bookings and the total amount of net revenue of the bookings.

fields

  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • provider_id (STRING). Provider unique ID.
  • country (STRING). Country of destination (ISO 3166-1 alpha-2).
  • city (STRING). Last level of destination.
  • city_country (STRING). Concatenation of fields city and country.
  • search_ok_net (NUMBER). Quantity of unique hotels available for key (search_date, city, country, provider_id).
  • perc_search_ok_net (FLOAT). Percentage of unique hotels available for key (search_date, city, country) of the total of sellers of TravelgateX.
  • percentile_search_ok_net (FLOAT). Value of percentile of the sorted list of unique hotels availables of all the sellers of TravelgateX for key (search_date, city, country).
  • rank_search_ok_net (NUMBER). Position of the ranking of unique hotels available for key (search_date, city, country) of the total of sellers of TravelgateX.
  • avg_search_ok_net (FLOAT). Average of unique hotels available for key (search_date, city, country) of the total of sellers of TravelgateX.
  • index_norm_search_ok_net (FLOAT). Min-Max Normalization of the field search_ok_net divided by avg_search_ok_net.
  • booking_ok_net (NUMBER). Quantity of confirmed bookings for key (search_date, city, country, provider_id).
  • perc_booking_ok_net (FLOAT). Percentage of confirmed bookings for key (search_date, city, country) of the total of sellers of TravelgateX.
  • percentile_booking_ok_net (FLOAT). Value of percentile of the sorted list of confirmed bookings, where we have the net amount in EUR of all the sellers of TravelgateX for key (search_date, city, country).
  • rank_booking_ok_net (NUMBER). Position of the ranking of confirmed bookings for key (search_date, city, country) of the total of sellers of TravelgateX.
  • avg_booking_ok_net (FLOAT). Average of quantity of confirmed bookings for key (search_date, city, country) of the total of sellers of TravelgateX.
  • index_norm_booking_ok_net (FLOAT). Min-Max Normalization of the field booking_ok_net divided by avg_booking_ok_net.
  • tot_amount_booking_net (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, city, country, provider_id).
  • perc_tot_amount_booking_net (FLOAT). Percentage of net amount in EUR of confirmed bookings for key (search_date, city, country) of the total of sellers of TravelgateX.
  • percentile_tot_amount_booking_net (FLOAT). Value of percentile of the sorted list of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, city, country).
  • rank_tot_amount_booking_net (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, city, country) of the total of sellers of TravelgateX.
  • avg_tot_amount_booking_net (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, city, country) of the total of sellers of TravelgateX.
  • index_norm_tot_amount_booking_net (FLOAT). Min-Max Normalization of the field tot_amount_booking_net divided by avg_tot_amount_booking_net.
  • search_ok_net_country (NUMBER). Quantity of unique hotels available for key (search_date, country, provider_id).
  • perc_search_ok_net_country (FLOAT). Percentage of unique hotels available for key (search_date, country) of the total of sellers of TravelgateX.
  • percentile_search_ok_net_country (FLOAT). Value of percentile of the sorted list of unique hotels availables of all the sellers of TravelgateX for key (search_date, country).
  • rank_search_ok_net_country (NUMBER). Position of the ranking of unique hotels available for key (search_date, country) of the total of sellers of TravelgateX.
  • avg_search_ok_net_country (FLOAT). Average of unique hotels available for key (search_date, country) of the total of sellers of TravelgateX.
  • index_norm_search_ok_net_country (FLOAT). Min-Max Normalization of the field search_ok_net divided by avg_search_ok_net.
  • booking_ok_net_country (NUMBER). Quantity of confirmed bookings for key (search_date, country, provider_id).
  • perc_booking_ok_net_country (FLOAT). Percentage of Quantity of confirmed bookings for key (search_date, country) of the total of sellers of TravelgateX.
  • percentile_booking_ok_net_country (FLOAT). Value of percentile of the sorted list of confirmed bookings, where we have the net amount in EUR for all the sellers of TravelgateX for key (search_date, country).
  • rank_booking_ok_net_country (NUMBER). Position of the ranking of Quantity of confirmed bookings for key (search_date, country) of the total of sellers of TravelgateX.
  • avg_booking_ok_net_country (FLOAT). Average of quantity of confirmed bookings for key (search_date, country) of the total of sellers of TravelgateX.
  • index_norm_booking_ok_net_country (FLOAT). Min-Max Normalization of the field booking_ok_net divided by avg_booking_ok_net.
  • tot_amount_booking_net_country (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, country, provider_id).
  • perc_tot_amount_booking_net_country (FLOAT). Percentage of net amount in EUR of confirmed bookings for key (search_date, country) of the total of sellers of TravelgateX.
  • percentile_tot_amount_booking_net_country (FLOAT). Value of percentile of the sorted list of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, country).
  • rank_tot_amount_booking_net_country (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, country) of the total of sellers of TravelgateX.
  • avg_tot_amount_booking_net_country (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, country) of the total of sellers of TravelgateX.
  • index_norm_tot_amount_booking_net_country (FLOAT). Min-Max Normalization of the field tot_amount_booking_net divided by avg_tot_amount_booking_net.
  • search_ok_net_provider (NUMBER). Quantity of unique hotels available for key (search_date, provider_id)
  • perc_search_ok_net_provider (FLOAT). Percentage of unique hotels available for key (search_date) of the total of sellers of TravelgateX.
  • percentile_search_ok_net_provider (FLOAT). Value of percentile of the sorted list of unique hotels availables of all the sellers of TravelgateX for key (search_date).
  • rank_search_ok_net_provider (NUMBER). Position of the ranking of unique hotels available for key (search_date) of the total of sellers of TravelgateX.
  • avg_search_ok_net_provider (FLOAT). Average of unique hotels available for key (search_date) of the total of sellers of TravelgateX.
  • index_norm_search_ok_net_provider (FLOAT). Min-Max Normalization of the field search_ok_net divided by avg_search_ok_net.
  • booking_ok_net_provider (NUMBER). Quantity of confirmed bookings for key (search_date, provider_id).
  • perc_booking_ok_net_provider (FLOAT). Percentage of Quantity of confirmed bookings for key (search_date) of the total of sellers of TravelgateX.
  • percentile_booking_ok_net_provider (FLOAT). Value of percentile of the sorted list of confirmed bookings, where we have the net amount in EUR of all the sellers of TravelgateX for key (search_date).
  • rank_booking_ok_net_provider (NUMBER). Position of the ranking of Quantity of confirmed bookings for key (search_date) of the total of sellers of TravelgateX.
  • avg_booking_ok_net_provider (FLOAT). Average of quantity of confirmed bookings for key (search_date) of the total of sellers of TravelgateX.
  • index_norm_booking_ok_net_provider (FLOAT). Min-Max Normalization of the field booking_ok_net divided by avg_booking_ok_net.
  • tot_amount_booking_net_provider (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, provider_id).
  • perc_tot_amount_booking_net_provider (FLOAT). Percentage of net amount in EUR of confirmed bookings for key (search_date) of the total of sellers of TravelgateX.
  • percentile_tot_amount_booking_net_provider (FLOAT). Value of percentile of the sorted list of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date).
  • rank_tot_amount_booking_net_provider (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date) of the total of sellers of TravelgateX.
  • avg_tot_amount_booking_net_provider (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date) of the total of sellers of TravelgateX.
  • index_norm_tot_amount_booking_net_provider (FLOAT). Min-Max Normalization of the field tot_amount_booking_net divided by avg_tot_amount_booking_net.
  • total_provider_per_city (STRING). Total of suppliers that have been considered for the benchmarking per city.
  • total_provider_per_country (STRING). Total of suppliers that have been considered for the benchmarking per country.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking for the TravelgateX marketplace.

Preview

provider_id country city city_country search_date search_ok_net perc_search_ok_net percentile_search_ok_net rank_search_ok_net avg_search_ok_net index_norm_search_ok_net booking_ok_net perc_booking_ok_net percentile_booking_ok_net rank_booking_ok_net avg_booking_ok_net index_norm_booking_ok_net tot_amount_booking_net perc_tot_amount_booking_net percentile_tot_amount_booking_net rank_tot_amount_booking_net avg_tot_amount_booking_net index_norm_tot_amount_booking_net search_ok_net_country perc_search_ok_net_country percentile_search_ok_net_country rank_search_ok_net_country avg_search_ok_net_country index_norm_search_ok_net_country booking_ok_net_country perc_booking_ok_net_country percentile_booking_ok_net_country rank_booking_ok_net_country avg_booking_ok_net_country index_norm_booking_ok_net_country tot_amount_booking_net_country perc_tot_amount_booking_net_country percentile_tot_amount_booking_net_country rank_tot_amount_booking_net_country avg_tot_amount_booking_net_country index_norm_tot_amount_booking_net_country search_ok_net_provider perc_search_ok_net_provider percentile_search_ok_net_provider rank_search_ok_net_provider avg_search_ok_net_provider index_norm_search_ok_net_provider booking_ok_net_provider perc_booking_ok_net_provider percentile_booking_ok_net_provider rank_booking_ok_net_provider avg_booking_ok_net_provider index_norm_booking_ok_net_provider tot_amount_booking_net_provider perc_tot_amount_booking_net_provider percentile_tot_amount_booking_net_provider rank_tot_amount_booking_net_provider avg_tot_amount_booking_net_provider index_norm_tot_amount_booking_net_provider total_provider_per_city total_provider_per_country total_provider
provider 1 Country ISO Code 1 City 1 City 1,Country ISO Code 1 2019-03-19 00:00:00 UTC 68 0.03 96.3 3.0 27.58 0.33 0 0.0 0.0 8.0 0.62 0.0 0 0.0 0.0 11.0 324.92 0.0 6716 0.03 94.7 8.0 1448.61 0.58 5 0.001 65.9 31.0 23.80 0.006 2397 0.001 69.7 41.0 10495.25 0.005 66767 0.025 95.4 13.0 9883.10 0.3 7 3.96E-4 64.4 74.0 67.41 0.001 3646 5.05E-4 65.1 92.0 27524.42 0.0016 81 133 262
provider 1 Country ISO Code 1 City 2 City 2, Country ISO Code 1 2019-03-19 00:00:00 UTC 92 0.04 96.2 3.0 27.59 0.62 0 0.0 0.0 7.0 0.65 0.0 0 0.0 0.0 12.0 251.56 0.0 6716 0.03 94.7 8.0 1448.61 0.58 5 0.001 65.9 31.0 23.80 0.006 2397 0.001 69.7 41.0 10495.25 0.005 66767 0.025 95.4 13.0 9883.10 0.3 7 3.96E-4 64.4 74.0 67.41 0.001 3646 5.05E-4 65.1 92.0 27524.42 0.001 79 133 262
provider 1 Country ISO Code 1 City 3 City 3, Country ISO Code 1 2019-03-19 00:00:00 UTC 29 0.03 96.0 3.0 10.11 0.41 0 0.0 0.0 4.0 0.27 0.0 0 0.0 0.0 12.0 149.44 0.0 6716 0.03 94.7 8.0 1448.61 0.58 5 0.001 65.9 31.0 23.80 0.006 2397 0.001 69.7 41.0 10495.255 0.005 66767 0.025 95.4 13.0 9883.10 0.3 7 3.968E-4 64.4 74.0 67.41 0.001 3646 5.05E-4 65.1 92.0 27524.42 0.001 76 133 262

Comments