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
-
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 -
Using Brand value for SEO: Can we use keyword with brand name?
Hi Moz community, I am curious to know this. Let's say there is a brand value for a company. It has it's own popularity that it's been mentioned across the internet and social media directly with brand name without their service or industry keyword. Now if the company started promoting themselves like keyword along with their brand name, will it help them to rank for that keyword. For example, Moz is already famous, now they want to rank for "SEO" and related keywords, so they started calling themselves on internet "Moz SEO"; will this fetch them in ranking for keyword SEO? My ultimate question is, using primary keyword along with brand name will work out in ranking for that primary keyword or not? Thanks
Algorithm Updates | | vtmoz0 -
New feature in seo results with icon?
I have never seen it before in the search: an icon in the title. Do you guys know how to get this icon in the title? See here: http://snag.gy/e7BiI.jpg e7BiI.jpg
Algorithm Updates | | Emilija1 -
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 -
Why am I getting different Google SERP result for same keywords?
Hi Mozzers, I have noticed recently that Google (.com.au) has been serving up different SERP results for the same keywords. For example, one of our main keywords is "Car Loan". One result will show our site as ranking #5 organically from 242,000,000 results. A refresh of this search will then result in our site not ranking at all from 133,000,000 results. We have been noticing this happen only in the last few days & more frustrating is that Google is throwing up the SERP from 133,000,000 results more frequently. Would anyone know why this is occurring? And what can we do, if anything, to ensure we are shown regardless of how many results Google calls from? Is it from recent algo update & will it settle down over time? Any help would be greatly appreciated. (Just to add - I'm not gogged in to Google when completing this test & regularly clear cookies etc so I don't believe its a personalised search issue)
Algorithm Updates | | 360Finance0 -
50% of my keywords just had a significant drop for no reason no changes?
I just looked at a report for one of my sites in moz pro and Improvement: 35 slots 35/75 keywords just dropped on google, I didn't make any changes recently Ranking Changes Improvement: 12 slots 12 Improved Improvement: 35 slots 35 Declined Many dropping 5 - 22 places! Any ideas on whats up, thank fully it didn't effect traffic, its pretty low anyways, but it has stayed the same... But still dropped to page 5 for lots of stuff. Strange. Did google just update or something? Thanks for any ideas.
Algorithm Updates | | syndicate0 -
SEO Ranking & Brand Names
I have several situations where one of my sites rank organically in 4th or 5th place for a specific search term relating to a 'big brand' .. I usually fall in behind the brands main website .. commercially this is very good for me. Let me give you an example .. in google.co.uk type in 'thomas cook exchange rates'. I rank position 4 (comparecurrency.co.uk). Position 1-3 are thomas cook's own pages. Naturally. However, my question is .. could I outrank them and how could I initially measure the effort involved in getting to position 1? I noticed Google recently put me into position 1 for this term and then quickly (within a few days) pulled me back down to position 4. Does anyone have any experience of this type of search positioning and have any information that may help me? My gut feel is that I have maybe maxed out the economically viable potential of these keywords and that I should invest my SEO $s into other phrases? Thanks in advance Olly
Algorithm Updates | | ojkingston0 -
Which is better for SEO. 1 big site or a number of smaller sites.
Hello , I am about to create a website with product reviews for a certain niche. What i want to know: Is it better for me to have a site with all reviews , like nicheproductsreviews.com and then have nicheproductsreviews.com/product-one-review.html and nicheproductsreviews.com/product-two-review.html or buy multiple domains to have product name in the domain name, like product-one-review.com and product-two-review.com As far as I understand, first approach consolidates all pages on the same site , consolidating all the link juice to it. However, second approach lets me have the product name in the main domain URL. Which way is better for SEO and why?
Algorithm Updates | | voitenkos0