Lowest Logical Fare (LLF) report

This report provides information about missed or actual savings related to the lowest logical fare (LLF) for air bookings. This includes both high level data on missed and actual savings as well as more traveler- and booking-specific information on the impact of LLF and any potential savings.

This report will only contain data if the LLF feature has been enabled. For more information on LLF, see Lowest Logical Fare - Overview.

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

• Lowest Logical Fare (LLF) report
  • Filters
  • Subfilters
    • To apply sub-filters
  • Parameters
    • Currency code
    • Name Format
  • Graph Metrics
  • Table Grid Metrics
    • (Missed) Savings by Traveler in the Last 90 days
    • Transaction Report

Filters

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

Subfilters

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

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

The sub-filters offered for this report are:

• Policy Status - Denotes whether the booking was in or out of compliance with policy. 
• Approval Type - Indicates the type of approval applied to the booking (soft or hard).
• Approver Name - Name of the person who approved the booking.
• LLF Route - The route or itinerary suggested by the LLF calculation.
• Selected Route - The route or itinerary suggested by the LLF calculation.

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 metrics shown in this section are arranged in large tiles. A description of each is provided in the table below.

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.

(Missed) Savings by Traveler in the Last 90 days

This grid lists LLF-related data per traveler. The main information presented is either missed savings or savings as a result of lower-than-LLF bookings.

• Traveler Name
• Missed Savings (User Selected Currency)
• Lower-than-LLF Savings (User Selected Currency)
• Time Saved (mins)
• % of Travel in LLF
• LLF Cost (User Selected Currency)
• Selected Cost (User Selected Currency)
• LLF Total Trip Time (mins)
• Selected Trip Time (mins)
• LLF Num Layovers
• Selected Num Layovers
• Unique PNRs

Transaction Report

This report contains detailed data about bookings, comparing LLF itineraries with the itineraries selected by travelers and displaying both missed and lower-than-LLF savings.

• Transaction Date
• Trip Name
• Policy Status
• OOP Reason Code
• Traveler Name
• Traveler Email
• Traveler SIO Code
• Traveler Employee ID
• Approver Name
• Approval Type
• Selected Route
• LLF Route
• Selected Fare Cost (User Selected Currency)
• LLF Cost (User Selected Currency)
• Missed LLF Savings (User Selected Currency)
• Lower-than-LLF Savings (User Selected Currency)
• Selected Trip Time (mins)
• LLF Trip Time (mins)
• Missed Trip Time Savings (mins)
• Layover Count - Selected
• Layover Count - LLF
• Selected Layover Time (mins)
• LLF Layover Time (mins)
• Missed Layover Time Savings (mins)
• Selected Airlines
• LLF Airlines
• Selected Source
• LLF Source
• Selected Travel Begin Date UTC
• LLF Travel Begin Date UTC
• Selected Travel End Date UTC
• LLF Travel End Date UTC
• Selected Cabin (per leg)
• LLF Cabin (per leg)
• Spotnana PNR ID