CN108268588B - Advertisement data summarizing and inquiring method and device - Google Patents

Advertisement data summarizing and inquiring method and device Download PDF

Info

Publication number
CN108268588B
CN108268588B CN201711222116.XA CN201711222116A CN108268588B CN 108268588 B CN108268588 B CN 108268588B CN 201711222116 A CN201711222116 A CN 201711222116A CN 108268588 B CN108268588 B CN 108268588B
Authority
CN
China
Prior art keywords
time
advertisement data
granularities
advertisement
granularity
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201711222116.XA
Other languages
Chinese (zh)
Other versions
CN108268588A (en
Inventor
张红强
何修峰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Alibaba China Co Ltd
Original Assignee
Alibaba China Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Alibaba China Co Ltd filed Critical Alibaba China Co Ltd
Priority to CN201711222116.XA priority Critical patent/CN108268588B/en
Publication of CN108268588A publication Critical patent/CN108268588A/en
Application granted granted Critical
Publication of CN108268588B publication Critical patent/CN108268588B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/40Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
    • G06F16/48Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
    • G06F16/489Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using time information
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06QDATA PROCESSING SYSTEMS OR METHODS, SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTING PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTING PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce, e.g. shopping or e-commerce
    • G06Q30/02Marketing, e.g. market research and analysis, surveying, promotions, advertising, buyer profiling, customer management or rewards; Price estimation or determination
    • G06Q30/0241Advertisement
    • G06Q30/0242Determination of advertisement effectiveness

Abstract

The embodiment of the invention provides a method and a device for summarizing and inquiring advertisement data. According to the embodiment of the invention, the time information of the advertisement data required to be inquired by the terminal equipment is divided according to different time granularities to obtain the time periods with different time granularities, the summary results of the advertisement data in the time periods with different time granularities are respectively inquired according to the time periods with different time granularities, and the summary results of the advertisement data in the time periods with different time granularities are summarized into the summary results of the advertisement data in the time length required to be inquired by the terminal equipment.

Description

Advertisement data summarizing and inquiring method and device
Technical Field
The embodiment of the invention relates to the technical field of communication, in particular to a method and a device for summarizing and inquiring advertisement data.
Background
Advertising is a means of publicizing and widely delivering information to the public through a certain form of media for a specific need.
Advertisements in different industries require different advertisement styles, and for the same advertiser, the advertiser can purchase some keywords, and an advertisement designer can design the advertisement styles according to the keywords owned by the advertiser, for example, one keyword corresponds to one advertisement style. When a netizen inputs a certain search word or certain search words in a search engine, the search engine displays a search result, and one or more advertisement styles are inserted into the search result, if the advertisement styles have enough attraction to the netizen, the netizen clicks the advertisement styles, so that a certain benefit is brought to an advertiser. The ad designer may deduct some of the advertiser's fees based on the advertiser's revenue. Because the advertisement pattern is generated according to the keywords, the whole process from inputting the search words by netizens to clicking the advertisement pattern completes the display and clicking of the keywords and the advertisement pattern and the consumption of advertisers. The search engine may record the presentation of keywords and ad styles, clicks, and consumption by advertisers.
If the number of the keywords is large, the advertisement styles are also large, for the same advertisement style, a plurality of netizens may click on the same day, and the amount of data which needs to be recorded by a search engine is large as time goes on. Generally, an advertiser only cares about the summary condition of the owned keywords in a long time, at the moment, the advertisement style corresponding to each keyword needs to be summarized in the daily display, clicking and consumption condition of the advertiser, thousands of advertisement styles corresponding to each keyword in the long time are displayed, clicked and consumed by the advertiser, the summary efficiency of the summary result is reduced by summarizing thousands of data, and the query efficiency of the summary result is reduced.
Disclosure of Invention
The embodiment of the invention provides an advertisement data summarizing and inquiring method and device, which are used for improving the advertisement data summarizing efficiency and the inquiring efficiency of summarized results.
One aspect of the embodiments of the present invention is to provide an advertisement data summarization query method, including:
receiving an inquiry request sent by terminal equipment, wherein the inquiry request comprises time information of advertisement data required to be inquired;
dividing the time length of the time information identifier according to different time granularities to obtain time periods with different time granularities;
according to time periods with different time granularities, inquiring and acquiring a summary result of the advertisement data in the time periods with the time granularities;
and determining the summary result of the advertisement data within the time length identified by the time information according to the summary result of the advertisement data within the time period of each time granularity.
Another aspect of the embodiments of the present invention is to provide an advertisement data summarization query device, including:
the receiving module is used for receiving a query request sent by terminal equipment, wherein the query request comprises time information of advertisement data to be queried;
the dividing module is used for dividing the time length of the time information identifier according to different time granularities to obtain time periods with different time granularities;
the query acquisition module is used for querying and acquiring the summary result of the advertisement data in the time periods of different time granularities according to the time periods of different time granularities;
and the determining module is used for determining the summary result of the advertisement data within the time length identified by the time information according to the summary result of the advertisement data within the time period of each time granularity.
According to the advertisement data summarizing and inquiring method and device provided by the embodiment of the invention, the time periods with different time granularities are obtained by dividing the time information of the advertisement data required to be inquired by the terminal equipment according to the time periods with different time granularities, the summarizing result of the advertisement data in the time period with each time granularity is inquired respectively according to the time periods with different time granularities, and the summarizing result of the advertisement data in the time period with each time granularity is summarized into the summarizing result of the advertisement data in the time length required to be inquired by the terminal equipment.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure.
Fig. 1 is a schematic diagram of a communication system provided by an embodiment of the present invention;
FIG. 2 is a flowchart of a method for summarizing and querying advertisement data according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a pyramid data model according to an embodiment of the present invention;
FIG. 4 is a flowchart of a method for summarizing and querying advertisement data according to an embodiment of the present invention;
FIG. 5 is a flowchart of a summarized query method for advertisement data according to another embodiment of the present invention;
FIG. 6 is a block diagram of an advertisement data summarization query device according to an embodiment of the present invention;
fig. 7 is a block diagram of an advertisement data summarization query device according to another embodiment of the present invention.
With the foregoing drawings in mind, certain embodiments of the disclosure have been shown and described in more detail below. These drawings and written description are not intended to limit the scope of the disclosed concepts in any way, but rather to illustrate the concepts of the disclosure to those skilled in the art by reference to specific embodiments.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the exemplary embodiments below are not intended to represent all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present disclosure, as detailed in the appended claims.
The advertisement data summarization query method provided by the invention can be applied to the communication system shown in figure 1. As shown in fig. 1, the communication system includes: server 11, terminal device 12, browser 13, remote server 14. It should be noted that the communication system shown in fig. 1 can be applied to different network systems.
The terminal device 12 may be a wireless terminal or a wired terminal. A wireless terminal may refer to a device that provides voice and/or other traffic data connectivity to a user, a handheld device having wireless connection capability, or other processing device connected to a wireless modem. A wireless terminal, which may be a mobile terminal such as a mobile telephone (or "cellular" telephone) and a computer having a mobile terminal, for example, a portable, pocket, hand-held, computer-included, or vehicle-mounted mobile device, may communicate with one or more core Network devices via a Radio Access Network (RAN), and may exchange language and/or data with the RAN. For another example, the Wireless terminal may also be a Personal Communication Service (PCS) phone, a cordless phone, a Session Initiation Protocol (SIP) phone, a Wireless Local Loop (WLL) station, a Personal Digital Assistant (PDA), and other devices. A wireless Terminal may also be referred to as a system, a Subscriber Unit (Subscriber Unit), a Subscriber Station (Subscriber Station), a Mobile Station (Mobile), a Remote Station (Remote Station), a Remote Terminal (Remote Terminal), an Access Terminal (Access Terminal), a Terminal Device (User Terminal), a User Agent (User Agent), and a User Device or User Equipment, which are not limited herein. Optionally, the terminal device 12 may also be a smart watch, a tablet computer, or the like.
The invention provides an advertisement data summarizing and inquiring method, which aims to solve the technical problems in the prior art.
The following describes the technical solutions of the present invention and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present invention will be described below with reference to the accompanying drawings.
Typically, advertisers may purchase keywords and ad designers may design ad patterns based on the keywords owned by the advertiser, e.g., one keyword for each ad pattern. As shown in fig. 1, the server 11 is embodied as a server on the advertisement designer side, and the server 11 can deliver the advertisement pattern designed by the advertisement designer to the search engine. The browser 13 is installed with a search engine, when the netizen inputs a certain search word or certain search words in the search engine of the browser 13, the search engine will present the search result, and insert one or more advertisement styles in the search result, if the advertisement styles have enough attraction to the netizen, the netizen will click on the advertisement styles, thereby bringing a certain profit to the advertiser. The search engine may deduct some of the advertiser's fees based on the advertiser's revenue. Therefore, the whole process from inputting the search word by the netizen to clicking the advertisement style completes the display, clicking and consumption of the advertiser of the keyword and the advertisement style. The search engine may record the presentation of keywords and ad styles, clicks, and consumption by advertisers.
The terminal device 12 may be a terminal device owned by an advertiser, and the advertiser sends a query request to the server 11 through the terminal device 12, where the query request is used to query a summary result of the display, click and consumption of the advertiser of the advertisement style corresponding to the keyword owned by the advertiser in a certain period of time. That is, the server 11 may receive the query request sent by the terminal device 12, process the query request to obtain a summary result of the query required by the advertiser, and return the summary result to the terminal device 12. In addition, before receiving the query request from the terminal device 12, the server 11 may further summarize each presentation, click and consumption of the advertiser for the keyword and the advertisement style recorded by the search engine, and the specific process includes the following steps:
step 201, obtaining an original record of advertisement data, wherein the original record comprises display, click and consumption records of keywords and advertisement styles;
as shown in fig. 1, each time the search engine of the browser 13 detects a presentation, click and consumption record of a keyword and an advertisement pattern, the presentation, click and consumption record of the keyword and the advertisement pattern is transmitted to the server 11. In this embodiment, for the same keyword, a record of one-time presentation, click and consumption of the keyword and the advertisement style is recorded as an original record. Since the number of netizens is large, the same advertisement pattern may be clicked by a plurality of different netizens, that is, the server 11 may receive a plurality of records of the same advertisement pattern within the same day. As time increases, the number of records of the same advertisement pattern received by the server 11 increases, and since the same advertiser may have a plurality of keywords corresponding to different advertisement patterns, the number of records of each advertisement pattern increases as time increases, so that the number of records received by the server 11 increases day by day.
Step 202, summarizing the original records of the advertisement data according to different preset time granularities, and respectively obtaining the summarizing result of the advertisement data of each preset time granularity.
Assuming that an advertiser has a keyword of "mobile phone," an advertisement designer designs an advertisement pattern according to the keyword of "mobile phone," for example, the advertisement pattern is delivered from 1 month and 1 day of 2017, which is only schematically illustrated here, and does not limit the number and specific content of the keyword owned by the advertiser, the specific delivery time of the advertisement pattern, and the number of times that the advertisement pattern is clicked each day after delivery. Suppose that the advertisement pattern is clicked 100 ten thousand times in total from 1/2017 to 31/2017/12, that is, the server 11 receives 100 ten thousand records of the display, click and consumption of the "mobile phone" and the advertisement pattern. The server 11 may summarize 100 ten thousand original records according to different preset time granularities, for example, the 1 st day in 2017 to the 12 th day in 2017 are divided according to the preset time granularity of half a year, quarter, month, half month, week, half week and day, for example, the half years after the 1 st day in 2017 to the 12 th day in 2017 are divided into: 1/2017 to 30/2017 and 1/2017 to 12/2017 and 31/2017; the quarterly after dividing 1/2017 to 12/2017/31/is respectively: 1/2017 to 3/31/2017, 4/1/2017 to 6/2017, 30/2017, 7/1/2017 to 9/2017, 30/2017, 10/1/2017 to 31/2017; and so on until the time divided into days, the granularity.
Further, the daily "cell phone" and the advertisement style display, click, consumption records are summarized, for example, each day of 2017, the "cell phone" and the advertisement style are displayed several times, clicked several times, how much fee the advertiser is deducted, etc. Similarly, the display, click and consumption records of the mobile phone and the advertisement style in each half-week can be summarized; summarizing the display, click and consumption records of the weekly 'mobile phone' and the advertisement style; summarizing the display, click and consumption records of the mobile phone and the advertisement style every half month; summarizing the display, click and consumption records of the monthly mobile phone and the advertisement style; summarizing the display, click and consumption records of the mobile phone and the advertisement style in each quarter; and summarizing the display, click and consumption records of the mobile phone and the advertisement style every half year. For example, 1/2/2017 is monday, 1/8/2017 is anniversary, and a complete week is from 1/2/2017 to 1/8/2017, and the display, click and consumption records of the advertisement style and the "mobile phone" of each day are shown in table 1 below during the week:
TABLE 1
From table 1, it can be seen that in the week from 1/2/2017 to 1/8/2017, the "mobile phone" and the advertisement style are displayed 91 times in total, clicked 20 times in total, and the advertiser 3100 yuan is deducted in total. Table 2 below is a summary of the results of the week from 2017, month 1 and 2 to 2017, month 1 and 8.
TABLE 2
Tables 1 and 2 are only schematic illustrations, and the summary results of other time granularities such as half-week, half-month, quarter and half-year are the same, and are not repeated here.
It can be appreciated that as the granularity of time increases, the data volume of the aggregated results after aggregating the display, click, consumption records of the "mobile phone" and the advertisement style decreases. As in the pyramid data model shown in fig. 3, the data amount aggregated with the time granularity of half a year is 0.05 times the data amount aggregated with the time granularity of day. The total data amount summarized by respectively taking semiyear, quarter, month, semimonth, week and semiweek as time granularity is about 1.5 times of the data amount summarized by taking day as time granularity.
And 203, storing the summary result of the advertisement data of each preset time granularity to a remote server.
In this embodiment, since a large storage space is required for storing the summary result of the advertisement data at each preset time granularity, alternatively, the server 11 may store the aggregated result of the advertisement data of each preset time granularity to a remote server, for example, the aggregated results aggregated at the time granularity of semiannuity are stored in the remote server 14, the aggregated results aggregated at the time granularity of quarterly are stored in the remote server 14, the aggregated results aggregated at the time granularity of month are stored in the remote server 14, the aggregated results aggregated at the time granularity of semimonthly are stored in the remote server 14, the aggregated results aggregated at the time granularity of week are stored in the remote server 14, the aggregated results aggregated at the time granularity of semiweekly are stored in the remote server 14, and the aggregated results aggregated at the time granularity of day are stored in the remote server 14. Alternatively, the remote server 14 may be one database, a plurality of databases, or a distributed database.
In this embodiment, the original records of the advertisement data are summarized according to different preset time granularities, so as to obtain the summarized result of the advertisement data of each preset time granularity respectively, and the summarized result of the advertisement data of each preset time granularity is stored in the remote server, thereby realizing the hierarchical storage of the advertisement data.
Fig. 4 is a flowchart of an advertisement data summarization query method according to an embodiment of the present invention. The embodiment of the invention provides an advertisement data summarizing and inquiring method aiming at the technical problems in the prior art, which comprises the following specific steps:
step 401, receiving an inquiry request sent by a terminal device, where the inquiry request includes time information of advertisement data to be inquired.
For example, the server 11 receives the query request sent by the terminal device 12, and assumes that the advertiser queries the summary result of the display, click, and consumption records of the "mobile phone" and the advertisement style from 1/2017 to 10/9/2017 through the terminal device 12. Accordingly, the query request sent by the terminal device 12 includes the time information, i.e., 1/2017 to 10/9/2017.
Step 402, dividing the time length of the time information identifier according to different time granularities to obtain time periods with different time granularities.
The server 11 receives the query request sent by the terminal device 12, and divides the time length identified by the time information in the query request, for example, 1/2017 to 10/9/2017.
Specifically, the dividing the time length of the time information identifier according to different time granularities to obtain time periods of different time granularities includes: and dividing the time length of the time information identifier according to the time granularity from large to small to obtain time periods with different time granularities.
For example, the time granularity of the half year is divided from 2017 1/month 1 to 2017 10/month 9 according to the time granularity of the half year, the quarter, the month, the week and the day, so that the time granularity of the half year is from 2017 1/month 1 to 2017 6/month 30, the time granularity of the quarter year is from 2017/month 1 to 2017 9/month 30, the time granularity of the week is from 2017 10/month 2 to 2017/month 10 8, and the time granularity of the day is from 2017/month 10 1 and 2017/month 10 9. Because 10/1/2017 is sunday, 10/2/2017 is monday, 10/8/2017 is sunday, 10/2/2017 to 10/8/2017 constitute a complete week, and 10/1/2017 and 10/9/2017 are two separate days in the query range.
Step 403, according to the time periods with different time granularities, inquiring and obtaining the summary result of the advertisement data in the time periods with different time granularities.
After the server 11 divides the time information in the query request from 2017 year 1/month 1 to 2017 year 10/month 9 according to different time granularities, inquiring the display, click and consumption record summary results of the mobile phone and the advertisement style in the half year from 1/2017 to 30/2017, the display, click and consumption record summary results of the mobile phone and the advertisement style in the quarter from 1/2017 to 30/2017 and 9/2017, the display, click and consumption record summary results of the mobile phone and the advertisement style in the week from 10/2/2017 to 10/8/2017, the display, click and consumption record summary results of the mobile phone and the advertisement style in the day from 10/1/2017 and the consumption record summary results from the remote server 14, and the summary result of the display, click and consumption records of the 'mobile phone' and the advertisement style in the day of 2017, 10 and 9.
Step 404, determining the summary result of the advertisement data within the time length identified by the time information according to the summary result of the advertisement data within the time period of each time granularity.
Specifically, the server 11 may query and acquire the summarized results of the display, click, and consumption records of the "mobile phone" and the advertisement style in the time period of each time granularity from the remote server 14, but the terminal device 12 queries the summarized results of the display, click, and consumption records of the "mobile phone" and the advertisement style in the time period of 1/2017 to 10/9/2017, and therefore, the server 11 needs to summarize the summarized results of the display, click, and consumption records of the "mobile phone" and the advertisement style in the time period of each time granularity again into the summarized results of the display, click, and consumption records of the "mobile phone" and the advertisement style in the time period of 1/2017 to 10/9/2017.
Specifically, the determining, according to the summary result of the advertisement data in the time period of each time granularity, the summary result of the advertisement data in the time length of the time information identifier includes: and summarizing the summary results of the advertisement data in the time periods of the time granularity again to obtain the summary results of the advertisement data in the time lengths of the time information identifications. For example, the server 11 accumulates the summary results of the display, click, and consumption records of the "mobile phone" and the advertisement style in the time period of each time granularity acquired by the query from the remote server 14, and obtains the summary results of the display, click, and consumption records of the "mobile phone" and the advertisement style in the time length from 1/2017 to 10/9/2017.
According to the embodiment of the invention, the time information of the advertisement data required to be inquired by the terminal equipment is divided according to different time granularities to obtain the time periods with different time granularities, the summary results of the advertisement data in the time periods with different time granularities are respectively inquired according to the time periods with different time granularities, and the summary results of the advertisement data in the time periods with different time granularities are summarized into the summary results of the advertisement data in the time length required to be inquired by the terminal equipment.
Fig. 5 is a flowchart of an advertisement data summarization query method according to another embodiment of the present invention. On the basis of the foregoing embodiment, the step 403, according to time periods with different time granularities, specifically querying and obtaining a summary result of the advertisement data in the time periods with the time granularities includes the following steps:
step 4031, according to the time periods of different time granularities, a plurality of request messages are generated, each request message including a time period of one time granularity.
The server 11 divides the time information in the query request into the time periods with different time granularities from 2017, 1/2017, 10/9/2017, and obtains the time periods with different time granularities, for example, the time granularity of half a year is from 2017, 1/2017, 6/30/2017, quarterly is from 2017, 7/1/2017, 9/30/2017, 10/2/2017, 10/8/2017, and the time granularity of a day is from 2017, 10/1/2017/9/2017.
In this embodiment, the server 11 may generate a request message according to the time granularity of half a year, where the request message includes two time points of 2017 year 1 month 1 day and 2017 year 6 month 30 day, that is, the request message is used to request to query the summary result of the display, click, and consumption records of "mobile phone" and advertisement style in the half a year from 2017 year 1 month 1 day to 2017 year 6 month 30 day.
Similarly, the server 11 may also generate another request message according to the time granularity of the quarter, where the request message includes two time points of 2017, month 1 and 2017, month 9 and month 30, that is, the request message is used to request to query the summary result of the display, click and consumption records of the "mobile phone" and the advertisement style in the quarter from 2017, month 1 to 2017, month 9 and month 30.
Similarly, the server 11 may further generate another request message according to the time granularity of the week, where the request message includes two time points of 2017, 10/month and 2 days and 2017, 10/month and 8 days, that is, the request message is used to request to query the summary result of the display, click and consumption records of the "mobile phone" and the advertisement style in the week from 2017, 10/month and 2 days to 2017, 10/month and 8 days.
Similarly, the server 11 may also generate another request message according to the time granularity of the day, where the request message includes a time point of day 10/1 in 2017, that is, the request message is used to request to query the summary result of display, click, and consumption records of "mobile phone" and advertisement style in the day 10/1 in 2017.
Similarly, the server 11 may also generate another request message according to the time granularity of the day, where the request message includes a time point of 10/9/2017, that is, the request message is used to request to query the summary result of the display, click, and consumption records of the "mobile phone" and the advertisement style on the day of 10/9/2017.
Step 4032, the request messages are sent to the remote server, so that the remote server can query and obtain the summary result of the advertisement data in the time period of each time granularity according to each request message.
Optionally, the server 11 sends the plurality of request messages generated in step 4031 to the remote server 14, and the remote server 14 queries, according to each request message, a summary result of display, click and consumption record of "mobile phone" and advertisement style in a half year from 1/2017 to 30/2017/6/2017, a summary result of "mobile phone" and advertisement style in a quarter from 1/2017/9/30/2017, click, a summary result of consumption record, a summary result of display, click, consumption record of "mobile phone" and advertisement style in a week from 10/2/2017 to 10/8/2017/8/year, a summary result of consumption record, a display, click and consumption style of "mobile phone" and advertisement style in a day from 10/1/2017/8/1, a summary result of consumption record, and the summary result of the display, click and consumption records of the 'mobile phone' and the advertisement style in the day of 2017, 10 and 9.
Further, the remote server 14 sends the summary results of the display, click and consumption records of the "mobile phone" and the advertisement s style in the time periods of the time granularities to the server 11, the server 11 further needs to assemble the summary results of the display, click and consumption records of the "mobile phone" and the advertisement s style in the time periods of the time granularities again into the summary results of the display, click and consumption records of the "mobile phone" and the advertisement style in the time length from 1/2017 to 10/9/2017, and send the summary results of the display, click and consumption records of the "mobile phone" and the advertisement style in the time length from 1/2017 to 10/9/2017 to the terminal device 12.
Optionally, the advertiser may have more than one keyword, such as "mobile phone", and may have a plurality of keywords, and the summary results of the advertisement style display, click, and consumption record corresponding to each keyword may be summarized or queried by the method described in this embodiment.
According to the embodiment of the invention, the plurality of request messages are generated according to the time periods with different time granularities, and the plurality of request messages are sent to the remote server, so that the remote server can respectively inquire the summary result of the advertisement data in the time periods with different time granularities according to the request messages, if the remote server is a distributed server, the distributed server can process the plurality of request messages in parallel, and the summary efficiency and the query efficiency of the summary result are further improved.
Fig. 6 is a structural diagram of an advertisement data summarizing and querying device according to an embodiment of the present invention. The advertisement data summarization query device provided in the embodiment of the present invention may execute the processing procedure provided in the embodiment of the advertisement data summarization query method, and as shown in fig. 6, the advertisement data summarization query device 60 includes: the system comprises a receiving module 61, a dividing module 62, a query obtaining module 63 and a determining module 64, wherein the receiving module 61 is used for receiving a query request sent by a terminal device, and the query request comprises time information of advertisement data to be queried; a dividing module 62, configured to divide the time length of the time information identifier according to different time granularities to obtain time periods of different time granularities; the query obtaining module 63 is configured to query and obtain a summary result of the advertisement data in a time period of each time granularity according to the time periods of different time granularities; the determining module 64 is configured to determine a summary result of the advertisement data within the time length identified by the time information according to the summary result of the advertisement data within the time period of each time granularity.
The advertisement data summarizing and querying device provided in the embodiment of the present invention may be specifically configured to execute the method embodiment provided in fig. 4, and specific functions are not described herein again.
According to the embodiment of the invention, the time information of the advertisement data required to be inquired by the terminal equipment is divided according to different time granularities to obtain the time periods with different time granularities, the summary results of the advertisement data in the time periods with different time granularities are respectively inquired according to the time periods with different time granularities, and the summary results of the advertisement data in the time periods with different time granularities are summarized into the summary results of the advertisement data in the time length required to be inquired by the terminal equipment.
Fig. 7 is a block diagram of an advertisement data summarization query device according to another embodiment of the present invention. On the basis of the foregoing embodiment, the dividing module 62 is specifically configured to: and dividing the time length of the time information identifier according to the time granularity from large to small to obtain time periods with different time granularities.
In addition, the advertisement data summarization query device 60 further includes: the system comprises an acquisition module 65, a summarization module 66 and a storage module 67, wherein the acquisition module 65 is used for acquiring original records of advertisement data, and the original records comprise display, click and consumption records of keywords and advertisement styles; the summarizing module 66 is configured to summarize the original records of the advertisement data according to different preset time granularities, and obtain summarizing results of the advertisement data of each preset time granularity respectively; the storage module 67 is configured to store the summary result of the advertisement data of each preset time granularity to a remote server.
Specifically, the query obtaining module 63 includes: a generation unit 631, a transmission unit 632; the generating unit 631 is configured to generate a plurality of request messages according to time periods of different time granularities, where each request message includes a time period of one time granularity; the sending unit 632 is configured to send the multiple request messages to the remote server, so that the remote server queries and obtains a summary result of the advertisement data in each time-granular time period according to each request message.
Optionally, the determining module 64 is specifically configured to: and summarizing the summary results of the advertisement data in the time periods of the time granularity again to obtain the summary results of the advertisement data in the time lengths of the time information identifications.
The advertisement data summarization query device provided in the embodiment of the present invention may be specifically configured to execute the method embodiments provided in fig. 2 and 5, and specific functions are not described herein again.
In the embodiment, original records of the advertisement data are summarized according to different preset time granularities, the summarized results of the advertisement data of each preset time granularity are respectively obtained, and the summarized results of the advertisement data of each preset time granularity are stored in a remote server, so that the classified storage of the advertisement data is realized; according to the time periods with different time granularities, a plurality of request messages are generated and sent to the remote server, so that the remote server can respectively inquire the summary results of the advertisement data in the time periods with the time granularities according to the request messages, if the remote server is a distributed server, the distributed server can process the request messages in parallel, and the summary efficiency and the query efficiency of the summary results are further improved.
In summary, in the embodiments of the present invention, the time information of the advertisement data that needs to be queried by the terminal device is divided according to different time granularities to obtain time periods of different time granularities, and the summary result of the advertisement data in the time periods of different time granularities is queried according to the time periods of different time granularities, and then the summary result of the advertisement data in the time periods of different time granularities is summarized into the summary result of the advertisement data in the time length that needs to be queried by the terminal device, so that compared with the prior art that the summary result is summarized based on daily display, click and consumption records of an advertiser, the summary efficiency is improved, and meanwhile, the query efficiency of the summary result is also improved; the original records of the advertisement data are summarized according to different preset time granularities, the summarizing results of the advertisement data of all the preset time granularities are respectively obtained, and the summarizing results of the advertisement data of all the preset time granularities are stored in a remote server, so that the classified storage of the advertisement data is realized; according to the time periods with different time granularities, a plurality of request messages are generated and sent to the remote server, so that the remote server can respectively inquire the summary results of the advertisement data in the time periods with the time granularities according to the request messages, if the remote server is a distributed server, the distributed server can process the request messages in parallel, and the summary efficiency and the query efficiency of the summary results are further improved.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional unit.
The integrated unit implemented in the form of a software functional unit may be stored in a computer readable storage medium. The software functional unit is stored in a storage medium and includes several instructions to enable a computer device (which may be a personal computer, a server, or a network device) or a processor (processor) to execute some steps of the methods according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
It is obvious to those skilled in the art that, for convenience and simplicity of description, the foregoing division of the functional modules is merely used as an example, and in practical applications, the above function distribution may be performed by different functional modules according to needs, that is, the internal structure of the device is divided into different functional modules to perform all or part of the above described functions. For the specific working process of the device described above, reference may be made to the corresponding process in the foregoing method embodiment, which is not described herein again.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.

Claims (6)

1. An advertisement data summarization query method is characterized by comprising the following steps:
receiving an inquiry request sent by terminal equipment, wherein the inquiry request comprises time information of advertisement data required to be inquired;
dividing the time length of the time information identifier according to different time granularities to obtain time periods with different time granularities;
respectively inquiring and acquiring the summary results of the advertisement data in the time periods of different time granularities according to the time periods of different time granularities;
determining a summary result of the advertisement data within the time length of the time information identifier according to the summary result of the advertisement data within the time period of each time granularity;
the dividing the time length of the time information identifier according to different time granularities to obtain time periods of different time granularities includes:
dividing the time length of the time information identifier according to the time granularity from large to small to obtain time periods with different time granularities;
before receiving the query request sent by the terminal device, the method further comprises the following steps:
acquiring an original record of advertisement data, wherein the original record comprises display, click and consumption records of keywords and advertisement styles;
summarizing the original records of the advertisement data according to different preset time granularities to respectively obtain summarizing results of the advertisement data of each preset time granularity;
and storing the summary result of the advertisement data of each preset time granularity to a remote server.
2. The method according to claim 1, wherein the querying and obtaining the summary result of the advertisement data in the time periods of the time granularities respectively according to the time periods of the different time granularities comprises:
generating a plurality of request messages according to time periods with different time granularities, wherein each request message comprises a time period with one time granularity;
and sending the request messages to the remote server so that the remote server can inquire and obtain the summary result of the advertisement data in the time period of each time granularity according to each request message.
3. The method of claim 2, wherein the determining the summarized result of the advertisement data in the time length identified by the time information according to the summarized result of the advertisement data in the time periods of the respective time granularities comprises:
and summarizing the summary results of the advertisement data in the time periods of the time granularity again to obtain the summary results of the advertisement data in the time lengths of the time information identifications.
4. An advertisement data summarization query device, comprising:
the receiving module is used for receiving a query request sent by terminal equipment, wherein the query request comprises time information of advertisement data to be queried;
the dividing module is used for dividing the time length of the time information identifier according to different time granularities to obtain time periods with different time granularities;
the query acquisition module is used for respectively querying and acquiring the summary results of the advertisement data in the time periods of different time granularities according to the time periods of different time granularities;
the determining module is used for determining the summary result of the advertisement data within the time length of the time information identifier according to the summary result of the advertisement data within the time period of each time granularity;
the dividing module is specifically configured to: dividing the time length of the time information identifier according to the time granularity from large to small to obtain time periods with different time granularities;
further comprising:
the system comprises an acquisition module, a display module and a display module, wherein the acquisition module is used for acquiring an original record of advertisement data, and the original record comprises display, click and consumption records of keywords and advertisement styles;
the summarizing module is used for summarizing the original records of the advertisement data according to different preset time granularities to respectively obtain summarizing results of the advertisement data of each preset time granularity;
and the storage module is used for storing the summary result of the advertisement data of each preset time granularity to a remote server.
5. The advertisement data summarization query device according to claim 4, wherein the query obtaining module comprises:
the generating unit is used for generating a plurality of request messages according to time periods with different time granularities, wherein each request message comprises a time period with one time granularity;
and the sending unit is used for sending the plurality of request messages to the remote server so that the remote server can inquire and obtain the summary result of the advertisement data in the time period of each time granularity according to each request message.
6. The advertisement data summarization query device according to claim 5, wherein the determining module is specifically configured to: and summarizing the summary results of the advertisement data in the time periods of the time granularity again to obtain the summary results of the advertisement data in the time lengths of the time information identifications.
CN201711222116.XA 2017-11-29 2017-11-29 Advertisement data summarizing and inquiring method and device Active CN108268588B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201711222116.XA CN108268588B (en) 2017-11-29 2017-11-29 Advertisement data summarizing and inquiring method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201711222116.XA CN108268588B (en) 2017-11-29 2017-11-29 Advertisement data summarizing and inquiring method and device

Publications (2)

Publication Number Publication Date
CN108268588A CN108268588A (en) 2018-07-10
CN108268588B true CN108268588B (en) 2021-07-23

Family

ID=62770896

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201711222116.XA Active CN108268588B (en) 2017-11-29 2017-11-29 Advertisement data summarizing and inquiring method and device

Country Status (1)

Country Link
CN (1) CN108268588B (en)

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104572726A (en) * 2013-10-22 2015-04-29 北京品众互动网络营销技术有限公司 Advertisement analysis method
CN104915431A (en) * 2015-06-17 2015-09-16 深圳市腾讯计算机系统有限公司 Data storage method and system

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8775454B2 (en) * 2008-07-29 2014-07-08 James L. Geer Phone assisted ‘photographic memory’
US20110295684A1 (en) * 2010-06-01 2011-12-01 Jeong Gab Lee Method and server for managing advertisements
CN103605664B (en) * 2013-10-22 2017-01-18 芜湖大学科技园发展有限公司 Massive dynamic data fast query method meeting different time granularity requirements

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104572726A (en) * 2013-10-22 2015-04-29 北京品众互动网络营销技术有限公司 Advertisement analysis method
CN104915431A (en) * 2015-06-17 2015-09-16 深圳市腾讯计算机系统有限公司 Data storage method and system

Also Published As

Publication number Publication date
CN108268588A (en) 2018-07-10

Similar Documents

Publication Publication Date Title
CN104809632B (en) A kind of generation method and device of the dynamic advertising based on template
CN103295150A (en) Advertising release system and advertising release method capable of accurately quantizing and counting release effects
CN102883056A (en) Short message reminding method and mobile terminal
CN102004993A (en) Information push method and system
US9128971B2 (en) Method and system for performing count-distinct queries in a large data set that stores presence bitmaps corresponding to different time periods
WO2011127062A1 (en) System for providing audio advertising messages on a mobile device
CN107464133B (en) Method and device for delivering advertisement
TWI530900B (en) Method and system for updating security information
CN104850546A (en) Mobile media information display method and system
CN106792001B (en) Advertisement operation method and system for smart television
CN108900924A (en) The method and apparatus of commending friends in direct broadcasting room
CN105760380A (en) Database query method, device and system
CN101083633A (en) Information searching system and searching method
CN108596690B (en) Advertisement processing method and device
CN108268588B (en) Advertisement data summarizing and inquiring method and device
CN109151808A (en) A kind of data analysing method and system
CN105787066A (en) Digital content distribution system based on total analysis
CN100419762C (en) Freely-inputted wireless short message matching and search engine information processing method, and apparatus therefor
CN107423999B (en) Directional advertisement issuing method and system based on user grouping
CN102216946A (en) Apparatus and method for providing and receiving mobile advertising service in a mobile advertising system
CN102982112A (en) Ranking list generation method and journal generation method and server
CN101384050A (en) Mobile terminal, method and system for resource management
CN103186571A (en) Method and device for displaying mobile media information in mobile search system
CN110852781A (en) Advertisement push service system
CN109360106B (en) Sketch construction method, system, medium and computer system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
TA01 Transfer of patent application right

Effective date of registration: 20200417

Address after: 310052 room 508, floor 5, building 4, No. 699, Wangshang Road, Changhe street, Binjiang District, Hangzhou City, Zhejiang Province

Applicant after: Alibaba (China) Co.,Ltd.

Address before: 510627 Guangdong city of Guangzhou province Whampoa Tianhe District Road No. 163 Xiping Yun Lu Yun Ping square B radio tower 13 layer self unit 01

Applicant before: GUANGZHOU SHENMA MOBILE INFORMATION TECHNOLOGY Co.,Ltd.

TA01 Transfer of patent application right
GR01 Patent grant
GR01 Patent grant