The Contribution To Codeshare Partners report, as shown in Figure 1, lays out contribution made by the host airline, as the operating airline, to its codeshare partners.

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 (key).

FieldDescription
Opt_AL keyOperating airline, which is the host airline
Mkt_AL keyMarketing airline, which is a codeshare partner of the host airline
PaxNumber of passengers operated by the host airline and marketed by the codeshare partner in the target month
Pax_ShareShare of passengers marketed by the specific partner relative to passengers marketed by all codeshare partners
Local_PaxNumber of passengers marketed by the specific partner in the local markets (flight origin and destination match the market origin and destination)
Local_Pax_ShareShare of local passengers marketed by the specific partner relative to total local passengers marketed by all partners
Cnx_PaxNumber of passengers marketed by the specific partner in connecting markets
Cnx_Pax_ShareShare of connecting passengers marketed by the specific partner relative to total connecting passengers by all partners
RevenueRevenue in USD generated by the specific marketing airline
Rev_ShareShare of revenue by the specific marketing airline relative to revenue generated by all marketing airlines
Local_RevenueRevenue from local markets generated by the specific marketing airline
Local_Rev_ShareShare of revenue from local markets generated by the specific marketing airline relative to total revenue by all local marketing airlines
Cnx_RevenueRevenue from connecting markets generated by the specific marketing airline
Cnx_Rev_ShareShare of revenue from connecting markets by the specific marketing airline relative to total revenue by all connecting marketing airlines
Table 1: Data Structure