Data processing method, device and equipment

Abstract

The invention provides a data processing method, device and equipment. The method comprises the following steps: acquiring real-time basic data of advertisement data from a first data system; acquiring real-time efficiency index data of the advertisement data from a second data system; updating basic data of target advertisement putting data according to the real-time basic data; efficiency index key value pair data are generated according to the real-time efficiency index data, and one efficiency index key corresponds to at least one efficiency index value; storing the efficiency index key value pair data in a target database; when it is monitored that the efficiency index key value pair data is changed through a monitoring event of the target database, generating an efficiency index data updating instruction; and updating the efficiency index data of the target advertisement putting data according to the efficiency index data updating instruction. According to the scheme, the real-time performance of advertisement putting efficiency index data updating can be improved, and computing resources and database input and output resources are saved.

Description

Technical Field

[0001] The present invention relates to the field of computer information technology, and in particular to a data processing method, device and equipment. Background Art

[0002] In the business logic of the advertising system, there are a lot of data matching problems: for example, a WeChat Moments advertisement will generate a lot of click, display, consumption data, consultation data, and delivery result data. Among them, the advertising API (interface) of the advertising platform will only provide basic data such as advertising display, click consumption, etc., while efficiency indicator data such as consultation data and delivery data need to be obtained from a third-party CRM (customer relationship management system) or e-commerce API (interface). Efficiency indicator data and basic advertising data are matched to form a complete set of advertising delivery data reports.

[0003] In the prior art, these advertising data reports need to be refreshed regularly. Data updates are updated in a polling manner, which is also a saturation update. Regardless of whether the data has changed or not, as long as the data is pulled, it needs to be updated; even if the data has not changed, the updated database SQL (Structured Query Language) must be executed. This update method will waste a lot of computing resources, slow efficiency and affect the performance of the entire system. Summary of the invention

[0004] The technical problem to be solved by the present invention is to provide a data processing method, device and equipment, which can improve the real-time updating of advertising delivery efficiency indicator data and save computing resources and database IO resources.

[0005] In order to solve the above technical problems, the technical solution of the present invention is as follows:

[0006] A data processing method, the method comprising:

[0007] Acquire real-time basic data of advertisement data from the first data system;

[0008] Acquire real-time efficiency index data of the advertisement data from a second data system;

[0009] Based on the real-time basic data, the basic data of the target advertisement delivery data is updated;

[0010] Generate efficiency indicator key-value pair data according to the real-time efficiency indicator data, wherein one efficiency indicator key corresponds to at least one efficiency indicator value;

[0011] Storing the efficiency index key-value pair data in a target database;

[0012] When a change in the efficiency index key-value pair data is detected through a monitoring event of the target database, an efficiency index data update instruction is generated;

[0013] According to the efficiency indicator data update instruction, the efficiency indicator data of the target advertisement delivery data is updated.

[0014] Optionally, obtaining real-time basic data of the advertisement data from the first data system includes:

[0015] Acquire advertisement report data of advertisement data from the first data system;

[0016] Real-time basic data is obtained from the advertisement report data; the real-time basic data includes at least one of advertisement identification, report date, data display, advertisement click, and consumption data; the advertisement identification and the report date have a corresponding index value.

[0017] Optionally, acquiring real-time efficiency index data of the advertisement data from the second data system includes:

[0018] Acquire multiple real-time efficiency indicator data of multiple advertisement data from the second data system; the real-time efficiency indicator data include: at least one real-time efficiency indicator of lead data, order data, conversation data, and effective conversation data generated when the advertisement is delivered on the advertisement platform.

[0019] Optionally, generating efficiency indicator key-value pair data according to the real-time efficiency indicator data includes:

[0020] Acquire the creation time of at least one real-time efficiency indicator in the real-time efficiency indicator data, the advertisement identifier generating the efficiency indicator, and the real-time efficiency indicator identifier;

[0021] The creation time and the advertisement identifier are used as the key in the efficiency indicator key-value pair data, and the real-time efficiency indicator identifier is used as the value in the efficiency indicator key-value pair data to obtain the efficiency indicator key-value pair data.

[0022] Optionally, storing the efficiency indicator key-value pair data in a target database includes:

[0023] The data with the same key in the efficiency index key-value pair data is stored as a set, and multiple values ​​corresponding to the key are stored as elements in the set, so as to obtain multiple sets;

[0024] The plurality of collections are stored in a target database.

[0025] Optionally, monitoring the change of the efficiency indicator key-value pair data through the monitoring event of the target database includes:

[0026] The monitoring event of the target database is called, and when it is detected that the length of the set has changed, an efficiency indicator data update instruction is generated.

[0027] Optionally, updating the efficiency indicator data of the target advertisement delivery data according to the efficiency indicator data update instruction includes:

[0028] According to the efficiency indicator data update instruction, obtaining the data length of the target set in the target database;

[0029] The efficiency indicator data of the target advertisement delivery data is updated to the data length of the target set.

[0030] The present invention also provides a data processing device, comprising:

[0031] An acquisition module, used to acquire real-time basic data of the advertisement data from the first data system; and acquire real-time efficiency index data of the advertisement data from the second data system;

[0032] A processing module is used to update the basic data of the target advertising delivery data according to the real-time basic data; generate efficiency indicator key-value pair data according to the real-time efficiency indicator data, wherein one efficiency indicator key corresponds to at least one efficiency indicator value; store the efficiency indicator key-value pair data in a target database; generate an efficiency indicator data update instruction when a change in the efficiency indicator key-value pair data is detected through a monitoring event of the target database; and update the efficiency indicator data of the target advertising delivery data according to the efficiency indicator data update instruction.

[0033] The present invention also provides a computing device, comprising: a processor and a memory storing a computer program, wherein when the computer program is run by the processor, the method as described above is executed.

[0034] The present invention also provides a computer-readable storage medium storing instructions, which, when executed on a computer, enable the computer to execute the above method.

[0035] The above solution of the present invention includes at least the following beneficial effects:

[0036] The above scheme of the present invention obtains the real-time basic data of the advertisement data from the first data system; obtains the real-time efficiency index data of the advertisement data from the second data system; updates the basic data of the target advertisement delivery data according to the real-time basic data; generates efficiency index key-value pair data according to the real-time efficiency index data, wherein one efficiency index key corresponds to at least one efficiency index value; stores the efficiency index key-value pair data in the target database; generates an efficiency index data update instruction when a change in the efficiency index key-value pair data is detected through the monitoring event of the target database; and updates the efficiency index data of the target advertisement delivery data according to the efficiency index data update instruction. The real-time performance of the advertisement delivery efficiency index data update can be improved, and computing resources and database IO resources can be saved. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] Figure 1 is a flow chart of a data processing method according to an embodiment of the present invention;

[0038] Figure 2 is a schematic diagram of updating basic data of target advertisement delivery data according to an embodiment of the present invention;

[0039] Figure 3 is a schematic diagram of updating efficiency indicator data of target advertisement delivery data according to an embodiment of the present invention;

[0040] Figure 4 It is a schematic diagram of the structure of a data processing device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0041] The exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although the exemplary embodiments of the present invention are shown in the accompanying drawings, it should be understood that the present invention can be implemented in various forms and should not be limited by the embodiments set forth herein. On the contrary, these embodiments are provided in order to enable a more thorough understanding of the present invention and to enable the scope of the present invention to be fully communicated to those skilled in the art.

[0042] In order to better explain the present invention, the present invention first briefly introduces the technical background of the advertising field. Advertisements are divided into lead-type advertisements and e-commerce advertisements. The lead-type advertisements refer to a type of advertisement that efficiently obtains potential user leads through a one-party lead form or a three-party landing page. The user leads generally refer to personal information such as the user's contact information. That is, after the user clicks on the advertisement, the landing page guides the user to actively leave personal contact information, which means that a user lead has been obtained for the advertiser. The e-commerce advertisement means that after the user clicks on the advertisement, the landing page is the product page of each major e-commerce platform, and the user is guided to place an order through various product introductions.

[0043] In advertising, advertisers will generally pay attention to advertising data reports, which include basic advertising data and advertising efficiency index data. The basic advertising data includes data such as display, clicks and consumption generated by advertising. The consumption refers to the cost of placing the advertisement. The advertising efficiency index data refers to data for evaluating the effectiveness of advertising after the advertisement is placed. The efficiency indicators include: number of conversations, number of effective conversations, number of leads, number of orders, etc. The efficiency index needs to be obtained by obtaining real-time efficiency index data from the advertiser's business system, and then matching the obtained real-time efficiency index data with the corresponding advertisement. The real-time efficiency index data obtained from the advertiser's business system refers to customer leads, orders, etc. obtained by the advertiser after placing multiple advertisements.

[0044] Taking lead ads as an example, the delivery link of a lead ad is:

[0045] 1. Advertisements are displayed on the advertising platform;

[0046] 2. After the user clicks on the ad, the advertiser's marketing landing page is opened;

[0047] 3. If users are interested in the service content displayed on the landing page, they will leave their contact information;

[0048] 4. The user finally closes the landing page, and the ad delivery process ends.

[0049] The data generated in this process include:

[0050] 1. Basic advertising data (impressions, clicks, and consumption);

[0051] 2. Real-time advertising efficiency indicator data (the contact information left by the user is entered into the advertiser’s CRM system, CRM, Customer Relationship Management customer relationship management system).

[0052] In the advertiser's CRM system, the real-time efficiency indicator data includes: the user's IP, device, location, contact information, and the URL (Uniform Resource Locator) of the ad landing page from which this information comes. At the same time, the URL will contain the ad ID (identification) parameter assigned by the ad platform. For example, the ad landing page URL can be: www.lanjin.com / index.html? ad_id=3621518326276 , where ad_id is the advertisement ID assigned by the advertising platform. The advertisement ID can be used to identify which advertisement the user information (clues) stored in the advertiser's system comes from, thereby calculating the efficiency index of each advertisement. Figure 1 As shown, an embodiment of the present invention provides a data processing method, the method comprising:

[0053] Step 11, obtaining real-time basic data of the advertisement data from a first data system; here, the first data system refers to an advertisement platform system, that is, a system of a platform where the advertisement is placed;

[0054] Step 12, obtaining real-time efficiency index data of the advertisement data from the second data system;

[0055] Here, the second data system refers to the business system of the advertiser who places the advertisement, and the business system of the advertiser may be an e-commerce platform system or a third-party CRM (customer relationship management system);

[0056] Step 13, updating the basic data of the target advertisement delivery data according to the real-time basic data;

[0057] Step 14, generating efficiency index key-value pair data according to the real-time efficiency index data, wherein one efficiency index key corresponds to at least one efficiency index value;

[0058] Step 15, storing the efficiency index key-value pair data in a target database; here, the target database may be a database based on a Key-Value data structure;

[0059] Step 16, when a change in the efficiency index key-value pair data is detected through the monitoring event of the target database, an efficiency index data update instruction is generated;

[0060] Step 17: updating the efficiency indicator data of the target advertisement delivery data according to the efficiency indicator data update instruction.

[0061] In this embodiment, the basic data of the target advertisement delivery data is updated based on the real-time basic data of the target advertisement pulled from the advertisement platform system. A key-value pair is generated based on the real-time efficiency index data pulled from the advertiser platform, and the real-time efficiency index data is stored in the target database in the form of a key-value pair. By monitoring the occurrence of new write events in the target database, an instruction to update the efficiency index data is obtained. This avoids the drawback of the prior art that even if there are no new clues, the database needs to be queried. At the same time, in the present invention, when the efficiency index is updated after the update instruction is obtained, it is obtained by obtaining the set length of the key-value pairs that have changed in the database, thereby avoiding the drawback of full fuzzy matching in the prior art and greatly reducing the amount of calculation.

[0062] In an optional embodiment of the present invention, step 11 may include:

[0063] Step 111, acquiring advertisement report data of advertisement data from the first data system;

[0064] Step 112, obtaining real-time basic data from the advertising report data; the real-time basic data includes: at least one of advertising identification, report date, data display, advertising clicks, and consumption data; the advertising identification and the report date have a corresponding index value.

[0065] In this embodiment, Figure 2 As shown, the advertising platform API (application programming interface) is connected to update the advertising report. The complete advertising level is advertising, creative, and material. Taking the advertising level as an example, it is first necessary to connect to the daily report of the advertising level, and obtain the advertising daily report data after requesting the corresponding interface. The fields include: 1. Advertising ID; 2. Report date; 3. Impression; 4. Click; 5. Consumption.

[0066] These fields can be combined to determine the basic data of an advertisement on a certain day, and the real-time basic data is stored in the database. Generally speaking, a joint index needs to be established for the advertisement ID and the report date to improve the query efficiency. Since only the basic data has been obtained and the efficiency data has not been matched yet, all the efficiency data are set to 0 at this time.

[0067] like Figure 3 As shown, in an optional embodiment of the present invention, step 12 may include:

[0068] Step 121, obtaining multiple real-time efficiency indicator data of multiple advertising data from the second data system; the real-time efficiency indicator data includes: at least one real-time efficiency indicator of lead data, order data, conversation data, and effective conversation data generated when the advertisement is delivered on the advertising platform.

[0069] In this embodiment, the advertiser system will store clues, orders, or conversation information left by users after clicking on advertisements. Taking clue data as an example, the advertiser system stores the clue (user information, such as mobile phone number), the creation time of the clue, the identifier of the clue, and the landing page URL of the clue. Since the landing page URL corresponds to the advertisement ID of the landing page advertisement, by querying the clue data, you can know which advertisement the user browsed and left the clue. The creation time can be used to know which day the clue came from.

[0070] In an optional embodiment of the present invention, step 14 may include:

[0071] Step 141, obtaining the creation time of at least one real-time efficiency indicator in the real-time efficiency indicator data, the advertisement identifier generating the efficiency indicator, and the real-time efficiency indicator identifier;

[0072] Step 142, the creation time and the advertisement identifier are combined into a key in the efficiency indicator key-value pair data, and the real-time efficiency indicator identifier is used as a value in the efficiency indicator key-value pair data to obtain the efficiency indicator key-value pair data.

[0073] In this embodiment, the creation time and advertising identifier of the real-time efficiency indicator in the real-time efficiency indicator data are spliced ​​into a string, and the string is used as the key. The real-time efficiency indicator identifier is used as the value. The key-value pair data is obtained. Taking the clue quantity efficiency indicator as an example, assume that the creation time of a clue is a certain year, month, and day; the landing page URL (Uniform Resource Locator) of the clue source is www.lanjin.com / index.html? wx_aid=3621518326276, where the advertising identifier is 3621518326276; then the creation time and advertising identifier are spliced ​​into a string of a certain year, month, and day: 3621518326276. The string is used as the key, and the clue identifier of the clue is used as the value. The clue is converted into a key-value pair key-value and stored in the target database.

[0074] In an optional embodiment of the present invention, step 15 may include:

[0075] Step 151, storing the data with the same key in the efficiency index key-value pair data as a set, and storing multiple values ​​corresponding to the key as elements in the set, to obtain multiple sets;

[0076] Step 152: store the multiple sets in a target database.

[0077] In this embodiment, when the keys of multiple efficiency indicator key-value pairs are the same, that is, these real-time efficiency indicator data are generated by the same advertisement on the same day, the set type is used to store these key-value pairs. After storage, there are multiple values ​​in a set, and one value corresponds to a lead, or an order, etc. The key of each value in a set is the same. The number of values ​​stored in each set (i.e., the set length) represents how many efficiency indicators the advertisement corresponding to the key has obtained in a day.

[0078] In an optional embodiment of the present invention, step 16 may include:

[0079] Step 161 , calling the monitoring event of the target database, and generating an efficiency indicator data update instruction when detecting that the length of the set has changed.

[0080] In this embodiment, the service of the key monitoring strategy is started to monitor the key updates of the set type in the target database. When the sadd (add one or more member elements to a set) command is used to add a value to a key, the service of the key monitoring strategy has obtained the action of adding a value to the set. If the added value is a duplicate, the monitoring will not respond because the set length has not changed; if the added value is new, the set length is +1, and the monitoring service will be triggered. After capturing this event, it means that the number of efficiency indicators of the advertisement on that date has changed, and the update SQL (Structured Query Language) can be executed in the database.

[0081] In an optional embodiment of the present invention, step 17 may include:

[0082] Step 171, obtaining the data length of the target set in the target database according to the efficiency indicator data update instruction;

[0083] Step 172: Update the efficiency indicator data of the target advertisement delivery data to the data length of the target set.

[0084] In this embodiment, when the monitoring service is triggered, it means that the value quantity of the key that triggers the monitoring service has changed. The length of the set of the key is obtained, and the set length value is the efficiency index data value of the target advertisement delivery data.

[0085] The implementation process of the above method is further described below with a specific embodiment:

[0086] Example 1: Taking the efficiency index of clue quantity as an example

[0087] 1. First, incrementally pull the real-time efficiency indicator data from the third-party CRM system API and store it in your own data table. There are two important fields in the real-time efficiency indicator data: 1. Creation time 2. Landing page URL. The creation time is used to match the date of the advertisement. The lead creation time can tell which day the lead came from. The landing page URL field is used to match specific advertisements. The advertising platform first displays the advertisement. After the user clicks on the advertisement and jumps to the specific landing page, he leaves a clue (mobile phone number). Therefore, the landing page URL represents the landing page from which the user left the clue. Since the landing page is opened from the advertising media, the advertising platform will attach parameters such as the advertising ID to the end of the URL for developers to parse.

[0088] 2. It is learned that the clue comes from the advertisement with ID 3621518326276. Assuming that the clue was created on a certain date, the clue belongs to the advertisement with ID 3621518326276 on a certain date. At this point, the clue can be attributed to a specific advertising report.

[0089] 3. Concatenate the date and ad ID into a string of year / month / day:3621518326276, use this string as the key and the lead ID as the value, and store them directly in the target database.

[0090] 4. The key monitoring strategy service has been started to monitor key updates. The clues are stored in the target database using the set data type. The set type can automatically remove duplicate clue IDs to ensure that each clue ID in the set is unique. Therefore, as long as the clue set length of an advertisement on a certain date is obtained, the number of clues for the advertisement on that date can be known. Use the sadd command to add the clue ID to the key.

[0091] 5. The service has obtained the action of adding values ​​to the set. If the lead ID is duplicated, the listener will not respond because the set length has not changed. If the lead ID is newly added, the set length is +1, and the listener service will be triggered. Capturing this event means that the number of leads for the advertisement on that date has changed. Then, you can execute an update SQL in the database to change the number of leads in the data report to the latest number of leads, and the process ends.

[0092] In the above method embodiment of the present invention, monitoring events is a mechanism for monitoring and capturing events when keys change. Specifically, the keyspace notification function can be used to issue notifications when the key of the efficiency indicator key value changes, and monitor key changes in real time, such as new additions, modifications, deletions, and other events. To use keyspace notifications, the following parameters can be configured in the target database: set in the configuration file of the target database: notify-keyspace-events parameter, for example: notify-keyspace-events Ex, where Ex means subscribing to key expiration events (E) and key deletion events (x). Available event types include: K: all keyspace events (set, del, etc.); E: expired events (expired); x: delete events (del); g: general commands (get, exists, etc.); $: string keys (set, append, etc.); further, specific channels can be subscribed to through the SUBSCRIBE or PSUBSCRIBE command of the target database to monitor events, for example: PSUBSCRIBE__keyevent@0__:expired; this command is used to monitor expiration events of all keys in the database. In this way, the efficiency indicator data can be updated in real time, and the publish / subscribe mechanism is used without the need for additional code logic. The data update SQL is triggered only when there is updated data, which greatly optimizes the performance overhead of data calculation.

[0093] The above-mentioned embodiment of the present invention writes a new clue into the target database, and then triggers the advertising report update SQL, directly omitting the fuzzy matching step, leaving only the more time-consuming step of updating the advertising report SQL. Under the same data volume, only the step of pulling the basic advertising report requires polling, and a round of report data can be updated within ten minutes, which greatly optimizes the overall report performance.

[0094] like Figure 4 As shown, an embodiment of the present invention further provides a data processing device 40, comprising:

[0095] The acquisition module 41 is used to acquire the real-time basic data of the advertisement data from the first data system; and acquire the real-time efficiency index data of the advertisement data from the second data system;

[0096] The processing module 42 is used to update the basic data of the target advertising delivery data according to the real-time basic data; generate efficiency indicator key-value pair data according to the real-time efficiency indicator data, in which one efficiency indicator key corresponds to at least one efficiency indicator value; store the efficiency indicator key-value pair data in the target database; generate an efficiency indicator data update instruction when changes to the efficiency indicator key-value pair data are detected through the monitoring events of the target database; and update the efficiency indicator data of the target advertising delivery data according to the efficiency indicator data update instruction.

[0097] Optionally, obtaining real-time basic data of the advertisement data from the first data system includes:

[0098] Acquire advertisement report data of advertisement data from the first data system;

[0099] Real-time basic data is obtained from the advertisement report data; the real-time basic data includes at least one of advertisement identification, report date, data display, advertisement click, and consumption data; the advertisement identification and the report date have a corresponding index value.

[0100] Optionally, acquiring real-time efficiency index data of the advertisement data from the second data system includes:

[0101] Acquire multiple real-time efficiency indicator data of multiple advertisement data from the second data system; the real-time efficiency indicator data include: at least one real-time efficiency indicator of lead data, order data, conversation data, and effective conversation data generated when the advertisement is delivered on the advertisement platform.

[0102] Optionally, generating efficiency indicator key-value pair data according to the real-time efficiency indicator data includes:

[0103] Acquire the creation time of at least one real-time efficiency indicator in the real-time efficiency indicator data, the advertisement identifier generating the efficiency indicator, and the real-time efficiency indicator identifier;

[0104] The creation time and the advertisement identifier are used as the key in the efficiency indicator key-value pair data, and the real-time efficiency indicator identifier is used as the value in the efficiency indicator key-value pair data to obtain the efficiency indicator key-value pair data.

[0105] Optionally, storing the efficiency indicator key-value pair data in a target database includes:

[0106] The data with the same key in the efficiency index key-value pair data is stored as a set, and multiple values ​​corresponding to the key are stored as elements in the set, so as to obtain multiple sets;

[0107] The plurality of collections are stored in a target database.

[0108] Optionally, monitoring the change of the efficiency indicator key-value pair data through the monitoring event of the target database includes:

[0109] The monitoring event of the target database is called, and when it is detected that the length of the set has changed, an efficiency indicator data update instruction is generated.

[0110] Optionally, updating the efficiency indicator data of the target advertisement delivery data according to the efficiency indicator data update instruction includes:

[0111] According to the efficiency indicator data update instruction, obtaining the data length of the target set in the target database;

[0112] The efficiency indicator data of the target advertisement delivery data is updated to the data length of the target set.

[0113] It should be noted that the device is a device corresponding to the above method, and all implementation methods in the above method embodiments are applicable to the embodiments of the device and can achieve the same technical effects.

[0114] The embodiment of the present invention further provides a computing device, comprising: a processor, a memory storing a computer program, wherein when the computer program is executed by the processor, the method described above is executed. All implementations in the above method embodiment are applicable to this embodiment and can achieve the same technical effect.

[0115] The embodiment of the present invention further provides a computer-readable storage medium storing instructions, which, when executed on a computer, enable the computer to execute the above method. All implementations in the above method embodiment are applicable to this embodiment and can achieve the same technical effect.

[0116] Those skilled in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0117] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0118] In the 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 units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components 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 through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0119] The units described as separate components may or may not be physically separated, and the components shown as units 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 units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0120] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0121] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, server, or network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: various media that can store program codes, such as USB flash drives, mobile hard disks, ROM, RAM, magnetic disks, or optical disks.

[0122] In addition, it should be noted that in the apparatus and method of the present invention, it is obvious that each component or each step can be decomposed and / or recombined. These decompositions and / or recombinations should be regarded as equivalent schemes of the present invention. Moreover, the steps of performing the above-mentioned series of processing can naturally be performed in chronological order according to the order of description, but it is not necessary to perform them in chronological order, and some steps can be performed in parallel or independently of each other. For those of ordinary skill in the art, it is understood that all or any steps or components of the method and apparatus of the present invention can be implemented in any computing device (including processors, storage media, etc.) or a network of computing devices in hardware, firmware, software or a combination thereof, which can be achieved by those of ordinary skill in the art using their basic programming skills after reading the description of the present invention.

[0123] Therefore, the purpose of the present invention can also be achieved by running a program or a group of programs on any computing device. The computing device can be a well-known general device. Therefore, the purpose of the present invention can also be achieved by simply providing a program product containing a program code that implements the method or device. That is to say, such a program product also constitutes the present invention, and the storage medium storing such a program product also constitutes the present invention. Obviously, the storage medium can be any well-known storage medium or any storage medium developed in the future. It should also be pointed out that in the device and method of the present invention, it is obvious that each component or each step can be decomposed and / or recombined. These decompositions and / or recombinations should be regarded as equivalent schemes of the present invention. In addition, the steps of performing the above-mentioned series of processing can naturally be performed in chronological order according to the order of description, but it is not necessary to perform them in chronological order. Some steps can be performed in parallel or independently of each other.

[0124] The above is a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A data processing method, characterized in that: include: Acquire real-time basic data of advertisement data from the first data system; Acquire real-time efficiency index data of the advertisement data from a second data system; Based on the real-time basic data, the basic data of the target advertisement delivery data is updated; Generate efficiency indicator key-value pair data according to the real-time efficiency indicator data, wherein one efficiency indicator key corresponds to at least one efficiency indicator value; Storing the efficiency index key-value pair data in a target database; When a change in the efficiency index key-value pair data is detected through a monitoring event of the target database, an efficiency index data update instruction is generated; According to the efficiency indicator data update instruction, the efficiency indicator data of the target advertisement delivery data is updated.

2. The data processing method according to claim 1, characterized in that: Obtain real-time basic data of advertising data from the first data system, including: Acquire advertisement report data of advertisement data from the first data system; Real-time basic data is obtained from the advertisement report data; the real-time basic data includes at least one of advertisement identification, report date, data display, advertisement click, and consumption data; the advertisement identification and the report date have a corresponding index value.

3. The data processing method according to claim 1, characterized in that: Acquiring real-time efficiency index data of the advertisement data from the second data system includes: Acquire multiple real-time efficiency indicator data of multiple advertisement data from the second data system; the real-time efficiency indicator data include: at least one real-time efficiency indicator of lead data, order data, conversation data, and effective conversation data generated when the advertisement is delivered on the advertisement platform.

4. The data processing method according to claim 3, characterized in that: Generate efficiency index key-value pair data according to the real-time efficiency index data, including: Acquire the creation time of at least one real-time efficiency indicator in the real-time efficiency indicator data, the advertisement identifier generating the efficiency indicator, and the real-time efficiency indicator identifier; The creation time and the advertisement identifier are used as the key in the efficiency indicator key-value pair data, and the real-time efficiency indicator identifier is used as the value in the efficiency indicator key-value pair data to obtain the efficiency indicator key-value pair data.

5. The data processing method according to claim 4, characterized in that: Storing the efficiency index key-value pair data in the target database includes: The data with the same key in the efficiency index key-value pair data is stored as a set, and multiple values ​​corresponding to the key are stored as elements in the set, so as to obtain multiple sets; The plurality of collections are stored in a target database.

6. The data processing method according to claim 5, characterized in that: Monitoring changes in the efficiency indicator key-value pair data through monitoring events of the target database includes: The monitoring event of the target database is called, and when it is detected that the length of the set has changed, an efficiency indicator data update instruction is generated.

7. The data processing method according to claim 1, characterized in that: According to the efficiency indicator data update instruction, the efficiency indicator data of the target advertisement delivery data is updated, including: According to the efficiency indicator data update instruction, obtaining the data length of the target set in the target database; The efficiency indicator data of the target advertisement delivery data is updated to the data length of the target set.

8. A data processing device, characterized in that: include: An acquisition module, used for acquiring real-time basic data of advertisement data from the first data system; Acquire real-time efficiency index data of the advertisement data from a second data system; A processing module is used to update the basic data of the target advertising delivery data according to the real-time basic data; generate efficiency indicator key-value pair data according to the real-time efficiency indicator data, wherein one efficiency indicator key corresponds to at least one efficiency indicator value; store the efficiency indicator key-value pair data in a target database; generate an efficiency indicator data update instruction when a change in the efficiency indicator key-value pair data is detected through a monitoring event of the target database; and update the efficiency indicator data of the target advertising delivery data according to the efficiency indicator data update instruction.

9. A computing device, characterized in that include: A processor and a memory storing a computer program, wherein when the computer program is executed by the processor, the method according to any one of claims 1 to 7 is performed.

10. A computer-readable storage medium, characterized in that: Instructions are stored, and when the instructions are executed on a computer, the computer is caused to execute the method according to any one of claims 1 to 7.

Images