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 |