AdWords Keyword Research for Beginners - AdWords Keyword Research for Beginners 660x330 - AdWords Keyword Research for Beginners

AdWords Keyword Research for Beginners

When you start your first PPC journey, you first need to keep a handful of keywords. Keyword lists thousands of words long should be reserved for more experienced PPC marketers. Ideally, beginners should use around 100 targeted keywords, any fewer may be too cumbersome for you to work with. If you can’t harness the power of large keyword campaigns, they can suck your bank account. You can use some very simple free techniques to find targeted low competition keywords. The process of finding niche keywords with low competition using Google and Excel. More specifically, if you want to use Google’s keyword tool, just type it into Google and it will show up in the search results.

When you land on the main Google Keyword Tool page, you will find a white box (box) where you can enter your specific keyword. Start by typing a keyword to see how it works, then press Enter. After hitting enter, you will be taken to a page of keywords that are closely related to the keywords you entered. For our purposes, you need to scroll to the middle of the page and the text Add All 150 is highlighted in bold blue. Under these terms, you’ll see the terms download all keywords with text, .csv (for Excel), and .csv. You want to click .csv (for Excel). This is how you export data to an Excel spreadsheet. Data that appears only as a green bar on the Google homepage will be converted into numerical data that is more valuable to you.

Once the data is in an Excel spreadsheet, you can start with a simple analysis that will greatly benefit your PPC campaign. There are columns of data in an Excel spreadsheet, A-D. The columns are from A to D, keyword, advertiser competition, last month’s search volume, and average search volume. The two columns we are interested in are Advertiser Competition and Average Search Volume. What we want to do is combine the data from these two columns to give us a number we can use. So what we need to do is take a generalized average of the two to get the numbers we are comparing against a given benchmark. It sounds a bit strange, let me explain in more detail, hope you can understand. All of these numbers are decimals from 0.00 to 1. The higher the number, the more competition (in terms of advertiser competition numbers), and the higher the search volume (in terms of average search volume). ). Ideally, we want low competition and decent search volume to target low-cost, high-converting keywords. Therefore, to find these keywords, we use a common benchmark number to determine their competition and volume. If keywords exceed the benchmark, we leave them as-is, and if they are near or below the benchmark, we want to log them and include them in our PPC campaigns.

To get our number, we compare it to a given benchmark, we average the advertiser competition column and the average search volume column. We want to do this for all keywords that have been exported to an Excel file. To do this, we enter a simple command in Excel and copy it into the relevant field. At the beginning we find field E2, which should be empty, which is the first field to the right of the first value in the mean. Search volume field. So enter =Average(D2,B2) in this empty field. When you close the last one, this will automatically give you the average of those two numbers in that row of column E. Now, to get all the average scores for each keyword, just click on this box (E2) and drag the box down while holding down the right mouse button. When you drag to the last box, the box should be filled with color (there is nothing in it yet). Then when you fill the color to the last box, you want to take your finger away from the right click. When you do this, all averages will appear in the box. You’re basically just duplicating that functionality through the box. So now we have all these averages. What do we do with them and what do they tell us?

Well, a good benchmark average is around 0.50. This gives us a reasonable level of competition and good search volume. So let’s compare these averages to anything 0.50 and below. Anything above 0.60 is something we initially wanted to avoid as it might be too expensive to bid on. So now compare all the averages in column E with the given guide value of 0.50. Anything below 0.50 or 0.55 that we want to keep (more data may be obtained). Get all keywords that match these criteria and copy them into a Notepad .txt file. (There are faster ways to do this, but they require you to be familiar with some Excel functions that you may not be familiar with.)

So now let’s paste those keywords that are below or close to the benchmark back into the Google Keyword Tool and hit Enter. Now go through the entire process we just did to get the keywords we just put into the Google Keyword Tool. You will need to take the average of the above two columns again, then get all the averages for all keywords by dragging the first box down, then compare to the benchmark 0.50 or 0.55 again. But now that we’ve found some more targeted keywords to use (as a result of first exporting the data to Excel and comparing the mean to the benchmark), we should have more keywords right around and below the benchmark . This is because we use more targeted and less competitive keywords. We found more targeted keywords related to the first sentence we found. This should generate a larger list of keywords that match our benchmark. So now we can use benchmark-compliant words here that we can use in our target PPC campaigns. Of course, you should go through this list and make sure the keywords are a good fit for the specific item you’re selling. This approach will give your PPC campaign the right direction.

Leave a Reply

Your email address will not be published.