Effective keyword grouping - any suggestions?

[DeptAgency]

I have a specific question regarding keyword grouping. Whenever I've have compiled a (long) list of keywords, I create smaller groups of keywords that can be targeted by a category or page. However, I find this to be quite labour-intensive as I'm doing this work manually through filtering in Excel.

To illustrate what I mean, here's an example of a keyword list:

baby shirt
t-shirt for baby
pregnancy shirts
pregnancy gifts

Normally I would create a list of root words, like this:

baby
shirt
pregnancy
gift

I would then manually filter the list on each root word and copy the filtered list to separate tabs, which would result in lists like this:

baby
baby shirt
t-shirt for baby

shirt
baby shirt
t-shirt for baby
pregnancy shirts

etc.

As you can imagine, this is a lot of work. So my hope is that you can help me out with a smart tool / Excel formula / ??? to automate this process.

Thanks for any suggestions!

[Francisco_Meza]

Are you using this for Google Adwords. Because if you are, I see a BIG problem with that strategy. Basically you will be competing with you own self for the keyword Baby Shirt & t-shirt for baby. Most likely you will have them in different campaigns or adgroups and all google is going to do is show the one with a higher bid.

[DeptAgency]

Hi Francisco,

Actually I'm only using this for SEO solely, and the purpose is to easily spot the most valuable keyword (in terms of search volume, competition, conversion rates etc.) as well as have some synonyms and related words grouped together to vary product copy.

[Francisco_Meza]

Your product category pages should only focus on 1 or 2 keywords. If you come out with a lot of keywords on one page, it may look like you are keyword stuffing. The only way to tell which are going to be your best keywords is by hooking up Google Analytics and setting up conversion goals. This will tell you he value of the keyword.  If you are using Google adwords, it'll tell you if a particular keyword is making or losing you money.

I always break things down into categories.

Mens shirt, Womens shirt, Baby Shirt, Dog shirt.  You won't run into so much duplication like you would with the two categories you are talking about (baby & shirt).  Use the Control F in Excel to find and replace duplicate keywords.