Unused Air Credit report

The Unused Air Credit report provides detailed metrics on unused credits associated with air travel for the travelers within your organization. 

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

• Unused Air Credit report
  • Filters
  • Subfilters
    • To apply sub-filters
  • Graph Metrics
    • Value of Credits Generated and Redeemed by Airline
    • Usused Credit Creation and Usage Over Time
    • Graph Visualization Controls
  • Table Grid Metrics
    • Travelers with the most unused credit
    • Travelers with the most redeemed credit
    • Detailed Credit Transaction Information

Filters

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

Subfilters

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:

• Traveler Name - Name of the traveler associated with the unused air credit.
• Legal Entity - Legal entity associated with the unused air credit.
• Traveler Office - Travel office associated with the unused air credit.
• Credit Type - The type of credit that has been issued. 
• Booking Source - The booking source associated with the unused air credit.
• Expiry (Expiration) date - The expiration date of the credit that has been issued. 
• Issued Date - The date on which the air credit was issued. 

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.

Graph Metrics

The Air Unused Credits report contains two graphs:

Value of Credits Generated and Redeemed by Airline

• This left axis of this graph shows the Total Credit Amount (for the time range, organization, and legal entities specified in the filters). Used and open credits are shown in different colors.  
• The bottom axis of this graph shows the Issuing Carrier IATA code for each of the the airline carriers who issued the credits.

Usused Credit Creation and Usage Over Time

• This left axis of this graph shows the Total Credit Amount (for the time range, organization, and legal entities specified in the filters). Used and open credits are shown in different colors.  
• The bottom axis of this graph shows the Weekly Issued Date (the specific week in which the credits were issued or used).

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.

Travelers with the most unused credit

This grid lists the travelers within your organization who have the most unused credits. The information shown is:

• Travler Name
• Total Credit Amount
• Number of Credits

Travelers with the most redeemed credit

This grid lists the travelers within your organization who have redeemed the most credits. The information shown is:

• Travler Name
• Total Credit Amount
• Number of Credits

Detailed Credit Transaction Information

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

This table grid provides the following metrics:

• Trip ID
• Trip Name
• Traveler Name
• Credit Type
• Credit Status
• Billing Currency
• Total Credit Amount (Billing Currency)
• Total Credit Amount (USD)
• Issuing Airline
• Source Reference
• Booking Source
• Credit Issue Date
• Credit Expiry (Expiration) Date
• Organization Name
• Traveler Tier (Seat 1A, Standard)
• Credit Number
• Transaction Key