Открыть главное меню

Изменения

Order reports

15 275 байт добавлено, 16:10, 4 июня 2019
Report types
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 Tickets by destinations directions ===
Отчет агрегирует информацию о суммарной стоимости выписанных заказов по конкретным маршрутам.<br />
Состоит из столбцов:
{| class="wikitable" style="width:1200px"
|-
| Service start Begin dateof services
| Route
| Number of legs
| Route type
| Departure country code
| Destination Arrival country code
| Number of orders
| Segment amountSegments count sum
| Number of tickets
| Total price
All ticketed orders with a departure date and arrival date included in the selected date range fall into the selection.
=== Number of issued tickets 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.<br />
It consists of the following columns:
{| class="wikitable" style="width:1100px"
|-
| Issue 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.
<!--
=== Цифры для выставления счета по модулю ===
Отчет аналогичный отчету '''Цифры для выставления счета''', единственным отличаем является условие выборки. <br />В выборку попадают выписанные авиа заказы, у которых дата вылета и прилета попадает в выбранный диапазон дат.
-->
 === General Direction and sources 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. <br />
| Creation date
| Route
| Transition source Source | Postponed ordersPending bookings| Issues Bookings with availiability checkfailed checking availability count| Orders Bookings with issues with availiability checkfailed checking availability IDs| Booked orderscount| Booking issues With failed booking | Orders with With failed booking issues IDs | Issued orders Ticketed bookings
|-
|}
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.<br />
=== Average fare for ticketed orders 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.<br />
It consists of the following columns:
{| class="wikitable" style="width:1200px"
|-
| Ticketing Complete date
| Number of orders
| Number of segments
| Number of tickets
| Average farebase 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 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.<br />
It consists of the following columns:
|-
| Creation date
| Number of transitionsNew bookings count
| Number of tickets
| Fares amountFare price sum| Taxes amountAirline charge sum| Agency fees amountcharge sum| Number of booked Booked orderscount| Number of issued Ticketed orderscount
| Currency
|-
The selection includes orders whose creation date is within a selected date range.
=== Statistics by company Companies statistics ===
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.<br />
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 Financial statement of the 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 issued and booked, but not issued orders.<br />
It consists of the following columns:
{| class="wikitable" style="width:1200px"
|-
| Issue Complete date| Booking supplierGDS
| Payment method
| Number of orders
| Number of segments
| Total price
| Segments Fare price sum| Fares sum| Taxes Airline charge sum| Total fees sum| Agency fees charge sum| Aeroexpress price sum| Alphastrakhovanie AlphaInsurance price sum
| Number of tickets
| Currency
The selection includes orders whose issue date is within the selected date range.
=== General sales 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.<br />
It consists of the following columns:
{| class="wikitable" style="width:1200px"
|-
| IDs of the companiesCompany ID| Company Partner name| Issue Complete date| Number of searchesSearches count
| Number of orders
| Number of tickets
| Fares Fare price sum| Taxes Airline charge sum| Agency fees charge sum| Aeroexpress price sum| Alphastrakhovanie AlphaInsurance price sum
| Currency
|-
The selection includes orders whose ticketing date is within the selected range.
=== Sales summary information report ===
ОThis report contains information on issued orders with breakdown by cost and indicating ticket numbers and PNR.<br />
It consists of the following columns:
|-
| Order ID
| Issue Complete date| PNR locator
| Number of segments
| Number of tickets
| Number Total number of segments in total
| Fare price
| Basic Base price| Agency fees amountcharge sum| Aeroexpress amountprice sum| Alphastrakhovanie amount AlphaInsurance price sum
| Total price
| Currency
The selection includes orders whose discharge date is in the selected date range.
=== Ticket return operations manual returns ===
This report contains detailed information on returns.
{| class="wikitable" style="width:1100px"
|-
| PNR locator
| Ticket number
| Fare
| Agency charge
| Subagency charge
| Payment gateway charge
| Retained fare
| Retained taxes
| Retained agency charge
| Retained subagency charge
| Retained for non-refundable fare| Airline’s Airline charge imposed for cancelled bookingsbooking cancellation| Insurance AlphaInsurance paid price for Alphastrakhovanie| ERV insurance paid price| Aeroexpress paid price| Service package pack paid price| Retained insurance price for AlphastrakhovanieAlphaInsurance| Retained ERV insurance retained price| Retained aeroexpress Aeroexpress retained price| Retined service package Service pack retained price| Agency return feerefund charge| Returned in totalTotal refund| Issue Complete date
| User name
|-
The selection includes orders whose issue date is in the selected date range.
=== Time from ticket purchase to departure flight ===
The report contains information about the time between payment and departure on various routes.<br />
It consists of the following columns:
| Route
| Payment date
| Service start Begin dateof services| Difference in daysDays difference
| Number of orders
|-
|-
| Order ID
| Transition errorError during the creation
| Airline
|-
|-
| Order ID
| Company Agency ID| Bonus program nametype
| Bonus card number
| Bonuses accrued| 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.<br />It consists of the following columns:{| class="wikitable" style="width:1600px"|-| Source || GDS || Error during the creation || Airline|| Route|| Creation date || Total count| Pending without data || There was no booking but pending with 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.<br />Grouping criteria:* transition source* booking provider* transition error* airline* route<br /> 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. <div class="toccolours mw-collapsible mw-collapsed" style="width:800px"><u>'''Available parameters'''</u><div class="mw-collapsible-content">For this report, the possibility to group data on a variety of parameters is implemented.<br />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 start 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</div></div>The selection includes orders whose issue date is within a selected date range. ===Electronic documents=== The report contains statistics on electronic documents (EMD). <br>One line of the report contains information on one electronic document.<br>The report contains the following columns:  {| class="wikitable" style="width:1050px"|-| Order ID || Date|| Number|| Ticket number || Type|| Subtype || Original price || Original currency || Price || Currency || RFISC data || Taxes sum| Service end -| Order number in the {{NameSystem}} 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: <pre><el_doc_type>7</el_doc_type> - Types<el_doc_type_sub>6</el_doc_type_sub> - Subtypes</pre> {| |valign="top"|{| class="wikitable" style="width:300px"|-! colspan="2" | 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'|-|} |&nbsp;||&nbsp; |{| class="wikitable" style="width:300px"|-! colspan="2" | 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:====
[[Файл:Эл документы.jpg|Отчёт "Электронные документы"]]
<br>
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).
 
<div class="toccolours mw-collapsible mw-collapsed" style="width:800px">
<u>'''Available parameters'''</u>
<div class="mw-collapsible-content">
* 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
</div>
</div>
 
The selection includes orders whose issue date is within a selected date range.<br>
 
Only the selected columns are displayed in the selection.
 
=== Analytic statistics ===
Отчет показывает конверсии и изменение продаж в один выбранный день. <br />
Состоит из столбцов:
{| class="wikitable" style="width:1200px"
|-
| '''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.
 
<div class="toccolours mw-collapsible mw-collapsed" style="width:800px">
<u>'''Available parameters'''</u>
<div class="mw-collapsible-content">
* 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
</div>
</div>
 
Order status can have the following values:
{|
|valign="top"|
{| class="wikitable" style="width:300px"
|-
! colspan="2" | Statuses
|-
! Code
! Value
|-
| 1 || New
|-
| 3 || Booked
|-
| 7 || Confirmed
|-
| 8 || Cancelled
|-
|}
 
Route types can have the following values:
{|
|valign="top"|
{| class="wikitable" style="width:300px"
|-
! colspan="2" | Route types:
|-
! Code
! Value
|-
| 1 || OW
|-
| 2 || RT
|-
| 3 || CR
|-
|}
 
Payment status can have the following values:
{|
|valign="top"|
{| class="wikitable" style="width:300px"
|-
! colspan="2" | Payment status:
|-
! Code
! Value
|-
| 1 || Not payed
|-
| 2 || Partial payment (less than full price)
|-
| 3 || Fully payed
|-
|}
 
{| class="wikitable" style="width:300px"
|-
! colspan="2" | 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.
 
 
{| class="wikitable"
|[[Файл:Aggregated sales report.png|1300px]]
|-
|Aggregated sales report
|}
 
 
==См. также==
*[[Статистика|Statistics (rus)]]
*[[Модуль метрики|Metric module (rus)]]
1382
правки
'