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 -
Exact Long Tail Keyword Wording?
Hi everyone! I'm currently doing long tail keyword research and I'm coming across keywords such as deer wall print for nursery for the main keyword "deer wall print" which doesn't really incorporate too well into a into a grammatically correct paragraph. Can I use something like **deer wall print for your nursery **or deer wall print is perfect for in a nursery? Does it have to be exact reproduction if I am trying to rank for a long tail keyword term/phrase?
Keyword Research | | TheFlyingSweetPotato0 -
Image alt attribute - keyword stuffing?
If on the page (blog post) there is a lot of images and they all have the same alt attribute - is it keyword stuffing?
Keyword Research | | templatemonster0 -
Keyword Help For Articles
Hello, My site is bobweikel.com Article page is here. Could you guys help me with keywords for new and existing articles around weight loss? Some ideas, though I'm unsure: weight loss tips healthy weight loss permanent weight loss weight loss program weight loss diets weight loss coaching weight loss life coaching weight management
Keyword Research | | BobGW1 -
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 -
How Can I Rank My One Keyword ?
I read many places about never use the same keywords/anchor text this will consider as spam by google, so i want to know if suppose my main keyword is Indian bridal sarees than how can i give rank to that keyword, should i use the same exact keyword but in different format like bridal indian sarees or indian bridal sarees shopping something like that. Should i use LSI keywords in that keywords. Please help Second, I also read some people saying they use 70% primary keywords and 30% LSI or generic words, so that mean if i have 10 articles so in 7 articles i have to give primary keyword and the rest of the 3 will be generic. Kindly please advice this also.
Keyword Research | | chandubaba0 -
Keyword and Keyphrases
I'm looking to optimise my website for some keywords and keyphrases I'm getting a bit confused on how different pages might compete (or help) each other. As we are an automotive dealer I was thinking about building the hompage around 4 keywords (one for each franchise we represent e.g 'Ford'). These show high local monthly searches and medium competition for just the manufacturer name on its own. Then if someone drills down into a franchise homepage (linked from our homepage e.g. www.ourwebsite.com/ford) I was thinking to optimise the page around e.g. 'Ford Dealer' (which has medium local monthly searches and high competition). Then if someone drills down into a particular model I optimise around that and so on. Question is will I be playing the franchise homepage vs the group homepage (Ford vs Ford Dealer) as I have read here on Keyword Cannibalization? Or will it work together? Alternative I guess is not to focus around a franchise on the group homepage and then only focus on the franchise from the franchise homepage onwards but I feel I would be missing a trick? As a new kid on the block help will be most appreciated.
Keyword Research | | design_man0 -
Targeting Keywords from the homepage
I tend to focus on two or three main keywords to target from the homepage. In fact come to think of it from all pages. Do you target up to 10 keywords of more from one page. Taking longer tail keywords into consideration. Granted the limits to any phrase or keyword group.
Keyword Research | | onlinemediadirect0