sq-20260727-151045
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 | 4553 | 0 | 0 | 0 | — | — | 0 | 0 |
| ndc_direct | 11697 | 0 | 0 | 0 | — | — | 0 | 0 |
Commission amounts seen
The commission amounts actually seen, commonest first
No offer in this run carries commission.
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 |
|---|---|---|---|---|---|---|---|
| EWR | SIN | amadeus | 30 | 0 | 0 | — | 0 |
| EWR | SIN | ndc_direct | 466 | 0 | 0 | — | 0 |
| JFK | FRA | amadeus | 296 | 0 | 0 | — | 0 |
| JFK | SIN | amadeus | 1512 | 0 | 0 | — | 0 |
| LAX | NRT | amadeus | 169 | 0 | 0 | — | 0 |
| LAX | NRT | ndc_direct | 112 | 0 | 0 | — | 0 |
| LAX | SIN | amadeus | 750 | 0 | 0 | — | 0 |
| LAX | SIN | ndc_direct | 2669 | 0 | 0 | — | 0 |
| SEA | HKG | amadeus | 94 | 0 | 0 | — | 0 |
| SEA | HKG | ndc_direct | 1351 | 0 | 0 | — | 0 |
| SEA | SIN | amadeus | 20 | 0 | 0 | — | 0 |
| SEA | SIN | ndc_direct | 2292 | 0 | 0 | — | 0 |
| SFO | HKG | amadeus | 1068 | 0 | 0 | — | 0 |
| SFO | HKG | ndc_direct | 2272 | 0 | 0 | — | 0 |
| SFO | SIN | amadeus | 614 | 0 | 0 | — | 0 |
| SFO | SIN | ndc_direct | 2535 | 0 | 0 | — | 0 |
Bookable itineraries carrying commissionitinerary
Bookable itineraries that carry commission, one row each — the list to pick a test case from
No bookable offer in this run carries commission.
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 | 253 | 120.06 | 0 | 120.06 | 0 |
| amadeus wins on fare | 34 | -1398.06 | 0 | -1398.06 | 0 |
▶ Offer summary by source 4 Total offers by source and fare type
| source | fare_type | offer_count | min_net | avg_net | median_net | routes |
|---|---|---|---|---|---|---|
| amadeus | nego | 4488 | 846.33 | 2126.42 | 2018.73 | 9 |
| amadeus | published | 65 | 9753.33 | 12877.56 | 12077.93 | 2 |
| ndc_direct | nego | 10656 | 770.63 | 3023.36 | 2860.13 | 7 |
| ndc_direct | published | 1041 | 1363.63 | 4139.71 | 2956.63 | 3 |