Google Ads keyword research for beginners
When you start your first PPC journey, you need to save a few, number of keywords at the beginning. A list of keywords with thousands of words in length should be left to an experienced PPC advertiser. Ideally, a beginner should use at least 100 keywords, or anything else will seem too difficult to use. If you are unable to use the power of keyword campaigns, they will absorb your dry bank accounts. There are some simple free strategies you can use to get targeted keywords with low competition. One process for finding low competitive niche keywords uses Google and is successful. Specifically you want to use Google's keyword tool, just type this in Google, and it will appear in search results.
When you get to the Google Keyword Toolbar's main page, you'll find a white box (field) where you want to enter your keywords. Enter one keyword right now to get an idea of how this works, then press enter. After pressing enter, you will be directed to a keywords' page that will be closely related to the keyword you entered. For the purposes of what we want to do, you will need to scroll through the page, where the text Insert All 150 is highlighted in bold blue text. Below these words you will see words that download all keywords in text, .csv (excel) and .csv. You want to click on .csv (for Excel). By doing this, you will extract this data from an Excel spreadsheet. The data, which only appears as green bars on the Google homepage, will be converted into numerical data of the highest value for you.
Once the information is in the Excel spreadsheet, you can start a simple analysis in it that will greatly benefit your PPC campaign. In the Excel spreadsheet, there will be data columns, A-D. Columns will be, from A-D, Keywords, advertiser competition, last month's search volume, and average search volume. What we want to do is combine the data from these two columns to give us a workable number. So all we have to do is take a standard deviation of the two in order to find the number that we will compare with the pre-determined benchmark. Sounds weird, let me explain in more detail, and I hope you understand. All of these numbers are in decimals on the scale from .00 to 1. The higher the value, the more competition there is (as the advertiser competition numbers are displayed) and the search volume increases (as shown in the search volume in the middle). Ideally, we want low competition with decent search volume in order to target low-key conversion rates. Therefore, in order to obtain these keywords, we use a standard benchmark number that will determine its competition and volume level. If the keywords go beyond the benchmark, we leave them, when they get close to the benchmark, or fall under it, we want to capture them and include them in our PPC campaign.
In order to obtain our statistics, which we will compare with a pre-determined benchmark, we will take the rating of the advertiser competition column and the search volume column. We want to do this for all keywords sent to the Excel file. And how we do this by typing a simple command in Excel and copying the command down into all the related boxes. So to get started, we find an E2 box that should be empty, this is the first box to the right of the first value in avg. Search the volume box. So, inside this empty box you want to type = measure (D2, B2). This will automatically give you an estimate of those two numbers in the E-row when you close the last one. While holding the right click. The boxes should fill in the color when you drag down the last box (nothing will fit into it yet). Then, once you have filled the boxes with color to the last box, you want to raise your finger and move it with the right click. If you do this, all the averages will appear in the boxes. Basically, you just copied the work down with the boxes. So now we have all these averages. What do we do with them, what do they tell us?
However, a good standing average can be .50. This will give us a reasonable level of competition with a good search volume. So we compare these values with anything that falls to .50 and below. Anything over .60 we want to avoid starting with, because it will probably be too expensive to call. So now compare all averages in column E with a pre-determined benchmark .50. Anything that falls below .50 or, .55 (for additional data) we want to keep. Take all the keywords that meet these requirements and copy them to a notepad .txt file. (There are quick ways to do this, but it does take you to learn excel jobs that you may not know yet.)
So now we want to take these keywords down or right next to the benchmark and connect them back to the Google keywords tool and hit enter. Now go back to all the process we just did to get the keywords we just connected to the Google keywords tool. You will want to take a re-evaluation of the two columns mentioned above, then find all the ratings for all the keywords by dragging down the first box, and then compare with the benchmark mark .50 or .55. But now, because we have found some keywords that are intended to work (as a result of sending data for the first time to be successful, and we take the average to benchmark) we should have more keywords hitting right next to the benchmark and below it. This is because we are dealing with highly targeted competitive keywords, and hopefully they reduce. We get the most targeted keywords related to the first set we found. This should generate a larger list of keywords that meet our benchmark. So now we can take the words that meet the benchmark here, and we can use them in our intended PPC campaign. You will want to edit this listing, and make sure the keywords do not match the items you are selling. This method will guide you in the right direction for your PPC campaign.
You must be logged in to post a comment.