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!

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.

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.

Update to Air Segments Dashboard

We have deployed an update to the Air Segments dashboard to display the number of international segments in the Airline Market Share and Air Ticket Class graphs.

Previously, the graphs displayed the number of trips based on the destination or turn around point of the itinerary.  This reduced the number of segments displayed in the airline market share and fare class graphs, which confused users expecting to see more segments than trips.

As an example, a trip to the USA (Melbourne to Sydney to Dallas Fort Worth to Washington to Dallas Forth Worth to Melbourne) would have previously displayed as the one trip across all of the graphs.  Now the same trip will display as five segments in the Airline Market Share and Air Ticket Class graphs, and one trip in the Advance Purchase and Destination graphs.

Number of Trips by Destination Graph displaying the number of trips to Countries. Clicking on the bars will drill down to display the destination (or turn around point) of the trip.
Number of Segments by Class of Travel graph displaying the number of segments for travel to and within the USA.  Note how the total number of segments is greater than the number of trips in the destination graph above.

The update also adjusts how international and domestic flights are treated.  Using the itinerary above as an example, the dashboard will now display the Melbourne to Sydney as a domestic segment.  However, in the Excel download, it will appear as international, if the domestic segment is booked as part of an international itinerary.

The Cost of Changes

When a change is made to a booking requiring the ticket to be reissued, most travel management mid office systems have the ability to tag the transaction as an exchange or an additional collection (adcol).  If they can do this, and more often that not they can, we are able to update the original policy code to ‘Exchange Ticket’ when we import data into Travel Analytics.

Identifying exchange tickets in this manner, allows Travel Analytics to display the data in the policy compliance chart within the Global Dashboard, making it simple for the customer to find information on changes.

Moreover, when the customer clicks on the Exchange Ticket segment within the chart, a table opens with a list of all the changes, including: booking reference, traveller name, airline and the cost.  And they can even download the data into Excel.

It is a great feature, and a fast way for customers to access the data they required to understand the cost of changes to the business.

Semi Colon

This is not a grammar lesson but a great tip on how to send downloadable reports to more than one person at the same time.

In the email field within the Report Download Request dialog box, you can enter multiple email addresses by separating them with a semi colon.  For example:;;

Saves downloading the report multiple times or forwarding the report onto your customers or colleagues after you receive it.

Spend by Hotel Download

The accommodation dashboard has two options to download data. The first is the Accommodation Spend Data download, which provides a comprehensive data set if you want to do a warts and all interrogation of the customers hotel data.

However, if you only want a summary of the spend, including: location, hotel name, room nights, spend, average nightly rate and preferred flag, then look no further than the second option – Spend by Hotel Excel download.

It is a great way to get the data you require quickly without having to set up pivot tables to do it.

Printable Report Update

We recently released an update to Printable Reports which enables users to run report by region and division.

This update assists Travel Managers who need to provide organisations printed reports across multiple areas of the business i.e. Region and Divisions.

To utilise this feature, navigate to the Global Dashboard and set the on screen filters to display the data you need in the report.  Click the download button, and select Printable Report from the report (type) drop down in the download box that appears on screen.

Screenshot displaying filter settings which can be used in the downloadable printable reports

When you click Submit, the request will be queued and the report emailed to you once it is processed.