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.
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
-
Is good for SEO update blog post dates after update post content
Hello I am updating some posts of my Blog, adding new and fresh content and rewriting some of the existing. After doing that I am thinking to update de post publishing so that I appears on front page of the blog and user can read ir again. But I don't know if it is good for google to change the publishing date of the post that he had indexed 5 years ago. Also I don't know if google will read it again if it is old and see the new changes in order to improve it in search results
Algorithm Updates | | maestrosonrisas0 -
How can I discover the Google ranking number for a keyword in Brazil?
Hello, how can I discover the Google ranking number for a keyword in Brazil location. I need to know what is the position in Brazil location for the keyword "ligação internacional" in the Google search engine for the webpage www.solaristelecom.com/ligacao-internacional. I tried to use the Moz tools to discover it but only shows that I am not in the top 50, then I want to know where I am, and if I am listed or not. I tried to search it in my browser and didn't show the name of my website. Thank you.
Algorithm Updates | | lmoraes1 -
I am wondering if there is a right answer for keywords with alternate spelling.
I work in insurance, specifically CoOp Insurance. I researched on Google trend the 3 different spellings (Co Op, Co-Op and CoOp) and there is search volume for all 3 but no big trends. Moz shows optimization for all 3. Is there a right one to go after? Is the correct spelling the correct one to target, even if it doesn't have the highest search volume? Does going after the misspellings dilute branding, or enhance search visibility?
Algorithm Updates | | Trent.Warner1 -
SEO - Vimeo vs. YouTube
Hi Does anyone have any good blogs or stats on which video hosting platform is better for SEO? I'm guessing YouTube as it's owned by Google - but I'd love some stats to support this for an internal debate. Thanks Becky
Algorithm Updates | | BeckyKey0 -
Ecommerce - SEO Quick Wins?
Hi I wanted to find out if anyone had any quick wins for an ecommerce site & SEO. I am the only SEO and we have a small online team and an ecommerce site with thousands of product pages. It's impossible to optimise everything, and we have taken the top 100 products and optimised them - starting from scratch with keyword research. I'm now struggling to prioritize what we need next - I know we need better internal linking, content, social and lots more, but this isn't something I can get through alone. I need a starting point and perhaps something with a quick win initially? Thanks 🙂
Algorithm Updates | | BeckyKey0 -
Has there been a change in the Bing/Yahoo Algorithm?
I have noticed many of my sites took a beating this month on Bing and Yahoo, while Google stayed pretty flat.
Algorithm Updates | | netviper0 -
Ranking #1 for decent traffic keywords, but not receiving any traffic?
A site I work on is ranked number 1 for a few keywords. To see how much a keyword is searched per month I rely on Google Adwords Keyword tool (https://adwords.google.com/select/KeywordToolExternal). Using this tool I see that the keyword receives 880 local monthly searches and another keyword they rank #1 for receives 1300 local monthly searches. To me these keywords are not the biggest as far as traffic but they are not small by any means. Now here is the issue. Like mentioned above, the site nmber 1 for multiple keywords. They have been ranked number 1 for these keywords for months. Looking in analytics the other day I notice that on a month to month basis both of these keywords are getting 1, or 2 visits. This past month (October) one of the keywords did not receive ANY visits, and that is being ranked #1 for a 1300 monthly searched keyword. It just doesn’t make sense. I would imagine getting at least 100 or so visits a month from these search terms. Could someone please help me understand this a little bit better?
Algorithm Updates | | WhiteHat120