The Contribution From Codeshare Partners report, depicted in Figure 1, lays out contributions made by other operating airlines to the host airline, in its role as the marketing airline.

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
Mkt_AL keyMarketing airline, which is the host airline
Opt_AL keyOperating airline, which is a codeshare partner of the host airline
PaxNumber of passengers carried by the specific codeshare partner in the target month
Pax_ShareShare of passengers carried by the specific partner relative to total passengers carried by all codeshare partners
Local_PaxNumber of passengers carried by the specific partner in the local markets (flight origin and destination match the market origin and destination)
Local_Pax_ShareShare of local passengers carried by the specific partner relative to total local passengers carried by all partners
Cnx_PaxNumber of passengers carried by the specific partner in the connecting markets
Cnx_Pax_ShareShare of connecting passengers carried by the specific partner relative to total connecting passengers by all partners
RevenueRevenue in USD attributed to the specific operating airline
Rev_ShareShare of revenue attributed to the specific operating airline relative to revenue attributed to all operating airlines
Local_RevenueRevenue from local markets attributed to the specific operating airline
Local_Rev_ShareShare of revenue from local markets attributed to the specific operating airline relative to total revenue attributed to all local operating airlines
Cnx_RevenueRevenue from connecting markets attributed to the specific operating airline
Cnx_Rev_ShareShare of revenue from connecting markets by the specific operating airline relative to total revenue by all connecting operating airlines
Table 1: Data Structure