Summary of the invention
Fundamental purpose of the present invention is the detection method and the device that provide a kind of web search keyword, to solve the problem that in correlation technique, when whether repeating keyword to detect, efficiency comparison is low.
To achieve these goals, according to an aspect of the present invention, a kind of detection method of web search keyword is provided.
Detection method according to web search keyword of the present invention comprises: obtain the keyword to be detected for performing web search; Obtain target database, wherein, target database is the database of targeted promotion account, stores the keyword that targeted promotion account comprises in target database; Judge whether there is keyword to be detected in the keyword stored in target database; And if judge to there is keyword to be detected in the keyword that stores in target database, then determine that keyword to be detected is the keyword of repetition, if judge there is not keyword to be detected in the keyword stored in target database, then determine that keyword to be detected is unduplicated keyword.
Further, whether there is keyword to be detected in the keyword judging to store in target database before, method also comprises: obtain the keyword stored in target database; Keyword is sorted, obtain the keyword after sorting, judge that whether there is keyword to be detected in the keyword stored in target database comprises: by the keyword after sequence and keyword to be detected are compared in the keyword judging to store in target database whether there is keyword to be detected.
Further, judge that whether there is keyword to be detected in the keyword that stores in target database comprises: each keyword in the keyword stored in target database and keyword to be detected are compared; And the number of the keyword identical with keyword to be detected in the keyword stored in calculating target database; If the number of keyword identical with keyword to be detected in the keyword stored in target database is greater than zero, then judge to there is keyword to be detected in the keyword stored in target database; And if the number of keyword identical with keyword to be detected in the keyword stored in target database equals zero, then judge there is not keyword to be detected in the keyword stored in target database.
Further, the keyword stored in target database comprises the first keyword, each keyword in the keyword stored in target database and keyword to be detected are compared to comprise the first keyword and keyword to be detected are compared, first keyword is compared with keyword to be detected and comprises: if the first keyword is identical with keyword to be detected, return results 1, and record the characteristic information of the first keyword, wherein, characteristic information is the information for representing the first keyword feature; And if the first keyword is not identical with keyword to be detected, returns results 0.
Further, keyword to be detected is there is in the keyword judging to store in target database, after determining that keyword to be detected repeats, method also comprises: generate the first chart according to characteristic information, wherein, the first chart stores the characteristic information of keyword identical with keyword to be detected in the keyword stored in target database; And export the first chart.
Further, in the keyword judging to store in target database, there is not keyword to be detected, after determining that keyword to be detected does not repeat, method also comprises: be inserted in target database by keyword to be detected.
Further, targeted promotion account is multiple, multiple targeted promotion account corresponds respectively to the different pieces of information table in target database, keyword to be detected is there is not in the keyword judging to store in target database, after determining that keyword to be detected does not repeat, method also comprises: obtain the first tables of data in target database, wherein, the first tables of data is for inserting the tables of data of the targeted promotion account of keyword to be detected in multiple targeted promotion account; And keyword to be detected is inserted in the first tables of data.
To achieve these goals, according to a further aspect in the invention, a kind of pick-up unit of web search keyword is provided.
Pick-up unit according to web search keyword of the present invention comprises: the first acquiring unit, for obtaining the keyword to be detected for performing web search; Second acquisition unit, for obtaining target database, wherein, target database is the database of targeted promotion account, stores the keyword that targeted promotion account comprises in target database; Judging unit, for judging whether there is keyword to be detected in the keyword that stores in target database; And determining unit, during for there is keyword to be detected in the keyword judging to store in target database, determine that keyword to be detected is the keyword of repetition, when there is not keyword to be detected in the keyword judging to store in target database, determine that keyword to be detected is unduplicated keyword.
Further, device also comprises: the 3rd acquiring unit, for obtaining the keyword stored in target database; Sequencing unit, for keyword is sorted, obtain sort after keyword, judging unit comprises: the first comparison module, for by by sort after keyword and keyword to be detected compare in the keyword judging to store in target database whether there is keyword to be detected.
Further, judging unit also comprises: the second comparison module, for each keyword in the keyword stored in target database and keyword to be detected being compared; And computing module, for calculating the number of keyword identical with keyword to be detected in the keyword that stores in target database; And judge module, when number for keyword identical with keyword to be detected in the keyword that stores in target database is greater than zero, judge to there is keyword to be detected in the keyword stored in target database, when the number of keyword identical with keyword to be detected in the keyword stored in target database equals zero, judge there is not keyword to be detected in the keyword stored in target database.
Pass through the present invention, adopting is pre-stored within database by the keyword of targeted promotion account, and automatically keyword to be detected is mated one by one with the keyword stored in the database of targeted promotion account, achieve detection keyword to be detected automatically whether to repeat, solve the problem that in correlation technique, when whether repeating keyword to detect, efficiency comparison is low, and then reach the effect improved whether repeating efficiency when detecting to keyword.
Embodiment
It should be noted that, when not conflicting, the embodiment in the application and the feature in embodiment can combine mutually.Below with reference to the accompanying drawings and describe the present invention in detail in conjunction with the embodiments.
The application's scheme is understood better in order to make those skilled in the art person, below in conjunction with the accompanying drawing in the embodiment of the present application, technical scheme in the embodiment of the present application is clearly and completely described, obviously, described embodiment is only the embodiment of the application's part, instead of whole embodiments.Based on the embodiment in the application, those of ordinary skill in the art are not making the every other embodiment obtained under creative work prerequisite, all should belong to the scope of the application's protection.
It should be noted that, term " first ", " second " etc. in the instructions of the application and claims and above-mentioned accompanying drawing are for distinguishing similar object, and need not be used for describing specific order or precedence.Should be appreciated that the data used like this can be exchanged, in the appropriate case so that the embodiment of the application described herein.In addition, term " comprises " and " having " and their any distortion, intention is to cover not exclusive comprising, such as, contain those steps or unit that the process of series of steps or unit, method, system, product or equipment is not necessarily limited to clearly list, but can comprise clearly do not list or for intrinsic other step of these processes, method, product or equipment or unit.
According to the embodiment of the present invention, provide a kind of detection method of web search keyword, Fig. 1 is the process flow diagram of the detection method of web search keyword according to a first embodiment of the present invention.
As shown in Figure 1, the method comprises following step S102 to step S108:
Step S102: obtain the keyword to be detected for performing web search.
Utilize network search engines to carry out marketing and comprise AdWords, AdWords is also referred to as keyword retrieval, and namely user is retrieved by a certain keyword, can show the web site url advertisement relevant to this keyword at the result for retrieval page.When utilizing network search engines to market, first user can set up promoted account on the marketing platforms such as Baidu, multiple popularization plan can be comprised under this promoted account, multiple popularization unit can be comprised under each popularization plan, can comprise multiple keyword and keyword intention under each popularization unit, this keyword is namely for the keyword of AdWords.Keyword to be detected can be the keyword needing arbitrarily to increase newly into promoted account, and this keyword to be detected can be one, also can be multiple.
Step S104: obtain target database, wherein, target database is the database of targeted promotion account, stores the keyword that targeted promotion account comprises in target database.
Targeted promotion account refers to the promoted account needing to carry out keyword duplicate detection to be detected, and compare by already present keyword in keyword to be detected and targeted promotion account, targeted promotion account can be one, also can be multiple.Target database, for storing the relevant information of targeted promotion account, such as, the popularization plan that targeted promotion account comprises, promotes the information such as unit, keyword.Can be that the data of multiple promoted account are stored in different databases respectively, also can be that the data of multiple promoted account are stored in same database, the embodiment of the present invention be stored in same target database for the data of multiple targeted promotion account and be described.
Step S106: judge whether there is keyword to be detected in the keyword stored in target database.
The keyword stored in traversal target database, compare with keyword to be detected respectively, if there is the keyword identical with keyword to be detected in the keyword stored in target database, keyword to be detected is then described Already in target database, namely be present in targeted promotion account, therefore, this keyword to be detected should not be added in targeted promotion account.If when keyword to be detected is multiple, then judge whether each keyword to be detected is present in targeted promotion account successively.
Preferably, whether there is keyword to be detected in the keyword judging to store in target database before, method also comprises: obtain the keyword stored in target database; Keyword is sorted, obtain the keyword after sorting, judge that whether there is keyword to be detected in the keyword stored in target database comprises: by the keyword after sequence and keyword to be detected are compared in the keyword judging to store in target database whether there is keyword to be detected.Keyword in target database can be carried out according to first letter female descending sort, also can be the ascending sort according to initial, also can be other sortords.Compare with keyword to be detected again after the keyword stored in target database is sorted, the efficiency compared can be improved.
Preferably, judge that whether there is keyword to be detected in the keyword that stores in target database comprises: each keyword in the keyword stored in target database and keyword to be detected are compared; And the number of the keyword identical with keyword to be detected in the keyword stored in calculating target database; If the number of keyword identical with keyword to be detected in the keyword stored in target database is greater than zero, then judge to there is keyword to be detected in the keyword stored in target database; And if the number of keyword identical with keyword to be detected in the keyword stored in target database equals zero, then judge there is not keyword to be detected in the keyword stored in target database.
By calculating in target database the number of keyword identical with keyword to be detected in the keyword that stores, can judge whether this keyword to be detected is present in target database on the one hand, can know in the keyword stored in target database whether there is identical keyword on the other hand, corresponding optimization process can be carried out to the keyword of existing promoted account according to this result, such as, the keyword etc. that some repeat is weeded out.Particularly, the keyword stored in target database comprises the first keyword, each keyword in the keyword stored in target database and keyword to be detected are compared to comprise the first keyword and keyword to be detected are compared, first keyword is compared with keyword to be detected and comprises: if the first keyword is identical with keyword to be detected, return results 1, and record the characteristic information of the first keyword, wherein, characteristic information is the information for representing the first keyword feature; And if the first keyword is not identical with keyword to be detected, returns results 0.
First keyword can be any one keyword in the keyword stored in target database.If the first keyword is identical with keyword to be detected, then return results 1, also can be return other marks that may be used for arbitrarily representing that this first keyword is identical with keyword to be detected herein, such as, and " T ", the marks such as "Yes".The characteristic information of the first keyword can be this information such as popularization unit, popularization plan, promoted account belonging to the first keyword.If when the first keyword is not identical with keyword to be detected, return results 0, also can be returned other herein arbitrarily and above-mentioned for representing the mark that mark that the first keyword is identical with keyword to be detected is not identical.In the embodiment of the present invention, aforesaid operations is carried out to each keyword stored in target database, namely compare with keyword to be detected, if identical with keyword to be detected, return results 1, and record the characteristic information of this keyword, if not identical with keyword to be detected, return results 0, by all returning results the number that namely addition can obtain keyword identical with keyword to be detected in the keyword stored in target database by above-mentioned, simultaneously, the characteristic information of the keyword that the keyword that can obtain storing in target database is identical with keyword to be detected.
Step S108: if judge to there is keyword to be detected in the keyword stored in target database, then determine that keyword to be detected is the keyword of repetition, if judge there is not keyword to be detected in the keyword stored in target database, then determine that keyword to be detected is unduplicated keyword.
Judged whether there is keyword to be detected in the keyword stored in target database by above-mentioned steps S106 after, if judge to there is keyword to be detected in the keyword stored in target database, then determine that keyword to be detected is the keyword of repetition, now should not add this keyword to be detected again in targeted promotion account, avoid causing vying each other of same keyword, waste advertising expenditure simultaneously, such as, keyword intelligence is all there is in two popularization plans, in first popularization plan, the advertisement of keyword intelligent association is smart mobile phone, and the advertisement of this keyword intelligent association is panel computer in second popularization plan, because AdWords carrys out sequencing display according to bid, namely bid higher more forward when user search results page shows, now, just competition is there will be between these two AdWords, if the emphasis that now advertiser promotes is smart mobile phone, then this advertisement of panel computer can affect the input effect of this advertisement of smart mobile phone.If judge there is not keyword to be detected in the keyword stored in target database, then determine that keyword to be detected is unduplicated keyword, now this keyword to be detected can be added in promoted account.
Preferably, conveniently user checks testing result intuitively, keyword to be detected is there is in the keyword judging to store in target database, after determining that keyword to be detected repeats, method also comprises: generate the first chart according to characteristic information, wherein, the first chart stores the characteristic information of keyword identical with keyword to be detected in the keyword stored in target database; And export the first chart.
The characteristic information of keyword identical with keyword to be detected in the keyword stored in target database is obtained by above-mentioned steps, the first chart is generated according to characteristic information, this the first chart can be the form of database, also can be Excel form, also can be other forms of icon.Particularly, suppose that keyword to be detected is keyword 1 and keyword 2, characteristic information comprises promoted account belonging to the keyword identical with keyword to be detected, popularization plan and popularization unit, and the form of the first chart can be as shown in table 1:
Table 1 testing result table
Can intuitively find out from upper table, keyword 1 repeats 3 times in targeted promotion account, namely the keyword that in the keyword stored in target database, existence 3 is identical with keyword 1, these three keywords belong to the popularization unit C in the popularization unit B in the popularization unit A in the popularization plan 01 in promoted account 01, the popularization plan 02 in promoted account 01 and the popularization plan 02 in promoted account 01 respectively.After obtaining these three identical keywords, user can select directly in target database, to delete this three keywords, also can select not delete this three keywords.The analysis of keyword 2, with keyword 1, does not repeat them here.User can check testing result intuitively according to this chart, can carry out corresponding optimization according to testing result to keyword simultaneously, such as, deletes the keyword repeated, changes etc. the keyword repeated.
Preferably, conveniently user upgrades in time target database, in the keyword judging to store in target database, there is not keyword to be detected, after determining that keyword to be detected does not repeat, method also comprises: be inserted in target database by keyword to be detected.
At acquisition keyword to be detected simultaneously, the targeted promotion account that keyword to be detected that user specifies is inserted into can be received, if there is not keyword to be detected in the keyword judging to store in target database, keyword to be detected is inserted in the tables of data of the target database of the targeted promotion account of specifying.Preferably, in order to realize accurately keyword to be detected being inserted in the targeted promotion account of specifying, when targeted promotion account is multiple, when multiple targeted promotion account corresponds respectively to the different pieces of information table in target database, keyword to be detected is there is not in the keyword judging to store in target database, after determining that keyword to be detected does not repeat, the method also comprises: obtain the first tables of data in target database, wherein, the first tables of data is for inserting the tables of data of the targeted promotion account of keyword to be detected in multiple targeted promotion account; And keyword to be detected is inserted in the first tables of data.Particularly, user can specify the targeted promotion account for inserting keyword to be detected, and the popularization plan of this targeted promotion account and promote unit.After receiving above-mentioned user-specific information, there is not keyword to be detected in the keyword judging to store in target database after, keyword to be detected is inserted into position corresponding in the first tables of data, i.e. the user popularization plan of specifying and the position of promoting unit place in the first tables of data.
Fig. 2 is the process flow diagram of the detection method of web search keyword according to a second embodiment of the present invention.As shown in Figure 2, the method comprises the steps that S202 is to step S:
Step S202: obtain keyword to be detected.
User can input keyword to be detected by EXCEL client, and selects the targeted promotion account for carrying out keyword duplicate detection.Therefore, keyword to be detected and the targeted promotion account of user's input can directly be obtained.
Step S204: keyword to be detected is input in the database of targeted promotion account.
EXCEL client is associated with the database of targeted promotion account, particularly, and the database of the database interface hyperlink target promoted account that can be provided by EXCEL client.After getting keyword to be detected, the operation carried out database and be correlated with can be input in the database of targeted promotion account by keyword just to be detected, such as, carry out data query etc. based on keyword to be detected.
Step S206: the keyword in database is sorted.
Can, to the keyword in database according to initial descending sort, also can be the ascending sort according to initial, also can be sort according to other modes.
Step S208: respectively by keyword to be detected with sort in database after keyword in each mate.
Each keyword in the keyword fetched data successively in storehouse after sequence mates with keyword to be detected, if identical with keyword to be detected, then the match is successful, otherwise it fails to match.
Step S210: judge whether that the match is successful.
If the keyword taken out from database and Keywords matching to be detected success, perform step S212, if the keyword taken out from database and Keywords matching to be detected failure, perform step S214.
Step S212: return results 1, and promoted account title, popularization plan title and the popularization unit title corresponding to the successful keyword of record matching.
Step S214: return results 0.
Step S216: return results addition by all, obtains the number of times that keyword to be detected repeats in targeted promotion account.After all being obtained with Keywords matching to be detected by all keywords stored in database again returning results, return results addition by all.Be 0 because the keyword not identical with keyword to be detected in the keyword that stores in database returns results, it is 1 that keyword identical with keyword to be detected in the keyword stored in database returns results, therefore, the value returning results addition can represent the number of times that keyword to be detected repeats in targeted promotion account.
Step S218: Output rusults in EXCEL client.
Output rusults can comprise the number of keyword identical with keyword to be detected in the keyword stored in database and these promoted accounts belonging to identical keyword, popularization plan and popularization unit, if be not present in the identical keyword of keyword to be detected in database, the value of the individual digital section of keyword that can be identical with keyword to be detected in Output rusults is 0.Particularly, Output rusults is presented in EXCEL client by the embodiment of the present invention in table form.
As can be seen from the above description, present invention achieves following technique effect:
The embodiment of the present invention is by storing information relevant for promoted account in a database in advance, mate one by one with the keyword stored in the database of targeted promotion account by obtaining keyword to be detected, whether automatic detection keyword to be detected repeats, whether compare to be searched for one by one in promoted account by promoted account supvr with prior art needs newly-increased keyword to repeat to improve detection efficiency, also avoid the leakage test problems because manual operation causes simultaneously, improve the accuracy of testing result, in addition, the present invention is less demanding to the computer skill of operating personnel and the configuration of computer.
It should be noted that, can perform in the computer system of such as one group of computer executable instructions in the step shown in the process flow diagram of accompanying drawing, and, although show logical order in flow charts, but in some cases, can be different from the step shown or described by order execution herein.
According to the another aspect of the embodiment of the present invention, provide a kind of pick-up unit of web search keyword, the pick-up unit of this web search keyword may be used for the detection method of the web search keyword performing the embodiment of the present invention, and the detection method of the web search keyword of the embodiment of the present invention also can be performed by the pick-up unit of the web search keyword of the embodiment of the present invention.
Fig. 3 is the schematic diagram of the pick-up unit of web search keyword according to the embodiment of the present invention, and as shown in Figure 3, the pick-up unit of this web search keyword comprises: the first acquiring unit 10, second acquisition unit 20, judging unit 30 and determining unit 40.
First acquiring unit 10, for obtaining the keyword to be detected for performing web search.
Keyword to be detected can be the keyword needing arbitrarily to increase newly into promoted account, and this keyword to be detected can be one, also can be multiple.
Second acquisition unit 20, for obtaining target database, wherein, target database is the database of targeted promotion account, stores the keyword that targeted promotion account comprises in target database.
Targeted promotion account refers to the promoted account needing to carry out keyword duplicate detection to be detected, and compare by already present keyword in keyword to be detected and targeted promotion account, targeted promotion account can be one, also can be multiple.Target database, for storing the relevant information of targeted promotion account, such as, the popularization plan that targeted promotion account comprises, promotes the information such as unit, keyword.
Judging unit 30, for judging whether there is keyword to be detected in the keyword that stores in target database.
The keyword stored in traversal target database, compare with keyword to be detected respectively, if there is the keyword identical with keyword to be detected in the keyword stored in target database, keyword to be detected is then described Already in target database, namely be present in targeted promotion account, therefore, this keyword to be detected should not be added in targeted promotion account.
Determining unit 40, during for there is keyword to be detected in the keyword judging to store in target database, determine that keyword to be detected is the keyword of repetition, when there is not keyword to be detected in the keyword judging to store in target database, determine that keyword to be detected is unduplicated keyword.
Judged whether there is keyword to be detected in the keyword stored in target database by judging unit 30 after, if judge to there is keyword to be detected in the keyword stored in target database, then determine that keyword to be detected is the keyword of repetition, now should not add this keyword to be detected again in targeted promotion account, avoid causing vying each other of same keyword, waste advertising expenditure simultaneously.
The embodiment of the present invention obtains the keyword to be detected for performing web search by the first acquiring unit 10, second acquisition unit 20 obtains the target database of targeted promotion plan, judged whether there is keyword to be detected in the keyword stored in target database by judging unit 30, and when there is keyword to be detected in the keyword judging to store in target database in determining unit 40, determine that keyword to be detected is the keyword of repetition, when there is not keyword to be detected in the keyword judging to store in target database, determine that keyword to be detected is unduplicated keyword, realize automatically detecting keyword to be detected whether to repeat, solve the problem that in correlation technique, when whether repeating keyword to detect, efficiency comparison is low, and then reach the effect improved whether repeating efficiency when detecting to keyword.
Preferably, this device also comprises: the 3rd acquiring unit, for obtaining the keyword stored in target database; Sequencing unit, for keyword is sorted, obtain sort after keyword, judging unit 30 comprises: the first comparison module, for by by sort after keyword and keyword to be detected compare in the keyword judging to store in target database whether there is keyword to be detected.
Preferably, judging unit 30 also comprises: the second comparison module, for each keyword in the keyword stored in target database and keyword to be detected being compared; And computing module, for calculating the number of keyword identical with keyword to be detected in the keyword that stores in target database; And judge module, when number for keyword identical with keyword to be detected in the keyword that stores in target database is greater than zero, judge to there is keyword to be detected in the keyword stored in target database, when the number of keyword identical with keyword to be detected in the keyword stored in target database equals zero, judge there is not keyword to be detected in the keyword stored in target database.
Obviously, those skilled in the art should be understood that, above-mentioned of the present invention each module or each step can realize with general calculation element, they can concentrate on single calculation element, or be distributed on network that multiple calculation element forms, alternatively, they can realize with the executable program code of calculation element, thus, they can be stored and be performed by calculation element in the storage device, or they are made into each integrated circuit modules respectively, or the multiple module in them or step are made into single integrated circuit module to realize.Like this, the present invention is not restricted to any specific hardware and software combination.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.