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_owner (STRING). Organization’s name of the client.
  • provider_owner (STRING). Organization’s name of the provider.
  • country (STRING). Country of destination (ISO 3166-1 alpha-2).
  • zone_2 (STRING). Administrative second level zone E.g. Madrid city.
  • 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_owner, client_owner).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, city, country, client_owner).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, city, country, client_owner) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, city, country, client_owner) of the total of sellers of TravelgateX.
  • availability_best_compset (INTEGER). Best availability value in the competitive set.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, city, country, provider_owner, client_owner).
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, city, country, client_owner).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, city, country, client_owner) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, city, country, client_owner) of the total of sellers of TravelgateX.
  • booking_best_compset (INTEGER). Best booking value in the competitive set.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, city, country, provider_owner, client_owner).
  • 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_owner).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, city, country, client_owner) 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_owner) of the total of sellers of TravelgateX.
  • revenue_best_compset (INTEGER). Best revenue value in the competitive set.
  • 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_owner)

Preview

client_owner provider_owner country zone_2 city country_city_client search_date availability_value availability_percentile availability_rank availability_compset availability_best_compset booking_value booking_percentile booking_rank booking_compset booking_best_compset revenue_value revenue_percentile revenue_rank revenue_compset revenue_best_compset total_provider country_name availability_tgx booking_tgx revenue_tgx
client 1 provider 1 ES Illes Balears Palma Palma,ES,client 1 2019-04-03 00:00:00 UTC 13 0.8889 1 6.625 13 0 0.0 3 1.5 6 0.0 0.0 3 381.9873 150 10 Spain 250 55 120
client 2 provider 2 CL Provincia de Santiago Santiago Santiago,CL,client 2 2019-04-03 00:00:00 UTC 57 0.8571 2 28.4286 65 1 0.8571 2 3.5 2 322.02 0.0532 2 3024.72 145498 8 Chile 330 33 130
client 3 provider 3 AE Dubai Jaddaf Jaddaf,AE,client 3 2019-04-03 00:00:00 UTC 97 0.8462 2 47.0714 250 0 0.0 2 1.0 5 0.0 0.0 2 1333.491 125 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_owner (STRING). Organization’s name of the client.
  • provider_owner (STRING). Organization’s name of the provider.
  • 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_owner, client_owner).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, country, client_owner).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, country, client_owner) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, country, client_owner) of the total of sellers of TravelgateX.
  • availability_best_compset (INTEGER). Best availability value in the competitive set.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, country, provider_owner, client_owner).
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, country, client_owner).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, country, client_owner) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, country, client_owner) of the total of sellers of TravelgateX.
  • booking_best_compset (INTEGER). Best booking value in the competitive set.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, country, provider_owner, client_owner).
  • 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_owner).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, country, client_owner) 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_owner) of the total of sellers of TravelgateX.
  • revenue_best_compset (INTEGER). Best revenue value in the competitive set.
  • 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_owner)
  • booking_tgx (NUMBER). - Quantity of confirmed bookings in TravelgateX for the Key (seach_date, country, provider_owner)
  • revenue_tgx (NUMBER). - Total net amount in EUR of confirmed bookings in TravelgateX for the key (search_date, country, provider_owner)

Preview

client_owner provider_owner country country_client search_date availability_value availability_percentile availability_rank availability_compset availability_best_compset booking_value booking_percentile booking_rank booking_compset booking_best_compset revenue_value revenue_percentile revenue_rank revenue_compset revenue_best_compset 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 13 0 0.0 3 1.5 6 0.0 0.0 3 381.9873 150 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 65 1 0.8571 2 3.5 2 322.02 0.0532 2 3024.72 145498 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 250 0 0.0 2 1.0 5 0.0 0.0 2 1333.491 125 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_owner (STRING). Organization’s name of the client.
  • provider_owner (STRING). Organization’s name of the provider.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, provider_owner, client_owner).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, provider_owner, client_owner).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, provider_owner, client_owner) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, provider_owner, client_owner) of the total of sellers of TravelgateX.
  • availability_best_compset (INTEGER). Best availability value in the competitive set.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, provider_owner, provider_owner, client_owner).
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, provider_owner, client_owner).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, provider_owner, client_owner) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, provider_owner, client_owner) of the total of sellers of TravelgateX.
  • booking_best_compset (INTEGER). Best booking value in the competitive set.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, provider_owner, client_owner).
  • 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_owner, client_owner).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, provider_owner, client_owner) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, provider_owner, client_owner) of the total of sellers of TravelgateX.
  • revenue_best_compset (INTEGER). Best revenue value in the competitive set.
  • 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_owner, client_owner)
  • booking_tgx (NUMBER). - Quantity of confirmed bookings in TravelgateX for the Key (seach_date, provider_owner, client_owner)
  • revenue_tgx (NUMBER). - Total net amount in EUR of confirmed bookings in TravelgateX for the key (search_date, provider_owner,client_owner)

Preview

client_owner provider_owner search_date availability_value availability_percentile availability_rank availability_compset availability_best_compset booking_value booking_percentile booking_rank booking_compset booking_best_compset revenue_value revenue_percentile revenue_rank revenue_compset revenue_best_compset total_provider country_name availability_tgx booking_tgx revenue_tgx
client 1 provider 1 2019-04-03 00:00:00 UTC 13 0.8889 1 6.625 13 0 0.0 3 1.5 6 0.0 0.0 3 381.9873 150 10 Spain 250 55 120
client 2 provider 2 2019-04-03 00:00:00 UTC 57 0.8571 2 28.4286 65 1 0.8571 2 3.5 2 322.02 0.0532 2 3024.72 145498 8 Chile 330 33 130
client 3 provider 3 2019-04-03 00:00:00 UTC 97 0.8462 2 47.0714 250 0 0.0 2 1.0 5 0.0 0.0 2 1333.491 125 14 United Arab Emirates 225 21 122

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_owner (STRING). Organization’s name of the provider.
  • 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.
  • zone_2 (STRING). Administrative second level zone E.g. Madrid city.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, city, country, provider_owner).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, city, country, provider_owner).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, city, country, provider_owner) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, city, country , provider_owner)of the total of sellers of TravelgateX.
  • availability_best_compset (INTEGER). Best availability value in the competitive set.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, city, country, provider_owner).
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, city, country, provider_owner).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, city, country, provider_owner) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, city, country, provider_owner) of the total of sellers of TravelgateX.
  • booking_best_compset (INTEGER). Best booking value in the competitive set.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, city, country, provider_owner).
  • 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_owner).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, city, country, provider_owner) 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_owner) of the total of sellers of TravelgateX.
  • revenue_best_compset (INTEGER). Best revenue value in the competitive set.
  • 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_owner)
  • booking_tgx (NUMBER). - Quantity of confirmed bookings in TravelgateX for the Key (seach_date, city, country, provider_owner)
  • revenue_tgx (NUMBER). - Total net amount in EUR of confirmed bookings in TravelgateX for the key (search_date, city, country, provider_owner)

Preview

provider_owner country zone_2 city country_city search_date availability_value availability_percentile availability_rank availability_compset availability_best_compset booking_value booking_percentile booking_rank booking_compset booking_best_compset revenue_value revenue_percentile revenue_rank revenue_compset revenue_best_compset total_provider country_name availability_tgx booking_tgx revenue_tgx
provider 1 ES Illes Balears Palma Palma,ES 2019-04-03 00:00:00 UTC 13 0.8889 1 6.625 13 0 0.0 3 1.5 6 0.0 0.0 3 381.9873 150 10 Spain 250 55 120
provider 2 CL Provincia de Santiago Santiago Santiago,CL 2019-04-03 00:00:00 UTC 57 0.8571 2 28.4286 65 1 0.8571 2 3.5 2 322.02 0.0532 2 3024.72 145498 8 Chile 330 33 130
provider 3 AE Dubai Jaddaf Jaddaf,AE 2019-04-03 00:00:00 UTC 97 0.8462 2 47.0714 250 0 0.0 2 1.0 5 0.0 0.0 2 1333.491 125 14 United Arab Emirates 225 21 122

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_owner (STRING). Organization’s name of the provider.
  • country (STRING). Country of destination (ISO 3166-1 alpha-2).
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, country, provider_owner).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, country, provider_owner).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, country, provider_owner) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, country, provider_owner) of the total of sellers of TravelgateX.
  • availability_best_compset (INTEGER). Best availability value in the competitive set.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, country, provider_owner), provider_owner.
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, country, provider_owner).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, country, provider_owner) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, country, provider_owner) of the total of sellers of TravelgateX.
  • booking_best_compset (INTEGER). Best booking value in the competitive set.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, country, provider_owner), provider_owner.
  • 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_owner).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, country, provider_owner) 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_owner) of the total of sellers of TravelgateX.
  • revenue_best_compset (INTEGER). Best revenue value in the competitive set.
  • 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_owner)
  • booking_tgx (NUMBER). - Quantity of confirmed bookings in TravelgateX for the Key (seach_date, country, provider_owner)
  • revenue_tgx (NUMBER). - Total net amount in EUR of confirmed bookings in TravelgateX for the key (search_date, country, provider_owner)

Preview

provider_owner country search_date availability_value availability_percentile availability_rank availability_compset availability_best_compset booking_value booking_percentile booking_rank booking_compset booking_best_compset revenue_value revenue_percentile revenue_rank revenue_compset revenue_best_compset total_provider country_name availability_tgx booking_tgx revenue_tgx
provider 1 ES 2019-04-03 00:00:00 UTC 13 0.8889 1 6.625 13 0 0.0 3 1.5 6 0.0 0.0 3 381.9873 150 10 Spain 250 55 120
provider 2 CL 2019-04-03 00:00:00 UTC 57 0.8571 2 28.4286 65 1 0.8571 2 3.5 2 322.02 0.0532 2 3024.72 145498 8 Chile 330 33 130
provider 3 AE 2019-04-03 00:00:00 UTC 97 0.8462 2 47.0714 250 0 0.0 2 1.0 5 0.0 0.0 2 1333.491 125 14 United Arab Emirates 225 21 122

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_owner (STRING). Organization’s name of the provider.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, provider_owner).
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, provider_owner).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, provider_owner) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, provider_owner) of the total of sellers of TravelgateX.
  • availability_best_compset (INTEGER). Best availability value in the competitive set.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, provider_owner).
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, provider_owner).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, provider_owner) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, provider_owner) of the total of sellers of TravelgateX.
  • booking_best_compset (INTEGER). Best booking value in the competitive set.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, provider_owner).
  • 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_owner).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, provider_owner) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, provider_owner) of the total of sellers of TravelgateX.
  • revenue_best_compset (INTEGER). Best revenue value in the competitive set.
  • 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_owner search_date availability_value availability_percentile availability_rank availability_compset availability_best_compset booking_value booking_percentile booking_rank booking_compset booking_best_compset revenue_value revenue_percentile revenue_rank revenue_compset revenue_best_compset total_provider country_name availability_tgx booking_tgx revenue_tgx
provider 1 2019-04-03 00:00:00 UTC 13 0.8889 1 6.625 13 0 0.0 3 1.5 6 0.0 0.0 3 381.9873 150 10 Spain 250 55 120
provider 2 2019-04-03 00:00:00 UTC 57 0.8571 2 28.4286 65 1 0.8571 2 3.5 2 322.02 0.0532 2 3024.72 145498 8 Chile 330 33 130
provider 3 2019-04-03 00:00:00 UTC 97 0.8462 2 47.0714 250 0 0.0 2 1.0 5 0.0 0.0 2 1333.491 125 14 United Arab Emirates 225 21 122

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