CO2 Emissions report

The CO2 Emissions report provides insights on the carbon dioxide emissions produced by your air and rail travel bookings. The metrics presented are aggregated across all air and rail bookings as well as being broken down by travel vendor, traveler, and traveler department. Detailed transaction level information is also provided. 

Carbon emissions on air bookings are only provided starting from August 2023. For rail bookings, this information is provided for travel dates beginning in November 2023. There is currently no carbon emissions information in this report related to rental car bookings. 

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

• CO2 Emissions report
  • Filters
  • Sub-filters
    • To apply sub-filters
  • Parameters
    • Currency code
    • Name Format
  • Graph Metrics
    • CO2 emissions over time
    • CO2 Emissions (kg) by travel vendor
    • CO2 Emissions (kg) by traveler department
    • CO2 Emissions (kg) by traveler
    • Graph Visualization Controls
  • Table Grid Metrics
    • Detailed CO2 Emissions 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).
• Booking Source - Distribution source through which the travel booking was made (e.g., Sabre, NDC). 
• Booking Platform - The platform on which the booking was made (e.g., App, Web).
• Policy Compliance - Whether the travel booking was in compliance with company travel policy.
• Traveler Cost Center - Cost center associated with the traveler.
• Traveler Department - Department associated with the traveler.
• Traveler Designation - Work role designation associated with the traveler (e.g., 1092 - Accounting Clerk).
• Traveler Name - Name of the traveler associated with the booking.
  
• Traveler Persona - Persona associated with the traveler (Employee, Guest - Profile, Guest - No profile).
  
• Traveler Tier - Tier associated with the traveler (VIP, Standard).
• Vendor Name - Name of the vendor who supplied the traveler (e.g., ticketing airline, hotel chain, car rental company, rail vendor, limo rental company). 

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 CO2 Emissions report contains 5 info tiles (all values displayed are for the time period, organization, and legal entities selected in the filters):

• Total CO2 Emissions (kg) - Total amount of CO2 emissions produced in kilograms.
• Air CO2 Emissions (kg) - Total amount of CO2 emissions produced by all air bookings expressed in kilograms.
• Rail CO2 Emissions (kg) - Total amount of CO2 emissions produced by all rail bookings expressed in kilograms.
• Air CO2 Emissions (kg) per trip - The average amount of CO2 emissions produced per trip by air bookings expressed in kilograms
• Rail CO2 Emissions (kg) per trip - The average amount of CO2 emissions produced per trip by rail bookings expressed in kilograms.

The CO2 Emissions report contains 4 graphs. The values shown are for the time range, organization, and legal entities specified in the filters.

CO2 emissions over time

• The left axis of this graph shows the CO2 emissions in kilograms. Air and rail are shown in different colors.
• The bottom axis of this graph shows the month in which the travel bookings occurred.

CO2 Emissions (kg) by travel vendor

• This is a bar graph showing the CO2 emissions in kilograms grouped by the vendor associated with the travel booking (e.g., airline or rail provider).

CO2 Emissions (kg) by traveler department

• This is a bar graph showing the CO2 emissions in kilograms grouped by the traveler's company department associated with the travel booking (e.g., airline or rail provider).

CO2 Emissions (kg) by traveler

• This is a bar graph showing the CO2 emissions in kilograms grouped by the traveler associated with the travel booking (e.g., airline or rail provider).

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.

Detailed CO2 Emissions Report

This table grid provides the following metrics:

• Booking Type
• Transaction Type
• Confirmation Number - Ticket number for air travel, confirmation number for rail travel 
• Transaction Date UTC 
• CO2 Emissions (kg) 
• Traveler Name 
• Traveler Email 
• Traveler Org Name 
• Trip ID 
• Trip Name 
• Spotnana PNR ID 
• Travel Begin Date UTC 
• Travel End Date UTC 
• PNR Creation Date UTC 
• Trip Creation Date UTC