Event Analytics report

Modified on Fri, 05 Apr 2024 at 10:53 AM

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

Filters

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

Subfilters

This report does not have any subfilters. 

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.

MetricDescription
Total event spendTotal amount spent on all event bookings for the time period selected.
Air event spendTotal amount spent on all air bookings related to events for the time period selected.
Hotel event spend
Total amount spent on all hotel bookings related to events for the time period selected.
Car event spendTotal amount spent on all car rental bookings related to events for the time period selected.

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article