Content Source Savings report

The Content Source Savings report provides insights about the added value you receive from Spotnana’s direct connections. For example, when the exact same itinerary is available via both direct connections (e.g., NDC or a direct connection with an airline) and non-direct channels, savings may often be achieved as a result of access to continuous pricing and by avoiding GDS surcharges (as well as other pricing advantages). We refer to these savings as like-for-like savings. This report features high-level metrics on like-for-like savings that occurred as a result of the content source that was used. It also offers the ability to view details such as savings by airline, route, and PNR.

Some clarifications relevant to the use of this report:
- Like-for-like savings are distinct from negotiated savings. When comparing direct and non-direct fares for the same itinerary, we do so by looking at the fares to which rate codes have already been applied. 
- A single booking may be associated with multiple airlines (e.g., when alliance partners each market part of a booking). As a result, the Selected Airlines field in this report may list multiple airlines for the same PNR.
- Like-for-like savings data is only available for dates after August, 2024.

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

• Content Source Savings report
  • Filters
  • Sub-filters
    • To apply sub-filters
  • Parameters
    • Currency code
    • Name Format
  • Graph Metrics
    • Achieved like-for-like savings over time 
    • Like-for-like savings per airline
    • Like-for-like savings by route
  • Table Grid Metrics
    • Detailed like-for-like savings 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:

• Booking Platform - The platform on which the booking was made (e.g., App, Web).
  
• Connection Type - Type of connection (e.g., NDC, Sabre) used for the booking.
• Selected Airlines - Airline carrier code(s) for the flights selected for the booking. 
• 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 Content Source Savings report contain 7 info tiles (all values displayed are for the time period selected):

• NDC/Direct connection spend - Total spend on air travel from NDC or direct connections (NDC, Southwest, etc.).
• NDC/Direct connection bookings - Total number of bookings from NDC or direct connections.
• NDC/Direct connection adoption % - Percentage of total bookings that came from NDC or direct connections. 
• Like-for-like savings - Total savings achieved by booking via direction connections when the same itinerary was available via a non-direct source. 
• Number of bookings with like-for-like savings - Total number of bookings for which like-for-like savings were achieved.
• Like-for-like savings % - Percentage of like-for-like savings that were achieved. This is measured across all booked itineraries that were available from both direct and non-direct content sources. 
• Like-for-like savings per booking - The average like-for-like savings achieved per booking.

The Content Source Savings report contains 3 graphs. The values shown are for the time range, organization, and legal entities specified in the filters.

Achieved like-for-like savings over time 

• The left axis of this graph shows the amount of like-for-like savings achieved per month as a result of direct connection sources.
• The right access of this graph shows the aggregate amount of like-for-like savings achieved across the selected time period as a result of direct connection sources.  
• The bottom axis of this graph shows the PNR creation month.

Like-for-like savings per airline

• The left axis of this graph shows the airlines with which you achieved the most like-for-like savings as a result of direct connection sources. 
• The bottom axis of this graph shows the amount of like-for-like savings achieved.

Like-for-like savings by route

• The left axis of this graph shows the routes with which you achieved the most like-for-like savings as a result of direct connection sources. 
• The bottom axis of this graph shows the amount of like-for-like savings achieved.

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 like-for-like savings report

This table grid provides the following metrics:

• Trip ID
• Trip Name
• Spotnana PNR ID
• Trip Creation Date UTC
• PNR Creation Date UTC
• Booking Source
• Traveler Name
• Traveler Email
• Other Supplier Source
• Like-for-like Savings (User Selected Currency)
• Selected Fare (User Selected Currency)
• Other Supplier Fare (User Selected Currency)
• Selected Airlines
• Selected Route
• Selected Travel Begin UTC
• Selected Travel End UTC
• Selected Travel Duration (mins)
• Selected Layover Duration (mins)
• Selected Layover Count
• Booking Platform
• Traveler PID