Overview

TripBuilder Analytics is the business intelligence module of TripBuilder that gives you instant access to consolidated data. It supports users with making smarter, data-driven decisions thanks to built-in data dashboards with interactive visualisations.

Feature Highlights

Interactive KPIs and data visualisations
Insights into all aspects of TripBuilder
Export functionality (PDF, CSV)
Fully integrated into TripBuilder (part of Cockpit)

Base Analytics Laptop 2.gif

How to get TripBuilder Analytics?

TripBuilder Analytics comes in three variations:

Base Analytics: included in all non-legacy plans. Offers general analytics of bookings, components, and the inventory.
Advanced Analytics: a paid add-on for non-Enterprise plans. Included in the Enterprise plans. Offers advanced versions of booking and component reports with filtering by travel agency or distribution channel, and provides additional dashboards.
Custom Analytics: custom dashboards according to your requirements. Subscription is per custom dashboard. Comes with a setup fee.

If Base Analytics is not available in your Cockpit, you might still be on a legacy plan. Please check with our support.

Pricing information is available at the Nezasa website.

The Available Analytics Dashboards

Base Analytics

Dashboard	Description
Booking Performance	Provides metrics related to itinerary creation, bookings, booking changes, and cancellations. Filters: date range
Components	Provides metrics related to booked components with drill-downs per component type. Filters: date range
Inventory	Provides metrics related to your Cockpit inventory data: growth of your inventory, entities by status, and more. Filters: none

Advanced Analytics

Dashboard	Description
Best Seller Products	Provides statistics in regards to best selling / most booked products (templates, modules, accommodations, activities, rental cars, transfers, upsell items, insurances) with product-specific KPIs as well as drill downs. Filters: distribution channels, travel agencies, and other filters depending on the product type such as supplier, booking date, or service start date.
Booking KPIs	Provides many KPIs of booked itineraries (PAX, components, cancellation rates, ...) and can be filtered freely along many dimensions. Filters: booking date, departure date, return date, distribution channels, travel agencies, source markets, destinations
Booking Performance	Provides metrics related to itinerary creation, bookings, booking changes, and cancellations over time. It also provides YoY visualizations and performance comparisons of last 28d and last 365d to the previous period. Filters: date range, distribution channels, travel agencies, source markets, destinations
Components - Advanced	Provides metrics related to booked components with drill-downs per component type and source (i.e., supply system). Filters: initialization date, start date, end date, distribution channels, travel agencies, supply system, destination country
Distribution Channels	The report allows you to compare the performance of your distribution channels in terms of itinerary creation, bookings, and cancellations. Filters: date range, distribution channels
Markets	This dashboard offers performance comparison of source and destination markets in terms of sales volume, cancellation ratios, time-to-book, and many more dimensions. Filters: booking date, departure date, return date, distribution channels, travel agencies, source markets, destinations
Supply Connections	It provides metrics related to the booking audit events, which store the requests sent to supply systems. Therefore, it helps to find instabilities coming from external systems or the integration with them. Filters: date range, supplier, component type, event type
Travel Agencies	The report allows you to compare the performance of your travel agencies in terms of itinerary creation, bookings, and cancellations. Filters: date range, travel agencies
Users	This report offers an overview of various aspects of your B2B user base, including user profiles and statuses, agencies with the most users, and login statistics. Filters: user profile, user status, created timestamp, last logged timestamp, number of logins, travel agency id and name

Remark: customers using Advanced Analytics also have access to theBase Analytics dashboards.

Advanced Analytics - Raw Data

Available with a subscription for “Advanced Analytics”. It offers dashboards with a simple table exposing the raw data for key model entities of TripBuilder’s analytics data and, as such, allows a CSV download of that data. The following model entities are supported:

users
travel agencies
itineraries
components

The dashboards have various filters specific to the underlying model entity. All columns of the CSV are explained on the “Documentation” tab of the dashboard.

Remarks:

You must use the "download option" on the table itself, not the one of the dashboard.
Due to the raw nature of the data, some data might show different values than those used in the Customer Care UI. For example, itinerary status.
Multi-language fields: if available, the report always uses the English value of multi-language fields. Otherwise, the value of whichever language was available is used by the raw data tables.

Marketplace Analytics

Marketplace Analytics are dedicated to our marketplace operator partners exclusively. They are listed here for the sake of completeness.

Dashboard	Description
Components	The list of components booked from the marketplace operator.
Companies	The list of companies booking from the marketplace operator.

User Guide

This user guide provides an overview of the most important functional features available in your dashboards.

A) Browse through the dashboard pages. They are generally used to provide dashboards in different reporting currencies. Furthermore, every dashboard has a “Documentation” page that provides details such as what the dashboard is about, data update schedules, and the change history.
B) The Controls provide the filters. Click on it to open the filter drawer to control interactively what data is shown by the dashboard’s visualizations.
C) Hit the Reset to set all filters to their original values.
D) Print or Download the dashboard as PDF. Hint: the PDF generation takes a moment. Stay on the page and use the “View Exports” in the menu to see the generated exports.
E) View the source data used by a specific visualization or download the data as CSV.
F) By hovering over a visualization with your mouse, you can view details of the data points.
G) Click on “Dashboards” in the breadcrumbs to get back to the list of all available dashboards.

H) Click on the date/time dimension to drill up/down (quarter / month / week / …)

Feedback & Feature Suggestions

Please use the Bucket List on the support portal to share your ideas and suggestions or upvote other user's ideas.

Frequently Asked Questions (FAQ)

When is the Analytics data refreshed?

Data is cached for improved usability and updated at least daily.

The data refresh for all TripBuilder Analytics dashboards happens daily between 2:00 AM and 6:00 AM CET. Consult the tab “Documentation” of the dashboards to learn about their data update schedules.

Why do I see "No Data" for some visualisations?

The two most common causes to see a "no data" message by a visualisation are:

No source data: the visualisation relates to an entity the underlying TripBuilder instance is not using. E.g., there are no highlights created in the TripBuilder instance, therefore the inventory report will show "No data" for the amount of highlights in the instance.
Filters: you might have set filters that limits the data set such that no more data can be visualised. Try to change or reset your filters, see chapter "User Guide" above.

What reporting currencies are supported?

TripBuilder Analytics supports our official accounting / contract currencies CHF, EUR, USD, and GBP.

How are the reports converted into different reporting currencies?

The currency conversion happens on itinerary-level within the data pipeline, and thus before the data reaches the business intelligence tool responsible for generating the report.
The conversion rates are sourced from the service CurrencyLayer once a month and stored in the data warehouse.
The lookup for the currency exchange rate is based on the original currency of a given price and the most appropriate timestamp for the given price. Examples: the timestamp of the booking completed event to calculate the initial price of the booking in different currencies, the timestamp of booking change completed for the price difference caused by the booking change, and so on.

What languages are supported by Analytics?

TripBuilder Analytics is only available in English.

Who can access TripBuilder Analytics?

Only company administrators (user role “Company Admin” ) have access to Analytics.

What is the main technology that supports TripBuilder Analytics?