Perfomance Dataset Reference

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 depending on the level of aggregation:

  • Daily (agregation stored every day)
  • Weekly (aggregation stored the first monday of every week)
  • Monthly (aggregation stored the first day of the month)

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

stats_(daily|weekly|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