tk-20260728-152539
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 | 210 | 0 | 0 | 0 | — | — | 0 | 0 |
| ndc_direct | 70 | 35 | 50 | 6 | 28.16 | 29.36 | 34.96 | 1 |
Commission amounts seen
The commission amounts actually seen, commonest first
| source | commission | offer_count | routes | pct_of_source |
|---|---|---|---|---|
| ndc_direct | 28.16 | 10 | 1 | 14.3 |
| ndc_direct | 31.76 | 9 | 1 | 12.9 |
| ndc_direct | 29.36 | 9 | 1 | 12.9 |
| ndc_direct | 31.36 | 3 | 1 | 4.3 |
| ndc_direct | 34.96 | 2 | 1 | 2.9 |
| ndc_direct | 32.56 | 2 | 1 | 2.9 |
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 |
|---|---|---|---|---|---|---|---|
| JFK | IST | ndc_direct | 70 | 35 | 50 | 28.16 | 34.96 |
| JFK | IST | amadeus | 210 | 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 |
|---|---|---|---|---|---|---|---|---|---|
| JFK | IST | 2026-10-09 | — | TK2 | ndc_direct | economy | 34.96 | 615.54 | 1 |
| JFK | IST | 2026-10-10 | — | TK2 | ndc_direct | economy | 34.96 | 615.54 | 1 |
| JFK | IST | 2026-10-09 | — | TK4 | ndc_direct | economy | 32.56 | 587.94 | 1 |
| JFK | IST | 2026-10-10 | — | TK4 | ndc_direct | economy | 32.56 | 587.94 | 1 |
| JFK | IST | 2026-10-04 | — | TK2 | ndc_direct | economy | 31.76 | 578.74 | 1 |
| JFK | IST | 2026-10-05 | — | TK2 | ndc_direct | economy | 31.76 | 578.74 | 1 |
| JFK | IST | 2026-10-06 | — | TK2 | ndc_direct | economy | 31.76 | 578.74 | 1 |
| JFK | IST | 2026-10-07 | — | TK2 | ndc_direct | economy | 31.76 | 578.74 | 1 |
| JFK | IST | 2026-10-08 | — | TK2 | ndc_direct | economy | 31.76 | 578.74 | 1 |
| JFK | IST | 2026-10-11 | — | TK2 | ndc_direct | economy | 31.76 | 578.74 | 1 |
| JFK | IST | 2026-10-12 | — | TK2 | ndc_direct | economy | 31.76 | 578.74 | 1 |
| JFK | IST | 2026-10-13 | — | TK2 | ndc_direct | economy | 31.76 | 578.74 | 1 |
| JFK | IST | 2026-10-14 | — | TK2 | ndc_direct | economy | 31.76 | 578.74 | 1 |
| JFK | IST | 2026-10-09 | — | TK12 | ndc_direct | economy | 31.36 | 574.14 | 1 |
| JFK | IST | 2026-10-10 | — | TK12 | ndc_direct | economy | 31.36 | 574.14 | 1 |
| JFK | IST | 2026-10-10 | — | TK112 | ndc_direct | economy | 31.36 | 574.14 | 1 |
| JFK | IST | 2026-10-04 | — | TK4 | ndc_direct | economy | 29.36 | 551.14 | 1 |
| JFK | IST | 2026-10-05 | — | TK4 | ndc_direct | economy | 29.36 | 551.14 | 1 |
| JFK | IST | 2026-10-06 | — | TK4 | ndc_direct | economy | 29.36 | 551.14 | 1 |
| JFK | IST | 2026-10-07 | — | TK4 | ndc_direct | economy | 29.36 | 551.14 | 1 |
| JFK | IST | 2026-10-08 | — | TK4 | ndc_direct | economy | 29.36 | 551.14 | 1 |
| JFK | IST | 2026-10-11 | — | TK4 | ndc_direct | economy | 29.36 | 551.14 | 1 |
| JFK | IST | 2026-10-12 | — | TK4 | ndc_direct | economy | 29.36 | 551.14 | 1 |
| JFK | IST | 2026-10-13 | — | TK4 | ndc_direct | economy | 29.36 | 551.14 | 1 |
| JFK | IST | 2026-10-14 | — | TK4 | ndc_direct | economy | 29.36 | 551.14 | 1 |
| JFK | IST | 2026-10-04 | — | TK12 | ndc_direct | economy | 28.16 | 537.34 | 1 |
| JFK | IST | 2026-10-05 | — | TK12 | ndc_direct | economy | 28.16 | 537.34 | 1 |
| JFK | IST | 2026-10-06 | — | TK12 | ndc_direct | economy | 28.16 | 537.34 | 1 |
| JFK | IST | 2026-10-07 | — | TK12 | ndc_direct | economy | 28.16 | 537.34 | 1 |
| JFK | IST | 2026-10-08 | — | TK112 | ndc_direct | economy | 28.16 | 537.34 | 1 |
| JFK | IST | 2026-10-08 | — | TK12 | ndc_direct | economy | 28.16 | 537.34 | 1 |
| JFK | IST | 2026-10-11 | — | TK12 | ndc_direct | economy | 28.16 | 537.34 | 1 |
| JFK | IST | 2026-10-12 | — | TK12 | ndc_direct | economy | 28.16 | 537.34 | 1 |
| JFK | IST | 2026-10-13 | — | TK12 | ndc_direct | economy | 28.16 | 537.34 | 1 |
| JFK | IST | 2026-10-14 | — | TK12 | ndc_direct | economy | 28.16 | 537.34 | 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 | 35 | 9 | 30.31 | 39.31 | 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 | 210 | 574.5 | 624.86 | 621.5 | 1 |
| ndc_direct | nego | 35 | 537.5 | 564.36 | 552.5 | 1 |
| ndc_direct | published | 35 | 537.34 | 562.05 | 551.14 | 1 |