Using Excel To Group Long Tail Keywords on Search Engine People

Excel and Array's

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.

Works in online marketing, runs on coffee and has a web design background. I maintain a few blogs to collect ideas and interesting stuff about the Internet, marketing online, coffee and technology.
This entry was posted in Search and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>