Rail Split Tickets report

When booking rail travel, travelers can sometimes significantly reduce the cost of the booking by splitting it into multiple tickets. The Rail Split Tickets report provides insights about the savings generated by selecting split tickets for rail bookings. The sub-filters in this report can be used to restrict the data you see to specific travelers, departments, and events.

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

• Rail Split Tickets report
  • Filters
  • Subfilters
    • To apply sub-filters
  • Parameters
    • Currency code
    • Name Format
  • Graph Metrics
    • Graph Visualization Controls
  • Table Grid Metrics
    • Split ticket transactions

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 once you have selected a report to run.

The sub-filters offered for this report are:

• Traveler Name - Name of the traveler.
• Legal Entity - Legal entity associated with the traveler.
• Department - Department associated with the traveler.
• Cost Center - Cost center associated with the traveler.
  
• Vendor name  - The carrier associated with the rail booking.
• Travel Region Type - Type of travel (domestic or international).
• Policy Compliance - Whether the travel was in or out of policy.
• Traveler Tier - Tier associated with the traveler (VIP, Standard).
• Traveler Persona - Persona associated with the traveler (Employee, Guest - Profile, Guest - No profile).
• Host Email 
• Event ID - ID of the event associated with the rail booking.
• Event Name - Name of the event associated with the rail 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 metrics shown in this section are arranged in large tiles. A description of each is provided in the table below.

Graph Visualization Controls

For a list of the controls that can be used in the graph visualization, see the Graph Visualization Controls section of 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.

Split ticket transactions

This grid lists details for split ticket transactions, which can be used for reconciliation purposes. The information shown is:

• Transaction Type
• Trip Name
• Trip ID
• Traveler Name
• Traveler Email
• Organization Name
• Legal Entity
• Legal Entity External ID
• Office Name
• Department
• Cost Center
• Traveler Persona
• Designation
• Traveler Tier
• PNR Booked By
• Travel Region Type
• Journey Type
• Routing
• Vendor Name
• Confirmation Num
• E Ticket Numbers
• Collection Numbers
• Transaction Date UTC
• Charged Date UTC
• Travel Begin Date UTC
• Travel End Date UTC
• Policy Compliance
• OOP Reason Code
• OOP Reason Description
• List of Policies Violated
• Policy Violation Details
• Policy Group
• Credit Card Number
• Credit Card Labels
• Rate Type
• Rate Code
• Rate Source
• Billing Currency Code
• Active, Spotnana PNR ID
• Transaction Key
• Host Name
• Host Email
• Event ID
• Fare Composition Outbound
• Fare Composition Return
• Rail Card Applied
• E Ticket Available
• Total Gross Price
• Total Published Price
• Total Base Spend
• Total Tax & Fee Spend
• Total Gross Spend
• Total Split Ticket Savings
• Total Gross Price (Billing Currency)
• Total Published Price (Billing Currency)
• Total Base Spend (Billing Currency)
• Total Tax & Fee Spend (Billing Currency)
• Total Gross Spend (Billing Currency)
• Total Split Ticket Savings (Billing Currency)
• Total Distance Miles
• Total CO2 Emissions (kg)