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:

benchmarking_country_city_client_(daily|weekly|monthly)_seller

This table contains different benchmarks of your organization for the TravelgateX marketplace at specific level of buyer, country and city. The benchmarks are based on the total of differents and availables hotels that have been requested, the total of bookings and the total amount of net revenue of the bookings.

fields

  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • country (STRING). Country of destination (ISO 3166-1 alpha-2).
  • city (STRING). Last level of destination.
  • country_city_client (STRING). Concatenation of fields city, country and client.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, city, country, provider_id, client_id).
  • availability_percentage (FLOAT). Percentage of unique hotels available for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, city, country, client_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, city, country, provider_id, client_id).
  • booking_percentage (FLOAT). Percentage of confirmed bookings for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, city, country, client_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, city, country, provider_id, client_id).
  • revenue_percentage (FLOAT). Percentage of net amount in EUR of confirmed bookings for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, city, country, client_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, city, country, client_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.
  • country_name (STRING). Country name of destination (English).

Preview

client_id provider_id country city country_city_client search_date availability_value availability_percentage availability_percentile availability_rank availability_compset availability_index booking_value booking_percentage booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentage revenue_percentile revenue_rank revenue_compset revenue_index total_provider country_name
client 1 provider 1 ES Palma Palma,ES,client 1 2019-04-03 00:00:00 UTC 13 0.2453 0.8889 1 6.625 1.0 0 0.0 0.0 3 1.5 0.0 0.0 0.0 0.0 3 381.9873 0.0 10 Spain
client 2 provider 2 CL Santiago Santiago,CL,client 2 2019-04-03 00:00:00 UTC 57 0.2864 0.8571 2 28.4286 0.8028 1 0.1429 0.8571 2 3.5 0.1667 322.02 0.0532 0.8571 2 3024.72 0.0562 8 Chile
client 3 provider 3 AE Dubai Dubai,AE,client 3 2019-04-03 00:00:00 UTC 97 0.1472 0.8462 2 47.0714 0.96 0 0.0 0.0 2 1.0 0.0 0.0 0.0 0.0 2 1333.491 0.0 14 United Arab Emirates

benchmarking_country_client_(daily|weekly|monthly)_seller

This table contains different benchmarks of your organization for the TravelgateX marketplace at specific level of buyer and country. The benchmarks are based on the total of differents and availables hotels that have been requested, the total of bookings and the total amount of net revenue of the bookings.

fields

  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • country (STRING). Country of destination (ISO 3166-1 alpha-2).
  • country_client (STRING). Concatenation of fields country and client.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, country, provider_id, client_id).
  • availability_percentage (FLOAT). Percentage of unique hotels available for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, country, client_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, country, provider_id, client_id).
  • booking_percentage (FLOAT). Percentage of confirmed bookings for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, country, client_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, country, provider_id, client_id).
  • revenue_percentage (FLOAT). Percentage of net amount in EUR of confirmed bookings for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, country, client_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, country, client_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.
  • country_name (STRING). Country name of destination (English).

Preview

client_id provider_id country country_client search_date availability_value availability_percentage availability_percentile availability_rank availability_compset availability_index booking_value booking_percentage booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentage revenue_percentile revenue_rank revenue_compset revenue_index total_provider country_name
client 1 provider 1 ES ES,client 1 2019-04-03 00:00:00 UTC 13 0.2453 0.8889 1 6.625 1.0 0 0.0 0.0 3 1.5 0.0 0.0 0.0 0.0 3 381.9873 0.0 10 Spain
client 2 provider 2 CL CL,client 2 2019-04-03 00:00:00 UTC 57 0.2864 0.8571 2 28.4286 0.8028 1 0.1429 0.8571 2 3.5 0.1667 322.02 0.0532 0.8571 2 3024.72 0.0562 8 Chile
client 3 provider 3 AE AE,client 3 2019-04-03 00:00:00 UTC 97 0.1472 0.8462 2 47.0714 0.96 0 0.0 0.0 2 1.0 0.0 0.0 0.0 0.0 2 1333.491 0.0 14 United Arab Emirates

benchmarking_client_(daily|weekly|monthly)_seller

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

fields

  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, provider_id, client_id).
  • availability_percentage (FLOAT). Percentage of unique hotels available for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, provider_id, client_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, provider_id, provider_id, client_id).
  • booking_percentage (FLOAT). Percentage of confirmed bookings for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, provider_id, client_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, provider_id, client_id).
  • revenue_percentage (FLOAT). Percentage of net amount in EUR of confirmed bookings for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, provider_id, client_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, provider_id, client_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.

Preview

client_id provider_id search_date availability_value availability_percentage availability_percentile availability_rank availability_compset availability_index booking_value booking_percentage booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentage revenue_percentile revenue_rank revenue_compset revenue_index total_provider
client 1 provider 1 2019-04-03 00:00:00 UTC 13 0.2453 0.8889 1 6.625 1.0 0 0.0 0.0 3 1.5 0.0 0.0 0.0 0.0 3 381.9873 0.0 10
client 2 provider 2 2019-04-03 00:00:00 UTC 57 0.2864 0.8571 2 28.4286 0.8028 1 0.1429 0.8571 2 3.5 0.1667 322.02 0.0532 0.8571 2 3024.72 0.0562 8
client 3 provider 3 2019-04-03 00:00:00 UTC 97 0.1472 0.8462 2 47.0714 0.96 0 0.0 0.0 2 1.0 0.0 0.0 0.0 0.0 2 1333.491 0.0 14

benchmarking_country_city_(daily|weekly|monthly)_seller

This table contains different benchmarks of your organization for the TravelgateX marketplace at specific level of country and city. The benchmarks are based on the total of differents and availables hotels that have been requested, the total of bookings and the total amount of net revenue of the bookings.

fields

  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • provider_id (STRING). Provider unique ID.
  • country (STRING). Country of destination (ISO 3166-1 alpha-2).
  • city (STRING). Last level of destination.
  • country_city (STRING). Concatenation of fields city and country.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, city, country, provider_id).
  • availability_percentage (FLOAT). Percentage of unique hotels available for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, city, country, provider_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, city, country , provider_id)of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, city, country, provider_id).
  • booking_percentage (FLOAT). Percentage of confirmed bookings for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, city, country, provider_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, city, country, provider_id).
  • revenue_percentage (FLOAT). Percentage of net amount in EUR of confirmed bookings for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, city, country, provider_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, city, country, provider_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.
  • country_name (STRING). Country name of destination (English).

Preview

provider_id country city country_city search_date availability_value availability_percentage availability_percentile availability_rank availability_compset availability_index booking_value booking_percentage booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentage revenue_percentile revenue_rank revenue_compset revenue_index total_provider country_name
provider 1 ES Palma Palma,ES 2019-04-03 00:00:00 UTC 13 0.2453 0.8889 1 6.625 1.0 0 0.0 0.0 3 1.5 0.0 0.0 0.0 0.0 3 381.9873 0.0 10 Spain
provider 2 CL Santiago Santiago,CL 2019-04-03 00:00:00 UTC 57 0.2864 0.8571 2 28.4286 0.8028 1 0.1429 0.8571 2 3.5 0.1667 322.02 0.0532 0.8571 2 3024.72 0.0562 8 Chile
provider 3 AE Dubai Dubai,AE 2019-04-03 00:00:00 UTC 97 0.1472 0.8462 2 47.0714 0.96 0 0.0 0.0 2 1.0 0.0 0.0 0.0 0.0 2 1333.491 0.0 14 United Arab Emirates

benchmarking_country_(daily|weekly|monthly)_seller

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

fields

  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • provider_id (STRING). Provider unique ID.
  • country (STRING). Country of destination (ISO 3166-1 alpha-2).
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, country, provider_id).
  • availability_percentage (FLOAT). Percentage of unique hotels available for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, country, provider_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, country, provider_id), provider_id.
  • booking_percentage (FLOAT). Percentage of confirmed bookings for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, country, provider_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, country, provider_id), provider_id.
  • revenue_percentage (FLOAT). Percentage of net amount in EUR of confirmed bookings for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, country, provider_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, country, provider_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.
  • country_name (STRING). Country name of destination (English).

Preview

provider_id country search_date availability_value availability_percentage availability_percentile availability_rank availability_compset availability_index booking_value booking_percentage booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentage revenue_percentile revenue_rank revenue_compset revenue_index total_provider country_name
provider 1 ES 2019-04-03 00:00:00 UTC 13 0.2453 0.8889 1 6.625 1.0 0 0.0 0.0 3 1.5 0.0 0.0 0.0 0.0 3 381.9873 0.0 10 Spain
provider 2 CL 2019-04-03 00:00:00 UTC 57 0.2864 0.8571 2 28.4286 0.8028 1 0.1429 0.8571 2 3.5 0.1667 322.02 0.0532 0.8571 2 3024.72 0.0562 8 Chile
provider 3 AE 2019-04-03 00:00:00 UTC 97 0.1472 0.8462 2 47.0714 0.96 0 0.0 0.0 2 1.0 0.0 0.0 0.0 0.0 2 1333.491 0.0 14 United Arab Emirates

benchmarking_(daily|weekly|monthly)_seller

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

fields

  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • provider_id (STRING). Provider unique ID.
  • availability_value (NUMBER). Quantity of unique hotels available for key (search_date, provider_id).
  • availability_percentage (FLOAT). Percentage of unique hotels available for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • availability_percentile (FLOAT). Value of percentile of unique hotels availables of all the sellers of TravelgateX for key (search_date, provider_id).
  • availability_rank (NUMBER). Position of the ranking of unique hotels availables for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • availability_compset (FLOAT). Average of unique hotels available for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • availability_index (FLOAT). Min-Max Normalization of the field availability_value.
  • booking_value (NUMBER). Quantity of confirmed bookings for key (search_date, provider_id).
  • booking_percentage (FLOAT). Percentage of confirmed bookings for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • booking_percentile (FLOAT). Value of percentile of confirmed bookings of all the sellers of TravelgateX for key (search_date, provider_id).
  • booking_rank (NUMBER). Position of the ranking of confirmed bookings for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • booking_compset (FLOAT). Average of quantity of confirmed bookings for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • booking_index (FLOAT). Min-Max Normalization of the field booking_value.
  • revenue_value (FLOAT). Total net amount in EUR of confirmed bookings for key (search_date, provider_id).
  • revenue_percentage (FLOAT). Percentage of net amount in EUR of confirmed bookings for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • revenue_percentile (FLOAT). Value of percentile of net amount in EUR of confirmed bookings of all the sellers of TravelgateX for key (search_date, provider_id).
  • revenue_rank (NUMBER). Position of the ranking of net amount in EUR of confirmed bookings for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • revenue_compset (FLOAT). Average of net amount in EUR of confirmed bookings for key (search_date, provider_id) of the total of sellers of TravelgateX.
  • revenue_index (FLOAT). Min-Max Normalization of the field revenue_value.
  • total_provider (STRING). Total of suppliers that have been considered for the benchmarking.

Preview

provider_id search_date availability_value availability_percentage availability_percentile availability_rank availability_compset availability_index booking_value booking_percentage booking_percentile booking_rank booking_compset booking_index revenue_value revenue_percentage revenue_percentile revenue_rank revenue_compset revenue_index total_provider
provider 1 2019-04-03 00:00:00 UTC 13 0.2453 0.8889 1 6.625 1.0 0 0.0 0.0 3 1.5 0.0 0.0 0.0 0.0 3 381.9873 0.0 10
provider 2 2019-04-03 00:00:00 UTC 57 0.2864 0.8571 2 28.4286 0.8028 1 0.1429 0.8571 2 3.5 0.1667 322.02 0.0532 0.8571 2 3024.72 0.0562 8
provider 3 2019-04-03 00:00:00 UTC 97 0.1472 0.8462 2 47.0714 0.96 0 0.0 0.0 2 1.0 0.0 0.0 0.0 0.0 2 1333.491 0.0 14

Comments