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
-
How to find low difficulty keywords
how to find informative low difficulty keywords. how can I get content ideas? I have lots of content ideas but it's not good search volume on google. I have a kitchen-related affiliate website called https://gloryspy.com
Keyword Research | | MalikJan0 -
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 -
Amazon Keyword Research Tools - Suggestions Please
Hi guys, I'm in need of a reliable keyword research tool for Amazon and Walmart. Is anyone able to recommend a good tool? Free or Paid is welcomed. I've found KeywordTool.io/Amazon and MerchantWords but am struggling to find anything else to compare. I'd love to know your experience with these or any other tools you've used in the past. Thanks in advance 🙂
Keyword Research | | daniel-brooks2 -
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 -
Using a country in your keywords
My company has recently started offering services in South Africa - which is great - same language - lot of potential there. But I suspect our keyword research is suffering from "thinking like a foreigner". i.e. "buy cars South Africa" rather than "buy cars". Wouldn't google.co.za naturally assume: 1) Anyone using their service for "buy cars" is looking for "buy cars South Africa" (I know it's more complicated - Google will give different results the more it can figure out about your location) 2) That any co.za site optimised for "buy cars" is automatically 90% optimised for "buy cars South Africa" too - so isn't a productive long tail query (against something like “buy sports cars”) I appreciate that some companies will be TARGETING foreign browsers (i.e. holiday accommodation South Africa) so will need to explicitly optimise their on-site for the country for “foreign search engines”. But I'm asking about companies in South Africa targeting people from South Africa.
Keyword Research | | Ali310 -
How is the keyword difficulty score calculated in SEOMoz?
The SEOMoz PRO tools provide a keyword difficulty score. How is this calculated? And is it a score for organic search competition or for PPC competition?
Keyword Research | | BenHuntLtd0 -
On-page Keyword Optimization
So I have created a page for the term "denver buick" but the next largest search term is for "buick denver." Should I create another page focusing on this keyword, or optimize one page for both? It's hard to come up with unique content since they are the basically the same term. But most importantly, if I make this new page, how do I incorporate it into the site architecture? Thanks!
Keyword Research | | kylesuss0 -
Invisible Long Tail Keywords
I've been doing some research on SEOmoz and have seen some posts relating to invisible long tail keywords. I have a couple of questions relating to this: Am I correct to understand that an invisible long tail keyword won't show any search in a tool like the Google Keyword Tool? If not, how do you define it? If an invisible long tail keyword has almost no search (or search that can be proven by an SEO researcher), how can you be confident that it will produce results?
Keyword Research | | EricVallee341