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
-
Is it bad from an SEO perspective that cached AMP pages are hosted on domains other than the original publisher's?
Hello Moz, I am thinking about starting to utilize AMP for some of my website. I've been researching this AMP situation for the better part of a year and I am still unclear on a few things. What I am primarily concerned with in terms of AMP and SEO is whether or not the original publisher gets credit for the traffic to a cached AMP page that is hosted elsewhere. I can see the possible issues with this from an SEO perspective and I am pretty sure I have read about how SEOs are unhappy about this particular aspect of AMP in other places. On the AMP project FAQ page you can find this, but there is very little explanation: "Do publishers receive credit for the traffic from a measurement perspective?
Algorithm Updates | | Brian_Dowd
Yes, an AMP file is the same as the rest of your site – this space is the publisher’s canvas." So, let's say you have an AMP page on your website example.com:
example.com/amp_document.html And a cached copy is served with a URL format similar to this: https://google.com/amp/example.com/amp_document.html Then how does the original publisher get the credit for the traffic? Is it because there is a canonical tag from the AMP version to the original HTML version? Also, while I am at it, how does an AMP page actually get into Google's AMP Cache (or any other cache)? Does Google crawl the original HTML page, find the AMP version and then just decide to cache it from there? Are there any other issues with this that I should be aware of? Thanks0 -
What's better for seo, NOINDEX, or INDEX
Hello Mozers; I am having an issue, my client has 10K pages on their site; in WP, and they have a classified section. Question #1: I am asking, what's better for seo, NOINDEX, or INDEX, for their Classified section. They currently have no SEO plug ins, that fix their errors, and warnings. Question #2: My question is also, do I want the Categories crawled, or INDEXED or NOINDEX? Check out their Campaign results by Moz: Title Element Too Long (> 70 Characters) 32 Too Many On-Page Links 9,032 Missing Meta Description Tag 6,234
Algorithm Updates | | smstv0 -
What was the biggest challenge you faced as an SEO in 2012?
As an SEO (in-house, freelance, consultant, agency, entrepreneur) what was the biggest challenge you faced in 2012? Please be as specific as you can, and let us all know what you are doing to overcome this challenge in 2013. For me personally I would have to say the biggest challenge I had to deal with was Google+ Local. Obviously Google is putting a lot into G+L, but it has been so messy and at times I have just thrown my arms up in the air. Especially when it comes to multi-state locations and losing reviews.
Algorithm Updates | | clarktbell0 -
Increasing Brands/Products thus increasing pages - improve SEO?
We curently have 5 brands on our website and roughly 200 pages. Does increasing the number of products you stock and thus increasing the number of pages improve your SEO?
Algorithm Updates | | babski0 -
Video SEO <video:uploader>sitemap optional tag for Google+</video:uploader>
Anyone know the specifics or using the video:uploaderoptional tag for Google+ for rel=”author” attribution. for video sitemap?</video:uploader> Related post has some info, but no specific example. http://www.distilled.net/blog/video/getting-video-results-in-google/ Quote from above link: "Good practice is to ensure that the
Algorithm Updates | | Packetman007
video:uploaderelement links to a Google+ profile or a blog profile
page with rel=”author” attribution. "</video:uploader> This is what it seems it should look like in the video sitemap: <video:uploader info="<a href=" https:="" plus.google.com="" 111123738944093379428"="" target="_blank">https://plus.google.com/111123738944093379428">Bill
Alderson</video:uploader> If you know this works and is worth editing video sitmaps to add the optional tag, let me know your experience. Alternately, my site (and each page, thanks to Yoast SEO for WP) does have the rel="author" linked to Google+ for every page, which may make the sitemap entry moot, but I have not yet seen this work in that manner. If you know it does or does not work, please let me know. Please let me know if you have any better information or specific experience. Also, if I elect to edit my sitemaps (provided by Wistia.com and BitsontheRun) to include this tag, what XML Sitemap Tool might work well to add these tags properly? Seems there is lots of XML Sitemap tools, but few really address Video Sitemap options specifically. Thanks, Bill@apalytics.com www.apalytics.com0 -
Confused About Addon Domains and SEO
I find addon domains really confusing. Everyone I've asked so far says that they don't affect SEO but I find that really hard to believe considering the same content is on both a subdomain and a subfolder and also has it's own unique domain. PLUS (in my case) completely different niche sites are sharing the same hosting. I really don't want to pay for hosting for all of my different sites but at the same time, if it's better/safer to do so for Panda/Penguin reasons I'm happy to do that. Thank you for your time. I look forward to your opinions/suggestions!
Algorithm Updates | | annasusmiles0 -
Keyword density and meta tags
Hi, I've just checked the number of keywords appearing on my website's pages. On some of them the keyword density was way too high (7-10%) if you included the meta tags, but all under 3.5% if I didn't include the keywords and description meta tags. So my question is - when looking at number of keywords used per page, do I have to worry about what's in those meta tags? Do the keywords in there count towards keyword density / number of keywords per page? Thanks, Luke
Algorithm Updates | | McTaggart0 -
If Google turns down the weight of keywords in domains then what will they be turning up?
Per Matt Cutts video "We will be turning that keyword in domain down." http://youtu.be/rAWFv43qubI So what will they be turning up?
Algorithm Updates | | Thos0030