lh-20260728-172312

Scanned

39200
Offers
10
Routes
1
Errors
production
Env
roundtrip
Trip
LH
Carrier

Commission by source

Per source: how much of it carries commission, and whether that is one flat amount or a spread of values

sourceoffer_countwith_commissionpct_with_commissiondistinct_valuesmin_commissionmedian_commissionmax_commissionroutes_paying
amadeus 19600 0 0 0 β€” β€” 0 0
ndc_direct 19600 0 0 0 β€” β€” 0 0

download this table as CSV

Commission amounts seen

The commission amounts actually seen, commonest first

No offer in this run carries commission.

Commission coverage by routeroute

How much of each route carries commission β€” routes where only some offers pay are listed first

origindestinationsourceoffer_countwith_commissionpct_with_commissionmin_commissionmax_commission
EWR FRA amadeus 2000 0 0 β€” 0
EWR FRA ndc_direct 2000 0 0 β€” 0
IAD FRA amadeus 2000 0 0 β€” 0
IAD FRA ndc_direct 2000 0 0 β€” 0
IAD MUC amadeus 2000 0 0 β€” 0
IAD MUC ndc_direct 2000 0 0 β€” 0
JFK FRA amadeus 2000 0 0 β€” 0
JFK FRA ndc_direct 2000 0 0 β€” 0
JFK MUC amadeus 2000 0 0 β€” 0
JFK MUC ndc_direct 2000 0 0 β€” 0
LAX FRA amadeus 2000 0 0 β€” 0
LAX FRA ndc_direct 2000 0 0 β€” 0
ORD FRA amadeus 2000 0 0 β€” 0
ORD FRA ndc_direct 2000 0 0 β€” 0
ORD MUC amadeus 2000 0 0 β€” 0
ORD MUC ndc_direct 2000 0 0 β€” 0
SFO FRA amadeus 2000 0 0 β€” 0
SFO FRA ndc_direct 2000 0 0 β€” 0
SFO MUC amadeus 1600 0 0 β€” 0
SFO MUC ndc_direct 1600 0 0 β€” 0

download this table as CSV

Bookable itineraries carrying commissionitinerary

Bookable itineraries that carry commission, one row each β€” the list to pick a test case from

No bookable offer in this run carries commission.

Fare vs commission, where both sources quoted

For itineraries both sources quoted: whether the cheaper net price comes from the fare or from the commission paid back β€” net price is the fare minus commission. The last column counts the wins that would reverse if commission were removed

driveritinerariesavg_fare_gapavg_commission_gapavg_net_gapflips_without_commission
ndc wins on fare 1455 113.53 0 113.53 0
amadeus wins on fare 126 -63.78 0 -63.78 0

download this table as CSV

β–Ά Offer summary by source 3 Total offers by source and fare type
sourcefare_typeoffer_countmin_netavg_netmedian_netroutes
amadeus published 19600 1058.73 1351.49 1328.33 10
ndc_direct nego 9110 1133.63 1787.39 1626.57 10
ndc_direct published 10490 802.23 1382.94 1340.13 10

download this table as CSV

Download raw data (parquet)