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
-
Termexplorer good tool for keyword research or not?
Hi Mozzer, Did you have tested the "Term Explorer" tool for the keyword research? Is it a good tool? Can we trust the results? Thank you for your help. Regards, Jonathan
Keyword Research | | JonathanLeplang0 -
How do you check keyword rankings for your sites?
The other day I used Rank Tracker form SEO PowerSuite and SEO small tools ranking checker http://smallseotools.com/keyword-position/ to check a keyword ranking. Both said that my clients keyword is not in top 50, but when I used Rank Tracker from Moz.com it showed that my client's keyword ranks #30 ! What's the tool that works for you all the time and is 100% reliable?
Keyword Research | | vitaliykolos1 -
Keywords with and without diacritics
Hi, I am trying to make my site to appear in the search results even the searched term have or have not been wrote with diacritics for example: "șarpe" or "sarpe". The language is Romanian. If I seach for "Românul cu maşină, marea victimă" or "Romanul cu masina, marea victima" the first result for both searches is the same. I don't see anything special on their html code and I am wondering how do they did it. Regards, Bogdan
Keyword Research | | RIAdig0 -
Google Keyword Tool
Hello, Is the Google Keyword Tool the only reliable source for stats on keyword search volume on Google? The tool returns "no data" results for keywords I would expect to have some, if not much, search volume. I would like to cross-check these results, if possible. Thanks!
Keyword Research | | nyc-seo0 -
Reasonable price for Keyword Research
If I knew what to look for I would do it myself. But I want it done now. The words would relate to one broad category with possible gold that can be mined from 12 sub-categories categories. In my preliminary seat of the pants research I didn't find much in the sub-categories but there were around 10 key words in the broad categories. I am getting a lot of long tail words ranked but I don't believe there is hardly any traffic. Does anyone know what a reasonable estimate is for this degree of keyword research? Also if anyone would like to submit a bid for this work please personal email me. Utah Tiger.
Keyword Research | | Boodreaux0 -
Why are my keywords not being crawled
In my google web tools. the keywords that are about my site are not being crawled. I have them in my Meta descriptions and keyword meta, but still arne't showing in significant keyword list for google.
Keyword Research | | TheGroom0 -
Please help with SEO keyword research
Hi Moz community, I would like to request your collective wisdom. I'm new to SEO and putting together an SEO research and strategy document for the employment service I work for. Have solid skills in Google Adwords and have ran a campaign over the last two years with excellent results. But this SEO thing is a whole new world! That's why who better to turn to than the leading community for SEO professionals? 🙂 Any support, advice, tips would be most welcomed appreciated. It's an employment service and I've got a list of keywords. For example, here are some of the action words I thought could be useful: <colgroup><col width="215"> <col width="91"> <col width="65"></colgroup> [find staff] 0.79 73 [find employees] 0.97 73 [looking for staff] 0.94 58 [looking for staff] 0.94 58 [staff wanted] 0.62 58 [looking for employees] 0.94 46 [look for work] 0.77 36 [looking for workers] 0.93 36 [find workers] 0.91 36 [employee search] 0.72 28 [staff search] 0.37 28 [find an employee] 0.79 22 [search for employees] 0.71 12 [find a worker] 0.66 12 [how to find employees] 0.71 12 My questions: Where to from here? If this was a Google Adwords campaign I would place the words in, create ad copy and test response. But with SEO, are these words useful? Can you target all of these words with SEO - or am I better finding words with higher volume? How many words should I be looking to target? For example, am I only trying to find the 5 or 10 highest volume words, or is it important to target lots of words with SEO? Is it just one set of keywords per page, or can I target all the above keywords on one page? I'm a bit lost. Thanks in advance for your consideration.
Keyword Research | | jasonlewisdiiigy0 -
Keyword Difficulty
is probably a "how long is a piece of string" question but wondered how to use the keyword difficulty tool, particularly in relation to the % and the wording moderate, what are these actually saying? Perhaps some of you could give details of how you use this tool and apply the % and term to real world situations, Thanks in advance, Lee
Keyword Research | | LeeMiller0