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 Websky 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 Websky 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 Websky 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, if they are available for the root agency.
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.
It consists of the following columns:
| 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.
Tickets by directions
Отчет агрегирует информацию о суммарной стоимости выписанных заказов по конкретным маршрутам.
It consists of the following columns:
| Begin date of services | Route | Number of legs | Number of segments | Number of transfers | Route type | Departure country code | Arrival country code | Number of orders | Segments count sum | 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 ticketing
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:
| Complete 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.
Direction and sources data
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 | Source | Pending bookings | Bookings with failed checking availability count | Bookings with failed checking availability IDs | Booked orders count | With failed booking | With failed booking IDs | Ticketed bookings |
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 tickets tariff
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:
| Complete date | Number of orders | Number of segments | Number of tickets | Average base price | 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 companies statistics
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 | New bookings count | Number of tickets | Fare price sum | Airline charge sum | Agency charge sum | Booked orders count | Ticketed orders count | Currency |
The selection includes orders whose creation date is within a selected date range.
Companies statistics
The report contains information on the number of tickets issued for each order with the order number in Websky 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 | Number of tickets |
The selection includes orders whose booking date is within the selected date range.
Financial statement of the company
The report contains information on the number of tickets issued for each order with the order number in Websky 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:
| Complete date | GDS | Payment method | Number of orders | Number of segments | Total price | Fare price sum | Airline charge sum | Total charge sum | Aeroexpress price sum | AlphaInsurance price sum | Number of tickets | Currency |
The selection includes orders whose issue date is within the selected date range.
General sales information
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:
| Company ID | Partner name | Complete date | Searches count | Number of orders | Number of tickets | Fare price sum | Airline charge sum | Agency charge sum | Aeroexpress price sum | AlphaInsurance price sum | Currency |
The selection includes orders whose ticketing date is within the selected range.
Sales information 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 | Complete date | PNR | Number of segments | Number of tickets | Total number of segments | Fare price | Base price | Agency charge sum | Aeroexpress price sum | AlphaInsurance price sum | Total price | Currency | Payment type | Transition source | Tickets |
The selection includes orders whose discharge date is in the selected date range.
Ticket manual returns
This report contains detailed information on returns.
It consists of the following columns:
| PNR | Ticket number | Fare | Taxes | Agency charge | Subagency charge | Payment charge | Retained fare | Retained taxes | Retained agency charge | Retained subagency charge | Retained for non refundable fare | Airline charge imposed for booking cancellation | AlphaInsurance paid price | ERV insurance paid price | Aeroexpress paid price | Service pack paid price | Retained insurance price for AlphaInsurance | ERV insurance retained price | Aeroexpress retained price | Service pack retained price | Agency refund charge | Total refund | Complete date | User name |
The selection includes orders whose issue date is in the selected date range.
Time to flight
The report contains information about the time between payment and departure on various routes.
It consists of the following columns:
| Route | Payment date | Begin date of services | Days difference | 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 | Error during the creation | 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 | Agency ID | Bonus program type | Bonus card number | Bonuses | Begin date of services | End date of services |
Orders conversion
The report contains detailed statistics on the status of orders, which will allow to perform the analysis of the conversion dynamics for a certain period.
It consists of the following columns:
| Source | GDS | Error during the creation | Airline | Route | Creation date | Total count | Pending without data | Pending with data but there was an error during booking | Stayed the booked (not ticketed) | Ticketed | Ratio of ticketed to total for day | Ratio of ticketed to booked for day |
- Total count - the total number of all orders
- Pending without data - user did not enter passenger data into the order
- There was no booking but pending with data - user entered passenger data, but there was no booking attempt
- Выписанные к переходам - the number of ticketed orders divided by the total number of orders
- Ratio of ticketed to total for day - the number of ticketed orders, divided by the total number of booked
- Number of orders issued in this report includes also voided/returned.
For this report, it is possible to group data.
Grouping criteria:
- transition source
- booking provider
- transition error
- airline
- route
The selection displays orders that meet the grouping criteria, the creation date of which falls within the selected date range.
You can also select in advance the type of conversion calculation using the option Conversion calculate by:
- Ticket(the fact of order issue will be considered as a conversion criterion, i.e., the ratio of written orders to booked/all is taken into account)
- Payment(the fact of payment is considered the conversion criterion, i.e. the ratio of paid orders to booked/all is taken into account, while among paid orders may be both iisued and not issued)
Ticketed bookings custom report
The report displays the statistics selected by the user for the orders issued.
Available parameters
For this report, the possibility to group data on a variety of parameters is implemented.
Grouping criteria:
- GDS
- Nemo2 package ID
- User ID
- Company ID
- Payment status
- Payment method
- Route type
- Количество пассажиров
- Number of segments
- Number of legs
- Point of departure(IATA)
- Point of arrival (IATA)
- Departure country code
- Arrival country code
- Direct flight
- Local flight
- Class
- Airline
Also there is the possibility of choosing a flight by:
- Ticket date
- Service begin date (i.e. departure)
Available columns:
- Maximum minutes in transit with transfers
- Average minutes in transit with transfers
- Minimum minutes from search to booking
- Average minutes from search to booking
- Maximum minutes from search to booking
- Minimum minutes from booking to issue
- Average minutes from booking to issue
- Maximum minutes from booking to issue
- Minimum days from issue to departure
- Average days from issue to departure
- Maximum days from issue to departure
- Number of tickets
- Tickets * segments
- Minimum total price
- Average total price
- Maximum total price
- Minimum base price
- Average base price
- Maximum base price
- Minimum tariff price
- Minimum tariff price
- Average tariff price
- Maximum sum of fees
- Average sum of fees
- Maximum sum of fees
- Minimum sum of AlfaInsurance
- Average sum of AlfaInsurance
- Maximum sum of AlfaInsurance
- Minimum sum of ERV insurance
- Average sum of ERV insurance
- Maximum sum of ERV insurance
- Minimum sum of Aeroexpress
- Average sum of Aeroexpress
- Maximum sum of Aeroexpress
- Minimum sum of additional services
- Average sum of additional services
- Maximum sum of additional services
- Minimum price of service packages
- Average price of service package
- Maximum price of the service package
- Minimum profit
- Average profit
- Maximum profit
- Destination Country Code
- Minimum profit for one ticket
- Average profit for one ticket
- Maximum profit for one ticket
- Minimum profit for one ticket * segment
- Average profit for one ticket * segment
- Maximum profit for one ticket * segment
- Minimum number of passengers in the order
- Average number of passengers in the order
- Maximum number of passengers in the order
- Maximum number of segments in the order
- Minimum minutes in transit
- Average minutes in transit
- Maximum minutes in transit
- Minimum minutes in transit with transfers
- Average umber of segments in the order
- Minimum umber of segments in the order
- Order examples
The selection includes orders whose issue date is within a selected date range.
Electronic documents
The report contains statistics on electronic documents (EMD).
One line of the report contains information on one electronic document.
The report contains the following columns:
| Order ID | Date | Number | Ticket number | Type | Subtype | Original price | Original currency | Price | Currency | RFISC data | Taxes sum |
| Order number in the Websky system | Order date | Electronic document number | Passenger ticket number to which the electronic document from this row of the table belongs | The type of electronic document, the values can be seen in the table "Types" below | The subtype of the electronic document, the values can be seen in the table "Subtypes" below | The amount for which the electronic document was issued in the currency of the supplier | Supplier currency code | The amount for which the electronic document was issued | The currency code of the previous column. Currency corresponds to the one that the client had when buying on the site | RFISC subcodes are set by the airline itself and determine the specific type of service | Shown for air tickets |
You can download the report in XLS, XML, CSV formats.
The reports in XML and СSV format use numerical designations of types and subtypes of electronic documents in the following form:
<el_doc_type>7</el_doc_type> - Types <el_doc_type_sub>6</el_doc_type_sub> - Subtypes
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||
The selection includes electronic documents, the date of registration of which is in the specified date range.
Sample "Electronic Documents" report:
Analysis of the order №522597:
- Total cost of the order will be: "Cost" of the ticket + "Additional charge cost"+ "Ancillary services cost" = 1980 + 500 + 600 = 3080RUB;
- Fare price separately in the report table is not indicated, you can calculate the fare price for this case like this: "Ticket cost" - "Amount of taxes" of the ticket + "Additional charge price" = 1980-1500 + 500 = 980RUB. The order from the example was issued in Sirena Travel GDS, this GDS sent an agency charge (TaxCode = AG), to which EMD is issued according to the rules of the GDS (second line from the example of the order above).
Attention! Although an EMD is issued for the 500RUB amount of this tax, it is also included in the "Tax amount" of the ticket.
Customizable report for issued air orders
This report contains only selected information on all issued air orders for a given period (including tickets voided and returned at the time of the report).
Available parameters
- Order ID
- Nemo2 order ID
- PNR
- Airline order ID
- GDS
- User ID
- Client email hash
- User name
- Company ID
- Company
- Source
- Search date
- Booking date
- Complete date
- Departure date
- Arrival date
- Payment method
- Total price
- Base price
- Agency charge sum
- Status
- Agency profit
- Airline comission
- Subagency charge
- Subagency profit
- Alphainsurance sum
- Aeroexpress sum
- Service package price
- ERV insurance price sum
- Service pack price sum
- Gateway charge
- All services sum
- Tickets
- Number of passengers
- Number of adult
- Number of child
- Number of infants without seat
- Number of infants with seat
- Number of tickets
- Route type
- Number of segments
- Number of legs
- Point of departure (IATA)
- Departure country code
- Arrival country code
- Point of arrival (IATA)
- Route
- Flight information
- Tariffs
- Direct flight
- Local flight
- Class
- Flight time in minutes
- Full time in minutes
- Nemo2 package ID
- Fare price
- Airline
The selection includes orders whose issue date is within a selected date range.
Only the selected columns are displayed in the selection.
Analytic statistics
The report contains conversion and changes of sales on the chosen date.
The report contains the following columns:
| Number of searches in a day | Number of searches in current month | Number of searches in 30 days | Tendency of searches for day | Tendency of searches for month | Tendency of searches for day 30 days | Ticketed segments in a day | Ticketed segments in current month | Ticketed segments in 30 days | Ticketed segments in last 30 days | Sales tendency for day | Sales tendency for 30 days | Number of orders in day | Ratio of ticketed to total for day | Ratio of ticketed to booked for day | Rejects without ticketing to ticketed in day | Rejects with ticketing to ticketed in day |
- Number of searches in a day - number of scans GDS per day;
- Number of searches in current month - number of GDS scans in the period from the 1st day of the month to the selected date;
- Number of searches in 30 days - number of GDS scans in the last 30 days;
- Tendency of searches for day - change in the number of scans for the selected day relative to the average for the last 30 days;
- Tendency of searches for month - change in the number of scans for the selected month relative to the average for the last 30 days
- Tendency of searches for day 30 days - change in the number of scans in the last 30 days to the previous 30 days;
- Ticketed segments in a day - number of ticketed segments per day;
- Ticketed segments in current month - number of ticketed segments in the period from the 1st day of the month to the selected date;
- Ticketed segments in 30 days - number of ticketed segments in the last 30 days;
- Ticketed segments in last 30 days - number of ticketed segments for the previous 30 days;
- Sales tendency for day - number of ticketed segments per day relative to the average for the last 30 days;
- Sales tendency for 30 days - number of ticketed segments in 30 days relative to the previous 30 days;
- Number of orders in day - number of transitions from the search results page to the order page;
- Ratio of ticketed to total for day - ratio of the number of ticketed segments to transitions to the order page per day;
- Ratio of ticketed to booked for day - ratio of the number of ticketed segments to transitions to the order page per day;
- Rejects without ticketing to ticketed in day - ratio of canceled segments not previously ticketed to the issued segments per day;
- Rejects with ticketing to ticketed in day - ratio of canceled and previously ticketed segments to ticketed segments per day.
Customizable report for all transitions
This report contains only selected information for all air orders.
Available parameters
- Order ID
- Nemo2 order ID
- PNR
- Airline order ID
- GDS
- User ID
- Client email hash
- User name
- Company ID
- Company
- Source
- Search date
- Booking date
- Complete date
- Departure date
- Arrival date
- Payment method
- Total price
- Base price
- Agency charge sum
- Status
- Agency profit
- Airline comission
- Subagency charge
- Subagency profit
- Alphainsurance sum
- Aeroexpress sum
- Service package price
- ERV insurance price sum
- Service pack price sum
- Gateway charge
- All services sum
- Tickets
- Number of passengers
- Number of adult
- Number of child
- Number of infants without seat
- Number of infants with seat
- Number of tickets
- Route type
- Number of segments
- Number of legs
- Point of departure (IATA)
- Departure country code
- Arrival country code
- Point of arrival (IATA)
- Route
- Flight information
- Tariffs
- Direct flight
- Local flight
- Class
- Flight time in minutes
- Full time in minutes
- Nemo2 package ID
- Fare price
- Airline
- Order status
Order status can have the following values:
Route types can have the following values:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
