Analyze Keywords Using Adwords Keyword Tool and Excel Macro Function

If you are looking for a free keyword analyzer, read this article and learn how to analyze keywords using the Google Adwords Keyword Tool and the Macro Function in Microsoft Excel.

Identifying what keywords to use for your web site or blog can mean the difference between success and failure so it’s important to get it right. The problem that most new business owners face is that they do not have extra money to spend on a fancy research keyword tool, like Wordtracker.

So what to do? Use what you already have at your disposal and maximize your free resources of course!

Google Adwords Keyword Tool

If you are not familiar with this tool, simply do a search and you will find it. Its only purpose is to help you identify a list of potential keywords. You will still have to analyze them to determine their worth. We will do that later in Microsoft Excel.

Analyze Keywords in Microsoft Excel

You can sort through keywords in a number of ways but the goal is always the same: find keywords that are high in search volume and low in competition. In other words, lots of searches but very few people answering the call.

Those keywords are the keepers, the golden nuggets.

In addition to ease of use, Excel really is the perfect tool for this job because it offers you the ability to:

Let’s get to work on our list of keywords from Adwords. You should have one spreadsheet with five columns. Our goal is to quickly eliminate less useful keywords and get pare down our list to only the top contenders. We’ll do that by using filters.

First we’ll go through the manual process and then the macro function which will cut processing time substantially.

Using Excel Filters To Analyze Keywords

Using Macros To Improve The Process

The process of using filters in Excel can be tedious especially if you have several columns of data and multiple spreadsheets of keywords that you are considering. That’s where the Macro Function comes in.

A macro is defined as “a series of program commands or instructions which are stored in a file and can be recalled when necessary.” Basically, we will record each of the steps that we did above and then save the macro and use it each time we process keywords.

Reading this brief macros tutorial will give you a high level view of how it’s done so that in the future, you can analyze keywords in a couple of mouse clicks.

The process of analyzing keywords using the Google Adwords Keyword Tool and the Microsoft Excel Macro Function will not only save you money but a huge amount of time.