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
-
Bye Bye Keyword Difficulty Tool :(
So the Keyword Difficulty Tool will be retired from the end of this month. Is anyone else worried about this? - because I just don't trust the numbers coming back from Keyword Explorer. Never have. I've even raised this with Moz staff previously, when there was a huge difference between the score given by the keyword difficulty tool vs keyword explorer. From what I see in Domain and Page authority and in the SERPs then the score from keyword difficulty tool, was always more accurate, and thankfully have been able to use both tools, but from next month I feel somewhat uneasy about solely relying on the score from Keyword Explorer. Thoughts? and feel free to run your own tests on keywords and I'm sure you'll see what I mean.
Keyword Research | | GregDixson0 -
Ranking a homepage for keywords
We recently found a handful of keywords we would like our homepage to rank for (for example - customer experience). On our homepage we have articles (4-5 posted daily) that feature the keywords we are targeting (one being customer experience). How do the keywords we are using in our daily articles that are posted to the homepage affect the overall keyword ranking for the homepage? In other words do the keywords used in the articles (title, first 2-3 paragraphs, meta description, etc.) all roll up/build up to the homepage's keywords or how does that work?
Keyword Research | | carlystemmer0 -
How can I learn what are the most popular keyword phrases?
I have done a lot of research on Google AdSense (e.g. how to get started, best practices, how much money can be made, custom channels). I want to write a blog post based on my research, but my question is -- how can I learn what are the most common questions about Google AdSense or Internet advertising from a keyword search perspective? For example, are more people searching for "How to make money with AdSense" vs "How to make money with Internet advertising" vs "How to make money with a website"? How do I know which phrase is searched most? It seems to me that I should make my page title, URL, H1, etc. exactly match (or as close as possible within proper grammar) the question that is most often searched. Thanks everyone! Ryan
Keyword Research | | GreenHatWeb0 -
Confirm my thoughts for this keyword
I'm working with a local kitchen remodeler. In reviewing the organic keyword searches for the last month I notice the word "kitchens" appearing in the top 10 keyword searches. Since I know we aren't ranking for the term "kitchens" I dug deeper. A handful of the searches are from the local area but most are one occurence of searches from cities across the US and the world. My surmise is that because there are 2.2 million searches for kitchens every month we just happen to be scraping enough of these searches, irrelevant as they are to our client, to make it look like an important keyword. Most of the visitors using this keyword are gone in seconds. Just wanted some folks to confirm what I'm thinking - that "kitchens" showing up in our top 10 keywords list is a bit of a red herring - and we should focus on more localized keyword searches.
Keyword Research | | DenverKelly0 -
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 -
How to choose Keywords
Am starting a company and in the process of developing the website. I would like to get a head start on content and want to know the best way to choose keywords and tips on how to write optimized content.
Keyword Research | | jclubb0 -
How do you limit the number of keywords that will be researched
I'm working with a client who has a website, but doesn't really have a clearly defined idea of who their key audience is nor do they know what keyword phrases they would like to rank for. I know that I can generate a starting list by reviewing their site, but I want to set some parameters on it so I can provide an accurate estimate. I'm looking for suggestions on how to do this.
Keyword Research | | EricVallee340 -
Keyword Traffic Estimator Tools
Hello, I'm relatively new to SEO and looking to find a good tool for estimating the search traffic volume of different keywords in order to focus efforts on higher yielding terms. Right now I'm using Google's traffic estimator but it doesn't seem to have much data for long-tail keywords. Is anything else out there better or more accurate? Thank you!
Keyword Research | | rawberg0