Method, apparatus, computer-readable medium, and electronic device for automatically placing advertisements
By splitting the strategy by source channel and using Redis queue processing, the repeated execution and speed limit rules of advertising delivery in e-commerce platforms are solved, and timed distributed parallel execution of multiple merchants is realized, which improves delivery speed and efficiency.
Patent Information
- Application Number
- CN202111323836.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-11-10
- Publication Date
- 2025-07-11
- Estimated Expiration
- 2041-11-10
AI Technical Summary
In e-commerce platforms, when users need to place advertisements on multiple platforms, there are problems such as long execution of a single strategy, repeated execution, and different speed limit rules on different platforms, resulting in inefficient delivery.
By splitting the strategy into a sub-strategy by source channel, a detailed description of to be executed is generated, and whether there is a detailed description of to be executed in the list of the same Listings is used to integrate data concurrently to create an advertising campaign entity, which solves the problems of repeated execution and speed limit rules, and realizes timed distributed parallel execution by multiple merchants.
It improves the speed and efficiency of advertising delivery, avoids duplicate or missed execution, adapts to the speed limit rules of different platforms, and improves the platform upload efficiency.
Smart Images

Figure CN114022210B_ABST
Abstract
Description
Background Art
[0002] In-site advertising is a way to drive traffic on e-commerce platforms. If users want to obtain a certain amount of exposure, they need to place in-site advertisements. Moreover, the same user may have different stores on different e-commerce platforms. When placing advertisements, it is necessary to ensure simultaneous distribution across multiple platforms and multiple stores. Moreover, the same store may need to place advertisements with different strategies, and there may be problems such as a single strategy being executed for too long or being executed repeatedly. Different platforms also have different speed limit rules. Therefore, an automatic advertising placement method that can solve the above problems is needed. Summary of the Invention
[0003] The present invention provides an automatic advertising placement method, device, computer-readable medium, and electronic device, aiming to solve the technical problems mentioned in the background art.
[0004] The present invention first provides an automatic advertising placement method, including the following steps:
[0005] Split the to-be-executed strategy into sub-strategies according to the source channels and load them into the to-be-processed sub-strategy Redis queue;
[0006] Decompose a sub-strategy from the to-be-processed sub-strategy Redis queue, generate to-be-executed details according to the sub-strategy, and determine whether there are to-be-executed details with the same Listing in the automatic advertising queue table;
[0007] If there are no to-be-executed details with the same Listing in the automatic advertising queue table, insert the to-be-executed details into the automatic advertising queue table;
[0008] If there are to-be-executed details with the same Listing in the automatic advertising queue table, the insertion fails and is recorded;
[0009] Integrate the queue IDs corresponding to a preset number of the to-be-executed details into a group, and send the integrated group data to the automatic advertising Redis queue;
[0010] Read any group of the group data in the automatic advertising Redis queue;
[0011] Concurrently create advertising campaign entities according to the to-be-executed details corresponding to the group data located in the automatic advertising queue table, and push all the created advertising campaign entities to the platform.
[0012] Further, the to-be-processed sub-strategy Redis queue adopts a right-in left-out method to execute sub-strategies in sequence.
[0013] Further, the automatic advertising Redis queue adopts a method of executing group data in an unordered manner.
[0014] Further, the preset quantity is less than or equal to the number of Listing batch requests supported by the platform API.
[0015] Further, after "pushing the advertising campaign entity to the platform", the following steps are also included:
[0016] Generating status information according to the push result and saving it to the automatic advertising team list.
[0017] Further, the automatic advertising team list includes a main table and a sub-table. The main table is used to store relevant information of the details to be executed, and the sub-table is used to store the status information of the advertising campaign entity.
[0018] Further, the strategy to be executed includes a strategy for updating the rate to be executed. The strategy for creating an advertisement to be executed and the strategy for updating the rate to be executed are separately processed through a single thread. The method further includes the following steps:
[0019] Decomposing a sub-strategy from the Redis queue of sub-strategies to be processed, generating details to be executed according to the sub-strategy, and determining whether there are details to be executed with the same Listing in the automatic rate team list;
[0020] If there are no details to be executed with the same Listing in the automatic rate team list, inserting the details to be executed into the automatic rate team list;
[0021] If there are details to be executed with the same Listing in the automatic rate team list, the insertion fails and is recorded;
[0022] Integrating the queue IDs corresponding to the preset quantity of the details to be executed into a group, and sending the integrated group data to the automatic rate Redis queue;
[0023] Reading any group of the group data in the automatic rate Redis queue;
[0024] Concurrently creating rate update entities according to the details to be executed located in the automatic rate team list corresponding to the group data, and pushing all the created rate update entities to the platform.
[0025] The present invention also provides a device for automatically placing advertisements, including:
[0026] A splitting module, configured to split the strategy to be executed into sub-strategies according to the source channel and load them into the Redis queue of sub-strategies to be processed;
[0027] A judgment module, configured to decompose a sub-strategy from a Redis queue of sub-strategies to be processed, generate details to be executed according to the sub-strategy, and determine whether there are details to be executed with the same Listing in the automatic advertising queue list. If there are no details to be executed with the same Listing in the automatic advertising queue list, the first execution module is executed; if there are, the second execution module is executed;
[0028] A first execution module, configured to insert the details to be executed into the automatic advertising queue list;
[0029] A second execution module, configured to record when the insertion fails;
[0030] An integration module, configured to integrate the queue IDs corresponding to a preset number of the details to be executed into a group, and send the integrated group data to the automatic advertising Redis queue;
[0031] A reading module, configured to read a group of data from any group in the automatic advertising Redis queue;
[0032] A creation module, configured to concurrently create advertising campaign entities according to the details to be executed located in the automatic advertising queue list corresponding to the group of data, and push all the created advertising campaign entities to the platform.
[0033] The present invention also provides a computer-readable medium, on which a computer program is stored, characterized in that when the program is processed and executed, the method for automatically placing advertisements as described above is implemented.
[0034] The present invention also provides an electronic device, which includes:
[0035] One or more processors;
[0036] A storage device, configured to store one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the method for automatically placing advertisements as described above.
[0037] In the embodiments of the present disclosure, by splitting sub-strategies according to source channels, the problem of multi-merchant timed distributed parallel execution is solved; details to be executed are generated according to the sub-strategies, and it is determined whether there are details to be executed with the same Listing in the automatic rate queue list, solving the problem of a single strategy taking too long to execute and being repeatedly executed. Splitting strategies in parallel by store dimension not only solves the speed problem, but also does not result in repeated execution or missed execution.
[0038] In the embodiments of the present disclosure, advertising campaign entities are also concurrently created according to the to-be-executed details corresponding to the group of data and located in the automatic advertising team list, and the queue IDs corresponding to a preset number of the to-be-executed details are integrated into a group, which can not only solve the problem of different speed limit rules on different platforms, but also package and upload the eligible data of the same store with different strategies together to solve the problem of platform upload efficiency.
[0039] It should be understood that the above general description and subsequent detailed description are merely exemplary and explanatory, and cannot limit the present disclosure. Brief Description of the Drawings
[0040] Figure 1 is a flowchart of the steps of a method for automatically placing advertisements according to an embodiment provided by the present invention.
[0041] Figure 2 is a module diagram of a device for automatically placing advertisements according to an embodiment provided by the present invention. Detailed Embodiments
[0042] Embodiments of the present invention will be described in detail below. Examples of the embodiments are shown in the drawings, where the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the drawings are exemplary and are only used to explain the present invention and should not be construed as limiting the present invention.
[0043] Those skilled in the art can understand that unless specifically stated, the singular forms "a", "an", "the" and "said" used herein may also include the plural forms. It should be further understood that the terms used in the specification of the present invention, "including", mean the presence of the described features, integers, steps, operations, but do not exclude the presence or addition of one or more other features, integers, steps, operations.
[0044] Those skilled in the art of the present technology can understand that unless otherwise defined, all terms (including technical terms and scientific terms) used herein have the same meaning as the general understanding of those of ordinary skill in the art to which the present invention belongs. It should also be understood that terms such as those defined in a general dictionary should be understood to have a meaning consistent with the meaning in the context of the prior art, and will not be interpreted with an idealized or overly formal meaning unless specifically defined as here.
[0045] Please refer to Figure 1 , the present invention first provides a method for automatically placing advertisements, including the following steps:
[0046] S100: Split the to-be-executed policy into sub-policies according to the source channel and load them into the to-be-processed sub-policy Redis queue.
[0047] The system screens out products that meet the conditions of the automatic advertising policy through three services: the loading policy sub-service, the decomposition policy sub-service, and the execution push sub-service, and automatically advertises them, and submits the advertisements to the platform.
[0048] The loading policy sub-service is mainly used to determine which service to run in which time period; the policies to be executed are processed by platform, and the task scheduling system triggers the loading action, and the policies to be executed are split into sub-policies according to the source channels and loaded into the Redis queue.
[0049] S200: Decompose a sub-policy from the Redis queue of sub-policies to be processed, and generate the details to be executed according to the sub-policy, and judge whether there are details to be executed with the same Listing in the automatic advertising queue table.
[0050] Screen out the Listings that meet the conditions according to the sub-policy and save them to the queue table. Before saving the Listing to the queue table, it is necessary to judge whether there are details to be executed with the same Listing in the queue table. If not, insert the details to be executed and SADD them to Redis, otherwise insert a failure record and do not enter Redis.
[0051] S200a: If there are no details to be executed with the same Listing in the automatic advertising queue table, insert the details to be executed into the automatic advertising queue table.
[0052] S200b: If there are details to be executed with the same Listing in the automatic advertising queue table, insert fails and record it.
[0053] S300: Integrate the queue IDs corresponding to a preset number of the details to be executed into a group, and send the integrated group data to the automatic advertising Redis queue.
[0054] Take the queue IDs of a preset number of Listing dimensions (the details to be executed) as a group: the maximum value of the preset number is the number of Listing batch requests supported by the platform API. The queue ID is the value of the field Id in the table Sty_AutoCreate_Queue_Listing and the table Sty_AdjustPrice_Queue.
[0055] S400: Read any group of the group data in the automatic advertising Redis queue.
[0056] S500: Create advertising campaign entities concurrently according to the details to be executed corresponding to the group data in the automatic advertising queue table, and push all the created advertising campaign entities to the platform.
[0057] The automatic advertising strategy in this embodiment determines the number of advertising campaign entities to be created based on the total number of sites and Listings.
[0058] Preferably, since it involves the distributed push of N Listings to the platform, when creating an advertising campaign entity, a Redis lock can also be added to the automatic advertising Redis queue to prevent the repeated creation of advertising campaign entities.
[0059] In the embodiment of the present disclosure, by splitting the sub-strategy according to the source channel, the problem of multi-merchant timed distributed parallel execution is solved; according to this sub-strategy, the details to be executed are generated, and it is judged whether there are details to be executed for the same Listing in the automatic rate queue table, so as to solve the problem that a single strategy takes too long to execute and is repeatedly executed. Splitting the strategy by store dimension and running it in parallel not only solves the speed problem, but also will not be repeatedly executed or missed.
[0060] In the embodiment of the present disclosure, advertising campaign entities are also concurrently created according to the details to be executed corresponding to this set of data in the automatic advertising queue table, and the queue IDs corresponding to the preset number of details to be executed are integrated into a group. In this way, the problem of different speed limit rules on different platforms can be solved, and the data that meets the conditions for the same store under different strategies can be packaged and uploaded together to solve the problem of platform upload efficiency.
[0061] In one embodiment of the present invention, the Redis queue of the sub-strategy to be processed adopts a right-in left-out method to execute the sub-strategy in sequence.
[0062] In one embodiment of the present invention, the automatic advertising Redis queue adopts a method of executing a group of data disorderly; the Redis set is adopted for the queue of automatic advertising to be executed in this embodiment, and the in (SADD) and out (SPOP) are executed disorderly, so as to prevent the platform limit caused by centralized concurrent synchronization of a single store.
[0063] In one embodiment of the present invention, the preset number is less than or equal to the Listing batch request number supported by the platform API.
[0064] In one embodiment of the present invention, after "pushing the advertising campaign entity to the platform", it further includes:
[0065] Generating status information according to the push result and saving it to the automatic advertising queue table.
[0066] In one embodiment of the present invention, the automatic advertising queue table includes a main table and a sub-table. The main table is used to store the relevant information of the details to be executed, and the sub-table is used to store the status information of the advertising campaign entity.
[0067] In an embodiment of the present invention, the to-be-executed policy includes a to-be-executed rate update policy. The to-be-executed create advertisement policy and the to-be-executed rate update policy are separately processed through a single thread. The method further includes the following steps:
[0068] Decompose a sub-policy from the Redis queue of to-be-processed sub-policies, generate to-be-executed details according to the sub-policy, and determine whether there are to-be-executed details of the same Listing in the automatic rate queue table;
[0069] If there are no to-be-executed details of the same Listing in the automatic rate queue table, insert the to-be-executed details into the automatic rate queue table;
[0070] If there are to-be-executed details of the same Listing in the automatic rate queue table, the insertion fails and is recorded;
[0071] Integrate the queue IDs corresponding to a preset number of the to-be-executed details into a group, and send the integrated group data to the automatic rate Redis queue;
[0072] Read any group of the group data in the automatic rate Redis queue;
[0073] Concurrently create rate update entities according to the to-be-executed details located in the automatic rate queue table corresponding to the group data, and push all the created rate update entities to the platform.
[0074] The present invention also provides a computer-readable medium, on which a computer program is stored. The program, when processed and executed, implements the above method for automatically placing advertisements.
[0075] In an embodiment, the present invention provides an automatic advertisement placement device 100. The device 100 stores multiple instructions, and the instructions are adapted to be loaded and executed by a processor to implement the method for automatically placing advertisements, including:
[0076] S100: Split the to-be-executed policy into sub-policies according to the source channels and load them into the Redis queue of to-be-processed sub-policies.
[0077] S200: Decompose a sub-policy from the Redis queue of to-be-processed sub-policies, generate to-be-executed details according to the sub-policy, and determine whether there are to-be-executed details of the same Listing in the automatic advertisement queue table.
[0078] S200a: If there are no to-be-executed details of the same Listing in the automatic advertisement queue table, insert the to-be-executed details into the automatic advertisement queue table.
[0079] S200b: If there are pending execution details with the same Listing in the automatic advertisement team list, the insertion fails and is recorded.
[0080] S300: Integrate the queue IDs corresponding to a preset number of the pending execution details into a group, and send the integrated group data to the automatic advertisement Redis queue.
[0081] S400: Read any group of data from the automatic advertisement Redis queue.
[0082] S500: Create advertisement campaign entities concurrently according to the pending execution details corresponding to the group data in the automatic advertisement team list, and push all the created advertisement campaign entities to the platform.
[0083] For ease of description, the device 100 is split into a functional module architecture, as Figure 2 shown, including:
[0084] The splitting module 10 is used to split the pending execution policy into sub-policies according to the source channel and load them into the pending processing sub-policy Redis queue.
[0085] The judgment module 20 is used to decompose a sub-policy from the pending processing sub-policy Redis queue, generate pending execution details according to the sub-policy, and judge whether there are pending execution details with the same Listing in the automatic advertisement team list. If there are no pending execution details with the same Listing in the automatic advertisement team list, the first execution module is executed; if there are, the second execution module is executed.
[0086] The first execution module 30 is used to insert the pending execution details into the automatic advertisement team list.
[0087] The second execution module 40 is used to record the failure of insertion.
[0088] The integration module 50 is used to integrate the queue IDs corresponding to a preset number of the pending execution details into a group, and send the integrated group data to the automatic advertisement Redis queue.
[0089] The reading module 60 is used to read any group of data from the automatic advertisement Redis queue.
[0090] The creation module 70 is used to create advertisement campaign entities concurrently according to the pending execution details corresponding to the group data in the automatic advertisement team list, and push all the created advertisement campaign entities to the platform.
[0091] If the modules / units integrated in the electronic device 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, to implement all or part of the processes in the method for multi-opening application programs described in the above embodiments of the present invention, it can also be completed by a computer program instructing the relevant hardware. The computer program can be stored in a computer-readable storage medium. When the computer program is executed by a processor, the steps of the method for automatically placing advertisements described in the above method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in the form of source code, object code, executable file or some intermediate form, etc. The computer-readable medium can include: any entity or device capable of carrying the computer program code, recording medium, USB flash drive, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), electrical carrier signal, telecommunication signal, and software distribution medium, etc. It should be noted that the content included in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, the computer-readable medium does not include electrical carrier signals and telecommunication signals.
[0092] The present invention also provides an electronic device, which includes:
[0093] One or more processors;
[0094] A storage device for storing one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the above method for automatically placing advertisements.
[0095] In the description and claims of this application, the words "comprise / include" and the words "have / include" and their variants are used to specify the existence of the stated features, values, steps or components, but do not exclude the existence or addition of one or more other features, values, steps, components or their combinations.
[0096] Some features of the present invention are described separately in different embodiments for clarity. However, these features can also be combined and described in a single embodiment. On the contrary, some features of the present invention are described briefly in a single embodiment. However, these features can also be described separately or in any suitable combination in different embodiments.
[0097] The above has specifically described each specific embodiment of the method and device for automatically placing advertisements of the present invention. Finally, it should be noted that the above specific embodiments are only used to illustrate the technical solutions of the present invention rather than to limit them. Although the present invention has been described in detail with reference to the above specific embodiments, those of ordinary skill in the art should understand that it is still possible to modify the specific embodiments of the present invention or make equivalent replacements for some technical features, and without departing from the spirit of the technical solutions of the present invention, they should all be covered within the scope of the technical solutions claimed by the present invention.
Claims
1. A method for automatically placing advertisements, characterized in that, Including the following steps: Split the to-be-executed policy into sub-policies according to the source channels and load them into the Redis queue of to-be-processed sub-policies. The to-be-executed policy includes the to-be-executed advertising creation policy; Decompose a sub-policy from the Redis queue of to-be-processed sub-policies, generate to-be-executed details according to the sub-policy, and determine whether there are to-be-executed details of the same Listing in the automatic advertising queue table; If there are no to-be-executed details of the same Listing in the automatic advertising queue table, insert the to-be-executed details into the automatic advertising queue table; If there are to-be-executed details of the same Listing in the automatic advertising queue table, the insertion fails and is recorded; Integrate the queue IDs corresponding to a preset number of the to-be-executed details into a group, and send the integrated group data to the automatic advertising Redis queue; Read any group of the group data in the automatic advertising Redis queue; Concurrently create advertising campaign entities according to the to-be-executed details located in the automatic advertising queue table corresponding to the group data, and push all the created advertising campaign entities to the platform; After executing "pushing the advertising campaign entities to the platform", it further includes: Generate status information according to the push result and save it to the automatic advertising queue table; The automatic advertising queue table includes a main table and a sub-table. The main table is used to store the relevant information of the to-be-executed details, and the sub-table is used to store the status information of the advertising campaign entities; The to-be-executed policy includes the to-be-executed rate update policy. Separate the to-be-executed advertising creation policy and the to-be-executed rate update policy for single-threaded processing. The method further includes the following steps: Decompose a sub-policy from the Redis queue of to-be-processed sub-policies, generate to-be-executed details according to the sub-policy, and determine whether there are to-be-executed details of the same Listing in the automatic rate queue table; If there are no to-be-executed details of the same Listing in the automatic rate queue table, insert the to-be-executed details into the automatic rate queue table; If there are to-be-executed details of the same Listing in the automatic rate queue table, the insertion fails and is recorded; Integrate the queue IDs corresponding to a preset number of the to-be-executed details into a group, and send the integrated group data to the automatic rate Redis queue; Read any group of the group data in the automatic rate Redis queue; Concurrently create rate update entities according to the to-be-executed details located in the automatic rate queue table corresponding to the group data, and push all the created rate update entities to the platform.
2. The method for automatically placing advertisements according to claim 1, characterized in that, The Redis queue of to-be-processed sub-policies adopts the method of entering from the right and exiting from the left, and executes the sub-policies in order.
3. The method for automatically placing advertisements according to claim 1, characterized in that The automatic advertising Redis queue adopts the method of executing the group data disorderly.
4. The method for automatically placing advertisements according to claim 1, characterized in that, The preset number is less than or equal to the Listing batch request number supported by the platform API.
5. An apparatus for automatically delivering advertisements, characterized in that, Including the method for automatically placing advertisements according to any one of claims 1-4, the device for automatically placing advertisements includes: A splitting module, configured to split the to-be-executed policy into sub-policies according to the source channels and load them into the Redis queue of to-be-processed sub-policies; A judgment module, configured to decompose a sub-strategy from a Redis queue of sub-strategies to be processed, generate details to be executed according to the sub-strategy, and judge whether there are details to be executed with the same Listing in the automatic advertising queue list. If there are no details to be executed with the same Listing in the automatic advertising queue list, the first execution module is executed; if there are, the second execution module is executed; A first execution module, configured to insert the details to be executed into the automatic advertising queue list; A second execution module, configured to record in case of insertion failure; An integration module, configured to integrate the queue IDs corresponding to a preset number of the details to be executed into a group, and send the integrated group data to an automatic advertising Redis queue; A reading module, configured to read any group of the group data in the automatic advertising Redis queue; A creation module, configured to concurrently create advertising campaign entities according to the details to be executed corresponding to the group data in the automatic advertising queue list, and push all the created advertising campaign entities to the platform.
6. A computer-readable medium having a computer program stored thereon, characterized in that, When the program is processed and executed, it implements the method for automatically placing advertisements as described in any one of claims 1-4.
7. An electronic device, characterized in that, Including: One or more processors; A storage device, configured to store one or more programs. When the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the method for automatically placing advertisements as described in any one of claims 1-4.
Citation Information
Patent Citations
Advertisement putting request processing method and device
CN111724179A
Task processing method, device and equipment and computer storage medium
CN113391890A