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 | 
 | 

