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
-
Are SEO Friendly URLS Less Important Now That Google Is Indexing Breadcrumb Markup?
Hi Moz Community and staffers, Would appreciate your thoughts on the following question: **Are SEO friendly URLS less important now that Google is indexing breadcrumb markup in both desktop and mobile search? ** Background that inspired the question: Our ecommerce platform's out of the box functionality has very limited "friendly url" settings and would need some development work to setup an alias for more friendly URLS. Meanwhile, the breadcrumb markup is implemented correctly and indexed so it seems there's no longer an argument for improved CTR with SEO friendly URLS . With that said I'm having a hard time justifying the URL investment, as well as the 301 redirect mapping we would need to setup, and am wondering if more friendly URLs would lead to a significant increase in rankings for level of effort? Sidenote: We already rank well for non-brand and branded searches since we are brand manufacturer with an ecommerce presence. Our breadcrumbs are much cleaner & concise than our URL structure. Here are a couple examples. Category URL: http://www.mysite.com/browse/category1/subcat2/subcat3/_/N-7th
Algorithm Updates | | jessekanman
Breadcrumb: www.mysite.com > category1 > subcat2 > subcat3 Product URL: http://www.mysite.com/product/product-name/_/R-133456E112
Breadcrumb: www.mysite.com > category1 > subcat2 > subcat3 > product name The "categories" contain actual keywords just hiding them here in the example. According to my devs they can't get rid of the "_" but could possible replace it with a letter. Also they said it's an easier fix to make the URLs always lower case. Lastly some of our product URLS contain non-standard characters in the product name like "." and "," which is also a simpler fix according to my developers. Looking forward to your thoughts on the topic! Jesse0 -
How is this possible? #2 ranking with NO on-page keywords, no backlinks, no sitemap...
Hi everybody. I have a question ... I'm totally stumped. This question is being asked today (November 16th, 2015) just after Google updated something in their algorithm. Nobody seems to know what they did. and it has something to do with the new "Rank Brain" system they're now using. My niche is Logo Design Software (https://www.thelogocreator.com). I had the keywords "logo creator" on the page roughly 7 times. After Google updated, I lost about 10 spots and as of this writing, I've dropped to #15. So, maybe I over optimized. fine. Noticing that for the keyword "logo creator" ... NONE of the top 14 spots actually have "logo creator" in their page title and NONE of them have more that 2 instances (if any) of the keyword "logo creator" on the actual page. So I removed ALL instances of my keyword "logo creator" from my home page - used the Webmaster's Fetch Tool and moved up a few spots instantly. So what the heck? And the #2 spot for that keyword is www.logomakr.com - they have NO words at all on their pages, no blog, no sitemap and far fewer links than anybody in the top 10. Can anybody reading this shed some light? Marc Marc Sylvester
Algorithm Updates | | Laughingbird
Laughingbird Software0 -
Troubleshooting Decline of Branded Keyword Searches
Hi, Over the past year, I have seen a huge change in the distribution of our organic keyword traffic. I'm trying to research why our branded keywords have gone down. Google analytics only shows me impressions for the past three months. Does anyone have ideas on how to explain this change in traffic? Please see the attached chart. Thanks! branded-v-nonbranded-organic-search.jpg
Algorithm Updates | | netdiva_amy0 -
SEO ranking factors
Hello I am reading SEO ranking factor (very good informations) and I want to ask: what does it mean: of linking C bloks to page I think that: how many(#) links from the same server (C block) links to your homepage or some pages of your web... of linking IP adresses to page how many web links are going to my web and every links are from another server. if I understand it good, it is no different between, if you have links from webpages in one server (one C block) or from webpages on another servers as your web is, because both correlation is 0.25... THX Could anybody expalin me, what does it mean: # of External Links w/ Partial Match Anchor Text http://www.seomoz.org/article/search-ranking-factors#metrics-5 The number of external links and all these external links contain partial match anchor text from my query: (I am finding in Google "tennis" and see in SERP domain www.usta.com. # of External Links w/ Partial Match Anchor Text: tells me the number how many external links contain partial match anchor text "play tennis, tennis school, tennis info..."? )
Algorithm Updates | | PeterSEO0 -
Singular vs plural SEO
Hi everyone, OK I've been looking at the Google adwords keyword tool and it's thrown some of my On-page SEO into question (everything said here are examples, I haven't used any real life terms or figures). Lets say my page is about "Green Apples", let's say the keyword tool shows that the singular version "Green Apple" gets more searches (as an example). Should I optimize for the singular or the plural? Also lets say my title tag for that page is "Green Apples | Apples Galore UK" would Google/SEOmoz count that as an optimisation for the singular "Green Apple" or do the search engines take the title literally and don't differenciate between singular and plurals? Thanks in advance everyone! Regards, Ash
Algorithm Updates | | AshSEO20112 -
Mobile SEO
Hello, A bit of an open question to start the week... What do you think are the key differences between Google's mobile search and web search algorithms? Obviously greater importance on site speed for mobile search!?
Algorithm Updates | | A_Q0 -
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