tk-20260728-162840
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 | 186 | 0 | 0 | 0 | — | — | 0 | 0 |
| ndc_direct | 376 | 88 | 23.4 | 40 | 19.12 | 53.92 | 125.12 | 1 |
Commission amounts seen
The commission amounts actually seen, commonest first
| source | commission | offer_count | routes | pct_of_source |
|---|---|---|---|---|
| ndc_direct | 48.72 | 5 | 1 | 1.3 |
| ndc_direct | 111.44 | 4 | 1 | 1.1 |
| ndc_direct | 81.52 | 4 | 1 | 1.1 |
| ndc_direct | 61.12 | 4 | 1 | 1.1 |
| ndc_direct | 42.32 | 4 | 1 | 1.1 |
| ndc_direct | 35.52 | 4 | 1 | 1.1 |
| ndc_direct | 35.04 | 4 | 1 | 1.1 |
| ndc_direct | 29.12 | 4 | 1 | 1.1 |
| ndc_direct | 25.52 | 4 | 1 | 1.1 |
| ndc_direct | 19.12 | 4 | 1 | 1.1 |
| ndc_direct | 43.52 | 3 | 1 | 0.8 |
| ndc_direct | 37.12 | 3 | 1 | 0.8 |
| ndc_direct | 125.12 | 2 | 1 | 0.5 |
| ndc_direct | 118.72 | 2 | 1 | 0.5 |
| ndc_direct | 90.72 | 2 | 1 | 0.5 |
| ndc_direct | 86.32 | 2 | 1 | 0.5 |
| ndc_direct | 83.52 | 2 | 1 | 0.5 |
| ndc_direct | 82.72 | 2 | 1 | 0.5 |
| ndc_direct | 82.32 | 2 | 1 | 0.5 |
| ndc_direct | 77.52 | 2 | 1 | 0.5 |
| ndc_direct | 72.32 | 2 | 1 | 0.5 |
| ndc_direct | 66.32 | 2 | 1 | 0.5 |
| ndc_direct | 64.32 | 2 | 1 | 0.5 |
| ndc_direct | 53.12 | 2 | 1 | 0.5 |
| ndc_direct | 49.52 | 2 | 1 | 0.5 |
| ndc_direct | 89.12 | 1 | 1 | 0.3 |
| ndc_direct | 87.52 | 1 | 1 | 0.3 |
| ndc_direct | 79.12 | 1 | 1 | 0.3 |
| ndc_direct | 77.92 | 1 | 1 | 0.3 |
| ndc_direct | 69.52 | 1 | 1 | 0.3 |
| ndc_direct | 67.92 | 1 | 1 | 0.3 |
| ndc_direct | 59.92 | 1 | 1 | 0.3 |
| ndc_direct | 59.52 | 1 | 1 | 0.3 |
| ndc_direct | 55.12 | 1 | 1 | 0.3 |
| ndc_direct | 54.72 | 1 | 1 | 0.3 |
| ndc_direct | 48.32 | 1 | 1 | 0.3 |
| ndc_direct | 47.92 | 1 | 1 | 0.3 |
| ndc_direct | 45.52 | 1 | 1 | 0.3 |
| ndc_direct | 41.92 | 1 | 1 | 0.3 |
| ndc_direct | 39.12 | 1 | 1 | 0.3 |
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 | 376 | 88 | 23 | 19.12 | 125.12 |
| ORD | MLA | amadeus | 186 | 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-10 | TK186-TK1369 / TK1372-TK5 | ndc_direct | economy | 125.12 | 2030.21 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK186-TK1371 / TK1372-TK5 | ndc_direct | economy | 125.12 | 2030.21 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK186-TK1371 / TK1370-TK5 | ndc_direct | economy | 118.72 | 1956.61 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK186-TK1369 / TK1370-TK5 | ndc_direct | economy | 118.72 | 1956.61 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK186-TK1369 / TK1372-TK185 | ndc_direct | economy | 111.44 | 1872.89 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK186-TK1369 / TK1370-TK185 | ndc_direct | economy | 111.44 | 1872.89 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK186-TK1371 / TK1370-TK185 | ndc_direct | economy | 111.44 | 1872.89 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK186-TK1371 / TK1372-TK185 | ndc_direct | economy | 111.44 | 1872.89 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK186-TK1371 / TK1372-TK185 | ndc_direct | economy | 90.72 | 1634.61 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK186-TK1371 / TK1372-TK5 | ndc_direct | economy | 90.72 | 1634.61 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK186-TK1371 / TK1370-TK5 | ndc_direct | economy | 89.12 | 1616.21 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK186-TK1371 / TK1372-TK5 | ndc_direct | economy | 87.52 | 1597.81 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK6-TK1369 / TK1370-TK5 | ndc_direct | economy | 86.32 | 1584.01 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK6-TK1371 / TK1370-TK5 | ndc_direct | economy | 86.32 | 1584.01 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK6-TK1371 / TK1372-TK5 | ndc_direct | economy | 83.52 | 1551.81 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK6-TK1369 / TK1372-TK5 | ndc_direct | economy | 83.52 | 1551.81 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK186-TK1369 / TK1370-TK5 | ndc_direct | economy | 82.72 | 1542.61 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK6-TK1371 / TK1370-TK5 | ndc_direct | economy | 82.72 | 1542.61 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK6-TK1371 / TK1372-TK5 | ndc_direct | economy | 82.32 | 1538.01 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK186-TK1369 / TK1372-TK5 | ndc_direct | economy | 82.32 | 1538.01 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK6-TK1371 / TK1372-TK185 | ndc_direct | economy | 81.52 | 1528.81 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK6-TK1371 / TK1370-TK185 | ndc_direct | economy | 81.52 | 1528.81 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK6-TK1369 / TK1372-TK185 | ndc_direct | economy | 81.52 | 1528.81 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK6-TK1369 / TK1370-TK185 | ndc_direct | economy | 81.52 | 1528.81 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK186-TK1371 / TK1370-TK185 | ndc_direct | economy | 79.12 | 1501.21 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK6-TK1369 / TK1372-TK5 | ndc_direct | economy | 77.92 | 1487.41 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK6-TK1369 / TK1370-TK5 | ndc_direct | economy | 77.52 | 1482.81 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK186-TK1371 / TK1370-TK185 | ndc_direct | economy | 77.52 | 1482.81 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK6-TK1371 / TK1370-TK185 | ndc_direct | economy | 72.32 | 1423.01 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK186-TK1369 / TK1370-TK185 | ndc_direct | economy | 72.32 | 1423.01 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK186-TK1371 / TK1372-TK185 | ndc_direct | economy | 69.52 | 1390.81 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK6-TK1369 / TK1370-TK185 | ndc_direct | economy | 67.92 | 1372.41 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK186-TK1369 / TK1372-TK185 | ndc_direct | economy | 66.32 | 1354.01 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK186-TK1369 / TK1372-TK5 | ndc_direct | economy | 66.32 | 1354.01 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK6-TK1371 / TK1372-TK185 | ndc_direct | economy | 64.32 | 1331.01 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK186-TK1369 / TK1372-TK185 | ndc_direct | economy | 64.32 | 1331.01 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK6-TK1369 / TK1372-TK185 | ndc_direct | economy | 61.12 | 1294.21 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK6-TK1371 / TK1372-TK185 | ndc_direct | economy | 61.12 | 1294.21 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK6-TK1371 / TK1372-TK5 | ndc_direct | economy | 61.12 | 1294.21 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK6-TK1369 / TK1372-TK5 | ndc_direct | economy | 61.12 | 1294.21 | 1 |
| ORD | MLA | 2026-09-05 | 2026-09-12 | TK6-TK1369 / TK1372-TK185 | ndc_direct | economy | 59.92 | 1280.41 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK186-TK1371 / TK1372-TK5 | ndc_direct | economy | 59.52 | 1275.81 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK186-TK1371 / TK1372-TK185 | ndc_direct | economy | 55.12 | 1225.21 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK186-TK1369 / TK1370-TK185 | ndc_direct | economy | 54.72 | 1220.61 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK186-TK1369 / TK1372-TK5 | ndc_direct | economy | 53.12 | 1202.21 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK6-TK1371 / TK1372-TK5 | ndc_direct | economy | 53.12 | 1202.21 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK6-TK1369 / TK1370-TK185 | ndc_direct | economy | 49.52 | 1160.81 | 1 |
| ORD | MLA | 2026-09-01 | 2026-09-05 | TK6-TK1371 / TK1370-TK185 | ndc_direct | economy | 49.52 | 1160.81 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK186-TK1371 / TK1370-TK185 | ndc_direct | economy | 48.72 | 1151.61 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK186-TK1369 / TK1372-TK185 | ndc_direct | economy | 48.72 | 1151.61 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK6-TK1371 / TK1372-TK185 | ndc_direct | economy | 48.72 | 1151.61 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK6-TK1369 / TK1372-TK5 | ndc_direct | economy | 48.72 | 1151.61 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK6-TK1371 / TK1372-TK5 | ndc_direct | economy | 48.72 | 1151.61 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK186-TK1371 / TK1370-TK5 | ndc_direct | economy | 48.32 | 1147.01 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK6-TK1369 / TK1372-TK5 | ndc_direct | economy | 47.92 | 1142.41 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK186-TK1371 / TK1372-TK5 | ndc_direct | economy | 45.52 | 1114.81 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK6-TK1369 / TK1372-TK185 | ndc_direct | economy | 43.52 | 1091.81 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK186-TK1371 / TK1372-TK185 | ndc_direct | economy | 43.52 | 1091.81 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK186-TK1371 / TK1370-TK185 | ndc_direct | economy | 43.52 | 1091.81 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK186-TK1369 / TK1370-TK185 | ndc_direct | economy | 42.32 | 1078.01 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK6-TK1371 / TK1370-TK185 | ndc_direct | economy | 42.32 | 1078.01 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK6-TK1369 / TK1370-TK5 | ndc_direct | economy | 42.32 | 1078.01 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK6-TK1371 / TK1370-TK5 | ndc_direct | economy | 42.32 | 1078.01 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK186-TK1369 / TK1370-TK5 | ndc_direct | economy | 41.92 | 1073.41 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK186-TK1369 / TK1372-TK5 | ndc_direct | economy | 39.12 | 1041.21 | 1 |
| ORD | MLA | 2026-09-02 | 2026-09-07 | TK6-TK1369 / TK1370-TK185 | ndc_direct | economy | 37.12 | 1018.21 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK186-TK1369 / TK1372-TK185 | ndc_direct | economy | 37.12 | 1018.21 | 1 |
| ORD | MLA | 2026-09-03 | 2026-09-09 | TK186-TK1369 / TK1370-TK185 | ndc_direct | economy | 37.12 | 1018.21 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK186-TK1369 / TK1372-TK5 | ndc_direct | economy | 35.52 | 999.81 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK186-TK1369 / TK1370-TK5 | ndc_direct | economy | 35.52 | 999.81 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK186-TK1371 / TK1370-TK5 | ndc_direct | economy | 35.52 | 999.81 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK186-TK1371 / TK1372-TK5 | ndc_direct | economy | 35.52 | 999.81 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK6-TK1369 / TK1372-TK185 | ndc_direct | economy | 35.04 | 994.29 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK6-TK1369 / TK1370-TK185 | ndc_direct | economy | 35.04 | 994.29 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK6-TK1371 / TK1370-TK185 | ndc_direct | economy | 35.04 | 994.29 | 1 |
| ORD | MLA | 2026-09-04 | 2026-09-10 | TK6-TK1371 / TK1372-TK185 | ndc_direct | economy | 35.04 | 994.29 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK6-TK1369 / TK1370-TK5 | ndc_direct | economy | 29.12 | 926.21 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK6-TK1369 / TK1372-TK5 | ndc_direct | economy | 29.12 | 926.21 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK6-TK1371 / TK1370-TK5 | ndc_direct | economy | 29.12 | 926.21 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK6-TK1371 / TK1372-TK5 | ndc_direct | economy | 29.12 | 926.21 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK186-TK1369 / TK1372-TK185 | ndc_direct | economy | 25.52 | 884.81 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK186-TK1369 / TK1370-TK185 | ndc_direct | economy | 25.52 | 884.81 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK186-TK1371 / TK1370-TK185 | ndc_direct | economy | 25.52 | 884.81 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK186-TK1371 / TK1372-TK185 | ndc_direct | economy | 25.52 | 884.81 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK6-TK1371 / TK1370-TK185 | ndc_direct | economy | 19.12 | 811.21 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK6-TK1369 / TK1370-TK185 | ndc_direct | economy | 19.12 | 811.21 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK6-TK1371 / TK1372-TK185 | ndc_direct | economy | 19.12 | 811.21 | 1 |
| ORD | MLA | 2026-09-06 | 2026-09-14 | TK6-TK1369 / TK1372-TK185 | ndc_direct | economy | 19.12 | 811.21 | 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 | 27 | 51.67 | 13 | 64.67 | 0 |
| ndc wins on commission | 10 | -15.7 | 65.36 | 49.66 | 10 |
| amadeus wins on fare | 2 | -160 | 75.92 | -84.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 | 186 | 848.33 | 1272.8 | 1196.33 | 1 |
| ndc_direct | nego | 188 | 814.33 | 1196.87 | 1146.33 | 1 |
| ndc_direct | published | 188 | 811.21 | 1276.99 | 1146.33 | 1 |