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
-
No SERPs contains my keyword phrase
Hi! I have a question that is the best described by an concrete example: When I use Google UK and search for a keyword "wood floor" why the top 100 search results show pages for "wood flooring" instead? Is it because that keyword is simply more popular and pages are in general better optimized for "flooring"?
Keyword Research | | KAN-Malmo1 -
Any tools to scan URL to identify keyword opportunities
Hi guys, Looking for tools which can scan content and identify keyword opportunities. I know you can use Google Keyword Planner or tools like Semrush. But was wondering what else there is on the market? Specifically looking for tools which can pull relevant keywords by scanning the content, exactly the same as Google Keyword Planner. Cheers.
Keyword Research | | jayoliverwright0 -
Changing Targeted Keywords on Landing Page
So we have a landing page that is ranking for a few of our targeted keywords but we are thinking about splitting the page into two and moving some of the content onto its own page. Our page at the moment has allot of content for keyword A and a little bit for keyword B, we are ranking for quite a few search terms around keyword A and a couple (but allot less) around keyword B, so we want to create a new page with content for keyword B ...hopefully that makes sense... So my question is are there any best practices around this sort of thing? We obviously dont want to negatively affect the rankings we are already gaining for keyword A and I'm worried that moving content around will do that. Thanks!
Keyword Research | | O2C0 -
Keyword Over-usage?
I have a photography page, where there are a number of galleries. In the galleries and thumbnails of each photo I'm selling. These also include the title. It's built dynamically. However, I've noticed when I do an on-page grade check, that one of the places I'm failing is over-using the keyword on the page. This is mainly due to the titles of each photo containing that keyword. For example, there might be a photo gallery for images of the Golden Gate Bridge in San Francisco, and 30 of the 40 images on the page have a title with "Golden Gate Bridge" in them. So naturally, the title is displaying this on the page and showing up 30+ times (after the term is used in the page text as well). Is this a really big problem, or is the benefit on each individual photo page outweighing any hit on the gallery page? Any thoughts? Thanks!
Keyword Research | | shannmg10 -
Keyword analysis tool
Is it not working? I have not been able to use it for the past 2 or so days.
Keyword Research | | JohnWalker0 -
Is there an ideal ratio of keyword difficulty to search volume?
I used the keyword research tool to pull data on potential keywords, the report returns a percentage to represent the competition and difficulty of a keyword. Is there an ideal ratio of percent difficulty to search volume
Keyword Research | | AdviceElle0 -
To Meta Keyword or Not To Meta Keyword, That Is The Question
I can't seem to get a reliable answer on this one. It seems to be split down the middle as far as who agrees and who doesn't, of course some of that content is outdated. So, for today, should I be using the meta keywords tag or not? Thanks, Steven
Keyword Research | | sfmatthews0 -
International Keyword Ranking
I want measure my ranking for keywords in various countries and search engines. If I use a tool such as rank checker to determine my rank for google.uk, google.au.com, etc... is that accurate, or does my IP still affect the rankings I see? If I use a VPS such as Hide My Ass (or another product you would recommend), would that make my ranking results more accurate? I also want to measure my ranking in Russia, where Yandex is very strong so a tool to measure my Yandex ranking + Google would be ideal. What method you would recommend to accurately determine my rankings in different countries? Thank you!
Keyword Research | | theLotter0