Summary of the invention
The object of the present invention is to provide a kind of stream media video-frequency advertisement put-on method, this method can not only be play channel for the advertiser opens up effective video advertisement, can also reduce the influence that advertisement causes user experience to greatest extent, improve the user advertising satisfaction.
For achieving the above object, the present invention is achieved in that
A kind of stream media video-frequency advertisement put-on method may further comprise the steps:
A. definite advertising plan: comprise input phase, input period, input region, input channel (column), the input frequency (N+), six contents of injected volume of determining advertisement, form the advertisement putting planning chart, and ad material is provided.
B. carry out Advertisement arrangement, comprising: I. handles ad material, with advertisement essential information input advertisement table and promotional literature table, and uploads promotional literature; II. import waiting, make up the Advertisement arrangement database, this Advertisement arrangement database comprises Advertisement arrangement master meter, waiting relevant information table, release time table, watches log recording table.
C. control advertisement and play, be divided into following substep successively: 1. the user sends a video (VOD) program request; 2. after media is received the VOD order request, transmit parameters such as media sign and media program category sign to system, the former is the unique identification that is assigned to each media, and the latter is the unique identification of each program category; 3. after the above-mentioned sign that receives transmission, a correspondent advertisement interface will be inquired about and return in system, media calls this interface, and give self-defining advertisement broadcast address parameter A durl with this interface assignment, and give custom parameter url, and two players are set for advertisement and program respectively with the broadcast address assignment of own program; 4. judge whether the advertisement interface IP address Adurl return is empty,,, then enter step 6. if be sky if for sky then carry out step 5.; 5. each media can be provided with an advertisement latency value according to the situation of oneself, and general recommendations is the arbitrary value between 8 seconds to 12 seconds.If surpass the stand-by period, Adurl also is empty, can not get advertising address in this time, then enters step and 8. play-overs program, if got advertisement in the stand-by period, promptly Adurl is not empty, then changes step over to 6.; 6. start the advertisement player, begin to play advertisement; 7. after advertisement begins to play, start show player simultaneously and begin the program buffering, advertisement is play and is not finished if the program buffering finishes, and then program is put halted state, carries out 8. broadcast program of step after waiting advertisement to finish.Also play end if the program buffering finishes the back advertisement, then directly carried out 8. broadcast program of step.
D. recording played daily record: after advertisement finishes, information such as the ID (AdID) of this advertisement, media sign (CPID), the program category of throwing in (CPPgTypeID) and user's relevant parameter (IP, watch time, city, place etc.) are write advertisement watch log sheet (AdVusitLog).
Further, substep among the step c of the present invention is mentioned the advertisement interface in 3. and can be obtained by following process: behind user's program request VOD program, system obtains the parameter that the user transmits and comprises information such as media communication, program category, User IP, user COOKIE and city, place.At first, queries ad waiting relevant information table (AdPlanInfo) is thrown in CP (CPID) and input channel (PgTypeID) according to media communication and program category coupling, returns eligible set of records ends, and record of random choose therefrom.Then according to the Advertisement arrangement id field (AdPlanID) of this record, queries ad waiting master meter (AdPlan), obtain the ID (AdID) of advertisement, according to AdID field queries ad table (Advertisement), judge whether this advertisement meets the region and throw in condition, if do not meet then return address blank, otherwise queries ad is watched log recording table (AdVusitLog), adds up the number of times that this user watches this advertisement.If accumulative total is watched number of times smaller or equal to the value of throwing in frequency N+ (NPlus), then meet and throw in frequency control, return the interface IP address (LinkUrl) of this advertisement, otherwise return address blank.
The invention has the beneficial effects as follows: can require to determine to throw in date and injected volume according to the advertiser, make advertisement corresponding with program category, certain video frequency program of user's program request, system is at first according to the type of this program, the request that sends is to obtain corresponding stream media video-frequency advertisement, through period, N+, after control is thrown in region etc., the calling interface of correspondent advertisement is returned to media call, playing stream media video ads when being implemented in program and cushioning.After video ads finished, system automatically switched to video frequency program and plays.And can carry out the advertising-on-demand number, person-time and by media, by the region, on a time period, by the detailed advertising program request situation of channel statistics; In step c, each media also can be provided with an advertisement latency value according to the situation of oneself, if surpass the stand-by period, Adurl also is empty, then illustrate in this time and can not get advertising address, then play-over program, if in the stand-by period, got advertisement, be that Adurl is not sky, then press normal procedure and play advertisement.When some special circumstances are got less than advertisement, can influence the user and watch program like this.
Embodiment
The invention will be further described below in conjunction with drawings and Examples.
As shown in the figure, Fig. 1 is the general flow chart of advertisement putting of the present invention;
General flow chart illustrates step by step:
A. determine the advertisement putting plan, as Fig. 2
Advertiser determines input phase, input period, input region, input channel (column), the input frequency (N+), six contents of injected volume of advertisement, forms " advertisement putting planning chart ", and ad material is provided
B. carry out Advertisement arrangement
Advertisement arrangement was divided into for two steps:
I. ad material is handled, as Fig. 3
Handle in the process of material, with advertisement essential information input relevant information table, comprise advertisement table (Advertisement) and promotional literature table (AdFile), list structure is as follows:
Advertisement table [Advertisement]
Field name | Data type | Explain |
AdID | Int | Advertisement ID |
Title | Varchar(100) | Ad title |
AdTypeID | Int | Adline |
LinkUrl | Varchar(256) | The network address that advertisement can be linked to |
CreateTime | Datetime | The advertisement creation time |
CompanyID | Int | The ID of company of advertisement correspondence |
BrandID | Int | The brand ID of advertisement correspondence |
IfPay | Bit | Whether advertisement is the charge advertisement |
NPlus | Int | The N+ of advertisement plays the frequency |
Promotional literature table [AdFile]
Field name | Data type | Explain |
AdFileID | Int | Promotional literature ID |
AdID | Int | The advertisement ID of promotional literature correspondence |
FileName | Varchar(64) | The title of file |
FileSize | Int | The size of file |
FileType | tinyint | The type of file |
Path | Varchar(64) | The issuing path of file |
After obtaining ad material, the essential informations such as title, type and link of advertisement are saved in the advertisement table (Advertisement), this table is a major key with the AdID field.After promotional literature is uploaded, file name and routing information are kept in the promotional literature table (AdFile), this table is associated with advertisement table (Advertisement) by the AdID field.
II. carry out waiting, as Fig. 4
After ad material is finished dealing with, waiting is carried out in advertisement, and the waiting data are saved in the correlation table in the Advertisement arrangement database according to planning chart.The table that waiting is relevant comprises Advertisement arrangement master meter (AdPlan), Advertisement arrangement relevant information table (AdPlanInfo) and Advertisement arrangement release time table (AdPlanDate).More than three tables be major key all with the Advertisement arrangement id field.Advertisement arrangement master meter (AdPlan) is associated with advertisement table (Advertisement) by the AdID field, wherein advertisement broadcasting time field (TotalNum) and watch that the initial value of time digital section (HaveShowTimes) is 0.Each list structure is as follows:
Advertisement arrangement master meter [AdPlan]
Field name | Data type | Explain |
AdPlanID | Int | Advertisement arrangement ID |
AdID | Int | The advertisement ID of Advertisement arrangement correspondence |
TotalNum | Int | The advertisement broadcasting time that waiting is thrown in |
CreateTime | Datetime | Creation-time |
Apply | Bit | Whether this waiting is effective |
HaveShowTimes | Int | Watching several times |
ShowMode | tinyint | The broadcast form |
Advertisement arrangement relevant information table [AdPlanInfo]
Field name | Data type | Explain |
AdPlanID | Int | Advertisement arrangement ID |
CPID | Varchar(2000) | The CP that Advertisement arrangement is thrown in |
PgTypeID | Varchar(2000) | The channel that Advertisement arrangement is thrown in |
ShowTime | Varchar(2000) | The period that Advertisement arrangement is thrown in |
ShowRegion | Varchar(2000) | The area that Advertisement arrangement is thrown in |
Advertisement arrangement release time table [AdPlanDate]
Field name | Data type | Explain |
AdPlanID | Int | Advertisement arrangement ID |
StartDate | Datetime | Start Date |
endDate | Datetime | Close Date |
C. advertisement playing flow
Shown in accompanying drawing 6, specify the situation of each flow process below:
1. the user sends a VOD program request.
2. after media is received the VOD order request, transmit media sign (CPID) and media program category sign parameters such as (CPPgTypeID) to system, the former is the unique identification that is assigned to each media, the latter is the unique identification of each program category, such as, program category comprises: video display, life, physical culture, amusement, news ... Deng the corresponding code 101,102 of difference ...
3. after the above-mentioned sign that receives transmission, system will return a correspondent advertisement interface (system returns the advertisement interface procedure and sees Fig. 5), and media calls this interface, and give Adurl with this interface assignment, and give url with the broadcast address assignment of own program.And two players (Adurl, url are two self-defining General Parameters, are used for depositing respectively advertisement broadcast address and playing programs address, can define separately) are set for advertisement and program respectively.
4. judge whether the advertisement interface IP address Adurl return is empty,,, then enter step 6. if be sky if for sky then carry out step 5..
5. each media can be provided with an advertisement latency value according to the situation of oneself, and general recommendations is the arbitrary value between 8 seconds to 12 seconds.If surpass the stand-by period, Adurl also is empty, then illustrates in this time and can not get advertising address, then play-overs program (when some special circumstances are got less than advertisement, can influence the user and watch program like this).If got advertisement in the stand-by period, promptly Adurl is not empty, then changes step over to 6..
6. start the advertisement player, begin to play advertisement.
7. after advertisement begins to play, start show player and begin the program buffering, advertisement is play and is not finished if the program buffering finishes, and then program is put halted state, carries out 8. playing programs of step after waiting advertisement to finish.Play end if the program buffering finishes the back advertisement, then directly carried out 8. broadcast program of step.
8. broadcast program.
The advertisement interface that substep among the step c is mentioned in 3. can obtain by following process (referring to Fig. 5): behind user's program request VOD program, system obtains the parameter that the user transmits and comprises information such as media communication, program category, User IP, user COOKIE and city, place.At first, queries ad waiting relevant information table (AdPlanInfo) is thrown in CP (CPID) and input channel (PgTypeID) according to media communication and program category coupling, returns eligible set of records ends, and record of random choose therefrom.Then according to the Advertisement arrangement id field (AdPlanID) of this record, queries ad waiting master meter (AdPlan), obtain the ID (AdID) of advertisement, according to AdID field queries ad table (Advertisement), judge whether this advertisement meets the region and throw in condition, if do not meet then return address blank, otherwise queries ad is watched log recording table (AdVusitLog), adds up the number of times that this user watches this advertisement.If accumulative total is watched number of times smaller or equal to the value of throwing in frequency N+ (NPlus), then meet and throw in frequency control, return the interface IP address (LinkUrl) of this advertisement, otherwise return address blank.
D. write down advertisement putting information
After advertisement finishes, upgrade Advertisement arrangement master meter (AdPlan), the advertisement broadcasting time field (TotalNum) that this advertisement ID (AdID) is corresponding and watch that the value of inferior digital section (HaveShowTimes) adds 1 respectively.Then information such as the ID (AdID) of this advertisement, media sign (CPID), the program category of throwing in (CPPgTypeID) and user's relevant parameter (IP, watch time, city, place etc.) are write advertisement and watch log recording table (AdVusitLog), this list structure is as follows:
Log recording table [AdVusitLog] is watched in advertisement
Field name | Data type | Explain |
AdVisitLogID | Bigint | The ad log Record ID |
AdID | Int | The advertisement ID that watches |
Cookie | Varchar(50) | Watch people's COOKIE |
IP | Varchar(20) | Watch people's IP |
CreateTime | Datetime | Watch the time of advertisement |
CPID | Int | Watch that the people is the advertisement of seeing from which CP |
CPPgTypeID | Smallint | The advertisement of watching by which program category is seen |
ShowMode | Tinyint | Watch pattern, head still are run-out or other |
CityID | int | Watch people's location, city |
By inquiring about this table, can add up each advertisement the program request number and person-time, and can be by media, by the region, on a time period, press channel and analyze the advertising-on-demand situation, thereby the adjustment Advertisement arrangement is offered help.
Definition:
CP:Content Provider is meant the general designation that is linked into each content supplier (wideband website or video software) of a little looking advertisement delivery system.
CPID: media sign (looking the unique identification that is assigned to each media by point).
CPPgTypeID: media program category sign (unique identification of each program category, look offer tabulation of each media by point).
Throw in control, promptly the input of advertisement carried out the control of N+, region, period and channel, comprising:
Throw in the frequency (N+) control: an advertisement is no more than N time by same spectators' the number of times of watching, and promptly these spectators watch the number of times<=N of advertisement.
Region control: can be according to spectators' region, place control advertisement putting.That is to say that the advertisement that the spectators of different regions watch same program to see at one time may be different.
Period control: can control to the little period of advertisement putting, promptly begin until what time to finish from some.
Channel control: determine the control of advertisement putting according to programme content.The advertisement that different program channels is thrown in may be inconsistent.