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!


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).

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.

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.

Carbon Emission Reporting

Air travel carbon emission reporting is now available to customers with access to the Air Segments dashboard in a downloadable Excel report.  CO2 emissions are shown in kilograms for each flight (or segment) which we calculate using methodology published by the International Civil Aviation Organisation (ICAO) and data sourced from the International Air Transport Association (IATA).

The starting point for calculating emissions is to calculate the circle distance between the city pairs (segments) provided by the Travel Managers in their air segment data.  Segments are then split into three categories: short, less than 550 km; mid, between 550 and 5500 kms; and long haul, greater than 5500 kms.  These categories are used to calculate fuel consumption, as fuel burn ratios are much higher on shorter flights than longer ones.

Extract of the Excel download displaying carbon emission data for individual flight segments

We also factor in a difference between economy and premium class travel for mid and long haul flights but not short haul, as most short duration flights  operate the one class (economy).  Finally, we factor in passenger load data published annually by IATA, however, we do not take into consideration the type of aircraft, as in most cases, the data.

Budget Tracking

The ability to track spend against a travel budget has been around for some time in Travel Analytics.  However, the feature was virtually unknown to most users, due to the complexity of setting it up in the system.

Fortunately, the introduction of Report Hierarchy has simplified the set up, providing customers the opportunity to take advantage of this great feature.

To activate budget tracking, administrators only need to add a figure in the budget column against each cost centre when they are setting up or modifying the customers report hierarchy.

To view the results, users simply navigate to the cost centre dashboard and the data is displayed within the headlines.  It’s pretty easy to determine how budgets are tracking; if the spend is within budget, the amount is shown in black, and if it’s over, it displays in red.

Cost Centre dashboard displaying Budget data

Adjusting the dates on the dashboard, will display a prorated amount for that period.  And using the region and division filters, allows users to drill down to determine how different areas of the business are tracking against budget.