Air O&D Pairs report

The Air O&D Pairs report provides insights on origin and destination (O&D) pairs for air travel. The metrics presented include top O&D city and airport pairs by spend, ticket price, and ticket count as well as air travel grouped by type of itinerary booked (one-way, round-trip, multi-city). Detailed transaction level information is also provided.

Some definitions relevant to the use of this report:
- O&D pairs are constructed alphabetically. Therefore JFK > SFO and SFO > JFK would both be aggregated under the O&D pair JFK-SFO.   
- O&D cities use the metropolitan city mapping provided by IATA. For example, using this mapping, EWR, LGA, and JFK are all mapped to New York City.
- The itinerary type is stored on both the ticket and PNR (booking) level. However, in cases where a single PNR causes multiple tickets to be issued, the itinerary type might be stored differently for each. For example, the itinerary type for SFO > JFK > SFO would be represented at the PNR level as a round-trip, but could be stored at the ticket level as a one-way (if the PNR was issued as two separate tickets) for each ticket.

For a list of all analytics reports available from the Spotnana Online Booking tool, a list of the filters that can be used with them, as well as how their general visualization graphs work, see Analytic reports

TABLE OF CONTENTS

• Air O&D Pairs report
  • Filters
  • Sub-filters
    • To apply sub-filters
  • Parameters
    • Currency code
    • Name Format
  • Graph Metrics
    • Gross spend by PNR itinerary type
    • Number of bookings by PNR itinerary type
    • Gross Spend by O&D cities 
    • Gross spend by O&D airports
    • Average price per ticket by O&D cities
    • Average price per ticket by O&D airports
    • Ticket count by O&D cities
    • Ticket count by O&D airports
  • Table Grid Metrics
    • Detailed O&D Report

Filters

For a list of filters that are available in all analytics reports, see the Filters sections of Analytic reports.

Sub-filters

Sub-filters offer additional control over the data that is presented. 

Sub-filters only appear once you have selected a report to run and applied the main filters.

The sub-filters offered for this report are:

• Policy Compliance - Whether the travel booking was in compliance with company travel policy.
• Region Type - Whether the travel was domestic or international.
• Booking Source - Distribution source through which the travel booking was made (e.g., Sabre, NDC).
• Booking Platform - The platform on which the booking was made (e.g., App, Web).
• Ticketing Carrier Name - Name of the airline carrier that ticketed the travel.  
• Traveler Cost Center - Cost center associated with the traveler.
• Traveler Department - Department associated with the traveler.
• Traveler Designation - Work role designation associated with the traveler (e.g., 1092 - Accounting Clerk).
• Traveler Name - Name of the traveler associated with the booking.
  

To apply sub-filters

For each sub-filter available, you will be able to include or exclude relevant values.

1. Click the down arrow next to the sub-filter you wish to set. A list of all valid values for that sub-filter will be displayed.
2. Select Include or Exclude depending on whether you want this sub-filter to include or exclude the values you select next.
3. You can search for a particular sub-filter value by using the Search field and clicking Go.
4. Once you have located the sub-filter values you wish to include or exclude, select each one as desired. You can also click Select all or Clear all.
5. Click Done. The results shown in the report will reflect the sub-filters selections you made.

The more filters you apply, the fewer results will be displayed. If you see no records displayed, try removing filters.

Parameters

Currency code

You can use the Currency Code parameter to control the currency in which all monetary values are displayed. To set this value:

1. Click the Currency Code parameter.
2. Select the desired currency (or search for it).
3. Click Apply.

This parameter converts all values from the billing currency to the selected currency. 

This conversion is only an approximate and does not reflect the actual conversion performed by the payment provider. For financial reconciliation purposes, please refer to the values in billing currency. Spotnana is not liable for any conversion discrepancies.

Name Format

You can use the Name Format parameter to designate whether the traveler's preferred name (if specified) should also be included in the report metics. By default, only the legal name will be used. To set this:

1. Click the Name Format parameter.
2. Select either Include Preferred or Legal Only.
3. Click Apply. 

Graph Metrics

The Air O&D Pairs report contains 2 pie graphs (all values displayed are for the time period, organization, and legal entities selected in the filters):

Gross spend by PNR itinerary type

A graph of all air travel spend by separate itinerary type, such as one way, round trip, multi-city, unknown. 

Number of bookings by PNR itinerary type

A graph of total number of air bookings by itinerary type, such as one way, round trip, multi-city, unknown.

The Air O&D Pairs report contains 6 graphs. The values shown are for the time range, organization, and legal entities specified in the filters.

Gross Spend by O&D cities 

• The left axis of this graph shows the top O&D city pairs ranked by gross spend. 
• The bottom axis of this graph shows the total gross spend.

Gross spend by O&D airports

• The left axis of this graph shows the top O&D airport pairs ranked by gross spend. 
• The bottom axis of this graph shows the total gross spend.

Average price per ticket by O&D cities

• The left axis of this graph shows the top O&D city pairs ranked by number of tickets and displays the average price per ticket for each pair. 
• The bottom axis of this graph shows the average price per ticket.

Average price per ticket by O&D airports

• The left axis of this graph shows the top O&D airport pairs ranked by number of tickets and displays the average price per ticket for each pair. 
• The bottom axis of this graph shows the average price per ticket.

Ticket count by O&D cities

• The left axis of this graph shows the top O&D city pairs ranked by total number of tickets. 
• The bottom axis of this graph shows the total number of tickets.

Ticket count by O&D airports

• The left axis of this graph shows the top O&D airport pairs ranked by total number of tickets. 
• The bottom axis of this graph shows the total number of tickets.

Table Grid Metrics

The table grid metrics of this report are described below. 

• You can download the metrics in a grid to .XLS or .CSV format by clicking on the … on the top right of each grid (you may need to hover to see it displayed).
• You can filter, sort, aggregate, or remove any of the metrics in the grid by clicking on the … in the column header for that metric.

Detailed O&D Report

This table grid provides the following metrics:

• Traveler Name

• Traveler Email

• Traveler Org Name

• Ticketing Carrier Name

• Active

• O&D Airports

• O&D Cities

• Booked By

• Booking Mode

• Start Airport

• End Airport

• Ticket Number

• Ticket Type

• Transaction Type

• Booking Source

• Policy Compliance

• Region Type

• Transaction Itinerary Type

• PNR Itinerary Type

• Gross Spend (User Selected Currency)

• Gross Price (User Selected Currency)

• Transaction Date UTC

• PNR Creation Date UTC

• Trip Creation Date UTC

• Transaction Key

• Spotnana PNR ID

• Trip ID

• Trip Name