WORDz.co Blog

Monday, 4 May 2015

You can get more keywords ideas from the keywords suggested by search engines at the bottom of the search results page based on your original search term. You can extract these keywords quickly into your Excel worksheet. You don't even need to copy and paste from the search results page and to the worksheet.

You can download this free Excel Add-In tool here.

Free Download

Note: For a comprehensive Excel Add-In to manage and manipulate keywords in bulk, check out our Keywords Editor, a "Swiss Army Knife" tool for keywords.

Note 2: Search engines may change the layout of search results page from time to time, therefore this tool will need constant update. Visit this page frequently to get the most updated version.

Friday, 1 August 2014

We released another powerful feature to compile keywords listed in different columns in Excel into various ad groups. The new command is "By Column" under Compile Keywords section. It compiles the keywords in each column as one ad group into a format readily to be uploaded to Adwords Editor.

The full keyword work flow:

Segregate your keywords into different columns. Each column represents an ad group. There are many existing commands, e.g. "By Words" (with Table checkbox unmarked), in Keywords Editor can help you to perform the segregation quickly and efficiently into columns.

Click "Group" button to execute. A new sheet will be created. The keywords are compiled into a format easily to be uploaded to Adwords Editor

Demo

In this demo you can see that the keywords are already organized into columns. This "By Column" command will compile the keywords in each column into an ad group. The name of the ad group is the keywords of the 1st cell of the column. We further breakdown the ad groups by match type. The output is at Sheet 7, it is a format that can be copy and paste to Adwords Editor.

We organize keywords in each column into its respective ad group.

Once you click the "Group" button, the "By Column" command will execute and the output is placed in a new sheet. The output is in a format easily to be copy and paste to Adwords Editor as below.

Tuesday, 29 July 2014

Now it is easy to extract and group thousands of keywords quickly into small, tight-knit and highly relevant ad groups, which is the only way to build effective and highly converting campaigns.

In ONE Command, Keywords Editor performs the processes below:

extracts highly related keywords from thousands of keywords,

groups them into a tiny ad groups and campaign (so that you can write very relevant ad copies)

compiles them into a format for quick upload to Adwords

You determine the words that serve as grouping criteria of the keywords. You have full control of the grouping structure. It saves you immense amount of time, efforts and money by eliminating keywords organizing efforts.

Deadlines Vs Effective Ad Groups

You downloaded thousands of keywords from various keyword research and planning tools. You realized the immense mundane and repetitive tasks required to segregate and compile these keywords into tiny and effective ad groups within a tight deadline. What did you do?

You probably decided to sacrifice several nights of sleep to produce that ideal small, relevant and laser sharp ad groups to meet the tight deadlines. Or you might decided to settle for looser, larger and more general ad groups and hope for the best.

Now, you can extract, group and compile thousands keywords into many tiny, laser sharp and highly relevant ad groups in minutes. Without losing your sleep.

The reasons of sloppy ad groups and campaign structure are simply because of the enormous efforts required to sort out and group vast volume of keywords within tight deadline. Without a proper keyword grouping tool, it is simply impossible to produce high quality campaigns within the expected deadline.

Extract, group and compile highly related keywords into Ad Group based on words criteria.

The above demo shows how I use this simple tool, in just a few steps:

to extract highly related keywords (all of them contain the words baby and boy and card OR baby and boy and cards,

to group and compile them with other information like Max CPC, Match Types, Ad Group Names, Campaign Name, etc. into a table format that is readily to be copy and paste to Adwords Editor

Step-by-step:

1. Excel Ribbon Button

1. Select Copy Output check box so that the Output is ready to be pasted
2. Select Table check box
3. Click on By Words button to trigger Group By Words dialog box

2. Group By Words Dialog Box

We fill up the words criteria and other information to generate the output.

The text box allows users to use comma ("," for OR) and ampersand ("&" for AND) to extract keywords in a more precise way. In our example, the words in the text box are baby & boy & card, baby & boy & cards. The extracted, grouped and compiled keywords must consist of words: baby AND boy AND card OR baby AND boy AND cards. Therefore, words like baby boy congratulation cards will be extracted but baby cards will not be extracted.

Method 2

You can also extract and arrange all grouped keywords into different columns using Ribbon button "By Words" command. Once you are comfortable with how all the keywords were grouped, you can use Ribbon button "Select" to compile these keywords into a format for quick copy and paste to Adwords Editor

Watch the demo below:
Step 1: Group the keywords into columns first
Step 2: Compile the keywords in the columns to table format for quick upload to Adwords Editor

Step 1: Group the extracted keywords into Columns

This demo illustrates how to extract keywords from a list based on the words contained in the keywords.
The process extract the keywords that fit the criteria and places them into the next columns.
You can repeat the process to group the keywords into many columns.

Step 1's detail Step-by-step image

The extracted keywords based on words criteria were placed at the next column at right. You need to
1. Select the cells
2. unmark the Table check box at the Excel Ribbon
3. Click "By Words" button to trigger Group by Words (Web Interface) dialog box
4. Enter the words criteria
5. Click "Group" button

Other useful Excel Built-in Functions
You can sort the keywords in various columns using Excel built-in command, "Sort" at Data Command Tab.

Step 2: Compile the keywords in the same column into an ad group

Select the cells in the same column.

All keywords in the selected cells will be compiled into a table for upload to Adwords Editor.

Method 2 enables you to have an grouping overview of all keywords before you compile them into table and upload them to Adwords Editor. Through such process you can identify negative keywords and easily add them to your campaigns.

Method 3

This method uses the built-in command of Excel, i.e. Filter, to extract relevant keywords from a keyword list with thousands of keywords.

You may use the Filter function of Excel to segregate and extract the keywords from its original list.

1. Enter your words criteria, i.e. contains,
2. Copy the filtered result and paste to another sheet.
Note: In this method, you only have maximum two words criteria to extract keywords

1. Copy and paste the filtered result to another sheet.
2. Hit Delete key to clear the copied keywords from the original list

Finally, clear the filter. You can start again to extract keywords with different words criteria.

You can repeat the process to extract keywords and group them in different columns. However, this method is cumbersome and slow as compared to the earlier two methods.

Keywords Editor

The processes described in method 1 and 2 are part of Keywords Editor. They are particularly useful in cutting down time and efforts required in moving and organizing keywords to be uploaded to Adwords and Bing during and after keywords research.

Other Resources

Here are a few very useful resources in learning ways to do keywords research and using online keywords tools:

Keyword Research Books

This online book, Keyword Research: The Definitive Guide by Brian Dean from Backlinko.Com, is one of the most comprehensive book on the topic of keywords research and niche market. There are 7 chapters in total. It explains ways to explore and to dig deeper into your market niche. It introduces many useful tools in doing your keyword research.

MOZ.com has a very good chapter on Keyword Research from their book The Beginners Guide to SEO.

WordStream has a free keyword grouper that I think is fun and easy to use. It is quick because the application try to determine the grouping structure on your behalf.

Keyword Grouping Tool from SpyFu, Groupie. Just like WordStream above, both tools attempt to determine grouping structure on your behalf. I am truly impressed by the grouped results consider that the grouping structure is determined by the application. The advantage of such tools is that it is quick and easy to use. The disadvantage is that you have less control over how the keywords should be grouped, which is important.

The original command allows users to extract keywords that contain certain words, from a list of keywords. For instance:
User can specify words like baby, card, cards in the command’s textbox. The “By Word” command will extract all keywords that contain baby OR card OR cards from the selected list of keywords.

In this new release, the “By Word” command is enhanced to allow user to state more stringent criteria of AND. For instance, User can specify words like baby & card in the command’s textbox. The “By Word” command will extract all keywords that contain both words of baby AND card from the selected list of keywords.

The comma ("," OR) and ampersand ("&" AND) can be combined for use. For instance, in the case of baby & card, baby & cards, the “By Word” command will extract all keywords that contain baby AND card OR baby AND cards.

This speed up the keywords grouping tasks tremendously. There is no change in the option of output. You can decide whether the output is in the format of table for easy upload to Adwords Editor OR in the format of keywords list for further segregating or for overview before further grouping.

The keywords that meet the criteria in the textbox will be extracted to a new sheet in a format that can be easily upload to Adwords Editor. These keywords will be deleted from the original list too.

B) On Combining list of words into new Keywords, allowing skipping of words while adding broad match modifiers to other words in the list.

Function: Compile Keywords, "Combine"

The original command allows users to Combine (we refer this word to the mathematics meaning of Combination) multiple list of words to create a new list of keywords.

It also allow empty word, represented by a space, in the word lists . This space in the word lists enables combination of words (of different lists) in creating new keywords without words from the respective lists.

C) On Cleaning Text from extra spaces and pluses

We added new function to clean not just extra space or spaces in keywords phrases, but extra plus signs ("+") due to insertion of broad match modifiers.

D) Add Broad Match Modifier Option for Permutation Command

Function: Compile Keywords, "Permute"

This specific improvement is not very important. Broad Match Modifier will work well regardless of the position or order of words in keywords phrases. However for consistency and special needs we added the option to mark broad match modifier while executing the command of Permutation (changing order of words in keywords phrases).

E) Broad Match Modifier Text Box

Function: Keyword Match Type, "Modified" > "Specific Words"

This command allow users to add broad match modifiers to the words in keywords. You may separate each word in the text box with either comma (",") or ampersand ("&"). In the case of adding Broad Match Modifier, both operators (comma and ampersand) mean OR.

You can separate each word by comma (",") or ampersand ("&").
There is no difference in this function of adding broad match modifier to words insider keywords.