Dataset Reference

On this page you will learn how the data is stored in Datasets.

Tables

Data is stored in multiple tables depending on the kind of info that wants to be queried. Descriptions of each table and their correspondent fields are found below:

daily_insights

This table contains info from searches, quotes and bookings aggregated by day.

fields

  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • cache (BOOLEAN). It indicates if the source of request was the client or Speed-X on behalf of the client (0=Client, 1=Speed-X).
  • search_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • check_in (TIMESTAMP). Check in date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • nights (NUMBER). Length of stay.
  • nationality (STRING). Pax nationality (ISO Alpha-2 code). It can be null when clients don’t send this field.
  • num_rooms (NUMBER). Quantity of rooms.
  • adults (NUMBER). Quantity of paxes older than 12 years (12 is not included).
  • children (NUMBER). Quantity of paxes between 2 and 12 (both included).
  • infants (NUMBER). Quantity of paxes younger than 2 years (2 is not included).
  • search_ok (NUMBER). Quantity of searches that returned any available hotel for above key (search_date, check_in…).
  • search_nok (NUMBER). Quantity of searches that didn’t return any available hotel for above key.
  • quote_ok (NUMBER). Quantity of quotes that returned a correct result for above key.
  • quote_nok (NUMBER). Quantity of quotes that returned a wrong result for above key.
  • booking_ok (NUMBER). Quantity of confirmed bookings for above key.
  • booking_nok (NUMBER). Quantity of failed bookings for above key.
  • amount (NUMBER). Total amount of confirmed bookings for above key.
  • hotels (STRUCT). Repeated field that contains info about hotels for above key.
    • code (STRING). Hotel unique ID.
    • search_ok (NUMBER). Quantity of searches with available options for above key and hotel.
    • search_nok (NUMBER). Quantity of searches without available options for above key and hotel.
    • quote_ok (NUMBER). Quantity of quotes that returned a correct result for above key and hotel.
    • quote_nok (NUMBER). Quantity of quotes that returned a wrong result for above key and hotel.
    • booking_ok (NUMBER). Quantity of confirmed bookings for above key and hotel.
    • booking_nok (NUMBER). Quantity of failed bookings for above key and hotel.
    • amount (NUMBER). Total amount of confirmed bookings for above key and hotel.

Preview

client_id provider_id cache search_date check_in nights nationality num_rooms adults children infants search_ok search_nok quote_ok quote_nok booking_ok booking_nok amount hotels.code hotels.search_ok hotels.search_nok hotels.quote_ok hotels.quote_nok hotels.booking_ok hotels.booking_nok hotels.amount
client A provider X false 2019-01-13 00:00:00 UTC 2019-01-19 00:00:00 UTC 4 SE 1 1 0 0 13 11 null null null null null 641443 13 0 null null null null null
551568 0 11 null null null null null
client B provider Y false 2019-01-13 00:00:00 UTC 2019-01-19 00:00:00 UTC 2 CN 1 2 0 0 6 1 3 0 1 0 398.84 299 0 1 null null null null null
927 5 0 3 0 1 0 398.84
203 1 0 null null null null null

daily_insights_client / daily_insights_provider

This table contains info similar to _dailyinsights but with a bigger aggregation. The fields check_in, adults, children and infants have disapeared.

fields

  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • cache (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_date (TIMESTAMP). Search date in UTC (format: YYYY-MM-DD hh:mm:ss).
  • booking_window (NUMBER). It is an enumeration to describe how far away is the check-in date.
    • 1 = Last second (0-1 day).
    • 2 = Last minute (2-3 days).
    • 3 = About 1 week (4-7 days).
    • 4 = About 2 weeks (8-14 days).
    • 5 = About 1 month (15-30 days)
    • 6 = About 2 months (31-60 days).
    • 7 = About 3 months (61-90 days).
    • 8 = More than 3 months (90+ days).
  • nights (NUMBER). Length of stay.
  • nationality (STRING). Pax nationality (ISO Alpha-2 code). It can be null when clients don’t send this field.
  • num_rooms (NUMBER). Quantity of rooms.
  • pax_type (NUMBER). It is an enumeration to describe a combination of paxes (adults + children + infants).
    • 1 = Solo (Adults = 1, children = 0 and infants = 0).
    • 2 = Couple (Adults = 2, children = 0 and infants = 0).
    • 3 = Family (Adults = 2, children + infants > 0).
    • 4 = Group (Adults > 2).
    • 5 = Other.
  • search_ok (NUMBER). Quantity of searches that returned any available hotel for above key (search_date, check_in…).
  • search_nok (NUMBER). Quantity of searches that didn’t return any available hotels for above key.
  • quote_ok (NUMBER). Quantity of quotes that returned a correct result for above key.
  • quote_nok (NUMBER). Quantity of quotes that returned a wrong result for above key.
  • booking_ok (NUMBER). Quantity of confirmed bookings for above key.
  • booking_nok (NUMBER). Quantity of failed bookings for above key.
  • amount (NUMBER). Total amount of confirmed bookings for above key.
  • hotels (STRUCT). Repeated field that contains info about hotels for above key.
    • code (STRING). Hotel unique ID.
    • search_ok (NUMBER). Quantity of searches with available options for above key and hotel.
    • search_nok (NUMBER). Quantity of searches without available options for above key and hotel.
    • quote_ok (NUMBER). Quantity of quotes that returned a correct result for above key and hotel.
    • quote_nok (NUMBER). Quantity of quotes that returned a wrong result for above key and hotel.
    • booking_ok (NUMBER). Quantity of confirmed bookings for above key and hotel.
    • booking_nok (NUMBER). Quantity of failed bookings for above key and hotel.
    • amount (NUMBER). Total amount of confirmed bookings for above key and hotel.

Preview

client_id provider_id cache search_date booking_window nights nationality num_rooms pax_type search_ok search_nok quote_ok quote_nok booking_ok booking_nok amount hotels.code hotels.search_ok hotels.search_nok hotels.quote_ok hotels.quote_nok hotels.booking_ok hotels.booking_nok hotels.amount
client A provider X false 2019-01-13 00:00:00 UTC 3 4 SE 1 1 13 11 null null null null null 641443 13 0 null null null null null
551568 0 11 null null null
client B provider Y false 2019-01-13 00:00:00 UTC 3 2 CN 1 2 6 1 3 0 1 0 398.84 299 0 1 null null null null null
927 5 0 3 0 1
203 1 0 null null null

daily_portfolio_seller

This table is used to know which hotels over supplier’s portfolio are being queried by the clients. This can be helpful to know which percentage over portfolio is mapped by the client.

fields

  • client_id (STRING). Client unique ID.
  • provider_id (STRING). Provider unique ID.
  • hotel (STRING). Hotel unique ID.
  • hotel_name_portfolio (STRING). Hotel name.
  • hotel_country_portfolio (STRING). Hotel Country Code (ISO Alpha-2 code)
  • status. It is an enumeration to describe the status of the hotel.
    • 0 = Hotel code queried but it doesn’t appear in provider’s portfolio. It can be due to a wrong mapping in client’s system.
    • 1 = Hotel code not queried but it appears in provider’s portfolio. It can be due to a mismapping in the client’s system.
    • 2 = Hotel code queried and it appears in provider’s portfolio.

Preview

client_id provider_id hotel hotel_name_portfolio hotel_country_portfolio status
client A provider X 1 hotel_1 ES 1
client A provider X 2 hotel_2 IT 2
client A provider X V null null 0
client B provider Y 1 hotel_1 FR 1

daily_stats

This table contains transactional info (response status, response time…) of requests between clients and providers.

fields

  • st_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
  • 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).
  • avail_ok (NUMBER). Quantity of searches with available results.
  • avail_nok_results (NUMBER). Quantity of searches without available results.
  • avail_nok_provider (NUMBER). Quantity of searches with generic error from provider.
  • avail_nok_bad_request (NUMBER). Quantity of searches with error due a wrong request.
  • avail_nok_integration (NUMBER). Quantity of searches with error due a failure in the connector.
  • avail_nok_communication (NUMBER). Quantity of searches with error due a timeout.
  • avail_nok_others (NUMBER). Quantity of searches with errors different to those above.
  • avail_time (NUMBER). Total response time (in milliseconds) for all searches.
  • quote_ok (NUMBER). Quantity of quotes with available results.
  • quote_nok_results (NUMBER). Quantity of quotes without available results.
  • quote_nok_provider (NUMBER). Quantity of quotes with generic error from provider.
  • quote_nok_bad_request. Quantity of quotes with error due to a wrong request.
  • quote_nok_integration. Quantity of quotes with error due a failure in the connector.
  • quote_nok_communication (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.
  • book_ok (NUMBER). Quantity of correct bookings.
  • book_nok (NUMBER). Quantity of bookings with an error.
  • book_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 above groups and that didn’t get an error.
  • other_nok (NUMBER). Quantity of other transactions with an error.
  • other_time (NUMBER). Total response time (in milliseconds) for other transactions.

Preview

st_date client_id provider_id speed avail_ok avail_nok_results avail_nok_provider avail_nok_bad_request avail_nok_integration avail_nok_communication avail_nok_others avail_time quote_ok quote_nok_results quote_nok_provider quote_nok_bad_request quote_nok_integration quote_nok_communication quote_nok_others quote_time book_ok book_nok book_time cancel_ok cancel_nok cancel_time other_ok other_nok other_time
2018-03-28 12:00:00 UTC client 1 provider 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 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 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

Comments