Nerdy Affiliate Adventures In Affiliate Marketing Land

Tutorial: Keyword Grouping With KeywordPad (Freeware)

Posted by JasperP on August 20th, 2008

I’ve been using this excellent free keyword tool called KeywordPad.  You can basically do alot of cleaning, grouping, and modifying with this tool.  The best part is that it’s ABSOLUTELY FREE! You can download it here:

http://www.goodkeywords.com/products/keywordpad/

What I’m going to demonstrate is how I do keyword grouping with this tool.  The first thing I did was get a broad range of keywords from Wordze.  I basically just typed in the word ‘debt’ and it returned a list of 3,334 keywords. You can check out that list here:

WZ_debt.txt

Anyway, the first thing I do is “IMPORT” this list into KeywordPad.

Then I “Delete …Duplicates” and “Clean… Unwanted Characters” and Clean… Trailing/Leading Chars”

At this point, I need to know what keywords to group it by.  So first I “Modify… Sort…Ascending” to view the list.

The next step is to start creating a “Base Keyword” list that I want to group my keywords by.  Since I’m using YSM to test my campaign, I can afford to have larger ad groups.  If I was using Google Adwords, I would limit my keyword groups to 100-200 keywords for each ad group.

Here are the keyword groupings that I chose for this list:

debt consolidation
debt collection
credit card debt
debt relief
credit card
debt management
debt free
debt reduction
out of debt
bad debt

In order to group, I use the “Highlight…Entries That Contain… Words Anywhere” function

Then I either “Export… Highlighted Words To Another List…” Or “Export… Highlighted Words To A Text File…”

I also have to “Delete… Only Highlighted Entries” to make sure the duplicate keywords don’t end up in other ad groups.

What I end up with is these keyword groups:

debt_consolidation.txt
debt_collection.txt
credit_card_debt.txt
debt_relief.txt
credit_card.txt
debt_management.txt
debt_free.txt
debt_reduction.txt
out_of_debt.txt
bad_debt.txt

RESOURCES

If you want to learn more about keyword research and keyword grouping, I recommend the following links:

Keyword Research : Go Deep or Going Wide First?

Keyword Research Secrets to Explode Your Affiliate Business

Uber Keyword Research

Think Outside the Box : Actually Don’t Think At All

Generating Pay Per Click Keywords

So that’s it! I’ve found KeywordPad to help a lot especially when working with huge keyword lists over 10k.  It’s a tool that’s great for newbies especially, since you don’t have to spend a dime on some complicated and expensive keyword tool.

Anyway, If you enjoyed this tutorial, go ahead and bookmark it or send me a comment with your thoughts!

Related Posts

• Niche Research: Brainstorming and Mindmapping
• Project Yahoo: Campaign Progress And Dating Niche Launch
• Twitter Bots.. They’re alive!!
• Interesting Posts From My Google Reader
• Top Blog Posts This Week From My Google Reader