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 |