|
||
The number given for each phrase is the number of searches performed on Yahoo for the previous Month. At this point, if you see a keyphrase that you would like to expand on, you can click on the phrase and get a new search on all terms using that phrase.
Then we test these keywords in Google to see how many pages of info on these keywords there are.
The next thing to do is to enter these keywords in a spreadsheet, we will use excel as an example, but any will do.
You will need four columns of Data.
First column is the keyword list from Overture, which is up to 100 keywords or phrases.
Second column is the number of searches found by overture, corresponding to each keyword.
Third column is the number of pages found by entering the keyword search in Google. The note below the search box says "Results 1-10 of about 3,198,000 for "keyword". This is the figure to enter.
Fourth column is very important. This is the ratio of searches to results. To make it usable, calculate this ratio as follows SearchesX100/Results. In case this doesn't print properly it is Searches multiplied by 100 divided by Results. You must do this calculation for each keyword. (easy with a spreadsheet, but out of the scope of this Article!) The x100 gets the figure to a manageable size, centered around 1.
Now ensure the list is sorted in order of column 2, which it should be if you transferred it from the yahoo printout. Delete any rows where the second column value is "too small" - say less than 500.
Re-sort the sheet in order of column 3. Delete any rows where the number of results is "too large" - say more than 1,000,000.
Re-sort the sheet in order of column 4. We now have a list of keywords, in order of "value", that is greatest demand for least supply.
Eliminate any keywords you don't want, for example off topic words.
Now if you are setting up a niche website, the first keyword in your list is the master keyword for the Home page, the others are one for each of the other pages.
You can use the same principle for Adwords etc.
Note! both Yahoo(Overture) and Google have different searches for Geographical regions, like North America, UK, Australia etc. It is worth looking at different results if you are targeting different markets.
What are the best Keywords to use for my niche product?
What keywords should I use for ad words?
Why is my site not making money?
These are common questions for the newbie, and for many not-so.
With a little experience, you see how much you don't know!
Keywords are a big part of SEO (search engine optimization), and much time, money and effort is spent researching the most popular keywords for a particular use.
What many people forget, is that selling something on the internet, whether it is your site, your product or your affiliate promotion, is really no different from selling anything anywhere.
The thing they always seem to forget is the law of Supply and Demand. If there is a demand for something, you can sell it. If there is a plentiful supply the buyer has plenty of choice, and will not need to buy from a particular supplier or at any particular price.
To make a living selling something, goods, services, whatever it may be, we must have a demand. And to be able to sell our product, the buyer should have a limited choice of sellers.
There are a couple of ways of finding something with a demand. The first is by advertising to convince people they need a particular product - creating a demand. This is what the Ad Agencies excel at. Whether they are selling soap powder or politicians, they can do it. But have you seen the cars the account executives drive? Sounds expensive!!
The second way is to find something already in demand. Not only this but it would be nice if this demand was for something in short supply! Then all we have to do is supply the thing in demand with little competition.
This is how we must choose our keywords. Sure start off with a list of the most popular keywords for your chosen topic, say games. Check overture for games, and get a list using this word. But now check Google and see how much information is available for each of these words.
Find a few with a good "Demand", say over 500 searches in the last Month. Then match them up with the "Supply" from Google (results show "first 10 of 250,000,000 total" etc).
Now work out what gives the best ratio of "supply" to "demand"
(supply should be less than say 1 million). Now the biggest ratio from this little calculation is your Best Keyword, say for the home page of your niche web site. The next ones are also useful, for example one per topic for each page.
Can you see an application to suit your requirements? - it works!