Frequently Asked Questions About the Niche Keyword Analyzer

What are the system requirements?

You must already have Microsoft Excel 2000 or 2002 (XP) installed on your computer. If you have Microsoft Office 2000 or Office XP, you probably have the right version of Excel.

This tool will not work in Excel 97.

Before you start Niche Keyword Analyzer, your computer must be connected to the Internet.

You may need Internet Explorer.

We do not offer technical support for Mac OS.

Try the evaluation demo version first.

How do I install Niche Keyword Analyzer?

The Niche Keyword Analyzer (NKA) installation is as follows:

1. Click on ‘.exe' file you downloaded and then press Install.
2. After Step 1, you will have a new folder created in your current directory.
3. Set MS Excel macro security level to Middle.
4. Install the Excel add-in titled "nkaaddin.xla".
5. Open the file "NicheKeywordAnalyzer.xls" and start your niche keyword research.

NKA will ONLY work if you are connected to the Internet. You must be online before you start using this tool.

Step by Step Setup Guide

1. Click on ‘.exe' file you downloaded and then press Install.
2. When you complete the Step 1, you will have a new folder created in your current directory.
3. Launch Microsoft Excel.
4. Open the Excel "Tools/Options/Security/Macro Security" dialog box.
5. Choose Security Level Medium.
6. In the same dialog box, click on "Trusted Sources" and see if there is a checkmark next to "Trust all installed add-ins and templates." If there is not one, be sure to activate the checkmark.
7. Click OK.
8. Close Microsoft Excel.
9. Install the add-in "nkaaddin.xla". It includes a code that is responsible for proper formatting of niche keyword reports. Open the file "install_nkaaddin.xls" and click the button "Install Niche Keyword Analyzer Add-In".

Before you open this file, you will see a dialog box that asks about enabling or disabling macros. Click on button "Enable Macros".

Now, installation is complete. Open the file "NicheKeywordAnalyzer.xls" and start your niche market research!

Every time you open Niche Keyword Analyzer, using the file "NicheKeywordAnalyzer.xls," you will see a dialog box stating that "this file contains macros". You must click on button "Enable Macros." Otherwise, the application will not work properly.

I just downloaded the file and try to run the demo. It never allowed me to run the script. Plus, it gave me a message saying the demo period of 3 days was over and I needed to order the script.

Download the demo again. It's possible that the file was corrupted during downloading.

How to start niche market research?

1. Enter a keyword in cell "J2" on the Start Sheet.
2. Press "Enter" on your keyboard.
3. Click Search.
4. Wait......
5. When you see a list of relevant keyword appear in the main table, click Calculate.
6. Now the program is calculating "supply" and the number of Adword campaigns for each keyword.
7. When the calculation is finished, click "Create Report." Save this file in a new location for further analysis.
8. Repeat Steps 1 thru 7 again, for the next keyword.

Please don't change anything in the file "NicheKeywordAnalyzer.xls" and don't delete anything, EXCEPT the keywords you entered manually. When you close this application, don't save it.

Sort by Demand function works OK in a report file. Rest of Sort functions does not work correct.

Open "Tools/Add-Ins..." and uncheck "Niche Keyword Analyzer Demo Tools". Click OK. Close MS Excel. Now the functions will work correct when you open the report file again.

I've a list of 81 keywords. If I sort by demand or by adwords the first 19 positions are empty(0) and I do not see keywords. If I sort by supply or by ratio the last 19 positions are empty(OK). I do not know why.

Open a report file. Select cells (e.g., D7:G25), that contain "0" or "link", next (on the right side) to empty keyword cells. Click "Delete" key on a keyboard. Now it will work as expected.

When making search, 'words' and 'demand' column appeared OK. However, when I use calculate key, it will calculate but there are no results. It will shown the following:
All supply column showed #VALUE!
All ratio column showed blank
All Adwords column showed '0'

Download updated version (1.5) of the Niche Keyword Analyzer. The download link you will find in the email you received when received confirmation email about your purchase (or free demo). Click on the same link to download it.

I can't find the answer here

If you cannot find the answer to your question, just send us an email at info@nichekeywordanalyzer.com.