WA Keyword Wizard Improvements

I have made some significant changes to the WA Keyword Wizard. One of which was to rework the formulas to provide more accurate results. I also added some new elements to the formula calculations. They are as follows...

If a keyword has 40 + searches a month and competitors of 400 or less, it rates the keyword as a Good Keyword and highlights it in yellow so you can still use it in your campaign if you desire.

If a keyword has 50 + searches a month and competitors of 300 or less, it rates the keyword as a Great Keyword and highlights it in green. These type of keywords should be your 1st choice to use in your campaign as they are higher quality keywords.

If a keyword does not meet the conditions of the formulas above then the rating is displayed as a Bad Keyword and it is also highlighted in red, so you know not to use it.

I also extended the number of rows from 45 to 500 for webmasters that need or want to build out larger marketing campaigns.

Usage instructions are included at the top of the spreadsheet and additional error checking formulas will help you enter the correct data in the corresponding fields.

I built this spreadsheet using Microsoft Excel 2007, but you should be able to open it in both older and newer versions of Microsoft Excel. You may need to download a free conversion pack from the Microsoft website to make it work for you.

Alternatively you can use Open Office to open this file.

If you downloaded the previous version of the WA Keyword Wizard I recommend that you transfer your data to the new spreadsheet and then delete the old one.

Download the New WA Keyword Wizard here.

Thank you for reading my Blog and using my resources.

Your feedback is welcomed and appreciated.