How to Google Ads Keyword Research For Beginners

When you embark on your first PPC trip, you need to keep a few, keywords at first. Keyword lists that are thousands of words long should be left to the more educated PPC marketer. Immaculately, a freshman should use around 100 targeted keywords, anything further will presumably prove too clumsy for you to manipulate.

• However, they will stink your bank accounts dry, If you can’t harness the power of large keyword juggernauts. There are some veritably simple free ways that you can use to find targeted keys words with low competition. One process of chancing low competition niche keywords utilizes Google and excel. More specifically, if you want to use Google’s keyword tool, just class this into Google, and it'll appear in the hunt results. 

 Upon landing on the main Google keyword tool runner, you'll find a white box (field) where you want to enter your particular keyword (s). Enter one keyword for now to get an idea of how this works, and press enter. After pressing enter, you'll be directed to a runner of keywords that will be nearly related to the keyword that you entered. For the purposes of what we want to do, you'll need to scroll to the middle of the runner where the textbook Add all 150 is stressed in the blue bold textbook. Below these words, you'll see the words download all keywords with the textbook, CSV (for Excel), and. CSV.

You want to click on it. CSV (for Excel). By doing this, you'll export this data into an Excel spreadsheet. The data, which only appears as green bars on the main Google runner, will be converted into numeric data that has much further value for you. 

Once the data is in the Excel spread distance, you can begin some simple analysis on it that will profit your PPC crusade a great deal. In the Excel spreadsheet, there are going to be columns of data, A-D. The columns are going to be, from-D, Keywords, Advertiser competition, the former month’s hunt volume, and the average hunt volume. The two columns we're interested in are the advertiser competition and the Average hunt volume. What we want to do is combine the data from these two columns to give us a number that we can work with. So what we need to do is take a generalized normal of these two to get a number that we will compare to a destined standard. Sounds a little odd, let me explain a bit more fully, and hopefully, you'll understand. All of these figures are in numbers on a scale ranging from.00 to 1.

The advanced the number, the further competition there is (as expressed by the advertiser competition figures) and the advanced the hunt volume (as expressed by the average hunt volume). Immaculately, we want low competition with a decent hunt volume to target lower cost high converting keywords. So, to find these keywords, we use a general standard. The number that will determine their competition and volume level. However, we leave them be if they hit right around the standard. If the keywords exceed the standard. 

 To get our numbers, which we're going to compare to a destined standard, we're going to take a normal of the advertiser competition column and the average hunt volume column. We want to do this for all the keywords that have been exported to the Excel train. And the way we do this is by codifying a simple command in Excel and copying the command down throughout the affiliated boxes. So to start, we find box E2 which should be blank, this is the first box to the right of the first value in the avg. hunt volume box. So, within this blank box, you want to class = average (D2, B2). This will automatically give you a normal of those two figures in this E column row when you close that last. Now, to get all the parts for every keyword.

You simply 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 down to the last box (nothing will be in them yet). Also, when you have filled in the boxes with color up to the last box, You want to lift your cutlet off the right-click. When you do this, all the pars will appear in the boxes. You principally just copied the function down through the boxes. So now we've all these pars. What do we do with them, and what do they tell us? 

Well, a good standard normal is around.50. This will give us a reasonable competition position with good hunt volume. So we compare these pars to anything that falls around.50 and below. Anything that goes over.60 we want to avoid to start out with because it'll presumably be too precious to bid on.

So now compare all the pars in column E to the destined standard of.50. Whatever falls below.50 or.,55 (to conceivably get some further data) we want to keep. Take all the keywords that meet this criterion and copy them into a tablet. TXT train. (There are brisk ways to do this but, they take some literacy of Excel functions that you may not know yet). 

 So now we want to take these keywords that fell below or right around the standard and plug these back into the Google keyword tool and hit enter. Now go back through the entire process that we just did to get the keywords we just plugged into the Google keyword tool.

You're going to want to take the average again of the two columns mentioned over, also get all the pars of all the keywords by dragging the first box down, and also compare again to a standard of.50 or.55. But now, because we set up some further targeted keywords to work with (as a result of the first exporting of data to exceed, and taking the pars to compare against the standard) we should have further keywords that hit right around the standard and below it. This is because we're working with further targeted and hopefully lower competition keywords. We're chancing yet more targeted keywords related to the first set we set up. This should produce a larger list of keywords that meet our standard.

So now we can take the words that meet the standard then, and we can use these in our targeted PPC crusade. You'll want to sort through this list, of course. and make sure the keywords are well suited for the particular particulars that you're dealing with. This system will get you headed in the right direction for your PPC crusade.