tk-20260728-155120
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 | 151 | 0 | 0 | 0 | β | β | 0 | 0 |
| ndc_direct | 82 | 82 | 100 | 54 | 20.3 | 45.66 | 104.46 | 1 |
Commission amounts seen
The commission amounts actually seen, commonest first
| source | commission | offer_count | routes | pct_of_source |
|---|---|---|---|---|
| ndc_direct | 45.66 | 6 | 1 | 7.3 |
| ndc_direct | 88.86 | 5 | 1 | 6.1 |
| ndc_direct | 26.6 | 4 | 1 | 4.9 |
| ndc_direct | 43.47 | 3 | 1 | 3.7 |
| ndc_direct | 36.9 | 3 | 1 | 3.7 |
| ndc_direct | 70.56 | 2 | 1 | 2.4 |
| ndc_direct | 69.02 | 2 | 1 | 2.4 |
| ndc_direct | 68.67 | 2 | 1 | 2.4 |
| ndc_direct | 62.64 | 2 | 1 | 2.4 |
| ndc_direct | 53.76 | 2 | 1 | 2.4 |
| ndc_direct | 43.56 | 2 | 1 | 2.4 |
| ndc_direct | 42.06 | 2 | 1 | 2.4 |
| ndc_direct | 39.36 | 2 | 1 | 2.4 |
| ndc_direct | 38.46 | 2 | 1 | 2.4 |
| ndc_direct | 34.37 | 2 | 1 | 2.4 |
| ndc_direct | 34.02 | 2 | 1 | 2.4 |
| ndc_direct | 32.7 | 2 | 1 | 2.4 |
| ndc_direct | 104.46 | 1 | 1 | 1.2 |
| ndc_direct | 104.16 | 1 | 1 | 1.2 |
| ndc_direct | 93.36 | 1 | 1 | 1.2 |
| ndc_direct | 90.66 | 1 | 1 | 1.2 |
| ndc_direct | 89.76 | 1 | 1 | 1.2 |
| ndc_direct | 86.76 | 1 | 1 | 1.2 |
| ndc_direct | 74.46 | 1 | 1 | 1.2 |
| ndc_direct | 65.04 | 1 | 1 | 1.2 |
| ndc_direct | 63.84 | 1 | 1 | 1.2 |
| ndc_direct | 61.44 | 1 | 1 | 1.2 |
| ndc_direct | 58.74 | 1 | 1 | 1.2 |
| ndc_direct | 57.84 | 1 | 1 | 1.2 |
| ndc_direct | 57.54 | 1 | 1 | 1.2 |
| ndc_direct | 56.16 | 1 | 1 | 1.2 |
| ndc_direct | 55.58 | 1 | 1 | 1.2 |
| ndc_direct | 55.23 | 1 | 1 | 1.2 |
| ndc_direct | 54.06 | 1 | 1 | 1.2 |
| ndc_direct | 52.86 | 1 | 1 | 1.2 |
| ndc_direct | 51.66 | 1 | 1 | 1.2 |
| ndc_direct | 51.36 | 1 | 1 | 1.2 |
| ndc_direct | 51.06 | 1 | 1 | 1.2 |
| ndc_direct | 50.16 | 1 | 1 | 1.2 |
| ndc_direct | 49.86 | 1 | 1 | 1.2 |
| ndc_direct | 47.76 | 1 | 1 | 1.2 |
| ndc_direct | 44.76 | 1 | 1 | 1.2 |
| ndc_direct | 43.82 | 1 | 1 | 1.2 |
| ndc_direct | 43.26 | 1 | 1 | 1.2 |
| ndc_direct | 39.66 | 1 | 1 | 1.2 |
| ndc_direct | 39.3 | 1 | 1 | 1.2 |
| ndc_direct | 38.16 | 1 | 1 | 1.2 |
| ndc_direct | 38.1 | 1 | 1 | 1.2 |
| ndc_direct | 34.2 | 1 | 1 | 1.2 |
| ndc_direct | 33.9 | 1 | 1 | 1.2 |
Showing the first 50 of 54 rows β 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
| origin | destination | source | offer_count | with_commission | pct_with_commission | min_commission | max_commission |
|---|---|---|---|---|---|---|---|
| SSH | SEA | ndc_direct | 82 | 82 | 100 | 20.3 | 104.46 |
| SSH | SEA | amadeus | 151 | 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-09-11 | β | TK699-TK79-UA2483 | ndc_direct | economy | 104.46 | 2024.56 | 1 |
| SSH | SEA | 2026-09-07 | β | TK699-TK79-UA2611 | ndc_direct | economy | 104.16 | 2019.86 | 1 |
| SSH | SEA | 2026-09-11 | β | TK699-TK5-UA2211 | ndc_direct | economy | 93.36 | 1810.66 | 1 |
| SSH | SEA | 2026-09-07 | β | TK699-TK5-UA2211 | ndc_direct | economy | 90.66 | 1768.36 | 1 |
| SSH | SEA | 2026-09-06 | β | TK699-TK5-UA2211 | ndc_direct | economy | 89.76 | 1754.26 | 1 |
| SSH | SEA | 2026-09-02 | β | TK701-TK79-TK9587 | ndc_direct | economy | 88.86 | 1780.16 | 1 |
| SSH | SEA | 2026-09-02 | β | TK701-TK289-TK9587 | ndc_direct | economy | 88.86 | 1780.16 | 1 |
| SSH | SEA | 2026-09-03 | β | TK701-TK79-TK9587 | ndc_direct | economy | 88.86 | 1780.16 | 1 |
| SSH | SEA | 2026-09-09 | β | TK701-TK289-TK9587 | ndc_direct | economy | 88.86 | 1780.16 | 1 |
| SSH | SEA | 2026-09-09 | β | TK701-TK79-TK9587 | ndc_direct | economy | 88.86 | 1780.16 | 1 |
| SSH | SEA | 2026-09-07 | β | TK699-TK79-UA1007 | ndc_direct | economy | 86.76 | 1747.26 | 1 |
| SSH | SEA | 2026-09-13 | β | TK699-TK5-UA2211 | ndc_direct | economy | 74.46 | 1514.56 | 1 |
| SSH | SEA | 2026-09-12 | β | TK701-TK79-TK9587 | ndc_direct | economy | 70.56 | 1493.46 | 1 |
| SSH | SEA | 2026-09-13 | β | TK699-TK79-TK9587 | ndc_direct | economy | 70.56 | 1493.46 | 1 |
| SSH | SEA | 2026-09-05 | β | TK701-TK203 | ndc_direct | economy | 69.02 | 1294.9 | 1 |
| SSH | SEA | 2026-09-05 | β | TK699-TK203 | ndc_direct | economy | 69.02 | 1294.9 | 1 |
| SSH | SEA | 2026-09-02 | β | TK701-TK203 | ndc_direct | economy | 68.67 | 1290.25 | 1 |
| SSH | SEA | 2026-09-03 | β | TK701-TK203 | ndc_direct | economy | 68.67 | 1290.25 | 1 |
| SSH | SEA | 2026-09-02 | β | TK701-TK185-TK8609 | ndc_direct | economy | 65.04 | 1366.98 | 1 |
| SSH | SEA | 2026-09-08 | β | TK699-TK5-UA2211 | ndc_direct | economy | 63.84 | 1348.18 | 1 |
| SSH | SEA | 2026-09-01 | β | TK699-TK5-UA2211 | ndc_direct | economy | 62.64 | 1329.38 | 1 |
| SSH | SEA | 2026-09-08 | β | TK699-TK5-UA341 | ndc_direct | economy | 62.64 | 1351.24 | 1 |
| SSH | SEA | 2026-09-13 | β | TK699-TK79-UA2483 | ndc_direct | economy | 61.44 | 1350.58 | 1 |
| SSH | SEA | 2026-09-08 | β | TK699-TK79-UA2483 | ndc_direct | economy | 58.74 | 1308.28 | 1 |
| SSH | SEA | 2026-09-13 | β | TK699-TK79-UA1007 | ndc_direct | economy | 57.84 | 1294.18 | 1 |
| SSH | SEA | 2026-09-01 | β | TK699-TK79-UA2611 | ndc_direct | economy | 57.54 | 1289.48 | 1 |
| SSH | SEA | 2026-09-03 | β | TK701-TK185-TK8609 | ndc_direct | economy | 56.16 | 1227.86 | 1 |
| SSH | SEA | 2026-09-06 | β | TK699-TK213 | ndc_direct | economy | 55.58 | 1116.34 | 1 |
| SSH | SEA | 2026-09-01 | β | TK699-TK203 | ndc_direct | economy | 55.23 | 1111.69 | 1 |
| SSH | SEA | 2026-09-06 | β | TK699-TK185-TK8609 | ndc_direct | economy | 54.06 | 1194.96 | 1 |
| SSH | SEA | 2026-09-07 | β | TK699-TK5-TK8609 | ndc_direct | economy | 53.76 | 1190.26 | 1 |
| SSH | SEA | 2026-09-10 | β | TK701-TK185-TK8609 | ndc_direct | economy | 53.76 | 1190.26 | 1 |
| SSH | SEA | 2026-09-12 | β | TK699-TK5-UA2211 | ndc_direct | economy | 52.86 | 1176.16 | 1 |
| SSH | SEA | 2026-09-13 | β | TK699-TK5-TK8609 | ndc_direct | economy | 51.66 | 1157.36 | 1 |
| SSH | SEA | 2026-09-11 | β | TK699-TK79-TK9587 | ndc_direct | economy | 51.36 | 1192.66 | 1 |
| SSH | SEA | 2026-09-10 | β | TK701-TK79-TK9587 | ndc_direct | economy | 51.06 | 1187.96 | 1 |
| SSH | SEA | 2026-09-06 | β | TK699-TK79-UA2611 | ndc_direct | economy | 50.16 | 1173.86 | 1 |
| SSH | SEA | 2026-09-07 | β | TK699-TK79-TK9587 | ndc_direct | economy | 49.86 | 1169.16 | 1 |
| SSH | SEA | 2026-09-12 | β | TK699-TK79-UA2483 | ndc_direct | economy | 47.76 | 1136.26 | 1 |
| SSH | SEA | 2026-09-01 | β | TK699-TK185-TK8609 | ndc_direct | economy | 45.66 | 1063.36 | 1 |
| SSH | SEA | 2026-09-07 | β | TK701-TK185-TK8609 | ndc_direct | economy | 45.66 | 1063.36 | 1 |
| SSH | SEA | 2026-09-07 | β | TK699-TK185-TK8609 | ndc_direct | economy | 45.66 | 1063.36 | 1 |
| SSH | SEA | 2026-09-08 | β | TK699-TK185-TK8609 | ndc_direct | economy | 45.66 | 1063.36 | 1 |
| SSH | SEA | 2026-09-08 | β | TK699-TK5-TK8609 | ndc_direct | economy | 45.66 | 1063.36 | 1 |
| SSH | SEA | 2026-09-09 | β | TK701-TK185-TK8609 | ndc_direct | economy | 45.66 | 1063.36 | 1 |
| SSH | SEA | 2026-09-06 | β | TK699-TK5-TK8609 | ndc_direct | economy | 44.76 | 1049.26 | 1 |
| SSH | SEA | 2026-09-06 | β | TK699-TK203 | ndc_direct | economy | 43.82 | 960.1 | 1 |
| SSH | SEA | 2026-09-11 | β | TK701-TK185-TK8609 | ndc_direct | economy | 43.56 | 1030.46 | 1 |
| SSH | SEA | 2026-09-12 | β | TK699-TK5-TK8609 | ndc_direct | economy | 43.56 | 1030.46 | 1 |
| SSH | SEA | 2026-09-07 | β | TK701-TK203 | ndc_direct | economy | 43.47 | 955.45 | 1 |
| SSH | SEA | 2026-09-07 | β | TK699-TK203 | ndc_direct | economy | 43.47 | 955.45 | 1 |
| SSH | SEA | 2026-09-10 | β | TK701-TK203 | ndc_direct | economy | 43.47 | 955.45 | 1 |
| SSH | SEA | 2026-09-01 | β | TK699-TK5-TK8609 | ndc_direct | economy | 43.26 | 1025.76 | 1 |
| SSH | SEA | 2026-09-05 | β | TK699-TK79-UA2611 | ndc_direct | economy | 42.06 | 1046.96 | 1 |
| SSH | SEA | 2026-09-06 | β | TK699-TK289-TK9587 | ndc_direct | economy | 42.06 | 1046.96 | 1 |
| SSH | SEA | 2026-09-06 | β | TK699-TK79-TK9587 | ndc_direct | economy | 39.66 | 1009.36 | 1 |
| SSH | SEA | 2026-09-07 | β | TK701-TK79-TK9587 | ndc_direct | economy | 39.36 | 1004.66 | 1 |
| SSH | SEA | 2026-09-08 | β | TK699-TK79-TK9587 | ndc_direct | economy | 39.36 | 1004.66 | 1 |
| SSH | SEA | 2026-09-13 | β | TK699-TK185-TK8609 | ndc_direct | economy | 39.3 | 963.72 | 1 |
| SSH | SEA | 2026-09-11 | β | TK701-TK79-TK9587 | ndc_direct | economy | 38.46 | 990.56 | 1 |
| SSH | SEA | 2026-09-12 | β | TK699-TK79-TK9587 | ndc_direct | economy | 38.46 | 990.56 | 1 |
| SSH | SEA | 2026-09-01 | β | TK699-TK79-TK9587 | ndc_direct | economy | 38.16 | 985.86 | 1 |
| SSH | SEA | 2026-09-05 | β | TK699-TK185-TK8609 | ndc_direct | economy | 38.1 | 944.92 | 1 |
| SSH | SEA | 2026-09-05 | β | TK699-TK5-TK8609 | ndc_direct | economy | 36.9 | 926.12 | 1 |
| SSH | SEA | 2026-09-12 | β | TK701-TK185-TK8609 | ndc_direct | economy | 36.9 | 926.12 | 1 |
| SSH | SEA | 2026-09-12 | β | TK699-TK185-TK8609 | ndc_direct | economy | 36.9 | 926.12 | 1 |
| SSH | SEA | 2026-09-11 | β | TK701-TK203 | ndc_direct | economy | 34.37 | 834.55 | 1 |
| SSH | SEA | 2026-09-11 | β | TK701-TK213 | ndc_direct | economy | 34.37 | 834.55 | 1 |
| SSH | SEA | 2026-09-05 | β | TK699-TK79-TK9587 | ndc_direct | economy | 34.2 | 923.82 | 1 |
| SSH | SEA | 2026-09-08 | β | TK699-TK203 | ndc_direct | economy | 34.02 | 829.9 | 1 |
| SSH | SEA | 2026-09-09 | β | TK701-TK203 | ndc_direct | economy | 34.02 | 829.9 | 1 |
| SSH | SEA | 2026-09-11 | β | TK699-TK5-TK8609 | ndc_direct | economy | 33.9 | 879.12 | 1 |
| SSH | SEA | 2026-09-05 | β | TK699-TK5-UA2211 | ndc_direct | economy | 32.7 | 860.32 | 1 |
| SSH | SEA | 2026-09-05 | β | TK701-TK185-TK8609 | ndc_direct | economy | 32.7 | 860.32 | 1 |
| SSH | SEA | 2026-09-11 | β | TK699-TK185-TK8609 | ndc_direct | economy | 31.5 | 841.52 | 1 |
| SSH | SEA | 2026-09-13 | β | TK699-TK289-TK9587 | ndc_direct | economy | 28.8 | 839.22 | 1 |
| SSH | SEA | 2026-09-05 | β | TK701-TK79-TK9587 | ndc_direct | economy | 27.6 | 820.42 | 1 |
| SSH | SEA | 2026-09-11 | β | TK699-TK203 | ndc_direct | economy | 26.6 | 731.32 | 1 |
| SSH | SEA | 2026-09-12 | β | TK699-TK203 | ndc_direct | economy | 26.6 | 731.32 | 1 |
| SSH | SEA | 2026-09-12 | β | TK701-TK203 | ndc_direct | economy | 26.6 | 731.32 | 1 |
| SSH | SEA | 2026-09-13 | β | TK699-TK203 | ndc_direct | economy | 26.6 | 731.32 | 1 |
| SSH | SEA | 2026-09-11 | β | TK699-TK213 | ndc_direct | economy | 20.3 | 647.62 | 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 |
|---|---|---|---|---|---|
| amadeus wins on fare | 12 | -136.58 | 44.84 | -91.75 | 0 |
| ndc wins on fare | 11 | 236.09 | 38.1 | 274.19 | 0 |
| ndc wins on commission | 7 | -7.29 | 57.35 | 50.06 | 7 |
βΆ 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 | 151 | 683.92 | 1179.76 | 1162.92 | 1 |
| ndc_direct | published | 82 | 647.62 | 1165.81 | 1063.36 | 1 |