Once you embark on your initial PPC journey, you need to stay a little 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 ought to use around one hundred targeted keywords, something additional will probably prove too cumbersome for you to manipulate. If you cannot harness the power of enormous keyword campaigns, they will suck your bank accounts dry. There are some terribly simple free techniques that you’ll use to find targeted keys words with low competition. One process of finding low competition niche keywords utilizes Google and excel. Additional specifically you want to use Google’s keyword tool, simply sort this into Google, and it can appear within the search results.
Upon landing on the main Google keyword tool page, you’ll find a white box(field) where you would like 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 may be directed to a page of keywords that will be closely connected to the keyword that you just entered. For the purposes of what we tend to wish to try and do, you will want to scroll to the center of the page where the text Add all one hundred fifty is highlighted in blue bold text. Below these words you’ll 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’ll export this data into an excel spreadsheet. The data, that solely seems as green bars on the main Google page, will be transformed into numeric information that has abundant more price for you.
Once the information is during the excel unfold sheet, you’ll be able to begin some straightforward analysis on it that can benefit your PPC campaign a great deal. In the excel spreadsheet, there are visiting be columns of data, A-D. The columns are visiting be, from A-D, Keywords, Advertiser competition, the previous month’s search volume, and the typical search volume.The 2 columns we are fascinated by are the advertiser competition and therefore the Average search volume. What we need to try to to is merge the information from these 2 columns to offer us a range that we have a tendency to can work with. So what we have a tendency to would like to do is take a generalized average of these two to induce a range that we will compare to a predetermined benchmark. Sounds a very little odd, let me justify a small amount additional utterly, and hopefully you will understand. All of these numbers are in decimals on a scale ranging from .00 to 1. The higher the amount, the more competition there’s(as expressed by the advertiser competition numbers) and the higher the search volume(as expressed by the typical search volume). Ideally, we have a tendency to need low competition with a decent search volume to target lower cost high converting keywords. Thus, to find these keywords we use a general benchmark range that can determine their competition and volume level. If the keywords exceed the benchmark, we leave them be, if they hit right round the benchmark, or fall below it, we tend to want to capture them and embody them in our PPC campaign.
To induce our figures, which we tend to are going to match to a predetermined benchmark, we have a tendency to are going to take a mean of the advertiser competition column and the common search volume column. We tend to want to try to to this for all the keywords that have been exported to the excel file. And the method we have a tendency to do this is often by typing during a easy command in excel and copying the command down throughout the connected boxes. Therefore to start, we notice box E2 that should be blank, this is the primary box to the right of the primary value in the avg. search volume box. Therefore, within this blank box you wish to sort=average(D2,B2). This can automatically give you a mean of those two numbers during this E column row when you close that last ).Now, to induce all the averages for every keyword you just wish to click on that box(E2) and pull down on the box while you hold in right click. The boxes ought to fill in with color once you drag all the way down to the last box(nothing will be in them nonetheless). Then, when you have filled in the boxes with color up to the last box you want to elevate your finger off the right click. When you do this all the averages can appear within the boxes. You basically simply copied the operate down through the boxes. Thus now we have a tendency to have all these averages. What do we tend to do with them, what do they tell us?
Well, a sensible benchmark average is around .50. This will offer us a reasonable competition level with smart search volume. Therefore we tend to compare these averages to anything that falls around .50 and below. Anything that goes higher than .60 we have a tendency to need to avoid to start out with, as a result of it will probably be too expensive to bid on. Thus currently compare all the averages in column E to the predetermined benchmark of .50. Whatever falls below .50 or, .55(to probably get some a lot of data) we tend to wish to keep. Take all the keywords that meet this criteria and replica them into a notepad .txt file. (There are faster ways to try and do this however they take some learning of excel functions that you may not recognize yet.)
Therefore currently we tend to want to take these keywords that fell below or right around the benchmark and plug these into the Google keyword tool and hit enter. Currently return through the entire method that we tend to simply did to induce the keywords we just plugged into the Google keyword tool. You are visiting want to take the average again of the two columns mentioned on top of, then get all the averages of all the keywords by draggin the first box down, and then compare once more to a benchmark of .50 or .55. However currently, because we have a tendency to found some more targeted keywords to work with(as a result of the primary exporting of information to excel, and taking the averages to check against the benchmark) we have a tendency to should have a lot of keywords that hit right around the benchmark and below it. This is as a result of we are working with more targeted and hopefully lower competition keywords. We are finding nevertheless more targeted keywords related to the first set we found. This should turn out a larger list of keywords that meet our benchmark. So now we will take the words that meet the benchmark here, and we have a tendency to can use these in our targeted PPC campaign. You will need to kind through this list of course, and create positive the keywords are well suited to the particular things that you are selling. This method can get you headed in the correct direction for your PPC campaign.