ATTN SEO MINDS: Is there a way/tool to categorize keywords from an Omniture/GA report?
-
So ideally I would like to take the list of keywords I am currently ranking for, and group these based on what the user intent was in making that query. For example if I am a Thai delivery chain and I am currently receiving traffic from the queries "vegan dish" and "tofu thai food", I would want to have a column in a keyword report that says these queries fall into the VEGETARIAN category. I think what I want to know is how can I filter a massive list by a range of keywords? I want to know does this cell contain, "keyword A" or "keyword B" or "keyword Z". If so list the corresponding category.
This way I can look at keyword performance by category or user intent/motivation.
Is there a tool out there that will help me accomplish this, or is there a good solution in excel I can use?
-
Hi Jonathan,
Firstly, reporting on keyword data from web analytics is a very outdated practice. The reason for this is that Google took away nearly all keyword data. So those reports are junk data.
If you did want to get this data anyway, you could use IF or COUNTIF functions to return those values.
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 important are author bios to SEO?
I'm trying to understand the importance of author bios to Google and its latest algorithms. Some say author bios affect rankings, but others say that has not been specifically stated by Google — but it does affect the user experience. Anyone have input on this? Thanks!
Algorithm Updates | | SallieJ0 -
Will more landing pages with related keywords improve ranking of main keyword?
Hi all, We are in the process of creating new landing pages and noticed something what our competitors been following with landing pages. They have created multiple landing pages targeting the related keywords of a main topic / main keyword. Like "seo defined", "seo history", "seo benefits", "seo strategies", "types of seo", etc being "SEO" as main keyword or main topic. Will this works? Thanks
Algorithm Updates | | vtmoz0 -
More pages or less pages for best SEO practices?
Hi all, I would like to know the community's opinion on this. A website with more pages or less pages will rank better? Websites with more pages have an advantage of more landing pages for targeted keywords. Less pages will have advantage of holding up page rank with limited pages which might impact in better ranking of pages. I know this is highly dependent. I mean to get answers for an ideal website. Thanks,
Algorithm Updates | | vtmoz1 -
Why am i not ranking in the top 50 for the keyword 'cocktails' even though all my other cocktail related keywords are in the first 2 pages of Google???
I have checked the first 50 pages of google for my website www.socialandcocktail.co.uk using the keyword 'cocktails'. It is NOT to be found. However, if I search for other keyword combinations eg cocktail recipes, cocktail bars etc they are all in the first 2 pages! What is going on????????
Algorithm Updates | | cocktailboss0 -
Why is my client's website, ranking higher for serps on bing and yahoo for competitive keywords
My client is in the competitive Private jet charter space. Why is my client's website, ranking higher for serps on bing and yahoo for competitive keywords phrases? like Private jet charter as an example. http://www.jetcharter.com/
Algorithm Updates | | AndrewSEO0 -
Any way to tell if a link has been devalued?
I have some listings in lawyer directories some of which have very hig PR , links, traffic, etc. For example, www.nolo.com, I know that Google has more or less recently devalued a lot of directory links. I would assume that a monster site like nolo would not be one of those, but does anyone know any way to tell? Paul
Algorithm Updates | | diogenes0 -
Addicted to SEO: Please Help!
Hello. My name is Justin. And I am an addict. I have recently starting dabbling around with SEO about five months ago. And I have found myself wanting more and more. I feel like I needed to come to this group of other addicts and admit it to you. I am constantly checking my ranking in Google. I am obsessed with my keywords. And I will sell my soul for a PR8 in-bound link. I desperately want my site: www.findahealthcarejob.com to be the best in the universe and it has been a wonderful drug for me. This must stop. Please help me. What are some steps of your own 12-steps that help you detox from this addicting lifestyle? Thank you.
Algorithm Updates | | findachristianjob0 -
What's the best way to discover which search terms competitors are highly-ranked for?
I'd like to know for which search terms competitors appear in the top 10, but I haven't found an efficient way to do so. Any help is appreciated...thanks!
Algorithm Updates | | actionagainsthunger0