| > | | | | Choose Data-Filters-AutoFilters to turn them on. |
| Learn how to analyze keywords using the free | | | | You should have drop down menus in each of the |
| Google Adwords Keyword Tool and the Microsoft | | | | columns. |
| Excel Macro Function to quickly process through | | | | Using the drop down menus you can sort out |
| massive amounts of potential words. Save time | | | | whatever you do not want to see, such as, the |
| and money using this free keyword selection | | | | keywords with high competition and/or those with |
| process. If you are looking for a free keyword | | | | virtually no search volume. |
| analyzer, read this article and learn how to analyze | | | | For each column decide what, if anything, you |
| keywords using the Google Adwords Keyword | | | | want to keep or eliminate. A high level sort might |
| Tool and the Macro Function in Microsoft Excel. | | | | look something like this: |
| Identifying what keywords to use for your web | | | | - Keywords--keep all |
| site or blog can mean the difference between | | | | - Estimated Avg. CPC--keep only those with CPC |
| success and failure so it's important to get it right. | | | | of $1.00 or more |
| The problem that most new business owners | | | | - Advertiser Competition--keep only those with |
| face is that they do not have extra money to | | | | competition of less than .74 |
| spend on a fancy research keyword tool, like | | | | - Local Search Volume: Month--keep all. Will use |
| Wordtracker. | | | | next column instead |
| So what to do? Use what you already have at | | | | - Global Monthly Search Volume--keep only those |
| your disposal and maximize your free resources | | | | with at least 200 searches |
| of course! | | | | Now that you have determined acceptable |
| Google Adwords Keyword Tool | | | | thresholds for each column, set up your custom |
| If you are not familiar with this tool, simply do a | | | | filters. In the CPC column click on the drop down |
| search and you will find it. Its only purpose is to | | | | menu and choose "Custom." |
| help you identify a list of potential keywords. | | | | Here is where you will define exactly what you |
| You will still have to analyze them to determine | | | | want to keep. There are 4 white boxes each |
| their worth. We will do that later in Microsoft | | | | with their own drop down menu. Typically you will |
| Excel. | | | | only use the top two boxes to analyze keywords. |
| Start by inputting your general keyword idea into | | | | Using the suggestions above, in the first box |
| the white box under "Enter one keyword or | | | | choose "is greater than", type in "1.00" in the |
| phrase per line." Fill in the security code and hit | | | | second box and click OK. Do the same for any |
| "Get Keyword Ideas." | | | | other columns you want to set thresholds for |
| By default, four columns of data will appear. To | | | | (see suggestions for each column above). |
| add additional columns, select them from the drop | | | | At this point you should have eliminated all of the |
| down menu under "Choose columns to display." If | | | | low quality keywords. Your list may still be quite |
| you plan on using Google Adsense to monetize | | | | long so a second round of filtering may be |
| your site or blog, add "Estimate Avg. CPC." | | | | needed. Use Data-Sort and formatting, such as fill |
| You should now have five columns of data. For | | | | colors and bolding, to help simplify your list. |
| definitions of each, click on the question marks | | | | The final decision about what keywords to keep |
| next to the column heading. The five columns are: | | | | and get rid of can only be made by manually |
| - Keywords | | | | considering a combination of CPC, Competition and |
| - Estimated Avg. CPC | | | | Search Volume. In addition to using these variables |
| - Advertiser Competition | | | | to help make your decision, keep in mind that the |
| - Local Search Volume: Month | | | | keyword or phrase must somehow be weaved |
| - Global Monthly Search Volume | | | | into your content for maximum search engine |
| Normally you will get two lists of keywords. The | | | | friendliness. |
| top list is where you will find "Keywords related to | | | | Using Macros To Improve The Process |
| term(s) entered." The bottom list is the "Additional | | | | The process of using filters in Excel can be |
| keywords to consider." | | | | tedious especially if you have several columns of |
| Under each list you will find links to download the | | | | data and multiple spreadsheets of keywords that |
| data, including ".csv (for Excel)." Download both | | | | you are considering. That's where the Macro |
| lists into an Excel Document, pasting one under | | | | Function comes in. |
| the other. | | | | A macro is defined as "a series of program |
| Analyze Keywords in Microsoft Excel | | | | commands or instructions which are stored in a |
| You do not have to be a master at Excel to be | | | | file and can be recalled when necessary." Basically, |
| able to use it for keyword processing. In addition | | | | we will record each of the steps that we did |
| to ease of use it really is the perfect tool for this | | | | above and then save the macro and use it each |
| job because it offers you the ability to: | | | | time we process keywords. |
| - Filter out keywords that have very little value | | | | Reading this brief macros tutorial will give you a |
| - Sort keywords in the order that you prefer | | | | high level view of how it's done so that in the |
| - Categorize and format keywords for easier | | | | future, you can analyze keywords in a couple of |
| consideration | | | | mouse clicks. |
| - Display subsets of keywords on individual | | | | With your spreadsheet of keywords open, |
| spreadsheets | | | | choose Tools-Macro-Record New Macro. Name |
| - Save workbooks on your own computer for | | | | the macro something you will remember when |
| reference | | | | you need to recall it, like "KeywordResearch." Do |
| You can sort through keywords in a number of | | | | not use dashes, slashes or spaces. Click okay. In |
| ways but the goal is always the same: find | | | | Excel 2003, a small box will appear in your |
| keywords that are high in search volume and low | | | | spreadsheet with a "Stop Recording" button |
| in competition. In other words, lots of searches | | | | visible. |
| but very few people answering the call. | | | | Every step you take from this point forward will |
| Those keywords are the keepers, the golden | | | | be recorded. Go through the exact steps above |
| nuggets. | | | | and any others that you might like to perform |
| Let's get to work on our list of keywords from | | | | and then hit the "Stop Recording" button. |
| Adwords. You should have one spreadsheet with | | | | The next time you want to use the macro |
| five columns. Our goal is to quickly eliminate less | | | | function, click anywhere in the spreadsheet and |
| useful keywords and get pare down our list to | | | | then choose Tools-Macro-Macros and find the |
| only the top contenders. We'll do that by using | | | | named macro in the list. Hit "Run" and your steps |
| filters. | | | | will automatically be performed. |
| First we'll go through the manual process and then | | | | The process of analyzing keywords using the |
| the macro function which will cut processing time | | | | Google Adwords Keyword Tool and the Microsoft |
| substantially. | | | | Excel Macro Function will not only save you |
| Using Filters To Analyze Keywords | | | | money but a huge amount of time. |
| Start by selecting the top row with the headings. | | | | |