The Alliance City Presence Impact report, depicted in Figure 1, highlights the previous and updated rankings of each alliance from individual cities and indicates the revenue shifts attributed to alliance city presence.
This image is password protected.
Table 1 below outlines the data structure, with the data metrics aggregated by the combination of fields with a key icon (
).
| Field | Description |
| Alliance | Alliance name. “~ ~” for the aggregation of all independent airlines. |
| Org | Origin airport of true Origin-Destination (O&D) trips |
| Rank_Old | Ranking of the alliance at the origin airport in the ‘before’ case |
| Rank_New | Ranking of the alliance at the origin airport in the ‘after’ case |
| Revenue_Change | Change in revenue, measured in USD, from the ‘before’ case to the ‘after’ case within the target month |
| Rev_Chg_City_Presence | Revenue change attributed to the variation in alliance city presence between the ‘before’ case and the ‘after’ case |
| Annual_Rev_Chg | Annualized revenue change (equals to Revenue_Change * 12) |
| Annual_Rev_Chg_City_Presence | Annualized revenue change attributed to the variation in alliance city presence (equals to Rev_Chg_City_Presence * 12) |