When you embark on your initial PPC journey, you would like to keep a small range of keywords at first. Keyword lists that are thousands of words long ought to be left to the additional experienced PPC marketer. Ideally, a beginner should use around a hundred targeted keywords, anything additional can most likely prove too cumbersome for you to manipulate. If you cannot harness the power of huge keyword campaigns, they will suck your bank accounts dry. There are some very simple free techniques that you can use to seek out targeted keys words with low competition. One method of finding low competition niche keywords utilizes Google and excel. Additional specifically you wish to use Google’s keyword tool, simply sort this into Google, and it can seem within the search results.
Upon landing on the most Google keyword tool page, you’ll notice a white box(field) where you want to enter your particular keyword(s). Enter one keyword for currently to induce an idea of how this works, and press enter. Once pressing enter, you will be directed to a page of keywords that will be closely related to the keyword that you simply entered. For the needs of what we tend to wish to try and do, you may would like to scroll to the middle of the page where the text Add all a hundred and fifty is highlighted in blue bold text. Below these words you will see the words download all keywords with text,.csv(for excel) and .csv. You would like to click on .csv(for excel). By doing this, you may export this data into an excel spreadsheet. The info, which only seems as green bars on the most Google page, can be reworked into numeric data that has much a lot of worth for you.
Once the info is in the excel unfold sheet, you can begin some easy analysis on it that can profit your PPC campaign a great deal. Within the excel spreadsheet, there are going to be columns of knowledge, A-D. The columns are visiting be, from A-D, Keywords, Advertiser competition, the previous month’s search volume, and the average search volume.The two columns we tend to are inquisitive about are the advertiser competition and the Average search volume. What we tend to need to try and do is merge the information from these two columns to present us a number that we have a tendency to will work with. Thus what we want to try to to is take a generalized average of those two to urge a range that we tend to will compare to a predetermined benchmark. Sounds a very little odd, let me justify a bit more utterly, and hopefully you’ll understand. All of those numbers are in decimals on a scale starting from .00 to 1. The higher the number, the a lot of competition there’s(as expressed by the advertiser competition numbers) and the upper the search volume(as expressed by the typical search volume). Ideally, we have a tendency to want low competition with a decent search volume to focus on lower value high converting keywords. Therefore, to search out these keywords we have a tendency to use a general benchmark variety that will determine their competition and volume level. If the keywords exceed the benchmark, we tend to leave them be, if they hit right round the benchmark, or fall below it, we tend to need to capture them and embrace them in our PPC campaign.
To get our figures, that we are going to check to a predetermined benchmark, we tend to are going to require an average of the advertiser competition column and the typical search volume column. We have a tendency to want to try to to this for all the keywords that have been exported to the excel file. And the way we have a tendency to do this can be by typing in a very simple command in excel and copying the command down throughout the connected boxes. So to begin, we tend to realize box E2 which ought to be blank, this is the primary box to the correct of the first price in the avg. search volume box. Therefore, at intervals this blank box you wish to sort=average(D2,B2). This will automatically provide you a mean of these 2 numbers in this E column row when you close that last ).Now, to induce all the averages for every keyword you merely want to click on that box(E2) and pull down on the box while you hold in right click. The boxes should fill in with color when you drag right down to the last box(nothing can be in them however). Then, when you have got filled within the boxes with color up to the last box you want to carry your finger off the proper click. When you do this all the averages can appear in the boxes. You essentially simply copied the function down through the boxes. Thus currently we have all these averages. What do we do with them, what do they tell us?
Well, a good benchmark average is around .50. This can give us a affordable competition level with good search volume. So we tend to compare these averages to anything that falls around .fifty and below. Something that goes on top of .60 we tend to need to avoid to begin out with, as a result of it can most likely be too expensive to bid on. Therefore currently compare all the averages in column E to the predetermined benchmark of .50. Whatever falls below .fifty or, .fifty five(to probably get some a lot of data) we wish to keep. Take all the keywords that meet this criteria and replica them into a notepad .txt file. (There are faster ways in which to try and do this but they take some learning of excel functions that you may not apprehend yet.)
Therefore now we tend to wish to require these keywords that fell below or right around the benchmark and plug these back to the Google keyword tool and hit enter. Currently go back through the entire method that we simply did to induce the keywords we just plugged into the Google keyword tool. You’re visiting need to take the common once more of the two columns mentioned above, then get all the averages of all the keywords by draggin the first box down, and then compare once more to a benchmark of .fifty or .55. But now, because we found some additional targeted keywords to figure with(as a results of the first exporting of data to excel, and taking the averages to compare against the benchmark) we should have a lot of keywords that hit right around the benchmark and below it. This can be because we tend to are operating with more targeted and hopefully lower competition keywords. We have a tendency to are finding nevertheless additional targeted keywords connected to the primary set we found. This could turn out a bigger list of keywords that meet our benchmark. Thus currently we have a tendency to will take the words that meet the benchmark here, and we can use these in our targeted PPC campaign. You will want to type through this list in fact, and make certain the keywords are well suited for the particular things that you are selling. This method can get you headed in the proper direction for your PPC campaign.
.gif)
Comments are closed.