Online marketing coupon and promotion activity data tracking and optimizing system

Abstract

The invention discloses an online marketing coupon and promotion activity data tracking and optimizing system, and belongs to the technical field of marketing data processing, and the system comprises a data storage module which is used for storing data related to promotion activities; the data acquisition module is used for acquiring consumption record information of the system; the range setting module is used for analyzing data related to promotion activities to obtain a time interval and an activity effect threshold value; the promotion analysis module is used for analyzing the newly generated consumption records with cards and coupons according to the time interval and the activity effect threshold value to obtain an evaluation result of the promotion activity effect; and the optimization early warning module is used for carrying out early warning on the user according to the evaluation result so as to adjust the promotion strategy. According to the method, key indexes such as participation conditions, conversion effects and the like of cards, coupons and sales promotion activities are tracked by adopting an advanced data processing algorithm, the effects of different sales promotion strategies can be accurately evaluated, and real-time acquisition, efficient storage, intelligent analysis and dynamic optimization of online marketing data are realized.

Description

Technical Field

[0001] The present invention relates to the technical field of marketing data processing, and in particular to an online marketing card and promotion activity data tracking and optimization system. Background Art

[0002] With the continuous emergence of innovations in data processing algorithms, system architecture, and software implementation, new solutions have been provided for the tracking and optimization of online marketing data. However, traditional online marketing data tracking systems often have problems such as low data processing efficiency, insufficient accuracy, and poor real-time performance, making it difficult to meet the needs of enterprises for precision marketing and efficient operations.

[0003] Most of the online marketing data tracking systems in the prior art use traditional databases and data processing methods, which are incapable of processing large-scale, high-concurrency marketing data. They are often unable to capture and process data in real time, resulting in lags and inaccuracies in data analysis. In addition, these systems lack intelligent analysis modules and cannot automatically adjust marketing strategies according to data changes, limiting their effectiveness in practical applications. Summary of the invention

[0004] To solve the above problems, the present invention provides an online marketing card and promotion activity data tracking and optimization system. By adopting advanced data processing algorithms to track key indicators such as participation in cards and promotion activities, conversion effects, etc., it can accurately evaluate the effects of different promotion strategies and realize real-time collection, efficient storage, intelligent analysis and dynamic optimization of online marketing data.

[0005] The above objectives can be achieved through the following solutions: An online marketing card and promotion activity data tracking and optimization system includes a data storage module, a data acquisition module, a range setting module, a promotion analysis module and an optimization warning module; wherein the data storage module is used to establish and store data related to promotion activities; the data acquisition module is used to collect consumption record information of the system, divide the consumption record information into consumption records with card and consumption records without card, and store them in the data storage module; the range setting module is used to analyze the data related to promotion activities in the data storage module to obtain a time interval and an activity effect threshold; the promotion analysis module is used to analyze newly generated consumption records with card according to the time interval and the activity effect threshold to obtain an evaluation result of the promotion activity effect; the optimization warning module is used to warn users according to the evaluation result to adjust the promotion strategy.

[0006] Optionally, the promotion analysis module includes: a promotion monitoring unit, a consumption rate calculation unit, a historical proportion calculation unit and a threshold judgment unit; wherein the promotion monitoring unit is used to identify whether the corresponding commodity with a newly generated card and coupon consumption record is a newly listed commodity, and obtain an identification result; the consumption rate calculation unit is used to calculate the card and coupon consumption rate of the corresponding commodity according to the identification result and the consumption record information of the corresponding commodity; the historical proportion calculation unit is used to calculate the card and coupon consumption rate ratio of the corresponding commodity according to the card and coupon consumption rate of the corresponding commodity and the historical card and coupon consumption rate of the corresponding commodity; the threshold judgment unit is used to evaluate the effect of the promotion activity according to the size of the card and coupon consumption rate ratio of the corresponding commodity and a preset first threshold and a preset second threshold of the corresponding commodity, and obtain an evaluation result of the corresponding commodity.

[0007] Optionally, the identification of whether the corresponding commodity with the newly generated card and coupon consumption record is a newly-listed commodity, and obtaining the identification result includes: obtaining the historical consumption record information of the corresponding commodity with the newly-generated card and coupon consumption record from the data storage module; judging whether the card and coupon consumption record of the corresponding commodity is generated for the first time according to the historical consumption record information; if not, evaluating the effectiveness of the promotion activity of the corresponding commodity; if so, judging whether there is a consumption record of the corresponding commodity the day before according to the historical consumption record information; if there is no consumption record, the corresponding commodity is a newly-listed commodity, and the promotion activity effectiveness evaluation is not performed; if there is a consumption record, evaluating the effectiveness of the promotion activity of the corresponding commodity.

[0008] Optionally, the method for calculating the card-voucher consumption rate based on the recognition result and the consumption record information includes: if the promotion activity effect evaluation of the corresponding commodity is performed, the consumption record information of the corresponding commodity is obtained; counting the number of card-voucher consumption records of the corresponding commodity in the consumption record information within a corresponding preset time period; counting the number of consumption record information of the corresponding commodity in the consumption record information within a corresponding preset time period; using the number of card-voucher consumption records of the corresponding commodity and the number of consumption record information to calculate the card-voucher consumption rate of the corresponding commodity, and for the card-voucher consumption rate ,have , In the formula, The number of consumption records with coupons for the corresponding product within the corresponding preset time period. It is the quantity of consumption record information of the corresponding product within the corresponding preset time period.

[0009] Optionally, the calculating the ratio of the consumption rates with coupons of the corresponding commodities according to the consumption rates with coupons of the corresponding commodities and the historical consumption rates with coupons of the corresponding commodities comprises: acquiring the historical consumption rates with coupons of the corresponding commodities from the data storage module to obtain a consumption rate set; sorting the consumption rates with coupons in the consumption rate set from large to small, selecting the consumption rate with coupons that is ranked first, and obtaining a consumption rate base of the corresponding commodities; using the consumption rates with coupons of the corresponding commodities and combining the consumption rate base to calculate the ratio of the consumption rates with coupons of the corresponding commodities, and for the consumption rate ratio with coupons ,have , In the formula, is the consumption rate of the corresponding product with coupons, is the consumption rate base.

[0010] Optionally, the evaluating the effect of the promotion activity according to the size of the ratio of the consumption rate with card and coupon of the corresponding commodity and the preset first threshold and the preset second threshold of the corresponding commodity to obtain the evaluation result of the corresponding commodity includes: judging whether the ratio of the consumption rate with card and coupon of the corresponding commodity is greater than the first threshold; if the ratio of the consumption rate with card and coupon of the corresponding commodity is greater than the first threshold of the corresponding commodity, the promotion effect of the corresponding commodity is evaluated to be excellent; if the ratio of the consumption rate with card and coupon of the corresponding commodity is less than or equal to the first threshold of the corresponding commodity, judging whether the ratio of the consumption rate with card and coupon of the corresponding commodity is greater than the second threshold of the corresponding commodity; if the ratio of the consumption rate with card and coupon of the corresponding commodity is greater than the second threshold of the corresponding commodity, the promotion effect of the corresponding commodity is evaluated to be average; if the ratio of the consumption rate with card and coupon of the corresponding commodity is less than or equal to the second threshold of the corresponding commodity, the promotion effect of the corresponding commodity is evaluated to be poor.

[0011] Optionally, the optimization warning module is also used to determine whether the evaluation result is consistent with the actual effect; if it is consistent with the actual, the evaluation result of the corresponding commodity and the card-coupon consumption rate of the corresponding commodity are not saved; if it is inconsistent with the actual, the evaluation result of the corresponding commodity is updated according to the actual effect, and the absolute value of the difference between the current card-coupon consumption rate of the corresponding commodity and the average of the historical card-coupon consumption rate of the corresponding commodity is calculated to obtain the error value of the corresponding commodity; determine whether the error value of the corresponding commodity is greater than a preset third threshold; if the error value of the corresponding commodity is greater than the third threshold, the card-coupon consumption rate of the corresponding commodity and the updated evaluation result are not saved; if the error value is less than or equal to the third threshold, the card-coupon consumption rate of the corresponding commodity and the updated evaluation result are stored in the data storage module.

[0012] Optionally, the range setting module includes a time configuration unit and an effect threshold configuration unit; wherein the time configuration unit is used to analyze and calculate the card and coupon consumption records and the card and coupon consumption records of the corresponding commodities in different time periods to obtain the preset time periods of the corresponding commodities; the effect configuration unit is used to analyze and calculate the evaluation results of the corresponding commodities and the card and coupon consumption rates of the corresponding commodities to obtain the first threshold value of the corresponding commodities and the second threshold value of the corresponding commodities.

[0013] Optionally, the analyzing and calculating the card-coupon consumption records and non-card-coupon consumption records of corresponding commodities in different time periods to obtain the preset time period of the corresponding commodities includes: collecting historical factor data affecting the card-coupon consumption records of the corresponding commodities and the historical card-coupon consumption records of the corresponding commodities to construct a training set; taking the historical factor data affecting the card-coupon consumption records of the corresponding commodities as input and the card-coupon consumption records of the corresponding commodities as output, and using the training set to establish and train a regression model to obtain a card-coupon consumption record prediction model; using the card-coupon consumption record prediction model to predict the card-coupon consumption records of the corresponding commodities; dividing the card-coupon consumption records of the corresponding commodities according to different time periods, calculating the card-coupon consumption rate of the corresponding commodities in each time period, and arranging them from large to small; selecting the time period corresponding to the card-coupon consumption rate that ranks first to obtain the preset time period of the corresponding commodities.

[0014] Optionally, the analyzing and calculating the evaluation results of the corresponding commodities and the card-voucher consumption rates of the corresponding commodities to obtain the first threshold value of the corresponding commodities and the second threshold value of the corresponding commodities include: acquiring the evaluation results of the corresponding commodities and the card-voucher consumption rates of the corresponding commodities in the data storage module in real time to construct a real-time data set; using the real-time data set to calculate the average value of the card-voucher consumption rates of the corresponding commodities with excellent promotion effects to obtain a first mean value; using the real-time data set to calculate the average value of the card-voucher consumption rates of the corresponding commodities with general promotion effects to obtain a second mean value; using the real-time data set to calculate the average value of the card-voucher consumption rates of the corresponding commodities with poor promotion effects to obtain a third mean value; using the first mean value, the second mean value, the third mean value, the consumption rate base of the corresponding commodities and the newly saved card-voucher consumption rate of the corresponding commodities to calculate a new first threshold value of the corresponding commodities and a new second threshold value of the corresponding commodities, and for the new first threshold value of the corresponding commodities ,have , In the formula, is the first mean of the corresponding product, is the second mean of the corresponding product, is the current first threshold value of the corresponding product, is the rate of change coefficient of the first threshold, is the consumption rate of the corresponding product with coupons, is the consumption rate base; for the current second threshold value of the corresponding commodity ,have , In the formula, is the third mean of the corresponding product, is the second threshold value of the corresponding product. is the rate of change coefficient of the second threshold, and the quantity of consumption record information within the time period; wherein, when the corresponding commodity currently has no first threshold and second threshold, the preset initial value is used; when the newly saved card-voucher consumption rate corresponds to the updated evaluation result is excellent, only the new first threshold is calculated; when the newly saved card-voucher consumption rate corresponds to the updated evaluation result is average, the new first threshold and the new second threshold are calculated at the same time; when the newly saved card-voucher consumption rate corresponds to the updated evaluation result is poor, only the new second threshold is calculated.

[0015] Compared with the prior art, the present invention has the following advantages: 1. The system of the present invention uses advanced data processing algorithms to track key indicators such as participation in cards and promotional activities, conversion effects, etc., and can accurately evaluate the effects of different promotional strategies. It has achieved significant advantages such as real-time collection, efficient storage, intelligent analysis and dynamic optimization of online marketing data, elimination of interference to improve evaluation accuracy, and dynamic adjustment of thresholds for scientific evaluation effects; 2. The system of the present invention can conduct in-depth analysis of newly generated card and coupon consumption records according to time intervals and activity effect thresholds, so as to accurately evaluate the effect of promotional activities; by adopting advanced data processing algorithms and intelligent analysis technologies, the system improves the efficiency and accuracy of data processing and realizes intelligent analysis of online marketing data; in addition, the optimization early warning module can warn users according to the evaluation results to help enterprises adjust promotional strategies in a timely manner, thus realizing dynamic optimization; 3. The system of the present invention can identify whether the corresponding commodity with newly generated card and coupon consumption records is a newly listed commodity, and decide whether to conduct promotion activity effect evaluation based on this; this function effectively eliminates the interference that may be caused by the limited sales record information and unstable sales trend of newly listed commodities, and improves the accuracy and reliability of the evaluation results; 4. The system of the present invention also has the ability to dynamically adjust thresholds. It can analyze and calculate the first threshold and the second threshold of the corresponding commodity based on the evaluation results of the corresponding commodity and the card and coupon consumption rate of the corresponding commodity. These thresholds will be used to evaluate the effectiveness of promotional activities and will be continuously updated as new data is added. By dynamically adjusting the thresholds, the system can more accurately evaluate the effectiveness of promotional activities and help enterprises formulate and adjust marketing strategies, reduce operational risks, and enhance market competitiveness.

[0016] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures pointed out in the description, claims and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0018] Figure 1 It is a framework diagram of an online marketing card and promotion activity data tracking and optimization system according to an embodiment of the present invention.

[0019] Figure 2 It is a structural diagram of an online marketing card and promotion activity data tracking and optimization system according to an embodiment of the present invention.

[0020] Figure 3 It is an execution flow chart of an online marketing card and promotion activity data tracking and optimization system according to an embodiment of the present invention.

[0021] Figure 4 It is an execution flow chart of optimizing the first threshold and the second threshold in an embodiment of the present invention. DETAILED DESCRIPTION

[0022] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0023] Reference Figure 1 An embodiment of the present invention proposes an online marketing card and promotion activity data tracking and optimization system. By adopting advanced data processing algorithms to track key indicators such as card and promotion activity participation, conversion effect, etc., it can accurately evaluate the effects of different promotion strategies and realize real-time collection, efficient storage, intelligent analysis and dynamic optimization of online marketing data.

[0024] The system of this embodiment specifically includes: a data storage module, a data collection module, a range setting module, a promotion analysis module and an optimization warning module; wherein, The data storage module is used to create and store data related to the promotion activities; Specifically, the data storage module is responsible for establishing and storing all data related to the promotional activities; these data include but are not limited to basic information of the promotional activities (such as activity name, activity time, participating products, etc.), consumption record information (including consumption records with cards and coupons and consumption records without cards and coupons), consumption rate with cards and coupons, preset time period, first threshold, second threshold and analysis results, etc.; by building an efficient and scalable data storage structure, this module can ensure the integrity and security of the data, providing a solid foundation for subsequent data analysis and optimization.

[0025] The data collection module is used to collect consumption record information of the system, divide the consumption record information into consumption records with cards and consumption records without cards, and store them in the data storage module; Specifically, the data collection module is responsible for real-time collection of consumption record information of the system, and divides this information into two categories: consumption records with cards and coupons and consumption records without cards and coupons; the collected data includes but is not limited to key information such as the user's purchase time, purchased goods, payment amount, whether coupons are used, etc.; through an efficient data collection mechanism, the module can ensure the real-time and accuracy of the data, and provide a reliable data source for subsequent data analysis.

[0026] The range setting module is used to analyze the data related to the promotion activities in the data storage module to obtain the time interval and the activity effect threshold; Specifically, the scope setting module is responsible for analyzing the promotion activity related data in the data storage module to determine the time interval for data analysis and the activity effect threshold; the time interval is usually set according to the actual time period of the promotion activity, while the activity effect threshold may be set based on historical data, industry standards or corporate goals; through reasonable scope setting, this module can ensure the pertinence and effectiveness of data analysis.

[0027] The promotion analysis module is used to analyze the newly generated card and coupon consumption records according to the time interval and the activity effect threshold to obtain an evaluation result of the promotion activity effect; Specifically, the promotion analysis module conducts in-depth analysis of newly generated card and coupon consumption records based on the time interval and activity effect threshold determined by the scope setting module to evaluate the effectiveness of the promotion activities; the analysis may include indicators such as coupon usage rate and conversion rate. By comparing and analyzing these indicators with the preset thresholds, the evaluation results of the promotion activities effect can be obtained.

[0028] The optimization warning module is used to warn users based on the evaluation results to adjust the promotion strategy.

[0029] Specifically, the optimization warning module issues warning prompts to users based on the evaluation results of the promotion analysis module to help companies adjust their promotion strategies in a timely manner; if the evaluation results show that the promotion of a certain product is not effective, the optimization warning module will issue a warning signal to prompt the company that it may need to adjust the promotion strategy of the product, such as increasing the number of coupons issued, extending the activity time, or changing the promotion method; at the same time, by confirming the evaluation results, the range setting module is optimized for the preset time period, the first threshold, and the second threshold, thereby improving the accuracy of the system.

[0030] Specifically, the system realizes comprehensive tracking and in-depth analysis of online marketing data by integrating multiple functional modules such as data storage module, data collection module, range setting module, promotion analysis module and optimization warning module; at the same time, the system also adopts advanced data processing algorithms and intelligent analysis technology to improve the efficiency and accuracy of data processing; through the application of this system, enterprises can understand the effectiveness of marketing activities in real time, adjust promotion strategies in time, reduce operational risks and enhance market competitiveness.

[0031] Alternatively, if Figure 2 As shown, the promotion analysis module includes: a promotion monitoring unit, a consumption rate calculation unit, a historical ratio calculation unit and a threshold judgment unit; wherein, The promotion monitoring unit is used to identify whether the corresponding commodity with the newly generated card and coupon consumption record is a newly-listed commodity, and obtain an identification result; Specifically, the main task of the promotion monitoring unit is to identify whether the corresponding products with newly generated card and coupon consumption records are newly listed products; since the amount of consumption record information of newly listed products is small, it is difficult to accurately evaluate the effectiveness of promotional activities, and its related data will affect the accuracy of the system database, so it needs to be excluded.

[0032] The consumption rate calculation unit is used to calculate the card and coupon consumption rate of the corresponding commodity according to the recognition result and the consumption record information of the corresponding commodity; Specifically, the consumption rate calculation unit is responsible for calculating the card-coupon consumption rate of the corresponding commodity based on the recognition result of the promotion monitoring unit and the consumption record information of the corresponding commodity; the card-coupon consumption rate refers to the proportion of consumers purchasing a certain commodity when using a card coupon.

[0033] The historical ratio calculation unit is used to calculate the card-coupon consumption rate ratio of the corresponding commodity according to the card-coupon consumption rate of the corresponding commodity and the historical card-coupon consumption rate of the corresponding commodity; Specifically, the task of the historical ratio calculation unit is to calculate the ratio of the corresponding commodity's consumption rate with coupons based on the corresponding commodity's consumption rate with coupons and the historical consumption rate with coupons; this ratio reflects the effectiveness of the current commodity promotion relative to the historical level.

[0034] The threshold judgment unit is used to evaluate the effect of the promotion activity according to the ratio of the card and coupon consumption rate of the corresponding commodity and the preset first threshold and the preset second threshold of the corresponding commodity, and obtain the evaluation result of the corresponding commodity.

[0035] Specifically, the threshold judgment unit is the last link of the promotion analysis module. It is responsible for evaluating the effect of the promotion activity by comparing the card-voucher consumption rate ratio of the corresponding product with the preset first threshold and second threshold, and generating the evaluation result of the corresponding product.

[0036] Optionally, the identifying whether the corresponding commodity with the newly generated card coupon consumption record is a newly-listed commodity, and obtaining the identification result includes: Acquire historical consumption record information of the corresponding commodity with newly generated card and coupon consumption records from the data storage module; Determine whether the card-voucher consumption record of the corresponding commodity is generated for the first time based on the historical consumption record information; if not, evaluate the effect of the promotion activity of the corresponding commodity; If so, determine whether there is a consumption record of the corresponding product the day before based on the historical consumption record information; If there is no consumption record, the corresponding product is a new product and no promotion effect evaluation will be conducted; If there is a consumption record, an evaluation of the effectiveness of the promotional activities for the corresponding product will be conducted.

[0037] For example, Figure 3As shown, the system detects a new consumption record with a card or coupon, corresponding to product A; the promotion monitoring unit obtains the historical consumption record information of product A from the data storage module and finds that this is the first time that product A has a consumption record with a card or coupon; further inspection finds that there was no consumption record for product A the day before; based on the recognition logic, the promotion monitoring unit determines that product A is a newly listed product, and therefore does not evaluate the effectiveness of the promotion activity; as a newly listed product, product A has very limited sales record information and its sales trend is unstable; based on the exclusion logic, the promotion analysis module excludes product A when evaluating the effectiveness of the promotion activity to avoid its inaccurate data from interfering with the evaluation results; the system also detects a new consumption record with a card or coupon, corresponding to product B; the promotion monitoring unit determines that product A is a newly listed product, and therefore does not evaluate the effectiveness of the promotion activity; After the monitoring unit obtains the historical consumption record information of product B, it finds that this is not the first time that product B has generated a card and coupon consumption record; further inspection finds that product B has multiple consumption records on the previous day; therefore, the promotion monitoring unit believes that product B is not a new product and will conduct an evaluation of the effectiveness of the promotion activities for the corresponding product; as an old product, product B has sufficient sales data and a stable sales trend; therefore, the promotion analysis module will include it in the evaluation scope, and conduct an in-depth analysis of product B's sales data and card and coupon usage to accurately evaluate the effectiveness of the promotion activities; by excluding newly listed products from the promotion effectiveness evaluation, the promotion analysis module can ensure the accuracy and reliability of the evaluation results, and provide strong support for subsequent market strategies and decision-making.

[0038] Optionally, the method for calculating the card-voucher consumption rate according to the recognition result and the consumption record information includes: If the promotion effect of the corresponding product is evaluated, the consumption record information of the corresponding product is obtained; Counting the number of card and coupon consumption records for the corresponding commodity in the consumption record information within the corresponding preset time period; Counting the number of consumption record information of the corresponding commodity in the consumption record information within the corresponding preset time period; The card coupon consumption rate of the corresponding commodity is calculated by using the card coupon consumption record quantity value and the consumption record information quantity value. ,have , In the formula, The number of consumption records with coupons for the corresponding product within the corresponding preset time period. It is the quantity of consumption record information of the corresponding product within the corresponding preset time period.

[0039] Specifically, the preset time period used for statistics is the most recent preset time period. For example, after statistical analysis, it is found that the consumption data on Saturday of each month is the most representative, so Saturday is set as the preset time period; if the currently collected card and coupon consumption records are for Friday, then the number of card and coupon consumption records counted at this time is the value of last Saturday, and the corresponding number of consumption record information counted at this time should also be the value of last Saturday; if the currently collected card and coupon consumption records are for Saturday, then the number of card and coupon consumption records counted at this time is the value of last Saturday, because today (Saturday) has not passed, and the recorded data is incomplete; similarly, if the currently collected card and coupon consumption records are for Sunday, then the number of card and coupon consumption records counted at this time is this Saturday.

[0040] For example, assume that the preset time period is Saturday; all consumption records of commodity E on the most recent Saturday are obtained from the data storage module, totaling 1000 records; among these consumption records, it is found that 200 records show that consumers used coupons to purchase, so =200; the total number of consumption records is 1000, that is =1000; the card coupon consumption rate of commodity E is calculated as =0.2; this means that on the most recent Saturday, 20% of consumers used coupons when purchasing product E, thereby enjoying the discounts brought by the promotion; through this data processing, the promotion analysis module can accurately quantify the effect of promotional activities on increasing the consumption rate of coupons, and provide strong support for subsequent market strategies and decision-making.

[0041] Optionally, calculating the ratio of the consumption rate with a card or coupon of the corresponding commodity according to the consumption rate with a card or coupon of the corresponding commodity and the historical consumption rate with a card or coupon of the corresponding commodity comprises: Obtaining the historical card and coupon consumption rates of the corresponding commodities from the data storage module to obtain a consumption rate set; Sorting the card-voucher consumption rates in the consumption rate set from large to small, selecting the card-voucher consumption rate with the first ranking, and obtaining the consumption rate base of the corresponding commodity; The consumption rate of the corresponding commodity with a card voucher is used in combination with the consumption rate base to calculate the consumption rate ratio of the corresponding commodity with a card voucher. ,have , In the formula, is the consumption rate of the corresponding product with coupons, is the consumption rate base.

[0042] For example, the card and coupon consumption rate data of commodity F from 12:00 to 21:00 every day in the past 12 days are obtained from the data storage module, forming a consumption rate set containing 12 values; after sorting these values, it is found that the highest card and coupon consumption rate is 30%; therefore, 30% is selected as the consumption rate base ( =0.3); Assume that according to the previous calculation, the card and coupon consumption rate of product F during the most recent 12:00-21:00 was 25% ( =0.25), the calculated consumption rate ratio of commodity F with coupons is =0.83; this means that the effect of the current promotion is about 83% of the best performance in history, slightly lower than the best level in history. Through this data processing, the promotion analysis module can quantitatively evaluate the effect of the current promotion relative to the best performance in history, and provide data support for further optimization of promotion strategies.

[0043] Optionally, evaluating the effect of the promotion activity according to the ratio of the consumption rate of the corresponding commodity with a card or coupon and the preset first threshold and the preset second threshold of the corresponding commodity to obtain the evaluation result of the corresponding commodity includes: Determine whether the card-voucher consumption rate ratio of the corresponding product is greater than the first threshold; If the card-voucher consumption rate ratio of the corresponding product is greater than the first threshold of the corresponding product, the promotion effect of the corresponding product is evaluated as excellent; If the card-voucher consumption rate ratio of the corresponding product is less than or equal to the first threshold of the corresponding product, then determine whether the card-voucher consumption rate ratio of the corresponding product is greater than the second threshold of the corresponding product; If the card-voucher consumption rate ratio of the corresponding product is greater than the second threshold value of the corresponding product, the promotion effect of the corresponding product is evaluated as average; If the card-voucher consumption rate ratio of the corresponding product is less than or equal to the second threshold value of the corresponding product, the promotion effect of the corresponding product is evaluated as poor.

[0044] For example, suppose an e-commerce company is evaluating the effect of a promotion activity on a certain product A on its platform, and sets two preset thresholds for product A: the first threshold is 0.8, and the second threshold is 0.5; these two thresholds represent the expected standards for the effect of the promotion activity; first, the card and coupon consumption rate ratio of product A is calculated according to the previous steps, and it is assumed that this ratio is 0.75; next, this ratio is compared with the first threshold of 0.8; because 0.75 is less than 0.8, I judge that the promotion effect of product A does not reach the "excellent" standard; the promotion effect of product A does not reach the "excellent" standard, and then compare its ratio with the second threshold of 0.5; because 0.75 is greater than 0.5, it is judged The promotion effect of product A at least reaches the "average" standard; Based on the above analysis, the promotion effect of product A is evaluated as "average"; this means that although the promotion of product A did not reach the set highest standard, it did not perform too badly and still had a certain effect; setting different thresholds can help evaluate the effectiveness of promotional activities more carefully and provide targeted suggestions for subsequent optimization; if the promotion effect of product A is evaluated as "average", it may be necessary to consider adjusting the promotion strategy, such as increasing the discount, improving the publicity method, etc., to enhance the promotion effect; and if the evaluation result is "poor", it may be necessary to analyze the reasons more deeply and take more active measures to improve the promotion effect.

[0045] Optionally, the optimization warning module is also used to determine whether the evaluation result is consistent with the actual effect; Specifically, the function of the optimization early warning module is to ensure the accuracy and practicality of the evaluation results; it will first compare the evaluation results with the actual effects of the actual promotion activities, and then decide whether to update the evaluation results based on the comparison results, and further determine whether to save these data.

[0046] Among them, Figure 4 If the result is consistent with the actual situation, the evaluation result of the corresponding product and the card and coupon consumption rate of the corresponding product will not be saved; Specifically, this step is to verify the accuracy of the evaluation model. If the evaluation results are consistent with the actual observed promotion effects, then the evaluation model is reliable and no additional adjustments are needed.

[0047] If it is inconsistent with the actual situation, the evaluation result of the corresponding product is updated according to the actual effect, and the absolute value of the difference between the current card-coupon consumption rate of the corresponding product and the average card-coupon consumption rate of the corresponding product in history is calculated to obtain the error value of the corresponding product; Specifically, if there is a deviation between the evaluation result and the actual effect, the optimization warning module will update the evaluation result according to the actual effect; at the same time, it will calculate the difference between the current card-voucher consumption rate and the historical card-voucher consumption rate average (take the absolute value) to obtain the error value; this error value reflects the degree of difference between the evaluation result and the actual effect.

[0048] Determine whether the error value of the corresponding product is greater than a preset third threshold; Specifically, the preset third threshold is a standard for judging whether the error is acceptable; if the error value is greater than this threshold, it means that the deviation of the evaluation result is large, which may be because the evaluation model is defective or affected by other unknown factors, so the inaccurate data should not be saved.

[0049] If the error value of the corresponding commodity is greater than the third threshold, the consumption rate of the corresponding commodity with a card or coupon and the updated evaluation result are not saved; If the error value is less than or equal to the third threshold, the card and coupon consumption rate of the corresponding commodity and the updated evaluation result are stored in the data storage module.

[0050] Specifically, if the error value is less than or equal to the third threshold, it means that although the evaluation result deviates from the actual effect, the deviation is within an acceptable range. At this time, the optimization warning module will save the updated evaluation result and the card and coupon consumption rate to the data storage module for subsequent analysis and reference.

[0051] Optionally, the range setting module includes a time configuration unit and an effect threshold configuration unit; wherein, The time configuration unit is used to analyze and calculate the card and coupon consumption records and the card and coupon consumption records of the corresponding commodities in different time periods to obtain the preset time periods of the corresponding commodities; Specifically, the main task of the time configuration unit is to analyze and calculate the consumption records with and without card coupons for corresponding commodities in different time periods, so as to obtain the preset time period for each commodity. This time period usually represents the period when commodity sales are most active and promotional activities are most effective. This preset time period will serve as the time benchmark for subsequent data analysis, which will help capture the sales trends and promotional activities effects of commodities in different time periods.

[0052] The effect configuration unit is used to analyze and calculate the evaluation result of the corresponding commodity and the card and coupon consumption rate of the corresponding commodity to obtain the first threshold value of the corresponding commodity and the second threshold value of the corresponding commodity.

[0053] Specifically, the main task of the effect threshold configuration unit is to analyze and calculate the evaluation results of the corresponding products and the consumption rate of cards and coupons, so as to obtain the first threshold and the second threshold of each product; these two thresholds will be used to evaluate the effectiveness of promotional activities and help enterprises formulate and adjust marketing strategies.

[0054] Optionally, analyzing and calculating the card-coupon consumption records and the card-coupon consumption records of the corresponding commodities in different time periods to obtain the preset time periods of the corresponding commodities includes: Collect historical data on factors that affect the consumption records of corresponding products with coupons and historical consumption records of corresponding products with coupons to build a training set; Specifically, collect historical data on factors that affect the consumption records of corresponding products with coupons. These historical factors may include but are not limited to promotion time, product discount strength, market competition, holiday impact, etc. At the same time, collect historical consumption records of corresponding products with coupons, including consumption time, consumption amount, type of coupons used, etc.

[0055] Taking the historical factor data that affects the card-voucher consumption record of the corresponding commodity as input and the card-voucher consumption record of the corresponding commodity as output, using the training set to establish and train a regression model to obtain a card-voucher consumption record prediction model; Predicting card-coupon consumption records of corresponding commodities using the card-coupon consumption record prediction model; Specifically, a regression model is built and trained using the constructed training set. The goal of this model is to predict the card and coupon consumption records of the corresponding product based on the input historical factor data; the choice of regression model can be based on the actual situation, such as linear regression, decision tree regression, random forest regression, etc.; during the model training process, the model parameters will be continuously adjusted to minimize the prediction error.

[0056] Divide the card and coupon consumption records of the corresponding products into different time periods, calculate the card and coupon consumption rates of the corresponding products in each time period, and arrange them from largest to smallest; Specifically, the predicted card-voucher consumption records are divided into different time periods, such as by hour, day or week; the card-voucher consumption records in each time period are calculated to obtain the corresponding card-voucher consumption rate. The card-voucher consumption rate is usually defined as the ratio of the number of consumption records using card vouchers to the total number of consumption records in a certain time period.

[0057] The time period corresponding to the card and coupon consumption rate that ranks first is selected to obtain the preset time period for the corresponding product.

[0058] Specifically, the card-voucher consumption rates in various time periods are arranged from large to small, and the time period corresponding to the card-voucher consumption rate that ranks first is selected as the preset time period for the product; this time period usually represents the period when the product is most active and has the most significant effect in card-voucher promotion activities; this makes the effects of card-voucher promotion activities for the product in multiple same time periods comparable.

[0059] For example, suppose that the card-voucher consumption records of a product called "smart bracelet" are analyzed to determine its preset time period; historical factor data that affects the card-voucher consumption records of the smart bracelet in the past year are collected, such as the time of each promotion, the discount intensity, and the activities of competitors in the same period; at the same time, the card-voucher consumption records of the smart bracelet in the past year are collected, including the time, amount, and type of card voucher used for each consumption; the historical factor data and the card-voucher consumption records are integrated to form a training set containing multiple samples; each sample contains the historical factors of a promotion and the corresponding card-voucher consumption records; a linear regression model is selected for training ; By continuously adjusting the model parameters and minimizing the prediction error, a regression model that can accurately predict the card and coupon consumption records of the smart bracelet is obtained; using the trained regression model, the card and coupon consumption records of the smart bracelet in the next month are predicted; the predicted card and coupon consumption records are divided by day, and the card and coupon consumption rate of each day is calculated; the card and coupon consumption rates of each day are arranged from large to small, and it is found that the card and coupon consumption rate on a certain weekend is the highest; therefore, this weekend is selected as the preset time period for the smart bracelet; this means that in the subsequent data analysis, the focus will be on the sales of smart bracelets on this weekend of each month in order to better evaluate the effectiveness of promotional activities.

[0060] Optionally, analyzing and calculating the evaluation result of the corresponding commodity and the card-voucher consumption rate of the corresponding commodity to obtain the first threshold value of the corresponding commodity and the second threshold value of the corresponding commodity includes: Acquire the evaluation results of the corresponding commodities and the consumption rates of the corresponding commodities with coupons in the data storage module in real time, and construct a real-time data set; Using the real-time data set, calculate the average of the card and coupon consumption rates of the corresponding products with excellent promotion effects to obtain a first average value; Using the real-time data set, the average value of the card and coupon consumption rate of the corresponding commodity promotion effect is calculated to obtain a second mean value; Calculate the average of the card and coupon consumption rates with poor promotion effects of the corresponding products using the real-time data set to obtain a third mean; The first mean, the second mean, the third mean, the consumption rate base of the corresponding commodity and the newly saved card and coupon consumption rate of the corresponding commodity are used to calculate the new first threshold value and the new second threshold value of the corresponding commodity. ,have , In the formula, is the first mean of the corresponding product, is the second mean of the corresponding product, is the current first threshold value of the corresponding product, is the rate of change coefficient of the first threshold, is the consumption rate of the corresponding product with coupons, is the consumption rate base; For the current second threshold of the corresponding product ,have , In the formula, is the third mean of the corresponding product, is the second threshold value of the corresponding product. is the change rate coefficient of the second threshold, the quantity of consumption record information within the time period; Among them, when there is currently no first threshold and second threshold for the corresponding product, the preset initial value is used; when the newly saved card-voucher consumption rate corresponds to an updated evaluation result of excellent, only the new first threshold is calculated; when the newly saved card-voucher consumption rate corresponds to an updated evaluation result of average, the new first threshold and the new second threshold are calculated at the same time; when the newly saved card-voucher consumption rate corresponds to an updated evaluation result of poor, only the new second threshold is calculated.

[0061] Specifically, the calculation of the threshold is a dynamic process. By confirming the promotion effect and the actual effect, the database is updated. It allows the system to be continuously updated as new data is added. This dynamic adjustment mechanism ensures the accuracy and timeliness of the threshold, making the evaluation of the promotion effect more scientific and reasonable.

[0062] For example, Figure 4 As shown in the figure, it is assumed that the first threshold and the second threshold are being calculated for a product called "Health Smart Watch"; it is assumed that the preset time is Saturday of each week, and the evaluation results and card and coupon consumption rate data of the Health Smart Watch on Saturdays of the past 20 weeks are obtained from the data storage module; after statistics, the current first threshold of the Health Smart Watch is 0.6, the current second threshold is 0.4; assuming the consumption rate base of health smart watches is 0.5, and the consumption rate with coupons is calculated up to the most recent Saturday. is 0.29, then the consumption rate ratio of this product with card coupons is , since 0.58 is less than the current first threshold of 0.6, the promotion effect is determined to be average; after comparison, it is found that the promotion effect should be excellent at this time (assuming that the error value at this time is less than the third threshold), so the card coupon consumption rate of 0.29 is marked as the promotion effect should be excellent and saved. Then, the average card coupon consumption rate of the health smart watch under the condition of excellent promotion effect needs to be calculated with the newly saved 0.29. Assuming that the new first mean is 0.34 after calculation ( ); At this time, the average consumption rate of smart health watches with coupons is 0.25 ( ), the average consumption rate of coupons with poor promotion effect is 0.15 ( ), and the first threshold change rate coefficient =1, the change rate coefficient of the second threshold =1; Since the evaluation result corresponding to the newly saved card and coupon consumption rate of 0.29 is excellent promotion effect, only the first threshold needs to be adjusted, so the new first threshold is calculated. ; At this time, the card-coupon consumption rate ratio of this product is 0.58, which is greater than 0.55, so the new first threshold is available; At this time, the new first threshold is 0.55, and the second threshold remains unchanged (0.4); In this way, the system can dynamically adjust the threshold according to actual data, so as to more accurately evaluate the effectiveness of promotional activities.

[0063] It should be noted that the electrical connection between the above-mentioned units does not necessarily mean direct connection of the lines, and the indirect connection mode can be applied to the embodiments of the present invention as long as the purpose of the present invention is achieved. The above is only an exemplary embodiment of the present invention and cannot be used to limit the scope of the present invention.

[0064] That is, any equivalent changes and modifications made according to the teachings of the present invention are still within the scope of the present invention. After considering the disclosure of the specification and the truth of practice, those skilled in the art will easily think of other embodiments of the present invention. This application is intended to cover any variation, use or adaptive change of the present invention, which follows the general principles of the present invention and includes common knowledge or customary technical means in the art that are not described in the present invention.

Claims

1. An online marketing card and promotion activity data tracking and optimization system, characterized in that: The system includes: a data storage module, a data collection module, a range setting module, a promotion analysis module and an optimization early warning module; wherein, The data storage module is used to create and store data related to the promotion activities; The data collection module is used to collect consumption record information of the system, divide the consumption record information into consumption records with cards and consumption records without cards, and store them in the data storage module; The range setting module is used to analyze the data related to the promotion activities in the data storage module to obtain the time interval and the activity effect threshold; The promotion analysis module is used to analyze the newly generated card and coupon consumption records according to the time interval and the activity effect threshold to obtain an evaluation result of the promotion activity effect; The optimization warning module is used to warn users based on the evaluation results to adjust the promotion strategy.

2. The online marketing card and promotion activity data tracking and optimization system according to claim 1, characterized in that: The promotion analysis module includes: a promotion monitoring unit, a consumption rate calculation unit, a historical ratio calculation unit and a threshold judgment unit; wherein, The promotion monitoring unit is used to identify whether the corresponding commodity with the newly generated card and coupon consumption record is a newly-listed commodity, and obtain an identification result; The consumption rate calculation unit is used to calculate the card and coupon consumption rate of the corresponding commodity according to the recognition result and the consumption record information of the corresponding commodity; The historical ratio calculation unit is used to calculate the card-coupon consumption rate ratio of the corresponding commodity according to the card-coupon consumption rate of the corresponding commodity and the historical card-coupon consumption rate of the corresponding commodity; The threshold judgment unit is used to evaluate the effect of the promotion activity according to the ratio of the card and coupon consumption rate of the corresponding commodity and the preset first threshold and the preset second threshold of the corresponding commodity, and obtain the evaluation result of the corresponding commodity.

3. The online marketing card and promotion activity data tracking and optimization system according to claim 2, characterized in that: The identification of whether the corresponding commodity with the newly generated card coupon consumption record is a newly listed commodity, and obtaining the identification result includes: Acquire historical consumption record information of corresponding commodities with newly generated card and voucher consumption records from the data storage module; Determine whether the card-voucher consumption record of the corresponding product is generated for the first time based on the historical consumption record information; if not, evaluate the effect of the promotion activity of the corresponding product; If so, determine whether there is a consumption record of the corresponding product the day before based on the historical consumption record information; If there is no consumption record, the corresponding product is a new product and no promotion effect evaluation will be conducted; If there is a consumption record, an evaluation of the effectiveness of the promotional activities for the corresponding product will be conducted.

4. The online marketing card and promotion activity data tracking and optimization system according to claim 2, characterized in that: The method for calculating the card and coupon consumption rate according to the recognition result and the consumption record information includes: If the promotion effect of the corresponding product is evaluated, the consumption record information of the corresponding product is obtained; Counting the number of card and coupon consumption records for the corresponding commodity in the consumption record information within the corresponding preset time period; Counting the number of consumption record information of the corresponding commodity in the consumption record information within the corresponding preset time period; The card coupon consumption rate of the corresponding commodity is calculated by using the card coupon consumption record quantity value and the consumption record information quantity value. ,have ， In the formula, The number of consumption records with coupons for the corresponding product within the corresponding preset time period. It is the quantity of consumption record information of the corresponding product within the corresponding preset time period.

5. The online marketing card and promotion activity data tracking and optimization system according to claim 2, characterized in that: Calculating the ratio of the consumption rate with coupons for the corresponding product according to the consumption rate with coupons for the corresponding product and the historical consumption rate with coupons for the corresponding product includes: Obtaining the historical card and coupon consumption rates of the corresponding commodities from the data storage module to obtain a consumption rate set; Sorting the card-voucher consumption rates in the consumption rate set from large to small, selecting the card-voucher consumption rate with the first ranking, and obtaining the consumption rate base of the corresponding commodity; The consumption rate of the corresponding commodity with a card voucher is used in combination with the consumption rate base to calculate the consumption rate ratio of the corresponding commodity with a card voucher. ,have ， In the formula, is the consumption rate of the corresponding product with coupons, is the consumption rate base.

6. The online marketing card and promotion activity data tracking and optimization system according to claim 2, characterized in that: The step of evaluating the effect of the promotion activity according to the ratio of the consumption rate of the corresponding commodity with a card or coupon and the preset first threshold and the preset second threshold of the corresponding commodity to obtain the evaluation result of the corresponding commodity includes: Determine whether the card-voucher consumption rate ratio of the corresponding product is greater than the first threshold; If the card-voucher consumption rate ratio of the corresponding product is greater than the first threshold of the corresponding product, the promotion effect of the corresponding product is evaluated as excellent; If the card-voucher consumption rate ratio of the corresponding product is less than or equal to the first threshold of the corresponding product, then determine whether the card-voucher consumption rate ratio of the corresponding product is greater than the second threshold of the corresponding product; If the card-voucher consumption rate ratio of the corresponding product is greater than the second threshold value of the corresponding product, the promotion effect of the corresponding product is evaluated as average; If the card-voucher consumption rate ratio of the corresponding product is less than or equal to the second threshold value of the corresponding product, the promotion effect of the corresponding product is evaluated as poor.

7. The online marketing card and promotion activity data tracking and optimization system according to claim 2, characterized in that: The optimization warning module is also used to determine whether the evaluation result is consistent with the actual effect; wherein, If it is consistent with the actual situation, the evaluation result of the corresponding product and the card and coupon consumption rate of the corresponding product will not be saved; If it is inconsistent with the actual situation, the evaluation result of the corresponding product is updated according to the actual effect, and the absolute value of the difference between the current card-coupon consumption rate of the corresponding product and the average card-coupon consumption rate of the corresponding product in history is calculated to obtain the error value of the corresponding product; Determine whether the error value of the corresponding product is greater than a preset third threshold; If the error value of the corresponding commodity is greater than the third threshold, the consumption rate of the corresponding commodity with a card or coupon and the updated evaluation result are not saved; If the error value is less than or equal to the third threshold, the card and coupon consumption rate of the corresponding commodity and the updated evaluation result are stored in the data storage module.

8. The online marketing card and promotion activity data tracking and optimization system according to claim 2, characterized in that: The range setting module includes a time configuration unit and an effect threshold configuration unit; wherein, The time configuration unit is used to analyze and calculate the card and coupon consumption records and the card and coupon consumption records of the corresponding commodities in different time periods to obtain the preset time periods of the corresponding commodities; The effect configuration unit is used to analyze and calculate the evaluation result of the corresponding commodity and the card and coupon consumption rate of the corresponding commodity to obtain the first threshold value of the corresponding commodity and the second threshold value of the corresponding commodity.

9. The online marketing card and promotion activity data tracking and optimization system according to claim 8, characterized in that: The analysis and calculation of the card-voucher consumption records and the card-free consumption records of the corresponding commodities in different time periods to obtain the preset time periods of the corresponding commodities include: Collect historical data on factors that affect the consumption records of corresponding products with coupons and historical consumption records of corresponding products with coupons to build a training set; Taking the historical factor data that affects the card-voucher consumption record of the corresponding commodity as input and the card-voucher consumption record of the corresponding commodity as output, using the training set to establish and train a regression model to obtain a card-voucher consumption record prediction model; Predicting card-coupon consumption records of corresponding commodities using the card-coupon consumption record prediction model; Divide the card and coupon consumption records of the corresponding products into different time periods, calculate the card and coupon consumption rates of the corresponding products in each time period, and arrange them from largest to smallest; The time period corresponding to the card and coupon consumption rate that ranks first is selected to obtain the preset time period for the corresponding product.

10. An online marketing card and promotion activity data tracking and optimization system according to claim 8, characterized in that: The analyzing and calculating the evaluation result of the corresponding commodity and the card-voucher consumption rate of the corresponding commodity to obtain the first threshold value of the corresponding commodity and the second threshold value of the corresponding commodity includes: Acquire the evaluation results of the corresponding commodities and the consumption rates of the corresponding commodities with coupons in the data storage module in real time, and construct a real-time data set; Using the real-time data set, calculate the average of the card and coupon consumption rates of the corresponding products with excellent promotion effects to obtain a first average value; Using the real-time data set, the average value of the card and coupon consumption rate of the corresponding commodity promotion effect is calculated to obtain a second mean value; Calculate the average of the card and coupon consumption rates with poor promotion effects of the corresponding products using the real-time data set to obtain a third mean; The first mean, the second mean, the third mean, the consumption rate base of the corresponding commodity and the newly saved card and coupon consumption rate of the corresponding commodity are used to calculate the new first threshold value and the new second threshold value of the corresponding commodity. ,have ， In the formula, is the first mean of the corresponding product, is the second mean of the corresponding product, is the current first threshold of the corresponding product, is the rate of change coefficient of the first threshold, is the consumption rate of the corresponding product with coupons, is the consumption rate base; For the current second threshold of the corresponding product ,have ， In the formula, is the third mean of the corresponding product, is the second threshold value of the corresponding product. is the change rate coefficient of the second threshold, the quantity of consumption record information within the time period; Among them, when there is currently no first threshold and second threshold for the corresponding product, the preset initial value is used; when the newly saved card-voucher consumption rate corresponds to an updated evaluation result of excellent, only the new first threshold is calculated; when the newly saved card-voucher consumption rate corresponds to an updated evaluation result of average, the new first threshold and the new second threshold are calculated at the same time; when the newly saved card-voucher consumption rate corresponds to an updated evaluation result of poor, only the new second threshold is calculated.

Images