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 .com and .me effect SEO?
Hi, We have a project https://www.shipwaves.me/ and https://www.shipwaves.com/ and however if we are doing SEO for .me domain - is this give early results like as .com domain. I'm not sure that .me is in the category of .me domains. Well, if we are following the same strategy as like following for .com domains - is that the results will be the same or not. Also, in terms of any additional strategy to be done to make the SEO little faster for the .me domain. Guys, please share your thought on this.
Algorithm Updates | | LayaPaul0 -
Should I target low competition related keywords to rank my main keyword?
Hi everyone, I created a product review based blog about finding the best outdoor basketball but it's MOZ keyword difficulty is increasing drastically. I'm finding it difficult to rank. Is it a good practice to target low competition related keywords to rank the main keyword?
Algorithm Updates | | rosie16
Please advise, Thank you!1 -
How important is Social Media for building domain authority / Google rankings? Are there any cases?
I really would like to know if someone tested the importance of Social Media for Google rankings.
Algorithm Updates | | Seeders
Are there some sites who build authority only by doing good social media?
Ofcourse, I know it is all about the mix (content, linkbuilding, social media, etc.) but how important is it?
I know many sites who rank good without any form of social media, but I do not know any sites who do only social media and rank high. I hope there are some good cases which give good insight. ps. I know it becomes more and more important...0 -
How much does a keyword focused domain matter today?
Is it still better to choose a keyword focused domain lets say over a branded domain in today's world? How much of a part does that have in the grand scheme of things?
Algorithm Updates | | HiddenPeak0 -
Why SEO
Hi Guys, it's going to be a long one so thank you from advance for your patience. First i wanted you to i am new to SEO world and this world excites me In the last 30 days, i started to check my companies (i am employee not an owner) website in SEO point of view. What we do: Online grocery shopping and home delivery www.artizone.com I will share with you some of the results: 5482 errors for duplicate page content 8850 errors for duplicate page title 37 title missing or empty some pages had 4+ H1 tags many more HTML errors. page authority 42/100 domain authority 40/100 We have no listing 163 back-links domain to our Dallas & Chicago website and much more another thing i checked was where are we for the keywords that we are interested in: "online grocery shopping Dallas" - position 1 in Google search shop for groceries online Dallas - Position 1 in Google search shop for groceries from home Dallas - Position 1 in Google search And some more and the same for Chicago I Did all the searches in new incognito window My Question - how come we build our website so bad, with no Google+, we have very few back-links(compare to our competitors) and the page and domain rank are so low and still we are in the 2 or 3 highest position in Google search One more question - Why to invest time in fixing all the SEO issues i found? You are all welcome to have a SEO view in my website Thank you vest much Ivgi
Algorithm Updates | | iivgi0 -
Non .Com or .Co Versus .ca or .fm sites - In terms of SEO value
We are launching a new site with a non traditional top level domain . We were looking at either .ca or .in as we are not able to get the traditional .com or .co or .net etc . I was wondering if this has any SEO effect ? Does Google/Bing treat this domain differently .Will it be penalized ? Note : My site is a US based site targeting US audience
Algorithm Updates | | Chaits0 -
Is there a way to know what rank my site is listed on google ?
My current client web page was listed at the 4th page 1 month ago. Im trying real hard to make him understand that the traffic from beiing on the first page is important and that he need to give me additionnal ressource to make it happen ( i don't prog at all). So i had the idea of checking every page to see whats is current rank. but instead of looking from page 1 to page X, i was wondering if there was something somewhere that could give me my rank right away. It woud help saving time. Thx.
Algorithm Updates | | Promoteam0 -
How does an exact match domain.me rate for SEO
Anyone have any idea how an exactly matching keyword (using the "domain.me" register) will compare against an almost matching keyword in the Google .ie search engine. (assuming that on and off page SEO will be the same). eg, www.wigets.me against www.mywigets.ie Thanks
Algorithm Updates | | peterds2