The Codeshare Connection Summary report, depicted in Figure 1, offers an analysis of how revenue is distributed between the host airline and its connecting partners on single connections, which account for the majority of total connecting revenue.
This image is password protected.
Table 1 below outlines the data structure, with the granularity of the data metrics defined by the combination of fields with a key icon (
).
| Field | Description |
| Org | Segment Origin Airport |
| Dst | Segment Destination Airport |
| True_Org | Trip Origin Airport |
| True_Dst | Trip Destination Airport |
| True_Org_Country | Trip Origin Country |
| True_Dst_Country | Trip Destination Country |
| Route | Airports on the trip concatenated with hyphens |
| Host | The Host Airline |
| Partner | The Partner Airline |
| OD_Pax | Total passenger count on the trip in the target month |
| Seg_Pax | Total passengers count on the segment from all trips using the segment |
| Share | Share of number of passengers traveling through the specific trip relative to total passenger count through the segment |
| Rev_Host | Revenue allocated to the host airline based on either the IATA SRP method or the SQRT Miles method specified in Advanced Settings before you run a scenario |
| Rev_Partner | Revenue allocated to the partner airline |