CN104899758A - Advertisement playing report generation system and generation method thereof - Google Patents
Advertisement playing report generation system and generation method thereof Download PDFInfo
- Publication number
- CN104899758A CN104899758A CN201410082312.1A CN201410082312A CN104899758A CN 104899758 A CN104899758 A CN 104899758A CN 201410082312 A CN201410082312 A CN 201410082312A CN 104899758 A CN104899758 A CN 104899758A
- Authority
- CN
- China
- Prior art keywords
- advertisement
- data
- play
- record
- appointment
- 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.)
- Pending
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention provides an advertisement playing report generation system, comprising: an advertisement base data summarizing module for summarizing advertisement data and generating data applicable to an advertisement playing report; an advertisement playing report generation module which is used for generating the corresponding advertisement playing report based on the data, which is applicable to the advertisement playing report and is generated by the advertisement base data summarizing module; and a data storage module for storing the data which is applicable to the advertisement playing report and is generated by the advertisement base data summarizing module and the advertisement playing report generated by the advertisement playing report generation module. The present invention also provides an advertisement playing report generation method.
Description
technical field:
The present invention relates to advertisement multimedia technical field, relate to a kind of advertisement particularly and play report generating system and generation method, particularly a kind of system and method for generating report forms on the basis of television advertising combined data.
background technology:
Advertisement, as the product of commodity economy, undoubtedly just day by day on the stage of economy, plays more and more important role.Television advertising, as one of the source of advertisement, has great significance in people's life.As the enterprise of advertisement putting, also can wish that the advertisement of oneself throwing in can be paid close attention to by more people.Television advertising report generation service can efficiently and accurately geo-statistic television advertising data, are the basis analyzed as ad data.
In the prior art, usually directly to add up from basic combined data, and by Structured Query Language (SQL) (Structured Query Language, is abbreviated as SQL) generating report forms.But the method that this generating advertisement plays form can bring following problem:
(1) data volume of basic combined data is very large, carries out that report form statistics speed is slow, efficiency is low, there will be wait phenomenon in user's use procedure;
(2) for a report data, each inquiry all will regenerate.
summary of the invention:
For solving the problems of the technologies described above, the invention provides a kind of advertisement and playing report generating system, comprising: advertisement basic data summarizing module, for gathering ad data, and generating the data being applicable to advertisement broadcasting form; Report generation module is play in advertisement, and what generate based on described advertisement basic data summarizing module is applicable to the data that form is play in advertisement, generates corresponding advertisement and plays form; Data memory module, the data being applicable to advertisement broadcasting form and described advertisement for storing the generation of described advertisement basic data summarizing module play the advertisement broadcasting form that report generation module generates.
Preferably, described advertisement is play report generating system and is also comprised data reception module, for obtaining the ad data from outside input, and described ad data is supplied to described advertisement basic data summarizing module.
Preferably, described advertisement is play report generation module and is comprised several report generation module, plays form for generating dissimilar advertisement, and form is play in the advertisement that wherein report generation module described in each can generate corresponding type according to appointed information in advance.
Preferably, described data memory module comprises the first data memory module and the second data memory module, the data being applicable to advertisement broadcasting form that wherein said first data memory module generates for storing described advertisement basic data summarizing module, the advertisement broadcasting form that described second data memory module generates for storing described advertisement broadcasting report generation module.
Preferably, described appointed information in advance at least comprises in appointment, the daily appointment of period statistics advertisement broadcasting record and the appointment of monthly channel statistics advertisement broadcasting record of daily channel statistics advertisement broadcasting record.
Preferably, described several report generation module at least comprises that the appointment of playing record for described daily channel statistics advertisement generates the first report generation module that the first advertisement plays form, the appointment of playing record for described daily period statistics advertisement generates the second advertisement and play the second form generation module of form and generate one that the 3rd advertisement plays in the 3rd report generation module of form for the appointment that record is play in described monthly channel statistics advertisement.
Preferably, described second data memory module uses GreenPlum data warehouse.
Preferably, described several report generation module uses advertisement described in each self-generating of file record to play the date of form respectively, and often generate once described advertisement broadcasting form with regard to record once, if find that certain described advertisement once plays report generation mistake, by the date change in described file to current time and from newly adding up.
The present invention also provides a kind of advertisement to play the method for report generation, comprising: gather ad data, generates and is applicable to the data that form is play in advertisement; Store the data being applicable to advertisement broadcasting form generated; Be applicable to based on generated the data that form is play in advertisement, generate corresponding advertisement and play form; Store the advertisement generated and play form.
Preferably, described method also comprises: obtain the ad data from outside input, and gather described in being used for by described ad data.
Preferably, in the described method, generate dissimilar advertisement according to appointed information in advance and play form.
Preferably, in the described method, described appointed information in advance at least comprises in appointment, the daily appointment of period statistics advertisement broadcasting record and the appointment of monthly channel statistics advertisement broadcasting record of daily channel statistics advertisement broadcasting record.
Preferably, described method comprises: play the appointment of recording for described daily channel statistics advertisement and generate the first advertisement broadcasting form, generate the second advertisement broadcasting form for the appointment of described daily period statistics advertisement broadcasting record and play in form for appointment generation the 3rd advertisement of described monthly channel statistics advertisement broadcasting record.
Preferably, in the described method, file record is used to generate the date of described advertisement broadcasting form, and often generate once described advertisement broadcasting form with regard to record once, if find that certain described advertisement once plays report generation mistake, by the date change in described file to current time and from newly adding up.
The television advertising report data checked required for user can generate by technique scheme of the present invention before user uses, and reduces the stand-by period in user's query script, avoids regenerating at every turn.
accompanying drawing illustrates:
Fig. 1 is the structured flowchart of the advertisement broadcasting report generating system that embodiment of the present invention relates to;
Fig. 2 is the process flow diagram of the advertisement broadcasting report generation that embodiment of the present invention relates to;
Fig. 3 is that in step S14, the process flow diagram that report generation module 5 generates corresponding advertisement broadcasting form is play in above-mentioned advertisement;
Fig. 4 is the example that above-mentioned advertisement plays that report generation module 5 generates corresponding advertisement broadcasting form.
embodiment:
Illustrated embodiment sets forth this invention with reference to the accompanying drawings below.
Fig. 1 shows the structured flowchart of the advertisement broadcasting report generating system that embodiment of the present invention relates to.As shown in Figure 1, above-mentioned advertisement broadcasting report generating system comprises data reception module 2, advertisement basic data summarizing module 3, data memory module 4, advertisement broadcasting report generation module 5, data memory module 6.Wherein, above-mentioned data reception module 2 for obtain from outside input ad data, such as, from the ad data of television terminal 1; Above-mentioned advertisement basic data summarizing module 3 for gathering the above-mentioned ad data from above-mentioned data reception module 2, and generates the data being applicable to advertisement broadcasting form; The data being applicable to advertisement broadcasting form that above-mentioned data memory module 4 generates for storing above-mentioned advertisement basic data summarizing module 3; The data being applicable to advertisement broadcasting form that report generation module 5 generates based on above-mentioned advertisement basic data summarizing module 3 are play in above-mentioned advertisement, generate corresponding advertisement and play form; The advertisement broadcasting form that above-mentioned data memory module 6 generates for storing above-mentioned advertisement broadcasting report generation module 5.
Above-mentioned advertisement is play report generation module 5 and is also comprised several report generation module, and wherein each report generation module plays form for dissimilar advertisement, can generate corresponding advertisement broadcasting form according to specifying in advance.Such as, above-mentioned advertisement broadcasting report generation module 5 also comprises the first report generation module 51, second form generation module 52 and the 3rd report generation module 53 etc.According to the demand of user, can play in report generating system in above-mentioned advertisement and preset corresponding appointment, such as can set the appointment that record is play in daily channel statistics advertisement, daily the appointment etc. of the appointment of record and monthly channel statistics advertisement broadcasting record is play in period statistics advertisement, and make above-mentioned first report generation module 51 play the appointment of record for daily channel statistics advertisement, above-mentioned second form generation module 52 plays the appointment of record for the statistics advertisement of daily period and above-mentioned 3rd report generation module 53 plays the appointment of record for monthly channel statistics advertisement, generate the advertisement broadcasting form that record is play in daily channel statistics advertisement respectively, daily the advertisement broadcasting form etc. of form and monthly channel statistics advertisement broadcasting record is play in the advertisement of period statistics advertisement broadcasting record.
Fig. 2 is the process flow diagram of the advertisement broadcasting report generation that embodiment of the present invention relates to.The processing procedure playing report generation in advertisement of the present embodiment is described referring to Fig. 2.
Start above-mentioned advertisement and play report generating system, above-mentioned data reception module 2 receives the ad data inputted from outside (as television terminal 1), and by received above-mentioned advertising data transmission to above-mentioned advertisement basic data summarizing module 3(step S11).Above-mentioned advertisement basic data summarizing module 3 gathers the above-mentioned ad data from above-mentioned data reception module 2, and generating the data (step S12) being applicable to advertisement broadcasting form, the data being applicable to advertisement broadcasting form then above-mentioned advertisement basic data summarizing module 3 generated are stored in above-mentioned data memory module 4 (step S13).Above-mentioned advertisement is play report generation module 5 from above-mentioned data memory module 4, is obtained the above-mentioned data being applicable to advertisement broadcasting form, and generate corresponding advertisement broadcasting form (step S14), then form is play in generated above-mentioned corresponding advertisement and be stored in above-mentioned data memory module 6 (step S15).Thus, user can check that form is play in various advertisement as required easily from above-mentioned data memory module 6.
Fig. 3 is that in step S14, the process flow diagram that report generation module 5 generates corresponding advertisement broadcasting form is play in above-mentioned advertisement.As shown in Figure 3, the data (step S141) being applicable to advertisement broadcasting form that report generation module 5 obtains the generation of above-mentioned advertisement basic data summarizing module 3 from above-mentioned data memory module 4 are play in above-mentioned advertisement, the appointed information (step S142) of reading pre-set, select the above-mentioned advertisement of the corresponding report generation CMOS macro cell in above-mentioned several report generation module to play form (step S143) respectively according to the read appointed information preset, form is play in each generated advertisement and is stored in above-mentioned data memory module 6 (step S15).
Fig. 4 is the example that above-mentioned advertisement plays that report generation module 5 generates corresponding advertisement broadcasting form.As shown in Figure 4, the data (step S151) being applicable to advertisement broadcasting form that report generation module 5 obtains the generation of above-mentioned advertisement basic data summarizing module 3 from above-mentioned data memory module 4 are play in above-mentioned advertisement, the appointed information (step S152) of reading pre-set, and the read appointed information preset is judged (step S153).If the appointed information preset above-mentioned is the appointment (step S153: yes) of playing record about daily channel statistics advertisement, form (step S154) is play in the first advertisement then selecting above-mentioned first report generation module 51 to generate about daily channel statistics advertisement broadcasting is recorded, store the first advertisement generated and play form (step S15), and return step S152, read the next appointed information preset.If the appointed information preset above-mentioned is not the appointment (step S153: no) of playing record about daily channel statistics advertisement, then judge that whether the above-mentioned appointed information preset is play the appointment (step S155) of recording about daily period statistics advertisement further.If the appointed information preset above-mentioned is about daily the period adds up the appointment (step S155: yes) that record is play in advertisement, form (step S156) is play in the second advertisement then selecting above-mentioned second form generation module 52 to generate about daily period statistics advertisement broadcasting is recorded, store the second advertisement generated and play form (step S15), and return step S152, read the next appointed information preset.If the appointed information preset above-mentioned is not about daily the period adds up the appointment (step S155: no) that record is play in advertisement, then judge that the above-mentioned appointed information preset is the appointment of playing record about monthly channel statistics advertisement, and select above-mentioned 3rd report generation module 52 to generate the 3rd advertisement broadcasting form (step S157) of playing record about monthly channel statistics advertisement, store the 3rd advertisement generated and play form (step S15).By that analogy, until the advertisement broadcasting form for all appointed information preset completes all.
In the present embodiment, report generating system is play in above-mentioned advertisement can be set to timing operation every day, and form is play in the advertisement generating the same day, also can generate the television advertising data sheet of specifying other day.
In the present embodiment, file record above-mentioned advertisement in above-mentioned several report generation module, can be used to play the date of report generation, often generate an advertisement and play form with regard to record once.Further, if find that report generation mistake is play in the advertisement of some day, by the date change in this file to the same day and from newly adding up, new advertisement broadcasting form life can be generated and replaced.
In the present embodiment, above-mentioned data memory module 6 can use GreenPlum data warehouse.GreenPlum data warehouse is a large-scale distributed data warehouse, has powerful parallel processing capability, and support to manage mass data, search efficiency is high, also supports the SQL statement such as INSERT, UPDATE, the DELETE in general data storehouse simultaneously.
In the present embodiment, inventor illustrates above-mentioned advertisement broadcasting report generation module 5 and also comprises the first report generation module 51, second form generation module 52 and the 3rd report generation module 53, correspondingly illustrate simultaneously and play the appointment of record for daily channel statistics advertisement respectively, daily the appointment of the appointment of record and monthly channel statistics advertisement broadcasting record is play in period statistics advertisement, generate the advertisement broadcasting form that record is play in daily channel statistics advertisement, daily the advertisement broadcasting form of form and monthly channel statistics advertisement broadcasting record is play in the advertisement of period statistics advertisement broadcasting record.But the present invention is not limited to this, can the requirement of user of basis, increase and decrease above-mentioned table generation module value volume and range of product, and can specify according to the requirement setting of user is corresponding.Such as, except daily the appointment of record is play in channel statistics advertisement, daily period statistics advertisement is play outside the appointment of the appointment of record and monthly channel statistics advertisement broadcasting record, the appointment of record can also be play by all channel statistics advertisements, play the appointment of record by the statistics advertisement of period in week and play the appointment of record by all channel statistics advertisements, generate the advertisement broadcasting form playing record by all channel statistics advertisements simultaneously, play form by the advertisement of period in week statistics advertisement broadcasting record and play the advertisement of recording by all channel statistics advertisements and play form, etc..
In the present embodiment, above-mentioned data memory module 4 and above-mentioned data memory module 6 independently exist, but the present invention is not limited to this, and above-mentioned data memory module 4 and above-mentioned data memory module 6 can use same data memory module.
Embodiment described in above instructions and embodiment should be understood only be not used in for illustration of the present invention and limit the scope of the invention.After having read the present invention, the amendment of those skilled in the art to various equivalents of the present invention has all fallen within the application's claims limited range.
Claims (14)
1. a report generating system is play in advertisement, comprising:
Advertisement basic data summarizing module, for gathering ad data, and generates the data being applicable to advertisement broadcasting form;
Report generation module is play in advertisement, and what generate based on described advertisement basic data summarizing module is applicable to the data that form is play in advertisement, generates corresponding advertisement and plays form;
Data memory module, the data being applicable to advertisement broadcasting form and described advertisement for storing the generation of described advertisement basic data summarizing module play the advertisement broadcasting form that report generation module generates.
2. system according to claim 1, is characterized in that:
Described advertisement is play report generating system and is also comprised data reception module, for obtaining the ad data from outside input, and described ad data is supplied to described advertisement basic data summarizing module.
3. system according to claim 1 and 2, is characterized in that:
Described advertisement is play report generation module and is comprised several report generation module, plays form for generating dissimilar advertisement, and form is play in the advertisement that wherein report generation module described in each can generate corresponding type according to appointed information in advance.
4. system according to claim 3, is characterized in that:
Described data memory module comprises the first data memory module and the second data memory module, the data being applicable to advertisement broadcasting form that wherein said first data memory module generates for storing described advertisement basic data summarizing module, the advertisement broadcasting form that described second data memory module generates for storing described advertisement broadcasting report generation module.
5. system according to claim 3, is characterized in that:
Appointment, daily period statistics advertisement that described appointed information in advance at least comprises daily channel statistics advertisement broadcasting record play one in the appointment of the appointment of record and monthly channel statistics advertisement broadcasting record.
6. system according to claim 5, is characterized in that:
Described several report generation module at least comprises that the appointment of playing record for described daily channel statistics advertisement generates the first report generation module that the first advertisement plays form, the appointment of playing record for described daily period statistics advertisement generates the second advertisement and plays the second form generation module of form and generate one that the 3rd advertisement plays in the 3rd report generation module of form for the appointment that record is play in described monthly channel statistics advertisement.
7. system according to claim 4, is characterized in that:
Described second data memory module uses GreenPlum data warehouse.
8. system according to claim 3, is characterized in that:
Described several report generation module uses advertisement described in each self-generating of file record to play the date of form respectively, and often generate once described advertisement broadcasting form with regard to record once, if find that certain described advertisement once plays report generation mistake, by the date change in described file to current time and from newly adding up.
9. a method for report generation is play in advertisement, comprising:
Ad data is gathered, generates and be applicable to the data that form is play in advertisement;
Store the data being applicable to advertisement broadcasting form generated;
Be applicable to based on generated the data that form is play in advertisement, generate corresponding advertisement and play form;
Store the advertisement generated and play form.
10. method according to claim 9, is characterized in that, also comprises:
Obtain the ad data from outside input, and gather described in described ad data is used for.
11. methods according to claim 9 or 10, is characterized in that:
Generate dissimilar advertisement according to appointed information in advance and play form.
12. methods according to claim 11, is characterized in that:
Appointment, daily period statistics advertisement that described appointed information in advance at least comprises daily channel statistics advertisement broadcasting record play one in the appointment of the appointment of record and monthly channel statistics advertisement broadcasting record.
13. methods according to claim 12, is characterized in that, comprising:
Play the appointment of recording for described daily channel statistics advertisement to generate the first advertisement broadcasting form, generate the second advertisement broadcasting form for the appointment of described daily period statistics advertisement broadcasting record and play in form for appointment generation the 3rd advertisement of described monthly channel statistics advertisement broadcasting record.
14. methods according to claim 11, is characterized in that:
File record is used to generate the date of described advertisement broadcasting form, and often generate once described advertisement broadcasting form with regard to record once, if find that certain described advertisement once plays report generation mistake, by the date change in described file to current time and from newly adding up.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410082312.1A CN104899758A (en) | 2014-03-07 | 2014-03-07 | Advertisement playing report generation system and generation method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410082312.1A CN104899758A (en) | 2014-03-07 | 2014-03-07 | Advertisement playing report generation system and generation method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104899758A true CN104899758A (en) | 2015-09-09 |
Family
ID=54032409
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410082312.1A Pending CN104899758A (en) | 2014-03-07 | 2014-03-07 | Advertisement playing report generation system and generation method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104899758A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107103047A (en) * | 2017-03-31 | 2017-08-29 | 北京奇艺世纪科技有限公司 | A kind of method and device for inquiring about advertisement putting abnormal cause |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1980381A (en) * | 2005-12-08 | 2007-06-13 | 厦门雅迅网络股份有限公司 | Taxi networked advertisement playing effect data processing method |
| CN101226618A (en) * | 2007-01-18 | 2008-07-23 | 尚凡资讯有限公司 | System for management of mutually feeding type website advertisement |
| CN101271562A (en) * | 2008-05-12 | 2008-09-24 | 腾讯科技（深圳）有限公司 | Collection processing method and system for network advertisement operation event information |
-
2014
- 2014-03-07 CN CN201410082312.1A patent/CN104899758A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1980381A (en) * | 2005-12-08 | 2007-06-13 | 厦门雅迅网络股份有限公司 | Taxi networked advertisement playing effect data processing method |
| CN101226618A (en) * | 2007-01-18 | 2008-07-23 | 尚凡资讯有限公司 | System for management of mutually feeding type website advertisement |
| CN101271562A (en) * | 2008-05-12 | 2008-09-24 | 腾讯科技（深圳）有限公司 | Collection processing method and system for network advertisement operation event information |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107103047A (en) * | 2017-03-31 | 2017-08-29 | 北京奇艺世纪科技有限公司 | A kind of method and device for inquiring about advertisement putting abnormal cause |
| CN107103047B (en) * | 2017-03-31 | 2020-07-03 | 北京奇艺世纪科技有限公司 | Method and device for inquiring reason of advertisement delivery abnormity |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP2021064960A (en) | Automatic content recognition fingerprint sequence matching | |
| CN107609913B (en) | Data analysis tracking method and system | |
| US20140297680A1 (en) | Analyzing multiple data streams as a single data object | |
| US20150334068A1 (en) | Message processing method and apparatus | |
| CN105120321A (en) | Video searching method, video storage method and related devices | |
| CN104778175A (en) | Method and system for realizing data synchronization of heterogeneous database | |
| CN101546589A (en) | Active playlist having dynamic media item groups | |
| AU2022204151B2 (en) | Targeted advertising based on user product information | |
| CN103164525B (en) | WEB application dissemination method and device | |
| EP2883153A1 (en) | Media content receiving device and distribution of media content utilizing social networks and social circles | |
| CN104581406A (en) | Network video recording and playback system and method | |
| CN105407030B (en) | The method and device of multimedia file is played in a kind of instant messaging | |
| CN104035991A (en) | Display method of news headlines and server for providing news pages | |
| CN105407365A (en) | Advertisement data management method and advertisement management server side | |
| CN109977135A (en) | A kind of data query method, apparatus and server | |
| CN105900093A (en) | Keyvalue database data table updating method and data table updating device | |
| CN103220587B (en) | A kind of method and device obtaining time-shifted contents | |
| CN103942213A (en) | Data paging method and device | |
| CN104899758A (en) | Advertisement playing report generation system and generation method thereof | |
| JP2011526026A5 (en) | ||
| CN105718491A (en) | Updating method and device between databases | |
| CN105120392A (en) | Method of creating sound box grouping and mobile terminal | |
| CN102611725B (en) | A kind of method and device of memory node | |
| CN109376174B (en) | Method and device for selecting database | |
| CN103870513A (en) | Method, equipment and system for video processing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150909 |