Air Unused Credits report

Modified on Fri, 1 Nov at 12:48 PM

Unused Air Credits report

The Unused Air Credits 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 Credits report

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.
Traveler Tier - Tier associated with the traveler (VIP, Standard)

To apply sub-filters

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

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.
Select Include or Exclude depending on whether you want this sub-filter to include or exclude the values you select next.
You can search for a particular sub-filter value by using the Search field and clicking Go.
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.
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:

Click the Currency Code parameter.
Select the desired currency (or search for it).
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:

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

Graph Metrics

The Air Unused Credits report contains four info tiles:

Generated Credit Value: Total value of all air credits (used and unused).
Unused Credit Value: Total value of all air credits that have not yet been used (including expired credits).
Used Credit Value: Total value of all air credits that have been redeemed.
Expiring Next Month: Total value of all air credits that will be expiring in the next calendar month.

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.

Unused 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