Benchmark Dataset Reference

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

Tables

Data is stored in multiple tables depending on the kind of info that wants to be queried and depending on the level of aggregation:

  • Daily (agregation stored every day)
  • Weekly (aggregation stored in the first monday of every week)
  • Monthly (aggregation stored in the first day of the month)

The fields and explanation of tables are based on seller organization. The case of buyer organization is analogous. Descriptions of each table and their correspondent fields are found below:

benchmark_country_city_client_(daily|weekly|monthly)_seller

This table contains different benchmarks of your organization for the TravelgateX marketplace at specific level of buyer, country and city. The benchmarks are based on the total of differents and availables 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).
  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • country (STRING). Country of destination (ISO 3166-1 alpha-2).
  • city (STRING). Last level of destination.
  • country_city_client (STRING). Concatenation of fields city, country and client.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, city, country, provider_id, client_id).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, city, country, client_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, city, country, provider_id, client_id).
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, city, country, client_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, city, country, provider_id, client_id).
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, city, country, client_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.
  • country_name (STRING). Country name of destination (English).
  • availability_tgx (NUMBER). - Quantity of unique hotels available in TravelgateX for key above (search_date, city, country, provider_id)
  • booking_tgx (NUMBER). - Quantity of confirmed bookings in TravelgateX for the Key above (seach_date, city, country, provider_id)
  • revenue_tgx (NUMBER). - Total net amount in EUR of confirmed bookings in TravelgateX for the key (search_date, city, country, provider_id)

Preview

client_id provider_id country city country_city_client search_date availability_value availability_percentile availability_rank availability_compset availability_index booking_value booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentile revenue_rank revenue_compset revenue_index total_provider country_name availability_tgx booking_tgx revenue_tgx
client 1 provider 1 ES Palma Palma,ES,client 1 2019-04-03 00:00:00 UTC 13 0.8889 1 6.625 1.0 0 0.0 3 1.5 0.0 0.0 0.0 3 381.9873 0.0 10 Spain 250 55 120
client 2 provider 2 CL Santiago Santiago,CL,client 2 2019-04-03 00:00:00 UTC 57 0.8571 2 28.4286 0.8028 1 0.8571 2 3.5 0.1667 322.02 0.0532 2 3024.72 0.0562 8 Chile 330 33 130
client 3 provider 3 AE Dubai Dubai,AE,client 3 2019-04-03 00:00:00 UTC 97 0.8462 2 47.0714 0.96 0 0.0 2 1.0 0.0 0.0 0.0 2 1333.491 0.0 14 United Arab Emirates 225 21 122

benchmark_country_client_(daily|weekly|monthly)_seller

This table contains different benchmarks of your organization for the TravelgateX marketplace at specific level of buyer and country. The benchmarks are based on the total of differents and availables 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).
  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • country (STRING). Country of destination (ISO 3166-1 alpha-2).
  • country_client (STRING). Concatenation of fields country and client.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, country, provider_id, client_id).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, country, client_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, country, provider_id, client_id).
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, country, client_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, country, provider_id, client_id).
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, country, client_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.
  • country_name (STRING). Country name of destination (English).
  • availability_tgx (NUMBER). - Quantity of unique hotels available in TravelgateX for key (search_date, country, provider_id)
  • booking_tgx (NUMBER). - Quantity of confirmed bookings in TravelgateX for the Key (seach_date, country, provider_id)
  • revenue_tgx (NUMBER). - Total net amount in EUR of confirmed bookings in TravelgateX for the key (search_date, country, provider_id)

Preview

client_id provider_id country country_client search_date availability_value availability_percentile availability_rank availability_compset availability_index booking_value booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentile revenue_rank revenue_compset revenue_index total_provider country_name availability_tgx booking_tgx revenue_tgx
client 1 provider 1 ES ES,client 1 2019-04-03 00:00:00 UTC 13 0.8889 1 6.625 1.0 0 0.0 3 1.5 0.0 0.0 0.0 3 381.9873 0.0 10 Spain 250 55 120
client 2 provider 2 CL CL,client 2 2019-04-03 00:00:00 UTC 57 0.8571 2 28.4286 0.8028 1 0.8571 2 3.5 0.1667 322.02 0.8571 2 3024.72 0.0562 8 Chile 330 33 130
client 3 provider 3 AE AE,client 3 2019-04-03 00:00:00 UTC 97 0.8462 2 47.0714 0.96 0 0.0 2 1.0 0.0 0.0 0.0 2 1333.491 0.0 14 United Arab Emirates 225 21 122

benchmark_client_(daily|weekly|monthly)_seller

This table contains different benchmarks of your organization for the TravelgateX marketplace at specific level of buyer. The benchmarks are based on the total of differents and availables 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).
  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, provider_id, client_id).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, provider_id, client_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, provider_id, provider_id, client_id).
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, provider_id, client_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, provider_id, client_id).
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, provider_id, client_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.
  • availability_tgx (NUMBER). - Quantity of unique hotels available in TravelgateX for key (search_date, provider_id, client_id)
  • booking_tgx (NUMBER). - Quantity of confirmed bookings in TravelgateX for the Key (seach_date, provider_id, client_id)
  • revenue_tgx (NUMBER). - Total net amount in EUR of confirmed bookings in TravelgateX for the key (search_date, provider_id,client_id)

Preview

client_id provider_id search_date availability_value availability_percentile availability_rank availability_compset availability_index booking_value booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentile revenue_rank revenue_compset revenue_index total_provider availability_tgx booking_tgx revenue_tgx
client 1 provider 1 2019-04-03 00:00:00 UTC 281 0.8696 4 303.5 0.061 45 0.9565 2 20.0 0.2679 28569.807281150093 0.9565 2 15114.587 0.2831 24 7284 300 166260
client 2 provider 2 2019-04-03 00:00:00 UTC 3373 0.381 14 20290.8571 0.0299 23 0.619 8 28.5263 0.1597 11466.54830430146 0.7619 6 14475.2945 0.1503 22 426108 542 217129
client 3 provider 3 2019-04-03 00:00:00 UTC 1729 0.4375 10 8388.8125 0.0199 14 0.5625 8 17.9375 0.2642 8989.779999999999 0.6875 6 11616.4348 0.2632 17 134221 287 151014

benchmark_country_city_(daily|weekly|monthly)_seller

This table contains different benchmarks of your organization for the TravelgateX marketplace at specific level of country and city. The benchmarks are based on the total of differents and availables 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.
  • country_city (STRING). Concatenation of fields city and country.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, city, country, provider_id).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, city, country, provider_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, city, country , provider_id)of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, city, country, provider_id).
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, city, country, provider_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, city, country, provider_id).
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, city, country, provider_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.
  • country_name (STRING). Country name of destination (English).
  • availability_tgx (NUMBER). - Quantity of unique hotels available in TravelgateX for key (search_date, city, country, provider_id)
  • booking_tgx (NUMBER). - Quantity of confirmed bookings in TravelgateX for the Key (seach_date, city, country, provider_id)
  • revenue_tgx (NUMBER). - Total net amount in EUR of confirmed bookings in TravelgateX for the key (search_date, city, country, provider_id)

Preview

provider_id country city country_city search_date availability_value availability_percentile availability_rank availability_compset availability_index booking_value booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentile revenue_rank revenue_compset revenue_index total_provider country_name availability_tgx booking_tgx revenue_tgx
provider 1 GB London London,GB 2019-04-03 00:00:00 UTC 67 0.9706 2 28.4921 0.971 31 1.0 1 4.6667 1.0 13454.129570238987 1.0 1 3278.689 1.0 69 United Kingdom 1795 70 29508
provider 2 CZ Prague Prague,CZ 2019-04-03 00:00:00 UTC 108 0.8 13 63.1304 0.6034 11 0.9867 1 3.0476 1.0 3157.33 0.9867 2 1096.9739 0.921 76 Czech Republic 4356 64 20843
provider 3 CZ Prague Prague,CZ 2019-04-03 00:00:00 UTC 179 0.9733 1 63.1304 1.0 11 0.9867 1 3.0476 1.0 3428.2791823675784 1.0 1 1096.9739 1.0 76 Czech Republic 4356 64 20843

benchmark_country_(daily|weekly|monthly)_seller

This table contains different benchmarks of your organization for the TravelgateX marketplace at specific level of country. The benchmarks are based on the total of differents and availables 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).
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, country, provider_id).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, country, provider_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, country, provider_id), provider_id.
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, country, provider_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, country, provider_id), provider_id.
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, country, provider_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.
  • country_name (STRING). Country name of destination (English).
  • availability_tgx (NUMBER). - Quantity of unique hotels available in TravelgateX for key (search_date, country, provider_id)
  • booking_tgx (NUMBER). - Quantity of confirmed bookings in TravelgateX for the Key (seach_date, country, provider_id)
  • revenue_tgx (NUMBER). - Total net amount in EUR of confirmed bookings in TravelgateX for the key (search_date, country, provider_id)

Preview

provider_id country search_date availability_value availability_percentile availability_rank availability_compset availability_index booking_value booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentile revenue_rank revenue_compset revenue_index total_provider country_name availability_tgx booking_tgx revenue_tgx
provider 1 CU 2019-04-03 00:00:00 UTC 111 0.629 23 98.1731 0.3502 11 0.9839 2 6.0476 0.1774 15634.101013693758 0.9839 2 4431.1882 0.3929 63 Cuba 5105 127 84193
provider 2 CN 2019-04-03 00:00:00 UTC 3302 0.9688 3 744.4259 0.9618 12 0.9844 2 4.8 0.5 5080.809816230813 0.9688 3 2572.4229 0.4133 65 China 40199 72 28297
provider 3 CN 2019-04-03 00:00:00 UTC 1639 0.8594 10 744.4259 0.4774 11 0.9688 3 4.8 0.4583 5247.645802952161 0.9844 2 2572.4229 0.4269 65 China 40199 72 28297

benchmark_(daily|weekly|monthly)_seller

This table contains different benchmarks of your organization for the TravelgateX marketplace. The benchmarks are based on the total of differents and availables 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.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, provider_id).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, provider_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, provider_id).
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, provider_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, provider_id).
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, provider_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.
  • availability_tgx (NUMBER). - Quantity of unique hotels available in TravelgateX for key above.
  • booking_tgx (NUMBER). - Quantity of confirmed bookings in TravelgateX for the key above.
  • revenue_tgx (NUMBER). - Total net amount in EUR of confirmed bookings in TravelgateX for the key above.

Preview

provider_id search_date availability_value availability_percentile availability_rank availability_compset availability_index booking_value booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentile revenue_rank revenue_compset revenue_index total_provider availability_tgx booking_tgx revenue_tgx
provider 1 2019-04-03 00:00:00 UTC 2944 0.7314 77 11463.625 0.0119 29 0.7385 65 103.508 0.0065 29590.885648230473 0.8551 42 58299.9138 0.0131 284 2934688 19356 8336888
provider 2 2019-04-03 00:00:00 UTC 6680 0.7915 60 11463.625 0.0271 19 0.689 73 103.508 0.0043 8789.47669647448 0.742 74 58299.9138 0.0039 284 2934688 19356 8336888
provider 3 2019-04-03 00:00:00 UTC 3130 0.735 76 11463.625 0.0127 12 0.6113 80 103.508 0.0027 8151.5 0.735 76 58299.9138 0.0036 284 2934688 19356 8336888

benchmark_market_city_bw_(daily|weekly|monthly)_(buyer|seller)

This table contains info from searches, quotes, bookings and revenue aggregated per search date, booking window, market, and location (country + Administrative Zone 1 + Administrative Zone 2 + City) by day|week|month of your organization and all buyers|sellers of TravelgateX.

fields

  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • booking_window (NUMBER). It is a division to describe how far away is the check-in date.
    • Last second (0-1 day).
    • Last minute (2-3 days).
    • About 1 week (4-7 days).
    • About 2 weeks (8-14 days).
    • About 1 month (15-30 days)
    • About 2 months (31-60 days).
    • About 3 months (61-90 days).
    • More than 3 months (90+ days).
  • market (STRING). Source market name. E.g. Spain
  • country (STRING). Country destination name. E.g. Spain
  • zone_1 (STRING). Administrative first level zone. E.g. Comunidad de Madrid
  • zone_2 (STRING). Administrative second level zone E.g. Madrid city
  • city (STRING). City name. If the city is big enough this level shows the neighbourghood. E.G. Chamberí
  • search_ok_net (NUMBER). Quantity of searches with available options for above key (search_date, booking_window, market, country, zone_1, zone_2, city) with net price available for your organization.
  • search_ok_unknown (NUMBER). Quantity of searches with available options for above key with a price where we don’t know if any commission is applied for your organization.
  • search_nok (NUMBER). Quantity of searches without available options for above for your organization.
  • tot_amount_search_net (NUMBER). Total net amount of searches for above key for your organization.
  • booking_ok_net (NUMBER). Quantity of bookings for above key with net price available for your organization.
  • booking_ok_unknown (NUMBER). Quantity of bookings for above key with a price where we don’t know if any commission is applied for your organization.
  • tot_amount_booking_net (NUMBER). Total net amount of booking for above key for your organization.
  • nights_rooms_search_ok_net (NUMBER). It is the product of the length of stay, the number of rooms requested and the field search_ok_net.
  • nights_rooms_booking_ok_net (NUMBER). It is the product of the length of stay, the number of rooms requested and the field booking_ok_net.
  • search_ok_net_tgx (NUMBER). Quantity of searches with available options for above key (search_date, booking_window, market, country, zone_1, zone_2, city) with net price available for all buyers|suppliers of TravelgateX.
  • search_ok_unknown_tgx (NUMBER). Quantity of searches with available options for above key with a price where we don’t know if any commission is applied for all buyers|suppliers of TravelgateX.
  • search_nok_tgx (NUMBER). Quantity of searches without available options for above for all buyers|suppliers of TravelgateX.
  • tot_amount_search_net_tgx (NUMBER). Total net amount of searches for above key for all buyers|suppliers of TravelgateX.
  • booking_ok_net_tgx (NUMBER). Quantity of bookings for above key with net price available for all buyers|suppliers of TravelgateX.
  • booking_ok_unknown_tgx (NUMBER). Quantity of bookings for above key with a price where we don’t know if any commission is applied for all buyers|suppliers of TravelgateX.
  • tot_amount_booking_net_tgx (NUMBER). Total net amount of booking for above key for all buyers|suppliers of TravelgateX.
  • nights_rooms_search_ok_net_tgx (NUMBER). It is the product of the length of stay, the number of rooms requested and the field search_ok_net.
  • nights_rooms_booking_ok_net_tgx (NUMBER). It is the product of the length of stay, the number of rooms requested and the field booking_ok_net.

Preview

booking_window search_date market country zone_1 zone_2 city search_ok_net search_ok_unknown search_nok booking_ok_net booking_ok_unknown tot_amount_booking_net tot_amount_search_net nights_rooms_search_ok_net nights_rooms_booking_ok_net search_ok_net_tgx search_ok_unknown_tgx search_nok_tgx booking_ok_net_tgx booking_ok_unknown_tgx tot_amount_booking_net_tgx tot_amount_search_net_tgx nights_rooms_search_ok_net_tgx nights_rooms_booking_ok_net_tgx
15-30 days (about 1 month) 2019-09-02 00:00:00 UTC Spain Spain Andalucia Almeria Las Marinas 0 0 0 0 0 0.0 0.0 0 0 423137 11442 1000767 24 8408.09 2.4921782818564382E8 1842919 109
2-3 days (last minute) 2019-09-02 00:00:00 UTC Bahrain Turkey Mugla Bodrum Guembet 14 0 54 1 0 1359.27 19616.02432 196 14 99 1148 1 1359.27 129696.2713370888 1386 14
31-60 days (about 2 months) 2019-09-02 00:00:00 UTC Romania Malta Saint Paul’s Bay Qawra 13 0 56 1 0 523.0786 10688.083528 91 8 2548 30 2818 1 523.0786 1786575.898334005 11019 8

Comments