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
-
Google's stand on LSI keywords?
Hi all, So the keywords which appear while typing some keywords and suggested keywords at the bottom of the search results page are refereed as LSI keywords. I been noticing some of the LSI keywords for years related to our industry and Google now suddenly changed them. I wonder why it would be. I can see competitors are started using those LSI keywords widely, is that the reason Google changed them? Thanks
Algorithm Updates | | vtmoz0 -
Different versions of keywords. Which one to optimize?
For some keywords, we have slightly different versions available. For example: people search for 'webhosting', but also for 'web hosting'. Same for 'cloudserver' and 'cloud server'. I used google trends to compare the keywords and find the more popular one. But in different countries, different keywords are searched more often. So we can't really optimize for the BEST version of the keyword, since there is no real BEST version. What would you suggest to do? We could also just develop pages for both keywords, but that could end in duplicated content. Would be an option to use canonicalization then, but this would not really improve ranking for one of the versions. I'm very confused. If anyone has a good idea on how to optimize here, please let me know. Thank you in advance! Best regards
Algorithm Updates | | hosttech_ch
Klemens1 -
Will Russia's New Data Protection Law Impact SEOs and SMBs Outside of Russia?
We've all seen the news recently that Google will be closing its engineering offices in Russia due to new data protection laws coming into place in January 2015. The same law has also led to Adobe pulling out of Russia earlier in the year. I was wondering how you think this will impact SEOers and small/medium businesses that market _to _Russia, but are based outside of the country? Personal data has been defined in the new legislation as: Personal data means any information directly or indirectly related to any identified or potentially identifiable person. It includes, among other things, first name and family name, date and place of birth, address, information about family status, education, profession, income Source For those businesses which don't process personal data (affiliates etc), will there be any foreseeable impact? On the flipside, are there any benefits here for affiliate businesses inside of Russia? I'm using affiliates as an example to get the ball rolling, but I'm sure there's numerous more. Personally, I'd be interested to hear if you think this may impact corporate websites which don't process personal data, but operate outside of Russia.
Algorithm Updates | | ecommercebc0 -
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 -
How do I rank higher in Bing/Yahoo?
We are doing really well across the board on Google, but having issues in ranking with Bing and Yahoo. What is different between the three search engines? I have read a few articles that Bing is happier with Flash, and they are more interested in Top Level Domain links, but what else is different? In Google we are sitting on page one for most terms, but are page 2-3 in Bing/Yahoo for the exact same terms. Any help would be appreciated!
Algorithm Updates | | FVdBeuken0 -
Physical locationof the server vs customer base vs SEO penality?
HI All, We are an Australian business with our hosting currently based in Australia. We have recently been considering moving hosts for a few reasons. In particular when we have done analysis of hosting in the US and also with Rackspace say in Hong Kong we have found that the prices can be significantly cheaper or with more bells in whistles provided in the hosting of a dedicated server offshore vs Australia for the same price. Therefore from this point of view we would be much better off moving our hosting to the US or HK with Rackspace. There are the issues such as latency to take on board but lets put that to the side for the moment as we are mostly interested in understanding if offshore hosting will impact us from an SEO perspective and if so how and can these impacts be mitigated. So our first question is a) if we move our hosting offshore, will this impact our SEO? b) if it does impact our seo, how will it impact (ie lose rankings for organic pages due to IP address being offshore)? c) is A is also an impact are there ways of eliminating these impacts outlined in B? d) net - if the impacts on seo can be mitigated will the net result still be negative or could we still be seen on the same footing as a domain hosted in Australia? Thanks Sean
Algorithm Updates | | sbcinv0 -
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