ATTN SEO MINDS: Is there a way/tool to categorize keywords from an Omniture/GA report?

[Jonathan.Smith]

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?

[ToriC]

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.