Here are some definitions and descriptions of the different fields in the Ranking Reports.
| FIELD | DESCRIPTION |
|
WebsiteID |
4 characters website ID – internal to Skyscanner. FYI Expedia has 2 IDs on Skyscanner. |
|
UserCountryID |
ISO code of the source market of the user |
|
ExitAirportID |
IATA code of the destination airport |
|
ExitCityID |
Name of the destination city. NOTE – if there is name of the city, but no airport IATA code it likely indicates downtown |
|
ExitCountryID |
ISO code of destination country |
|
ctr_Location_market_rank |
How popular the destination is for a given source market (based on the aggregated number of redirects). E.g. we aggregate redirects to all our partners and split it by destination, e.g. in December we had 30,000 redirects from the UK to destination Orlando it would get ranking 1, 25,000 Malaga, ranking 2 etc. It is always based on the source market. Lower ranking number=higher volume of traffic. |
|
Redirects |
Expedia’s redirects for given combination. NOTE: Report is sorted in the descending number of redirects. |
|
Conversions |
Number of bookings based on the report |
|
Partner_rank |
How popular partner (Expedia) is in that location, based on the SoV in terms of redirects. E.g. Partner A had 15,000 redirects in Orlando, Expedia had 10,000 and Partner C had 5,000 – Expedia would receive ranking 2 in this case. Lower ranking number=better share of voice. It is a good proxy to how pric |