FAQ - Benchmark Dashboard
R
Written by Remi Giudicelli
Updated over a week ago

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:
-average of booked rates

-distinct number of booked rates

average booked rate:
average booked rate * number of booked rates DIVIDED by the total 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:
distinct number of booked requests DIVIDED by the distinct number of search requests where booking was possible for an airline.

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:
number of distinct booked requests DIVIDED by number of distinct search requests

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:

number of requests with rates DIVIDED by total number of requests.

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

Did this answer your question?