Travel Analytics Update - Friday, 7 June 2019
Travel Analytics Updates
Friday, June 7 2019
The Travel Analytics development team have been busy pushing out changes within the Mark II travel reporting application. In this update, there is information on:
- Scheduled Reports
- Benchmarking
- Travel Analytics Terms of Use
Scheduled Reports
The scheduled reports feature is found within the Report’s menu below Download Reports. This feature allows users to schedule any of the downloadable reports within Travel Analytics.
To schedule a report, click on the ‘Add’ button within the table to open the scheduler.
Select Report Options
Click the customer drop down to select the customer or area of the business you want to send the report (i.e. Sales and Marketing).
Click the Report Type drop-down, select which report you wish to schedule (invoice, air segment, printable or summary reports - other fields will appear depending on which report you select); the Period drop-down, to set how often you wish to receive the report (weekly or monthly); and finally, the End Date picker to nominate when you wish to stop receiving the reports.
By default, the user's email address will be displayed as the recipient of the report. To add more users, simply select a person from the dropdown list provided or start typing to search for a person or email address.
Scheduled Report Security
Report recipients must be registered in Travel Analytics to receive a scheduled report. This is for security reasons as when a user profile is deleted from the application, any scheduled reports they have access to are also terminated.
Updating a Scheduled Report
You can amend or deactivate a scheduled report by clicking either the ‘edit’ or ‘deactivate’ options in the schedule reports table. Administrators will be able to view and update all scheduled reports within their area.
Benchmarking
Benchmarking is now available in Mark II. Benchmarking will only be made available to TMCs until we update our row-level security feature to allow data to be shared across customers within Mark II.
Setting Up Benchmarking
Before you can access to benchmarking, you first need to assign an industry to each customer within your agency.
To see if the customer is set up, navigate to benchmarking dashboard, select a customer and if they are not set up, the following message will display.
To set up a customer, click on the 'Settings' link in the alert message displayed on the screen (above).
Click on the edit link in the row displaying the customer data to open the dialogue box, then select the industry type from the drop-down options provided.
The industries within the list are compliant with international ISO standards.
Once you have selected the industry, click OK to save your selection.
You can now navigate back to the benchmarking dashboard and review the data.
Benchmarking Dashboard
The dashboard layout contains benchmarking data formatted in bar graphs and tables.
Bar Chart Data
The bar charts compare average online and offline air bookings costs, percentage policy compliance, average lost savings, percentage of changes, the average cost of booking changes and average booking lead in days.
Average air booking costs is the total cost of air travel inclusive of changes, additional collections, refunds and cancellations divided by the total number of bookings. If the original booking was made online, then it will be tagged as such no matter the number of offline changes made to the booking.
Policy compliance is based on the number of policy-compliant bookings i.e. lowest fare accepted.
Lost savings is the difference between the best fare and the fare purchased divided by the total number of bookings.
Booking changes is the number of changes (additional collections, exchange tickets) divided by the total number of bookings, and the cost of change is the average cost of these changes.
Booking lead in days is the total number of days between the departure date of the first air segment and the original ticket issue date divided by the total number of bookings.
Clicking on the bar charts will open a line chart comparing the customer and industry data over a rolling 12 month period (see below).
Booking Expenditure by Destination
The table displays the average online and offline cost of air bookings and booking volumes by destination.
By default, benchmarking provides data on the top five country destinations by expenditure as shown in the table below. Keep in mind the destination (country) is the turnaround point in the itinerary or the greatest distance from the departure city.
To view data for specific destinations (i.e. Australia, New Zealand etc.), click on the location filter and select the data you wish to display within the dashboard. When data is displayed for a specific location or between two locations, city pair data will display within the table as shown below.
Airfare Type Utilisation Benchmarking
In this table, we benchmark the airfare type booked by utilisation, changes and the average cost of change.
The airfare type is calculated on the class of travel on the longest segment within the itinerary. For example, if the following trip was booked: MEL/SIN(Y)/LHR(J)/SIN(J)/MEL(Y), the fare would be tagged as Business Class, as the longest segment is SIN/LHR and LHR/SIN and the class of travel is business.
If you apply the location filter, the data will refresh displaying airfare types for the criteria you have selected (see below).
Table displaying data with location filter set as 'Travel within Australia'
Table displaying data with the location filter set as 'Travel between Australia and the United Kingdom'
Travel Analytics Terms of Use
We have updated our terms of use for the Travel Analytics reporting application. The new terms are published on our Help Scout Page and include links to our privacy policy. In the coming weeks, we will release an update that will require users to read and accept our terms of use when they log into Travel Analytics.