cm-20260729-180014

Scanned

324
Offers
1
Routes
0
Errors
production
Env
roundtrip
Trip
CM
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
ndc_direct 324 108 33.3 6 26.76 30.16 33.56 1

download this table as CSV

Commission amounts seen

The commission amounts actually seen, commonest first

sourcecommissionoffer_countroutespct_of_source
ndc_direct 32.96 24 1 7.4
ndc_direct 32.36 24 1 7.4
ndc_direct 27.36 24 1 7.4
ndc_direct 26.76 24 1 7.4
ndc_direct 33.56 6 1 1.9
ndc_direct 27.96 6 1 1.9

download this table as CSV

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
LAX PTY ndc_direct 324 108 33 26.76 33.56

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

origindestinationdeparture_datereturn_dateflight_codessourcecabincommissioncheapest_netoffer_count
LAX PTY 2026-08-26 2026-09-02 CM362 / CM472 ndc_direct economy 33.56 800.67 2
LAX PTY 2026-08-30 2026-09-06 CM362 / CM472 ndc_direct economy 33.56 800.67 2
LAX PTY 2026-09-03 2026-09-10 CM362 / CM472 ndc_direct economy 33.56 800.67 2
LAX PTY 2026-09-06 2026-09-13 CM362 / CM472 ndc_direct economy 33.56 800.67 2
LAX PTY 2026-09-10 2026-09-17 CM362 / CM472 ndc_direct economy 33.56 800.67 2
LAX PTY 2026-09-14 2026-09-21 CM362 / CM472 ndc_direct economy 33.56 800.67 2
LAX PTY 2026-08-26 2026-09-02 CM473 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-08-26 2026-09-02 CM362 / CM401 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-08-26 2026-09-02 CM306 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-08-26 2026-09-02 CM362 / CM360 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-08-30 2026-09-06 CM362 / CM360 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-08-30 2026-09-06 CM306 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-08-30 2026-09-06 CM362 / CM302 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-08-30 2026-09-06 CM473 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-03 2026-09-10 CM473 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-03 2026-09-10 CM362 / CM360 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-03 2026-09-10 CM362 / CM302 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-03 2026-09-10 CM402 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-06 2026-09-13 CM306 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-06 2026-09-13 CM473 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-06 2026-09-13 CM362 / CM360 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-06 2026-09-13 CM362 / CM302 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-10 2026-09-17 CM473 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-10 2026-09-17 CM362 / CM302 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-10 2026-09-17 CM362 / CM360 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-10 2026-09-17 CM402 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-14 2026-09-21 CM473 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-14 2026-09-21 CM306 / CM472 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-14 2026-09-21 CM362 / CM401 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-09-14 2026-09-21 CM362 / CM360 ndc_direct economy 32.96 786.27 2
LAX PTY 2026-08-26 2026-09-02 CM473 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-08-26 2026-09-02 CM473 / CM401 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-08-26 2026-09-02 CM306 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-08-26 2026-09-02 CM306 / CM401 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-08-30 2026-09-06 CM473 / CM302 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-08-30 2026-09-06 CM473 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-08-30 2026-09-06 CM306 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-08-30 2026-09-06 CM306 / CM302 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-03 2026-09-10 CM473 / CM302 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-03 2026-09-10 CM402 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-03 2026-09-10 CM402 / CM302 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-03 2026-09-10 CM473 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-06 2026-09-13 CM306 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-06 2026-09-13 CM306 / CM302 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-06 2026-09-13 CM473 / CM302 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-06 2026-09-13 CM473 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-10 2026-09-17 CM473 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-10 2026-09-17 CM402 / CM302 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-10 2026-09-17 CM402 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-10 2026-09-17 CM473 / CM302 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-14 2026-09-21 CM473 / CM401 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-14 2026-09-21 CM473 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-14 2026-09-21 CM306 / CM360 ndc_direct economy 32.36 771.87 2
LAX PTY 2026-09-14 2026-09-21 CM306 / CM401 ndc_direct economy 32.36 771.87 2

download this table as CSV

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

No itinerary was quoted by both sources.
โ–ถ Offer summary by source 2 Total offers by source and fare type
sourcefare_typeoffer_countmin_netavg_netmedian_netroutes
ndc_direct nego 108 1178.63 1188.63 1193.63 1
ndc_direct published 216 754.63 841.65 847.65 1

download this table as CSV

Download raw data (parquet)