Marketing data processing method, device, server and storage medium

By pre-storing the user ID and policy ID of secondary marketing user data in a third-party data storage server and processing data within preset time intervals, the problem of delay in large-scale data processing of MySQL database is solved, and the secondary is improved Marketing efficiency.

CN114742615BActive Publication Date: 2024-12-06CHINA UNITED NETWORK COMM GRP CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202210389243.3
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-04-14
Publication Date
2024-12-06
Estimated Expiration
2042-04-14

AI Technical Summary

Technical Problem

In the existing digital full-scale operation system, when MySQL database processes tens of millions of secondary marketing user data, it leads to delayed data extraction, affecting the efficiency of secondary marketing.

Method used

By pre-stored the user ID and marketing strategy ID of secondary marketing user data in a third-party data storage server, and obtaining the delay marketing logo within the preset time interval, filtering and generating target data tables, and transmitting target policy information to the terminal, Improve data processing efficiency.

Benefits of technology

It significantly improves the efficiency of data extraction of secondary marketing user, reduces data processing delays, and improves the efficiency of marketing activities.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114742615B_ABST
    Figure CN114742615B_ABST
Patent Text Reader

Abstract

The present invention provides a marketing data processing method, device, server and storage medium, which relates to the field of wireless communication technology and is applied to a first server, including: obtaining all user orders corresponding to delayed marketing identifiers according to preset time intervals, treating all orders that do not contain target product ordering information in the user orders as delayed marketing orders, obtaining delayed marketing user identifiers corresponding to all delayed marketing orders, using the time of obtaining all user orders as delayed marketing time, and sending the delayed marketing identifier, all delayed marketing user identifiers and delayed marketing time to a second server, receiving a target data table returned by the second server, obtaining target strategy information corresponding to each target marketing strategy identifier in the target data table, and transmitting the target strategy information to a terminal corresponding to the target user identifier. The marketing data processing method provided by the present invention improves the efficiency of obtaining secondary marketing user data.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of wireless communication technologies, and in particular to a marketing data processing method, device, server and storage medium. Background Art

[0002] In the customer operation system of telecommunications operators, by building a digital full-scale operation system, a full-scale customer value operation platform is provided for the customer operation system.

[0003] In the existing digital full-scale operation system, during the execution of marketing activities, marketing is first carried out to customers through text messages. If the customer does not order related marketing products, the user data that needs to be marketed in the next wave will be stored in the MySQL database. When the specified time arrives, the secondary marketing user data will be extracted from the MySQL database, and secondary marketing will be carried out based on the extracted user data.

[0004] However, when the amount of user data required for secondary marketing reaches tens of millions, due to the limitation of data processing efficiency of MySQL database, there will be a problem of delayed return of data extraction during paging query of later pages, and the secondary marketing user data cannot be extracted quickly, which affects the efficiency of secondary marketing. Summary of the invention

[0005] The present invention provides a marketing data processing method, device, server and storage medium, which improve the processing efficiency of extracting secondary marketing user data by pre-storing user identifiers and marketing strategy identifiers of secondary marketing user data.

[0006] In a first aspect, the present invention provides a marketing data processing method, applied to a first server, comprising:

[0007] Obtain all user orders corresponding to the delayed marketing identifier at preset time intervals, treat all user orders that do not contain target product ordering information as delayed marketing orders, and obtain delayed marketing user identifiers corresponding to all delayed marketing orders;

[0008] The time for obtaining all user orders is used as the delayed marketing time, and the delayed marketing identifier, all delayed marketing user identifiers and the delayed marketing time are sent to the second server, so that the second server filters out a delayed marketing data table from a pre-stored marketing data table according to the delayed marketing time and the delayed marketing identifier, determines at least one target user data according to the user identifiers and all delayed marketing user identifiers contained in all user data in the delayed marketing data table, and generates a target data table according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier;

[0009] Receive the target data table returned by the second server, obtain the target policy information corresponding to each target marketing policy identifier in the target data table, and transmit the target policy information to the terminal corresponding to the target user identifier.

[0010] In a possible design, before acquiring all user orders corresponding to the delayed marketing identifier at a preset time interval, the method further includes:

[0011] In response to the received marketing instruction, obtaining a to-be-marketed identifier and at least one to-be-marketed user data contained in the marketing instruction, wherein the to-be-marketed user data includes a to-be-marketed user identifier and a to-be-marketed strategy identifier corresponding to each to-be-marketed user identifier;

[0012] Acquire the pending marketing strategy information corresponding to each pending marketing strategy identifier, and transmit the pending marketing strategy information to the terminal corresponding to the pending marketing user identifier;

[0013] Determine the delay time corresponding to the pending marketing identifier, use the time for transmitting the pending marketing strategy information as the marketing time, and use the sum of the delay time and the marketing time as the scheduled marketing time, generate a marketing data table according to the scheduled marketing time, the pending marketing identifier and all pending marketing user data, and send the marketing data table to the second server for storage.

[0014] In a possible design, before determining the delay time corresponding to the to-be-marketed logo, the method further includes:

[0015] Obtaining a delay strategy corresponding to the pending marketing identifier;

[0016] If it is determined according to the delay strategy that delayed marketing needs to be performed, then the step of determining the delay time corresponding to the to-be-marketed identifier is continued.

[0017] In a possible design, obtaining target strategy information corresponding to each target marketing strategy identifier in the target data table includes:

[0018] The target strategy information corresponding to each target marketing strategy identifier in the target data table is obtained according to the strategy information table pre-stored in the MySQL database.

[0019] In a second aspect, the present invention provides a marketing data processing method, which is applied to a second server.

[0020] Receiving the delayed marketing identifier, all delayed marketing user identifiers and delayed marketing time sent by the first server, wherein the delayed marketing time is the time when the first server obtains all user orders, and all delayed marketing user identifiers are all user orders corresponding to the delayed marketing identifiers obtained by the first server at preset time intervals, treating all user orders that do not contain target product ordering information as delayed marketing orders, and determining based on all delayed marketing orders;

[0021] A delayed marketing data table is screened out from a pre-stored marketing data table according to the delayed marketing time and the delayed marketing identifier, at least one target user data is determined according to the user identifier contained in all user data in the delayed marketing data table and all delayed marketing user identifiers, and a target data table is generated according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier;

[0022] The target data table is sent to the first server, so that the first server obtains the target policy information corresponding to each target marketing policy identifier in the target data table, and transmits the target policy information to the terminal corresponding to the target user identifier.

[0023] In a possible design, generating a target data table according to all target user data includes:

[0024] A distributed file system file is obtained according to all target user data, and a target data table is obtained according to the distributed file system file.

[0025] In a possible design, the marketing data table is an HBase data table.

[0026] In a third aspect, the present invention provides a marketing data processing device, applied to a first server, comprising:

[0027] An acquisition module is used to acquire all user orders corresponding to the delayed marketing identifier at preset time intervals, treat all user orders that do not contain target product ordering information as delayed marketing orders, and acquire delayed marketing user identifiers corresponding to all delayed marketing orders;

[0028] A sending module, used to use the time for obtaining all user orders as the delayed marketing time, and send the delayed marketing identifier, all delayed marketing user identifiers and the delayed marketing time to a second server, so that the second server filters out a delayed marketing data table from a pre-stored marketing data table according to the delayed marketing time and the delayed marketing identifier, determines at least one target user data according to the user identifiers contained in all user data in the delayed marketing data table and all delayed marketing user identifiers, and generates a target data table according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier;

[0029] The receiving module is used to receive the target data table returned by the second server, obtain the target policy information corresponding to each target marketing policy identifier in the target data table, and transmit the target policy information to the terminal corresponding to the target user identifier.

[0030] In a fourth aspect, the present invention provides a marketing data processing device, applied to a second server, comprising:

[0031] A receiving module, configured to receive a delayed marketing identifier, all delayed marketing user identifiers, and a delayed marketing time sent by the first server, wherein the delayed marketing time is the time when the first server obtains all user orders, and all delayed marketing user identifiers are all user orders corresponding to the delayed marketing identifiers obtained by the first server at preset time intervals, and orders that do not contain target product ordering information among all user orders are regarded as delayed marketing orders, and are determined based on all delayed marketing orders;

[0032] A screening module, used to screen out a delayed marketing data table from a pre-stored marketing data table according to the delayed marketing time and the delayed marketing identifier, determine at least one target user data according to the user identifier contained in all user data in the delayed marketing data table and all delayed marketing user identifiers, and generate a target data table according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier;

[0033] The sending module is used to send the target data table to the first server, so that the first server obtains the target strategy information corresponding to each target marketing strategy identifier in the target data table, and transmits the target strategy information to the terminal corresponding to the target user identifier.

[0034] In a fifth aspect, the present invention provides a server, comprising: at least one processor and a memory;

[0035] The memory stores computer-executable instructions;

[0036] The at least one processor executes the computer-executable instructions stored in the memory, so that the at least one processor performs the marketing data processing method as described in the first aspect and various possible designs of the first aspect.

[0037] In a sixth aspect, the present invention provides a server, comprising: at least one processor and a memory;

[0038] The memory stores computer-executable instructions;

[0039] The at least one processor executes the computer-executable instructions stored in the memory, so that the at least one processor performs the marketing data processing method as described in the second aspect and various possible designs of the second aspect.

[0040] In the seventh aspect, the present invention provides a computer storage medium storing computer execution instructions. When a processor executes the computer execution instructions, the marketing data processing method as described in the first aspect and various possible designs of the first aspect, or the second aspect and various possible designs of the second aspect is implemented.

[0041] The marketing data processing method, device, server and storage medium provided by the present invention are configured to obtain all user orders corresponding to the delayed marketing identifier according to a preset time interval, and to treat all orders of the user orders that do not contain the target product ordering information as delayed marketing orders, and to obtain the delayed marketing user identifiers corresponding to all delayed marketing orders, and to use the time of obtaining all user orders as the delayed marketing time, and to send the delayed marketing identifier, all delayed marketing user identifiers and delayed marketing time to the second server, and to receive the target data table returned by the second server, and to obtain the target strategy information corresponding to each target marketing strategy identifier in the target data table, and to transmit the target strategy information to the terminal corresponding to the target user identifier. The present invention improves the efficiency of obtaining secondary marketing user data by pre-storing the user identifiers and marketing strategy identifiers of secondary marketing user data in a third-party data storage server. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. 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 labor.

[0043] Figure 1 A schematic diagram of an application scenario of the marketing data processing method provided by an embodiment of the present invention;

[0044] Figure 2 Schematic diagram of the marketing data processing method provided by the embodiment of the present invention Figure 1 ;

[0045] Figure 3 Schematic diagram of the marketing data processing method provided by the embodiment of the present invention Figure 2 ;

[0046] Figure 4 Schematic diagram of the marketing data processing method provided by the embodiment of the present invention Figure 3 ;

[0047] Figure 5 A schematic diagram of the structure of a marketing data processing device provided by an embodiment of the present invention Figure 1 ;

[0048] Figure 6 A schematic diagram of the structure of a marketing data processing device provided by an embodiment of the present invention Figure 2 ;

[0049] Figure 7 Schematic diagram of the hardware structure of the server provided in the embodiment of the present invention Figure 1 ;

[0050] Figure 8 Schematic diagram of the hardware structure of the server provided in the embodiment of the present invention Figure 2 . DETAILED DESCRIPTION

[0051] 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.

[0052] In the process of executing marketing activities, multi-wave marketing is one of the important marketing methods, that is, marketing to customers in multiple times. For example, the first wave of marketing is to market to customers through text messages. If the customer does not order, the second wave of telephone marketing is carried out to the customer two days later. In the existing digital full-scale operation system, marketing is first carried out to customers through text messages. If the customer does not order the relevant marketing products, the user data that needs to be marketed in the next wave is stored in the MySQL database. When the specified time arrives, the secondary marketing user data is extracted from the MySQL database, and secondary marketing is carried out based on the extracted user data. However, when the amount of extracted secondary marketing user data reaches tens of millions, due to the limitation of MySQL data processing efficiency, if MySQL is used to extract the current wave of marketing data, there will be a problem of delayed return of extracted data during the paging query of the later pages, and the secondary marketing user data cannot be extracted quickly, affecting the efficiency of secondary marketing.

[0053] In order to solve the above technical problems, the embodiment of the present invention proposes the following technical solution: by pre-storing the user identification and marketing strategy identification of the secondary marketing user data in the third-party data storage server, the processing efficiency of extracting the secondary marketing user data is improved.

[0054] Figure 1 Schematic diagram of an application scenario of the marketing data processing method provided by an embodiment of the present invention. Figure 1 As shown, the first server is used to provide an operator marketing platform, and the policy information corresponding to the marketing policy identifier is pre-stored in the first server. The first server markets the user terminal through the stored policy information. The second server is used to provide a third-party data storage platform, and the user identifier and marketing policy identifier of the secondary marketing user data are pre-stored in the third-party data storage server. The first server uses the user identifier and marketing policy identifier of the secondary marketing user data stored in the second server to determine the marketing policy identifier of the user who needs to be secondary marketed, and determines the policy information corresponding to the marketing policy identifier. When using the marketing information to conduct secondary marketing on the user, the efficiency of secondary marketing is improved by improving the efficiency of extracting secondary marketing user data.

[0055] Figure 2 Schematic diagram of the marketing data processing method provided by the embodiment of the present invention Figure 1 , the execution subject of this embodiment can be Figure 1 The first server in the embodiment shown is not particularly limited in this embodiment. Figure 2 As shown, the method includes:

[0056] S201: Obtain all user orders corresponding to delayed marketing identifiers at preset time intervals, treat all user orders that do not contain target product ordering information as delayed marketing orders, and obtain delayed marketing user identifiers corresponding to all delayed marketing orders.

[0057] In an embodiment of the present invention, exemplarily, the preset time interval is set to 24 hours. Specifically, secondary marketing is started at 1 a.m. every day. By obtaining the information of all user orders that have undergone initial marketing corresponding to the delayed marketing identifier of this marketing. Exemplarily, when this marketing is to handle a network package, all user order information that has been sent marketing text messages when executing the network package activity is obtained at 1 a.m. every day, and users who have not subscribed to the network package are identified as users who need secondary marketing, that is, all user orders that do not contain target product ordering information are treated as delayed marketing orders, and the delayed marketing user identifiers corresponding to all delayed marketing orders are obtained. Exemplarily, the delayed marketing user identifier can be the user's mobile phone number.

[0058] Optionally, after obtaining all user orders corresponding to the delayed marketing identifier at a preset time interval, users who need secondary marketing can also be identified based on the initial marketing situation. Exemplarily, after a marketing SMS has been sent to the user, that is, when it is determined that the first wave of marketing information has reached the user, a call is made to the user for voice marketing according to the marketing strategy, and the user needs to be set as a user who needs secondary marketing in the following situations. Specifically, when the call is not connected, the user is connected but indicates no intention to order, the user is connected and indicates an intention to order but has not ordered, the phone rings for more than 8 seconds, the user hangs up within 2 seconds after answering the call, and the user hangs up within 5 seconds after answering the call, the user in the above situations is set as a user who needs secondary marketing.

[0059] S202: The time for obtaining all user orders is used as the delayed marketing time, and the delayed marketing identifier, all delayed marketing user identifiers and the delayed marketing time are sent to the second server, so that the second server filters out the delayed marketing data table from the pre-stored marketing data table according to the delayed marketing time and the delayed marketing identifier, determines at least one target user data according to the user identifier contained in all user data in the delayed marketing data table and all delayed marketing user identifiers, and generates a target data table according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier.

[0060] In an embodiment of the present invention, if the delayed marketing user identifiers corresponding to all users who need to undergo secondary marketing are obtained at 1 a.m. on December 2, 2021, December 2, 2021 will be used as the delayed marketing time, and the delayed marketing identifier, all delayed marketing user identifiers, and the delayed marketing time will be sent to the second server. The second server stores marketing data tables corresponding to different delayed marketing times. The second server identifies all marketing data tables corresponding to the marketing activity based on the delayed marketing identifier, and then determines the delayed marketing data table corresponding to the delayed marketing time. Each delayed marketing data table contains multiple user data, and each user data contains the user identifier of the user and the corresponding marketing strategy identifier.

[0061] In an embodiment of the present invention, specifically, the second server finds all target user data that are consistent with the delayed marketing user identifier in the delayed marketing data table, that is, the user identification of the target user data is consistent with the delayed marketing user identifier, and generates a target data table based on all target user data. Each target user data contains a target user identifier and a corresponding target marketing strategy identifier. Exemplarily, the second server obtains a distributed file system file based on all target user data, and obtains a target data table based on the distributed file system file. Specifically, using DataX, data can be quickly exported to a distributed file system (Hadoop Distributed File System, HDFS) to form a file, which is convenient for subsequent distributed batch processing. DataX is an offline synchronization tool for heterogeneous data sources.

[0062] S203: Receive the target data table returned by the second server, obtain the target policy information corresponding to each target marketing policy identifier in the target data table, and transmit the target policy information to the terminal corresponding to the target user identifier.

[0063] In the embodiment of the present invention, the second server sends the generated target data table to the first server. Since different users have different levels, the corresponding policy information is also different. The first server identifies the target policy information corresponding to each target user identifier that needs to be remarketed from the policy information table. Specifically, the target policy information corresponding to each target marketing policy identifier in the target data table can be obtained according to the policy information table pre-stored in the MySQL database.

[0064] In the embodiment of the present invention, after obtaining the target strategy information corresponding to each target marketing strategy identifier in the target data table, secondary marketing can be performed on the target user according to the target strategy information corresponding to each target user identifier. Specifically, secondary marketing can be performed by door-to-door service, or activity information contained in the strategy information can be pushed to the application software of the user terminal, thereby realizing various forms of secondary marketing.

[0065] The marketing data processing method provided in this embodiment is to set a first server to obtain a delayed marketing user identifier according to a delayed marketing order, and send the delayed marketing identifier, all delayed marketing user identifiers and delayed marketing time to a second server, and obtain the target strategy information corresponding to each user who needs to perform secondary marketing according to the target data table returned by the second server, and transmit the target strategy information to the terminal corresponding to the target user identifier. The present invention improves the efficiency of obtaining secondary marketing user data by pre-storing the user identifier and marketing strategy identifier of the secondary marketing user data in a third-party data storage server.

[0066] Figure 3 Schematic diagram of the marketing data processing method provided by the embodiment of the present invention Figure 2 In the embodiment of the present invention, Figure 2 Based on the embodiment provided, before obtaining all user orders corresponding to the delayed marketing identifier according to the preset time interval in S202, the generation process of the marketing data table stored in the second server is described in detail. Figure 3 As shown, the method includes:

[0067] S301: In response to a received marketing instruction, obtain a to-be-marketed identifier and at least one to-be-marketed user data contained in the marketing instruction, wherein the to-be-marketed user data includes a to-be-marketed user identifier and a to-be-marketed strategy identifier corresponding to each to-be-marketed user identifier.

[0068] In the embodiment of the present invention, when a marketing campaign is started, the target user of this marketing campaign is selected according to the user's historical order data. Specifically, after receiving a marketing instruction containing a to-be-marketed identifier, the marketing campaign is started to start the initial marketing, and all to-be-marketed user data are obtained according to all selected user information. Specifically, each to-be-marketed user data contains a to-be-marketed user identifier and a to-be-marketed strategy identifier corresponding to each to-be-marketed user identifier.

[0069] S302: Acquire the pending marketing strategy information corresponding to each pending marketing strategy identifier, and transmit the pending marketing strategy information to the terminal corresponding to the pending marketing user identifier.

[0070] In the embodiment of the present invention, the marketing strategy information corresponding to each marketing strategy identifier is determined according to the pre-stored strategy information table. The marketing strategy identifier is generally an 8-byte character set according to the rules, and the marketing strategy information is the detailed rules of the specific marketing process of this marketing activity. After obtaining the marketing strategy information corresponding to each marketing strategy identifier, the marketing strategy information is transmitted to the terminal corresponding to the marketing user identifier according to the marketing rules set in the marketing strategy information corresponding to each user, that is, the initial marketing is performed on the user terminal corresponding to each marketing user identifier.

[0071] S303: Determine the delay time corresponding to the pending marketing identifier, use the time for transmitting the pending marketing strategy information as the marketing time, and use the sum of the delay time and the marketing time as the scheduled marketing time, generate a marketing data table based on the scheduled marketing time, the pending marketing identifier and all pending marketing user data, and send the marketing data table to the second server for storage.

[0072] In an embodiment of the present invention, the time for transmitting the pending marketing strategy information is used as the marketing time, that is, the time when the marketing information reaches the user terminal is used as the marketing time. In one scenario, different marketing activities have different delay times set, and some marketing activities may not even require delayed marketing, so it is necessary to determine whether to perform delayed marketing and the corresponding delay time based on the delay strategy corresponding to the marketing identifier. Exemplarily, by obtaining the delay strategy corresponding to the pending marketing identifier, if it is determined according to the delay strategy that delayed marketing needs to be performed, the delay time corresponding to the pending marketing identifier is determined. In the first server, an interface for setting the extension time is provided. Exemplarily, the planning staff of the marketing activity can set the planning content and delay time of the marketing activity through the platform provided by the first server.

[0073] In an embodiment of the present invention, after the delay time and the marketing time are determined, the sum of the delay time and the marketing time is used as the scheduled marketing time. For example, if the marketing time is December 2, 2021 and the delay time is 2 days, the scheduled marketing time is December 4, 2021. A marketing data table is generated according to the scheduled marketing time, the pending marketing identifier, and all pending marketing user data, and the marketing data table is sent to the second server for storage.

[0074] Exemplarily, the second server is a third-party storage platform storing HBase, and the marketing data table is an HBase data table. Specifically, the naming rule of the marketing data table is tf_perform_hbase_wave_data_YYYYMMDD, where YYYYMMDD is the initial marketing time, and the specific format is the year, month, and day corresponding to the initial marketing time.

[0075] Figure 4 Schematic diagram of the marketing data processing method provided by the embodiment of the present invention Figure 3 , the execution subject of this embodiment can be Figure 1 The second server in the embodiment shown is not particularly limited in this embodiment. Figure 4 As shown, the method includes:

[0076] S401: Receive the delayed marketing identifier, all delayed marketing user identifiers and delayed marketing time sent by the first server, where the delayed marketing time is the time for the first server to obtain all user orders, and all delayed marketing user identifiers are all user orders corresponding to the delayed marketing identifiers obtained by the first server at preset time intervals. All user orders that do not contain target product ordering information are regarded as delayed marketing orders, and are determined based on all delayed marketing orders.

[0077] S402: Filter out a delayed marketing data table from pre-stored marketing data tables according to the delayed marketing time and the delayed marketing identifier, determine at least one target user data according to the user identifier contained in all user data in the delayed marketing data table and all delayed marketing user identifiers, and generate a target data table according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier.

[0078] S403: Send the target data table to the first server, so that the first server obtains the target policy information corresponding to each target marketing policy identifier in the target data table, and transmits the target policy information to the terminal corresponding to the target user identifier.

[0079] In the embodiment of the present invention, the methods and effects of S401 to S403 are the same as Figure 2 S201 to S203 in the embodiment are consistent and will not be repeated here.

[0080] Figure 5 A schematic diagram of the structure of a marketing data processing device provided by an embodiment of the present invention Figure 1 The marketing data processing device 50 is applied to the first server, such as Figure 5 As shown, the marketing data processing device 50 includes: an acquisition module 501 , a sending module 502 and a receiving module 503 .

[0081] The acquisition module 501 is used to acquire all user orders corresponding to the delayed marketing identifier at a preset time interval, regard all user orders that do not contain target product ordering information as delayed marketing orders, and acquire delayed marketing user identifiers corresponding to all delayed marketing orders;

[0082] A sending module 502 is used to use the time for obtaining all user orders as the delayed marketing time, and to send the delayed marketing identifier, all delayed marketing user identifiers and the delayed marketing time to the second server, so that the second server filters out a delayed marketing data table from a pre-stored marketing data table according to the delayed marketing time and the delayed marketing identifier, determines at least one target user data according to the user identifiers and all delayed marketing user identifiers contained in all user data in the delayed marketing data table, and generates a target data table according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier;

[0083] The receiving module 503 is used to receive the target data table returned by the second server, obtain the target policy information corresponding to each target marketing policy identifier in the target data table, and transmit the target policy information to the terminal corresponding to the target user identifier.

[0084] In one possible implementation, the marketing data processing device 50 also includes a determination module for obtaining, in response to a received marketing instruction, an identification to be marketed and at least one piece of user data to be marketed contained in the marketing instruction, wherein the user data to be marketed includes the user identification to be marketed and a strategy identification to be marketed corresponding to each user identification to be marketed; obtaining strategy information to be marketed corresponding to each strategy identification to be marketed, and transmitting the strategy information to be marketed to a terminal corresponding to the user identification to be marketed; determining a delay time corresponding to the identification to be marketed, taking the time for transmitting the strategy information to be marketed as the marketing time, and taking the sum of the delay time and the marketing time as the scheduled marketing time, generating a marketing data table according to the scheduled marketing time, the identification to be marketed and all user data to be marketed, and sending the marketing data table to the second server for storage.

[0085] In a possible implementation, the marketing data processing device 50 also includes a determination module to obtain a delay strategy corresponding to the pending marketing identifier; if it is determined according to the delay strategy that delayed marketing needs to be performed, then the step of determining the delay time corresponding to the pending marketing identifier is continued.

[0086] In a possible implementation, the receiving module 503 is specifically configured to obtain the target strategy information corresponding to each target marketing strategy identifier in the target data table according to a strategy information table pre-stored in a MySQL database.

[0087] Figure 6 A schematic diagram of the structure of a marketing data processing device provided by an embodiment of the present invention Figure 2 The marketing data processing device 60 is applied to the second server, such as Figure 6 As shown, the marketing data processing device 60 includes: a receiving module 601, a screening module 602 and a sending module 603.

[0088] The receiving module 601 is used to receive the delayed marketing identifier, all delayed marketing user identifiers and delayed marketing time sent by the first server, wherein the delayed marketing time is the time when the first server obtains all user orders, and all delayed marketing user identifiers are all user orders corresponding to the delayed marketing identifiers obtained by the first server at preset time intervals, and orders that do not contain target product ordering information among all user orders are regarded as delayed marketing orders, and are determined based on all delayed marketing orders;

[0089] A screening module 602 is used to screen out a delayed marketing data table from a pre-stored marketing data table according to the delayed marketing time and the delayed marketing identifier, determine at least one target user data according to the user identifier contained in all user data in the delayed marketing data table and all delayed marketing user identifiers, and generate a target data table according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier;

[0090] The sending module 603 is used to send the target data table to the first server, so that the first server obtains the target policy information corresponding to each target marketing policy identifier in the target data table, and transmits the target policy information to the terminal corresponding to the target user identifier.

[0091] In a possible implementation, the screening module 602 is specifically configured to obtain a distributed file system file according to all target user data, and obtain a target data table according to the distributed file system file.

[0092] The device provided in this embodiment can be used to execute the technical solution of the above method embodiment. Its implementation principle and technical effect are similar, and this embodiment will not be repeated here.

[0093] Figure 7 Schematic diagram of the hardware structure of the server provided in the embodiment of the present invention Figure 1 .like Figure 7 As shown, the server 70 of this embodiment includes: a processor 701 and a memory 702;

[0094] Memory 702, used to store computer-executable instructions;

[0095] The processor 701 is used to execute the computer-executable instructions stored in the memory to implement the various steps performed by the first server in the above embodiment. For details, please refer to the relevant description in the above method embodiment.

[0096] Optionally, the memory 702 may be independent or integrated with the processor 701 .

[0097] When the memory 702 is independently provided, the server further includes a bus 703 for connecting the memory 702 and the processor 701 .

[0098] Figure 8 Schematic diagram of the hardware structure of the server provided in the embodiment of the present invention Figure 2 .like Figure 8 As shown, the server 80 of this embodiment includes: a processor 801 and a memory 802;

[0099] Memory 802, used to store computer-executable instructions;

[0100] The processor 801 is used to execute the computer-executable instructions stored in the memory to implement the various steps performed by the second server in the above embodiment. For details, please refer to the relevant description in the above method embodiment.

[0101] Optionally, the memory 802 may be independent or integrated with the processor 801 .

[0102] When the memory 802 is independently configured, the server further includes a bus 803 for connecting the memory 802 and the processor 801 .

[0103] An embodiment of the present invention further provides a computer storage medium, in which computer execution instructions are stored. When a processor executes the computer execution instructions, the marketing data processing method as described above is implemented.

[0104] An embodiment of the present invention further provides a computer program product, including a computer program, which, when executed by a processor, implements the marketing data processing method as described above. An embodiment of the present invention further provides a computer program product, including a computer program, which, when executed by a processor, implements the marketing data processing method as described above.

[0105] In the several embodiments provided by the present invention, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic, for example, the division of the modules is only a logical function division, and there may be other division methods in actual implementation, such as multiple modules can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or modules, which can be electrical, mechanical or other forms.

[0106] The modules described as separate components may or may not be physically separated, and the components shown as modules may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the modules may be selected according to actual needs to implement the solution of this embodiment.

[0107] In addition, each functional module in each embodiment of the present invention may be integrated into one processing unit, or each module may exist physically separately, or two or more modules may be integrated into one unit. The above-mentioned module-composed unit may be implemented in the form of hardware or in the form of hardware plus software functional units.

[0108] The above-mentioned integrated module implemented in the form of a software function module can be stored in a computer-readable storage medium. The above-mentioned software function module is stored in a storage medium, including a number of instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) or a processor to perform some steps of the method described in each embodiment of the present application.

[0109] It should be understood that the processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), etc. A general-purpose processor may be a microprocessor or any conventional processor. The steps of the method disclosed in the invention may be directly implemented as being executed by a hardware processor, or may be implemented by a combination of hardware and software modules in the processor.

[0110] The memory may include high-speed random access memory (RAM), and may also include non-volatile memory (NVM), such as at least one disk memory, and may also be a USB flash drive, a mobile hard disk, a read-only memory, a disk or an optical disk, etc.

[0111] The bus may be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of representation, the bus in the drawings of the present application is not limited to only one bus or one type of bus.

[0112] The above storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk or optical disk. The storage medium can be any available medium that can be accessed by a general or special-purpose computer.

[0113] An exemplary storage medium is coupled to a processor so that the processor can read information from the storage medium and write information to the storage medium. Of course, the storage medium can also be a component of the processor. The processor and the storage medium can be located in an application specific integrated circuit (ASIC). Of course, the processor and the storage medium can also exist as discrete components in an electronic device or a main control device.

[0114] Those skilled in the art can understand that all or part of the steps of implementing the above-mentioned method embodiments can be completed by hardware related to program instructions. The aforementioned program can be stored in a computer-readable storage medium. When the program is executed, the steps of the above-mentioned method embodiments are executed; and the aforementioned storage medium includes: ROM, RAM, disk or optical disk and other media that can store program codes.

[0115] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A marketing data processing method, It is characterized in that Applied to the first server, comprising: In response to the received marketing instruction, obtaining a to-be-marketed identifier and at least one to-be-marketed user data contained in the marketing instruction, wherein the to-be-marketed user data includes a to-be-marketed user identifier and a to-be-marketed strategy identifier corresponding to each to-be-marketed user identifier; Acquire the pending marketing strategy information corresponding to each pending marketing strategy identifier, and transmit the pending marketing strategy information to the terminal corresponding to the pending marketing user identifier; Determine the delay time corresponding to the pending marketing identifier, use the time for transmitting the pending marketing strategy information as the marketing time, and use the sum of the delay time and the marketing time as the scheduled marketing time, generate a marketing data table according to the scheduled marketing time, the pending marketing identifier and all pending marketing user data, and send the marketing data table to the second server for storage; Obtain all user orders corresponding to the delayed marketing identifier at preset time intervals, treat all user orders that do not contain target product ordering information as delayed marketing orders, and obtain delayed marketing user identifiers corresponding to all delayed marketing orders; The time for obtaining all user orders is used as the delayed marketing time, and the delayed marketing identifier, all delayed marketing user identifiers and the delayed marketing time are sent to the second server, so that the second server filters out a delayed marketing data table from a pre-stored marketing data table according to the delayed marketing time and the delayed marketing identifier, determines at least one target user data according to the user identifiers and all delayed marketing user identifiers contained in all user data in the delayed marketing data table, and generates a target data table according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier; Receive the target data table returned by the second server, obtain the target policy information corresponding to each target marketing policy identifier in the target data table, and transmit the target policy information to the terminal corresponding to the target user identifier.

2. The method according to claim 1, It is characterized in that Before determining the delay time corresponding to the pending marketing logo, the method further includes: Obtaining a delay strategy corresponding to the pending marketing identifier; If it is determined according to the delay strategy that delayed marketing needs to be performed, then the step of determining the delay time corresponding to the to-be-marketed identifier is continued.

3. The method according to any one of claims 1 to 2, It is characterized in that The step of obtaining target strategy information corresponding to each target marketing strategy identifier in the target data table includes: The target strategy information corresponding to each target marketing strategy identifier in the target data table is obtained according to the strategy information table pre-stored in the MySQL database.

4. A marketing data processing method, It is characterized in that The method is applied to the second server, and includes: receiving a marketing data table, a delayed marketing identifier, all delayed marketing user identifiers, and a delayed marketing time sent by the first server, wherein the delayed marketing time is the time when the first server obtains all user orders, and all delayed marketing user identifiers are all user orders corresponding to the delayed marketing identifiers obtained by the first server at a preset time interval, and treating all user orders that do not contain target product ordering information as delayed marketing orders, and determining the time based on all delayed marketing orders; A delayed marketing data table is screened out from a pre-stored marketing data table according to the delayed marketing time and the delayed marketing identifier, at least one target user data is determined according to the user identifier contained in all user data in the delayed marketing data table and all delayed marketing user identifiers, and a target data table is generated according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier; Sending the target data table to the first server, so that the first server obtains the target strategy information corresponding to each target marketing strategy identifier in the target data table, and transmits the target strategy information to the terminal corresponding to the target user identifier; The marketing data table is obtained by the first server based on the following process: In response to the received marketing instruction, obtaining the to-be-marketed identifier contained in the marketing instruction and the to-be-marketed strategy identifier corresponding to each to-be-marketed user identifier; Acquire the pending marketing strategy information corresponding to each pending marketing strategy identifier, and transmit the pending marketing strategy information to the terminal corresponding to the pending marketing user identifier; Determine the delay time corresponding to the pending marketing identifier, use the time for transmitting the pending marketing strategy information as the marketing time, and use the sum of the delay time and the marketing time as the scheduled marketing time, and generate a marketing data table based on the scheduled marketing time, the pending marketing identifier and all pending marketing user data.

5. The method according to claim 4, It is characterized in that The generating of the target data table according to all target user data includes: A distributed file system file is obtained according to all target user data, and a target data table is obtained according to the distributed file system file.

6. The method according to claim 4 or 5, It is characterized in that The marketing data table is an HBase data table.

7. A marketing data processing device, It is characterized in that Applied to the first server, comprising: A response module, configured to, in response to a received marketing instruction, obtain a to-be-marketed identifier and at least one to-be-marketed user data contained in the marketing instruction, wherein the to-be-marketed user data includes a to-be-marketed user identifier and a to-be-marketed strategy identifier corresponding to each to-be-marketed user identifier; A first acquisition module is used to acquire the pending marketing strategy information corresponding to each pending marketing strategy identifier, and transmit the pending marketing strategy information to the terminal corresponding to the pending marketing user identifier; a determination module, for determining a delay time corresponding to the pending marketing identifier, taking the time for transmitting the pending marketing strategy information as the marketing time, and taking the sum of the delay time and the marketing time as the scheduled marketing time, generating a marketing data table according to the scheduled marketing time, the pending marketing identifier and all pending marketing user data, and sending the marketing data table to the second server for storage; The second acquisition module is used to acquire all user orders corresponding to the delayed marketing identifier at a preset time interval, regard all user orders that do not contain target product ordering information as delayed marketing orders, and acquire delayed marketing user identifiers corresponding to all delayed marketing orders; A sending module, used to use the time for obtaining all user orders as the delayed marketing time, and send the delayed marketing identifier, all delayed marketing user identifiers and the delayed marketing time to a second server, so that the second server filters out a delayed marketing data table from a pre-stored marketing data table according to the delayed marketing time and the delayed marketing identifier, determines at least one target user data according to the user identifiers contained in all user data in the delayed marketing data table and all delayed marketing user identifiers, and generates a target data table according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier; The receiving module is used to receive the target data table returned by the second server, obtain the target policy information corresponding to each target marketing policy identifier in the target data table, and transmit the target policy information to the terminal corresponding to the target user identifier.

8. A marketing data processing device, It is characterized in that Applied to the second server, including: A receiving module, configured to receive a marketing data table, a delayed marketing identifier, all delayed marketing user identifiers, and a delayed marketing time sent by a first server, wherein the delayed marketing time is the time when the first server obtains all user orders, and all delayed marketing user identifiers are all user orders corresponding to the delayed marketing identifiers obtained by the first server at a preset time interval, and orders among all user orders that do not contain target product ordering information are regarded as delayed marketing orders, and are determined based on all delayed marketing orders; A screening module, used to screen out a delayed marketing data table from a pre-stored marketing data table according to the delayed marketing time and the delayed marketing identifier, determine at least one target user data according to the user identifier contained in all user data in the delayed marketing data table and all delayed marketing user identifiers, and generate a target data table according to all target user data, wherein the scheduled marketing time contained in the delayed marketing data table is consistent with the delayed marketing time, the marketing identifier contained in the delayed marketing data table is consistent with the delayed marketing identifier, and each target user data contains a target user identifier and a corresponding target marketing strategy identifier; A sending module, configured to send the target data table to the first server, so that the first server obtains the target strategy information corresponding to each target marketing strategy identifier in the target data table, and transmits the target strategy information to the terminal corresponding to the target user identifier; The marketing data table is obtained by the first server based on the following process: In response to the received marketing instruction, obtaining the to-be-marketed identifier contained in the marketing instruction and the to-be-marketed strategy identifier corresponding to each to-be-marketed user identifier; Acquire the pending marketing strategy information corresponding to each pending marketing strategy identifier, and transmit the pending marketing strategy information to the terminal corresponding to the pending marketing user identifier; Determine the delay time corresponding to the pending marketing identifier, use the time for transmitting the pending marketing strategy information as the marketing time, and use the sum of the delay time and the marketing time as the scheduled marketing time, and generate a marketing data table based on the scheduled marketing time, the pending marketing identifier and all pending marketing user data.

9. A server, It is characterized in that include: at least one processor and memory; The memory stores computer-executable instructions; The at least one processor executes the computer-executable instructions stored in the memory, so that the at least one processor performs the marketing data processing method according to any one of claims 1 to 3.

10. A server, It is characterized in that include: at least one processor and memory; The memory stores computer-executable instructions; The at least one processor executes the computer-executable instructions stored in the memory, so that the at least one processor performs the marketing data processing method according to any one of claims 4 to 6.

11. A computer storage medium, It is characterized in that The computer storage medium stores computer execution instructions, and when the processor executes the computer execution instructions, the marketing data processing method according to any one of claims 1 to 3 is implemented.