Using Excel To Group Long Tail Keywords on Search Engine People

Posted on by

Excel and Array’s

My latest guest post, “Using Excel Formulas To Group Your Google Analytics Long Tail Keywords Into Themes
“, is live on Search Engine People’s blog.

This post expands further on my last post, “Living with SSL Search” and covers a fairly simple and quick technique for dealing with theming keyword traffic:

Unfortunately natural language processing tools are not as widely available as we would like and frankly word clouds just do not cut it. This leaves us having to find some kind of a workable kludge to make sense of the information Google Analytics provides. In this case, it is going to be Excel’s formulas. A sample spreadsheet is provided at the end of this post.

You can ready the full post and grab the example spreadsheet with the formula here.

Leave a Reply