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
-
Best place to employ "branded" related keywords to gain SEO benefits and rank for "non branded" keywords?
Hi all, I want to put this question straight with an example rather than confusing with a scenario. If there is company called "vertigo", a tiles manufacturer. There are many search queries with thousands of searches like "vertigo tiles life", "vertigo tiles for garden", "vertigo tiles dealers", "vertigo tiles for kitchen", etc....These kind of pages will eventually have tendency to rank for non-branded keywords like "tiles for garden", "tiles for kitchen", etc. So where to employ these kind of help/info pages? Main website or sub-domain? Is it Okay to have these pages on sub-domain and traffic getting diverted to sub domain? What if the same pages are on main website? Will main website have ranking improvement for non branded keywords because of employing the landing pages with related topics? Thanks
Algorithm Updates | | vtmoz0 -
Use of http://schema-creator.org boost ranking
Hello all if we use http://schema-creator.org for structured html will it increase our ranking too. has it any benefit for SEO?
Algorithm Updates | | adnan11010 -
Home page rank for keyword
Hi Mozers I have traded from my website balloon.co.uk for over 10 years. For a long while the site ranked first for the word 'balloon' across the UK on google.co.uk (first out of 41 million). Around the time Penguin launched the site began to drop and currently sits on about page 5. What's confusing is that for a search on 'balloons' ('s' on the end of balloon) it ranks 2nd in the location of Birmingham where I'm based. That's 2nd in the real search rather than a map local search. But - if I search 'balloon' from the location of Birmingham my contact page ranks 5th: http://www.balloon.co.uk/contact.htm but the home page ranks nowhere. So - it's gone from ranking 1st nationally to ranking nowhere with my contact page ranking above the home page (which is a generic word domain). Any ideas?
Algorithm Updates | | balloon.co.uk0 -
Will Parked Domain hurt My SEO as Duplicate Content?
Hello, I have one website (Migration Lawyers) and I have an extra 8 domains Parked so they are basically cloning the content of the site. so if the main site is: migrationlawyers.co.za and I have an addon domain migration-lawyers.com is that good or bad? is there a proper way to redirect the sites, will redirecting (301) subdomains be more effective? Thanks for your Input 🙂 0i8VXqr.png
Algorithm Updates | | thealika0 -
Meta description & Meta keywords
Good morning, One of our HTML experts, just told me that Google is not reading meta keywords or meta description - and they (or one of them) are no longer part of my website SEO ranking Do you know where can i read about it? Are other SE do look at these parameters? Thank you SEOWiseUs
Algorithm Updates | | iivgi1 -
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 -
Negative SEO?
I have a large content site that's 8-9 yrs old, a PR4, DA of 66, and has many thousands of backlinks. It has ranked well for it's primary keywords for quite some time. This morning I noticed rankings dropped significantly. My #2 keyword went from 1 to 150. I started trying to figure out what was up and when I signed into GWT I had the notice from Google on 2/25 that they noticed un-natural linking tactics. Hmm....weird...I dont use un-natural linking methods. So I pulled open a couple back link analyzing tools and when looking at Majestic SEO I noticed that about mid February I had a spike of about 2500-3000 links coming from roughly 350 unique domains. Hmm..weird..We hadn't been doing any major content marketing or link building during that time or for probably a month to month and half before that. Upon analyzing some of those links it appears that a vast majority of them are from some type of blog network. Not sure which but you know the kind I'm talking about. ALN or something similar. What appears to have happened is someone pointed a bunch of spammy links at my site and this has caused Google to penalize me. I know this isn't suppose to be possible but just recently on a forum I visit I noticed a thread where someone was able to successfully do this to his competitor who has held the number one spot for over a year. He used the same technique of a couple hundred blog network links with varied anchor text and his competitor dropped about a hundred spots. So curious if anyone else has seen this or has any advice on my next step. I have filed a re-inclusion request and outlined what I think happened. I am also attempting to figure out which blog network it is so that I can request they remove those links but if I can't I'm not sure what I should do next.
Algorithm Updates | | jmacek070 -
Can You Recommend An SEO Consultant To Support Our Panda Recovery Efforts?
Hi, I'm looking to find an SEO consultant to help me review my organic search strategy following the recent Panda update. Can you recommend somebody? Thanks, Adam
Algorithm Updates | | adampick0