Where is the data coming from?
All the results on our CargoAi solutions:
-✅ only keep weight between 50kg and 5 ton
-✅ only keep the rates that were in the most used currency for the origin_country
-✅exclude COMAT searches as the low rates will mess with our minimums
-✅exclude all express rates
-✅exclude route when there are results for less than 4 airlines to make impossible to identify data from other airline
Explanation of the data fields :
Fields | Description | Calculations |
airline_code | Airline Code |
|
req | Origin Airport - Destination Airport |
|
origin_country | Origin Country |
|
destination_country | Destination Country |
|
|
|
|
|
|
|
allairlines_avgbookedrate | Average booked rate for all airlines |
|
allairlines_bookedrate_2ndpercentile | 2nd percentile of all airlines avg bookedrate |
|
allairlines_bookedrate_50thpercentile | 50th percentile of all airlines avg bookedrate |
|
allairlines_minofferedrate_2ndpercentile | 2nd percentile of all airlines min offered rate |
|
allairlines_avgofferedrate_50thpercentile | 50th percentile of all airlines average offered rate |
|
nb_airlines_routenew |
|
|
oal_avgbookedrate | Average booked rate for all airlines except the selected one | Calculates average booked rate based on 2 metrics: -distinct number of booked rates |
airline_avgbookedrate | Average booked rate for the selected airline | see above |
ben1.oal_avgofferedrate, | Average offered rate for all airlines except the selected one | No calculations |
ben1.airline_avgofferedrate, | Average offered rate for the selected airline | see above |
ben1.oal_avgwinrate, | Average win rate for all airlines except the selected one | Average win rate: |
ben1.airline_avgwinrate, | Average win rate for the selected airline | see above |
ben1.oal_avgconvrate, | Average conversion rate for all airlines except the selected one | Conversion rate metric: |
ben1.airline_avgconvrate, | Average conversion rate for the selected airline | see above |
nb_airlines_route | Number of airlines with searches |
|
month | Month | Transformed month column from SRF into a real date to be used in filters by adding a fake day (01) (eg month 2023-10 will become 2023-10-01) |
source | Source |
|
rate_currency | Currency |
|
|
|
|
|
|
|
ben1.oal_avgshowuprate | Average win rate for the selected airline | Showup rate metric: |
ben1.airline_avgshowuprate | Average conversion rate for all airlines except the selected one | see above |
nb_airlines_bookable_route | Number of airlines where “has_instant_bookable” column from searches_aggr is true = true |
|
s.nb_searches_route | Number of search requests |
|
s.total_searched_weight_route | total searched weight |
|
s.avg_searched_weight_route | average searched weight |
|
s.total_unique_users_route | total unique users making searches |
|