Performance Dataset
On this page you will learn how the data is stored in Performance Dataset.
Tables
Data is stored in multiple tables depending on the kind of information that wants to be queried and different level of aggregation:
- Daily (agregation stored every day)
- Monthly (aggregation stored the first day of the month)
This dataset is updated daily.
stats_(daily|monthly)_(buyer|seller)
This table contains transactional information (e.g. response status, response time) of requests between clients and providers.
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.
- speed (BOOLEAN). It indicates if the source of request was the client or Speed-X to load info in cache (0=Client, 1=Speed-X).
- search_ok (NUMBER). Quantity of searches with searchable results.
- search_nok_no_results (NUMBER). Quantity of searches without searchable results.
- search_nok_provider_error (NUMBER). Quantity of searches with generic error from provider.
- search_nok_bad_request (NUMBER). Quantity of searches with error due a wrong request.
- search_nok_integration_error (NUMBER). Quantity of searches with error due a failure in the connector.
- search_nok_communication_error (NUMBER). Quantity of searches with error due a timeout.
- search_nok_others (NUMBER). Quantity of searches with errors different to those above.
- search_time (NUMBER). Total response time (in milliseconds) for all searches.
- quote_ok (NUMBER). Quantity of quotes with searchable results.
- quote_nok_no_results (NUMBER). Quantity of quotes without searchable results.
- quote_nok_provider_error (NUMBER). Quantity of quotes with generic error from provider.
- quote_nok_bad_request (NUMBER). Quantity of quotes with error due to a wrong request.
- quote_nok_integration_error (NUMBER). Quantity of quotes with error due a failure in the connector.
- quote_nok_communication_error (NUMBER). Quantity of quotes with error due to a timeout.
- quote_nok_others (NUMBER). Quantity of quotes with errors different to those above.
- quote_time (NUMBER). Total response time (in milliseconds) for all quotes.
- booking_ok (NUMBER). Quantity of correct bookings.
- booking_nok (NUMBER). Quantity of bookings with an error.
- booking_time (NUMBER. Total response time (in milliseconds) for bookings.
- cancel_ok (NUMBER). Quantity of correct cancellations.
- cancel_nok (NUMBER). Quantity of cancellations with an error.
- cancel_time (NUMBER). Total response time (in milliseconds) for cancellations.
- other_ok (NUMBER). Quantity of transactions that cannot be included in one of the groups above and that didn’t receive an error.
- other_nok (NUMBER). Quantity of other transactions with an error.
- other_time (NUMBER). Total response time (in milliseconds) for other transactions.
Preview
search_date | client_id | provider_id | provider_owner | client_owner | speed | search_ok | search_nok_no_results | search_nok_provider_error | search_nok_bad_request | search_nok_integration_error | search_nok_communication_error | search_nok_others | search_time | quote_ok | quote_nok_no_results | quote_nok_provider_error | quote_nok_bad_request | quote_nok_integration_error | quote_nok_communication_error | quote_nok_others | quote_time | bookinging_ok | bookinging_nok | bookinging_time | cancel_ok | cancel_nok | cancel_time | other_ok | other_nok | other_time |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2018-03-28 12:00:00 UTC | client 1 | provider 1 | Org Name 1 | Org Name 1 | false | 372408 | 159272 | 571 | 30093 | 0 | 40 | 0 | 206883360 | 182 | 0 | 0 | 0 | 0 | 0 | 0 | 38166 | 3 | 0 | 31848 | 0 | 0 | 0 | 0 | 0 | 0 |
2018-03-28 12:00:00 UTC | client 1 | provider 2 | Org Name 2 | Org Name 2 | false | 50 | 10 | 0 | 0 | 0 | 0 | 0 | 48754 | 419 | 6 | 0 | 0 | 0 | 4 | 0 | 374301 | 5 | 0 | 41257 | 1 | 0 | 6080 | 172 | 0 | 5116 |
2018-03-28 12:00:00 UTC | client 2 | provider 1 | Org Name 3 | Org Name 3 | false | 548214 | 0 | 577 | 0 | 714 | 0 | 0 | 47457579 | 3719 | 32 | 0 | 0 | 0 | 0 | 0 | 327425 | 18 | 0 | 81757 | 6 | 4 | 31803 | 230 | 0 | 42614 |