Method and device for generating marketing activity digital ranking list
By acquiring and aggregating marketing campaign data and generating rankings based on award calculation rules, the problem of inefficiency in banks' financial marketing activities has been solved, achieving efficient and accurate data processing and ranking generation.
Patent Information
- Application Number
- CN202511897325.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-12-16
- Publication Date
- 2026-03-20
AI Technical Summary
Banks are inefficient when planning and executing financial marketing campaigns because they rely on manual analysis and processing of large amounts of data.
By acquiring campaign information, checking initialization fields, aggregating metric data, and generating leaderboards based on award calculation rules, manual intervention can be avoided, thus improving data processing efficiency.
It enables accurate calculation of award scores and timely generation of leaderboards, improving work efficiency, avoiding human error, and simplifying the execution process of marketing activities.
Smart Images
Figure CN121705285A_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of data processing technology, and in particular to a method and apparatus for generating a digital ranking of marketing campaigns. Background Technology
[0002] As competition intensifies in the financial industry, banking operations are undergoing digital transformation, particularly in the area of precision marketing. Digital precision marketing enables banks to offer more personalized and differentiated services to meet the needs of diverse customer groups.
[0003] Currently, banks typically rely on manual analysis and processing of massive amounts of data to formulate marketing plans and reward distribution strategies when planning and executing financial marketing campaigns. Although traditional marketing models have achieved a certain degree of digitalization and online integration, the increasing number of financial marketing campaigns and the growing complexity of data have made manual analysis and processing of large amounts of data extremely tedious, resulting in inefficiency. Summary of the Invention
[0004] This application provides a method and apparatus for generating digital rankings of marketing campaigns to solve the problem that manual analysis and processing of large amounts of data becomes extremely cumbersome, resulting in low efficiency.
[0005] To achieve the above objectives, this application provides the following technical solution:
[0006] The first aspect of this application provides a method for generating a digital ranking of marketing campaigns, including:
[0007] Obtain activity information for marketing campaigns; the activity information shall include at least the activity time range, indicator data, award names, and award calculation rules.
[0008] If the current date falls within the activity time range, check if the marketing activity's initialization field is empty;
[0009] If the initialization field of the marketing activity is not empty, the indicator data is aggregated to obtain aggregated indicator data.
[0010] The aggregated indicator data is calculated according to the award calculation rules to obtain the award score;
[0011] A leaderboard is generated based on the award name and the award score.
[0012] Optionally, the aggregation of the indicator data to obtain aggregated indicator data includes:
[0013] Obtain the activity indicator definition table from the activity information;
[0014] According to the activity index definition table, current index data required for the current date is obtained from the index data;
[0015] The current index data is stored into a score table to obtain aggregated index data.
[0016] Optionally, the aggregation of the index data to obtain aggregated index data comprises:
[0017] When the activity index definition table contains a group number, the index data is grouped according to the group number to obtain index groups;
[0018] Index group data corresponding to the index groups and index weights corresponding to the index group data are obtained from the index group table;
[0019] Based on the index group data and the index weights corresponding to the index group data, summary data of the index groups is determined;
[0020] The summary data of the index groups is stored into a score table to obtain aggregated index data.
[0021] Optionally, the method further comprises:
[0022] When there is a nested award, an award calculation rule and a dependency relationship corresponding to the nested award are obtained; the dependency relationship comprises a dependent award;
[0023] The award score of the dependent award is taken as input data;
[0024] Based on the award calculation rule corresponding to the nested award, the input data is calculated to obtain an award score of the nested award.
[0025] Optionally, the method further comprises:
[0026] The display state of a ranking list of the marketing activity is changed to a hidden state;
[0027] When a ranking list query request containing user information is received, it is detected whether the user information is contained in a white list;
[0028] If the user information is contained in the white list, a ranking list corresponding to the ranking list query request is displayed.
[0029] The second aspect of the application provides a generation device of a digital ranking list of a marketing activity, comprising:
[0030] An acquisition unit is configured to acquire activity information of a marketing activity; the activity information at least comprises an activity time range, index data, an award name and an award calculation rule;
[0031] The checking unit is configured to check whether an initialization field of the marketing campaign is empty if the current date is within the active time range;
[0032] The aggregating unit is configured to aggregate the index data to obtain aggregated index data if the initialization field of the marketing campaign is not empty.
[0033] The calculating unit is configured to calculate the aggregated index data according to the award calculation rule to obtain an award score.
[0034] The generating unit is configured to generate a ranking list based on the award name and the award score.
[0035] Optionally, the aggregating unit is specifically configured to:
[0036] obtain an activity index definition table from the activity information;
[0037] obtain current index data required by the current date from the index data according to the activity index definition table;
[0038] store the current index data into a score table to obtain the aggregated index data.
[0039] Optionally, the aggregating unit is specifically configured to:
[0040] group the index data according to the group number to obtain an index group when the activity index definition table contains the group number;
[0041] obtain index group data corresponding to the index group and an index weight corresponding to the index group data from the index group table;
[0042] determine summary data of the index group based on the index group data and the index weight corresponding to the index group data;
[0043] store the summary data of the index group into the score table to obtain the aggregated index data.
[0044] Optionally, the method further comprises:
[0045] The relationship obtaining unit is configured to obtain an award calculation rule and a dependency relationship corresponding to the nested award when the nested award exists; the dependency relationship includes a dependent award;
[0046] The determining unit is configured to take an award score of the dependent award as input data;
[0047] The score calculating unit is configured to calculate the input data based on the award calculation rule corresponding to the nested award to obtain an award score of the nested award.
[0048] Optionally, further comprising:
[0049] The changing unit is configured to change a display state of the ranking list of the marketing activity to a hidden state.
[0050] The detecting unit is configured to detect whether the user information is contained in a white list when receiving the ranking list query request containing the user information.
[0051] The displaying unit is configured to display the ranking list corresponding to the ranking list query request if the user information is contained in the white list.
[0052] The technical scheme provided in the application obtains activity information of a marketing activity; the activity information at least includes an activity time range, index data, an award name and an award calculation rule; if a current date is within the activity time range, it is checked whether an initialization field of the marketing activity is empty; if the initialization field of the marketing activity is not empty, the index data is aggregated to obtain aggregated index data; the aggregated index data is calculated according to the award calculation rule to obtain an award score; and a ranking list is generated based on the award name and the award score. Through aggregating the index data and calculating the score according to the award calculation rule, the ranking list is generated, so as to avoid manual intervention and improve the efficiency and accuracy of data processing. This data processing manner ensures accurate calculation of the award score and timely generation of the ranking list, and greatly improves work efficiency. BRIEF DESCRIPTION OF DRAWINGS
[0053] In order to more clearly illustrate the technical schemes in the embodiments of the present application or the prior art, the drawings needed to be used in the embodiments or the prior art description will be briefly introduced. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor.
[0054] Figure 1 A flowchart of a generation method of a marketing activity digital ranking list provided by the embodiment of the present application;
[0055] Figure 2 A schematic diagram of a whole-process management of a marketing activity provided by the embodiment of the present application;
[0056] Figure 3 An architecture schematic diagram of a generation device of a marketing activity digital ranking list provided by the embodiment of the present application. DETAILED DESCRIPTION
[0057] With reference to the drawings, the technical solutions in the embodiments of the present application will be clearly and completely described below. Obviously, the described embodiments are only a part of the embodiments of the present application, but not all the embodiments of the present application. Based on the embodiments in the present application, all the other embodiments obtained by a person of ordinary skill in the art without creative effort should fall into the scope of the present application.
[0058] In the present application, the term "comprising" or "including" or any other variant thereof is intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements not only includes those elements, but also includes other elements not explicitly listed or inherent to such a process, method, article or device. Without more limitations, the element defined by the sentence "including a" does not exclude the presence of other identical elements in the process, method, article or device including the element.
[0059] As shown in FIG. 1, a flowchart of a method for generating a marketing activity digital ranking list provided by an embodiment of the present application includes the following steps: Figure 1
[0060] S101: Obtain activity information of a marketing activity.
[0061] The activity information at least includes an activity time range, index data, an award name and an award calculation rule.
[0062] Specifically, it generally refers to a series of activities organized and implemented by an enterprise or organization in order to promote products or services and achieve sales targets.
[0063] Optionally, the activity information further includes activity basic information definition (including activity name, stage, department, level, activity time range, etc.), activity index information definition (including activity index definition table and index grouping table), activity target definition (including the number of targets for each index), activity award definition (including award basic information, award type (institution / person), constituent index (index grouping), scoring rule, etc.).
[0064] The index is the smallest unit for award calculation. For example, the amount of deposits per capita, the number of cards issued, etc.
[0065] The awards are generally divided into two types: institutional and individual. The institutional awards include branch and sub-branch awards, and the individual awards include awards based on public and private dimensions and self-defined awards. Each award involves multiple algorithms for multiple indexes, and the corresponding assessment scores are calculated according to the award evaluation rules, and the ranking list is formed after sorting.
[0066] It should be noted that when the activity information of the marketing activity is entered in the front-end interface, the activity information of the marketing activity needs to be approved, and the approval needs to be performed by a person with the right to approve using his exclusive account. If the approval is passed, the activity is converted to a published state, and at this time, the activity information of the marketing activity can be obtained. If the approval is not passed, the activity information needs to be modified and resubmitted, and the complete process of the above design to approval is performed again.
[0067] In addition, if the activity involves group assessment, the activity group and group target need to be set according to the branch dimension; if the activity is divided into stages according to time, the time range and stage target of each stage need to be clearly defined. The activity can include multiple indicators and indicator groups, and support the configuration of multiple groups, stages and prizes, wherein each indicator needs to correspond to a target, and each prize can be associated with multiple indicators, and the activity and the prize can be independently set to display or hide. After completing the design, submit for approval, and after submission, the activity information is locked and cannot be modified.
[0068] Specifically, one marketing activity has one or more prizes, and each prize corresponds to a ranking list.
[0069] S102: If the current date is within the activity time range, check whether the initialization field of the marketing activity is empty.
[0070] If the initialization field of the marketing activity is not empty, step S103 is performed.
[0071] It can be understood that the activity number is looped and processed, and in each loop, the activity time range of a row of marketing activities is read. By comparing the preset "current date" in the activity definition table with the start and end dates in the activity time range, it is judged whether the current date is within the activity time range. If the current system date is within the activity time range, it means that the activity is in progress, and then it is checked whether the initialization field of the marketing activity is empty. If the current date is not within the activity time range, it means that the activity has not started or has ended, and there is no need to process.
[0072] Specifically, the specific implementation process of checking whether the initialization field of the marketing activity is empty is: checking whether the field corresponding to the current date is empty; if the field corresponding to the current date is empty, it means that the marketing activity has not been initialized; if the field corresponding to the current date is not empty, it means that the marketing activity already exists on the current date, which indicates that the marketing activity has been initialized.
[0073] It should be noted that if the activity has not been initialized, an initialization operation needs to be performed, which will clear all related indicator and prize score data. By setting and triggering the "initialization flag", complete activity data can be regenerated.
[0074] S103: Aggregate the indicator data to obtain the aggregated indicator data.
[0075] Optionally, the definition of the aggregation marketing activity involves all index data according to the activity index information.
[0076] Optionally, the aggregation of the index data is implemented by the following steps: obtaining an activity index definition table from the activity information; obtaining current index data required for the current date from the index data according to the activity index definition table; and storing the current index data into a score table to obtain the aggregated index data.
[0077] Optionally, in another embodiment of the present application, the implementation of step S103 includes processes A1 to A4.
[0078] A1: When the activity index definition table contains a group number, the index data is grouped according to the group number to obtain index groups.
[0079] It can be understood that if the "index number" field in the "activity index definition table" actually stores a "group number" instead of an index number following a specific rule, it means that the field stores a "group number".
[0080] A2: Obtain index group data corresponding to the index groups and index weights corresponding to the index group data from the index group table.
[0081] A3: Determine the summary data of the index groups based on the index group data and the index weights corresponding to the index group data.
[0082] It can be understood that the summary data of the index groups is determined based on the index group data and the index weights corresponding to the index group data, that is, the index group data and the index weights corresponding to the index group data are determined as the summary data of the index groups.
[0083] A4: Store the summary data of the index groups into the score table to obtain the aggregated index data.
[0084] It can be understood that to cope with the problems of explosive data volume, slow system response, and large storage pressure caused by a large number of activities, indexes, awards, institutions, and personnel, the embodiments of the present application propose a score data sub-table storage scheme. This scheme can effectively improve data processing efficiency, shorten system response time, reduce storage resource occupation, reduce operation and maintenance complexity, save storage space while retaining complete data trend.
[0085] It should be noted that based on the three dimensions of institutional level, time period and index granularity, the score data adopts a table storage strategy: in the level dimension, it is divided into an organization table and a personal table, which store the scores of marketing activities in the corresponding dimensions; in the time dimension, it is divided into a score table and a score history table, the former stores the daily scores of the current month, and the latter stores the key time point data such as the end-of-month value, the end-of-stage value, and the initial value of the activity; in the index dimension, it is divided into a score detail table and a score summary table, the detail table records the original data of single indicators, and the summary table calculates and stores the index summary score based on the detail data according to the award rules, corresponding to the award dimension analysis.
[0086] S104: Calculate the aggregated index data according to the award calculation rules to obtain the award score.
[0087] Among them, the award calculation rules include but are not limited to weighted sum, completion rate, median, fixed value comparison, growth rate, and original value.
[0088] Optionally, the award calculation rules can also be flexibly expanded according to actual needs.
[0089] Weighted sum: weighted summary calculation according to the original data of one or more index data and its preset weight.
[0090] Completion rate: calculated according to the ratio of the original data of the index data to its specified target value.
[0091] Median: based on the original data of the index data, according to the set calculation range (all or within the group) and the score interval, take the score corresponding to the median position.
[0092] Fixed value comparison: compare the original data of the index data with the specified comparison value (such as control target, initial value, average value of the whole jurisdiction, etc.) through the set comparison operator (such as equal, greater than or equal), if the condition is met, assign the corresponding fixed assessment score.
[0093] Growth rate: calculated according to the original data of the index data and its corresponding growth target.
[0094] Original value: directly use the original value of the index data in the corresponding data source as the score.
[0095] Among them, the data source is a database table that contains the index data required for award calculation. The original data is the numerical value of the index data in the data source.
[0096] Optionally, after step S104, when there are nested awards, the purpose of calculating the nested awards is to ensure that the interdependence and dependence between the awards are correctly processed according to the dependence relationship of the nested awards. The dependence relationship of the nested awards generally means that the scores or qualifications of certain awards depend on the scores or conditions of other awards. By calculating the nested awards, the integrity and hierarchical relationship of the award evaluation can be ensured. Therefore, in another embodiment of the present application, a method for calculating the scores of nested awards is provided, including processes B1 to B3.
[0097] B1: When there are nested awards, the award calculation rules and dependence relationship corresponding to the nested awards are obtained.
[0098] The dependence relationship includes dependent awards.
[0099] It can be understood that the upstream awards of the dependence of the nested awards are obtained.
[0100] B2: The award scores of the dependent awards are taken as input data.
[0101] B3: The input data is calculated based on the award calculation rules corresponding to the nested awards to obtain the award scores of the nested awards.
[0102] For example, award 1 is the index completion rate, and award 2 is the median of the index completion rate, and the output of award 1 is taken as the input of award 2. Award 2 is called a nested award.
[0103] It can be seen that the award nesting provides arbitrary possibilities for award combination and can realize the calculation of complex awards.
[0104] S105: Generate a ranking list based on the award name and the award score.
[0105] It can be understood that one marketing activity has one or more awards, and each award corresponds to a ranking list. Therefore, the ranking list of the award can be generated according to the award name and the award score corresponding to the award name.
[0106] In addition, the execution time of the automatic task can be flexibly configured through a parameter table. At the same time, the task supports manual execution function: it can be selected to start running from any date within the activity period, or it can be selected to be initialized from the start time of the activity, so as to effectively solve the problem of ranking list interruption caused by data supply exception and the like.
[0107] Optionally, after step S105, the ranking list can also be queried, and users or administrators can view and analyze the score situation of each award, so as to understand the ranking and performance of different participants. Therefore, in another embodiment of the present application, a ranking list query method is provided, including processes C1 to C2.
[0108] C1: When receiving a ranking list query request containing user information, detecting whether the user information is contained in the whitelist.
[0109] If the user information is contained in the whitelist, executing process C2.
[0110] Among them, the activity ranking list is provided with a whitelist access control mechanism. If the access range of an activity needs to be limited, the display state of the activity needs to be set to “hidden” first, and then the personnel information allowed to access and the corresponding activity number are configured in the whitelist. In this way, the activity can be opened only to specified personnel with permission.
[0111] It should be noted that if the user information is not contained in the whitelist, the ranking list is not allowed to be viewed.
[0112] C2: Displaying the ranking list corresponding to the ranking list query request.
[0113] It should be noted that the user can enter the “marketing activity ranking list” function through the front-end page, first filter and select the target marketing activity from the activity list (supporting filtering according to the “in progress” or “ended” state), and then view the ranking list data of the activity in a specific stage, a specific group, or a group in a certain stage (if any). At the same time, the user can also select a specific date through the calendar to view the ranking list of the corresponding date.
[0114] In some examples, the ranking list can be divided into two dimensions of institutions and individuals according to different activities, and can be displayed according to all indicators or specific award dimensions. The list usually contains information such as the names of institutions / individuals, assessment scores, value-added values (if any), and raw data of related indicators.
[0115] Among them, the value-added value is a score value obtained by calculating the raw data of some indicator data in the data source according to the set rules.
[0116] Specifically, if it is a sub-branch level award in the institution dimension, the list supports the downward drilling function, which can display the ranking of each branch under the sub-branch; if it is an individual dimension award, the ranking list of fixed dimension awards such as public and private or self-defined awards can be displayed according to the evaluation rules. For nested awards, the list also supports hierarchical exploration to the raw data layer. In addition, all ranking lists display the current ranking and its floating change compared with the previous month. Data export function is also provided, which supports exporting all lists or single award data (including complete information of all nested awards under it).
[0117] In order to better explain Figure 1 the content shown, see Figure 2 a schematic diagram of the whole process management of a marketing activity is shown. In Figure 2In this process, the full-process management of marketing activities mainly includes three stages: First, the activity is entered through the front-end interface, and the activity information is filled in and submitted for approval and release; then, the back-end automatically performs data processing tasks, including the initialization of activity data and the daily processing of activity data according to preset rules, and finally generates the data required for the activity ranking; finally, according to user needs, the activity ranking data of different organizational levels and different award dimensions are flexibly displayed on the front end.
[0118] In summary, by aggregating indicator data and calculating scores according to award rules to generate leaderboards, manual intervention is avoided, improving the efficiency and accuracy of data processing. This data processing method ensures accurate calculation of award scores and timely generation of leaderboards, significantly improving work efficiency and avoiding human error. Furthermore, it simplifies the execution process of marketing campaigns, allowing marketers to focus on strategic decision-making rather than tedious data processing, thereby improving overall marketing effectiveness. This automated solution solves the problems of inefficiency and frequent errors in existing technologies, ensuring the smooth execution of marketing campaigns.
[0119] like Figure 3 The diagram shown is an architectural schematic of a marketing campaign digital ranking generation device provided in the application embodiment. The generation device includes: an acquisition unit 100, an inspection unit 200, an aggregation unit 300, a calculation unit 400, and a generation unit 500.
[0120] Unit 100 is used to obtain activity information for marketing campaigns; the activity information includes at least the activity time range, indicator data, award names, and award calculation rules.
[0121] Check unit 200 is used to check whether the initialization field of the marketing campaign is empty if the current date is within the activity time range.
[0122] Aggregation unit 300 is used to aggregate the indicator data if the initialization field of the marketing campaign is not empty, and obtain the aggregated indicator data.
[0123] The aggregation unit 300 is specifically used for: obtaining the activity indicator definition table from the activity information; obtaining the current indicator data required for the current date from the indicator data according to the activity indicator definition table; storing the current indicator data in the score table to obtain the aggregated indicator data.
[0124] The aggregation unit 300 is specifically configured to: when the activity index definition table contains a group number, grouping the index data according to the group number to obtain an index group; obtaining, from the index group table, index group data corresponding to the index group and an index weight corresponding to the index group data; determining summary data of the index group based on the index group data and the index weight corresponding to the index group data; and storing the summary data of the index group into the score table to obtain aggregated index data.
[0125] The computing unit 400 is configured to calculate the aggregated index data according to a prize calculation rule to obtain a prize score.
[0126] The generating unit 500 is configured to generate a ranking list based on the prize name and the prize score.
[0127] In summary, by aggregating the index data and calculating the score according to the prize calculation rule to generate the ranking list, manual intervention is avoided, and the efficiency and accuracy of data processing are improved. This data processing method ensures accurate calculation of the prize score and timely generation of the ranking list, greatly improving work efficiency and avoiding human errors. In addition, the execution process of the marketing activity is simplified, allowing marketing personnel to focus on strategic decision-making rather than tedious data processing, thereby improving overall marketing effectiveness. Through this automated solution, the problems of low efficiency and frequent errors in the prior art are solved, ensuring the smooth progress of the marketing activity.
[0128] In combination with the content shown in the first aspect, Figure 3 the generating apparatus further includes:
[0129] The relationship obtaining unit is configured to, when there is a nested prize, obtain a prize calculation rule and a dependency relationship corresponding to the nested prize; the dependency relationship includes a dependent prize.
[0130] The determining unit is configured to take the prize score of the dependent prize as input data.
[0131] The score calculating unit is configured to calculate the input data based on the prize calculation rule corresponding to the nested prize to obtain a prize score of the nested prize.
[0132] In combination with the content shown in the first aspect, Figure 3 the generating apparatus further includes:
[0133] The changing unit is configured to change a display state of the ranking list of the marketing activity to a hidden state.
[0134] The detecting unit is configured to, when receiving a ranking list query request containing user information, detect whether the user information is contained in a white list.
[0135] The displaying unit is configured to, if the user information is contained in the white list, display the ranking list corresponding to the ranking list query request.
[0136] The various embodiments described in this specification are intended to be illustrative only and alterations and / or modifications to the illustrated embodiments can readily occur to those skilled in the art. Accordingly, the phraseology "at least one of A and B should be construed in the sense that A and B include at least one of A and B, but not the possibility of the presence of all of the members, in the sense of "and / or", unless otherwise indicated herein. Moreover, where a choice of means or elements is expressly contemplated by this specification (for example, where a parameter is "selected from the group consisting of A, B, and C"), then "at least one of A and B" is understood to allow for "A but not B", "B but not A", and "A and B" as well as the possibility of the presence of all of the members of the group. The various embodiments described in this specification can be described in the general context of computer-executable instructions of a computer program that runs on computer hardware. Computer-executable instructions include, but are not limited to, computer program code, routines, subroutines, programs, applications, software modules, microcode, bytecode, firmware, macros, interpreters, and machine code. Such computer-executable instructions or computer program can be stored, compiled, or interpreted to run on one or more computers, processors, or other hardware. As such, the term "computer" should be taken to encompass any of these possibilities and should not be limited to a general purpose computer. The above-described systems and system embodiments are merely illustrative and not restrictive, wherein the units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, i.e., they may be located in one place or distributed over multiple network units. Some or all of the modules can be selected according to actual needs to achieve the purposes of the embodiments. Those skilled in the art can understand and implement without creative labor.
[0137] Those skilled in the art will further appreciate that the units and algorithm steps of the examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of both. To clearly illustrate the interchangeability of hardware and software, the components and steps of the examples have been described in general terms hereinabove as being generally described in terms of functionality. Whether such functionality is implemented as hardware or software depends on the particular application and design constraints imposed on the overall system. Those skilled in the art can implement the described functionality in varying ways for each particular application, but such implementation should not be interpreted to change the scope of the present application.
[0138] The above description of disclosed embodiments enables a person skilled in the art to implement or use the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the present application. Accordingly, the present application will not be limited to the embodiments shown herein but will be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims
1. A method for generating a digital ranking list for marketing campaigns, characterized in that, include: Obtain information about marketing campaigns; The activity information shall include at least the activity time range, indicator data, award names, and award calculation rules; If the current date falls within the activity time range, check if the marketing activity's initialization field is empty; If the initialization field of the marketing activity is not empty, the indicator data is aggregated to obtain aggregated indicator data. The aggregated indicator data is calculated according to the award calculation rules to obtain the award score; A leaderboard is generated based on the award name and the award score.
2. The method according to claim 1, characterized in that, The aggregation of the indicator data to obtain aggregated indicator data includes: Obtain the activity indicator definition table from the activity information; According to the activity indicator definition table, obtain the current indicator data required for the current date from the indicator data; The current indicator data is stored in the score table to obtain the aggregated indicator data.
3. The method according to claim 2, characterized in that, The aggregation of the indicator data to obtain aggregated indicator data includes: When the activity indicator definition table contains a group number, the indicator data is grouped according to the group number to obtain indicator groups; Obtain the indicator group data and the indicator weights corresponding to the indicator group from the indicator grouping table; Based on the indicator grouping data and the indicator weights corresponding to the indicator grouping data, the summary data of the indicator grouping is determined; The aggregated data of the indicator groups is stored in the score table to obtain the aggregated indicator data.
4. The method according to claim 1, characterized in that, Also includes: When nested awards exist, obtain the award calculation rules and dependencies corresponding to the nested awards; The dependencies include dependency awards; Use the award scores of the dependent awards as input data; The input data is calculated based on the award calculation rules corresponding to the nested awards to obtain the award scores for the nested awards.
5. The method according to claim 1, characterized in that, Also includes: Change the display status of the marketing campaign's leaderboard to hidden; When a leaderboard query request containing user information is received, it is checked whether the user information is included in the whitelist. If the whitelist contains the user information, then the ranking list corresponding to the ranking list query request will be displayed.
6. A device for generating a digital ranking list for marketing campaigns, characterized in that, include: The acquisition unit is used to acquire activity information for marketing campaigns; The activity information shall include at least the activity time range, indicator data, award names, and award calculation rules; The checking unit is used to check whether the initialization field of the marketing campaign is empty if the current date is within the activity time range; An aggregation unit is used to aggregate the indicator data if the initialization field of the marketing activity is not empty, so as to obtain aggregated indicator data. The calculation unit is used to calculate the aggregated indicator data according to the award calculation rules to obtain the award score; The generation unit is used to generate a ranking list based on the award name and the award score.
7. The apparatus according to claim 6, characterized in that, The aggregation unit is specifically used for: Obtain the activity indicator definition table from the activity information; According to the activity indicator definition table, obtain the current indicator data required for the current date from the indicator data; The current indicator data is stored in the score table to obtain the aggregated indicator data.
8. The apparatus according to claim 6, characterized in that, The aggregation unit is specifically used for: When the activity indicator definition table contains a group number, the indicator data is grouped according to the group number to obtain indicator groups; Obtain the indicator group data and the indicator weights corresponding to the indicator group from the indicator grouping table; Based on the indicator grouping data and the indicator weights corresponding to the indicator grouping data, the summary data of the indicator grouping is determined; The aggregated data of the indicator groups is stored in the score table to obtain the aggregated indicator data.
9. The apparatus according to claim 6, characterized in that, Also includes: The relationship acquisition unit is used to acquire the award calculation rules and dependency relationships corresponding to the nested awards when nested awards exist. The dependencies include dependency awards; A determining unit is used to take the award score of the dependent award as input data; The scoring calculation unit is used to calculate the input data based on the award calculation rules corresponding to the nested awards to obtain the award scores of the nested awards.
10. The apparatus according to claim 6, characterized in that, Also includes: Change the display status of the marketing campaign's leaderboard to a hidden state; The detection unit is used to detect whether the whitelist contains the user information when a leaderboard query request containing user information is received. The display unit is used to display the ranking list corresponding to the ranking list query request if the whitelist contains the user information.