CN107995266A - Bury point data processing method, device, computer equipment and storage medium - Google Patents

Bury point data processing method, device, computer equipment and storage medium Download PDF

Info

Publication number
CN107995266A
CN107995266A CN201711173043.XA CN201711173043A CN107995266A CN 107995266 A CN107995266 A CN 107995266A CN 201711173043 A CN201711173043 A CN 201711173043A CN 107995266 A CN107995266 A CN 107995266A
Authority
CN
China
Prior art keywords
advertisement
identifier
terminal
point data
statistical
Prior art date
Application number
CN201711173043.XA
Other languages
Chinese (zh)
Inventor
江彬
陈晓夫
Original Assignee
平安科技(深圳)有限公司
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 平安科技(深圳)有限公司 filed Critical 平安科技(深圳)有限公司
Priority to CN201711173043.XA priority Critical patent/CN107995266A/en
Publication of CN107995266A publication Critical patent/CN107995266A/en

Links

Classifications

    • 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
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/06Network-specific arrangements or communication protocols supporting networked applications adapted for file transfer, e.g. file transfer protocol [FTP]
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/20Network-specific arrangements or communication protocols supporting networked applications involving third party service providers
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network-specific arrangements or communication protocols supporting networked applications
    • H04L67/34Network-specific arrangements or communication protocols supporting networked applications involving the movement of software or configuration parameters

Abstract

This application involves one kind to bury point data processing method, device, computer equipment and storage medium, the described method includes:What receiving terminal uploaded buries point data;The point data of burying is parsed, obtains json data;A little corresponding ad identifier is buried in the json extracting datas terminal iidentification, and with default advertisement;The terminal iidentification in preset time period and the ad identifier are counted, obtain the statistical magnitude of terminal iidentification and the statistical magnitude of ad identifier;Using the statistical magnitude of the terminal iidentification rate is reported with the corresponding advertisement of statistical magnitude calculating of the ad identifier.Extracted using this method in magnanimity buries point data and effectively bury point data, dispensing effect of the advertisement in preset time is analyzed with this.

Description

Bury point data processing method, device, computer equipment and storage medium

Technical field

This application involves field of computer technology, buries point data processing method, device, computer more particularly to one kind and sets Standby and storage medium.

Background technology

Burying in APP (Application, application program) can gather when being a little triggered buries point data accordingly, buries a little Data can reflect user behavior.During by launching advertisement in APP, in APP corresponding advertisement can be set to bury a little.By to wide Accuse the point data of burying buried a little to be analyzed, operation personnel can be caused to understand the dispensing effect of advertisement.Would generally be set in APP compared with More buries a little, and each burying after being a little triggered can have corresponding point data of burying to be uploaded to backstage.If all set in a variety of APP Advertisement is buried a little, and backstage receives the magnanimity that a variety of APP are uploaded and buries point data at the same time, then how effectively to be buried point data The dispensing effect of analysis advertisement becomes a technical problem to need to solve at present.

The content of the invention

Based on this, it is necessary to for above-mentioned technical problem, there is provided one kind can extract effectively in magnanimity buries point data Bury point data, bury point data processing method, device, the computer that dispensing effect of the advertisement in preset time is analyzed with this are set Standby and storage medium.

One kind buries point data processing method, including:

What receiving terminal uploaded buries point data;

The point data of burying is parsed, obtains json data;

A little corresponding ad identifier is buried in the json extracting datas terminal iidentification, and with default advertisement;

The terminal iidentification in preset time period and the ad identifier are counted, obtain the system of terminal iidentification The statistical magnitude of count number and ad identifier;

Using the statistical magnitude of the terminal iidentification with the corresponding advertisement of statistical magnitude calculating of the ad identifier Report rate.

In one of the embodiments, it is described in the json extracting datas terminal iidentification, and with default advertisement The step of burying a little corresponding advertisement and identifier includes:

Multiple parameters in the json data are traveled through, extraction represents the parameter value of terminal, obtains corresponding end End mark;

Judge whether to occur default advertisement using the json data and bury a little corresponding to bury an event;

If so, then representing the parameter value of advertisement in the json extracting datas, corresponding ad identifier is obtained.

In one of the embodiments, in the terminal iidentification in preset time period and the ad identifier Before the step of being counted, further include:

The terminal iidentification of extraction is sent to redis corresponding with terminal and is gathered, passes through the redis corresponding with terminal Set carries out duplicate removal to the terminal iidentification;

The ad identifier of extraction is sent to redis corresponding with advertisement and is gathered, by described corresponding with advertisement Redis set carries out duplicate removal to the ad identifier.

In one of the embodiments, the point data of burying is stored in multiple source datas storehouse;The method further includes:

Multiple field names are obtained in target database, SQL statement is generated using the field name;The field name includes Advertising theme and ad identifier;

Extracted using the SQL statement in the source database and bury point data accordingly;

The point data of burying extracted is write in target database according to the field name;

The statistical magnitude of the ad identifier is calculated according to the advertising theme in the target database.

In one of the embodiments, the method further includes:

The statistical log renewal request that receiving terminal is sent, application program is carried in the renewal request of the statistical log Mark;

According to application program identification inquiry with the presence or absence of the statistical log after renewal, wrapped in the daily record after the statistics Include renewal after advertisement bury a little with corresponding page iden-tity;

If depositing statistical log in the updated, the statistical log after the renewal is back to terminal;When the page The advertisement after renewal in mark is buried when being a little triggered, obtain it is corresponding buries point data, bury point data described in upload;

Using the advertisement after renewal bury a little it is corresponding bury point data calculate renewal after the corresponding advertisement of advertisement report rate.

One kind buries dot data processing device, and described device includes:

Communication module, point data is buried for what receiving terminal uploaded;

Parsing module, for being parsed to the point data of burying, obtains json data;In the json extracting datas Terminal iidentification, and bury a little corresponding ad identifier with default advertisement;

Statistical module, for being counted to the terminal iidentification in preset time period and the ad identifier, obtains To the statistical magnitude of terminal iidentification and the statistical magnitude of ad identifier;Using the terminal iidentification statistical magnitude with it is described wide The corresponding advertisement of statistical magnitude calculating for accusing identifier reports rate.

In one of the embodiments, the parsing module is additionally operable to the multiple parameters progress time in the json data Go through, extraction represents the parameter value of terminal, obtains corresponding terminal iidentification;Judge whether to occur using the json data default Advertisement, which is buried, a little corresponding buries an event;If so, then representing the parameter value of advertisement in the json extracting datas, obtain corresponding Ad identifier.

In one of the embodiments, the communication module is additionally operable to the statistical log renewal request of receiving terminal transmission, Application program identification is carried in the renewal request of the statistical log;

Described device further includes:

Enquiry module, for whether there is the statistical log after renewal, the system according to application program identification inquiry Daily record after meter include renewal after advertisement bury a little with corresponding page iden-tity;

If the communication module is additionally operable to deposit statistical log in the updated, the statistical log after the renewal is returned To terminal;When the advertisement after the renewal in the page iden-tity, which is buried, to be a little triggered, obtain it is corresponding bury point data, described in upload Bury point data;

The statistical module be additionally operable to using the advertisement after renewal bury a little it is corresponding bury point data calculate renewal after advertisement Corresponding advertisement reports rate.

A kind of computer equipment, including memory, processor and storage can be run on a memory and on a processor The step of computer program, the processor realizes any of the above-described method when performing the computer program.

A kind of computer-readable recording medium, is stored thereon with computer program, and the computer program is held by processor The step of any of the above-described method is realized during row.

Above-mentioned to bury point data processing method, device, computer equipment and storage medium, burying point data can be passed through by terminal Application program uploads, and by being parsed to burying point data, can obtain json data, then extracts terminal using json data Identify and bury a little corresponding ad identifier with default advertisement.By to the terminal iidentification in preset time period and described Ad identifier is counted, and obtains the statistical magnitude of terminal iidentification and the statistical magnitude of ad identifier, so as to utilize The statistical magnitude of the terminal iidentification reports rate with the corresponding advertisement of statistical magnitude calculating of the ad identifier.Terminal iidentification Statistical magnitude can be reflected in the situation of enlivening of application program in preset time, i.e. user uses the situation of application program.Extensively The situation that advertisement is clicked can be reflected by accusing the statistical magnitude of identifier.It is possible thereby to it is pre- to enable advertisement to report rate to be reflected in If user clicks on the ratio of advertisement when using application program in the time.It is achieved thereby that extracted in magnanimity buries point data Effect buries point data to analyze dispensing effect of the advertisement in preset time.Advertisement is understood in preset time for operation personnel Effect is launched to provide a convenient.

Brief description of the drawings

Fig. 1 is the application scenario diagram that point data processing method is buried in one embodiment;

Fig. 2 is the flow chart that point data processing method is buried in one embodiment;

Fig. 3 is the block diagram that dot data processing device is buried in one embodiment;

Fig. 4 is the block diagram of one embodiment Computer equipment.

Embodiment

It is with reference to the accompanying drawings and embodiments, right in order to which the object, technical solution and advantage of the application are more clearly understood The application is further elaborated.It should be appreciated that specific embodiment described herein is only to explain the application, not For limiting the application.

The application provides and buries point data processing method, can be applied in application environment as shown in Figure 1.Terminal 102 is logical Network is crossed to be communicatively coupled with server 104.One or more application program is mounted with terminal 102.It is pre- in application program First be provided with bury a little, when bury a little triggered by user when, application program acquisition bury point data accordingly, point data will be buried and be uploaded to clothes Business device 104.It can be buried a little including advertisement in burying a little.In one application program one or more advertisements can be set to bury a little.Service Device 104 receive terminal 102 upload bury point data after, point data will be buried and stored into database.Server 104 is in data Parsed in storehouse to burying point data, obtain timestamp and json data etc..Json data include multiple parameters.Server 104 extract terminal iidentification in json data.When advertisement, which is buried, to be a little triggered, server 104 can also be in json extracting datas Ad identifier.Server 104 extracts terminal iidentification and ad identifier in preset time period according to timestamp, to it is default when Between terminal iidentification in section and ad identifier counted, obtain the statistical magnitude of terminal iidentification and the statistics of ad identifier Quantity.Server 104 is reported using the statistical magnitude of terminal iidentification with the corresponding advertisement of statistical magnitude calculating of ad identifier Rate.Point data effectively is buried to analyze dispensing of the advertisement in preset time it is achieved thereby that being extracted in magnanimity buries point data Effect.

In one embodiment, as shown in Figure 2, there is provided one kind buries point data processing method, in this way applied to Fig. 1 In server exemplified by illustrate, specifically include following steps:

Step 202, what receiving terminal uploaded buries point data.

Application program is mounted with terminal.Pre-set in application program bury a little, when bury a little triggered by user when, application Program obtains and buries point data accordingly, will bury point data and uploads onto the server.Wherein, bury a little include control, input frame, picture or Video etc..It can be buried a little including advertisement in burying a little.In one application program one or more advertisements can be set to bury a little.It is one wide Announcement, which buries, can a little represent an advertisement.Multiple advertisements, which are buried, can a little represent different advertisements, can also represent same advertisement.Eventually Multiple application programs can be installed on end, advertisement can be set to bury a little in each application program.It is wide in different application Announcement, which buries, can a little represent different advertisements, can also represent same advertisement.

Step 204, parsed to burying point data, obtain json data.

Step 206, in json extracting data terminal iidentifications, and with default advertisement a little corresponding advertisement and identifier is buried Symbol.

Server receive terminal upload bury point data after, point data will be buried and stored into database.Database can To be non-relational database, for example, SSDB databases.Server can be single server or server set Group.Point data is buried when the corresponding multiple terminals of a variety of application programs upload, server set can be randomized to either by burying point data Stored in some server in group.

Server is parsed to burying point data in the database.Specifically, server according to budget separator to burying a little Data are split, and some, including timestamp, terminal IP and json data etc. can be divided into by burying point data.Its In, json data are a huge arrays, including multiple parameters, for example, representing the parameter of terminal, represent the parameter of advertisement Deng.

In one of the embodiments, in json extracting data terminal iidentifications, and bury with default advertisement corresponding Advertisement and identifier the step of include:Multiple parameters in json data are traveled through, extraction represents the parameter value of terminal, obtains Corresponding terminal iidentification;Judge whether to occur default advertisement using json data and bury a little corresponding to bury an event;If so, then The parameter value of advertisement is represented in json extracting datas, obtains corresponding ad identifier.

Server in the database travels through each json data, identifies each parameter in json data.In table Show and corresponding parameter value is extracted in the parameter of terminal, obtain corresponding terminal iidentification.If exist in json data and represent advertisement Parameter, and corresponding parameter value is not sky, it is determined that is buried there occurs advertisement and a little corresponding buries an event, you can to determine extensively Announcement, which buries, to be a little triggered.Server extracts ad identifier in the parameter for representing advertisement, obtains the corresponding value of ad identifier.Its In, advertisement, which is buried advertisement a little corresponding with advertisement and identifier, different and buried, can a little correspond to different advertisement and identifiers, can also correspond to phase Same advertisement and identifier.When definite advertisement, which is buried, to be a little triggered, server obtains default advertisement and identifier, according to default advertisements Knowledge is judged burying an event.Specifically, including advertisement and identifier in json data in the parameter of expression advertisement, server will The corresponding advertisement and identifier of an event is buried compared with default advertisement and identifier, if identical, then it represents that it is default that this, which buries an event, Advertisement bury and a little corresponding bury an event.Otherwise, it is not that a little corresponding bury a little is buried in default advertisement to represent that this buries an event Event.

Further, terminal type is further included in json data, terminal type can be according to the operating system of terminal come area Point, including iOS (Mobile operating system of Apple Inc.) OS Type (being referred to as the first kind) and Android (Android) OS Type (being referred to as Second Type).Different terminal types can have different ad identifiers. For example, the ad identifier of iOS OS Types can be IDFA (being referred to as the first ad identifier).Android The ad identifier of OS Type can be Imei (can also become the second ad identifier).Server can also basis Terminal type is respectively in json extracting data terminal iidentifications.When definite default advertisement, which is buried, to be a little triggered, server may be used also To extract corresponding ad identifier according to terminal type.

If a different advertisement of expression is buried in default multiple advertisements, server can also be in the expression in json data Advertising theme is extracted in the parameter of advertisement.Different terminal iidentifications can correspond to different advertising themes, different terminal iidentifications Corresponding advertising theme can also be corresponded to.

Step 208, the terminal iidentification in preset time period and ad identifier are counted, obtains the system of terminal iidentification The statistical magnitude of count number and ad identifier.

Step 210, using the statistical magnitude of terminal iidentification with the corresponding advertisement of statistical magnitude calculating of ad identifier Report rate.

Server extracts terminal iidentification and ad identifier in preset time according to timestamp, to the end in preset time End mark and ad identifier are counted, and respectively obtain the statistical magnitude of terminal iidentification and the statistical magnitude of ad identifier. Preset time can be one day or one week or one month etc..The statistical magnitude of server by utilizing ad identifier divided by The statistical magnitude of terminal iidentification, is calculated default advertisement and buries a little corresponding advertisement and report rate.Thus facilitate operation personnel overall The upper dispensing effect for understanding advertisement.

If a different advertisement of expression is buried in default advertisement, then server can also be obtained according to advertising theme and corresponded to The statistical magnitude of terminal iidentification and the statistical magnitude of ad identifier.Server can utilize terminal mark according to advertising theme The statistical magnitude of knowledge and the statistical magnitude of ad identifier calculate the corresponding advertisement of each advertising theme and report rate respectively.

In one of the embodiments, this method further includes:In json extracting data terminal types;According to terminal type Terminal iidentification in preset time period and ad identifier are counted, obtain the end after statistics corresponding with terminal type Ad identifier after end mark and statistics;Utilize the terminal iidentification after the corresponding statistics of terminal type and the advertisements after statistics Know symbol calculating advertisement corresponding with terminal type and report rate.

Server can also count the terminal iidentification of the first kind, obtain the statistics of the terminal iidentification of the first kind Quantity.Server can also count the ad identifier of the first kind, obtain the ad identifier statistics of the first kind Quantity.The statistical magnitude of the ad identifier statistical magnitude of the server by utilizing first kind and the terminal iidentification of the first kind, meter The advertisement that calculation obtains the first kind reports rate, that is, the advertisement for obtaining iOS OS Types reports rate.It is possible thereby to convenient operation Personnel understand the advertisement delivery effect in the terminal device of iOS operating systems.

Server can also count the terminal iidentification of Second Type, obtain the statistics of the terminal iidentification of Second Type Quantity.Server can also count the ad identifier of Second Type, obtain the ad identifier statistics of Second Type Quantity.The statistical magnitude of the ad identifier statistical magnitude of server by utilizing Second Type and the terminal iidentification of Second Type, meter The advertisement that calculation obtains Second Type reports rate, that is, the advertisement for obtaining Android operation system type reports rate.It is it is possible thereby to convenient Operation personnel understands the advertisement delivery effect in the terminal device of Android operation system.

Further, if a different advertisement of expression is buried in default advertisement, then server can also be according to advertiser Topic, the advertisement for calculating the first kind respectively report the advertisement of rate and Second Type to report rate.It is possible thereby to further facilitate operation Personnel understand, and advertisement delivery effect of each advertising theme in the terminal device of iOS operating systems and are operated in Android Advertisement delivery effect in the terminal device of system.

In the present embodiment, burying point data can be uploaded by terminal by application program, by being parsed to burying point data, Json data can be obtained, then terminal iidentification is extracted using json data and buries a little corresponding advertisement with default advertisement Identifier.By being counted to the terminal iidentification in preset time period and ad identifier, the statistical number of terminal iidentification is obtained The statistical magnitude of amount and ad identifier, so as to utilize the statistical magnitude of the statistical magnitude of terminal iidentification and ad identifier Calculate corresponding advertisement and report rate.What the statistical magnitude of terminal iidentification can be reflected in application program in preset time enlivens feelings Condition, i.e. user use the situation of application program.The statistical magnitude of ad identifier can reflect the situation that advertisement is clicked.Thus Advertisement can be enabled to report rate to be reflected in the ratio that user in preset time clicks on advertisement when using application program.So as to Realize to extract in magnanimity buries point data and effectively bury point data to analyze dispensing effect of the advertisement in preset time.For Operation personnel understands dispensing effect of the advertisement in preset time and provides a convenient.

In one embodiment, the step of terminal iidentification in preset time period and ad identifier count it Before, further include:The terminal iidentification of extraction is sent to redis corresponding with terminal and is gathered, passes through redis collection corresponding with terminal Close and duplicate removal is carried out to terminal iidentification;By the ad identifier of extraction send to redis corresponding with advertisement gather, by with advertisement Corresponding redis set carries out duplicate removal to ad identifier.

Would generally be set in application program it is more bury a little, and it is generally only a little one kind in numerous bury a little that advertisement, which is buried,.Often It is a to bury burying point data and parse to obtain terminal iidentification a little.And some are buried may a little be repeated triggering, so that in advance If there may be a certain number of repetitions for the terminal iidentification in the time.And bury a little may also be default for advertisement in preset time Repeatedly it is triggered in time, there are a certain number of repetitions for the ad identifier that can also cause in preset time.These can all make Obtain advertisement and report the not accurate enough of rate calculating.

Rate is reported for terrible more accurate advertisement, server, will after point data is buried to each and is parsed The terminal iidentification of extraction is sent into redis corresponding with terminal set, and terminal iidentification is carried out with will pass through redis set Duplicate removal processing.Server, which can also send the ad identifier of extraction to redis corresponding with advertisement, to be gathered, by this Redis set carries out duplicate removal to ad identifier.It is possible thereby to count to obtain terminal iidentification after the duplicate removal in preset time and Ad identifier.The statistical number of ad identifier after the statistical magnitude and duplicate removal of terminal iidentification after server by utilizing duplicate removal Amount, can be calculated the advertisement after duplicate removal and report rate.It is possible thereby to the accuracy that advertisement reports rate is improved, can be further true Reflect advertisement delivery effect on the spot.

Further, server can also be carried out at duplicate removal terminal iidentification and ad identifier according to terminal type respectively Reason.Specifically, the terminal iidentification of the first kind can be sent to the first redis set, gathered by the redis of the first kind Duplicate removal processing is carried out to the terminal iidentification of the first kind.The ad identifier of the first kind can be sent to the 2nd redis collection Close.Duplicate removal processing is carried out to the ad identifier of the first kind by the 2nd redis set.Server is gathered in the first redis In the terminal iidentification of the first kind after duplicate removal is counted, obtain the statistical number of the terminal iidentification of the first kind after duplicate removal Amount.Server counts the ad identifier of the first kind after duplicate removal in the 2nd redis set, after obtaining duplicate removal The statistical magnitude of the terminal identifier of the first kind.The statistical number of the terminal identifier of the first kind after server by utilizing duplicate removal The statistical magnitude of the terminal identifier of the first kind after amount and duplicate removal, calculates the advertisement after the corresponding duplicate removal of the first kind and reports Rate, that is, obtain the advertisement after the duplicate removal of iOS OS Types and report rate.Grasped it is possible thereby to facilitate operation personnel to understand in iOS Make the further accurate advertisement delivery effect in the terminal device of system.

The terminal iidentification of Second Type can be sent to the 3rd redis set, pass through the redis set pair of Second Type The terminal iidentification of Second Type carries out duplicate removal processing.The ad identifier of Second Type can be sent to the 4th redis set. Duplicate removal processing is carried out to the ad identifier of Second Type by the 3rd redis set.Server is right in the 3rd redis set The terminal iidentification of Second Type after duplicate removal is counted, and obtains the statistical magnitude of the terminal iidentification of the Second Type after duplicate removal. Server counts the ad identifier of the Second Type after duplicate removal in the 4th redis set, obtains the after duplicate removal The statistical magnitude of the terminal identifier of two types.The statistical magnitude of the terminal identifier of Second Type after server by utilizing duplicate removal With the statistical magnitude of the terminal identifier of the Second Type after duplicate removal, calculate the advertisement after the corresponding duplicate removal of Second Type and report Rate, that is, obtain the advertisement after the duplicate removal of Android operation system type and report rate.It is possible thereby to operation personnel is facilitated to understand Further accurate advertisement delivery effect in the terminal device of Android operation system.

Further, the dispensing effect of each advertisement is understood in order to facilitate operation personnel, server can also utilize wide Accuse theme with ad identifier to be spliced, spliced advertising theme and ad identifier are sent to corresponding with advertisement In redis set.Specifically, advertising theme can be spliced with the ad identifier of the first kind, by spliced first The ad identifier of type is stored in the 2nd redis set.Advertisements by the 2nd redis set to the spliced first kind Know symbol and carry out duplicate removal processing.In the manner described above, server can be calculated the advertisement of the spliced first kind and report rate. It is hereby achieved that the advertisement after each advertisement duplicate removal of iOS OS Types reports rate.People is runed so as to convenient Effect is accurately launched in each advertisement that member is understood in the terminal device of iOS operating systems.

Advertising theme can be spliced with the ad identifier of Second Type, by the advertisements of spliced Second Type Know symbol deposit the 4th redis set.Duplicate removal is carried out to the ad identifier of spliced Second Type by the 4th redis set Processing.In the manner described above, server can be calculated the advertisement of spliced Second Type and report rate.It is hereby achieved that Advertisement after each advertisement duplicate removal of Android operation system type reports rate.So as to facilitate operation personnel to understand Effect is accurately launched in each advertisement in the terminal device of Android operation system.

In one embodiment, bury point data and be stored in multiple source datas storehouse, method further includes:Obtained in target database Multiple field names are taken, SQL statement is generated using field name;Field name includes advertising theme and ad identifier;Utilize SQL statement Extraction buries point data accordingly in source database;The point data of burying extracted is write in target database according to field name; The statistical magnitude of ad identifier is calculated according to advertising theme in target database.

In the present embodiment, in addition to it can calculate advertisement and report rate, total click volume of every advertisement can also be counted.When When all being buried there is provided advertisement in a variety of application programs, the point data of burying that advertisement can be buried a little by a variety of application programs is uploaded to clothes Business device.Server can be server cluster, server cluster receive that a variety of application programs upload when burying point data, can be with Stored burying in some server that point data is assigned randomly in server cluster.Each in server cluster Server can dispose corresponding database, and such as SSDB databases, this database is referred to as source database.Multiple sources Stored in database and largely bury point data.When server needs total click volume to each advertisement in preset time period When being counted, target database is established in a wherein server that can be in its server cluster.In target database Tables of data can be pre-established.Tables of data includes multiple fields.Each field has corresponding field name, including advertiser Topic, ad identifier and timestamp etc..Server obtains multiple field names in target database, and SQL is generated using field name Sentence.Server by utilizing SQL statement extracts in source database buries point data accordingly, obtains multiple advertising themes and advertisements Know symbol.Server writes the multiple advertising themes and ad identifier extracted in target database according to field name.Service Device counts the advertising theme in target database and advertisement and identifier according to timestamp respectively.Specifically, server is in mesh Mark to obtain in database and read the corresponding timestamp of each advertisement symbol, according to timestamp and preset time period extraction and advertising theme Corresponding ad identifier, the quantity of the corresponding ad identifier of each advertising theme to extracting count respectively. It is hereby achieved that total click volume of the every advertisement in preset time period.

In one embodiment, method further includes:The statistical log renewal request that receiving terminal is sent, statistical log is more Application program identification is carried in new request;According to application program identification inquiry with the presence or absence of the statistical log after renewal, statistics Daily record afterwards include renewal after advertisement bury a little with corresponding page iden-tity;, will more if depositing statistical log in the updated Statistical log after new is back to terminal;When the advertisement after the renewal in page iden-tity, which is buried, to be a little triggered, corresponding bury is obtained Point data is buried in point data, upload;Using the advertisement after renewal bury a little it is corresponding bury point data calculate renewal after advertisement it is corresponding Advertisement reports rate.

Application program is mounted with terminal in advance.After application program installation, daily record can locallyd create.Daily record includes fixed Position daily record and statistical log., can be in terminal local record location daily record when application program is run.Positioning daily record can be used for should With the fault location of program.It can include multiple bury a little and corresponding page iden-tity in statistical log.Can be with by statistical log User behavior is counted.Application program has multiple business functions.Business function is independent of one another with daily record, is not bound. It can set in application program and be buried a little with the relevant advertisement of business function.

Advertisement is buried can a little update at any time.When terminal starts application program, statistical log renewal can be sent to server Request.Or application program, when being switched to running background, terminal can send statistical log renewal request to server.Service Device receives the request, according to the requesting query with the presence or absence of the statistical log after renewal.Statistical log after renewal can be clothes Business device buries what is a little generated with corresponding page iden-tity according to the advertisement after renewal.Server is by the statistics day after the renewal inquired Will is back to terminal.Terminal receives the statistical log after renewal.Terminal utilizes the statistical log after renewal and local statistical log Generate current statistical log.

When the advertisement after renewal, which is buried, to be a little triggered, terminal can obtain buries point data accordingly, will bury point data upload To server.The advertisement that server can calculate after renewal in the way of being provided in above-described embodiment is buried a little in corresponding advertisement Report rate.It is hereby achieved that advertisement of the advertisement after renewal in preset time period reports rate.Can also be according to above-described embodiment The mode of middle offer calculates total click volume of the advertisement in preset time period after renewal.

In the present embodiment, when advertisement updates, advertisement is buried when a little can accordingly update, server can to statistical log into Row renewal.After statistical log after renewal returns to terminal, it is wide after updating that terminal can utilize the statistical log after renewal to gather The trigger event buried a little is accused, is uploaded onto the server point data is buried accordingly.It is possible thereby to so that server be calculated it is default The corresponding advertisement of advertisement in period after renewal reports rate and total click volume etc..After operation personnel can be caused to understand renewal Advertisement dispensing effect.In whole process, it is not necessary to application program carry out edition upgrading, by statistical log more Newly, you can with the dispensing effect of the advertisement after understanding renewal at any time of more newly arriving of advertisement.

As shown in figure 3, present invention also provides one kind to bury dot data processing device.In one embodiment, the device bag Include:Communication module 302, parsing module 304 and statistical module 306, each module can be by software, hardware or its combinations come real It is existing.Wherein:

Communication module 302, point data is buried for what receiving terminal uploaded.

Parsing module 304, for being parsed to burying point data, obtains json data;In json extracting data terminals Mark, and bury a little corresponding ad identifier with default advertisement.

Statistical module 306, for being counted to the terminal iidentification in preset time period and ad identifier, obtains terminal The statistical magnitude of mark and the statistical magnitude of ad identifier;Utilize the statistical magnitude of terminal iidentification and the statistics of ad identifier Quantity calculates corresponding advertisement and reports rate.

In one of the embodiments, parsing module 304 is additionally operable to travel through the multiple parameters in json data, carries The parameter value for representing terminal is taken, obtains corresponding terminal iidentification;Judge whether that default advertisement, which occurs, buries a little using json data Corresponding buries an event;If so, then representing the parameter value of advertisement in json extracting datas, corresponding advertisement and identifier is obtained Symbol.

Communication module is additionally operable to the statistical log renewal request of receiving terminal transmission in one embodiment, statistical log Application program identification is carried in renewal request;The device further includes:Enquiry module, for being according to application program identification inquiry The no statistical log deposited in the updated, the advertisement that the daily record after statistics is included after renewal bury a little with corresponding page iden-tity;It is logical If letter module is additionally operable to deposit statistical log in the updated, the statistical log after renewal is back to terminal;Work as page iden-tity In renewal after advertisement bury when being a little triggered, obtain it is corresponding buries point data, point data is buried in upload;

Statistical module be additionally operable to using the advertisement after renewal bury a little it is corresponding bury point data calculate renewal after advertisement correspond to Advertisement report rate.

In one embodiment, which further includes:Deduplication module, for by the terminal iidentification of extraction send to terminal Corresponding redis set, duplicate removal is carried out by redis corresponding with terminal set to terminal iidentification;By the advertisement and identifier of extraction Symbol, which is sent to redis corresponding with advertisement, to be gathered, and duplicate removal is carried out to ad identifier by redis corresponding with advertisement set.

In one embodiment, bury point data and be stored in multiple source datas storehouse, which further includes synchronization module, for Multiple field names are obtained in target database, SQL statement is generated using field name;Field name includes advertising theme and advertisement and identifier Symbol;Extracted using SQL statement in source database and bury point data accordingly;The point data of burying extracted is write according to field name In target database;Statistical module is additionally operable to calculate the statistical number of ad identifier according to advertising theme in target database Amount.

The above-mentioned dot data processing device that buries can be implemented as a kind of form of computer program, and computer program can be such as Run in computer equipment shown in Fig. 4.Wherein, computer equipment can be a kind of server.Server can be independent clothes Business device or cluster server.

In one embodiment, there is provided a kind of computer equipment, such as server, as shown in figure 4, the computer equipment bag Include processor, memory and the network interface connected by system bus.Wherein, the processor of the computer equipment is used to provide Calculating and control ability.The memory of the computer equipment includes non-volatile memory medium, built-in storage.The computer equipment Non-volatile memory medium be stored with operating system, database and and computer program.The built-in storage of the computer equipment Environment is provided for the operating system in non-volatile memory medium and the operation of computer program.Stored in database and bury points According to.The network interface of the computer equipment is used to communicate by network connection with exterior terminal.The computer program is processed To realize that one kind buries point data processing method when device performs.It will be understood by those skilled in the art that the structure shown in Fig. 4, only Only it is the block diagram with the relevant part-structure of application scheme, does not form the computer being applied thereon to application scheme The restriction of equipment, specific computer equipment can be included than more or fewer components shown in figure, or some portions of combination Part, or arranged with different components.

In one embodiment, there is provided a kind of computer equipment, including memory, processor and storage are on a memory And the computer program that can be run on a processor, processor realize following steps when performing computer program:

What receiving terminal uploaded buries point data;

Parsed to burying point data, obtain json data;

A little corresponding ad identifier is buried in json extracting data terminal iidentifications, and with default advertisement;

Terminal iidentification in preset time period and ad identifier are counted, obtain terminal iidentification statistical magnitude and The statistical magnitude of ad identifier;

Using the statistical magnitude of terminal iidentification rate is reported with the corresponding advertisement of statistical magnitude calculating of ad identifier.

In one embodiment, following steps are also realized when processor performs computer program:

Multiple parameters in json data are traveled through, extraction represents the parameter value of terminal, obtains corresponding terminal mark Know;

Judge whether to occur default advertisement using json data and bury a little corresponding to bury an event;

If so, then representing the parameter value of advertisement in json extracting datas, corresponding ad identifier is obtained.

In one embodiment, following steps are also realized when processor performs computer program:

The terminal iidentification of extraction is sent to redis corresponding with terminal and is gathered, is gathered by redis corresponding with terminal Duplicate removal is carried out to terminal iidentification;

The ad identifier of extraction is sent to redis corresponding with advertisement and is gathered, passes through redis collection corresponding with advertisement Close and duplicate removal is carried out to ad identifier.

In one embodiment, bury point data and be stored in multiple source datas storehouse, processor goes back reality when performing computer program Existing following steps:

Multiple field names are obtained in target database, SQL statement is generated using field name;Field name includes advertising theme And ad identifier;

Extracted using SQL statement in source database and bury point data accordingly;

The point data of burying extracted is write in target database according to field name;

The statistical magnitude of ad identifier is calculated according to advertising theme in target database.

In one embodiment, following steps are also realized when processor performs computer program:

The statistical log renewal request that receiving terminal is sent, application program mark is carried in the renewal request of statistical log Know;

According to application program identification inquiry with the presence or absence of the statistical log after renewal, the daily record after statistics is included after updating Advertisement bury a little and corresponding page iden-tity;

If depositing statistical log in the updated, the statistical log after renewal is back to terminal;When in page iden-tity Advertisement after renewal is buried when being a little triggered, obtain it is corresponding buries point data, point data is buried in upload;

Using the advertisement after renewal bury a little it is corresponding bury point data calculate renewal after the corresponding advertisement of advertisement report rate.

In one embodiment, there is provided a kind of computer-readable recording medium, is stored thereon with computer program, calculates Machine program realizes following steps when being executed by processor:

What receiving terminal uploaded buries point data;

Parsed to burying point data, obtain json data;

A little corresponding ad identifier is buried in json extracting data terminal iidentifications, and with default advertisement;

Terminal iidentification in preset time period section and ad identifier are counted, obtain the statistical magnitude of terminal iidentification With the statistical magnitude of ad identifier;

Using the statistical magnitude of terminal iidentification rate is reported with the corresponding advertisement of statistical magnitude calculating of ad identifier.

In one embodiment, following steps are also realized when computer program is executed by processor:

Multiple parameters in json data are traveled through, extraction represents the parameter value of terminal, obtains corresponding terminal mark Know;

Judge whether to occur default advertisement using json data and bury a little corresponding to bury an event;

If so, then representing the parameter value of advertisement in json extracting datas, corresponding ad identifier is obtained.

In one embodiment, following steps are also realized when computer program is executed by processor:

The terminal iidentification of extraction is sent to redis corresponding with terminal and is gathered, is gathered by redis corresponding with terminal Duplicate removal is carried out to terminal iidentification;

The ad identifier of extraction is sent to redis corresponding with advertisement and is gathered, passes through redis collection corresponding with advertisement Close and duplicate removal is carried out to ad identifier.

In one embodiment, bury point data and be stored in multiple source datas storehouse, when computer program is executed by processor also Realize following steps:

Multiple field names are obtained in target database, SQL statement is generated using field name;Field name includes advertising theme And ad identifier;

Extracted using SQL statement in source database and bury point data accordingly;

The point data of burying extracted is write in target database according to field name;

The statistical magnitude of ad identifier is calculated according to advertising theme in target database.

In one embodiment, following steps are also realized when computer program is executed by processor:

The statistical log renewal request that receiving terminal is sent, application program mark is carried in the renewal request of statistical log Know;

According to application program identification inquiry with the presence or absence of the statistical log after renewal, the daily record after statistics is included after updating Advertisement bury a little and corresponding page iden-tity;

If depositing statistical log in the updated, the statistical log after renewal is back to terminal;When in page iden-tity Advertisement after renewal is buried when being a little triggered, obtain it is corresponding buries point data, point data is buried in upload;

Using the advertisement after renewal bury a little it is corresponding bury point data calculate renewal after the corresponding advertisement of advertisement report rate.

One of ordinary skill in the art will appreciate that realize all or part of flow in above-described embodiment method, being can be with Relevant hardware is instructed to complete by computer program, the computer program can be stored in computer-readable storage In medium, the computer program is upon execution, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, the storage Medium includes magnetic disc, CD, read-only memory (Read-Only Memory, ROM) etc..

Each technical characteristic of embodiment described above can be combined arbitrarily, to make description succinct, not to above-mentioned reality Apply all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited In contradiction, the scope that this specification is recorded all is considered to be.

Embodiment described above only expresses the several embodiments of the application, its description is more specific and detailed, but simultaneously Cannot therefore it be construed as limiting the scope of the patent.It should be pointed out that come for those of ordinary skill in the art Say, on the premise of the application design is not departed from, various modifications and improvements can be made, these belong to the protection of the application Scope.Therefore, the protection domain of the application patent should be determined by the appended claims.

Claims (10)

1. one kind buries point data processing method, including:
What receiving terminal uploaded buries point data;
The point data of burying is parsed, obtains json data;
A little corresponding ad identifier is buried in the json extracting datas terminal iidentification, and with default advertisement;
The terminal iidentification in preset time period and the ad identifier are counted, obtain the statistical number of terminal iidentification The statistical magnitude of amount and ad identifier;
Using the statistical magnitude of the terminal iidentification rate is reported with the corresponding advertisement of statistical magnitude calculating of the ad identifier.
2. according to the method described in claim 1, it is characterized in that, described in the json extracting datas terminal iidentification, with And the step of with default advertisement burying a little corresponding advertisement and identifier, includes:
Multiple parameters in the json data are traveled through, extraction represents the parameter value of terminal, obtains corresponding terminal mark Know;
Judge whether to occur default advertisement using the json data and bury a little corresponding to bury an event;
If so, then representing the parameter value of advertisement in the json extracting datas, corresponding ad identifier is obtained.
3. according to the method described in claim 1, it is characterized in that, in the terminal iidentification in preset time period and Before the step of ad identifier is counted, further include:
The terminal iidentification of extraction is sent to redis corresponding with terminal and is gathered, is gathered by the redis corresponding with terminal Duplicate removal is carried out to the terminal iidentification;
The ad identifier of extraction is sent to redis corresponding with advertisement and is gathered, passes through the redis collection corresponding with advertisement Close and duplicate removal is carried out to the ad identifier.
4. according to the method described in claim 1, it is characterized in that, the point data of burying is stored in multiple source datas storehouse;It is described Method further includes:
Multiple field names are obtained in target database, SQL statement is generated using the field name;The field name includes advertisement Theme and ad identifier;
Extracted using the SQL statement in the source database and bury point data accordingly;
The point data of burying extracted is write in target database according to the field name;
The statistical magnitude of the ad identifier is calculated according to the advertising theme in the target database.
5. according to the method described in claim 1, it is characterized in that, the method further includes:
The statistical log renewal request that receiving terminal is sent, application program mark is carried in the renewal request of the statistical log Know;
According to application program identification inquiry with the presence or absence of the statistical log after renewal, after the statistical log includes renewal Advertisement bury a little and corresponding page iden-tity;
If depositing statistical log in the updated, the statistical log after the renewal is back to terminal;
When the advertisement after the renewal in the page iden-tity, which is buried, to be a little triggered, acquisition is corresponding to bury point data, is buried described in upload Point data;
Using the advertisement after renewal bury a little it is corresponding bury point data calculate renewal after the corresponding advertisement of advertisement report rate.
6. one kind buries dot data processing device, it is characterised in that described device includes:
Communication module, point data is buried for what receiving terminal uploaded;
Parsing module, for being parsed to the point data of burying, obtains json data;In the json extracting datas terminal Mark, and bury a little corresponding ad identifier with default advertisement;
Statistical module, for being counted to the terminal iidentification in preset time period and the ad identifier, obtains end Hold the statistical magnitude of mark and the statistical magnitude of ad identifier;Statistical magnitude and the advertisements using the terminal iidentification The corresponding advertisement of statistical magnitude calculating for knowing symbol reports rate.
7. device according to claim 6, it is characterised in that the parsing module is additionally operable to in the json data Multiple parameters are traveled through, and extraction represents the parameter value of terminal, obtains corresponding terminal iidentification;Judged using the json data Default advertisement whether occur bury a little corresponding to bury an event;If so, then advertisement is represented in the json extracting datas Parameter value, obtains corresponding ad identifier.
8. device according to claim 6, it is characterised in that the communication module is additionally operable to the statistics of receiving terminal transmission Daily record renewal request, application program identification is carried in the renewal request of the statistical log;
Described device further includes:
Enquiry module, for according to application program identification inquiry with the presence or absence of the statistical log after renewal, after the statistics Daily record include renewal after advertisement bury a little with corresponding page iden-tity;
If the communication module is additionally operable to deposit statistical log in the updated, the statistical log after the renewal is back to end End;When the advertisement after the renewal in the page iden-tity, which is buried, to be a little triggered, acquisition is corresponding to bury point data, is buried a little described in upload Data;
The statistical module be additionally operable to using the advertisement after renewal bury a little it is corresponding bury point data calculate renewal after advertisement correspond to Advertisement report rate.
9. a kind of computer equipment, including memory, processor and storage are on a memory and the meter that can run on a processor Calculation machine program, it is characterised in that the processor realizes any one of claim 1 to 5 institute when performing the computer program The step of stating method.
10. a kind of computer-readable recording medium, is stored thereon with computer program, it is characterised in that the computer program The step of method any one of claim 1 to 5 is realized when being executed by processor.
CN201711173043.XA 2017-11-22 2017-11-22 Bury point data processing method, device, computer equipment and storage medium CN107995266A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201711173043.XA CN107995266A (en) 2017-11-22 2017-11-22 Bury point data processing method, device, computer equipment and storage medium

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201711173043.XA CN107995266A (en) 2017-11-22 2017-11-22 Bury point data processing method, device, computer equipment and storage medium
PCT/CN2018/077017 WO2019100614A1 (en) 2017-11-22 2018-02-23 Buried point data processing method, device, computer device and storage medium

Publications (1)

Publication Number Publication Date
CN107995266A true CN107995266A (en) 2018-05-04

Family

ID=62032620

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201711173043.XA CN107995266A (en) 2017-11-22 2017-11-22 Bury point data processing method, device, computer equipment and storage medium

Country Status (2)

Country Link
CN (1) CN107995266A (en)
WO (1) WO2019100614A1 (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101577871A (en) * 2009-01-22 2009-11-11 腾讯科技(深圳)有限公司 Precise statistical method for advertisements put in movable terminal software
CN103685423A (en) * 2012-09-24 2014-03-26 腾讯科技(深圳)有限公司 Information receiving method, device and system
US20150120470A1 (en) * 2013-10-24 2015-04-30 Yahoo! Inc. Multi-protocol interactive mobile video advertising
CN106571949A (en) * 2016-09-23 2017-04-19 北京五八信息技术有限公司 Event tracking point processing method and apparatus

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101577871A (en) * 2009-01-22 2009-11-11 腾讯科技(深圳)有限公司 Precise statistical method for advertisements put in movable terminal software
CN103685423A (en) * 2012-09-24 2014-03-26 腾讯科技(深圳)有限公司 Information receiving method, device and system
US20150120470A1 (en) * 2013-10-24 2015-04-30 Yahoo! Inc. Multi-protocol interactive mobile video advertising
CN106571949A (en) * 2016-09-23 2017-04-19 北京五八信息技术有限公司 Event tracking point processing method and apparatus

Also Published As

Publication number Publication date
WO2019100614A1 (en) 2019-05-31

Similar Documents

Publication Publication Date Title
US10027540B2 (en) Automatically determining unpopulated entries of a provisioning template for a hosted computing environment
US9633106B1 (en) Log data analysis
US10367827B2 (en) Using network locations obtained from multiple threat lists to evaluate network data or machine data
US9590880B2 (en) Dynamic collection analysis and reporting of telemetry data
CN106067080B (en) Configurable workflow capabilities are provided
US9659042B2 (en) Data lineage tracking
US20190266583A1 (en) Systems and methods for automatically collection of performance data in a multi-tenant database system environment
CN103874032B (en) Information-pushing method and device based on mobile terminal
EP2088711B1 (en) A log analyzing method and system based on distributed compute network
AU2014237292B2 (en) System and method for coordinating field user testing results for a mobile application across various mobile devices
Zadrozny et al. Big data analytics using Splunk: Deriving operational intelligence from social media, machine data, existing data warehouses, and other real-time streaming sources
US8528039B2 (en) System for and method of set-top box memory monitoring
JP2018536956A (en) Method, device and storage medium for preventing illegal acts related to advertisement
US9852041B2 (en) Systems and methods for categorizing exceptions and logs
US10621613B2 (en) Systems and methods for monitoring malicious software engaging in online advertising fraud or other form of deceit
US8731998B2 (en) Three dimensional visual representation for identifying problems in monitored model oriented business processes
JP2004227359A (en) Operation management method for storage system based on policy
US8938534B2 (en) Automatic provisioning of new users of interest for capture on a communication network
US20140040026A1 (en) Systems and methods for including advertisements in streaming content
CN103281410B (en) Broadcast television network intelligent obstacle pretreatment method and system
CN105556554A (en) Multiple device correlation
WO2018113385A1 (en) Method and system for dynamically tracking application of client, client, and server
CN103646086B (en) Junk file cleaning method and device
CN102768667B (en) Method and system for releasing pushed information
CN102484653A (en) Measuring attributes of client-server applications

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20180504

RJ01 Rejection of invention patent application after publication