Event Analytics report

The Event Analytics report provides detailed metrics on events, organized into different groupings related to reconciliation and any air, hotel, rail, or car rental bookings associated with the event. The report can be used to reconcile financial data, track traveler locations and bookings and derive traveler safety insights.

The Event Analytics report will only contain data if the Events feature has been enabled and events have been created.

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

• Event Analytics
  • Filters
  • Subfilters
  • Parameters
  • Graph Metrics
  • Graph Visualization Controls
  • Table Grid Metrics
    • Reconciliation report
    • Air - Logistics report
    • Hotel - Logistics report
    • Car - Logistics report
    • Rail - Logistics 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 once you have selected a report to run and applied the main filters.

The sub-filters offered for this report are:

• Department - Department associated with the traveler.
• Cost Center - Cost center associated with the traveler.
• Traveler Name - Name of the traveler.
• Traveler Tier - Tier associated with the traveler (VIP, Standard).
• Traveler Persona - Persona associated with the traveler (Employee, Guest).
• Policy Compliance - Whether the booking was in or out of policy. 
• Event Name - The name of the event associated with the bookings. 

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

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.

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

The Event Analytics report does not have any graph visualizations.

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.

Reconciliation report

This grid lists general event-related details (not specific to a particular type of booking). 

• Event ID
• Event Name
• Organization ID
• PNR ID
• Trip ID
• Is Active
• Booking Type
• Transaction Type
• Traveler PID
• Traveler Name
• Traveler Email
• Traveler Phone Number
• Traveler Persona
• Confirmation Number
• Transaction Date
• Trip Creation Date
• Travel Begin UTC
• Travel Begin Local (timezone)
• Travel End UTC
• Travel End Local (timezone)
• Policy Reason Code
• Transaction Key
• Base Spend (User Selected Currency)
• Tax & Fee Spend (User Selected Currency)
• Gross Spend (User Selected Currency)

Air - Logistics report

This grid lists flight-specific metrics (e.g., airports and cabin classes) for event-related air bookings.

• Event ID
• Event Name
• Organization ID
• PNR ID
• Traveler PID
• Traveler Name
• Traveler Email
• Traveler Phone Number
• Traveler Persona
• Trip ID
• Confirmation Number
• Travel Begin UTC
• Travel Begin Local (timezone)
• Travel End UTC
• Travel End Local (timezone)
• Departure Airport Code
• Departure Airport Name
• Departure City Country
• Arrival Airport Code
• Arrival Airport Name
• Arrival City Country
• Operating Carrier Name
• Marketing Carrier Name
• Operating Flight Number
• Marketing Flight Number
• Segment Key

Hotel - Logistics report

This grid lists hotel-specific metrics (e.g., check-in times and room types) for event-related hotel bookings.

• Event ID
• Event Name
• Organization ID
• PNR ID
• Transaction Type
• Traveler PID
• Traveler Name
• Traveler Email
• Traveler Phone Number
• Traveler Persona
• Trip ID
• Confirmation Number
• Room Code
• Room Description
• Hotel Name
• Chain Name
• Hotel Address
• Hotel Location
• Hotel Phone Number
• Travel Begin UTC
• Travel Begin Local (timezone)
• Travel End UTC
• Travel End Local (timezone)
• Prepaid
• Transaction Key

Car - Logistics report

This grid lists car-specific metrics (e.g., pickup times and car rental companies) for event-related car rental bookings.

• Event ID
• Event Name
• Organization ID
• PNR ID
• Transaction Type
• Traveler PID
• Traveler Name
• Traveler Email
• Traveler Phone Number
• Traveler Persona
• Trip ID
• Confirmation Number
• Travel Begin UTC
• Travel Begin Local (timezone)
• Travel End UTC
• Travel End Local (timezone)
• Rental Company Code
• Rental Company Name
• Pickup Address
• Drop Address
• Car Type
• Number of Cars
• Number of Rental Days
• Transaction Key

Rail - Logistics report

This grid lists train-specific metrics (e.g., departure times and carriers) for event-related rail bookings.

• Event ID
• Event Name
• Organization ID
• PNR ID
• Traveler PID
• Traveler Name
• Traveler Email
• Traveler Phone Number
• Traveler Persona
• Trip ID
• Confirmation Number
• Travel Begin UTC
• Travel Begin Local (timezone)
• Travel End UTC
• Travel End Local (timezone)
• Vendor Name
• Travel Region Type
• Transaction Key