Order reports
Airline order report — the company's air ticket sales report with information on ticket numbers, ticketing dates, types of transportation, etc. within the selected time period.
Содержание
Purpose
Airline order report component in Nemo.travel system was created to help the agency generate different types of agency sales reports and facilitate the analysis of sales statistics for agency managers.
Examples of usage
In the unloaded data, the following information is available:
- the number of tickets sold, orders and segments for different periods,
- problem orders in the context of different transition sources (including meta search);
- search statistics;
- summary of the value of sold additional services;
- returned tickets;
- flight routes.
Configuration of access to order reports
The component is connected by the Nemo.Travel administrator. The administrator also sets up the agency rights to view specific reports in 'Statistics and Reports → Reports → Access to orders reports'. If you notice that any report listed below is not in your settings, contact Nemo.Travel technical support.
''Attention!' Only the manager and experts of the root agency have access to all connected reports. Subagents have access only to the following reports: Customizable ticketed order report, Customizable report for all conversions, Analytical statistics, Aggregated sales report, Electronic documents, Manual ticket returns, Automatic ticket returns, при условии, что они доступны для самого корневого агентства.
Work principle
Reports are located in Statistics and reports → Reports → Avia orders report.
To receive a report, you must specify the parameters by which the report will be generated.
- Choose the report type
- Choose the report parameters:
- Period.
- Date from - date in DD.MM.YYYY format (date selection on the calendar is available)
- Date to — date in DD.MM.YYYY format (date selection on the calendar is available)
For different types of reports, reservation date, ticketing date or other dates can be used as date parameters. For clarification, see the description of the specific report below.
- Aggregation type — The information in the report can be grouped by time period (day / month / year).
- Period.
- Select the data display form. The data in the report can be obtained in three ways:
- View a table with data on the current page — to do this, click the View the report button.
- Downloading XLS tables to your computer — to do this, click the Download in XLS button.
- Downloading a file with data in XML format to your computer - to do this, click the Download in XML button.
For convenience of storing reports, you can enable the Add description to the table option, then the XLS table will contain a header describing the main report parameters (for which subagency the report is formed, the selection date, the report type).
Also, for convenience of users, in this section you can filter and sort the column values in ascending and descending order.
Report types
Availability Check Fails
The report displays information about all orders in which there were any problems during the transition from the search page to the booking page (for example, the flight was no longer available, the price increased, an error occurred etc.
Состоит из столбцов:
| Metasearch | Creation date | Customer IP | Search external ID | Route | Begin date of services | Number of segments | Number of adult | Number of child | Number of infants with seat | Number of infants without seat | Price | Currency | Price change | Search GDS | Booking GDS |
All problem orders, creation date of which is within the selected range, fall into the selection. The creation date hereinafter refers to the date of transition from the search results page to the booking page. Under the service start date means the date of departure.
Ticketing by destinations
Отчет агрегирует информацию о суммарной стоимости выписанных заказов по конкретным маршрутам.
Состоит из столбцов:
| Service start date | Route | Number of legs | Number of segments | Number of transfers | Route type | Departure country code | Destination country code | Number of orders | Segment amount | Number of tickets | Total price | Currency |
All ticketed orders with a departure date and arrival date included in the selected date range fall into the selection.
Number of issued tickets
The report displays information on the total number of tickets issued on each route per day, month or year, depending on the aggregation type selected.
It consists of the following columns:
| Issue date | Route | Number of tickets |
All issued orders are included, the issue date of which is included in the selected date range, fall into the selection.
General data on the transitions by source
The report helps to analyze the conversion in the context of specific transition sources and flight routes with details of the problems encountered during the ordering process.
| Creation date | Route | Transition source | Postponed orders | Issues with availiability check | Orders with issues with availiability check | Booked orders | Booking issues | Orders with booking issues | Issued orders |
The selection includes orders whose creation date is included in the selected date range.
Example:
1 1st line means that there was one transfer from the Momondo source to the agent's site on the AAQ-VKO route on the specified day, while the client did not attempt to make a reservation.
The 3rd line means that the AER-LED route on the specified day had one transition from the Yandex source to the agent's site, the order was successfully booked and checked out, and there were no problems in the ticketing process.
The 5th line means that the AER-PEE route on the specified day was one transition from the Momondo source to the agent's site, but an error occurred during the actualization of the flight and the number of this order was indicated.
Average fare for ticketed orders
The report displays information on the number of orders issued, tickets, the total value of orders and the average cost of the fare for the particular time period.
It consists of the following columns:
| Ticketing date | Number of orders | Number of segments | Number of tickets | Average fare | Total price | Currency |
The selection includes orders whose discharge date is in the selected date range. Also for this report, there is an additional "Supplier" parameter in the form, which allows you to generate a report only for a specific supplier.
Aggregated statistics by company
The report displays the total price of fares, taxes and agency fees for orders issued within a specific period, as well as the number of orders and tickets issued.
It consists of the following columns:
| Creation date | Number of transitions | Number of tickets | Fares amount | Taxes amount | Agency fees amount | Number of booked orders | Number of issued orders | Currency |
The selection includes orders whose creation date is within a selected date range.
Statistics by company
The report contains information on the number of tickets issued for each order with the order number in Nemo and the corresponding PNR in the GDS. In this case, the report may contain both written out and booked, but not written out orders.
It consists of the following columns:
| Order ID | Booking date | PNR locator | Number of tickets |
The selection includes orders whose booking date is within the selected date range.
Company financial report
The report contains information on the number of tickets issued for each order with the order number in Nemo and the corresponding PNR in the GDS. In this case, the report may contain both issued and booked, but not issued orders.
It consists of the following columns:
| Issue date | Booking supplier | Payment method | Number of orders | Number of segments | Total price | Segments sum | Fares sum | Taxes sum | Total fees sum | Agency fees sum | Aeroexpress sum | Alphastrakhovanie sum | Number of tickets | Currency |
The selection includes orders whose issue date is within the selected date range.
General information on sales
This report contains general information on the number of searches, orders, tickets, and the cost of orders issued by a specific agency company for the selected period.
It consists of the following columns:
| IDs of the companies | Company name | Issue date | Number of searches | Number of orders | Number of tickets | Fares sum | Taxes sum | Agency fees sum | Aeroexpress sum | Alphastrakhovanie sum | Currency |
The selection includes orders whose ticketing date is within the selected range.
Sales summary report
ОThis report contains information on issued orders with breakdown by cost and indicating ticket numbers and PNR.
It consists of the following columns:
| Order ID | Issue date | PNR locator | Number of segments | Number of tickets | Number of segments in total | Fare price | Basic price | Agency fees amount | Aeroexpress amount | Alphastrakhovanie amount | Total price | Currency | Payment type | Transition source | Tickets |
The selection includes orders whose discharge date is in the selected date range.
Ticket return operations
This report contains detailed information on returns.
It consists of the following columns:
| PNR locator | Ticket number | Fare | Taxes | Agency charge | Subagency charge | Payment gateway charge | Retained fare | Retained taxes | Retained agency charge | Retained subagency charge | Retained non-refundable fare | Airline’s charge for cancelled bookings | Insurance price for Alphastrakhovanie | ERV insurance price | Aeroexpress price | Service package price | Retained insurance price for Alphastrakhovanie | Retained ERV insurance price | Retained aeroexpress price | Retined service package price | Agency return fee | Returned in total | Issue date | User name |
The selection includes orders whose issue date is in the selected date range.
Time from ticket purchase to departure
The report contains information about the time between payment and departure on various routes.
It consists of the following columns:
| Route | Payment date | Service start date | Difference in days | Number of orders |
All paid orders, the issue date of which falls within the selected date range, are included in the selection.
Unsuccessful booking attempts
The report contains information about orders, the booking of which for one reason or another failed.
It consists of the following columns:
| Order ID | Transition error | Airline |
Data can be grouped by inaccessibility type, using the Group data by parameter. Grouping criteria:
- price increase
- flight is unavailable
- booking errors
To filter the data included in the report for specific airlines, list the codes of the required airlines in the Airlines list by commas field.
The selection includes all orders of selected airlines that meet the grouping criteria, the date of the booking attempt of which falls within the selected date range.
Orders with bonus cards
This report is available only if the Bonus programs module is connected.
It consists of the following columns:
| Order ID | Company ID | Bonus program name | Bonus card number | Bonuses accrued | Service start date | Service end date |