Interpreting Data V5

Overview

This is the data dictionary where you can find out what each field means, and also which fields are filterable and will appear in CSV files.

Here is a guide of what each column means:

• Name of field in CSV file: These are the columns that will appear on the extracts generated. This consists of the selectable fields and more such as leg/segment details.
• Description: A brief of what that column indicates
• Example: An example of what the data for that column can be like

For Airport and Airline mappings, please refer to this page : Helpful Resources

Data Dictionary

Searches data set 

Column name	Description	Example	Configuration Group	Type	Mode
Guid	A unique record ID for debugging and referencing	7587FAD4-1E86-4F28-9D08-E11181BD059A	Default	string	REQUIRED
Timestamp	Event timestamp	2021-08-10 12:12	Default	datetime	REQUIRED
Market	The market (Skyscanner domain) a user has selected	DE	Default	string	REQUIRED
OriginAirport	The airport of the first leg's first segment. Empty in case of city search	LHR	Default	string	OPTIONAL
OriginCity	The city of the first leg's origin	LON	Default	string	REQUIRED
OriginCountry	The country of the first leg's origin	KR	Default	string	REQUIRED
DestinationAirport	The airport of the first leg's last segment. Empty in case of city search. Empty in case of MULTI_CITY trip kind	JFK	Default	string	OPTIONAL
DestinationCity	The city of the first leg's destination Empty in case of MULTI_CITY trip kind	NYC	Default	string	OPTIONAL
DestinationCountry	The country of the first leg's destination Empty in case of MULTI_CITY trip kind	FR	Default	string	OPTIONAL
Locale	User-locale settings of the user's browser	en-GB	Default	string	REQUIRED
CabinClass	Cabin class type, e.g. "ECONOMY", "BUSINESS", "PREMIUMECONOMY" in the search query	ECONOMY	Default	string	REQUIRED
Currency	Currency of the search query	GBP	Default	string	REQUIRED
Kind	The kind of flight searched for (one of "RETURN", "ONE_WAY" or "MULTI_CITY")	RETURN	Default	string	REQUIRED
DepartureDate	Date of first segment departure	2021-08-10	Default	date	REQUIRED
ReturnDate	Date of last segment departure  Empty in case of MULTI_CITY or ONE_WAY trip kind	2021-08-10	Default	date	OPTIONAL
TripLengthNights	Total length of stay (nights) Empty in case of MULTI_CITY or ONE_WAY trip kind	14	TripProperties	integer	OPTIONAL
TravelHorizonDays	Search horizon in days (a difference between departure date and search date)	60	TripProperties	integer	REQUIRED
TravelType	One of "DOMESTIC" or "INTERNATIONAL" Empty in case of MULTI_CITY trip kind	DOMESTIC	TripProperties	string	OPTIONAL
TravelDistanceKm	Travel distance (great-circle distance) in km between the OriginCity and DestinationCity Empty in case of MULTI_CITY trip kind	123	TripProperties	integer	OPTIONAL
PassengerAdult	Number of adult passengers	2	PassengerInfo	integer	REQUIRED
PassengerChild	Number of child passengers	0	PassengerInfo	integer	REQUIRED
PassengerInfant	Number of infant passengers	1	PassengerInfo	integer	REQUIRED
Device	A user platform (one of "DESKTOP", "MOBILE", "TABLET")	DESKTOP	DeviceInfo	string	OPTIONAL
BrowserName	Name of the browser used. If empty on mobile, it's a native app (Android or iOS); otherwise, mobile web.	Chrome	DeviceInfo	string	OPTIONAL
BrowserVersion	Version of the browser used	35.0.1	DeviceInfo	string	OPTIONAL
OSName	Name of the OS of the user device	Android	DeviceInfo	string	OPTIONAL
OSVersion	Version of the OS of the user device	11.0.3	DeviceInfo	string	OPTIONAL
UserCountryCode	User country code	US	userLocation	string	OPTIONAL
UserCountryName	User country name	United States	userLocation	string	OPTIONAL
UserRegionName	User region name	California	userLocation	string	OPTIONAL
UserCityName	User city name	London	userLocation	string	OPTIONAL
UserDistrictName	User district name	Camden	userLocation	string	OPTIONAL
UserLongitude	Longitude of the user location	0.233333007	userLocation	string	OPTIONAL
UserLatitude	Latitude of the user location	-96.74082947	userLocation	string	OPTIONAL
CorrelationIds	ID to correlate searches with redirects. IDs are double-colon (::) separated, with same-user, same-search condensed into a single row	7587FAD4-1E86-4F28-9D08-E11181BD059A	correlationIds	string	OPTIONAL
SessionId	ID to identify user sessions resulting in multiple events (searches and redirects)	NzU4N0ZBRDQtMUU4Ni00RjI4LTlEMDgtRTExMTgxQkQwNTlBc2Q=	correlationIds	string	OPTIONAL
LegsCount	Number of journeys in a trip (1 for one-way, 2 for roundtrip, 3+ for multicity)	4	FlightInfo	integer	REQUIRED
Leg_0..6_Date	Leg's Date of flight	2021-08-10	FlightInfo	date	REQUIRED

Redirects data set

Column name	Description	Example	Configuration Group	Type	Mode
Guid	A unique record ID for debugging and referencing	7587FAD4-1E86-4F28-9D08-E11181BD059A	Default	string	REQUIRED
Timestamp	Event timestamp	2021-08-10 12:12	Default	datetime	REQUIRED
Market	The market (Skyscanner domain) a user has selected	DE	Default	string	REQUIRED
OriginAirport	The airport of the first leg's first segment.	LHR	Default	string	REQUIRED
OriginCity	The city of the first leg's origin.	LON	Default	string	REQUIRED
OriginCountry	The country of the first leg's origin.	KR	Default	string	REQUIRED
DestinationAirport	The airport of the first leg's last segment. Empty in case of MULTI_CITY trip kind	JFK	Default	string	OPTIONAL
DestinationCity	The city of the first leg's destination. Empty in case of MULTI_CITY trip kind	NYC	Default	string	OPTIONAL
DestinationCountry	The country of the first leg's destination. Empty in case of MULTI_CITY trip kind	FR	Default	string	OPTIONAL
Locale	User-locale settings of the user's browser	en-GB	Default	string	REQUIRED
CabinClass	Cabin class type, e.g. "ECONOMY", "BUSINESS", "PREMIUMECONOMY" in the search query	ECONOMY	Default	string
Currency	Currency of the search query	GBP	Default	string	REQUIRED
Kind	The kind of flight searched for (one of "RETURN", "ONE_WAY" or "MULTI_CITY")	RETURN	Default	string	REQUIRED
DepartDate	Date of first segment departure	2021-08-10	Default	date	REQUIRED
ReturnDate	Date of the last segment departure  Empty in case of MULTI_CITY or ONE_WAY trip kind	2021-08-10	Default	date	OPTIONAL
TripLengthNights	Total length of travel (nights) 0 in case of ONE_WAY	14	TripProperties	integer	REQUIRED
TravelHorizonDays	Redirect horizon in days (a difference between departure date and redirect date)	60	TripProperties	integer	REQUIRED
TravelType	One of "DOMESTIC" or "INTERNATIONAL" Empty in case of MULTI_CITY trip kind	DOMESTIC	TripProperties	string	OPTIONAL
TravelDistanceKm	Travel distance (great-circle distance) in km between the OriginCity and DestinationCity Empty in case of MULTI_CITY trip kind	123	TripProperties	integer	OPTIONAL
PassengerAdult	Number of adult passengers	2	PassengerInfo	integer	REQUIRED
PassengerChild	Number of child passengers	0	PassengerInfo	integer	REQUIRED
PassengerInfant	Number of infant passengers	1	PassengerInfo	integer	REQUIRED
Device	A user device (one of "DESKTOP", "MOBILE", "TABLET")	DESKTOP	DeviceInfo	string	OPTIONAL
BrowserName	Name of the browser used. If empty on mobile, it's a native app (Android or iOS); otherwise, mobile web.	Chrome	DeviceInfo	string	OPTIONAL
BrowserVersion	Version of the browser used	35.0.1	DeviceInfo	string	OPTIONAL
OSName	Name of the OS of the user device	Android	DeviceInfo	string	OPTIONAL
OSVersion	Version of the OS of the user device	11.0.3	DeviceInfo	string	OPTIONAL
ProviderType	One of "AIRLINE", "TRAVEL_AGENT"	AIRLINE	OfferInfoBasic	string	REQUIRED
RedirectType	One of "ADS", "ORGANIC" for own brand(s) clicks.  Empty in case of competitor redirects  This is only applicable to direct  suppliers on Skyscanner	ORGANIC	OfferInfoBasic	string	OPTIONAL
ItineraryID	Skyscanner's unique Itinerary ID	12461-11389-2109060550-2109060705--31734	OfferInfoDetailed	string	OPTIONAL
ItineraryPosition	The itinerary position in the search results is ranked numerically, with '0' representing the highest possible position.	3	OfferInfoDetailed	integer	OPTIONAL
ItinerarySortType	One of "CHEAPEST", "BEST", "FASTEST"	CHEAPEST	OfferInfoDetailed	string	OPTIONAL
ProviderRank	The provider rank on the selection screen indicates the order of offers, with '0' representing the top-ranked option, which features the lowest price available	2	OfferInfoDetailed	integer	OPTIONAL
SelfTransfer	Combinations of flights, where travellers may need to check in separately for each connecting flight. One of TRUE or FALSE	TRUE	FlightInfoDetailed	string	REQUIRED
ProviderIntel	Your brand(s) name as a provider (if applicable). Indicates if a user  redirected to your brand or not.  One of <YourBrand1.com>,...,<YourBrandN.com>" Empty in case of competitor redirects  This is only applicable to direct  suppliers on Skyscanner	YourBrand.com	OfferInfoDetailed	string	OPTIONAL
PriceUserCurrency	Total basket value in user currency	123.3	PriceInfo	float	REQUIRED
PriceUserCurrencyPerPax	Average basket value per passenger in user currency	50.3	PriceInfo	float	REQUIRED
PriceCustomCurrency	Total basket value in subscription currency	123.3	PriceInfo	float	REQUIRED
PriceCustomCurrencyPerPax	Average basket value per passenger in subscription currency	50.3	PriceInfo	float	REQUIRED
SearchLowestPriceRatio	Ratio between a redirect price and the lowest price for the whole search (typically ≥ 1)	3.2	PriceInfo	float	REQUIRED
ItineraryLowestPriceRatio	Ratio between a redirect price and the lowest price for selected itinerary (typically ≥ 1)	1.2	PriceInfo	float	REQUIRED
PartnerQuouteIds	Custom partner quote ID  This is only applicable to travel agents on Skyscanner	123457890asdf	PartnerquouteIds	string	OPTIONAL
UserCountryCode	User country code	US	UserLocation	string	OPTIONAL
UserCountryName	User country name	United States	UserLocation	string	OPTIONAL
UserRegionName	User region name	California	UserLocation	string	OPTIONAL
UserCityName	User city name	London	UserLocation	string	OPTIONAL
UserDistrictName	User district name	Camden	UserLocation	string	OPTIONAL
UserLongitude	Longitude of the user location	0.233333007	UserLocation	string	OPTIONAL
UserLatitude	Latitude of the user location	-96.74082947	UserLocation	string	OPTIONAL
CorrelationIds	ID to correlate searches with redirects. IDs are double-colon (::) separated, with same-user, same-search condensed into a single row	7587FAD4-1E86-4F28-9D08-E11181BD059A	CorrelationIds	string	OPTIONAL
SessionId	ID to identify user sessions resulting in multiple events (searches and redirects)	NzU4N0ZBRDQtMUU4Ni00RjI4LTlEMDgtRTExMTgxQkQwNTlBc2Q=	CorrelationIds	string	OPTIONAL
LegsCount	Number of journeys in a trip (1 for one-way, 2 for roundtrip, 3+ for multicity)	2	FlightInfoBasic	integer	REQUIRED
Leg_0..6_Segment_0..15_OriginIATA	Segment's Origin IATA code	LHR	FlightInfoBasic	string	REQUIRED
Leg_0..6_Segment_0..15_OriginName	Segment's Origin location name	Naples Airport	FlightInfoBasic	string	REQUIRED
Leg_0..6_Segment_0..15_DestinationIATA	Segment's Destination IATA code	MAD	FlightInfoBasic	string	REQUIRED
Leg_0..6_Segment_0..15_DestinationName	Segment's Destination location name	Madrid airport	FlightInfoBasic	string	REQUIRED
Leg_0..6_StopsCount	A number of stops in a leg (0, 1 or more)	1	FlightInfoBasic	integer	REQUIRED
Leg_0..6_Segment_0..15_DepartureTimestamp	Segment's timestamp of departure May not be guaranteed for some segments	2021-08-10 12:12	FlightInfoDetailed	datetime	OPTIONAL
Leg_0..6_Segment_0..15_ArrivalTimestamp	Segment's timestamp of arrival May not be guaranteed for some segments	2021-08-10 12:12	FlightInfoDetailed	datetime	OPTIONAL
Leg_0..6_Segment_0..15_MarketingCarrierIATA	Segment's Marketing carrier code	BA	FlightInfoDetailed	string	OPTIONAL
Leg_0..6_Segment_0..15_OperatingCarrierIATA	Segment's Operating carrier code	IB	FlightInfoDetailed	string	OPTIONAL
Leg_0..6_Segment_0..15_FlightNumber	Segment's Marketing carrier's flight number	123	FlightInfoDetailed	integer	REQUIRED
Leg_0..6_Segment_0..15_DurationMin	Segment's duration (in minutes)	233	FlightInfoDetailed	integer	REQUIRED
Leg_0..6_Segment_0..15_TravelDistanceKm	Travel distance (great-circle distance) in km between the OriginIATA and DestinationIATA	123	FlightInfoDetailed	integer	REQUIRED
Leg_0..6_DurationMin	Total leg journey duration (with flights and stopovers) in minutes	740	FlightInfoDetailed	integer	REQUIRED