Insights Benchmark Dataset

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

Overview

First of all, it’s important to know that the benchmark is given by different period of time:

  • Daily
  • Monthly

and 3 levels of detail:

  • General for TravelgateX.
  • By destination.
  • By seller if your organization has a buyer profile. By buyer if your organization has a seller profile.

These three levels of detail are given by 6 tables, offering in that way all the combinations of detail. This dataset is updated daily. From now, let’s focus on a seller organization. The case of buyer organization is analogous.

The most specific level of detail is given per buyer and city. In there, the benchmark is calculated considering all suppliers in TravelgateX per each city and buyer, this means that you’ll be able to know differents benchmarks for any of your buyers in a specific city. The table that contains that information is benchmarking\_country\_city\_client\_(daily|monthly)\_seller.

The next level of detailed is given per buyer and country. In there, the benchmark is calculated considering all suppliers in TravelgateX per each country and buyer, this means that you’ll be able to know differents benchmarks for any of your buyers in a specific country. The table that contains that information is benchmarking\_country\_client\_(daily|monthly)\_seller.

The following level detail in given per buyer. In there, the benchmark is calculated considering all suppliers in TravelgateX , this means that you’ll be able to know differents benchmarks for any of your buyers for the globaltmarket of TravelgateX. The table that contains that information is benchmarking\_client\_(daily|monthly)\_seller.

By the other hand, you can consult your benchmarks just per city. In there, the benchmark is calculated considering all suppliers in TravelgateX per each city. The table that contains that information is benchmarking\_country\_city\_(daily|monthly)\_seller.

The next level of detailed is given per country. In there, the benchmark is calculated considering all suppliers in TravelgateX per each country. The table that contains that information is benchmarking\_country\_(daily|monthly)\_seller.

Finally, the most general level of detail is given per provider. In there, the benchmark is calculated considering all suppliers in TravelgateX. The table that contains that information is benchmarking\_(daily|monthly)\_seller.

As a summary of above, the next table sum up the level of details for the 6 benchmark tables:

Buyer Information Not Buyer Information
Destination benchmarking_country_city_client_(daily|monthly)_seller benchmarking_country_city_(daily\
benchmarking_country_client_(daily|monthly)_seller benchmarking_country_(daily|monthly)_seller
Not Destination benchmarking_client_(daily|monthly)_seller benchmarking_(daily|monthly)_seller

Next, we’ll explain how to interpret the differents fields of the table.

Interpretation

The bechmark table analyses the total of uniques searches per hotel returning availability, the total of confirmed bookings and the total revenue net in euros. These analisys is made by different metrics:

  • The real value:
    • Total of differents hotels returning availabitity: availabitity_value
    • Total of bookings: booking_value
    • Total of revenue: revenue_value
  • The total for TravelgateX:
    • Total of differents hotels returning availabitity: availability_tgx
    • Total of bookings: booking_tgx
    • Total of revenue: revenue_tgx
  • What percentage of suppliers are above than me:
    • Percentage of total of providers that are worse than me in availables hotels availability_percentile
    • Percentage of total of providers that are worse than me in bookings: booking_percentile
    • Percentage of total of providers that are worse than me in revenue net: revenue_percentile
  • Position of ranking:
    • Position of the ranking by availables hotels considering all sellers in TravelgateX: availability_rank
    • Position of the ranking by my bookings considering all sellers in TravelgateX: booking_rank
    • Position of the ranking by revenue net considering all sellers in TravelgateX: revenue_rank
  • Average per seller (competitive set):
    • Average of all the availables hotels per seller: availability_compset
    • Average of all the bookings per seller: booking_compset
    • Average of all the revenue net per seller: revenue_compset
  • The value of the best seller:
    • Returning availables hotels: availability_best_compset
    • In bookings: booking_best_compset
    • In revenue net: revenue_best_compset

Examples

Let’s consider the following row from the table benchmarking\_country\_city\_client\_(daily\|monthly)\_seller:

client_id provider_id 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 ES,Palma,client 1 2019-04-03 00:00:00 UTC 130 0.8889 1 12.625 130 3 0.7674 3 1.426 15 2104.72 0.8163 2 620.36 2513.5 8 Spain 60000 20 3600

Let’s see what we can say about the provider 1 at 2019-04-03 00:00:00 UTC in availability for the client 1:

  • Has returned 130 diferents hotels availables in Palma to client 1 1 .
  • The total of differents hotels availables in Palma requested by the client 1 is 60000 1 .
  • The provider is above de 89.89% of providers in Palma of client 1.
  • This provider is the first returning availability in Palma for client 1. Here, that’s a point, because the provider is first in the ranking but the percentile is not 100%. That’s why there is another provider retuning the same numbers of hotels availables.
  • The average of hotels availables per provider in Palma for client 1 is 12.25.
  • The provider in TGX that has obtained the most available hotels has obtained a total of 130 availables hotels, so provider 1 is the best seller for the client 1 or there is not another seller returning more availables hotels.

Let’s see what we can say about the provider 1 at 2019-04-03 00:00:00 UTC in bookings for the client 1:

  • Client 1 has booked 3 hotels in Palma to provider 1.
  • The total of bookings in Palma for the client 1 is 20.
  • The seller is above the 76.74% providers operating in Palma for the client 1.
  • This seller is the third in bookability in Palma for the client 1.
  • The average of bookings in Palma per seller for the client 1 is 1.426.
  • The provider in TGX that has obtained the most bookings has obtained a total of 15 bookings, so provider 1 is not so far of the first seller in bookability in Palma for the client 1.

Let’s see what we can say for the provider 1 at 2019-04-03 00:00:00 UTC in revenue for the client 1:

  • The bookings with net price in Palma have been sold for 2104.72€ to client 1.
  • The total of revenue in Palma for all the bookings with net price for the client 1 is 3600€.
  • The seller is above de 81.63% providers operating in Palma for the client 1.
  • This seller is the second in revenue in Palma for the client 1.
  • The average of revenue in Palma per seller is 620.36€ for the client 1.
  • The provider in TGX that has obtained the most revenue has obtained 2513.5€, so provider 1 is close to the seller with largest revenue in Palma for the client 1.

The benchmarks have been calculated comparing provider 1 with other 8 providers.

Let’s consider the following row from the table benchmarking\_country\_city\_(daily\|monthly)\_seller:

provider_id country 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 CU La Habana Vieja La Habana Vieja 2019-04-03 00:00:00 UTC 20 1.0 1 9.3953 20 2 0.902 2 1.8889 4 676.95 0.9412 4 701.0125 1612.7 52 Cuba 60000 20 3600

Let’s see what we can say about the provider 1 at 2019-04-03 00:00:00 UTC in availability:

  • Has returned 20 diferents hotels availables in La Habana Vieja 1 .
  • The total the differents hotels availables in La Habana Vieja is 60000 1 .
  • The provider is above de 100% of providers in La Habana Vieja (so it’s the best).
  • This provider is the first returning availability in La Habana Vieja.
  • The average of hotels availables per provider in La Habana Vieja is 9.3953.
  • The provider in TGX that has obtained the most available hotels has obtained a total of 20 availables hotels, so is the best seller.

Let’s see what we can say about the provider 1 at 2019-04-03 00:00:00 UTC in bookings:

  • Has have 2 bookings in La Habana Vieja.
  • The total of bookings in La Habana Vieja is 20.
  • The seller is above the 90.72% providers operating in La Habana Vieja.
  • This seller is the second in bookability in La Habana Vieja.
  • The average of bookings in La Habana Vieja per seller is 1.8889.
  • The provider in TGX that has obtained the most bookings has obtained a total of 4 bookings, so provider 1 has sold the half of bookings than the best seller in bookability in La Habana Vieja.

Let’s see what we can say for the provider 1 at 2019-04-03 00:00:00 UTC in revenue:

  • The bookings with net price in La Habana Vieja have been sold for 676.95€.
  • The total of revenue in La Habana Vieja for all the bookings with net price is 3600€.
  • The seller is above de 94.12% providers operating in La Habana Vieja.
  • This seller is the fourth in revenue in La Habana Vieja.
  • The average of revenue in La Habana Vieja per seller is 701.0125€.
  • The provider in TGX that has obtained the most revenue has obtained 1612.7€, so provider1 is far to the seller with largest revenue in La Habana Vieja.

The benchmarks have been calculated comparing provider 1 with other 52 providers.


Tables

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

benchmark_country_city_client_(daily|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|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|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|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|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|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|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|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

  1. Taking into account that the hotels between providers do not have to be different. [return]