Aviation award mileage value accounting method and system and storage medium

Abstract

The invention discloses an aviation reward mileage value accounting method and system and a storage medium, and the method comprises the steps: obtaining original data related to reward mileage in a target airline company, carrying out the data processing, and at least obtaining exchange detail data, accumulated detail data and a cooperation protocol table; extracting an exchange detail table of a specified time period from the exchange detail data; according to the exchange detail table and the cooperation protocol table, calculating to obtain an exchange unit price of each exchange service scene; from the accumulated detail data, tracing an accumulated source of the exchange mileage corresponding to each exchange event, and forming an accumulated event table; based on the cumulative event table, the exchange event and the cooperation protocol table, calculating to obtain a mileage cumulative unit price of each cumulative service scene; and based on the accumulated unit price, the predicted exchange rate and the cooperation agreement table, obtaining a recursive unit price of the award mileage. According to the method, the value accounting of the mileage in various performance obligations can be realized by integrating various data related to the rewarded mileage in the target airline company.

Description

Technical Field

[0001] This invention relates to the field of aviation technology, and in particular to a method, system, and computer-readable storage medium for calculating the value of aviation reward miles. Background Technology

[0002] With the continuous development of internet technology, mathematical models used for revenue prediction are also constantly being updated and iterated. Early data processing methods relying on Excel are no longer sufficient to meet the ever-increasing business needs. In the aviation industry, facing investments ranging from tens of millions to hundreds of millions of yuan, the accuracy and timeliness of revenue prediction are crucial. However, airlines still face many challenges in mileage value calculation.

[0003] While airlines have accumulated rich experience in calculating cash revenue from ticket sales and value-added services, a significant gap remains in their ability to calculate mileage value. As airline frequent flyer programs grow and expand, the scenarios for mileage accumulation and redemption become increasingly complex, involving more diverse revenue channels. Simultaneously, with the continuous expansion of the airline ecosystem, third-party platforms such as Taobao, JD.com, and Pinduoduo have joined the fray, further complicating the logic and rules of mileage value calculation and presenting new business models and cooperation patterns. Therefore, how to effectively calculate mileage value has become a pressing problem that needs to be solved. Summary of the Invention

[0004] The purpose of this invention is to provide a method, system, and computer-readable storage medium for calculating the value of airline reward miles, which calculates the value of miles in various performance obligations by integrating various data related to reward miles from the target airline.

[0005] A first aspect of the present invention provides a method for calculating the value of airline reward miles, comprising:

[0006] Obtain raw data related to reward miles from the target airline, and perform data cleaning, data integration, and business scenario segmentation on the raw data to obtain processed data; wherein, the processed data includes: redemption details data, cumulative details data, and cooperation agreement table;

[0007] Extract the exchange details table for a specified time period from the exchange details data; wherein, the exchange details table includes: various exchange events under different exchange business scenarios;

[0008] Based on the redemption details table and the cooperation agreement table, the mileage redemption unit price for each redemption business scenario is calculated;

[0009] From the accumulated detailed data, trace the accumulated source of the redemption mileage corresponding to each redemption event and construct an accumulated event table;

[0010] Based on the cumulative event table, the redemption event table, and the cooperation agreement table, the mileage cumulative unit price for each cumulative business scenario is calculated.

[0011] Based on the cumulative unit price, the expected exchange rate, and the cooperation agreement table, the deferred unit price of reward miles is obtained; wherein, the deferred unit price includes: the deferred unit price of air travel and the deferred unit price of other services.

[0012] Optionally, the method further includes:

[0013] Based on the aforementioned agreement table, the guaranteed price for the reward mileage is calculated.

[0014] The mileage redemption price, the mileage accumulation price, the deferred price, and the safety net price are applied to the corresponding business requirements, and the results are displayed.

[0015] Optionally, the mileage redemption price includes: the redemption price for a free ticket on the domestic airline, the redemption price for a free ticket on a foreign airline, the redemption price for an airline upgrade, the redemption price in the online store, and the redemption price in the wallet.

[0016] Optionally, the unit price for the free ticket redemption on this airline is calculated using the following formula:

[0017]

[0018] Where Y1 is the unit price for the free ticket redemption of this airline; A i The ticket price for the target airline; B i For foreign airline fares; p is the tax rate; C i denoted as mileage on the corresponding ticket; n represents the number of tickets, and n = n1 + n2.

[0019] Optionally, the exchange rate in the mall is calculated using the following formula:

[0020]

[0021] Among them, y i1 Let A be the exchange price per unit of the i-th type of goods; sku1 The corresponding product supply price; num is the redemption quantity for the corresponding product category; q is the commission rate; F is shipping insurance; u is the mall coupon; t is the merchant coupon; E is the shared postage; M i Y3 represents the redemption mileage corresponding to the i-th type of goods; Y3 represents the redemption price per unit in the mall; and N1 represents the total number of types of goods in the mall.

[0022] Optionally, the wallet exchange rate is calculated using the following formula:

[0023]

[0024] Among them, y i2 Let A be the exchange price per unit of the i-th type of goods; sku2 Pricing set by the target airline itself; M i Y4 represents the redemption mileage corresponding to the i-th type of goods; Y4 represents the wallet redemption price; and N2 represents the total number of types of goods in the wallet.

[0025] Optionally, the step of calculating the mileage accumulation price for each cumulative business scenario based on the cumulative event table, the redemption event table, and the cooperation agreement table includes:

[0026] The first cumulative unit price corresponding to the cumulative business scenario being an aviation cumulative business scenario is calculated using the following formula:

[0027]

[0028] Where Y5 is the first cumulative unit price; V j P represents the exchange value of the j-th exchange source. j W represents the ratio of accumulated miles to redeemed miles for the j-th redemption source; j m1 represents the accumulated mileage corresponding to the j-th redemption source; m1 is the total number of redemption sources in the aviation accumulation business scenario.

[0029] The second cumulative unit price when the cumulative business scenario is a non-aviation cumulative business scenario is calculated using the following formula:

[0030]

[0031] Where Y6 is the second cumulative unit price; P c (k) represents the agreed price for the k-th cumulative event in the non-aviation cumulative business scenario; W k is the cumulative mileage of the kth cumulative event; m2 is the total number of cumulative events in the non-aviation cumulative service scenario.

[0032] Optionally, the deferred fare is calculated using the following formula:

[0033]

[0034] Where Y7 is the deferred fare for air travel; X i Q represents the deferred amount corresponding to the i-th cumulative flight event in the aviation business scenario; i W i and R iThese represent the cumulative unit price, cumulative mileage, and expected redemption rate corresponding to the i-th cumulative flight event, respectively; S represents ticket revenue; and m3 represents the total number of cumulative flight events in the aviation business scenario.

[0035] A second aspect of the present invention provides a system for calculating the value of airline reward miles, comprising:

[0036] The data processing module is used to acquire raw data related to reward miles from the target airline, and to perform data cleaning, data integration and business scenario segmentation on the raw data to obtain processed data; wherein, the processed data includes: redemption details data, cumulative details data and cooperation agreement table;

[0037] The data time segmentation module is used to extract a redemption detail table for a specified time period from the redemption detail data; wherein, the redemption detail table includes: various redemption events under different redemption business scenarios;

[0038] The redemption unit price calculation module is used to calculate the mileage redemption unit price for each redemption business scenario based on the redemption details table and the cooperation agreement table.

[0039] The cumulative source tracing module is used to trace the cumulative source of the redemption mileage corresponding to each redemption event from the cumulative detailed data, and to form a cumulative event table;

[0040] The cumulative unit price calculation module is used to calculate the mileage cumulative unit price for each cumulative business scenario based on the cumulative event table, the redemption event, and the cooperation agreement table.

[0041] The deferred unit price calculation module is used to obtain the deferred unit price of reward mileage based on the cumulative unit price, the expected exchange rate and the cooperation agreement table; wherein, the deferred unit price includes: the deferred unit price of air travel and the deferred unit price of other services.

[0042] A third aspect of the present invention provides a computer-readable storage medium, characterized in that the computer-readable storage medium includes a stored computer program; wherein, when the computer program is executed, it controls the device where the computer-readable storage medium is located to perform the aviation reward mileage value calculation method described in any of the first aspects above.

[0043] Compared with existing technologies, embodiments of the present invention provide a method, system, and computer-readable storage medium for calculating the value of airline reward miles. The method includes: acquiring raw data related to reward miles from a target airline, and performing data cleaning, data integration, and business scenario segmentation on the raw data to obtain processed data; wherein the processed data includes: redemption details data, cumulative details data, and cooperation agreement tables; extracting redemption details tables for a specified time period from the redemption details data; calculating the mileage redemption unit price for each redemption business scenario based on the redemption details table and the cooperation agreement table; tracing the accumulation source of redemption miles corresponding to each redemption event from the cumulative details data and constructing a cumulative event table; calculating the mileage cumulative unit price for each cumulative business scenario based on the cumulative event table, redemption events, and cooperation agreement table; and obtaining the deferred unit price of reward miles based on the cumulative unit price, the expected redemption rate, and the cooperation agreement table. The present invention can realize the value calculation of miles in various performance obligations by comprehensively considering various data related to reward miles from a target airline. Attached Figure Description

[0044] Figure 1 This is a flowchart illustrating an embodiment of the aviation reward mileage value calculation method provided by the present invention;

[0045] Figure 2 This is a flowchart illustrating another embodiment of the aviation reward mileage value calculation method provided by the present invention;

[0046] Figure 3 This is a flowchart illustrating another embodiment of the aviation reward mileage value calculation method provided by the present invention;

[0047] Figure 4 This is a schematic diagram of an embodiment of the aviation reward mileage value calculation system provided by the present invention. Detailed Implementation

[0048] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0049] See Figure 1 This is a flowchart illustrating an embodiment of the aviation reward mileage value calculation method provided by the present invention.

[0050] A first aspect of the present invention provides a method for calculating the value of airline reward miles, including steps S1 to S6, as detailed below:

[0051] Step S1: Obtain the raw data related to reward miles from the target airline, and perform data cleaning, data integration and business scenario segmentation on the raw data to obtain processed data; wherein, the processed data includes: redemption details data, cumulative details data and cooperation agreement table;

[0052] Step S2: Extract the exchange details table for a specified time period from the exchange details data; wherein, the exchange details table includes: various exchange events under different exchange business scenarios;

[0053] Step S3: Calculate the mileage redemption unit price for each redemption business scenario based on the redemption details table and the cooperation agreement table;

[0054] Step S4: From the accumulated details data, trace the accumulated source of the redemption mileage corresponding to each redemption event and construct an accumulated event table;

[0055] Step S5: Based on the cumulative event table, the redemption event, and the cooperation agreement table, calculate the mileage cumulative unit price for each cumulative business scenario;

[0056] Step S6: Based on the cumulative unit price, the expected exchange rate, and the cooperation agreement table, obtain the deferred unit price of the reward mileage; wherein, the deferred unit price includes: the deferred unit price of air travel and the deferred unit price of other services.

[0057] Furthermore, the method also includes:

[0058] Step S7: Calculate the guaranteed price of the reward mileage based on the agreement table;

[0059] Step S8: Apply the mileage redemption price, the mileage accumulation price, the deferred price, and the safety net price to the corresponding business requirements, and display the results.

[0060] like Figure 2 The diagram shown is a flowchart of another embodiment of the aviation reward mileage value calculation method provided by the present invention. Figure 2 It mainly includes the following 5 parts:

[0061] (1) Data input section: In step S1, the system connects to data sources such as the airline's internal website, APP, and data platform through database synchronization or Web interface to obtain raw data related to reward miles, such as frequent flyer event information and transaction information involving third parties such as mall and wallet.

[0062] (2) Data cleaning section: In step S1, the original data is initially cleaned, including processing abnormal data, duplicate data and invalid data. Sometimes, special cleaning rules are formulated to clean the data according to different data requirements.

[0063] (3) Data integration and storage section: In step S1, the cleaned data is integrated and divided into business scenarios. For example, the redemption event table, redemption order table and redemption flight information table are integrated into redemption detail data; similarly, the cumulative detail data is processed in the same way; then, member tags are marked according to the member table, and redemption business and cumulative business are subdivided and logically divided according to business scenarios, so as to accurately establish redemption detail data and cumulative detail data.

[0064] (4) Mileage value calculation: In steps S2 to S6, the mileage redemption unit price and mileage accumulation unit price are calculated based on the information from the mileage flow table, the opening data, the carrier data, the settlement price, the non-airline cooperation agreement and the foreign airline agreement, etc. Then, the deferred unit price is calculated based on the mileage accumulation unit price.

[0065] In step S7, a safety net price is calculated based on different dimensions using the mileage accumulation unit price. These calculated unit prices are used to estimate the redemption cost, accumulated value, and membership value for the whole month. Finally, the profit is calculated based on the cost.

[0066] (5) Output report section: In step S8, according to business needs, the calculated results are summarized or refined into datasets of various dimensions and conditions for front-end report display to meet the needs of business analysis and prediction.

[0067] To provide a clearer description of the technical solutions provided in the embodiments of the present invention, a specific embodiment is provided below for reference:

[0068] Data Input: User A redeemed a flight ticket on the official website using miles, spending 1000 miles. At this point, the system generates the corresponding order information, ticketed flight information, and carrier revenue information. The 1000 miles spent by the user come from miles accumulated after previous flight bookings, or miles accumulated through other activities, and these accumulated miles also include their corresponding accumulation information.

[0069] Data cleaning: Download this relevant information from the corresponding business database and clean it into the specified table in the analysis database.

[0070] Data integration: The redemption order table, flight information table, and membership table are integrated into a redemption details table (wide table); at the same time, the cumulative order table, flight information table, and membership table are integrated into a cumulative details table (wide table).

[0071] Mileage Value Calculation: Based on the redemption details table (linked to the carrier table), the value of 1000 miles redeemed for this ticket is calculated. The average redemption rate for the month is calculated using the redeemed miles and redemption values. Based on the redemption rate for each redemption scenario, the cumulative redemption rate for some scenarios is further calculated; for some cumulative scenarios, the rate from the agreement table is used directly. Finally, based on the cumulative rate, the deferred rate and the safety net rate are calculated.

[0072] Output reports: Calculate the deferred amount (i.e., mileage revenue) based on the product of the deferred unit price and accumulated mileage; calculate the mileage cost based on the product of the redemption unit price and redeemed mileage. Profit is calculated by subtracting mileage cost from mileage revenue, and customized reports are generated for display based on user needs.

[0073] In one optional embodiment, the mileage redemption price includes: the redemption price for a free ticket on the domestic airline, the redemption price for a free ticket on a foreign airline, the redemption price for an airline upgrade, the redemption price in the online store, and the redemption price in the wallet.

[0074] It should be noted that the unit price for free tickets on domestic airlines, free tickets on foreign airlines, and upgrades are all airline-related unit prices; the unit prices for online store and wallet transactions are non-airline-related unit prices.

[0075] In an optional embodiment, the unit price for the free ticket redemption on this flight is calculated using the following formula:

[0076]

[0077] Where Y1 is the unit price for the free ticket redemption of this airline; A i The ticket price for the target airline; B i For foreign airline fares; p represents the tax rate (which is generally fixed); C i denoted as mileage on the corresponding ticket; n represents the number of tickets, and n = n1 + n2.

[0078] It should be noted that when the carrier calculates the free ticket redemption for its own airline (the target airline), it needs to exclude the fares of other regular flights besides the free ticket data, and calculate the free ticket fare based on the average fare of regular flights, accurate to the mother cabin class. Additionally, domestic flights need to undergo tax deduction processing to calculate the unit price (unit: RMB / mile) for the free ticket redemption for the own airline.

[0079] Furthermore, the number of miles required to redeem a single ticket is set by the business department, and the redemption rate is used to calculate the overall mileage cost (RMB / mile) for the entire business scenario in a given month. Since ticket prices are affected by peak and off-peak seasons, the price for the same flight segment can vary from month to month, thus causing monthly cost fluctuations. However, when calculating the rate, there's no need to consider when to use which rate, as the rate for the appropriate scenario is pre-determined and calculated based on the business scenario. This rate is primarily used for financial auditing to account for the cost of free tickets, fees collected from users, and profits, etc.

[0080] The specific implementation example is as follows: Calculating the redemption price per free ticket first requires precision down to the flight number, calculating the average monthly fare for the motherboard of that flight segment (economy and business class fares may differ for the same flight). After obtaining the average fare, the fare for the entire business scenario is derived based on the ticket number corresponding to that scenario. Finally, the fares for all ticket numbers in that business scenario are summed, and then divided by the total mileage required to redeem all ticket numbers to obtain the redemption price per free ticket for that scenario.

[0081] The specific calculation priority is as follows:

[0082] Priority ①: When the free ticket includes ticket number, ticket copy, flight number, date of carriage, departure and arrival airports, carrier and mother cabin information, the price will be calculated accurately based on the mother cabin fare.

[0083] Priority ②: Free tickets include ticket number, ticket copy, flight number, operating date, departure and arrival airports, and carrier information, but if there is no mother cabin information, the overall ticket price for that flight will be calculated.

[0084] Priority ③: Free tickets include ticket number, ticket copy, flight number, travel date, departure and arrival airports, but if carrier information is missing, the overall fare for the departure and arrival airports will be calculated.

[0085] And so on, searching upwards level by level until the ticket prices for all ticket numbers are covered.

[0086] In other words, since some home cabins only offer free tickets (tickets redeemed with miles), it's impossible to directly calculate the fare for that home cabin segment (because fares for the same flight and the same home cabin can differ; for example, the fare for the same segment might differ between morning and noon). Therefore, the calculation needs to be scaled up to a higher level, down to the carrier (i.e., the average fare for the same segment, the same airline, and the same home cabin), and the home cabin fare is priced based on this. This process continues until all ticket numbers are covered. The goal is to ensure that every free ticket number has a corresponding fare.

[0087] Furthermore, the calculation of the unit price for foreign airline free tickets involves excluding free ticket data and calculating the unit price based on the average ticket price of other regular flights operated by foreign airlines, accurate to the cabin class. Domestic flights require tax deduction, while foreign airlines do not. The formula is as follows:

[0088]

[0089] Where Y2 is the unit price for redeeming a free ticket from a foreign airline; A i The ticket price for the target airline; B i For foreign airline fares; p represents the tax rate (which is generally fixed); C i denoted as mileage on the corresponding ticket; n represents the number of tickets, and n = n1 + n2.

[0090] It's worth noting that "domestic" and "international" refer to the nature of the flight segment, i.e., whether the destination of the segment is domestic or international. For example, a China Southern Airlines flight to New York would be considered an international segment. "Foreign airline" and "domestic airline" refer to the airline itself. A domestic airline refers to an aircraft owned by the target airline, while a foreign airline refers to a flight operated by a non-target airline on behalf of the target airline. For example, if a user purchases a ticket with China Eastern Airlines, but China Eastern Airlines uses a China Southern Airlines aircraft to provide service, this would be considered a foreign airline ticket. In fact, the formula for calculating the redemption price of a foreign airline free ticket should be the same as the formula for calculating the redemption price of a domestic airline free ticket mentioned above; only the airlines involved differ.

[0091] Furthermore, the calculation method for the redemption price of airline upgrades is similar to that for the redemption price of free tickets on the same airline, so it will not be elaborated on here.

[0092] In an optional embodiment, the mall redemption price is calculated using the following formula:

[0093]

[0094] Among them, y i1 Let A be the exchange price per unit of the i-th type of goods; sku1 num represents the corresponding product supply price (the price listed by the partner merchant on the China Southern Airlines Mall); q represents the redemption quantity for the corresponding product category; F represents shipping insurance; u represents the mall coupon; t represents the merchant coupon; E represents the shared postage; M represents the commission rate; F represents shipping insurance; u represents the mall coupon; t represents the merchant coupon; E represents the shared postage; M represents the commission rate. i Y3 represents the redemption mileage corresponding to the i-th type of goods; Y3 represents the redemption price per unit in the mall; and N1 represents the total number of types of goods in the mall.

[0095] It's important to note that when a user redeems multiple different items in a single large order, with varying quantities of each item, the shipping costs will be allocated based on the value of each item during data integration, since shipping fees are uniformly priced across the platform. The final calculated value is the amount actually received by the target airline. Commissions are included in platform fees, not in the value of individual items. Shipping insurance will be precisely allocated to each item. The monthly mall price is calculated by dividing the total value of all items for the month by the mileage spent on redeeming those items.

[0096] In an optional embodiment, the wallet exchange rate is calculated using the following formula:

[0097]

[0098] Among them, y i2 Let A be the exchange price per unit of the i-th type of goods; sku2 Pricing set by the target airline itself; M i Y1 represents the redemption mileage corresponding to the i-th type of goods; Y4 represents the wallet redemption price (which can be used to represent the monthly redemption price of the entire wallet); N2 represents the total number of goods types in the wallet.

[0099] In other words, the monthly redemption price Y4 of the entire wallet is equal to the total value of all wallet items in that month (calculated by redemption price and mileage weighting) divided by the total mileage redeemed for all items in that month.

[0100] In an optional embodiment, the step of calculating the mileage accumulation price for each cumulative business scenario based on the cumulative event table, the redemption event table, and the cooperation agreement table includes:

[0101] The first cumulative unit price corresponding to the cumulative business scenario being an aviation cumulative business scenario is calculated using the following formula:

[0102]

[0103] Where Y5 is the first cumulative unit price; V j P represents the exchange value of the j-th exchange source. j W represents the ratio of accumulated miles to redeemed miles for the j-th redemption source; j m1 represents the accumulated mileage corresponding to the j-th redemption source; m1 is the total number of redemption sources in the aviation accumulation business scenario.

[0104] The second cumulative unit price when the cumulative business scenario is a non-aviation cumulative business scenario is calculated using the following formula:

[0105]

[0106] Where Y6 is the second cumulative unit price; P c (k) represents the agreed price for the k-th cumulative event in the non-aviation cumulative business scenario; W k is the cumulative mileage of the kth cumulative event; m2 is the total number of cumulative events in the non-aviation cumulative service scenario; It can be used to characterize the monthly cumulative mileage corresponding to non-aviation cumulative business scenarios.

[0107] It should be noted that when calculating the first cumulative fare for the airline accumulator business scenario, the redemption source is first found through the redemption event; then, the accumulator event table is found using the redemption source; next, the corresponding accumulator business scenario in the accumulator event table is identified, and the first cumulative fare Y5 is calculated based on the ratio (percentage) of the accumulator mileage to the redemption mileage in the accumulator event table, as shown below. Figure 3 As shown; among them, accumulated mileage includes: redeemed mileage (used) and redeemed mileage (not used).

[0108] When calculating the second cumulative unit price for non-aviation accumulator business scenarios, it primarily involves negotiated pricing. The negotiated price, deferred amount, and deferred unit price are directly retrieved from the corresponding agreement table. The negotiated price (unit price) refers to the value directly defined for the accumulated event in that accumulator business scenario. For example, for business scenario A1, if a mileage is accumulated, the agreement directly sets the value of that mileage at 100 yuan. There is usually a standard negotiated unit price (yuan / mileage), but pricing may vary between different agreements, and the negotiated price may also change when renewing an agreement.

[0109] In an optional embodiment, the deferred fare is calculated using the following formula:

[0110]

[0111] Where Y7 is the deferred fare for air travel; X i Q represents the deferred amount corresponding to the i-th cumulative flight event in the aviation business scenario; i W i and R i These represent the cumulative unit price, cumulative mileage, and expected redemption rate corresponding to the i-th cumulative flight event, respectively; S represents ticket revenue; and m3 represents the total number of cumulative flight events in the aviation business scenario.

[0112] It should be noted that when calculating the deferred unit price for air travel, the deferred amount must be calculated first, followed by the deferred unit price; while for other services, the deferred unit price is calculated first, followed by the deferred amount. Furthermore, the method for calculating ticket revenue is: "Based on the data in the carrier data sheet, domestic flights use gross revenue, and international flights use net revenue. If this cannot be determined, pre-allocated revenue is used." Expected exchange rate R iThe calculation method is to "calculate the proportion of mileage actually redeemed in the year's accumulated mileage based on the annual statistics".

[0113] It is worth noting that the deferred unit price for other services is directly taken as the cumulative unit price or the agreed price. The corresponding formula for calculating the deferred amount is: Deferred amount = Deferred unit price × Mileage × Expected conversion rate.

[0114] Furthermore, this invention also provides a method for calculating the floor price based on mileage, as follows:

[0115] (1) Calculation of non-aviation cooperation guarantee price: This involves calculating the average mileage unit price based on the agreement table data, assuming that the default unit price in the agreement is always greater than 0. Details are as follows:

[0116]

[0117] Among them, 0.001 <P c (i)<1;P c (i) represents the i-th contract price for the corresponding service; W i This represents the accumulated mileage corresponding to the i-th negotiated price of the corresponding service; m4 is the number of negotiated prices involved in the calculation for the corresponding service. The negotiated prices here are directly derived from the negotiated price table.

[0118] (2) Calculation of the minimum fare for foreign airlines:

[0119] (a) The guaranteed unit price for domestic flights is calculated based on the foreign airline agreement table, exchange rate data, and after-tax calculation, as follows:

[0120]

[0121] (b) The guaranteed fare for international flights needs to be adjusted according to the exchange rate and take into account taxes and fees (assuming a tax rate of 9%). The calculation method is as follows:

[0122]

[0123] Among them, P c (i) represents the i-th contract price for the corresponding service; W i H represents the cumulative mileage corresponding to the i-th agreed price of the corresponding service; i is the exchange rate for the i-th item; m5 is the quantity of the agreed price involved in the calculation of the corresponding business.

[0124] (3) The all-channel guaranteed price is calculated based on the average deferred unit price over the past year.

[0125] See Figure 4 This is a schematic diagram of an embodiment of the aviation reward mileage value calculation system provided by the present invention.

[0126] A second aspect of the present invention provides a system for calculating the value of airline reward miles, used to implement the method for calculating the value of airline reward miles described in any of the embodiments of the first aspect above, the system comprising:

[0127] The data processing module 11 is used to acquire raw data related to reward miles from the target airline, and to perform data cleaning, data integration and business scenario segmentation on the raw data to obtain processed data; wherein, the processed data includes: redemption details data, cumulative details data and cooperation agreement table;

[0128] The data time segmentation module 12 is used to extract a redemption detail table for a specified time period from the redemption detail data; wherein, the redemption detail table includes: various redemption events under different redemption business scenarios;

[0129] The redemption unit price calculation module 13 is used to calculate the mileage redemption unit price for each redemption business scenario based on the redemption details table and the cooperation agreement table.

[0130] The cumulative source tracing module 14 is used to trace the cumulative source of the redemption mileage corresponding to each redemption event from the cumulative detailed data, and to form a cumulative event table;

[0131] The cumulative unit price calculation module 15 is used to calculate the mileage cumulative unit price for each cumulative business scenario based on the cumulative event table, the redemption event, and the cooperation agreement table.

[0132] The deferred unit price calculation module 16 is used to obtain the deferred unit price of reward mileage based on the cumulative unit price, the expected exchange rate and the cooperation agreement table; wherein, the deferred unit price includes: the deferred unit price of air travel and the deferred unit price of other services.

[0133] The system also includes:

[0134] The safety net price calculation module is used to calculate the safety net price of the reward mileage based on the agreement table;

[0135] The results display module is used to apply the mileage redemption price, the mileage accumulation price, the deferred price, and the safety net price to the corresponding business requirements and display the results.

[0136] It should be noted that the aviation reward mileage value calculation system provided in the second aspect embodiment of the present invention can realize all the processes of the aviation reward mileage value calculation method described in the first aspect embodiment. The functions and technical effects of each module in the system are the same as those of the aviation reward mileage value calculation method described in the first aspect embodiment, and will not be repeated here.

[0137] A third aspect of the present invention provides a computer-readable storage medium comprising a stored computer program; wherein, when the computer program is executed, it controls the device on which the computer-readable storage medium is located to perform the aviation reward mileage value calculation method described in any of the first aspects of the present invention.

[0138] The above description is only a preferred embodiment of the present invention. It should be noted that for those skilled in the art, several improvements and modifications can be made without departing from the technical principles of the present invention, and these improvements and modifications should also be considered within the scope of protection of the present invention.

Claims

1. A method for calculating the value of airline reward miles, characterized in that, include: Obtain raw data related to reward miles from the target airline, and perform data cleaning, data integration, and business scenario segmentation on the raw data to obtain processed data; wherein, the processed data includes: redemption details data, cumulative details data, and cooperation agreement table; Extract the exchange details table for a specified time period from the exchange details data; wherein, the exchange details table includes: various exchange events under different exchange business scenarios; Based on the redemption details table and the cooperation agreement table, the mileage redemption unit price for each redemption business scenario is calculated; From the accumulated detailed data, trace the accumulated source of the redemption mileage corresponding to each redemption event and construct an accumulated event table; Based on the cumulative event table, the redemption event table, and the cooperation agreement table, the mileage cumulative unit price for each cumulative business scenario is calculated. Based on the cumulative unit price, the expected exchange rate, and the cooperation agreement table, the deferred unit price of reward miles is obtained; wherein, the deferred unit price includes: the deferred unit price of air travel and the deferred unit price of other services.

2. The method for calculating the value of airline reward miles as described in claim 1, characterized in that, The method further includes: Based on the aforementioned agreement table, the guaranteed price for the reward mileage is calculated. The mileage redemption price, the mileage accumulation price, the deferred price, and the safety net price are applied to the corresponding business requirements, and the results are displayed.

3. The method for calculating the value of airline reward miles as described in claim 1, characterized in that, The mileage redemption rates include: domestic airline free ticket redemption rate, foreign airline free ticket redemption rate, airline upgrade redemption rate, online store redemption rate, and wallet redemption rate.

4. The method for calculating the value of airline reward miles as described in claim 3, characterized in that, The unit price for the free ticket on this airline is calculated using the following formula: Where Y1 is the unit price for the free ticket redemption of this airline; A i The ticket price for the target airline; B i For foreign airline fares; p is the tax rate; C i denoted as mileage on the corresponding ticket; n represents the number of tickets, and n = n1 + n2.

5. The method for calculating the value of airline reward miles as described in claim 1, characterized in that, The exchange rate in the mall is calculated using the following formula: Among them, y i1 Let A be the exchange price per unit of the i-th type of goods; sku1 The corresponding product supply price; num is the redemption quantity for the corresponding product category; q is the commission rate; F is shipping insurance; u is the mall coupon; t is the merchant coupon; E is the shared postage; M i Y3 represents the redemption mileage corresponding to the i-th type of goods; Y3 represents the redemption price per unit in the mall; and N1 represents the total number of types of goods in the mall.

6. The method for calculating the value of airline reward miles as described in claim 1, characterized in that, The exchange rate for the wallet is calculated using the following formula: Among them, y i2 Let A be the exchange price per unit of the i-th type of goods; sku2 Pricing set by the target airline itself; M i Y4 represents the redemption mileage corresponding to the i-th type of goods; Y4 represents the wallet redemption price; and N2 represents the total number of types of goods in the wallet.

7. The method for calculating the value of airline reward miles as described in claim 1, characterized in that, The calculation of the mileage accumulation price for each cumulative business scenario based on the accumulated event table, the redemption event table, and the cooperation agreement table includes: The first cumulative unit price corresponding to the cumulative business scenario being an aviation cumulative business scenario is calculated using the following formula: Where Y5 is the first cumulative unit price; V j P represents the exchange value of the j-th exchange source. j W represents the ratio of accumulated miles to redeemed miles for the j-th redemption source; j m1 represents the accumulated mileage corresponding to the j-th redemption source; m1 is the total number of redemption sources in the aviation accumulation business scenario. The second cumulative unit price when the cumulative business scenario is a non-aviation cumulative business scenario is calculated using the following formula: Where Y6 is the second cumulative unit price; P c (k) represents the agreed price for the k-th cumulative event in the non-aviation cumulative business scenario; W k is the cumulative mileage of the kth cumulative event; m2 is the total number of cumulative events in the non-aviation cumulative service scenario.

8. The method for calculating the value of airline reward miles as described in claim 1, characterized in that, The deferred fare for air travel is calculated using the following formula: Where Y7 is the deferred fare for air travel; X i Q represents the deferred amount corresponding to the i-th cumulative flight event in the aviation business scenario; i W i and R i These represent the cumulative unit price, cumulative mileage, and expected redemption rate corresponding to the i-th cumulative flight event, respectively; S represents ticket revenue; and m3 represents the total number of cumulative flight events in the aviation business scenario.

9. A system for calculating the value of airline reward miles, characterized in that, include: The data processing module is used to acquire raw data related to reward miles from the target airline, and to perform data cleaning, data integration and business scenario segmentation on the raw data to obtain processed data; wherein, the processed data includes: redemption details data, cumulative details data and cooperation agreement table; The data time segmentation module is used to extract a redemption detail table for a specified time period from the redemption detail data; wherein, the redemption detail table includes: various redemption events under different redemption business scenarios; The redemption unit price calculation module is used to calculate the mileage redemption unit price for each redemption business scenario based on the redemption details table and the cooperation agreement table. The cumulative source tracing module is used to trace the cumulative source of the redemption mileage corresponding to each redemption event from the cumulative detailed data, and to form a cumulative event table; The cumulative unit price calculation module is used to calculate the mileage cumulative unit price for each cumulative business scenario based on the cumulative event table, the redemption event, and the cooperation agreement table. The deferred unit price calculation module is used to obtain the deferred unit price of reward mileage based on the cumulative unit price, the expected exchange rate and the cooperation agreement table; wherein, the deferred unit price includes: the deferred unit price of air travel and the deferred unit price of other services.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium includes a stored computer program; wherein, when the computer program is executed, it controls the device on which the computer-readable storage medium is located to perform the aviation reward mileage value calculation method as described in any one of claims 1 to 8.

Images