Windows version of the Keyword Databases


Quick Start:

Working with keyword lists:

Working with data columns:

Working with keywords:

Other features:

Error messages:


How to run a simple keyword search

Let's run a simple search query and get the list all keywords containing the phrase "online business".
1. Start the program and open your base (save file). If you do not have the base yet, please read how to create it in the "Quick start"
2. Choose the Document tab: New document -> Find more specific keywords -> English 245 mln. Keyword Database

 If you start the program for the first time, specify the folder in the Settings tab with the unpacked keyword database stored on your local or USB hard drive.

a) online business - in this case all search queries in which there is simultaneous occurrence of lines “online” and “business” with different word order will be found.

b) "online business" - in this case all search queries in which there is simultaneous occurrence of lines “online” and “business” with direct word order will be found (phrase match).

c) [online business] - in this case only search queries in which there is simultaneous occurrence of lines "online business” with direct word order will be found (exact match).

Let use the third variant, when all search queries in which there is simultaneous occurrence of lines [online business] will be found.

 All operations are carried out in a background mode. You can see the progress bar in the right bottom of the main window.

4. You will get the list of keywords in no more than 2 minutes.

 You can rename the keyword list in the tree window by double clicking it with a left mouse button or by pressing F2.


How to run a multiple keyword search

Let's run a search query and get the list all keywords containing phrases "software development", "web development" and "web design". We will get the list of keywords related to these three phrases.
1. Start the program and open your base (save file). If you do not have the base yet, please read how to create it in the "Quick start"
2. Choose the Document tab: New document -> Find more specific keywords -> English 245 mln. Keyword Database

 If you start the program for the first time, specify the folder in the Settings tab with the unpacked keyword database stored on your local or USB hard drive.

3. Enter keywords for search into the form by one phrase per line. You can use several keyword matching options:

a) software development - in this case all search queries in which there is simultaneous occurrence of lines “software” and “development” with different word order will be found.

b) "software development" - in this case all search queries in which there is simultaneous occurrence of lines “software” and “development” with direct word order will be found (phrase match).

c) [software development] - in this case only search queries in which there is simultaneous occurrence of lines " software development” with direct word order will be found (exact match).

Let use the first variant:

4. You will get the list of keywords in not more than 2 minutes. All search queries in which there is a simultaneous occurrence of lines “software” and “development", or simultaneous occurrence of lines “web” and “development”, or “web" and “design” will be found.

 You can rename the keyword list in the tree window by double clicking it with a left mouse button or by pressing F2.


How to get popularity data for keywords

Let's get Google popularity data for the keywords in the list we have now.
1. Open the keyword list. Click with the right mouse on the header of the first column and choose “New column” in the appeared menu.

2. The window with the list of all bases and all columns will open. Choose: Keyword Databases -> English 245 mln. Keyword Database -> Google Searches.

 You can get the popularity data for the keyword list from any available database: English 245, 115, 77, 60 or 44 mln. Keyword Database

3. The new column with "Google Searches" data will be added automatically to the main table.
4. Click with the left mouse button on the header of this column and choose “Sort descending”/"Sort ascending" in the appeared menu.

You will get the list of keywords sorted by popularity.


How to get the CPC for keywords

Let's get Adwords CPC data for the keywords in the list we have now.
1. Open the keyword list. Click with the left mouse button on the header of the first column and choose “New column” in the appeared menu.

2. The window with the list of all bases and all columns will open. Choose: Keyword Databases -> English 245 mln. Keyword Database -> Adwords CPC.

3. The new column with “Google Adwords CPC” data will be added automatically to the main table.

 To sort keywords by values click with the right mouse button on the header of the Adwords CPC column and choose “Sort descending”/"Sort ascending" in the appeared menu.


How to get the list of the most popular keywords

Let's find all keywords that have more than 500.000 Google search queries per month.
1. Start the program and open your base (save file). If you do not have the base yet, please read how to create it in the "Quick start"
2. Choose the Document tab: New document -> Find keywords by condition (column) -> English 245 mln. Keyword Database

2. In the appeared window choose a column “Google Searches”, select the filter "higher" and type the value "500000".

3. You will get the list of keywords that have more than 500.000 searches per month.


How to get the list of the most expensive keywords

Let's find all keywords with the CPC value higher than $10.
1. Start the program and open your base (save file). If you do not have the base yet, please read how to create it in the "Quick start"
2. Choose the Document tab: New document -> Find keywords by condition (column) -> English 245 mln. Keyword Database

3. In the appeared window choose a column “Adwords CPC”, select the filter "higher" and type the value "1000".

 The CPC value in any English keyword database is displayed in cents.

4. You will get the list of keywords that have more than $10 Adwords CPC.


Working with keyword lists


How to filter keywords by the number of words

Let's filter the keyword list by the number of words.

1. Open the keyword list. Click with the left mouse button on the header of the first column and choose “New column” in the appeared menu.

2. The window with the list of all bases and all columns will open. Choose: Number of Words.

3. The new column with the number of words per each keyword phrase will be added to the main table.

4. Click with the left mouse button on the header of this column and choose “Filter” in the appeared menu.

5. In the appeared window choose a column “Number of Words”, select the filter “higher” and type the value “2″ for example.

6. The software will filter the keyword list by this column / value and add new sub-keyword list to the tree.


How to filter keywords by the keyword length

Let's filter the keyword list by the length of words with spaces.

1. Open the keyword list. Click with the left mouse button on the header of the first column and choose “New column” in the appeared menu.

2. The window with the list of all bases and all columns will open. Choose: Keyword Length.

3. The new column with the number of words per each keyword phrase will be added to the main table.

4. Click with the left mouse button on the header of this column and choose “Filter” in the appeared menu.

5. In the appeared window choose a column “Keyword Length”, select the filter “higher” and type the value “15″ for example.

6. The software will filter the keyword list by this column / value and add new sub-keyword list to the tree.


How to use quick filter

The quick filter allows you to filter the keyword list in real time as you types words in its form. You can then copy remained keywords to another keyword list or add them to a new one.


How to merge together keyword lists to form new keyword combinations

For example we have a keyword list consisting of two phrases: "web development" and "web design".

Let's add to each phrase two words: "price" and "credit". To do so switch to the Keyword tab and press "Combine" button.

In the appeared window type these two words.

You will get the new keyword list that contains combinations of keywords with a new words.
- price web development
- credit web development
- price web design
- credit web design
- web development price
- web development credit
- web design price
- web design credit


How to export the list of keywords to CSV, TXT, HTML etc.

1. Open "Keywords" tab.
2. Press the button "Select All". Note that this operation may take some time.
3. The button "Export" will become active. Press it and choose a desirable format and a place where you would like to save the file.

 You can export to CSV, TXT, HTML etc. only your keyword lists. If you need the whole database in TXT format, download it from the server.


Working with data columns


How to change the column order

To change the column order, click and hold the header of any column with the left mouse button and drag it to a proper place.


How to rename a column

Click the column name. In the appeared menu choose "Rename".


How to sort data column

Click with the left mouse button on the header of any column and choose “Sort descending”/"Sort ascending" in the appeared menu.

You will get the list of keywords sorted by the data from this column.


How to display all accessible columns

1. Open the keyword list and switch to the Keyword tab.

2. Press "Columns" button and choose the keyword database needed.

All data columns which are accessible for this keyword base will be automatically added to the main table.


Working with keywords


How to add own keywords

1. Start the program and open your base (save file). If you do not have the base yet, please read how to create it in the "Quick start"
2. Choose the Document tab: New document -> Keyword List

3. Switch to the Keywords tab and press the "Add" button.

4. In the appeared window type keywords or phrases which you want to add to the list by one per line and press Ok.

 You can paste any number of keywords to that window for example from text files simply by using hot key command Ctrl + V

For example let's add two phrases: "web development" and "web design".


How to edit keywords

1. Select any keyword or a group of keywords in the main table and press the "Edit" button on the Keywords tab.

2. You can edit keywords in the appeared window.

3. To save your changes simply press Ok.


How to cut or copy keywords

1. Select any keyword or a group of keywords in the main table which you want to cut or copy.
2. Press "Cut" or "Copy" button on the Keywords tab.
3. Now you can paste them to other keyword list in the tree or to any text editor.


How to paste keywords into the list

1. Select any keyword or a group of keywords in the main table that you want to paste to another keyword list. You can also select and copy one or a group of keywords from any text editor.
2. Select the keyword list in the tree and press "Paste" button on the Keyword tab.

3. New keywords will be added to the end of the list.


How to delete keywords from the list

Select any keyword or a group of keywords in the main table and press "Delete" button on the Keywords tab.


Other features


How to add selected keyword to the search engine

1. Open the keyword list.
2. Switch to the Keywords tab.

3. Select a keyword in the main table and press “Search Engines" button -> "Google”.

3. The software will create the new subdocument in the tree window.

 By pressing "All Search Engines" button can get the list of all available search engines:


How to change keyword font, color or add an icon

1. Open the keyword list.
2. Switch to the Keywords tab.

3. Select a keyword in the main table and choose any style you want from the tab menu.

Using the submenu "Style" you can:
- add an icon for any keyword;
- make the font bold, italic, underline or strikethrough;
- change the font size, style, color or background color;
- format the text.


Error messages:


Error message during keyword search: "System.OutOfMemoryException"

You can get this error message when there is no more free RAM on your computer for the software to proceed and complete the search.

If you constantly get this message, you should do the following steps: 
1. Switch to the Settings tab and limit the amount of keywords found for one keyword list, for example, to 500,000.

2. Enter less keywords for search into the filter form. 
3. Use keyword matching options, like "broad" or [direct] match (see Keyword matching options).


Error message during startup of the software: "Can't connect to server"

You can get this message when your software is out of date. To update the software turn it off and deleted a temp folder of the software:

- for Windows XP: С:Documents and Settingsuser_nameLocal SettingsApplication DataPastukhov

- for Windows VistaWindows 7: C:Usersuser_nameAppDataLocalPastukhov

Then download Xedant.com Keyword Databases software here, run the installation file and follow the dialogs of the installer.

 Please do not use proxy servers for internet connection as you won't be able to login to the software.


How to run keyword search if you get an error "System.OutOfMemoryException"

Most of computers/notebooks can handle not more than 2 millions of keywords at a time. If there would be more than 2 millions of them you will get an error "System.OutOfMemoryException". It means that there is not enough free RAM to create new keyword list from the database.

If the amount of keywords exceeds the system limit, follow these simple steps:

Let's run a simple search query and get the list all keywords containing the word "download".
1. Start the program and open your base (save file). If you do not have the base yet, please read how to create it in the "Quick start"
2. Choose the Document tab: New document -> Find more specific keywords -> English 245 mln. Keyword Database

 If you start the program for the first time, specify the folder in the Settings tab with the unpacked keyword database stored on your local or USB hard drive.

3. Enter keywords for search into the form. You can use several keyword matching options:

a) broad match keyword - in this case all search queries in which there is simultaneous occurrence of any words with different word order will be found.

b) "phrase match keyword" - in this case all search queries in which there is simultaneous occurrence of specified words with direct word order will be found.

c) [direct match keyword] - in this case only search queries in which there is simultaneous occurrence of specified words and grammatical forms with direct word order will be found.

Let use the first variant as there is no any unnecessary wordforms from the word "download" that can "spoil" our future keyword list.

 All operations are carried out in a background mode. You can see the progress bar in the right bottom of the main window.

4. For example set special parameters as described below: 
- Limit number of results to: 1000000
- Skip first: 0

5. You will get the list of keywords that contains the first million of keywords from the database for the word "download".

6. Choose the Document tab: New document -> Find more specific keywords -> English 245 mln. Keyword Database

7. Type again the word "download" in the filter form.

8. Set special parameters as described below: 
- Limit number of results to: 1000000
- Skip first: 100000

9. You will get the list of keywords that contains the second million of keywords from the database for the word "download".

10. Etc.

In this way you can search for any amount of keywords no matter how many keywords there are in the database.