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
-
Choosing the right keywords when the products are similar
What keywords should I choose if I have 3 similar products, only the value differs?
Keyword Research | | Voucherstore 0
It is recommended to use the same keyword, and change the value? Example: Product 1: $ 100 discount coupon
Keyword: $ 100 discount coupon Product 2: $ 75 discount coupon
Keyword:? Product 3: $ 50 discount coupon
Keyword:? Any advice? Thank you, Sergio K.0 -
I'm monitoring the organic keywords for a website, what do their organic keywords tell me?
Should the keywords they already rank well for make good topics for them to exploring in the future?
Keyword Research | | RonkeIR0 -
Selecting keywords
hello, i am using google adwords search terms to find keywords, first of all is that a good practice? If it is then i have the below question: What is most important to take into consideration when thinking of a better keyword: a) impressions b) Most conversotions c) Both in a combination i want to import that keywords in moz pro to see search visibility is that the right way? Which keywords are the most important and how can i chase them? i have to mention here that my adwords account is from 2010 so the data are very much!! Please be specific in for answer thanks in advance
Keyword Research | | anavasis0 -
Need a keyword tool for the whole company
I alone cannot do keyword research on all of the online content that my company produces. There are about 10 publishing support teams who could do this research themselves, once trained, but I don't know which tool to suggest they use since they can't all use my MOZ login. Right now, those who do any research at all are using Google Trends. Wrong answer, but of course they are used to Trends for their social campaigns. Has your company dealt with this situation? I've looked at a few free keyword tools...each seems to have its plusses and minusses. **What would you recommend...either as a free tool or possible other workaround? **
Keyword Research | | Jen_Floyd0 -
How can I "target keywords"?
Hello everyone, Could you please explain how can I "target keywords"? So from my understanding, I do a research on keywords, then find those which I can rank for easily, and then what? Do I build links to my website pages with these keywords? Or do I create different articles on the website with this keyword?
Keyword Research | | moneywise_test0 -
What came first the content or the keyword research?
So I've been searching high and low to try and answer this. I just cant seem to get this part down and i know its the most important part. I always run into the issue where i am building a e commerce or some other site and i have it all set up but no content. So i start doing keyword research. In which the market niche that i am working on now is really broad, so its really hard to research. I then end up getting frustrated because the competition for the words are really high. But back on track, i get frustrated and then kaboom! i don't get the results i want and i am back to square one and no content is made or nothing. So my webpage gets nothing. So i took a step back and wondered, should i make all the content first and then the keyword research and then go back and "revise" my website content with all my keywords that i a trying to target? Sounds like a dumb question but i just wanted feedback and input on how people do this and go forth with everything.
Keyword Research | | Dante130 -
Best keyword research tool
Okay, what is the BEST keyword research tool? I've heard all across the board, but I'm looking for preferrably a free tool, but just want to use one that can do competitive research, as well as find me a ton of long tail.
Keyword Research | | azguy0 -
Keyword Optimization for 2 Brands
We carry two brands, Buick & GMC. All of the most trafficked keywords that I'm finding in my research are structured like this: buick denver buick service gmc denver gmc service How should I approach this situation so that I'm optimizing for both brands?
Keyword Research | | kylesuss0