WO2022063118A1 - Method and apparatus for determining price sensitivity - Google Patents

Method and apparatus for determining price sensitivity Download PDF

Info

Publication number
WO2022063118A1
WO2022063118A1 PCT/CN2021/119586 CN2021119586W WO2022063118A1 WO 2022063118 A1 WO2022063118 A1 WO 2022063118A1 CN 2021119586 W CN2021119586 W CN 2021119586W WO 2022063118 A1 WO2022063118 A1 WO 2022063118A1
Authority
WO
WIPO (PCT)
Prior art keywords
historical
price
data
historical data
sales
Prior art date
Application number
PCT/CN2021/119586
Other languages
French (fr)
Chinese (zh)
Inventor
张晓松
王启凡
Original Assignee
胜斗士(上海)科技技术发展有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 胜斗士(上海)科技技术发展有限公司 filed Critical 胜斗士(上海)科技技术发展有限公司
Publication of WO2022063118A1 publication Critical patent/WO2022063118A1/en

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201Market modelling; Market analysis; Collecting market data
    • G06Q30/0206Price or cost determination based on market factors
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/219Managing data history or versioning
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/95Retrieval from the web
    • G06F16/953Querying, e.g. by the use of web search engines
    • G06F16/9537Spatial or temporal dependent retrieval, e.g. spatiotemporal queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/10Complex mathematical operations
    • G06F17/18Complex mathematical operations for evaluating statistical data, e.g. average values, frequency distributions, probability functions, regression analysis
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201Market modelling; Market analysis; Collecting market data
    • G06Q30/0202Market predictions or forecasting for commercial activities

Definitions

  • the present application relates to quantitative evaluation of data, and in particular, to a method and apparatus for determining price sensitivity based on historical sales data for a product.
  • the quantitative analysis of the price sensitivity of stores is mainly based on the traditional economic price sensitivity model.
  • the main variables of the economics price sensitivity model are usually only the product sales volume of the store in a period of time and the product sales price in the period of time.
  • the specific value of the price sensitivity is obtained by calculating the ratio of the change in the sales volume of the product to the change in the sales price of the product (eg, the change in percentage). Normally this value is negative.
  • the present application proposes an improved method and apparatus for determining price sensitivity to obtain a more accurate price sensitivity assessment result. Users provide accurate sales trends to help develop pricing strategies.
  • a method for determining price sensitivity comprising:
  • the historical data sequence is composed of historical data associated with the historical time in the historical time series, wherein the historical data includes historical sales volume data and historical price data of the product;
  • a regression model is used to determine an optimal trend polynomial corresponding to a product's sales trend, and a price sensitivity is determined based on the optimal trend polynomial, wherein the product's
  • the sales volume data is represented as a trend polynomial with price data as the independent variable.
  • an apparatus for determining price sensitivity comprising:
  • the historical data sequence generating unit is configured to generate a historical data sequence based on the historical sales data of the product, the historical data sequence is composed of historical data associated with the historical time in the historical time series, wherein the historical data includes the historical sales volume data of the product and historical price data;
  • a historical data sequence processing unit configured to generate a processed historical data sequence by removing the part affected by the periodic factor in the historical data sequence
  • a price sensitivity determination unit configured to use a regression model to determine an optimal trend polynomial corresponding to a sales trend of a product based on a plurality of trend polynomials corresponding to predetermined sales trends and the processed historical data series, and based on the optimal trend
  • the polynomial determines price sensitivity, where the sales volume data for a product is represented as a trend polynomial with price data as the independent variable.
  • a computer-readable storage medium on which a computer program is stored, the computer program comprising executable instructions, which, when executed by a processor, implement the method according to the above .
  • an electronic device comprising a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to execute the executable instructions to implement the above-mentioned method.
  • FIG. 1 is a schematic logic flow diagram of a process of determining price sensitivity and formulating a corresponding price strategy according to an example embodiment of the present application
  • FIG. 2 is a schematic flowchart of a method for determining price sensitivity according to an example embodiment of the present application
  • FIG. 3 is a schematic structural block diagram of an apparatus for determining price sensitivity according to an exemplary embodiment of the present application.
  • FIG. 4 is a schematic block diagram of an electronic device for determining price sensitivity according to an example embodiment of the present application.
  • the sales volume entity is sales volume data representing product sales volume information of sales units during a certain time interval.
  • the sales volume data generally refers to the total product sales volume of the sales unit, and can be obtained by calculating, for example, the sum of the sales volume of each product, weighting the sales volume of different products based on a preset weight, and/or other methods.
  • the price entity is price data representing price information of the product sold in the sales unit during the time interval corresponding to the sales volume entity. In the traditional economic price sensitivity model, the price entity is generally the average of the official sales price or obtained by weighting the official sales price based on a preset weight.
  • the price entity may be the actual selling price of the product (since the customer's sensitivity to the actual selling price is more related to the actual value paid for purchasing the product) or the official selling price.
  • the price entity may also be obtained by processing, such as weighted or weighted average, of the product's sales price based on the product's category and/or sales volume.
  • Time intervals can be days, weeks, months, quarters, years, hours, minutes, etc., depending on the product category and/or assessment needs.
  • the application is presented with the example of a week, but the application is not limited to the weekly price sensitivity.
  • a sales unit represents an object for evaluating price sensitivity, and can be a sales store located in the same, adjacent, or different sales location, or the sales location itself.
  • the method flow of determining the price sensitivity and formulating the corresponding price strategy is described by taking a sales store as an example.
  • price sensitivity is defined as the ratio of the changes of the sales volume entity and the price entity, that is, the ratio of the changes of the sales volume entity as the sales volume data to the price entity as the price data.
  • the sales volume entity is not only related to the sales price, but also affected by other external factors.
  • the traditional economic model may take into account that the sales volume entity is affected by factors other than the sales price, because its model is based on the assumption that only the price entity is considered, it cannot exclude other external factors that affect the relationship between the sales volume entity and the price entity. The interference of the interrelationships causes inaccurate and unstable assessment of price sensitivity.
  • step 110 historical sales data of the store is obtained.
  • the historical sales data of the store is counted at a selected time interval (for example, every week), for example, for the 1st week, the 2nd week, ..., the nth week, the weekly sales volume entity and the price entity of the store are created respectively.
  • the sales volume entity and the price entity are associated with the corresponding week numbers.
  • a week or a week is a time interval between adjacent historical times T, or is referred to as a time unit for measuring the historical time T. If the serial number of the week is denoted as k, the historical time of the kth week can be denoted as T k .
  • the historical time T k constitutes a historical time series ⁇ T k ⁇ (1 ⁇ k ⁇ n, k is a positive integer).
  • Historical sales data can be refined to the category of the product, the actual sale price of the product, and the actual transaction data detail of the date of sale (eg, the week in which the sale was made).
  • the weekly sales volume entity and the price entity of the store are created.
  • the Weekly Sales entity can be created by summing the product sales for that week.
  • Weekly Price attributes can be created by taking the average price of a product for the week weighted proportionally to the sales volume of the category.
  • the weight of the sales volume ratio of the category can also be used as the product sales volume ratio of the historical time Tk (such as a week). The weights are weighted average to calculate the price entity.
  • the historical data D k is a two-dimensional variable, and its sub-variables M k and P k can be one-dimensional or multi-dimensional variables according to the creation method of the corresponding historical sales volume entity and historical price entity.
  • a historical data series ⁇ D k ⁇ is associated with a historical time series ⁇ T k ⁇ , where D k is associated with T k .
  • the problem of determining price sensitivity based on the historical sales data of a product can be transformed into calculating the sales volume entity (sales data) and the price entity (price based on the historical data sequence ⁇ D k ⁇ corresponding to the historical time series ⁇ T k ⁇ ). data) to guide future price strategies.
  • it can also be seen as calculating price sensitivity based on a data sequence ⁇ Dk, Tk ⁇ or ⁇ Mk , Pk , Tk ⁇ .
  • the historical data in the historical data series includes the part affected by periodic factors, and this part of the interference needs to be removed during the price sensitivity calculation process of this application.
  • Periodic factors include holiday factors and seasonal factors. The following will remove the holiday factors and seasonal factors respectively to obtain the processed historical data series ⁇ D k * ⁇ .
  • step 122 the sales volume entities affected by holiday factors are removed from the historical data sequence ⁇ D k ⁇ , that is, the historical data ⁇ M i , P i ⁇ at the historical time T i are removed, where 1 ⁇ i ⁇ n, i is a positive integer.
  • the holiday factors include Gregorian holidays that appear on a fixed date each year and lunar holidays that do not appear on a fixed date. Since the dates of the holidays on the lunar calendar are not fixed, it is inconvenient to remove them in the periodic time series processing method based on statistics, so this part of the historical data elements D i need to be removed from the historical data sequence ⁇ D k ⁇ separately.
  • the historical data D i corresponding to all the lunar holidays and/or the solar holidays can be removed, or the lunar holidays and the solar holidays related to the year can be cross-referenced, which will only result in weekly
  • the historical data D i corresponding to the holidays of the lunar calendar and/or the solar calendar with the misplaced holidays are removed.
  • the number of elements is generally smaller than the number of elements of the original historical data sequence ⁇ D k ⁇ , and the number of elements of the corresponding historical time series ⁇ T k * ⁇ is also smaller than that of the original historical data sequence ⁇ D k * ⁇ .
  • step 122 components affected by seasonal factors in the value of the historical sales volume entity Mk in the historical data Dk are removed.
  • Seasonal factors include, for example, the influence of product sales in winter and summer due to differences in temperature.
  • STL Seasonal Trend decomposition procedure based on Loss (STL)
  • each historical data D k in the historical data series ⁇ D k ⁇ is divided into The value of the historical sales entity M k of , is split into three parts, which are the component corresponding to the influence of seasonal factors, the component associated with the sales trend, and the white noise component.
  • the value of the component corresponding to the influence of seasonal factors is deleted from the value of the historical sales entity Mk , and only the values corresponding to the other two components are retained. It can be seen that in step 122, the historical data element Dk is not removed using the STL method, but a part of the value of its sub-variable historical sales entity Mk is deleted. That is to say, the number of elements of the historical data sequence processed by the STL method is not reduced, which is different from the process of removing the influence of holiday factors in step 121 . In traditional economics price sensitivity models, at least one of holiday factors and seasonal factors is generally not considered.
  • At least one of the part affected by holiday factors and the part affected by seasonal factors may be performed to generate processed historical data before inputting the historical data series ⁇ D k ⁇ into the regression model sequence ⁇ Dk * ⁇ .
  • a logarithmic operation may be applied to the sales volume entity Mk * and the price entity Pk in the historical data Dk * in the created processed historical data sequence ⁇ Dk * ⁇ , respectively, eg Use the natural logarithm operation.
  • the benefit of using logarithmic operations is to simplify price sensitivity calculations later on, which are described below.
  • the historical data sequence processed above is input into the regression model in step 150 to perform linear regression to complete the process of fitting the historical trend.
  • the input to the regression model in addition to the processed historical data sequence ⁇ Dk * ⁇ , also includes the set of trend polynomials provided in step 151 for fitting a predetermined sales trend, the set including at least one trend polynomial, each Trend polynomials all correspond to predetermined sales trends.
  • a trend polynomial that fits a predetermined sales trend is a polynomial based on a time variable that provides a trend alternative to the regression model.
  • the sales trends of stores are generally divided into three categories: rising, falling and fluctuating trends, and the change parameters in each type of sales trend are different.
  • the sales trend polynomial is a linear relationship with the sales volume entity (sales volume data) of the product as the dependent variable and the price entity (price data) as the independent variable, so the regression model is used to determine the optimal trend that can accurately fit the sales trend of the store
  • a polynomial to determine the price sensitivity defined by the ratio of the magnitude of changes in the sales volume and price entities.
  • the order of the terms of the price entity in the sales trend polynomial can be between -0.25 and +4.
  • the method used to determine price sensitivity models each store, so to accommodate the unique sales trends of each store, a collection of trend polynomials (i.e. pools of candidates) is provided for the method to automatically try to determine the appropriateness for the current store.
  • the optimal trend polynomial of , and the coefficients of the correlation terms are examples of the optimal trend polynomial of , and the coefficients of the correlation terms.
  • the regression model may be a linear regression model, and a step-wise regression linear model is used below to describe the solution of the present application.
  • the stepwise regression linear model is a linear regression independent variable selection model. Each time a new independent variable is introduced, an F test is performed, and a t test is performed for the independent variables that have been selected one by one. When a previously introduced independent variable becomes no longer significant (or causes multicollinearity) due to the introduction of a later independent variable, the previously introduced independent variable is deleted to ensure that the regression is performed before each new independent variable is introduced. Only significant variables are included in the equation or polynomial.
  • Stepwise regression of variable introduction and validation is performed repeatedly until neither significant independent variables are introduced into the regression equation or polynomial, and no insignificant independent variables are removed from the regression equation or polynomial. This can ensure that the finally obtained set of independent variables is optimal for the fitting of the regression equation or polynomial, that is, each independent variable in the obtained set of independent variables is significant relative to the regression equation or polynomial.
  • an expected fitting target (such as a fitting error threshold) can also be set, so that when the expected fitting target cannot be met, it can be determined that the regression equation or polynomial cannot meet the requirements based on the current input set of independent variables. The best fit, or that the regression equation or polynomial is not the best fit equation or polynomial corresponding to the input set of independent variables.
  • the price entity of the historical data in the processed historical data sequence is used as a fixed independent variable
  • the trend polynomial corresponding to the predetermined sales trend is used as a variable independent variable
  • the sales volume entity in the historical data is used as the dependent variable
  • Common input stepwise regression linear model Each time a trend polynomial is selected from the trend polynomial set for step-by-step fitting, and all the historical data D k * in the historical data sequence ⁇ D k * ⁇ are sequentially introduced into the trend polynomial to test and judge that the historical data D k * is relative to the trend polynomial. The significance of this trend polynomial.
  • historical data can be traversed from front to back in chronological order, or historical data can be traversed from back to front. If all the historical data introduced into the stepwise regression linear model are removed from the significant data, the fitting of the retained significant historical data for the trend polynomial meets the expected fitting target, and it can be determined that the trend polynomial can be accurate to characterize the relationship between the sales volume entity and the price entity in the historical data sequence ⁇ D k * ⁇ .
  • the desired fit target may be, for example, that the error of fitting the significant historical data set to the trend polynomial is within the desired error threshold.
  • the price sensitivity determination method of the present application can also adopt other regression models, as long as the model can take the historical data in the processed historical data series as the fixed independent variable of the input regression model, and convert multiple trends corresponding to the predetermined sales trends
  • the polynomial is used as the variable independent variable of the input regression model, and the sales entity in the historical data in the processed historical data series is used as the dependent variable of the input regression model, and the significant historical data is retained through the regression operation and determined to meet the expectations.
  • the optimal trend polynomial for the target can take the historical data in the processed historical data series as the fixed independent variable of the input regression model, and convert multiple trends corresponding to the predetermined sales trends
  • the polynomial is used as the variable independent variable of the input regression model, and the sales entity in the historical data in the processed historical data series is used as the dependent variable of the input regression model, and the significant historical data is retained through the regression operation and determined to meet the expectations.
  • the optimal trend polynomial for the target is used as the variable independent variable of the input regression model
  • a temporal weight-based attention mechanism may also be added before the processed historical data sequence ⁇ D k * ⁇ is input into the regression model.
  • the attention mechanism is used to adjust the influence of the historical data D k * corresponding to different historical time T k * on the fitting trend polynomial in the regression operation. For example, historical sales volume data generated recently should be more representative of store sales trends than historical sales volume data generated relatively far back in time.
  • the attention mechanism uses a polynomial based on the time variable to calculate the weights, adjusting the effect of historical time on the trend regression operation. For example, it can be ensured that the historical sales volume entity in the more recent historical data Dk * has a higher weight.
  • the weekly ordinal k of the historical time T k in the historical time series ⁇ T k * ⁇ is used as the time variable, and the polynomial is selected as the power of k, such as k 0.5 to the power k 0.5 , then each historical The data Dk * is weighted with a power of k (k 0.5 ). The closer to the historical data of the current time, the larger its k value, and thus the larger its weight k 0.5 .
  • the output of the regression model is the determined optimal trend polynomial corresponding to the sales trend of the product, and the price sensitivity can be determined according to the optimal trend polynomial.
  • the price sensitivity is related to the coefficient of the term in the optimal trend polynomial including the price entity of the historical data Dk * . Since the logarithmic operation has been performed on the historical sales volume entity and the price entity in the historical data Dk * in step 140, although the regression model uses the historical data Dk * in the historical data series ⁇ Dk * ⁇ and the trend polynomial Predicts store sales trends, but the coefficients of terms with price entities can be used directly to calculate price sensitivity. When the natural logarithm operation is used in step 140, the coefficient of the term including the price entity is effectively equivalent to the price sensitivity.
  • the historical data D k * (1 ⁇ k ⁇ m, m is retained after removing the insignificant historical data, which is included as a fixed independent variable in the optimal trend polynomial is also generated.
  • the significance value p (0 ⁇ p ⁇ 1) of the coefficient corresponding to the item of the historical price entity in the number of historical data).
  • the significance value p characterizes the reliability of using the coefficient corresponding to the term in the optimal trend polynomial including the historical price entity to accurately characterize the sales trend.
  • the weighted price sensitivity is obtained by weighting according to the significance value p corresponding to each historical data D k * , as shown in Figure 1 Step 160 is described.
  • the weight corresponding to the historical data with the significance value p may be a value calculated based on a polynomial of p, such as (1-p) 2 .
  • the price sensitivity weighting operation based on the significance coefficient p is used to penalize the insignificant coefficients, so that the calculated price sensitivity has higher significance and higher credibility.
  • the above steps can be used to obtain the price sensitivity of the corresponding store from the store's historical sales data.
  • the price sensitivity data of different stores can be encapsulated into a flexible sorting data table and provided to the company decision makers or related financial personnel who manage multiple stores.
  • the data table may include, for example, store numbers and significance-weighted price sensitivity.
  • the price sensitivity is the coefficient of the weighted price entity term.
  • the calculated price sensitivity can be notified or distributed to the user, eg, by mail or message.
  • step 171 the price sensitivity of each store is sorted and a price strategy is applied.
  • the larger the absolute value of the price sensitivity (weighted coefficient of the price entity item), the less sensitive the customers of the store are to the price, and the more suitable for implementing the price increase strategy.
  • the absolute value of price sensitivity is smaller, it indicates that customers are more sensitive to price and need to be carefully considered when implementing the price increase strategy.
  • step 172 Another way of applying price strategies based on price sensitivity data is presented in step 172 .
  • This method extracts appropriate thresholds according to the price sensitivity distribution of all stores, and sets a hierarchical strategy according to the threshold interval where the price sensitivity of the stores is located to divide the stores into multiple groups. For example, a group with a higher threshold corresponds to the least price-sensitive stores, and a higher price increase strategy can be applied.
  • a group with a relatively low threshold corresponds to a store that is less sensitive to price, and this group of stores can apply a small price increase strategy.
  • For a group with a central threshold it means that stores that are more sensitive to price can consider maintaining the original price. Groups with lower thresholds indicate that customers in their stores are very price-sensitive and can suggest promotions.
  • FIG. 2 illustrates a method of determining price sensitivity according to an embodiment of the present application.
  • a historical data sequence is generated based on the historical sales data of the product, and the historical data sequence composed of the historical data corresponds to the historical time sequence composed of the associated historical time.
  • historical sales volume data ie, historical sales volume entity
  • historical price data ie, historical price entity
  • a processed historical data series is generated by removing the portion of the historical data series that is affected by periodic factors.
  • Step 220 is used to preprocess the historical data sequence.
  • the preprocessing includes removing historical data associated with a historical time corresponding to at least one of a lunar holiday and a solar holiday in the historical data sequence for holiday factors.
  • the preprocessing includes removing the components affected by seasonal factors in the value of historical sales data in the historical data series based on the STL method for seasonal factors.
  • Logarithmic operations can also be applied to the historical sales volume data and historical price data of the historical data before inputting the processed historical data series into the regression model to facilitate subsequent price sensitivity calculations.
  • the method of the present application may also introduce an attention mechanism by weighting the historical sales volume data of the historical data based on the historical time associated with the historical data in the processed historical data sequence.
  • an optimal trend polynomial corresponding to the sales trend of the product is determined using a regression model in step 230 based on the plurality of trend polynomials corresponding to the predetermined sales trends and the two inputs of the processed historical data series, and further based on The optimal trend polynomial determines price sensitivity.
  • the price entity in the historical data in the processed historical data sequence is used as a fixed independent variable
  • a plurality of trend polynomials corresponding to predetermined sales trends are used as variable independent variables
  • the The sales volume entity in the historical data is used as the dependent variable
  • the significant historical data is retained through the regression operation and the optimal trend polynomial that satisfies the desired fitting target is determined.
  • the coefficients of terms including historical price data can be used to determine price sensitivity.
  • a significance coefficient can also be introduced to weight the coefficients of items including price data to improve the credibility of price sensitivity.
  • a price strategy may be applied according to the sorted results, or grouped based on the thresholds, and corresponding price strategies may be applied to different groups respectively.
  • FIG. 3 shows an apparatus for determining price sensitivity according to an embodiment of the present application.
  • the device 300 includes at least a historical data sequence generating unit 310 , a historical data sequence processing unit 320 , a price sensitivity determining unit 330 and a price strategy generating unit 340 .
  • the historical data sequence generating unit 310 is configured to generate a historical data sequence based on the historical sales data of the product.
  • the unit 310 may also be used to implement the specific functions described in step 210 above.
  • the historical data sequence processing unit 320 is configured to generate a processed historical data sequence by removing the part affected by periodic factors in the historical data sequence. Further, this unit 320 also implements other functions completed by step 220 in FIG. 2 .
  • the price sensitivity determination unit 330 is configured to realize the two inputs completed in step 230 based on a plurality of trend polynomials corresponding to the predetermined sales trend and the processed historical data series, and use a regression model to determine the most suitable product corresponding to the sales trend of the product.
  • the optimal trend polynomial and further determine the price sensitivity based on the optimal trend polynomial.
  • the price strategy generation unit 340 is configured to apply the price strategy according to the sorted results according to the obtained price sensitivities of the multiple sales units, and/or group them based on their thresholds and apply corresponding price strategies for different groups respectively.
  • data preprocessing methods such as STL are used to convert historical data before inputting the regression model. Parts of the data series affected by periodic factors are removed, and a pool of trend polynomial candidates associated with historical time is added to the regression operation, using search-based automatic convergence methods such as stepwise regression linear models.
  • search-based automatic convergence methods such as stepwise regression linear models.
  • an attention mechanism is introduced to strengthen the fitting weight of recent historical data to avoid the dilution of information value caused by a long time line.
  • the solution of the present application successfully fits external factors such as holiday and seasonal factors and store personalization trend factors to the maximum extent.
  • the trend polynomial candidate pool can cover the personalized sales trends of rising, falling and fluctuating stores, including more influences of external factors on store sales.
  • the price sensitivity between the price entity and the sales volume entity determined by the method and device is as close as possible to pure price sensitivity, controlling the impact of external factors on the historical sales volume entity, and the price sensitivity uses traditional economic models almost Unable to calculate. For multiple stores, the store price sensitivity ranking and grouping are ultimately used to guide the store's price strategy at the company level.
  • modules or units of the apparatus for determining price sensitivity are mentioned in the above detailed description, this division is not mandatory. Indeed, according to embodiments of the present application, the features and functions of two or more modules or units described above may be embodied in one module or unit. Conversely, the features and functions of one module or unit described above may be further divided into multiple modules or units to be embodied. Components shown as modules or units may or may not be physical units, ie may be located in one place, or may be distributed over multiple network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the solution of the present application. Those of ordinary skill in the art can understand and implement it without creative effort.
  • a computer-readable storage medium on which a computer program is stored, the program including executable instructions, which, when executed by, for example, a processor, can implement any one of the above
  • the steps of the method for determining price sensitivity described in the Examples can also be implemented in the form of a program product, which includes program code, which is used to cause the program product to run on a terminal device when the program product is executed.
  • the terminal device performs the steps according to various exemplary embodiments of the present application described in the method for determining price sensitivity in this specification.
  • the program product for implementing the above method according to the embodiments of the present application may adopt a portable compact disc read only memory (CD-ROM) and include program codes, and may be executed on a terminal device such as a personal computer.
  • CD-ROM compact disc read only memory
  • the program product of the present application is not limited thereto, and in this document, a readable storage medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.
  • the program product may employ any combination of one or more readable media.
  • the readable medium may be a readable signal medium or a readable storage medium.
  • the readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus or device, or a combination of any of the above. More specific examples (non-exhaustive list) of readable storage media include: electrical connections with one or more wires, portable disks, hard disks, random access memory (RAM), read only memory (ROM), erasable programmable read only memory (EPROM or flash memory), optical fiber, portable compact disk read only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.
  • the computer-readable storage medium may include a data signal propagated in baseband or as part of a carrier wave, carrying readable program code therein. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing.
  • a readable storage medium can also be any readable medium other than a readable storage medium that can transmit, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device.
  • Program code embodied on a readable storage medium may be transmitted using any suitable medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
  • Program code for carrying out the operations of the present application may be written in any combination of one or more programming languages, including object-oriented programming languages—such as Java, C++, etc., as well as conventional procedural Programming Language - such as the "C" language or similar programming language.
  • the program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server execute on.
  • the remote computing device may be connected to the user computing device through any kind of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computing device (eg, using an Internet service provider business via an Internet connection).
  • LAN local area network
  • WAN wide area network
  • an external computing device eg, using an Internet service provider business via an Internet connection
  • an electronic device which may include a processor, and a memory for storing executable instructions of the processor.
  • the processor is configured to perform the steps of the method for determining price sensitivity in any one of the above embodiments by executing the executable instructions.
  • aspects of the present application may be implemented as a system, method or program product. Therefore, various aspects of the present application can be embodied in the following forms, namely: a complete hardware implementation, a complete software implementation (including firmware, microcode, etc.), or a combination of hardware and software aspects, which may be collectively referred to herein as implementations "circuit", “module” or "system”.
  • the electronic device 400 according to this embodiment of the present application is described below with reference to FIG. 4 .
  • the electronic device 400 shown in FIG. 4 is only an example, and should not impose any limitations on the functions and scope of use of the embodiments of the present application.
  • electronic device 400 takes the form of a general-purpose computing device.
  • Components of the electronic device 400 may include, but are not limited to, at least one processing unit 410, at least one storage unit 420, a bus 430 connecting different system components (including the storage unit 420 and the processing unit 410), a display unit 440, and the like.
  • the storage unit stores program codes, and the program codes can be executed by the processing unit 410, so that the processing unit 410 executes various examples according to the present application described in the method for determining price sensitivity in this specification steps of sexual implementation.
  • the processing unit 410 may perform the steps shown in FIG. 1 and FIG. 2 .
  • the storage unit 420 may include a readable medium in the form of a volatile storage unit, such as a random access storage unit (RAM) 4201 and/or a cache storage unit 4202 , and may further include a read only storage unit (ROM) 4203 .
  • RAM random access storage unit
  • ROM read only storage unit
  • the storage unit 420 may also include a program/utility 4204 having a set (at least one) of program modules 4205 including, but not limited to, an operating system, one or more application programs, other program modules, and programs Data, each or some combination of these examples may include an implementation of a network environment.
  • program/utility 4204 having a set (at least one) of program modules 4205 including, but not limited to, an operating system, one or more application programs, other program modules, and programs Data, each or some combination of these examples may include an implementation of a network environment.
  • the bus 430 may be representative of one or more of several types of bus structures, including a memory cell bus or memory cell controller, a peripheral bus, a graphics acceleration port, a processing unit, or a local area using any of a variety of bus structures. bus.
  • the electronic device 400 may also communicate with one or more external devices 500 (eg, keyboards, pointing devices, Bluetooth devices, etc.), with one or more devices that enable a user to interact with the electronic device 400, and/or with Any device (eg, router, modem, etc.) that enables the electronic device 400 to communicate with one or more other computing devices. Such communication may occur through input/output (I/O) interface 450 . Also, the electronic device 400 may communicate with one or more networks (eg, a local area network (LAN), a wide area network (WAN), and/or a public network such as the Internet) through a network adapter 460 . Network adapter 460 may communicate with other modules of electronic device 400 through bus 430 . It should be understood that, although not shown, other hardware and/or software modules may be used in conjunction with electronic device 400, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives and data backup storage systems.
  • the exemplary embodiments described herein may be implemented by software, or may be implemented by software combined with necessary hardware. Therefore, the technical solutions according to the embodiments of the present application may be embodied in the form of software products, and the software products may be stored in a non-volatile storage medium (which may be CD-ROM, U disk, mobile hard disk, etc.) or on the network , including several instructions to cause a computing device (which may be a personal computer, a server, or a network device, etc.) to execute the method for determining price sensitivity according to an embodiment of the present application.
  • a computing device which may be a personal computer, a server, or a network device, etc.

Abstract

A method and apparatus for determining price sensitivity. The method comprises: generating a historical data sequence on the basis of historical sales data of a product; removing, from the historical data sequence, a part thereof that is affected by a cyclical factor, so as to generate a processed historical data sequence; on the basis of a plurality of trend polynomials corresponding to a predetermined sales trend and the processed historical data sequence and by using a regression model, determining an optimal trend polynomial corresponding to the sales trend of the product; and determining price sensitivity on the basis of the optimal trend polynomial. By means of the method and the apparatus of the present application, the influence of external factors in a historical data sequence is removed, and the determined price sensitivity between a price entity and a sales volume entity is as close to pure price sensitivity as possible.

Description

用于确定价格敏感度的方法和装置Method and apparatus for determining price sensitivity
本申请要求于2020年09月23日递交的中国专利申请第202011008732.7号的优先权,在此全文引用上述中国专利申请公开的内容以作为本申请的一部分。This application claims the priority of Chinese Patent Application No. 202011008732.7 filed on September 23, 2020. The contents disclosed in the above Chinese patent application are hereby cited in their entirety as a part of this application.
技术领域technical field
本申请涉及数据的量化评估,特别地,涉及用于基于产品的历史销售数据来确定价格敏感度的方法和装置。The present application relates to quantitative evaluation of data, and in particular, to a method and apparatus for determining price sensitivity based on historical sales data for a product.
背景技术Background technique
在诸如连锁餐饮和零售的服务行业中,需要针对每家门店的销售数据与产品售价之间的价格敏感度进行量化评估以指导门店的产品总体价格的调整策略。In service industries such as chain restaurants and retail, it is necessary to quantitatively evaluate the price sensitivity between each store's sales data and product selling price to guide the store's overall product price adjustment strategy.
目前针对门店的价格敏感度的量化分析主要基于传统的经济学价格敏感度模型。该经济学价格敏感度模型的主要变量通常仅为一段时间间隔内的门店的产品销售量及该段时间间隔内的产品销售价格。通过计算产品销售量的变动幅度与产品销售价格的变动幅度(例如,以百分比形式表示的变动幅度)的比值获得价格敏感度的具体数值。正常情况下该数值为负数。一般来说,价格敏感度数值的绝对值大于1的门店的价格敏感度高而不适合实施提价策略;价格敏感度数值的绝对值小于1的门店的价格敏感度低而适合实施提价策略;而该数值的绝对值等于1的门店被认为价格敏感度达到平衡,从而可保持现状。At present, the quantitative analysis of the price sensitivity of stores is mainly based on the traditional economic price sensitivity model. The main variables of the economics price sensitivity model are usually only the product sales volume of the store in a period of time and the product sales price in the period of time. The specific value of the price sensitivity is obtained by calculating the ratio of the change in the sales volume of the product to the change in the sales price of the product (eg, the change in percentage). Normally this value is negative. Generally speaking, stores whose absolute value of price sensitivity value is greater than 1 have high price sensitivity and are not suitable for implementing price increase strategy; stores whose absolute value of price sensitivity value is less than 1 have low price sensitivity and are suitable for implementing price increase strategy ; and stores whose absolute value is equal to 1 are considered to have balanced price sensitivity, thus maintaining the status quo.
但是,传统的经济学价格敏感度模型主要基于销售量仅受定价影响的假设。而在诸如餐饮零售业的以线下交易为主的市场环境中,产品销售价格仅仅是影响产品销售量的众多因素之一。其它影响因素包括但不限于天气因素,季节性因素,门店的促销折扣活动因素,门店附近的竞争对手的 门店活动(例如竞争对手的新店开业、营销策略),门店的短期变化(例如门店的临时内外部装修施工),门店所处商业环境的长期变化,门店相关的特定事件(例如演唱会,展览等的举办)等。在这些复杂的现实因素的影响下,传统的经济学价格敏感度模型所表征的产品销售价格与销售量之间的关系往往不够准确并且存在不稳定性,导致不精确的价格敏感度评估结果。However, traditional economics price sensitivity models are mainly based on the assumption that sales volume is only affected by pricing. In a market environment dominated by offline transactions such as the catering retail industry, product sales price is only one of many factors that affect product sales. Other influencing factors include but are not limited to weather factors, seasonal factors, store promotions and discounts, store activities of competitors near the store (such as competitors' new store openings, marketing strategies), and short-term changes in stores (such as temporary store openings). Internal and external decoration construction), long-term changes in the business environment where the store is located, specific events related to the store (such as the holding of concerts, exhibitions, etc.), etc. Under the influence of these complex realistic factors, the relationship between product sales price and sales volume represented by traditional economic price sensitivity models is often inaccurate and unstable, resulting in inaccurate price sensitivity assessment results.
因此,存在对价格敏感度的评估方案的改进需求。Therefore, there is a need for improved assessment schemes for price sensitivity.
需要说明的是,在上述背景技术部分公开的信息仅用于加强对本申请背景的理解,因此可以包括不构成对本领域普通技术人员已知的现有技术的信息。It should be noted that the information disclosed in the above background section is only for enhancing understanding of the background of the application, and therefore may include information that does not form the prior art known to a person of ordinary skill in the art.
发明内容SUMMARY OF THE INVENTION
为了解决使用上述传统的经济学价格敏感度模型进行价格敏感度评估的方案的至少一个缺点,本申请提出用于确定价格敏感度的改进方法和装置以获得更准确的价格敏感度评估结果,向用户提供准确的销售趋势以帮助制定价格策略。In order to solve at least one disadvantage of the solution of using the above-mentioned traditional economic price sensitivity model for price sensitivity assessment, the present application proposes an improved method and apparatus for determining price sensitivity to obtain a more accurate price sensitivity assessment result. Users provide accurate sales trends to help develop pricing strategies.
根据本申请的一方面,提出一种用于确定价格敏感度的方法,包括:According to an aspect of the present application, a method for determining price sensitivity is proposed, comprising:
基于产品的历史销售数据生成历史数据序列,历史数据序列由与历史时间序列中的历史时间相关联的历史数据构成,其中,历史数据包括产品的历史销售量数据和历史价格数据;Generate a historical data sequence based on the historical sales data of the product, the historical data sequence is composed of historical data associated with the historical time in the historical time series, wherein the historical data includes historical sales volume data and historical price data of the product;
通过在历史数据序列中移除受到周期性因素影响的部分以生成经处理的历史数据序列;Generate a processed historical data series by removing the part affected by periodic factors in the historical data series;
基于与预定的销售趋势对应的多个趋势多项式和经处理的历史数据序列,使用回归模型确定与产品的销售趋势对应的最优趋势多项式,以及基于最优趋势多项式确定价格敏感度,其中产品的销售量数据被表示为以价格数据作为自变量的趋势多项式。Based on a plurality of trend polynomials corresponding to predetermined sales trends and the processed historical data series, a regression model is used to determine an optimal trend polynomial corresponding to a product's sales trend, and a price sensitivity is determined based on the optimal trend polynomial, wherein the product's The sales volume data is represented as a trend polynomial with price data as the independent variable.
根据本申请的另一方面,还提出一种用于确定价格敏感度的装置,包括:According to another aspect of the present application, an apparatus for determining price sensitivity is also proposed, comprising:
历史数据序列生成单元,被配置为基于产品的历史销售数据生成历史数据序列,历史数据序列由与历史时间序列中的历史时间相关联的历史数据构成,其中,历史数据包括产品的历史销售量数据和历史价格数据;The historical data sequence generating unit is configured to generate a historical data sequence based on the historical sales data of the product, the historical data sequence is composed of historical data associated with the historical time in the historical time series, wherein the historical data includes the historical sales volume data of the product and historical price data;
历史数据序列处理单元,被配置为通过在历史数据序列中移除受到周期性因素影响的部分以生成经处理的历史数据序列;a historical data sequence processing unit, configured to generate a processed historical data sequence by removing the part affected by the periodic factor in the historical data sequence;
价格敏感度确定单元,被配置为基于与预定的销售趋势对应的多个趋势多项式和经处理的历史数据序列,使用回归模型确定与产品的销售趋势对应的最优趋势多项式,以及基于最优趋势多项式确定价格敏感度,其中产品的销售量数据被表示为以价格数据作为自变量的趋势多项式。a price sensitivity determination unit configured to use a regression model to determine an optimal trend polynomial corresponding to a sales trend of a product based on a plurality of trend polynomials corresponding to predetermined sales trends and the processed historical data series, and based on the optimal trend The polynomial determines price sensitivity, where the sales volume data for a product is represented as a trend polynomial with price data as the independent variable.
根据本申请的又一方面,提出一种计算机可读存储介质,其上存储有计算机程序,该计算机程序包括可执行指令,当该可执行指令被处理器执行时,实施根据如上所述的方法。According to yet another aspect of the present application, a computer-readable storage medium is provided, on which a computer program is stored, the computer program comprising executable instructions, which, when executed by a processor, implement the method according to the above .
根据本申请的再一方面,提出一种电子设备,包括处理器;以及存储器,用于存储所述处理器的可执行指令;其中该处理器设置为执行可执行指令以实施根据如上所述的方法。According to yet another aspect of the present application, an electronic device is provided, comprising a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to execute the executable instructions to implement the above-mentioned method.
应当理解的是,以上的一般描述和后文的细节描述仅是示例性和解释性的,并不能限制本申请。It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not limiting of the present application.
附图说明Description of drawings
通过参照附图详细描述其示例性实施例,本申请的上述和其它特征及优点将变得更加明显。The above and other features and advantages of the present application will become more apparent by describing in detail exemplary embodiments thereof with reference to the accompanying drawings.
图1为根据本申请的一个示例实施例的确定价格敏感度以及制定相应价格策略的过程的示意性逻辑流程图;1 is a schematic logic flow diagram of a process of determining price sensitivity and formulating a corresponding price strategy according to an example embodiment of the present application;
图2为根据本申请的一个示例实施例的确定价格敏感度的方法的示意性流程图;FIG. 2 is a schematic flowchart of a method for determining price sensitivity according to an example embodiment of the present application;
图3为根据本申请的一个示例实施例的确定价格敏感度的装置的示意性结构框图;以及3 is a schematic structural block diagram of an apparatus for determining price sensitivity according to an exemplary embodiment of the present application; and
图4为根据本申请的一个示例实施例的确定价格敏感度的电子设备的示意性框图。FIG. 4 is a schematic block diagram of an electronic device for determining price sensitivity according to an example embodiment of the present application.
具体实施方式detailed description
现在将参考附图更全面地描述示例性实施例。然而,示例性实施例能够以多种形式实施,且不应被理解为限于在此阐述的实施方式;相反,提供这些实施方式使得本申请将全面和完整,并将示例性实施例的构思全面地传达给本领域的技术人员。在图中,为了清晰,可能会夸大部分元件的尺寸或加以变形。在图中相同的附图标记表示相同或类似的结构,因而将省略它们的详细描述。Example embodiments will now be described more fully with reference to the accompanying drawings. Exemplary embodiments, however, can be embodied in various forms and should not be construed as limited to the embodiments set forth herein; rather, these embodiments are provided so that this application will be thorough and complete, and will fully convey the concept of exemplary embodiments conveyed to those skilled in the art. In the drawings, the size of most elements may be exaggerated or deformed for clarity. The same reference numerals in the drawings denote the same or similar structures, and thus their detailed descriptions will be omitted.
此外,所描述的特征、结构或特性可以以任何合适的方式结合在一个或更多实施例中。在下面的描述中,提供许多具体细节从而给出对本申请的实施例的充分理解。然而,本领域技术人员将意识到,可以实践本申请的技术方案而没有所述特定细节中的一个或更多,或者可以采用其它的方法、元件等。在其它情况下,不详细示出或描述公知结构、方法或者操作以避免模糊本申请的各方面。Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided in order to give a thorough understanding of the embodiments of the present application. However, one skilled in the art will appreciate that the technical solutions of the present application may be practiced without one or more of the specific details, or other methods, elements, etc. may be employed. In other instances, well-known structures, methods, or operations are not shown or described in detail to avoid obscuring aspects of the application.
在本申请中,引入销售量实体和价格实体的概念。销售量实体是表示在一定时间间隔期间的销售单位的产品销售数量信息的销售量数据。该销售量数据一般指该销售单位的产品总销售量,可以通过计算例如各个产品的销售量的总和、基于预设的权重对不同产品的销售量进行加权、和/或其它方式获得。价格实体是表示对应于销售量实体的时间间隔期间的在销售单位中所销售的产品的价格信息的价格数据。在传统的经济学价格敏感度模型中,价格实体一般为官方销售价格的平均值或基于预设的权重对官方销售价格进行加权获得。根据本申请的实施例,价格实体可以是产品的实际销售价格(因为顾客对实际销售价格的敏感程度与购买产品所付出的实际价值更相关)或官方销售价格。价格实体还可以基于产品的类别和/或销售量对产品的销售价格进行诸如加权或加权平均的处理来获得。In this application, the concepts of sales volume entity and price entity are introduced. The sales volume entity is sales volume data representing product sales volume information of sales units during a certain time interval. The sales volume data generally refers to the total product sales volume of the sales unit, and can be obtained by calculating, for example, the sum of the sales volume of each product, weighting the sales volume of different products based on a preset weight, and/or other methods. The price entity is price data representing price information of the product sold in the sales unit during the time interval corresponding to the sales volume entity. In the traditional economic price sensitivity model, the price entity is generally the average of the official sales price or obtained by weighting the official sales price based on a preset weight. According to an embodiment of the present application, the price entity may be the actual selling price of the product (since the customer's sensitivity to the actual selling price is more related to the actual value paid for purchasing the product) or the official selling price. The price entity may also be obtained by processing, such as weighted or weighted average, of the product's sales price based on the product's category and/or sales volume.
根据产品类别和/或评估需求,时间间隔可以是天、周、月、季度、年,也可以是小时、分钟等。在下文中以周为示例介绍本申请,但是本申请不限于周度价格敏感度。销售单元表示评估价格敏感度的对象,可以是位于相同、临近或不同的销售地点的销售门店,也可以是销售地点本身。在本申请的实施例中以销售门店为例介绍确定价格敏感度以及制定相应价格策略的方法流程。Time intervals can be days, weeks, months, quarters, years, hours, minutes, etc., depending on the product category and/or assessment needs. In the following the application is presented with the example of a week, but the application is not limited to the weekly price sensitivity. A sales unit represents an object for evaluating price sensitivity, and can be a sales store located in the same, adjacent, or different sales location, or the sales location itself. In the embodiments of the present application, the method flow of determining the price sensitivity and formulating the corresponding price strategy is described by taking a sales store as an example.
与传统的经济学模型类似,价格敏感度被定义为销售量实体与价格实体两者的变动幅度之比,即作为销售量数据的销售量实体与作为价格数据的价格实体两者的变化之比。在实际情况中,销售量实体不仅与销售价格相关,还受到其它外部因素影响。传统的经济学模型虽然可能考虑到销售量实体受销售价格之外的因素影响,但是由于其模型建立所基于的假设仅考虑价格实体,因此无法排除其它外部因素对销售量实体-价格实体之间的相互关系的干扰,造成价格敏感度评估的不准确和不稳定。Similar to the traditional economic model, price sensitivity is defined as the ratio of the changes of the sales volume entity and the price entity, that is, the ratio of the changes of the sales volume entity as the sales volume data to the price entity as the price data. . In practice, the sales volume entity is not only related to the sales price, but also affected by other external factors. Although the traditional economic model may take into account that the sales volume entity is affected by factors other than the sales price, because its model is based on the assumption that only the price entity is considered, it cannot exclude other external factors that affect the relationship between the sales volume entity and the price entity. The interference of the interrelationships causes inaccurate and unstable assessment of price sensitivity.
现在结合图1所示的确定价格敏感度以及制定相应价格策略的过程来介绍根据本申请的实施例的价格敏感度评估方法。The method for evaluating price sensitivity according to an embodiment of the present application will now be introduced in conjunction with the process of determining price sensitivity and formulating a corresponding price strategy shown in FIG. 1 .
首先,在步骤110处获取门店的历史销售数据。门店的历史销售数据是以所选择的时间间隔(例如每周)来统计的,例如针对第1周,第2周,…,第n周,分别创建门店的周度销售量实体和价格实体。销售量实体和价格实体与相应的周数相关联。在此,周或星期为相邻的历史时间T之间的时间间隔,或被称为用于计量历史时间T的时间单位。如果将周的序号表示为k,则第k周的历史时间可以表示为T k。历史时间T k构成历史时间序列{T k}(1≤k≤n,k为正整数)。为了消除周期性因素,特别是季节性因素对价格敏感度确定的影响,通常使用门店的至少两年的历史销售数据。历史销售数据可以细化到产品的类别、产品的实际销售价格、销售日期(例如是在第几周销售的)的实际交易数据明细。 First, at step 110, historical sales data of the store is obtained. The historical sales data of the store is counted at a selected time interval (for example, every week), for example, for the 1st week, the 2nd week, ..., the nth week, the weekly sales volume entity and the price entity of the store are created respectively. The sales volume entity and the price entity are associated with the corresponding week numbers. Here, a week or a week is a time interval between adjacent historical times T, or is referred to as a time unit for measuring the historical time T. If the serial number of the week is denoted as k, the historical time of the kth week can be denoted as T k . The historical time T k constitutes a historical time series {T k } (1≤k≤n, k is a positive integer). To eliminate cyclical factors, especially seasonal factors, on the determination of price sensitivity, at least two years of historical sales data for stores are usually used. Historical sales data can be refined to the category of the product, the actual sale price of the product, and the actual transaction data detail of the date of sale (eg, the week in which the sale was made).
分别在步骤121和131中,创建门店的周度销售量实体和价格实体。如上所述,周度销售量实体可以通过计算该周的产品销售量的总和来创建。周度价格实体可以通过该周的产品按类别的销售量比例加权的平均价格来 创建。根据本申请的实施例,还可以通过对更长的时间间隔(例如全月或全年)的产品,按照类别的销售量比例的权重作为该历史时间T k(例如周)的产品销售量比例的权重进行加权平均值来计算价格实体。与历史时间T k对应的历史数据D k包括第k周的产品的历史销售量实体(历史销售量数据)M k和历史价格实体(历史价格数据)P k,则历史销售数据可以表示为历史数据序列{D k}(1≤k≤n,k为正整数),其中历史数据D k=(M k,P k)。历史数据D k为二维变量,其子变量M k和P k根据相应的历史销售量实体和历史价格实体的创建方式,可以是一维或多维变量。历史数据序列{D k}与历史时间序列{T k}相关联,其中D k与T k相关联。这样,基于产品的历史销售数据确定价格敏感度的问题可以转化为基于与历史时间序列{T k}对应的历史数据序列{D k},计算销售量实体(销售量数据)与价格实体(价格数据)之间的价格敏感度以指导未来的价格策略的问题。换一种方式来看,也可以看作基于数据序列{D k,T k}或{M k,P k,T k},计算价格敏感度。 In steps 121 and 131, respectively, the weekly sales volume entity and the price entity of the store are created. As mentioned above, the Weekly Sales entity can be created by summing the product sales for that week. Weekly Price attributes can be created by taking the average price of a product for the week weighted proportionally to the sales volume of the category. According to the embodiments of the present application, for products with a longer time interval (such as a full month or a year), the weight of the sales volume ratio of the category can also be used as the product sales volume ratio of the historical time Tk (such as a week). The weights are weighted average to calculate the price entity. The historical data D k corresponding to the historical time T k includes the historical sales volume entity (historical sales volume data) M k and historical price entity (historical price data) P k of the product in the kth week, then the historical sales data can be expressed as historical Data sequence {D k } (1≤k≤n, k is a positive integer), wherein historical data D k =(M k , P k ). The historical data D k is a two-dimensional variable, and its sub-variables M k and P k can be one-dimensional or multi-dimensional variables according to the creation method of the corresponding historical sales volume entity and historical price entity. A historical data series {D k } is associated with a historical time series {T k }, where D k is associated with T k . In this way, the problem of determining price sensitivity based on the historical sales data of a product can be transformed into calculating the sales volume entity (sales data) and the price entity (price based on the historical data sequence {D k } corresponding to the historical time series {T k }). data) to guide future price strategies. Viewed another way, it can also be seen as calculating price sensitivity based on a data sequence { Dk, Tk} or {Mk , Pk , Tk }.
历史数据序列中的历史数据包括受到周期性因素影响的部分,在本申请的价格敏感度计算过程中需要将这部分干扰移除。周期性因素包括节假日因素和季节性因素,下面分别对节假日因素和季节性因素进行移除处理以获得经处理的历史数据序列{D k *}。 The historical data in the historical data series includes the part affected by periodic factors, and this part of the interference needs to be removed during the price sensitivity calculation process of this application. Periodic factors include holiday factors and seasonal factors. The following will remove the holiday factors and seasonal factors respectively to obtain the processed historical data series {D k * }.
在步骤122中,在历史数据序列{D k}中移除受节假日因素影响的销售量实体,即移除历史时刻T i的历史数据{M i,P i},其中1≤i≤n,i为正整数。节假日因素中,包括以每年的固定日期出现的阳历节假日和不按照固定日期出现的阴历节假日。由于阴历节假日的日期不固定,不便于在基于统计学的周期性时间序列处理方法中移除,因此需要单独从历史数据序列{D k}中移除这部分历史数据元素D i。在所移除的历史数据的选择上,可以将所有阴历节假日和/或阳历节假日所对应的历史数据D i移除,也可以将涉及年份的阴历节假日与阳历节假日交叉对照,仅将导致周度节假日错位的阴历和/或阳历节假日所对应的历史数据D i移除。通过将这些影响对应周的历史数据进行清理,可以保证剩下的历史数据所构成的经处理的历史数据序列{D k *}中的所有历史数据元素在节假日成分上都能够是对等的。经过移除受 节假日因素影响的历史数据序列{D k *}的元素数量一般小于原始历史数据序列{D k}的元素数量,相对应的历史时间序列{T k *}的元素数量也小于原始的历史时间序列{T k}的元素数量。换句话说,经过节假日因素的数据处理,序列中的数据项数减少了。 In step 122, the sales volume entities affected by holiday factors are removed from the historical data sequence {D k }, that is, the historical data {M i , P i } at the historical time T i are removed, where 1≤i≤n, i is a positive integer. The holiday factors include Gregorian holidays that appear on a fixed date each year and lunar holidays that do not appear on a fixed date. Since the dates of the holidays on the lunar calendar are not fixed, it is inconvenient to remove them in the periodic time series processing method based on statistics, so this part of the historical data elements D i need to be removed from the historical data sequence {D k } separately. In the selection of the removed historical data, the historical data D i corresponding to all the lunar holidays and/or the solar holidays can be removed, or the lunar holidays and the solar holidays related to the year can be cross-referenced, which will only result in weekly The historical data D i corresponding to the holidays of the lunar calendar and/or the solar calendar with the misplaced holidays are removed. By cleaning the historical data of the corresponding weeks, it can be ensured that all historical data elements in the processed historical data sequence {D k * } formed by the remaining historical data can be equivalent in terms of holiday components. After removing the elements of the historical data sequence {D k * } affected by holiday factors, the number of elements is generally smaller than the number of elements of the original historical data sequence {D k }, and the number of elements of the corresponding historical time series {T k * } is also smaller than that of the original historical data sequence {D k * }. The number of elements of the historical time series {T k }. In other words, the number of data items in the series is reduced after the holiday factor data processing.
在步骤122中,移除历史数据D k中的历史销售量实体M k的值中受季节性因素影响的成分。季节性因素例如包括冬季、夏季由于气温的不同所造成的产品销售情况的影响。使用在统计学上用于处理时间数据序列的基于损失的季节性趋势分解过程(Seasonal Trend decomposition procedure based on Loss,简称为STL)将历史数据序列{D k}中的每个历史数据D k中的历史销售量实体M k的值拆分为三个部分,分别是与季节性因素影响对应的成分、与销售趋势相关联的成分和白噪声成分。其中与季节性因素影响对应的成分的值被从历史销售量实体M k的值中删除,仅保留另外两个成分对应的值。可以看到,在步骤122中,使用STL方法并未移除历史数据元素D k,而是将其子变量历史销售量实体M k的值删除一部分。也就是说,经过STL方法处理的历史数据序列的元素项数并未减少,这与步骤121中移除节假日因素影响的过程不同。在传统的经济学价格敏感度模型中,一般不会考虑节假日因素和季节性因素中的至少一项。 In step 122, components affected by seasonal factors in the value of the historical sales volume entity Mk in the historical data Dk are removed. Seasonal factors include, for example, the influence of product sales in winter and summer due to differences in temperature. Using the Seasonal Trend decomposition procedure based on Loss (STL), which is statistically used to process time data series, each historical data D k in the historical data series {D k } is divided into The value of the historical sales entity M k of , is split into three parts, which are the component corresponding to the influence of seasonal factors, the component associated with the sales trend, and the white noise component. Among them, the value of the component corresponding to the influence of seasonal factors is deleted from the value of the historical sales entity Mk , and only the values corresponding to the other two components are retained. It can be seen that in step 122, the historical data element Dk is not removed using the STL method, but a part of the value of its sub-variable historical sales entity Mk is deleted. That is to say, the number of elements of the historical data sequence processed by the STL method is not reduced, which is different from the process of removing the influence of holiday factors in step 121 . In traditional economics price sensitivity models, at least one of holiday factors and seasonal factors is generally not considered.
根据本申请的实施例,可以在将历史数据序列{D k}输入到回归模型之前,执行对节假日因素影响的部分和季节性因素影响的部分二者中的至少一个以生成经处理的历史数据序列{D k *}。 According to an embodiment of the present application, at least one of the part affected by holiday factors and the part affected by seasonal factors may be performed to generate processed historical data before inputting the historical data series {D k } into the regression model sequence { Dk * }.
在可选的步骤140中,可以分别对创建的经处理的历史数据序列{D k *}中的历史数据D k *中的销售量实体M k *和价格实体P k应用对数操作,例如采用自然对数操作。使用对数操作的好处在于简化稍后的价格敏感度计算,具体在下文中介绍。 In optional step 140, a logarithmic operation may be applied to the sales volume entity Mk * and the price entity Pk in the historical data Dk * in the created processed historical data sequence { Dk * }, respectively, eg Use the natural logarithm operation. The benefit of using logarithmic operations is to simplify price sensitivity calculations later on, which are described below.
经过上述处理的历史数据序列,在步骤150中输入到回归模型以执行线性回归,完成对历史趋势的拟合过程。The historical data sequence processed above is input into the regression model in step 150 to perform linear regression to complete the process of fitting the historical trend.
回归模型的输入除了经处理的历史数据序列{D k *},还包括在步骤151中提供的用于拟合预定的销售趋势的趋势多项式的集合,该集合中包括至 少一个趋势多项式,每一个趋势多项式都与预定的销售趋势对应。拟合预定的销售趋势的趋势多项式是基于时间变量的多项式,用于提供回归模型的趋势备选。门店的销售趋势一般分为上升、下降和波动三大类趋势,每类销售趋势中的变化参数不同。销售趋势多项式是以产品的销售量实体(销售量数据)作为因变量,价格实体(价格数据)作为自变量的线性关系,因此回归模型用于确定能够准确拟合门店的销售趋势的最优趋势多项式,从而确定由销售量实体和价格实体的变化幅度之比所定义的价格敏感度。销售趋势多项式中的价格实体的项的阶数可以是-0.25至+4之间。用于确定价格敏感度的方法对每家门店进行建模,因此为了适应每个门店的独特销售趋势,提供趋势多项式的集合(即备选池)以供方法自动尝试,从而确定适合于当前门店的最优趋势多项式以及相关项的系数。 The input to the regression model, in addition to the processed historical data sequence { Dk * }, also includes the set of trend polynomials provided in step 151 for fitting a predetermined sales trend, the set including at least one trend polynomial, each Trend polynomials all correspond to predetermined sales trends. A trend polynomial that fits a predetermined sales trend is a polynomial based on a time variable that provides a trend alternative to the regression model. The sales trends of stores are generally divided into three categories: rising, falling and fluctuating trends, and the change parameters in each type of sales trend are different. The sales trend polynomial is a linear relationship with the sales volume entity (sales volume data) of the product as the dependent variable and the price entity (price data) as the independent variable, so the regression model is used to determine the optimal trend that can accurately fit the sales trend of the store A polynomial to determine the price sensitivity defined by the ratio of the magnitude of changes in the sales volume and price entities. The order of the terms of the price entity in the sales trend polynomial can be between -0.25 and +4. The method used to determine price sensitivity models each store, so to accommodate the unique sales trends of each store, a collection of trend polynomials (i.e. pools of candidates) is provided for the method to automatically try to determine the appropriateness for the current store. The optimal trend polynomial of , and the coefficients of the correlation terms.
根据本申请的实施例,回归模型可以是线性回归模型,并在下文中采用逐步回归线性(Step-wise regression linear)模型描述本申请的方案。逐步回归线性模型作为一种线性回归自变量选择模型,其基本思想是将自变量逐个引入模型,引入条件例如可以是自变量的偏回归平方和应当被验证是具有显著性的。每引入一个新的自变量后都要进行F检验,并对已经选入的自变量逐个进行t检验。当先前引入的自变量由于后面的自变量的引入而变得不再显著(或者说导致多重共线性)时,将该先前引入的自变量删除,以确保每次引入新的自变量之前在回归方程或多项式中只包含显著性变量。反复执行变量引入和验证的逐步回归,直到既没有显著的自变量被引入回归方程或多项式,也没有不显著的自变量从回归方程或多项式中被删除为止。这样可以保证最后所得到的自变量的集合对于回归方程或多项式的拟合是最优的,即所得的自变量集合中每一个自变量相对回归方程或多项式都是显著的。在逐步回归模型中,还可以设置期望拟合目标(例如拟合误差阈值),使得当无法满足期望拟合目标时可以认定基于当前的自变量输入集合无法对该回归方程或多项式实现满足要求的最优拟合,或者说该回归方程或多项式并不是与自变量输入集合对应的最优拟合方程或多项式。According to the embodiment of the present application, the regression model may be a linear regression model, and a step-wise regression linear model is used below to describe the solution of the present application. The stepwise regression linear model is a linear regression independent variable selection model. Each time a new independent variable is introduced, an F test is performed, and a t test is performed for the independent variables that have been selected one by one. When a previously introduced independent variable becomes no longer significant (or causes multicollinearity) due to the introduction of a later independent variable, the previously introduced independent variable is deleted to ensure that the regression is performed before each new independent variable is introduced. Only significant variables are included in the equation or polynomial. Stepwise regression of variable introduction and validation is performed repeatedly until neither significant independent variables are introduced into the regression equation or polynomial, and no insignificant independent variables are removed from the regression equation or polynomial. This can ensure that the finally obtained set of independent variables is optimal for the fitting of the regression equation or polynomial, that is, each independent variable in the obtained set of independent variables is significant relative to the regression equation or polynomial. In the stepwise regression model, an expected fitting target (such as a fitting error threshold) can also be set, so that when the expected fitting target cannot be met, it can be determined that the regression equation or polynomial cannot meet the requirements based on the current input set of independent variables. The best fit, or that the regression equation or polynomial is not the best fit equation or polynomial corresponding to the input set of independent variables.
在回归模型中,经过处理的历史数据序列中的历史数据的价格实体作为固定自变量,与预定的销售趋势对应的趋势多项式作为可变自变量,将历史数据中的销售量实体作为因变量,共同输入逐步回归线性模型。每次从趋势多项式集合中选取一个趋势多项式进行逐步拟合,将历史数据序列{D k *}中的所有历史数据D k *依次引入该趋势多项式以检验和判断该历史数据D k *相对于该趋势多项式的显著性。对于回归运算,可以按照时间顺序从前向后遍历历史数据,也可以从后向前遍历历史数据。如果将所有引入逐步回归线性模型中的历史数据完成显著性数据剔除之后,所保留的具有显著性的历史数据的集合对于该趋势多项式的拟合满足期望拟合目标,可以确定该趋势多项式可以准确地表征历史数据序列{D k *}中的销售量实体和价格实体之间的关系。期望拟合目标例如可以是,显著性历史数据集合拟合到该趋势多项式的误差在期望误差阈值之内。如果所保留的历史数据集合对于趋势多项式无法满足期望拟合目标,说明该趋势多项式无法准确表征历史数据序列{D k *}中的销售量实体和价格实体之间的关系,方法从趋势多项式集合中选取其它趋势多项式并重新上述回归计算过程。 In the regression model, the price entity of the historical data in the processed historical data sequence is used as a fixed independent variable, the trend polynomial corresponding to the predetermined sales trend is used as a variable independent variable, and the sales volume entity in the historical data is used as the dependent variable, Common input stepwise regression linear model. Each time a trend polynomial is selected from the trend polynomial set for step-by-step fitting, and all the historical data D k * in the historical data sequence {D k * } are sequentially introduced into the trend polynomial to test and judge that the historical data D k * is relative to the trend polynomial. The significance of this trend polynomial. For regression operations, historical data can be traversed from front to back in chronological order, or historical data can be traversed from back to front. If all the historical data introduced into the stepwise regression linear model are removed from the significant data, the fitting of the retained significant historical data for the trend polynomial meets the expected fitting target, and it can be determined that the trend polynomial can be accurate to characterize the relationship between the sales volume entity and the price entity in the historical data sequence {D k * }. The desired fit target may be, for example, that the error of fitting the significant historical data set to the trend polynomial is within the desired error threshold. If the retained historical data set cannot meet the expected fitting target for the trend polynomial, it means that the trend polynomial cannot accurately represent the relationship between the sales volume entity and the price entity in the historical data series {D k * }. Select other trend polynomials in and repeat the above regression calculation process.
本申请的价格敏感度确定方法还可以采用其它回归模型,只要该模型能够将经处理的历史数据序列中的历史数据作为输入回归模型的固定自变量,将与预定的销售趋势对应的多个趋势多项式作为输入回归模型的可变自变量,将经处理的历史数据序列中的历史数据中的销售量实体作为输入回归模型的因变量,通过回归运算保留具有显著性的历史数据并确定满足期望拟合目标的最优趋势多项式。The price sensitivity determination method of the present application can also adopt other regression models, as long as the model can take the historical data in the processed historical data series as the fixed independent variable of the input regression model, and convert multiple trends corresponding to the predetermined sales trends The polynomial is used as the variable independent variable of the input regression model, and the sales entity in the historical data in the processed historical data series is used as the dependent variable of the input regression model, and the significant historical data is retained through the regression operation and determined to meet the expectations. The optimal trend polynomial for the target.
如步骤152所示,还可以在将经过处理的历史数据序列{D k *}输入到回归模型之前,加入基于时间权重的注意力机制。注意力机制用于调节不同的历史时间T k *所对应的历史数据D k *对回归运算中拟合趋势多项式的影响。例如,最近产生的历史销售量数据应当比相对久远的时间产生的历史销售量数据更能代表门店的销售趋势。注意力机制使用基于时间变量的多项式来计算权重,调整历史时间对趋势回归运算的作用。例如,可以确保越近期的历史数据D k *中的历史销售量实体具有越高的权重。根据本申请 的实施例,以历史时间序列{T k *}中的历史时间T k的周序数k作为时间变量,多项式选择为k的幂,例如k的0.5次幂k 0.5,则每个历史数据D k *采用k的幂(k 0.5)进行加权。距离当前时间的历史数据越近,其k值越大,从而其权重k 0.5越大。 As shown in step 152, a temporal weight-based attention mechanism may also be added before the processed historical data sequence {D k * } is input into the regression model. The attention mechanism is used to adjust the influence of the historical data D k * corresponding to different historical time T k * on the fitting trend polynomial in the regression operation. For example, historical sales volume data generated recently should be more representative of store sales trends than historical sales volume data generated relatively far back in time. The attention mechanism uses a polynomial based on the time variable to calculate the weights, adjusting the effect of historical time on the trend regression operation. For example, it can be ensured that the historical sales volume entity in the more recent historical data Dk * has a higher weight. According to the embodiments of the present application, the weekly ordinal k of the historical time T k in the historical time series {T k * } is used as the time variable, and the polynomial is selected as the power of k, such as k 0.5 to the power k 0.5 , then each historical The data Dk * is weighted with a power of k (k 0.5 ). The closer to the historical data of the current time, the larger its k value, and thus the larger its weight k 0.5 .
回归模型的输出为所确定的与产品的销售趋势对应的最优趋势多项式,根据该最优趋势多项式可以确定价格敏感度。根据价格敏感度的定义,价格敏感度与最优趋势多项式中的包括历史数据D k *的价格实体的项的系数有关。由于在步骤140中已经对历史数据D k *中的历史销售量实体和价格实体进行过对数运算,因此虽然回归模型使用历史数据序列{D k *}中的历史数据D k *和趋势多项式预测门店的销售趋势,但是含有价格实体的项的系数可以直接用于计算价格敏感度。当在步骤140中使用自然对数运算时,包括价格实体的项的系数实际上等同于价格敏感度。 The output of the regression model is the determined optimal trend polynomial corresponding to the sales trend of the product, and the price sensitivity can be determined according to the optimal trend polynomial. According to the definition of price sensitivity, the price sensitivity is related to the coefficient of the term in the optimal trend polynomial including the price entity of the historical data Dk * . Since the logarithmic operation has been performed on the historical sales volume entity and the price entity in the historical data Dk * in step 140, although the regression model uses the historical data Dk * in the historical data series { Dk * } and the trend polynomial Predicts store sales trends, but the coefficients of terms with price entities can be used directly to calculate price sensitivity. When the natural logarithm operation is used in step 140, the coefficient of the term including the price entity is effectively equivalent to the price sensitivity.
在回归模型确定最优趋势多项式的过程中,还生成与最优趋势多项式中的包括作为固定自变量的历史数据D k *(1≤k≤m,m为剔除不显著的历史数据后保留的历史数据的数量)中的历史价格实体的项所对应的系数的显著性值p(0<p<1)。显著性值p表征采用该最优趋势多项式中的包括历史价格实体的项所对应的系数以准确表征销售趋势的可信度。对于最优趋势多项式中包括作为固定自变量的历史价格实体的项的系数,按照每个历史数据D k *所对应的显著性值p进行加权获取加权后的价格敏感度,如图1中的步骤160所述。具有显著性值p的历史数据所对应的权重可以是基于p的多项式,例如(1-p) 2,所计算的值。基于显著性系数p的价格敏感度加权运算用于惩罚不显著的系数,使计算出的价格敏感度具有更高显著性和更高的可信度。 In the process of determining the optimal trend polynomial by the regression model, the historical data D k * (1≤k≤m, m is retained after removing the insignificant historical data, which is included as a fixed independent variable in the optimal trend polynomial is also generated. The significance value p (0<p<1) of the coefficient corresponding to the item of the historical price entity in the number of historical data). The significance value p characterizes the reliability of using the coefficient corresponding to the term in the optimal trend polynomial including the historical price entity to accurately characterize the sales trend. For the coefficient of the item including the historical price entity as a fixed independent variable in the optimal trend polynomial, the weighted price sensitivity is obtained by weighting according to the significance value p corresponding to each historical data D k * , as shown in Figure 1 Step 160 is described. The weight corresponding to the historical data with the significance value p may be a value calculated based on a polynomial of p, such as (1-p) 2 . The price sensitivity weighting operation based on the significance coefficient p is used to penalize the insignificant coefficients, so that the calculated price sensitivity has higher significance and higher credibility.
可以针对不同的门店,分别使用上述步骤从门店的历史销售数据获得对应门店的价格敏感度。不同门店的价格敏感度数据可以封装成一个灵活排序的数据表提供给管理多个门店的公司决策者或相关财务人员。数据表例如可以包括门店编号和经过显著性加权后得到的价格敏感度。例如,在上文的示例性实施例中,价格敏感度为加权后的价格实体项的系数。For different stores, the above steps can be used to obtain the price sensitivity of the corresponding store from the store's historical sales data. The price sensitivity data of different stores can be encapsulated into a flexible sorting data table and provided to the company decision makers or related financial personnel who manage multiple stores. The data table may include, for example, store numbers and significance-weighted price sensitivity. For example, in the above exemplary embodiment, the price sensitivity is the coefficient of the weighted price entity term.
所计算的价格敏感度可以通过例如邮件或消息的方式通知或分发给用户。The calculated price sensitivity can be notified or distributed to the user, eg, by mail or message.
用户在获得门店的价格敏感度数据后,可以针对不同的价格敏感度情况在门店实施相应的价格策略。例如,在步骤171中,对各个门店的价格敏感度进行排序,并应用价格策略。根据实施例,价格敏感度(价格实体项的加权系数)绝对值越大说明该门店的顾客对价格越不敏感,越适合实施提价策略。相反,如果价格敏感度绝对值越小,说明顾客对价格更敏感,在实施提价策略时需要谨慎考虑。After obtaining the price sensitivity data of the store, users can implement corresponding price strategies in the store according to different price sensitivity situations. For example, in step 171, the price sensitivity of each store is sorted and a price strategy is applied. According to the embodiment, the larger the absolute value of the price sensitivity (weighted coefficient of the price entity item), the less sensitive the customers of the store are to the price, and the more suitable for implementing the price increase strategy. On the contrary, if the absolute value of price sensitivity is smaller, it indicates that customers are more sensitive to price and need to be carefully considered when implementing the price increase strategy.
在步骤172中提出了另一种基于价格敏感度数据应用价格策略的方式。该方式根据所有门店的价格敏感度分布,提取适当的阈值并根据门店的价格敏感度所在的阈值区间设定分层策略以将门店分成多个分组。例如,阈值较高的分组对应于对价格最不敏感的门店,可以应用较高幅度的提价策略。相应地,阈值相对不高的分组对应于对价格不太敏感的门店,该组门店可以应用小幅度的提价策略。对于阈值居中的分组,其表示对于价格较敏感的门店,该组门店可以考虑维持原价。而阈值较低的分组表示其门店的客户对价格非常敏感,可以建议进行促销活动。Another way of applying price strategies based on price sensitivity data is presented in step 172 . This method extracts appropriate thresholds according to the price sensitivity distribution of all stores, and sets a hierarchical strategy according to the threshold interval where the price sensitivity of the stores is located to divide the stores into multiple groups. For example, a group with a higher threshold corresponds to the least price-sensitive stores, and a higher price increase strategy can be applied. Correspondingly, a group with a relatively low threshold corresponds to a store that is less sensitive to price, and this group of stores can apply a small price increase strategy. For a group with a central threshold, it means that stores that are more sensitive to price can consider maintaining the original price. Groups with lower thresholds indicate that customers in their stores are very price-sensitive and can suggest promotions.
图2示出根据本申请的实施例的确定价格敏感度的方法。FIG. 2 illustrates a method of determining price sensitivity according to an embodiment of the present application.
在步骤210中,基于产品的历史销售数据生成历史数据序列,由历史数据构成的历史数据序列与由相关联的历史时间的历史时间序列对应。对于历史数据的两个子变量历史销售量数据(即历史销售量实体)和历史价格数据(即历史价格实体)的确定方法已经在上文中描述。In step 210, a historical data sequence is generated based on the historical sales data of the product, and the historical data sequence composed of the historical data corresponds to the historical time sequence composed of the associated historical time. The determination methods for the two sub-variables of historical data, historical sales volume data (ie, historical sales volume entity) and historical price data (ie, historical price entity), have been described above.
在步骤220中,通过在历史数据序列中移除受到周期性因素影响的部分以生成经处理的历史数据序列。步骤220用于对历史数据序列进行预处理。该预处理包括针对节假日因素,在历史数据序列中移除与阴历节假日和阳历节假日中的至少一个对应的历史时间相关联的历史数据。预处理海包括针对季节性因素,基于STL方法将历史数据序列中的历史销售量数据的值中受到季节性因素影响的成分移除。在将经处理的历史数据序列输入到回归模型之前,还可以对历史数据的历史销售量数据和历史价格数据应 用对数操作,以便于后续的价格敏感度计算。本申请的方法还可以基于与经处理的历史数据序列中的历史数据相关联的历史时间对历史数据的历史销售量数据进行加权,引入注意力机制。In step 220, a processed historical data series is generated by removing the portion of the historical data series that is affected by periodic factors. Step 220 is used to preprocess the historical data sequence. The preprocessing includes removing historical data associated with a historical time corresponding to at least one of a lunar holiday and a solar holiday in the historical data sequence for holiday factors. The preprocessing includes removing the components affected by seasonal factors in the value of historical sales data in the historical data series based on the STL method for seasonal factors. Logarithmic operations can also be applied to the historical sales volume data and historical price data of the historical data before inputting the processed historical data series into the regression model to facilitate subsequent price sensitivity calculations. The method of the present application may also introduce an attention mechanism by weighting the historical sales volume data of the historical data based on the historical time associated with the historical data in the processed historical data sequence.
接下来,在步骤230中基于与预定的销售趋势对应的多个趋势多项式和经处理的历史数据序列的两个输入,使用回归模型确定与产品的销售趋势对应的最优趋势多项式,以及进一步基于最优趋势多项式确定价格敏感度。具体地,将经处理的历史数据序列中的历史数据中的价格实体作为固定自变量,将与预定的销售趋势对应的多个趋势多项式作为可变自变量,将经处理的历史数据序列中的历史数据中的销售量实体作为因变量,通过回归运算保留具有显著性的历史数据并确定满足期望拟合目标的最优趋势多项式。在获得最优趋势多项式之后,包括历史价格数据的项的系数可以用于确定价格敏感度。在计算价格敏感度时,还可以引入显著性系数,对包括价格数据的项的系数进行加权,提高价格敏感度的可信度。Next, an optimal trend polynomial corresponding to the sales trend of the product is determined using a regression model in step 230 based on the plurality of trend polynomials corresponding to the predetermined sales trends and the two inputs of the processed historical data series, and further based on The optimal trend polynomial determines price sensitivity. Specifically, the price entity in the historical data in the processed historical data sequence is used as a fixed independent variable, a plurality of trend polynomials corresponding to predetermined sales trends are used as variable independent variables, and the The sales volume entity in the historical data is used as the dependent variable, and the significant historical data is retained through the regression operation and the optimal trend polynomial that satisfies the desired fitting target is determined. After obtaining the optimal trend polynomial, the coefficients of terms including historical price data can be used to determine price sensitivity. When calculating price sensitivity, a significance coefficient can also be introduced to weight the coefficients of items including price data to improve the credibility of price sensitivity.
在可选的步骤240中,对于得到的多个销售单元的价格敏感度,可以按照排序的结果应用价格策略,也可以基于其阈值进行分组并分别针对不同的组应用相应的价格策略。In optional step 240, for the obtained price sensitivities of a plurality of sales units, a price strategy may be applied according to the sorted results, or grouped based on the thresholds, and corresponding price strategies may be applied to different groups respectively.
图3则示出根据本申请的实施例的确定价格敏感度的装置。该装置300至少包括历史数据序列生成单元310,历史数据序列处理单元320,价格敏感度确定单元330和价格策略生成单元340。历史数据序列生成单元310用于基于产品的历史销售数据生成历史数据序列。该单元310还可以用于实现上文中步骤210所述的具体功能。历史数据序列处理单元320用于通过在历史数据序列中移除受到周期性因素影响的部分以生成经处理的历史数据序列。进一步,该单元320还实现图2中的步骤220完成的其它功能。价格敏感度确定单元330用于实现步骤230所完成的基于与预定的销售趋势对应的多个趋势多项式和经处理的历史数据序列的两个输入,使用回归模型确定与产品的销售趋势对应的最优趋势多项式,以及进一步基于最优趋势多项式确定价格敏感度。价格策略生成单元340则用于对于得到的多个销售单元的价格敏感度,按照排序的结果应用价格策略,和/或基于其阈 值进行分组并分别针对不同的组应用相应的价格策略。FIG. 3 shows an apparatus for determining price sensitivity according to an embodiment of the present application. The device 300 includes at least a historical data sequence generating unit 310 , a historical data sequence processing unit 320 , a price sensitivity determining unit 330 and a price strategy generating unit 340 . The historical data sequence generating unit 310 is configured to generate a historical data sequence based on the historical sales data of the product. The unit 310 may also be used to implement the specific functions described in step 210 above. The historical data sequence processing unit 320 is configured to generate a processed historical data sequence by removing the part affected by periodic factors in the historical data sequence. Further, this unit 320 also implements other functions completed by step 220 in FIG. 2 . The price sensitivity determination unit 330 is configured to realize the two inputs completed in step 230 based on a plurality of trend polynomials corresponding to the predetermined sales trend and the processed historical data series, and use a regression model to determine the most suitable product corresponding to the sales trend of the product. The optimal trend polynomial, and further determine the price sensitivity based on the optimal trend polynomial. The price strategy generation unit 340 is configured to apply the price strategy according to the sorted results according to the obtained price sensitivities of the multiple sales units, and/or group them based on their thresholds and apply corresponding price strategies for different groups respectively.
根据本申请的确定价格敏感度的方法和装置,基于机器学习中的回归算法模型而不是传统的考虑价格和销售额的经济学模型,在输入回归模型之前使用诸如STL的数据预处理方式将历史数据序列中受周期性因素影响的部分移除,在回归运算中加入与历史时间相关联的趋势多项式候选池,使用诸如逐步回归线性模型的搜索式自动收敛方法。为进一步考虑历史时间远近对价格敏感度的影响,引入注意力机制加强最近时间的历史数据的拟合权重,避免时间线过长导致的信息价值稀释。本申请的方案成功地将诸如节假日和季节性因素和门店个性化趋势因素等外部因素最大化地拟合。由于所使用的历史销售数据中的价格不采用官方定价而是实际成交价格的加权,将诸如折扣活动的因素考虑在内。趋势多项式候选池可以覆盖上升、下降、波动三类门店的个性化销售趋势,包括外界因素对门店销售情况的更多影响。该方法和装置所确定的价格实体与销售量实体间的价格敏感度尽可能地接近纯粹的价格敏感度,控制外部因素对历史销售量实体的影响,该价格敏感度使用传统的经济学模型几乎无法计算。对于多个门店,最终利用门店价格敏感度排序和分组在公司层面指导门店的价格策略。According to the method and apparatus for determining price sensitivity of the present application, based on the regression algorithm model in machine learning instead of the traditional economic model considering price and sales, data preprocessing methods such as STL are used to convert historical data before inputting the regression model. Parts of the data series affected by periodic factors are removed, and a pool of trend polynomial candidates associated with historical time is added to the regression operation, using search-based automatic convergence methods such as stepwise regression linear models. In order to further consider the impact of historical time on price sensitivity, an attention mechanism is introduced to strengthen the fitting weight of recent historical data to avoid the dilution of information value caused by a long time line. The solution of the present application successfully fits external factors such as holiday and seasonal factors and store personalization trend factors to the maximum extent. Since the prices in the historical sales data used are not official pricing but a weighting of actual transaction prices, factors such as discounting activity are taken into account. The trend polynomial candidate pool can cover the personalized sales trends of rising, falling and fluctuating stores, including more influences of external factors on store sales. The price sensitivity between the price entity and the sales volume entity determined by the method and device is as close as possible to pure price sensitivity, controlling the impact of external factors on the historical sales volume entity, and the price sensitivity uses traditional economic models almost Unable to calculate. For multiple stores, the store price sensitivity ranking and grouping are ultimately used to guide the store's price strategy at the company level.
应当注意,尽管在上文详细描述中提及了用于确定价格敏感度的装置的若干模块或者单元,但是这种划分并非强制性的。实际上,根据本申请的实施方式,上文描述的两个或更多模块或者单元的特征和功能可以在一个模块或者单元中具体化。反之,上文描述的一个模块或者单元的特征和功能可以进一步划分为由多个模块或者单元来具体化。作为模块或单元显示的部件可以是或者也可以不是物理单元,即可以位于一个地方,或者也可以分布到多个网络单元上。可以根据实际的需要选择其中的部分或者全部模块来实现本申请的方案的目的。本领域普通技术人员在不付出创造性劳动的情况下,即可以理解并实施。It should be noted that although several modules or units of the apparatus for determining price sensitivity are mentioned in the above detailed description, this division is not mandatory. Indeed, according to embodiments of the present application, the features and functions of two or more modules or units described above may be embodied in one module or unit. Conversely, the features and functions of one module or unit described above may be further divided into multiple modules or units to be embodied. Components shown as modules or units may or may not be physical units, ie may be located in one place, or may be distributed over multiple network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the solution of the present application. Those of ordinary skill in the art can understand and implement it without creative effort.
在本申请的示例性实施例中,还提供了一种计算机可读存储介质,其上存储有计算机程序,该程序包括可执行指令,该可执行指令被例如处理器执行时可以实现上述任意一个实施例中所述用于确定价格敏感度的方法 的步骤。在一些可能的实施方式中,本申请的各个方面还可以实现为一种程序产品的形式,其包括程序代码,当所述程序产品在终端设备上运行时,所述程序代码用于使所述终端设备执行本说明书用于确定价格敏感度的方法中描述的根据本申请各种示例性实施例的步骤。In an exemplary embodiment of the present application, there is also provided a computer-readable storage medium on which a computer program is stored, the program including executable instructions, which, when executed by, for example, a processor, can implement any one of the above The steps of the method for determining price sensitivity described in the Examples. In some possible implementations, various aspects of the present application can also be implemented in the form of a program product, which includes program code, which is used to cause the program product to run on a terminal device when the program product is executed. The terminal device performs the steps according to various exemplary embodiments of the present application described in the method for determining price sensitivity in this specification.
根据本申请的实施例的用于实现上述方法的程序产品可以采用便携式紧凑盘只读存储器(CD-ROM)并包括程序代码,并可以在终端设备,例如个人电脑上运行。然而,本申请的程序产品不限于此,在本文件中,可读存储介质可以是任何包含或存储程序的有形介质,该程序可以被指令执行系统、装置或者器件使用或者与其结合使用。The program product for implementing the above method according to the embodiments of the present application may adopt a portable compact disc read only memory (CD-ROM) and include program codes, and may be executed on a terminal device such as a personal computer. However, the program product of the present application is not limited thereto, and in this document, a readable storage medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.
所述程序产品可以采用一个或多个可读介质的任意组合。可读介质可以是可读信号介质或者可读存储介质。可读存储介质例如可以为但不限于电、磁、光、电磁、红外线、或半导体的系统、装置或器件,或者任意以上的组合。可读存储介质的更具体的例子(非穷举的列表)包括:具有一个或多个导线的电连接、便携式盘、硬盘、随机存取存储器(RAM)、只读存储器(ROM)、可擦式可编程只读存储器(EPROM或闪存)、光纤、便携式紧凑盘只读存储器(CD-ROM)、光存储器件、磁存储器件、或者上述的任意合适的组合。The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. The readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus or device, or a combination of any of the above. More specific examples (non-exhaustive list) of readable storage media include: electrical connections with one or more wires, portable disks, hard disks, random access memory (RAM), read only memory (ROM), erasable programmable read only memory (EPROM or flash memory), optical fiber, portable compact disk read only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.
所述计算机可读存储介质可以包括在基带中或者作为载波一部分传播的数据信号,其中承载了可读程序代码。这种传播的数据信号可以采用多种形式,包括但不限于电磁信号、光信号或上述的任意合适的组合。可读存储介质还可以是可读存储介质以外的任何可读介质,该可读介质可以发送、传播或者传输用于由指令执行系统、装置或者器件使用或者与其结合使用的程序。可读存储介质上包含的程序代码可以用任何适当的介质传输,包括但不限于无线、有线、光缆、RF等等,或者上述的任意合适的组合。The computer-readable storage medium may include a data signal propagated in baseband or as part of a carrier wave, carrying readable program code therein. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing. A readable storage medium can also be any readable medium other than a readable storage medium that can transmit, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. Program code embodied on a readable storage medium may be transmitted using any suitable medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
可以以一种或多种程序设计语言的任意组合来编写用于执行本申请操作的程序代码,所述程序设计语言包括面向对象的程序设计语言—诸如Java、C++等,还包括常规的过程式程序设计语言—诸如“C”语言或类似的程序设计语言。程序代码可以完全地在用户计算设备上执行、部分地在用 户设备上执行、作为一个独立的软件包执行、部分在用户计算设备上部分在远程计算设备上执行、或者完全在远程计算设备或服务器上执行。在涉及远程计算设备的情形中,远程计算设备可以通过任意种类的网络,包括局域网(LAN)或广域网(WAN),连接到用户计算设备,或者,可以连接到外部计算设备(例如利用因特网服务提供商来通过因特网连接)。Program code for carrying out the operations of the present application may be written in any combination of one or more programming languages, including object-oriented programming languages—such as Java, C++, etc., as well as conventional procedural Programming Language - such as the "C" language or similar programming language. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server execute on. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computing device (eg, using an Internet service provider business via an Internet connection).
在本申请的示例性实施例中,还提供一种电子设备,该电子设备可以包括处理器,以及用于存储所述处理器的可执行指令的存储器。其中,所述处理器配置为经由执行所述可执行指令来执行上述任意一个实施例中的用于确定价格敏感度的方法的步骤。In an exemplary embodiment of the present application, there is also provided an electronic device, which may include a processor, and a memory for storing executable instructions of the processor. Wherein, the processor is configured to perform the steps of the method for determining price sensitivity in any one of the above embodiments by executing the executable instructions.
所属技术领域的技术人员能够理解,本申请的各个方面可以实现为系统、方法或程序产品。因此,本申请的各个方面可以具体实现为以下形式,即:完全的硬件实施方式、完全的软件实施方式(包括固件、微代码等),或硬件和软件方面结合的实施方式,这里可以统称为“电路”、“模块”或“系统”。As will be appreciated by one skilled in the art, various aspects of the present application may be implemented as a system, method or program product. Therefore, various aspects of the present application can be embodied in the following forms, namely: a complete hardware implementation, a complete software implementation (including firmware, microcode, etc.), or a combination of hardware and software aspects, which may be collectively referred to herein as implementations "circuit", "module" or "system".
下面参照图4来描述根据本申请的这种实施方式的电子设备400。图4显示的电子设备400仅仅是一个示例,不应对本申请实施例的功能和使用范围带来任何限制。The electronic device 400 according to this embodiment of the present application is described below with reference to FIG. 4 . The electronic device 400 shown in FIG. 4 is only an example, and should not impose any limitations on the functions and scope of use of the embodiments of the present application.
如图4所示,电子设备400以通用计算设备的形式表现。电子设备400的组件可以包括但不限于:至少一个处理单元410、至少一个存储单元420、连接不同系统组件(包括存储单元420和处理单元410)的总线430、显示单元440等。As shown in FIG. 4, electronic device 400 takes the form of a general-purpose computing device. Components of the electronic device 400 may include, but are not limited to, at least one processing unit 410, at least one storage unit 420, a bus 430 connecting different system components (including the storage unit 420 and the processing unit 410), a display unit 440, and the like.
其中,所述存储单元存储有程序代码,所述程序代码可以被所述处理单元410执行,使得所述处理单元410执行本说明书用于确定价格敏感度的方法中描述的根据本申请各种示例性实施方式的步骤。例如,所述处理单元410可以执行如图1和图2中所示的步骤。Wherein, the storage unit stores program codes, and the program codes can be executed by the processing unit 410, so that the processing unit 410 executes various examples according to the present application described in the method for determining price sensitivity in this specification steps of sexual implementation. For example, the processing unit 410 may perform the steps shown in FIG. 1 and FIG. 2 .
所述存储单元420可以包括易失性存储单元形式的可读介质,例如随机存取存储单元(RAM)4201和/或高速缓存存储单元4202,还可以进一步包括只读存储单元(ROM)4203。The storage unit 420 may include a readable medium in the form of a volatile storage unit, such as a random access storage unit (RAM) 4201 and/or a cache storage unit 4202 , and may further include a read only storage unit (ROM) 4203 .
所述存储单元420还可以包括具有一组(至少一个)程序模块4205的程序/实用工具4204,这样的程序模块4205包括但不限于:操作系统、一个或者多个应用程序、其它程序模块以及程序数据,这些示例中的每一个或某种组合中可能包括网络环境的实现。The storage unit 420 may also include a program/utility 4204 having a set (at least one) of program modules 4205 including, but not limited to, an operating system, one or more application programs, other program modules, and programs Data, each or some combination of these examples may include an implementation of a network environment.
总线430可以为表示几类总线结构中的一种或多种,包括存储单元总线或者存储单元控制器、外围总线、图形加速端口、处理单元或者使用多种总线结构中的任意总线结构的局域总线。The bus 430 may be representative of one or more of several types of bus structures, including a memory cell bus or memory cell controller, a peripheral bus, a graphics acceleration port, a processing unit, or a local area using any of a variety of bus structures. bus.
电子设备400也可以与一个或多个外部设备500(例如键盘、指向设备、蓝牙设备等)通信,还可与一个或者多个使得用户能与该电子设备400交互的设备通信,和/或与使得该电子设备400能与一个或多个其它计算设备进行通信的任何设备(例如路由器、调制解调器等等)通信。这种通信可以通过输入/输出(I/O)接口450进行。并且,电子设备400还可以通过网络适配器460与一个或者多个网络(例如局域网(LAN),广域网(WAN)和/或公共网络,例如因特网)通信。网络适配器460可以通过总线430与电子设备400的其它模块通信。应当明白,尽管图中未示出,可以结合电子设备400使用其它硬件和/或软件模块,包括但不限于:微代码、设备驱动器、冗余处理单元、外部磁盘驱动阵列、RAID系统、磁带驱动器以及数据备份存储系统等。The electronic device 400 may also communicate with one or more external devices 500 (eg, keyboards, pointing devices, Bluetooth devices, etc.), with one or more devices that enable a user to interact with the electronic device 400, and/or with Any device (eg, router, modem, etc.) that enables the electronic device 400 to communicate with one or more other computing devices. Such communication may occur through input/output (I/O) interface 450 . Also, the electronic device 400 may communicate with one or more networks (eg, a local area network (LAN), a wide area network (WAN), and/or a public network such as the Internet) through a network adapter 460 . Network adapter 460 may communicate with other modules of electronic device 400 through bus 430 . It should be understood that, although not shown, other hardware and/or software modules may be used in conjunction with electronic device 400, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives and data backup storage systems.
通过以上的实施方式的描述,本领域的技术人员易于理解,这里描述的示例实施方式可以通过软件实现,也可以通过软件结合必要的硬件的方式来实现。因此,根据本申请实施方式的技术方案可以以软件产品的形式体现出来,该软件产品可以存储在一个非易失性存储介质(可以是CD-ROM,U盘,移动硬盘等)中或网络上,包括若干指令以使得一台计算设备(可以是个人计算机、服务器、或者网络设备等)执行根据本申请实施方式的用于确定价格敏感度的方法。From the description of the above embodiments, those skilled in the art can easily understand that the exemplary embodiments described herein may be implemented by software, or may be implemented by software combined with necessary hardware. Therefore, the technical solutions according to the embodiments of the present application may be embodied in the form of software products, and the software products may be stored in a non-volatile storage medium (which may be CD-ROM, U disk, mobile hard disk, etc.) or on the network , including several instructions to cause a computing device (which may be a personal computer, a server, or a network device, etc.) to execute the method for determining price sensitivity according to an embodiment of the present application.
本领域技术人员在考虑说明书及实践这里公开的内容后,将容易想到本申请的其它实施方案。本申请旨在涵盖本申请的任何变型、用途或者适应性变化,这些变型、用途或者适应性变化遵循本申请的一般性原理并包 括本申请未公开的本技术领域中的公知常识或惯用技术手段。说明书和实施例仅被视为示例性的,本申请的真正范围和精神由所附的权利要求指出。Other embodiments of the present application will readily occur to those skilled in the art upon consideration of the specification and practice of what is disclosed herein. This application is intended to cover any variations, uses or adaptations of this application that follow the general principles of this application and include common knowledge or conventional techniques in the technical field not disclosed in this application . The specification and examples are to be regarded as exemplary only, with the true scope and spirit of the application being indicated by the appended claims.

Claims (17)

  1. 一种用于确定价格敏感度的方法,其特征在于,包括:A method for determining price sensitivity, comprising:
    基于产品的历史销售数据生成历史数据序列,所述历史数据序列由与历史时间序列中的历史时间相关联的历史数据构成,其中,所述历史数据包括所述产品的历史销售量数据和历史价格数据;A historical data series is generated based on historical sales data of the product, the historical data series is composed of historical data associated with historical times in the historical time series, wherein the historical data includes historical sales volume data and historical price of the product data;
    通过在所述历史数据序列中移除受到周期性因素影响的部分以生成经处理的历史数据序列;generating a processed historical data series by removing the portion of the historical data series that is affected by periodic factors;
    基于与预定的销售趋势对应的多个趋势多项式和所述经处理的历史数据序列,使用回归模型确定与所述产品的销售趋势对应的最优趋势多项式,以及基于所述最优趋势多项式确定所述价格敏感度,其中所述产品的销售量数据被表示为以所述价格数据作为自变量的所述趋势多项式。Based on a plurality of trend polynomials corresponding to predetermined sales trends and the processed historical data series, a regression model is used to determine an optimal trend polynomial corresponding to the sales trend of the product, and the optimal trend polynomial is determined based on the optimal trend polynomial. and the price sensitivity, wherein the sales volume data of the product is represented as the trend polynomial with the price data as an independent variable.
  2. 根据权利要求1所述的方法,其特征在于,所述历史销售量数据基于所述产品的总销售量确定,所述历史价格数据基于所述产品的销售量和销售价格的加权确定。The method according to claim 1, wherein the historical sales volume data is determined based on the total sales volume of the product, and the historical price data is determined based on a weighted determination of the sales volume and the sales price of the product.
  3. 根据权利要求1所述的方法,其特征在于,所述周期性因素包括节假日因素和季节性因素。The method according to claim 1, wherein the periodic factors include holiday factors and seasonal factors.
  4. 根据权利要求3所述的方法,其特征在于,所述节假日因素包括阴历节假日和阳历节假日,通过在所述历史数据序列中移除与所述阴历节假日和所述阳历节假日中的至少一个对应的历史时间相关联的所述历史数据来生成所述经处理的历史数据序列。The method according to claim 3, wherein the holiday factor includes a lunar calendar holiday and a solar calendar holiday, and by removing the historical data sequence corresponding to at least one of the lunar calendar holiday and the solar calendar holiday the historical data associated with historical time to generate the processed series of historical data.
  5. 根据权利要求3或4所述的方法,其特征在于,通过基于损失的季节性趋势分解过程(STL)将所述历史数据中的所述历史销售量数据的值中受到季节性因素影响的成分移除来生成所述经处理的历史数据序列。The method according to claim 3 or 4, characterized in that, components affected by seasonal factors in the value of the historical sales volume data in the historical data are separated by a loss-based seasonal trend decomposition process (STL). removed to generate the processed series of historical data.
  6. 根据权利要求2所述的方法,其特征在于,在将所述经处理的历史数据序列输入到所述回归模型之前,对所述历史数据的所述历史销售量数据和所述历史价格数据应用对数操作。3. The method of claim 2, wherein applying to the historical sales volume data and the historical price data of the historical data prior to inputting the processed series of historical data into the regression model Logarithmic operations.
  7. 根据权利要求1所述的方法,其特征在于,在将所述经处理的历史数据序列输入到所述回归模型之前,基于与所述经处理的历史数据序列中的所述历史数据相关联的所述历史时间对所述历史数据的所述历史销售量数据进行加权。The method of claim 1, wherein prior to inputting the processed series of historical data into the regression model, based on a The historical time weights the historical sales volume data of the historical data.
  8. 根据权利要求1所述的方法,其特征在于,使用回归模型确定与所述产品的销售趋势对应的最优趋势多项式进一步包括:The method of claim 1, wherein using a regression model to determine the optimal trend polynomial corresponding to the sales trend of the product further comprises:
    将所述经处理的历史数据序列中的所述历史数据中的价格实体作为输入所述回归模型的固定自变量,将与预定的销售趋势对应的多个趋势多项式作为输入所述回归模型的可变自变量,将所述经处理的历史数据序列中的所述历史数据中的销售量实体作为输入所述回归模型的因变量,通过回归运算保留具有显著性的所述历史数据并确定满足期望拟合目标的所述最优趋势多项式。The price entity in the historical data in the processed historical data sequence is used as a fixed independent variable input to the regression model, and a plurality of trend polynomials corresponding to predetermined sales trends are used as the variable input to the regression model. Change the independent variable, take the sales volume entity in the historical data in the processed historical data sequence as the dependent variable of the input to the regression model, retain the significant historical data through regression operation and determine to meet expectations Fits the optimal trend polynomial of the target.
  9. 根据权利要求8所述的方法,其特征在于,所述回归模型为逐步回归线性模型。The method according to claim 8, wherein the regression model is a stepwise regression linear model.
  10. 根据权利要求1所述的方法,其特征在于,基于所述最优趋势多项式确定所述价格敏感度进一步包括基于通过所述最优趋势多项式中的包括所述价格数据的项的系数确定所述价格敏感度。2. The method of claim 1, wherein determining the price sensitivity based on the optimal trend polynomial further comprises determining the price sensitivity based on a coefficient through a term in the optimal trend polynomial that includes the price data price sensitivity.
  11. 根据权利要求10所述的方法,其特征在于,基于所述最优趋势多项式确定所述价格敏感度进一步包括基于与包括所述价格数据的项的系数相关联的显著性系数对包括所述价格数据的项的系数进行加权。11. The method of claim 10, wherein determining the price sensitivity based on the optimal trend polynomial further comprises including the price based on a pair of significance coefficients associated with coefficients of items including the price data The coefficients of the terms of the data are weighted.
  12. 根据权利要求1所述的方法,其特征在于,包括针对多个销售单元的历史销售数据确定相应的价格敏感度。The method of claim 1, comprising determining corresponding price sensitivities for historical sales data for a plurality of sales units.
  13. 根据权利要求12所述的方法,其特征在于,进一步包括基于所述多个销售单元的相应的价格敏感度对所述多个销售单元进行排序,以及基于排序结果应用价格策略。13. The method of claim 12, further comprising ranking the plurality of sales units based on respective price sensitivities of the plurality of sales units, and applying a price strategy based on the ranking results.
  14. 根据权利要求12所述的方法,其特征在于,进一步包括基于所述多个销售单元的相应的价格敏感度对所述多个销售单元进行分组,以及针对不同的分组应用对应的价格策略。13. The method of claim 12, further comprising grouping the plurality of sales units based on corresponding price sensitivities of the plurality of sales units, and applying corresponding price policies for different groupings.
  15. 一种用于确定价格敏感度的装置,其特征在于,包括:An apparatus for determining price sensitivity, comprising:
    历史数据序列生成单元,被配置为基于产品的历史销售数据生成历史数据序列,所述历史数据序列由与历史时间序列中的历史时间相关联的历史数据构成,其中,所述历史数据包括所述产品的历史销售量数据和历史价格数据;A historical data sequence generating unit configured to generate a historical data sequence based on historical sales data of the product, the historical data sequence being composed of historical data associated with historical times in the historical time series, wherein the historical data includes the Historical sales volume data and historical price data of the product;
    历史数据序列处理单元,被配置为通过在所述历史数据序列中移除受到周期性因素影响的部分以生成经处理的历史数据序列;a historical data sequence processing unit configured to generate a processed historical data sequence by removing a portion of the historical data sequence affected by periodic factors;
    价格敏感度确定单元,被配置为基于与预定的销售趋势对应的多个趋势多项式和所述经处理的历史数据序列,使用回归模型确定与所述产品的销售趋势对应的最优趋势多项式,以及基于所述最优趋势多项式确定所述价格敏感度,其中所述产品的销售量数据被表示为以所述价格数据作为自变量的所述趋势多项式。a price sensitivity determination unit configured to use a regression model to determine an optimal trend polynomial corresponding to a sales trend of the product based on a plurality of trend polynomials corresponding to predetermined sales trends and the processed historical data sequence, and The price sensitivity is determined based on the optimal trend polynomial, wherein the sales volume data for the product is represented as the trend polynomial with the price data as an independent variable.
  16. 一种计算机可读存储介质,其上存储有计算机程序,该计算机程序包括可执行指令,当该可执行指令被处理器执行时,实施根据权利要求1至14中任一项所述的方法。A computer-readable storage medium having stored thereon a computer program comprising executable instructions which, when executed by a processor, implement the method of any one of claims 1 to 14.
  17. 一种电子设备,其特征在于,包括:An electronic device, comprising:
    处理器;以及processor; and
    存储器,用于存储所述处理器的可执行指令;a memory for storing executable instructions for the processor;
    其中,所述处理器设置为执行所述可执行指令以实施根据权利要求1至14中任一项所述的方法。wherein the processor is arranged to execute the executable instructions to implement the method of any one of claims 1 to 14.
PCT/CN2021/119586 2020-09-23 2021-09-22 Method and apparatus for determining price sensitivity WO2022063118A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN202011008732.7 2020-09-23
CN202011008732.7A CN112132617A (en) 2020-09-23 2020-09-23 Method and apparatus for determining price sensitivity

Publications (1)

Publication Number Publication Date
WO2022063118A1 true WO2022063118A1 (en) 2022-03-31

Family

ID=73842863

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2021/119586 WO2022063118A1 (en) 2020-09-23 2021-09-22 Method and apparatus for determining price sensitivity

Country Status (2)

Country Link
CN (1) CN112132617A (en)
WO (1) WO2022063118A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115081698A (en) * 2022-06-09 2022-09-20 佛山众陶联供应链服务有限公司 Method, apparatus and computer storage medium for predicting firing curve based on degree of deformation

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112132617A (en) * 2020-09-23 2020-12-25 胜斗士(上海)科技技术发展有限公司 Method and apparatus for determining price sensitivity

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20160148225A1 (en) * 2014-11-24 2016-05-26 Institute For Information Industry Product sales forecasting system, method and non-transitory computer readable storage medium thereof
CN107515898A (en) * 2017-07-22 2017-12-26 复旦大学 Based on data diversity and the multifarious tire enterprise sales forecasting method of task
CN108694599A (en) * 2017-04-07 2018-10-23 北京京东尚科信息技术有限公司 Determine method, apparatus, electronic equipment and the storage medium of commodity price
CN112132617A (en) * 2020-09-23 2020-12-25 胜斗士(上海)科技技术发展有限公司 Method and apparatus for determining price sensitivity

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20160148225A1 (en) * 2014-11-24 2016-05-26 Institute For Information Industry Product sales forecasting system, method and non-transitory computer readable storage medium thereof
CN108694599A (en) * 2017-04-07 2018-10-23 北京京东尚科信息技术有限公司 Determine method, apparatus, electronic equipment and the storage medium of commodity price
CN107515898A (en) * 2017-07-22 2017-12-26 复旦大学 Based on data diversity and the multifarious tire enterprise sales forecasting method of task
CN112132617A (en) * 2020-09-23 2020-12-25 胜斗士(上海)科技技术发展有限公司 Method and apparatus for determining price sensitivity

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115081698A (en) * 2022-06-09 2022-09-20 佛山众陶联供应链服务有限公司 Method, apparatus and computer storage medium for predicting firing curve based on degree of deformation
CN115081698B (en) * 2022-06-09 2023-04-07 佛山众陶联供应链服务有限公司 Method, apparatus and computer storage medium for predicting firing curve based on degree of deformation

Also Published As

Publication number Publication date
CN112132617A (en) 2020-12-25

Similar Documents

Publication Publication Date Title
US11556964B2 (en) Methods, systems, and devices for counterfactual-based incrementality measurement in digital ad-bidding platform
US10846710B2 (en) Rating aggregation and propagation mechanism for hierarchical services and products
JP5677967B2 (en) Specification, estimation, causal driver discovery and market response elasticity or lift coefficient automation
US8494887B2 (en) Generating an optimized pricing plan
US20190073699A1 (en) Matching visitors as leads to lead buyers
US20030177103A1 (en) Calculating price elasticity
WO2022063118A1 (en) Method and apparatus for determining price sensitivity
US20200065852A1 (en) Reallocation of electronic resources using a predictive model of attribution
US20200234218A1 (en) Systems and methods for entity performance and risk scoring
CN102156932A (en) Prediction method and device for secondary purchase intention of customers
US20200387990A1 (en) Systems and methods for performing automated feedback on potential real estate transactions
CN111738805B (en) Behavior log-based search recommendation model generation method, device and storage medium
US20100324965A1 (en) Apparatus, method and article to evaluate affiliate performance
US20150332298A1 (en) Price matching in omni-channel retailing
US20200320561A1 (en) Method and apparatus using context to determine consumer deals
KR102097045B1 (en) Method and apparatus to recommend products reflecting characteristics of users
CN115147144A (en) Data processing method and electronic equipment
US11348146B2 (en) Item-specific value optimization tool
US20120166259A1 (en) Adjusting Demand Parameters To Reduce Allocation Errors in Display Advertising
US10360582B2 (en) Social commerce return on investment
US8805715B1 (en) Method for improving the performance of messages including internet splash pages
US11915295B2 (en) Systems and methods for automatically customizing electronic commerce
CN113362141A (en) Associated commodity recommendation method, device, medium and electronic equipment
WO2020150597A1 (en) Systems and methods for entity performance and risk scoring
Liang et al. Online ad procurement in non-stationary autobidding worlds

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 21871488

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 21871488

Country of ref document: EP

Kind code of ref document: A1