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

Niche Research: Brainstorming and Mindmapping

Posted by JasperP on August 15th, 2008

I had a consultation with Derek at ClickConsultants and he advised that I create a mind map in order to brainstorm all the possible phrases and keywords used in the debt relief niche I’ve been working on.  Since my campaign hasn’t been performing as I liked, I started from scratch in order to get a good idea of my niche.

So I went through Google looking for phrases to discover more about my niche.  As I was doing that I put them in a mind mapping software called Freemind.  This software is free and you can get it at:

http://freemind.sourceforge.net/wiki/index.php/Main_Page

Anyway, here is the mind map that I came up with for the debt relief campaign

Now, I didn’t just combine words and just throw them in a list.  I basically used these to create a base keyword list and started plugging it into keyword tools like Wordtracker, Wordze, and the Adwords Keyword Tool.

I ended up with around ~50k, but after grouping them by 1,2,3-kw phrases, I ended up with a list of ~27k keywords.  I just re-imported them back into Yahoo and YSM declined about 6-7k, which left me with 19k in my campaign.

To sum it up, it really helps to discover the terminology and wording used in your niche.  Use it as a guideline and start plugging them into the keyword tools.  Use your brain, use the search engines and then use the keyword tools.

Related Posts

• Project Yahoo: Campaign Progress And Dating Niche Launch
• Tutorial: Keyword Grouping With KeywordPad (Freeware)
• Free Pay-Per-Click And Internet Marketing Tools
• Project Yahoo: YSM -> CPA Networks
• Twitter Bots.. They’re alive!!