Order reports

From docs.websky.tech
Revision as of 18:49, 5 August 2020 by I shaletin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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, при условии, что они доступны для самого корневого агентства.

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.
Состоит из столбцов:

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

Отчет агрегирует информацию о суммарной стоимости выписанных заказов по конкретным маршрутам.
Состоит из столбцов:

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

Отчет показывает конверсии и изменение продаж в один выбранный день.
Состоит из столбцов:

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.



Retrieved from "https://docs.websky.tech/index.php?title=Order_reports&oldid=56"