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.

1. Choose the report type
2. 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).
3. 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

Type Code Value 1 'Airline additional service' 2 'AlphaInsurance policy' 3 'ERV policy' 4 'Aeroexpress ticket' 5 'Ticket' 6 'Charge' 7 'EMD' 8 'Ticket change' 9 'Ticket return' 10 'Airline additional services return'

Subtypes Code Value 1 'Air ticket' 2 'Airline additional service' 3 'Air ticket issue' 4 'Penalty' 5 'Refund' 6 'Additional charge' 7 'Conj. ticket' 9 'Policy' 10 'Order discount' 11 'Order charge' 12 'Refund' 13 'Payment'

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:

Statuses Code Value 1 New 3 Booked 7 Confirmed 8 Cancelled Route types can have the following values: Route types: Code Value 1 OW 2 RT 3 CR Payment status can have the following values: Payment status: Code Value 1 Not payed 2 Partial payment (less than full price) 3 Fully payed Suppliers (general): Code Value 1 Sabre 2 Travelport Galileo 5 Sirena Travel 18 Amadeus 30 Sita 33 Nemo Inventory 36 Travelfusion 40 Travelport UAPI The payment method corresponds to the gateway identifiers specified in the admin panel: (Finances → Payment methods → Gateway control → Payment Gateway No.N. Only the selected columns are displayed in the selection. Attention! The number of days in the report must be no more than 31. Aggregated sales report The report aggregates information on the number of: segments, air orders, air tickets, EMD, aeroexpress tickets, exchanges and returns, insurance policies and ERV, according to the selected agency. The sample includes information from all orders issued for which the departure date and arrival date falls within the selected date range. Aggregated sales report См. также Statistics (rus) Metric module (rus)