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
-
Paid vs Organic Keyword Optimisation
Hi Im wondering whether I should optimise my site with Organic search terms that drive traffic to the site or the paid terms i use in Google search ads?
Keyword Research | | aplnzmarch180 -
Is my copy too keyword rich?
www.heartwavemedia.com - Wordpress - All in One SEO Competitors: photonsf.com, h2video.com, corduroymedia.com, thehivestudios.org I've spent the last week writing and tweaking my landing page copy along with my SEO page titles and descriptions. I think I finally feel pretty good about it but I'd like your professional opinions. Is it too keyword rich? Does it flow naturally? Is the voice fresh? Do my SEO titles vary enough? Thanks in advance for your thoughts and advice.
Keyword Research | | keeot1 -
What came first the content or the keyword research?
So I've been searching high and low to try and answer this. I just cant seem to get this part down and i know its the most important part. I always run into the issue where i am building a e commerce or some other site and i have it all set up but no content. So i start doing keyword research. In which the market niche that i am working on now is really broad, so its really hard to research. I then end up getting frustrated because the competition for the words are really high. But back on track, i get frustrated and then kaboom! i don't get the results i want and i am back to square one and no content is made or nothing. So my webpage gets nothing. So i took a step back and wondered, should i make all the content first and then the keyword research and then go back and "revise" my website content with all my keywords that i a trying to target? Sounds like a dumb question but i just wanted feedback and input on how people do this and go forth with everything.
Keyword Research | | Dante130 -
How effective the use of preposition in title tag?
I would like to know the value of preposition on title tag and the impact on search engine queries. As for example, I would like to know the difference between TOURS TO NEPAL and TOURS NEPAL keyword, how they had a impact on search engine queries.
Keyword Research | | SuMoksha0 -
Keyword research
i am trying to figure out what would be good keywords to optimize for an orthodontist. i looked up the keywords "his city + orthodontist" or " his city + braces" and the google adword tool tells me there are no monthly searches for those terms. i am not sure what i can optimize for if no one is searching for the most obvious keywords.
Keyword Research | | dad7more0 -
Is there a way to check what keywords a competitor is ranking for?
Hi Guys I have been working on a site and I'm doing better but I just want to ensure I am covering all the bases. I have a list of competitors and I want to see if I can find out what keywords they are ranking for so I can research and see if there is any merit in me trying to rank for those keywords also? Is there any software or processes that any of you can recommend? Thanks
Keyword Research | | RankStealer0 -
No idea where to start with keywords
I have a friend who owns an IT business in Pennsylvania. I have been on the adwords tool begging for keywords that people are searching for and I am getting no search results at all. I have tried all types of combinations- IT consultant Pennsylvania IT consultant PA network solutions pennsylvania computer tech pennsylvania ...and many variations thereof. Does this mean that maybe just no one looks for this type of business on google? What would you guys do in this situation? Thanks!
Keyword Research | | GroundFloorSEO0 -
Best Keyword Research Tool
Can anyone please recommend the best keyword research tools available, we specialise in the travel industry and struggle to find new keywords as the more niche ones always show no traffic searches in the google keyword tool so it is really difficult to make a judgement. We know from google analytics that some niche keywords really are useless and while they are no. 1 they generate no traffic. I hope you can help Thanks! Andy
Keyword Research | | iprosoftware0