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.

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.

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.

Welcome to Travel Analytics

Welcome to Travel Analytics.  We are into our third year of existence, and we thought it was time to create a blog for our rapidly expanding customer base.

And we have plenty to talk about, including: functionality updates, dashboards enhancements, improved code and queries, API integrations, customer data integrations, and plenty tips on how to get the most out of Travel Analytics.

So to keep up to date with the latest, subscribe to the blog and new posts will be sent straight to your inbox as they are published.

Enjoy the blog!