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
-
Moz keyword rank checker
The Moz Keyword Ranker does not seem to work - it keeps buffering when I add a keyword, Anyone see the same thing?
Keyword Research | | SmartSimple0 -
Point of diminishing returns for keyword research?
Hey, something I've been thinking about lately is "where is the point of diminishing returns for keyword research detail?" I get that keyword research is important for finding out stuff like "people generally search for 'doctor' way more often than they search for 'licensed medical professional'", but what about after that? Is there much useful information to be found by sifting through spreadsheets of stats about "doctor" vs "dr" vs "doctors" vs "physician" vs "physicians" etc? Especially when Google seems to treat a lot of those as interchangable? Or another example: If a remodeling company did basements, do you think there's much to be gleaned from AdWords data comparing "basement remodeler", "basement remodelers", basement remodeling", "basement remodeling contractor", "basement remodeling contractors", "basement renovation", "basement renovations", "basement renovators", "finished basements", "basement finishers", "basement finishing", etc.? Should those variations be analyzed and each targeted by their own sets of pages and pieces of content (e.g. a blog post that specifically targets "basement remodeler" and a blog post that targets "basement finisher" and a third blog post that specifically targets "renovated basement") Or should the takeaway be "there aren't any combinations that people overwhelmingly prefer to use, so let's just make content about basements and topics relevant to basements. Keyword research complete."
Keyword Research | | BrianAlpert782 -
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 -
Should I concentrate keyword ranking locally or nationally?
Hi all, I have spent few last days reading here in community and watching Moz videos about keyword research. I used keywords planner tool. Here is the question. When I researched keywords I took into account search traffic nationwide UK rather then my local search volume. My photography business operates more for local customers rather then nationwide. Does it mean that I need to concentrate on my local city/region search volume rather then nationwide. After I have done Nationwide keyword research I realised that most of those keywords which are with really high search volumes are pretty much non existent in my local search results. I meant to the point that keyword search volume is under 10. Considering that I have small number of pages i could use them for, my guess is that it is no point to target those high search volume keywords as most likely those won't be my clients anyway. I might be getting all this wrong, but wanted to ask here. Thank you all, Regards, Armands
Keyword Research | | A_Fotografy1 -
Keyword Conundrum...
I have 3 keywords that I am targeting. Assume for the time being that they are all equally competitive. Includes local exact match monthly searches: Managed IT Services - 3600 IT Managed Services - 720 Managed IT Support - 170 They are all exactly synonymous, not to mention other keywords such as IT Managed Support, Managed IT Service, IT Managed Service, Managed IT Service Provider, etc.. My current strategy is to target the top 3 all on one page. The problem then is the title tag: Managed IT Services | IT Managed Services | Managed IT Support Pretty spammy. I could build pages for all 3, but how would I incorporate them into the website since they are all synonyms. Can I get some recommendations on how to handle this? What would you use for a title tag? How would handle separate pages with synonymous content?
Keyword Research | | CsmBill0 -
Keyword Difficulty Report
Hi I am a seo beginner, please help me to know and usability of Keyword Difficulty Report. Actually, i see the difficulty percentage is 28 for a keyword and i have option to generate defficulty report. Bit confused how can i use this?
Keyword Research | | Webworld_Norway0 -
Should i go with 50% Keyword Competition ?
I just checked through seomoz keyword tool and found one of my keyword which "Photoshop Stroke Brushes" have around 50% competition.. should i continue to go with or can you suggest me any same keywords ?
Keyword Research | | xplodeguru0 -
Are the Volume numbers from the Keyword Difficulty Tool identical to Google Adwords Keyword Tool?
I use the Keyword Difficulty Tool daily. Because of the troubles with Google's API I can no longer see the search volumes. I still want to use the tool for difficulty numbers because I think this is a much better number than the Google Adwords Competitive bar. If I use the Adwords keyword tool for volume numbers, will that be sufficient? Is this the same as what Moz usually provides? If no, where is the best place to gather volume numbers? Thanks!
Keyword Research | | KevinBloom0