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
-
Studies showing that social sharing does/doesn't affect rankings?
I'm currently researching this area in order to show to a client that social shares aren't as valuable for SEO as they might think. Can anyone point me in the direction of the best studies done on this topic? Thanks in advance!
Algorithm Updates | | QubaSEO0 -
What's the best way to go about building/using interactive snippets?
I'm starting to see interactive snippets (I guess they're called islands) like the attached image in our SERPs, so I figured I would look into experimenting with them, but I'm not entirely clear how to proceed. I have only seen them in adwords, so is that the only way you can use them? Is there some way to set them up or some service you need to set them up organically? Lost, but intrigued, Ruben SW7ak4d.jpg
Algorithm Updates | | KempRugeLawGroup0 -
Google Webmaster Tools: Quality Issues on http://www.enakliyat.com.tr/
Specifically, we detected low-quality pages on your site which do not provide substantially unique content or added value. Examples could include thin affiliate pages, doorway pages, automatically generated content, or copied content. We encourage you to make changes to your site so that it meets our quality guidelines. Once you've made these changes, please submit your site for reconsideration in Google's search results. Google Webmaster Tool send me this message I think the low-quality pages is like the this http://www.enakliyat.com.tr/detaylar/bursa-fethiye-ucevler-nakliye-5834 page and we have so many pages like this... Example 1: http://www.enakliyat.com.tr/detaylar/evden-eve-nakliyat-5906 **Example 2 : **http://www.enakliyat.com.tr/detaylar/cekmekoy-izmit-5905 **Example 3: **http://www.enakliyat.com.tr/detaylar/evden-eve-nakliyat-5906 What should I do to these pages HELP 😞
Algorithm Updates | | iskq0 -
Has there been a change in the Bing/Yahoo Algorithm?
I have noticed many of my sites took a beating this month on Bing and Yahoo, while Google stayed pretty flat.
Algorithm Updates | | netviper0 -
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 -
Proper Way To Submit A Reconsideration Request To Google
Hello, In previous posts, I was speaking about how we were penalized by Google for unnatural links. Basically 50,000 our of our 58,000 links were coming from 4-5 sites with the same exact anchor text and img alt tags. This obviously was causing our issues. Needless to say, I wen through the complete link profile to determine that all of the links besides this were of natrural origins. My question here is what is the accepted protocol of submitting a reinclusion request; For example, how long should it be? Should I disclose that I was in fact using paid links, and now that I removed (or at least nofollowed) them? I want to make sure that the request as good as it should so I can get our rankings up in a timely manner. Also, how long until the request is typically aknowledged? Thanks
Algorithm Updates | | BestOdds0 -
Content on Wordpress blog inside the main website for SEO
Hi, We have our main website and our blog on blog.practo.com. Now what I see is that we wish to write in content to grow our seo keywords and links. Should we put the blog as www.practo.com/blog and then begin writing all the content or we should put the wordpress blog as www.practo.com/(wordpress blog here) and then begin writing the content. For best practices I suppose we should have content lined up as www.sitename.com/category/article name etc or www.sitename.com/article name etc - am I correct? Our main site consists of few html pages and then we have our software on a different sub domain. What are the best ways to publish content and get it crawled at a faster rate for growth? I would also wish to understand how to measure the number of growth in % to our content we are writing. Only via google analytics or some other tool? Say I wish to see the growth of 10 articles from month of may and compare it to the month of april or march 2012. So what tools could I use to see if we are progressing or not? Thanks
Algorithm Updates | | shanky10 -
Are the latest Ranking Reports counting the new large format site links as positions?
Received my weekly ranking report this morning and noticed a specific keyword that I've been ranking in the 3rd or 4th spot has dropped a significant amount of positions. I tested the results myself and it appears the site links of the manufacturer are being counted as positions? My keyword has me in the 3rd position (although it is much lower on the physical page now because of the new format). I'm really wondering how this will affect organic listings going forward - this new format could be a game changer.
Algorithm Updates | | longbeachjamie2
