The Airline City Presence Impact report, depicted in Figure 1, details the revenue fluctuations by airline, stemming from changes in 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. |
| AL_Group | Airline group defined in the Group_Airline table |
| AL | IATA code of the dominant marketing airline |
| 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) |