Advance Purchase Drill Down

Last night we released an update, which allows users to drill down into the Air Segments Advance Purchase graph and the Average Ticket Price Comparison to Lead in Time graph in the Air Spend dashboard.

This feature allows users to understand the relationship between the types of fares booked (i.e. fully flexible and restricted economy airfares) and how far ahead travel is booked.  The hypothesis is, the closer you book to the departure date, the more expensive the fare will be i.e. travel will be in a higher fare class.  Now you can test this.

Click on the Bars

When you click on the bars within the graphs, the drill down refreshes to display the fare type description.  You can then click on the fare type description to display the actual class of travel (see below).

Days Booked in Advance graph as it appears in the Air Segments dashboard. Clicking the bars refreshes the data within the graph to display the class of travel (next graph).
Drill down displaying the fare type description.
Drill down displaying the class of travel booked.

The Air Segments data is based on individual segments within the itinerary, and the Air Spend data is based on the first segment of the ticket.

Pretty cool eh!

Benchmarking Dashboard Update

A big fortnight for the Travel Analytics team with the release of a new benchmarking dashboard.  The new dashboard is packed full of great features, including clickable events, trends graphs, improved average booking cost benchmarking and a range of informative metrics.  Here is a bit of an overview of what is available.

New Metrics

The new dashboards contain really cool and informative metrics, designed to show your customers how well they are managing their travel.  Within the one dashboard, they can see how much they have saved by booking online; how compliant they are to policy, where they have selected the cheapest fare (or not); their average lost savings, difference between the best fare and the fare selected by the customer; discount fare utilisation, percentage of restricted fares they book; number of changes they make and the average cost of these changes, including exchange tickets, airline charges etc.; and the average booking lead in days.

We have also included hover text on the headings to provide information on what the data means.  For example, Average Online Air Booking Cost is the total air spend, including original, exchange, and refund transactions, divided by the number of unique bookings booked online.  This will help your customers understand the data they can see on the dashboard.

Clickable Events

The new headline data also contains clickable events.  When you click on the heading, a window opens displaying the last 12 months of data benchmarking the customer’s data to other clients (see below).  This is a great feature, allowing customers to track specific metrics across an extended timeframe.

New Benchmarking Tables

We have also overhauled the benchmarking tables.  City pair (domestic) and destination (international) metrics have been improved to display data at the booking level, not the ticket.  Now the data is inclusive of the original ticket cost and subsequent costs resulting from changes to the booking.

Booking volumes information also provides perspective on where customers can focus their attention when reviewing their travel patterns.

The new dashboard includes a table that looks at the types of fares your customers are booking, how often they change them and the average cost of the change.  This information is extremely handy for customers weighing up the value of flexible fares and how often they are actually changing them.  No doubt this particular table will spark a few interesting debates within some organisations.

The final table in the new dashboard is accommodation.  Nothing much has changed from the last version, except we show the difference in average nightly rate between online and offline.  Looking at the results of our testing, it appears as if most online users are looking to reduce accommodation costs as well as their flight costs.  Another ticket in the box for going online.

Activating the Benchmarking Dashboard

Administrators activate the new dashboard by navigating to Report Settings and activating the benchmarking dashboard.  This can be done for all customers or individual customers or customer groups depending on your requirements.


This week we released a new feature allowing you to unmerge data previously merged in Travel Analytics.  The new feature applies to traveller, travel booker, policy code and service fee data only.

To check it out, navigate to data editing and select one of the tabs above.  Look up the data you wish to unmerge, and click on the ‘unmerge‘ link.

Select the options you wish to unmerge – you can select more than one – then click the unmerge button and the system will process your request.

Once you have unmerged the data, you can then remerge it with other data if you need to.  This feature is only available to system administrators.

Latest Updates

Client Name in Registration Email

Invitations sent to customers inviting them to access Travel Analytics, now include the TMC name (‘[TMC name] Reporting’) in the first line of the email.  This allows the customer to associate the TMC to Travel Analytics so they don’t think we are a bunch of spammers trying to hack into their system!

Travel Analytics invite message featuring the TMC Name (Demo Reporting)

Segment Sequence for Air Segments (Excel download)

Our latest deployment contains a number of enhancements to Excel downloads.  Air Segments downloads now contain a booking sequence column.  This enhancement allows users to sort data by the booking reference and the order of the itinerary (booking sequence).

Customers are going to love this, as it allows them to quickly work out the types of fares being booked for each segment of the itinerary.  Finally, we can track who is booking restricted on outbound and flexible on the inbound.  Changes next…..

Air Segments Excel data showing the Booking Sequence Number

Duration in Car and Hotel Excel downloads

Hotel and car hire Excel downloads now contain a duration column.  This saves your customers doing calculations to work out how long they have stayed at a hotel or hired a car for.

Even better, where the data contains the date and time, we have updated the code to calculate an additional day for car rentals that exceed the 1 hour grace period.

Country Name in Excel downloads

We have added Departure and Arrival countries to city names to Air Segments and Air Spend Excel data downloads.  This is designed to assist those of us that don’t have a good grasp of Geography, and lets face it, who does?

Global Dashboard Screenshot Phased Out

This deployment we bid farewell to the Global Dashboard Screenshot.  While it has served many of us well, the deployment of the SME report has made it obsolete.

Fare Configuration – New Feature

We have just released a great new feature which enables you to configure airfare categories (i.e. Business, Flexible Economy, Restricted Economy etc.) by airline, class of travel, fare basis, location or a combination of the above.

We all know the US has two classes of travel: First and Coach (or economy).  When we travel to the US on a business class flight, internal US sectors, are in most cases, booked in P or F class, the default airfare class for First Class category.

While us industry types know it’s business and not first, the customer is not always that well informed, and the words ‘First Class Travel’ in a report is guaranteed to put the cat among the pigeons, resulting in a stream of ‘Please Explain’ emails from the customer asking why people are travelling first class.

Enter fare types configuration………

This feature allows administrators to look up and categories airfares that fall outside the standard defaults.  And it is really simple to do.

Start by navigating to data editing and clicking on the Fare Type tab.  Within the table you will see six columns: Airline, Origin and Destination Country, Fare Basis, Fare Class and Fare Type (see below).

Click on the Add button, and a form opens.  This is where you apply the magic.

Here are a couple of scenarios to explain how it works.  The first, P class airfares on American Airlines within the USA.  In the form, select the airline (American Airlines), Origin and Destination Country (USA), Fare Class (P), and the Fare Type you wish to categorise the fare as; in this case Business Class.  Click ‘Add’.

Now all American Airlines F class fares for travel within the USA will be categorised as Business Class instead of the default First Class.  Pretty cool eh!

In the next example, we are going to be a bit more generic and categories JetStar P class fares as Restricted Economy across all markets.

All we need to do is look up the airline (Jetstar), and the Fare Class (P), then select the Fare Type, in this case Restricted Economy, click Add and your done.

If you need to be really specific, then you have the option to select a fare basis.  In most cases you won’t need to do this, unless there are specific fares where the fare class is outside the norm or you want to add specific fare types (categories).

Travel Analytics Updates

We deployed a new version of Travel Analytics earlier this week to introduce a few new features.

SME Report Update

Customers with Trans Tasman trip types enabled will now see Trans Tasman Air, Hotel and Car spend data in the SME report.  Corporate Logo’s will also appear on the report.

Air Segment Dashboard

We have updated the trip type filter on the Air Segments dashboard to display Domestic and International trip types only.

The calculation we use to determine destinations – a stopover greater than 24 hours – does not differentiate between Trans Tasman and International itineraries.  As a result, the previous trip type configuration displayed all international trips even if Trans Tasman was selected as the trip type.

Confused?  Great, and so were users, and we are not surprised, particularly when China, USA and Singapore were displayed as Trans Tasman destinations.  Sanity prevails and our support queues will be better for it.

Preferred Suppliers

A bug fix has been applied to allow administrators to set up preferred suppliers again.  Good news it that we are working on an enhancement to this feature to make it really easy for administrators to manage this.

Next Deployment

We have a great new feature coming up in the next deployment which allows administrators to categories fare types based on country settings.  This is really cool for markets like the US where they only have first and economy class.  Administrators will be able to configure Travel Analytics to display F and P class (first class) segments as business where the trip starts and ends within the US.  No more customers calling wanting to know who is travelling is 1A.  More on in a fortnights time when we release the update.

Update to Roles in System Users

We have updated System Users role names to provide administrators a better understanding of what users have access to when they are set up in Travel Analytics.

Administrator (Access All Areas)

Users has access to all areas of the application, including administration modules and reporting dashboards.

Administrators are able to adjust report settings, edit data (using data editing), invite subscribers to access Travel Analytics and update their Report Hierarchy.

Client Administrator (Access All Areas with Client Branch)

User has access to all areas within the client branch (i.e. Demo Site, Movetech New Zealand etc.), including administration modules and customer dashboards.

Customer Group (Administrator Access – All Hierarchy Levels)

User has access to all areas within a group of customers, including administration modules and the customer dashboards.  For example, Movetech Technology, Movetech Research and Movetech Operations within the Movetech Group.  Customer Groups are set up using the Data Editing feature.

Customer (Administrator Access – All Hierarchy Levels)

User has access to all areas within the nominated customer, including administration modules and the customer dashboards.

Customer Group (Report Access Only – All Hierarchy Levels)

User has access to reporting dashboards within a customer group across all reporting hierarchy levels.

Customer (Reports Only – All Hierarchy Levels)

User has access to reporting dashboards at a customer level across all reporting hierarchy levels.

Customer (Report Access Only – Restricted by Region)

User has access to reporting dashboards at a customer level for a nominated region within the report hierarchy.

Customer (Report Access Only – Restricted by Division)

User has access to reporting dashboards at a customer level for a nominated division within the report hierarchy.

Customer (Report Access Only – Restricted by Cost Centre)

User has access to reporting dashboards at a customer level for a nominated cost centre within the report hierarchy.

Customer (Report Access Only – Restricted by Travel Booker)

User has access to reporting dashboards at a customer level for bookings made by a nominated Travel Booker.


New Features

We completed a major deployment overnight which includes the following new features:

Scheduled Reports

You can now schedule an automated monthly, quarterly or annual report using the new schedule report feature.  When you click on the download button, the pop up dialogue box now has a new ‘Schedule Report’ button (see below).

If you click on the button, another dialogue box will open displaying the options available to schedule a report (see below).

Once you have made your selections, the report scheduler will send you an email confirming your request.  Scheduled reports will be automatically emailed to the recipient within five days of the end of the month.

Finally, to assist with keeping track, a list will appear below the scheduler with the reports you have scheduled including the customers email address, report name and report expiry date.

SME Report

To coincide with the schedule report feature, we have introduced a new SME report.  The report is a simple one pager designed to update customers on their travel spend for the previous month across each spend category.  The report also compares the spend to the previous period 12 months ago and provides a running Year to Date total.

Customer Groups and Customers

Groups of customers can be assigned to a customer group.  This allows you to report on the customer group and individual customers within a group.  For example, if Movetech Australia and Movetech New Zealand were set up as individual customers (or debtors), then you have the option to create a group (Movetech Group) to link the spends together.  This is great feature where the customer requires consolidated reporting across all businesses as well as reporting for individual businesses.

Customer Group displaying grouped customers, Movetech Australia and Movetech New Zealand.

Furthermore, Travel Analytics is designed to display information only when it is available.  Therefore, if a customer has regions and divisions in their report hierarchy, all of these fields will display on the dashboard.  However, if the customer only has divisions in their hierarchy, then the regions will be hidden from view.

Selecting Movetech Australia from the Customer drop down automatically hides the region drop down as it is not included in the hierarchy.

Travel Analytics Help

Many users of Travel Analytics are not aware of the help resources available within the application.  To find help, click on the hamburger (menu) and you will see help right at the bottom of the menu list.  Clicking Help opens a new tab in your browser displaying the following page.

Help contains FAQs, videos and articles on a range of topics related to Travel Analytics.  You can also type key words into Search to find information about the topics you are interested in.  We update Help regularly, however, if there is anything missing, send us an email at support and we will add it for you.