tk-20260728-163708
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 | 100 | 0 | 0 | 0 | — | — | 0 | 0 |
| ndc_direct | 144 | 48 | 33.3 | 21 | 27.52 | 41.12 | 82.72 | 1 |
Commission amounts seen
The commission amounts actually seen, commonest first
| source | commission | offer_count | routes | pct_of_source |
|---|---|---|---|---|
| ndc_direct | 37.12 | 8 | 1 | 5.6 |
| ndc_direct | 64.72 | 4 | 1 | 2.8 |
| ndc_direct | 41.92 | 4 | 1 | 2.8 |
| ndc_direct | 40.32 | 4 | 1 | 2.8 |
| ndc_direct | 39.12 | 4 | 1 | 2.8 |
| ndc_direct | 82.72 | 2 | 1 | 1.4 |
| ndc_direct | 66.72 | 2 | 1 | 1.4 |
| ndc_direct | 61.52 | 2 | 1 | 1.4 |
| ndc_direct | 58.32 | 2 | 1 | 1.4 |
| ndc_direct | 43.52 | 2 | 1 | 1.4 |
| ndc_direct | 42.32 | 2 | 1 | 1.4 |
| ndc_direct | 31.92 | 2 | 1 | 1.4 |
| ndc_direct | 27.52 | 2 | 1 | 1.4 |
| ndc_direct | 66.32 | 1 | 1 | 0.7 |
| ndc_direct | 63.52 | 1 | 1 | 0.7 |
| ndc_direct | 48.32 | 1 | 1 | 0.7 |
| ndc_direct | 45.52 | 1 | 1 | 0.7 |
| ndc_direct | 36.72 | 1 | 1 | 0.7 |
| ndc_direct | 33.92 | 1 | 1 | 0.7 |
| ndc_direct | 32.32 | 1 | 1 | 0.7 |
| ndc_direct | 29.52 | 1 | 1 | 0.7 |
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 |
|---|---|---|---|---|---|---|---|
| ORD | MLA | ndc_direct | 144 | 48 | 33 | 27.52 | 82.72 |
| ORD | MLA | amadeus | 100 | 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 |
|---|---|---|---|---|---|---|---|---|---|
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK186-TK1371 / TK1370-TK5 | ndc_direct | economy | 82.72 | 1542.61 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK186-TK1369 / TK1370-TK5 | ndc_direct | economy | 82.72 | 1542.61 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK186-TK1369 / TK1372-TK5 | ndc_direct | economy | 66.72 | 1358.61 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK186-TK1371 / TK1372-TK5 | ndc_direct | economy | 66.72 | 1358.61 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK186-TK1371 / TK1370-TK5 | ndc_direct | economy | 66.32 | 1354.01 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK186-TK1371 / TK1372-TK185 | ndc_direct | economy | 64.72 | 1335.61 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK186-TK1369 / TK1372-TK185 | ndc_direct | economy | 64.72 | 1335.61 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK186-TK1369 / TK1370-TK185 | ndc_direct | economy | 64.72 | 1335.61 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK186-TK1371 / TK1370-TK185 | ndc_direct | economy | 64.72 | 1335.61 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK186-TK1371 / TK1372-TK5 | ndc_direct | economy | 63.52 | 1321.81 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK186-TK1371 / TK1370-TK185 | ndc_direct | economy | 61.52 | 1298.81 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK186-TK1371 / TK1372-TK185 | ndc_direct | economy | 61.52 | 1298.81 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK6-TK1371 / TK1370-TK5 | ndc_direct | economy | 58.32 | 1262.01 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK6-TK1369 / TK1370-TK5 | ndc_direct | economy | 58.32 | 1262.01 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK186-TK1371 / TK1370-TK5 | ndc_direct | economy | 48.32 | 1147.01 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK186-TK1371 / TK1372-TK5 | ndc_direct | economy | 45.52 | 1114.81 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK186-TK1371 / TK1372-TK185 | ndc_direct | economy | 43.52 | 1091.81 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK186-TK1371 / TK1370-TK185 | ndc_direct | economy | 43.52 | 1091.81 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK6-TK1369 / TK1372-TK5 | ndc_direct | economy | 42.32 | 1078.01 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK6-TK1371 / TK1372-TK5 | ndc_direct | economy | 42.32 | 1078.01 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK6-TK1369 / TK1370-TK5 | ndc_direct | economy | 41.92 | 1073.41 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK6-TK1371 / TK1370-TK5 | ndc_direct | economy | 41.92 | 1073.41 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK186-TK1369 / TK1370-TK5 | ndc_direct | economy | 41.92 | 1073.41 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK6-TK1371 / TK1370-TK5 | ndc_direct | economy | 41.92 | 1073.41 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK6-TK1371 / TK1372-TK185 | ndc_direct | economy | 40.32 | 1055.01 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK6-TK1371 / TK1370-TK185 | ndc_direct | economy | 40.32 | 1055.01 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK6-TK1369 / TK1372-TK185 | ndc_direct | economy | 40.32 | 1055.01 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-09 | TK6-TK1369 / TK1370-TK185 | ndc_direct | economy | 40.32 | 1055.01 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK6-TK1371 / TK1372-TK5 | ndc_direct | economy | 39.12 | 1041.21 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK6-TK1369 / TK1372-TK5 | ndc_direct | economy | 39.12 | 1041.21 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK186-TK1369 / TK1372-TK5 | ndc_direct | economy | 39.12 | 1041.21 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK6-TK1371 / TK1372-TK5 | ndc_direct | economy | 39.12 | 1041.21 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK6-TK1369 / TK1370-TK185 | ndc_direct | economy | 37.12 | 1018.21 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK6-TK1369 / TK1372-TK185 | ndc_direct | economy | 37.12 | 1018.21 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK6-TK1371 / TK1370-TK185 | ndc_direct | economy | 37.12 | 1018.21 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK6-TK1371 / TK1372-TK185 | ndc_direct | economy | 37.12 | 1018.21 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK186-TK1369 / TK1370-TK185 | ndc_direct | economy | 37.12 | 1018.21 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK186-TK1369 / TK1372-TK185 | ndc_direct | economy | 37.12 | 1018.21 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK6-TK1371 / TK1372-TK185 | ndc_direct | economy | 37.12 | 1018.21 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK6-TK1371 / TK1370-TK185 | ndc_direct | economy | 37.12 | 1018.21 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK6-TK1369 / TK1370-TK5 | ndc_direct | economy | 36.72 | 1013.61 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK6-TK1369 / TK1372-TK5 | ndc_direct | economy | 33.92 | 981.41 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK186-TK1369 / TK1370-TK5 | ndc_direct | economy | 32.32 | 963.01 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK6-TK1369 / TK1370-TK185 | ndc_direct | economy | 31.92 | 958.41 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-09 | TK6-TK1369 / TK1372-TK185 | ndc_direct | economy | 31.92 | 958.41 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK186-TK1369 / TK1372-TK5 | ndc_direct | economy | 29.52 | 930.81 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK186-TK1369 / TK1372-TK185 | ndc_direct | economy | 27.52 | 907.81 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-09 | TK186-TK1369 / TK1370-TK185 | ndc_direct | economy | 27.52 | 907.81 | 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 | 13 | 92.23 | 11.3 | 103.53 | 0 |
| ndc wins on commission | 6 | -10 | 54.65 | 44.65 | 6 |
| amadeus wins on fare | 1 | -63 | 41.92 | -21.08 | 0 |
â–¶ Offer summary by source 3 Total offers by source and fare type
| source | fare_type | offer_count | min_net | avg_net | median_net | routes |
|---|---|---|---|---|---|---|
| amadeus | nego | 100 | 985.33 | 1206.53 | 1143.33 | 1 |
| ndc_direct | nego | 72 | 888.03 | 1093.59 | 1058.33 | 1 |
| ndc_direct | published | 72 | 906.03 | 1078.16 | 1029.71 | 1 |