Keyword Research - Shiny Diamonds Everywhere
This post is a continuation of the Keyword Research lesson “Start Up the Diamond Digger”
Now that AffiliateElite has ran for 14 days, we are ready to get our good “Money” keywords. Once we have these words we are then going to need to decide which words we are going to focus on for affiliate presales content and which ones will be for regular content posts.
Part 1 Filter Our the Good Words
Step 1: Open AffiliateElite and select “Analyze Adwords Competition” and click “OK”
Step 2: Select the campaign from the drop down menu that you want to get the keywords from.
Step 3: Click the “Report” tab.
Step 4: In the “Report” section, right click in the table and select the “Expand All”
Step 5: Click the “TD Ratio” twice to sort from highest to lowest of percentage found
Step 6: Click the “Export” button and then save as a Excel CSV file.
Step 7: The export CSV now needs to be edited to see the best keywords. To do this delete all the columns except “Keywords”, “Total Days Found” and “Total Days Found (%)”
Step 8: Now highlight the three columns and click in the menu “Data” –> “Sort” and then sort by “Total Days Found” and “Total Days Found (%)”
Step 9: Now you can delete all the keywords that were not found atleast 85% of the time. Now copy those keywords and save them in a notepad file (.txt)
You now have a list of keywords that you know have a very good chance of being profitable because they are keywords that advertisers have consistently been spending money on. The challenge now is to figure out which of these words are good from an organic search engine stand point.
This is where we use the Traffic Estimator tool from your Google Adwords account.
Part 2 Finding the Organic Treasures
Step 1: Log into your Adwords account, go to the “tools” section and then “Traffic Estimator”
Step 2: Enter the keywords from the .txt file you created from AffiliateElite and (1) enter them into the top box 1, (2) Enter a Max CPC of 100 and (3) select “all countries and territories” and add. Now click on “Continue”
Step 3: Google will now give you details of each of the keywords. It is important to remember that this data is related to Google Adwords and that means that the traffic estimates are lower then what you might expect from organic search engine listings.
Now you are going to click on the link “Estimated Clicks / Day” and this will sort the data from highest traffic to lowest.
Step 4: Next you are going to start searching for the best words to use for content on your blog. Do NOT use single word phrases, you will have better chances with larger phrases such as three word phrases because these tend to have lower competition. Start at the top of your list and work your way down and what you are going to do is take the keyword phrase and enter it into google search using the allintitle search command…
Allintitle:“keyword phrase here”
You are going to want to find the keywords that have decent traffic and low competition and as a general rule if the allintitle results are…
- Less than 10 000 results = OK
- Less than 5000 results = Good
- Less than 1000 results = Great
Organizing Your Keyword in Order of Priority
With your list of keywords, you now want to figure out which ones are going to be designated to your presales pages and which ones will be best for regular post content.
For your presales content you want to select the words that…
- 1. Have the best traffic potential: Your presales pages will be linked to from every page on your blog and therefore will be easier to rank for in the search engines. These are the pages you want to focus high traffic potential to.
- 2. Are directly related to the product or service you are promoting: Do not select a keyword just based on traffic, the word also needs to relate directly to the product or service. For example if your best keyword is “Red Race Cars” and if the product or service is about “Blue Race Cars”, that might confuse the visitor.
Note: You need to balance this with competition as well. For example if you have a word that has a traffic potential of 100 visitors a day and a competition of 8000 versus one that gets 90 visitors and has a competition of 3000… we would take the little bit less traffic phrase since it will be easier to rank for.
– The End!
Well, that is it for the “Keyword Research” series… we hope you enjoyed it and got some good training from it. As always we appreciate any and all feedback or questions!
PS –> Do not forget to check out the new contest sponsored by Market Leverage… you can Win a New iPhone 3G
Keyword Lesson Series:
- Lesson 1 - Keyword Research: What are you Basing it On?
- Lesson 2 - Keyword Research: the Cart before the Cow
- Lesson 3 - Keyword research: What for may we ask?
- Lesson 4 - Keyword Research: Show me the Money… Words that is…
- Lesson 5 - Keyword Research: Diamonds in the Rough
- Lesson 6 - Keyword Research: Start Up the Diamond Digger
- Lesson 7 - Keyword Research: Shiny Diamonds Everywhere
If you enjoyed this post, make sure you subscribe to my RSS feed!
[...] Lesson 7 - Keyword Research: Shiny Diamonds Everywhere Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages. [...]
[...] Lesson 7 - Keyword Research: Shiny Diamonds Everywhere Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages. [...]
[...] Lesson 7 - Keyword Research: Shiny Diamonds Everywhere Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages. [...]
Hi John,
thanks for the extensive keyword research tutorial !
I’ve an additional question, I blog also in italian language for that I’m looking for a keyword suggestion tool that provides results for keywords in italian. As long as Overture does no more giving acces to it’s DB, I’m no more able to get valuable results with my actual tool (Niche Inspector). Do you know another tool which gives me results also in italian ?
thanks in advance
ciao
alexander
Big Bloggers last blog post..SEO Tip: Seductive, Sexy Keyword Titles
I have been using Google adwords keywords tool, keyword Elite and Wordtracker for keyword research. And wordtracker being my favorite tool for doing keyword research
This was a great lesson.
Embarassingly…I have been running jobs on Affiliate Elite but did not see the report tab! This is where the gold is and with your outline above I have found a number of great keywords already.
Thanks once again.
Clint.
http://www.secretwebvideos.com
Cow, i’ve heard of Affiliate Elite and I’ve heard of Xconversions or something like that. What should I use?