tk-20260728-160842
Scanned
Commission by source
Per source: how much of it carries commission, and whether that is one flat amount or a spread of values
| source | offer_count | with_commission | pct_with_commission | distinct_values | min_commission | median_commission | max_commission | routes_paying |
|---|---|---|---|---|---|---|---|---|
| amadeus | 91 | 0 | 0 | 0 | β | β | 0 | 0 |
| ndc_direct | 63 | 63 | 100 | 32 | 19.25 | 32.1 | 88.56 | 1 |
Commission amounts seen
The commission amounts actually seen, commonest first
| source | commission | offer_count | routes | pct_of_source |
|---|---|---|---|---|
| ndc_direct | 27 | 7 | 1 | 11.1 |
| ndc_direct | 19.6 | 7 | 1 | 11.1 |
| ndc_direct | 88.26 | 4 | 1 | 6.3 |
| ndc_direct | 30.6 | 4 | 1 | 6.3 |
| ndc_direct | 52.2 | 3 | 1 | 4.8 |
| ndc_direct | 25.8 | 3 | 1 | 4.8 |
| ndc_direct | 19.25 | 3 | 1 | 4.8 |
| ndc_direct | 62.34 | 2 | 1 | 3.2 |
| ndc_direct | 46.8 | 2 | 1 | 3.2 |
| ndc_direct | 46.56 | 2 | 1 | 3.2 |
| ndc_direct | 34.5 | 2 | 1 | 3.2 |
| ndc_direct | 33.3 | 2 | 1 | 3.2 |
| ndc_direct | 31.8 | 2 | 1 | 3.2 |
| ndc_direct | 25.5 | 2 | 1 | 3.2 |
| ndc_direct | 88.56 | 1 | 1 | 1.6 |
| ndc_direct | 83.04 | 1 | 1 | 1.6 |
| ndc_direct | 64.74 | 1 | 1 | 1.6 |
| ndc_direct | 61.14 | 1 | 1 | 1.6 |
| ndc_direct | 57.24 | 1 | 1 | 1.6 |
| ndc_direct | 55.86 | 1 | 1 | 1.6 |
| ndc_direct | 53.46 | 1 | 1 | 1.6 |
| ndc_direct | 52.8 | 1 | 1 | 1.6 |
| ndc_direct | 50.76 | 1 | 1 | 1.6 |
| ndc_direct | 50.46 | 1 | 1 | 1.6 |
| ndc_direct | 44.16 | 1 | 1 | 1.6 |
| ndc_direct | 42.66 | 1 | 1 | 1.6 |
| ndc_direct | 38.76 | 1 | 1 | 1.6 |
| ndc_direct | 33.32 | 1 | 1 | 1.6 |
| ndc_direct | 32.1 | 1 | 1 | 1.6 |
| ndc_direct | 29.4 | 1 | 1 | 1.6 |
| ndc_direct | 26.7 | 1 | 1 | 1.6 |
| ndc_direct | 25.55 | 1 | 1 | 1.6 |
Commission coverage by routeroute
How much of each route carries commission β routes where only some offers pay are listed first
| origin | destination | source | offer_count | with_commission | pct_with_commission | min_commission | max_commission |
|---|---|---|---|---|---|---|---|
| SSH | SEA | ndc_direct | 63 | 63 | 100 | 19.25 | 88.56 |
| SSH | SEA | amadeus | 91 | 0 | 0 | β | 0 |
Bookable itineraries carrying commissionitinerary
Bookable itineraries that carry commission, one row each β the list to pick a test case from
| origin | destination | departure_date | return_date | flight_codes | source | cabin | commission | cheapest_net | offer_count |
|---|---|---|---|---|---|---|---|---|---|
| SSH | SEA | 2026-10-18 | β | TK699-TK79-TK9587 | ndc_direct | economy | 88.56 | 1775.46 | 1 |
| SSH | SEA | 2026-10-14 | β | TK701-TK79-TK9587 | ndc_direct | economy | 88.26 | 1770.76 | 1 |
| SSH | SEA | 2026-10-14 | β | TK701-TK289-TK9587 | ndc_direct | economy | 88.26 | 1770.76 | 1 |
| SSH | SEA | 2026-10-21 | β | TK701-TK289-TK9587 | ndc_direct | economy | 88.26 | 1770.76 | 1 |
| SSH | SEA | 2026-10-21 | β | TK701-TK79-TK9587 | ndc_direct | economy | 88.26 | 1770.76 | 1 |
| SSH | SEA | 2026-10-18 | β | TK699-TK5-UA2211 | ndc_direct | economy | 83.04 | 1648.98 | 1 |
| SSH | SEA | 2026-10-24 | β | TK699-TK5-TK8609 | ndc_direct | economy | 64.74 | 1305.88 | 2 |
| SSH | SEA | 2026-10-04 | β | TK699-TK5-UA2211 | ndc_direct | economy | 62.34 | 1324.68 | 1 |
| SSH | SEA | 2026-10-24 | β | TK699-TK5-UA2211 | ndc_direct | economy | 62.34 | 1324.68 | 1 |
| SSH | SEA | 2026-10-31 | β | TK699-TK79-UA5579 | ndc_direct | economy | 57.24 | 1284.78 | 1 |
| SSH | SEA | 2026-10-11 | β | TK699-TK5-TK8609 | ndc_direct | economy | 55.86 | 1223.16 | 1 |
| SSH | SEA | 2026-10-11 | β | TK699-TK185-TK8609 | ndc_direct | economy | 53.46 | 1185.56 | 1 |
| SSH | SEA | 2026-10-11 | β | TK699-TK5-UA2211 | ndc_direct | economy | 52.8 | 1175.22 | 1 |
| SSH | SEA | 2026-10-18 | β | TK699-TK79-UA1007 | ndc_direct | economy | 52.2 | 1205.82 | 1 |
| SSH | SEA | 2026-10-18 | β | TK699-TK79-UA5579 | ndc_direct | economy | 52.2 | 1205.82 | 1 |
| SSH | SEA | 2026-10-18 | β | TK699-TK79-UA1097 | ndc_direct | economy | 52.2 | 1205.82 | 1 |
| SSH | SEA | 2026-10-04 | β | TK699-TK79-TK9587 | ndc_direct | economy | 50.76 | 1183.26 | 1 |
| SSH | SEA | 2026-10-08 | β | TK701-TK79-TK9587 | ndc_direct | economy | 50.46 | 1178.56 | 1 |
| SSH | SEA | 2026-10-04 | β | TK699-TK79-UA1097 | ndc_direct | economy | 46.8 | 1121.22 | 1 |
| SSH | SEA | 2026-10-11 | β | TK699-TK79-UA1097 | ndc_direct | economy | 46.8 | 1121.22 | 1 |
| SSH | SEA | 2026-10-31 | β | TK699-TK185-TK8609 | ndc_direct | economy | 46.56 | 1077.46 | 1 |
| SSH | SEA | 2026-10-31 | β | TK701-TK185-TK8609 | ndc_direct | economy | 46.56 | 1077.46 | 1 |
| SSH | SEA | 2026-10-04 | β | TK699-TK5-TK8609 | ndc_direct | economy | 44.16 | 1039.86 | 1 |
| SSH | SEA | 2026-10-01 | β | TK701-TK185-TK8609 | ndc_direct | economy | 42.66 | 1016.36 | 1 |
| SSH | SEA | 2026-10-01 | β | TK701-TK79-TK9587 | ndc_direct | economy | 38.76 | 995.26 | 1 |
| SSH | SEA | 2026-10-24 | β | TK699-TK185-TK8609 | ndc_direct | economy | 34.5 | 888.52 | 1 |
| SSH | SEA | 2026-10-24 | β | TK701-TK185-TK8609 | ndc_direct | economy | 34.5 | 888.52 | 1 |
| SSH | SEA | 2026-10-01 | β | TK701-TK203 | ndc_direct | economy | 33.32 | 820.6 | 1 |
| SSH | SEA | 2026-10-18 | β | TK699-TK185-TK8609 | ndc_direct | economy | 33.3 | 869.72 | 1 |
| SSH | SEA | 2026-10-18 | β | TK699-TK5-TK8609 | ndc_direct | economy | 33.3 | 869.72 | 1 |
| SSH | SEA | 2026-10-04 | β | TK699-TK185-TK8609 | ndc_direct | economy | 32.1 | 850.92 | 1 |
| SSH | SEA | 2026-10-28 | β | TK699-TK185-TK8609 | ndc_direct | economy | 31.8 | 846.22 | 1 |
| SSH | SEA | 2026-10-28 | β | TK699-TK5-TK8609 | ndc_direct | economy | 31.8 | 859.93 | 1 |
| SSH | SEA | 2026-10-08 | β | TK701-TK185-TK8609 | ndc_direct | economy | 30.6 | 827.42 | 1 |
| SSH | SEA | 2026-10-11 | β | TK699-TK79-UA1007 | ndc_direct | economy | 30.6 | 867.42 | 1 |
| SSH | SEA | 2026-10-14 | β | TK701-TK185-TK8609 | ndc_direct | economy | 30.6 | 827.42 | 1 |
| SSH | SEA | 2026-10-21 | β | TK701-TK185-TK8609 | ndc_direct | economy | 30.6 | 827.42 | 1 |
| SSH | SEA | 2026-10-11 | β | TK699-TK79-TK9587 | ndc_direct | economy | 29.4 | 848.62 | 1 |
| SSH | SEA | 2026-10-04 | β | TK699-TK79-UA1007 | ndc_direct | economy | 27 | 811.02 | 1 |
| SSH | SEA | 2026-10-04 | β | TK699-TK289-TK9587 | ndc_direct | economy | 27 | 811.02 | 1 |
| SSH | SEA | 2026-10-04 | β | TK699-TK79-UA5579 | ndc_direct | economy | 27 | 811.02 | 1 |
| SSH | SEA | 2026-10-11 | β | TK699-TK79-UA5579 | ndc_direct | economy | 27 | 811.02 | 1 |
| SSH | SEA | 2026-10-11 | β | TK699-TK289-TK9587 | ndc_direct | economy | 27 | 811.02 | 1 |
| SSH | SEA | 2026-10-24 | β | TK699-TK79-UA1097 | ndc_direct | economy | 27 | 811.02 | 1 |
| SSH | SEA | 2026-10-24 | β | TK699-TK79-UA1007 | ndc_direct | economy | 27 | 811.02 | 1 |
| SSH | SEA | 2026-10-28 | β | TK699-TK79-UA494 | ndc_direct | economy | 26.7 | 814.33 | 1 |
| SSH | SEA | 2026-10-18 | β | TK699-TK289-TK9587 | ndc_direct | economy | 25.8 | 792.22 | 1 |
| SSH | SEA | 2026-10-24 | β | TK701-TK79-TK9587 | ndc_direct | economy | 25.8 | 792.22 | 1 |
| SSH | SEA | 2026-10-24 | β | TK699-TK79-TK9587 | ndc_direct | economy | 25.8 | 792.22 | 1 |
| SSH | SEA | 2026-10-08 | β | TK701-TK203 | ndc_direct | economy | 25.55 | 717.37 | 1 |
| SSH | SEA | 2026-10-28 | β | TK699-TK79-TK9587 | ndc_direct | economy | 25.5 | 787.52 | 1 |
| SSH | SEA | 2026-10-28 | β | TK699-TK79-UA1007 | ndc_direct | economy | 25.5 | 787.52 | 1 |
| SSH | SEA | 2026-10-04 | β | TK699-TK203 | ndc_direct | economy | 19.6 | 638.32 | 1 |
| SSH | SEA | 2026-10-11 | β | TK699-TK203 | ndc_direct | economy | 19.6 | 638.32 | 1 |
| SSH | SEA | 2026-10-18 | β | TK699-TK203 | ndc_direct | economy | 19.6 | 638.32 | 1 |
| SSH | SEA | 2026-10-24 | β | TK701-TK203 | ndc_direct | economy | 19.6 | 638.32 | 1 |
| SSH | SEA | 2026-10-24 | β | TK699-TK203 | ndc_direct | economy | 19.6 | 638.32 | 1 |
| SSH | SEA | 2026-10-31 | β | TK701-TK203 | ndc_direct | economy | 19.6 | 638.32 | 1 |
| SSH | SEA | 2026-10-31 | β | TK699-TK203 | ndc_direct | economy | 19.6 | 638.32 | 1 |
| SSH | SEA | 2026-10-14 | β | TK701-TK203 | ndc_direct | economy | 19.25 | 633.67 | 1 |
| SSH | SEA | 2026-10-21 | β | TK701-TK203 | ndc_direct | economy | 19.25 | 633.67 | 1 |
| SSH | SEA | 2026-10-28 | β | TK699-TK203 | ndc_direct | economy | 19.25 | 633.67 | 1 |
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
| driver | itineraries | avg_fare_gap | avg_commission_gap | avg_net_gap | flips_without_commission |
|---|---|---|---|---|---|
| ndc wins on fare | 14 | 27.57 | 23.82 | 51.39 | 0 |
| amadeus wins on fare | 3 | -249 | 40 | -209 | 0 |
| ndc wins on commission | 3 | -7 | 65.06 | 58.06 | 3 |
βΆ Offer summary by source 2 Total offers by source and fare type
| source | fare_type | offer_count | min_net | avg_net | median_net | routes |
|---|---|---|---|---|---|---|
| amadeus | nego | 91 | 668.92 | 859.92 | 673.92 | 1 |
| ndc_direct | published | 63 | 633.67 | 996.29 | 859.93 | 1 |