Negotiated Savings report

The Negotiated Savings report provides information on savings achieved through company- and TMC-negotiated rates for Sabre bookings. The report contains metrics on total negotiated savings as well as details, such as savings by booking type and travel provider. You can also read a Spotnana blog post about this report.

Note that this report only contains savings associated with Sabre-related bookings. When making non-Sabre bookings (e.g., booked via NDC), you may also receive savings and discounts due to company- and TMC-negotiated rates. However, these savings will not be presented in this report. 

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

• Negotiated Savings report
  • Filters
  • Sub-filters
    • To apply sub-filters
  • Parameters
    • Currency code
    • Name Format
  • Graph Metrics
    • Cumulative and Monthly Negotiated Savings
    • Negotiated Savings by Rate Type
    • Graph Visualization Controls
  • Table Grid Metrics
    • Spend, Savings & Discounts by Booking Type & Vendor Name
    • Negotiated Savings and Effective Discount by Vendor and Booking Type
    • Negotiated 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 Type - Type of travel (air, hotel, car, rail, limo).
• Transaction Type - Type of transaction (booking, cancellation).
• Rate Type - Type of rate associated with the transaction (published, company-negotiated, TMC-negotiated).
• Traveler Name - Name of the traveler associated with the booking.
• Traveler Cost Center - Cost center associated with the traveler.
• Vendor Name - Name of the vendor who supplied the traveler (e.g., ticketing airline, hotel chain, car rental company, rail vendor, limo rental company). 
• Policy Compliance - Whether the travel booking was in compliance with company travel policy. 
• Rate Code - The rate code that was applied to a transaction. 
• Traveler Tier - Tier associated with the traveler (VIP, Standard).
• Traveler Persona - Persona associated with the traveler (Employee, Guest - Profile, Guest - No profile).
• Traveler Designation - Work role designation associated with the traveler (e.g., 1092 - Accounting Clerk).
• Traveler Department - Department associated with the traveler.

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 Negotiated Savings report contains 3 info tiles (all values displayed are for the time period selected):

• Total Achieved Negotiated Savings: Total value of all negotiated savings for Sabre bookings.
• Achieved Negotiated Savings per Booking: Average negotiated savings per Sabre booking.
• Effective Discount: Total value of all negotiated savings for Sabre bookings represented as a percentage (e.g., 12%).

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

Cumulative and Monthly Negotiated Savings

• This left axis of this graph shows the Total Negotiated Savings. Air, Car, Hotel, and Rail are shown in different colors.
• The bottom axis of this graph shows the month in which the PNRs were created for the Sabre bookings.
• The right axis of this graph shows the Cumulative Savings (for all booking types). The value is represented by the black line. 

Negotiated Savings by Rate Type

• This is a pie chart showing the achieved negotiated savings for the Sabre bookings by rate type (e.g., Company-negotiated, TMC-negotiated) and booking type (e.g., hotel, rail).

Graph Visualization Controls

For a list of the controls that can be used in the graph visualization, see Analytic reports.

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.

Spend, Savings & Discounts by Booking Type & Vendor Name

This grid lists the Total Spend, Total Negotiated Savings, and Effective Discount, for each booking type and vendor. 

Negotiated Savings and Effective Discount by Vendor and Booking Type

This grid lists the Total Negotiated Savings, Effective Discount, and Number of Trips for each booking type (Hotel, Car, etc.), Vendor Name, and Rate Type.

Negotiated Savings Report

This table grid provides the following metrics:

• Trip ID
• Spotnana PNR ID
• Transaction Key
• Booking Type
• Transaction Type
• Vendor Name 
• Rate Type 
• Booking Source 
• Total Published Price (User Selected Currency) 
• Total Gross Price (User Selected Currency) 
• Total Gross Spend (User Selected Currency) 
• Total Negotiated Savings (User Selected Currency) 
• Total Effective Discount 
• Traveler Employee ID 
• Traveler Name 
• Trip Name 
• PNR Creation Date 
• Transaction Date UTC 
• Booking Mode 
• Active