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 granular should I get with Keyword research?
I'm doing KW research for a new business. My understanding from KW research guides: Use tools to create a list of thousands of keywords Analyze difficulty and search volume Reduce your list and do on page optimization for your select KWs My dilemma with this approach is that it seems "keyword based" rather than "intent" or "category" based. e.g. Let's say I have a grocery store. Ignoring SEO, I know that these are my main categories: Produce Meat Dairy Canned Goods Baked Goods In other words, the above categories are the general "intents" and "categories" that I'd really want to rank for. Keyword tool shows that they have high volume and high difficulty. Let's say that after doing keyword research, I discover "Low Fat Chicken Breasts" and "Turkey Sausage" and "Cheap Meat Wholesale" have decent search volume and low competition. I don't quite understand how I'm supposed to utilize these fringe keywords in my on page SEO plan because it doesn't make sense as a human to categorize my site that way. Not sure if this is clear. Basically I'm trying to figure out if I should really be getting this granular on keywords to help guide my store categories or if I should just be picking broader terms.
Keyword Research | | clarasboutiqueusa0 -
Keyword Organising
Does anyone know of any tools to aid organising keywords? I'm currently using Excel extensively in an effort to bring some organisation, however it is very labour intensive.
Keyword Research | | seoman100 -
How can I find out which keyword I am currently ranking for?
Hi Guys! Is there an easy way of finding out which key words my site is currently ranking for? And how wwell these keywords are doing in the search engines? Thank you for the help 😉
Keyword Research | | StoryScout0 -
Keyword Planner - search volume for keywords seems to be off. Anyone else experiencing this problem?
Using Keyword planner, I am seeing search volume results which to me look somewhat odd. Anyone else experiencing this? How is this different to the keyword tool used before?
Keyword Research | | seo12120 -
Title keyword and synonyms in content ?
what is the % relation in between a keyword in title and that given keyword's synonyms in a content of that page? if i use the keyword "apple pie" on a page title once, what should be % of reappearance of this keyword in the content ? and its synonyms in relation to the entire content on that page. thank you
Keyword Research | | orion680 -
Ranking Reports for New Keywords
I added new keywords to my campaign. They do appear in my ranking report. But I am not getting any ranking data on the new keywords. It looks like they are yet to be crawled. For my initial set of keywords, i see the specific rankings in each search engine and for some it says "not in the top 50." For the new ones all I see are zeros. Will the ranking data eventually appear?
Keyword Research | | dseevers0 -
What is the maximum lenght in url for keyword ?
Howdy, I was looking at the maximum lenght of url for ntfs and they told me it was 255 character for url and/or folder ect. Does that mean that i could use the full lenght of 255 filled whit keyword for the url on my site ? Thx.
Keyword Research | | Promoteam0 -
Keyword research is tough isn’t it ?
I am only just realising that the Google Keyword Tool I use is aimed at Adwords customers and where competition is stated as low, they mean competition for adverts. When I have a ridiculously low amount of links and an equally low Domain Authority finding keywords is not easy. I presume there is some correlation between the SEOMOZ Keyword Difficulty score and the amount of Adwords traffic, but even very low Adwords Traffic Search Terms still seem to be moderately competitive. I guess its a case of plugging away with the Keyword Difficulty tool.
Keyword Research | | jp_cp1