Insights-X changelog

Easily accessible log of notable changes to Insights-X

2020-03-11

  • Updated RANK definiton in benchmark tables. All destinations/suppliers/clients with the same volume for the same metric receive the same rank value. The next destinations/suppliers/clients receives a rank value which increments by the number of peers with the previous rank value, instead of increment by 1.

2019-11-28

  • Added the fields client_owner and provider_owner in all the tables of the InsightsX Dataset.
  • Changed fields availability_index, booking_index and revenue_index by availability_best_compset, booking_best_compset and revenue_best_compset in benchmark tables.

2019-10-04

  • Added new table: daily_portfolio_stats_(buyer|seller)

2019-09-03

  • Added new table: benchmark_market_city_bw_(daily|weekly|monthly)_(buyer|seller). This one replaces insights_agg_(daily|weekly|monthly)_destination_tgx
  • Schema modified for tables: insights_(daily|weekly|monthly)_destination_(buyer|seller), insights_agg_(daily|weekly|monthly)_destination_(buyer|seller). Now, country field is outside the record.

2019-08-27

2019-06-19

  • Added new tables: insights_(daily|weekly|monthly)_destination_(buyer|seller), insights_agg_(daily|weekly|monthly)_destination_(buyer|seller) and insights_agg_(daily|weekly|monthly)_destination_tgx

2019-06-05

  • Added new fields in portfolio: zone_1, zone_2, city, username. Added new metrics in portfolio: search_ok,search_nok, quote_ok, quote_nok, booking_ok, booking_nok, cancel_ok, cancel_nok, revenue_net and revenue_unknown.
  • Added new fields in effective bookings: username, commision, adults, childen, infants.
  • Benchmark is available now for Performance. Added new table in benchmark: performance_daily_(buyer|seller).

2019-05-27

  • Added new fields in benchmark datasets: TravelgateX total availability, total bookings and total revenue.

2019-04-11

  • Benchmark table daily_benchmarking_seller replaced by new ones benchmark tables
  • Added buyer field in benchmark seller tables. Added seller field in benchmark buyer tables.

2019-03-27

  • New table daily_benchmarking_seller

2019-02-21

  • New table effective_bookings_(buyer|seller)
  • daily_insights table renamed as insights_daily_(buyer|seller)
  • daily_insights_(client|provider) table renamed as insights_daily_(buyer|seller)

2019-02-07