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
-
Keywords with different spelling depending on country.
Hello, My product sells in both USA and UK, childrens sleepwear. I am not quite sure whether my onsite optimisation should be for "pajamas" or "pyjamas", or do I need both terms? Can someone please advise the best option? Thanks Astrid
Keyword Research | | Lilala_Kids0 -
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 -
Is the Adwords keywords planner accurate ?
Hey guyz,
Keyword Research | | atakala
As you guyz do, I base all my seo effort into the keywords' traffic and quality which I can get from Adwords Keywords Planner.
But this post has confused my mind .
It' says the average searches doesn't exactly the average searches.
And everything is okay here now I can say that of course it's not %100 accurate.
But the shocking part is he gives an example of how a big gap there is between real searches number and adwords keywords planner tools give us . What do you think guyz?
Can it be true ?
(And also last time I asked a question, Randy has replied me, If possible please Randy do it again :D.)
Best wishes.0 -
Local Keywords
Hello everyone. Still loving MOZ. Question: When I research a keyword phrase such as Entertainers it is returning a local search of 15,972. I want to target three specific cities in my area ( Pittsburgh, Cleveland, Akron). When I research the phrase Cleveland Entertainers I'm getting a local search result of 0. Should I just assume that the search is still large enough to use? Should I target Cleveland Entertainers still with feedback of 0? Also is it a good idea to target the word entertainers with three separate pages to three separate cities? I'm planning on making three separate blogs with new content on each. This will not be duplicate content.
Keyword Research | | Jasonalanmagic0 -
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 to interpret the keyword tool?
I've played with the keyword tool a bit. Some keywords have 43% difficulty and some have 55%. What do these difficulty levels mean? I don't really know how to go about it.
Keyword Research | | sleepmaster0 -
Keywords
I'm working on an e-commerce site and I'm having trouble determining how to find keyword targets for similar product pages. The company sells posters and they have three posters for Babe Ruth: Babe Ruth Winning, Babe Ruth Attitude and Babe Ruth Desire. After doing keyword research, I found there is a good amount of traffic for "Babe Ruth Posters" but none for "Babe Ruth Winning Posters," "Babe Ruth Attitude Posters" and "Babe Ruth Desire Posters." How can I differentiate these three product pages? Can I optimize them for a term that doesn't have traffic, hoping that one or more of these pages will come up when someone enters the search term "Babe Ruth Posters."
Keyword Research | | EricVallee340