Performance Benchmark Dataset

On this page you will learn how the data is stored in Performance Benchmark Dataset and how to interpret the differents table fields. This dataset is updated daily.

Tables

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

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

This table contains the total of ok and nok searches, quotes, bookings and cancellation requests and responses times for the buyer|seller and for TravelgateX. The buyers|sellers that aren’t connected are aggregated in “others” for the seller case and “OTHERS” for the buyers case.

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.
  • client_owner (STRING). Organization’s name of the client.
  • provider_owner (STRING). Organization’s name of the provider.
  • search_ok (NUMBER). Quantity of searches with searchable results.
  • search_ok_tgx (NUMBER). Quantity of searches with searchable results for TravelgateX.
  • search_nok(NUMBER). Quantity of searches with errors.
  • search_nok_tgx (NUMBER). Quantity of searches with errors for TravelgateX.
  • search_time (NUMBER). Total response time (in milliseconds) for all searches.
  • search_time_tgx (NUMBER). Total response time (in milliseconds) for all searches for TravelgateX.
  • quote_ok (NUMBER). Quantity of quotes with searchable results.
  • quote_ok_tgx (NUMBER). Quantity of quotes with searchable results for TravelgateX.
  • quote_nok (NUMBER). Quantity of quotes with errors.
  • quote_nok_tgx (NUMBER). Quantity of quotes with errors for TravelgateX.
  • quote_time (NUMBER). Total response time (in milliseconds) for all quotes.
  • quote_time_tgx (NUMBER). Total response time (in milliseconds) for all quotes for TravelgateX.
  • booking_ok (NUMBER). Quantity of correct bookings.
  • booking_ok_tgx (NUMBER). Quantity of correct bookings for TravelgateX.
  • booking_nok (NUMBER). Quantity of bookings with an error.
  • booking_nok_tgx (NUMBER). Quantity of bookings with an error for TravelgateX.
  • booking_time (NUMBER. Total response time (in milliseconds) for bookings.
  • booking_time_tgx (NUMBER. Total response time (in milliseconds) for bookings for TravelgateX.
  • cancel_ok (NUMBER). Quantity of correct cancellations.
  • cancel_ok_tgx (NUMBER). Quantity of correct cancellations for TravelgateX.
  • cancel_nok (NUMBER). Quantity of cancellations with an error.
  • cancel_nok_tgx (NUMBER). Quantity of cancellations with an error for TravelgateX.
  • cancel_time (NUMBER). Total response time (in milliseconds) for cancellations.
  • cancel_time_tgx (NUMBER). Total response time (in milliseconds) for cancellations for TravelgateX.

Preview

search_date provider_id client_id provider_owner client_owner search_ok search_ok_tgx search_nok search_nok_tgx search_time search_time_tgx quote_ok quote_ok_tgx quote_nok quote_nok_tgx quote_time quote_time_tgx booking_ok booking_ok_tgx booking_nok booking_nok_tgx booking_time booking_time_tgx cancel_ok cancel_ok_tgx cancel_nok cancel_nok_tgx cancel_time cancel_time_tgx
2019-05-31 00:00:00 UTC Provider 1 Client 1 Org Name 1 Org Name 1 2739 2739 5435 5435 15143760 15143760 19 19 0 0 54151 54151 2 2 1 1 31747 31747 0 0 0 0 0 0
2019-05-31 00:00:00 UTC Provider 2 Client 2 Org Name 2 Org Name 2 22631 1079375 4964 669086 2308465 256855044 1694 7708 0 80 157269 3539127 8 18 1 1 5441 15815 1 7 0 0 625 5925
2019-05-31 00:00:00 UTC Provider 3 Client 3 Org Name 3 Org Name 3 131116 192822 68270 106039 581904466 1168506957 6386 8220 1232 1511 32997644 41012522 93 193 1 1 3468668 7259187 32 40 0 0 334721 399424