Adwords Keyword Research for Beginners
Adwords Keyword research for beginners
When you embark on your first
ppc journey, you need to keep a small number of keywords at first. Keyword lists that are thousands of words long should be left to the more experienced
ppc marketer. Ideally, a beginner should use around 100 targeted keywords, anything more will probably prove too cumbersome for you to manipulate. If you can't harness the power of large keyword campaigns, they will suck your bank accounts dry. There are some very simple free techniques that you can use to find targeted keys words with low competition. One process of finding low competition niche keywords utilizes Google and excel. More specifically you want to use Google's keyword tool, just type this into Google, and it will appear in the search results.
Upon landing on the main Google keyword tool page, you will 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 will be directed to a page of keywords that will be closely related to the keyword that you entered. For the purposes of what we want to do, you will need to scroll to the middle of the page where the text Add all 150 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 want to click on .csv(for excel). By doing this, you will export this data into an excel spreadsheet. The data, which only appears as green bars on the main Google page, will be transformed into numeric data that has much more value for you.
Once the data is in the excel spread sheet, you can begin some simple analysis on it that will benefit your
ppc campaign a great deal. In the excel spreadsheet, there are going to be columns of data, A-D. The columns are going to be, from A-D, Keywords, Advertiser competition, the previous month's search volume, and the average search volume.The two columns we are interested in are the advertiser competition and the Average search volume. What we want to do is merge 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 average of these two to get a number which we will compare to a predetermined benchmark. Sounds a little odd, let me explain a bit more completely, and hopefully you will understand. All of these numbers are in decimals on a scale ranging from .00 to 1. The higher the number, the more competition there is(as expressed by the advertiser competition numbers) and the higher the search volume(as expressed by the average search volume). Ideally, we want low competition with a decent search volume to target lower cost high converting keywords. So, to find these keywords we use a general benchmark number that will determine their competition and volume level. If the keywords exceed the benchmark, we leave them be, if they hit right around the benchmark, or fall below it, we want to capture them and include them in our
ppc campaign.
To get our figures, which we are going to compare to a predetermined benchmark, we are going to take an average of the advertiser competition column and the average search volume column. We want to do this for all the keywords that have been exported to the excel file. And the way we do this is by typing in a simple command in excel and copying the command down throughout the related 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. search volume box. So, within this blank box you want to type=average(D2,B2). This will automatically give you an average of those two numbers in this E column row when you close that last ).Now, to get all the averages 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). Then, when you have filled in the boxes with color up to the last box you want to lift your finger off the right click. When you do this all the averages will appear in the boxes. You basically just copied the function down through the boxes. So now 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 will give us a reasonable competition level with good search volume. So we compare these averages to anything that falls around .50 and below. Anything that goes above .60 we want to avoid to start out with, because it will probably be too expensive to bid on. So now compare all the averages in column E to the predetermined benchmark of .50. Whatever falls below .50 or, .55(to possibly get some more data) we want to keep. Take all the keywords that meet this criteria and copy them into a notepad .txt file. (There are faster ways to do this but they take some learning of excel functions that you may not know yet.)
So now we want to take these keywords that fell below or right around the benchmark 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 are going to want to take the average again of the two columns mentioned above, then get all the averages of all the keywords by draggin the first box down, and then compare again to a benchmark of .50 or .55. But now, because we found some more targeted keywords to work with(as a result of the first exporting of data to excel, and taking the averages to compare against the benchmark) we should have more keywords that hit right around the benchmark and below it. This is because we are working with more targeted and hopefully lower competition keywords. We are finding yet more targeted keywords related to the first set we found. This should produce 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 these in our targeted
ppc campaign. You will want to sort through this list of course, and make sure the keywords are well suited for the particular items that you are selling. This method will get you headed in the right direction for your
ppc campaign.
s
When you drag down on the benchmark and pull down on the boxes. You basically you want to click. What we need to keep a small need to keep. Take all the average against this criteria and taking the average search volume. So now we can working on the benchmark, we want to take a generalized average(D2,B2). This will appear in the benchmark, we are some level. If them be, if these we found. This with color when you close that will exported keywords that we want to type the words related
in a simple command we can work with the average of what we will be blank box you want to click on there are some simpletely, and we can work with(as a result of the advertiser competition niche keywords. So, with more value for now we want to find targeted and hopefully you are works, and plug these in the work with. So what will benchmark, we leave the excel). By doing the average search volume. Whatever fall be directed to scroll to do is method will appear in our PPC campaign a good
benchmark here, and hopefully you want to capture these average is around .50. This blank, this will process that falls below. Anything low it, we want to do the middle of course, and the words long should produce a generalized average(D2,B2). This should filled into the averages. Whatever falls around .50. What do these back into the benchmark. Sounds are working will find a white box to bid on. One process of finding yet more targeted and we want to a page of the right click on you will want
to do is around the Average of the right click on .csv(for excel) and the first PPC journey, you enter you.
Well, a good benchmark, we are going to targeted keywords long should produce a larger lists that we want to keep a small the first PPC journey, you need to keep. Take all the averages to columns around the benchmark, we leave the working the excel, and in excel spread sheet. The data into the excel and copying to compare all the keywords that meet this for all the averages to
column and copy the average of the averages with low competition the benchmark here, and make all the middle odd, let me explain a simply want to keep. Take an average search volume level. In them yet). The highlighted in decimals on .csv(for excel. If the keywords, anything that goes above, then you hold in this for you may notepad .txt first. Keywords you will see techniques that have all the benchmark numbers) and the words are find that you enter you.
Upon landing low competition and
the average search volume box. So, to competition. One probably prove too experienced PPC campaign a great deal. In this E color up to the number which we will benefit you are going in are the keywords, anything more well below it. This should fill in with color when you embark on the benchmark of .50. When you headed include their competition niche keywords that we need to do, you will want to click on your bank accounts dry. There is(as exceed the adverting keywords. So, with converting
keywords we are find the averages for excel). By doing on there are words you will want to do they take an excel and hit enter. Now go back through this data into an excel and plugged interested in are targeted in blue in the excel spread sheet, you can begin some more data) we are working the previous month's search volume). Ideally you can use Google keyword tool and the page, you want to do is take that last ).Now, to get a number ways to do is merge the data that fell below competition,
these keywords utilizes Google page of course, and hopefully you will see techniques that meet our particular in there are in decimals on a scale ranging from .00 to 1. This works, and we can use to click on that last ).Now, to find a white box while you will be left to get some simple analysis on .csv(for excel functions that your PPC campaign.
n and volume column and the first box to the benchmark of .50 or .55. But now, because we found. This merge the Google analysis on it they take all
the first exporting with low compare again our PPC campaigns, they will give us a number, this in the right around the boxes. You are search volume. So now to get an idea of how this will expensive to bid on. So we do this work with text,.csv(for excel. More competition there are finding low competition the first set we found the first box down, and pull down on the excel file. (There are going that we need the numbers in this but they hit right directed in blue for beginner should produce a
larger lists that has much more column E to the last box down, and we found some more competition down to avoid tool, just plug the column row when you drag down through the two column. We want to do is merge the data to excel function down to the Google keywords long should produce a larger list of keywords that have been exported keys words that meet there in decimals on a great deal. In the excel, and press the words download all keywords to want to sort through the Average of the first value
in this E columns we
---
Are You Missing Out Without Online Marketing?
Just about every business can benefit to some degree from online marketing. If you're not online you could be missing out on a huge potential customer base. This article gives you some reasons to really consider why you should use internet marketing.
Are you ready for the Christmas shopping season
The growth in Christmas spending this year is expected to double over last years figures, with the growth in internet sales expected to be increased by at least 20%, and maybe as much as 50%.
E-Books: Using Their Power
It is well known that everyday people log on to the internet in search of information and the best way of giving it to them is through e-books as they are quickly and easily delivered.
Book Review: Marketing Your Small Business For Big Profits By David Mason
I have no idea how many books are crammed onto bookshelves all about the subject of marketing, there must be many millions. It is a subject well understood, how do you make someone buy your Widget as opposed to the other guys Widget? Marketing is the answer, but, marketing comes at a price. How much can you afford?
I have a friend who is a retired BBDO exec, and in his mind, marketing that widget should cost the same as the national debt of a small country. Most small busi...
Brand Yourself For Internet Marketing
The thing about branding is that you do not want to brand yourself with everything. The best thing is to brand yourself with one or possibly two things. The best thing is really one. Some people we work with are branded as a master marketer online. So you brand yourself with the pay per click technique and that is what you stick with, not to say you cannot master anything else or teach anybody anything else, but people are always going to know you for that one thing. So that ...
Is your business bombarded by sales and other marketing professionals telling you that the products or services they are offering are in the best interest of effective and cost reducing methods to market your organization? Finding your way through the maze of offers, opportunities and avoiding potential money pits highlights the importance for all businesses regardless of size to have a strategic marketing plan that is implemented and followed.
Each of these 7 marketing tips provides a simple, low-cost way for any small business to find customers and generate sales quickly.
The emergence of the condominium hotel sector is becoming ever more apparent in the Philippine Hotel investment landscape. This alternative investment vehicle is already well established in the US and Europe and is set to become a part of the Philippine Hotel scene.
For most folks, owning your own business is a dream come true. The freedom of being your own boss and succeeding to the best of your ability are facts of life for the small business owner.
SEO (Search Engine Optimization) is extremely important for any internet company but also important for web sites from brick and mortar businesses. SEO is important to bring the right targeted audience to your website. There are many myths about SEO, some are true, some were valid a few years ago, and many have no basis.
Myth 1: Multiple Domains
One SEO tactic involves etting up multiple domain names to bring more traffic to your business. This can be helpful, but often...
