Effective keyword grouping - any suggestions?
-
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 giftsNormally I would create a list of root words, like this:
baby
shirt
pregnancy
giftI 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 babyshirt
baby shirt
t-shirt for baby
pregnancy shirtsetc.
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!
-
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.
-
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.
-
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.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
I have two keywords. If I combine them do I get credit for both keywords?
For example I have a keyword - IPA Beer, and I have a keyword - IPA Beer Kit. If I use the keyword IPA Beer Kit will I get the benefit of the IPA Beer keyword as well as the IPA Beer Kit keyword? Hope this makes sense. Thanks in advance for the help!
Keyword Research | | brewngrow0 -
Can I use my keyword in brackets '( )'
I need to sort my product keywords in the countries: (UK) (USA) (Global) etc. What does putting my keyword into brackets do - does it negatively affect my SEO?
Keyword Research | | crocman0 -
How to leverage keyword research on-page.
I'm a newbie and I'm a little embarrassed to ask this question, but here it is. Let's say I've done my keyword research and have 200 keywords. How do I use that for on-page/site optimization? Or do I not use it for on-page/site optimization? I guess I'm unclear about the relationship of keyword research and on-page/site optimization. Thanks.
Keyword Research | | swolock0 -
I understand it's been asked before, however moz staff is telling me keyword's capitalization is treated as a separate keyword.
So there I was looking through my rankings like every other day, when I see a lowercase and uppercase version of a keyword. Most times I see this, I see them with the same rankings, and even researched this about 5 months ago, when I came to the conclusion that google treats them the same way. However, this day I saw them as different ranks, same keyword, only capitalized 1st letter of the 2 word keyword. I asked moz staff about this, as I felt it was an error. But was met with the answer that google does indeed treat these keywords differently. My line of thought was that the rank checker didn't check both the lowercase and uppercase keyword at the same time, and SERPs happened to change when the second word was checked for rank, returning a different rank. So now, I am in doubt again, as to uppercase and lowercase keywords being different or the same in google's eyes? I honestly don't know why a uppercase keyword would have different motive from searcher than a lowercase when many time not, searchers can't even spell the keyword correctly.
Keyword Research | | Deacyde0 -
New Rules Keywords of Google Panda
Hello Everyone,.. I want to ask regarding my confusion of Keywords. How does search engine see the keywords? and find the website that is matched with the keywords. So this is what I mean: When I type keywords "luxury dog clothes" at google, then the website which is showed up, is nothing using keyword of "luxury dog clothes". But then appeared websites which in bold words are "designer dog clothes", "dog clothes", "designer dog" . Can anyone please help me to explain why Google shows the website which is not identical matched keywords "luxury dog clothes" that I am looking for? I read at the beginer guide SEO, that the good keywords must be placed at the front of the title then in the body description, placed no more than 2 times. But in fact, for the example above, there is nothing words of "luxury dog clothes" placed at the title and in the body description. This makes me very confuse how to determine the right keyword for mine, especially the long tail keywords. Thank you everyone. Hopefully you all can help me to explain as I am a newbie at SEO.
Keyword Research | | Jesslyn0 -
Can I target the same keywords on multiple sites?
I am launching a series of geographically specific sites to support my main website. Is there any problem with targeting the same keywords on both sites?
Keyword Research | | theLotter0 -
How do I make sure my homepage ranks better than my 2nd page when I need the same keywords for both? I don't want them competing against each other for keywords.
I seen here on SeoMoz something about more than one page having the same keywords so they don't compete against each other for the same keywords that makes sense to me. But I would like my main page (homepage) to be ranked better over time rather than the 2nd page or do I just not care about the second page ranking at all and don't SEO the page very well? ,Both pages have similar content so I need the keywords for both. So im very confused on what to do with the second page. Thanks in advance to any helpful answers, i am a newbie when it comes to SEO.
Keyword Research | | DreamKandy0 -
Page keywords
How many keywords should the home page of a Real Estate site be optimized for?
Keyword Research | | bronxpad0