Benchmarking Dashboard
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 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(
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 the location filter set as 'Travel within Australia':
Table displaying data with the location filter set as 'Travel between Australia and the United Kingdom':
