Monday, 4 May 2015

Wordz Expand (Keywords Ideas from Search Results)

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.
keyword grouping tool download
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.

Sunday, 26 April 2015

Wordz Trim is a simple tool to remove all spaces from text except for single spaces between words. You select the cells that contain the text and click to remove the extra spaces.

Instead of writing formula in the cells like this, i.e. =TRIM(+A1), =TRIM(+A2), =TRIM(+A3), etc., you simply
  1. select the cells that contain the text and
  2. click to remove the extra spaces




You can download this free Excel's add-in tool here.
keyword grouping tool download
Free Download


Note: For more features to manage and manipulate keywords in bulk, check out our Keywords Editor, a "Swiss Knife" tool for keywords.


Saturday, 13 December 2014

New Google Adwords Editor 11

Google just released its latest version of Adwords Editor. It looks promising in simplifying and quickening the process of campaign building. These are 4 things that I truly like
  1. its interface
  2. the way it structured multiple users and further access to multiple accounts
  3. the way it structured the access to campaigns, groups, keywords and ads
  4. it is fast on my Windows 8 PC






Comments from the industry experts are generally positive. Here are the comments from a few of the experts:
  1. Larry Kim on the New Google Adwords Editor 11
  2. Ginny Marvin on the New Google Adwords Editor 11
  3. From the horse mouth, Google Adwords's blog on the new Adwords Editor 11
  4. Check the discussion on Adwords Editor in Google Adwords Community


There are small unfavorable changes made, for instance Keyword Grouper function in Adwords Editor 10.6 and earlier was removed.

Tuesday, 28 October 2014

Keyword Grouping: Wordz Group 1.01

We released an updated version of our keywords grouping tool, Wordz Group.

It is an Excel add-in. It splits your long list of keywords into smaller groups based on your criteria of word or words.



Step-by-Step


  • Select your list of keywords on the worksheet
  • Enter word or words (separated by comma ( , ) and/ or ampersand ( & )) as criteria to extract keywords from the list
  • In one click, it will extract all the keywords that contain the word or words you indicated and place them in another column
  • It will also automatically delete the extracted keywords from the original list


We distribute this little powerful Excel add-in tool for free. You can download it here.


Other free or free for evaluation resources:







Friday, 1 August 2014

Keywords Editor Version 2.0.4 New Release

Keywords Editor has a new release, i.e. Keywords Editor version 2.0.4

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:

  1. 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. 
  2. Select/ Highlight these columns 
  3. Click "By Column" command  (with Table checkbox marked) on the Ribbon command bar to trigger "Group by Column to Table" dialog box
  4. Fill up the information like max cpc, campaign names, etc. 
  5. 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.

Copy and Paste to Adwords Editor

Upload the output of the "By Column" Command to Adwords Editor.


Tuesday, 29 July 2014

Adwords Keyword Grouping Tool

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.


It runs on desktop, Windows 7 and higher, Excel 2007 and higher.


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.


3 Ways to Group Thousands of Keywords in Excel Quickly


Method 1

4 Steps:
  1. Select cells that contain keywords
  2. Click on Ribbon button "By Words" at Compile Keywords section
  3. Enter words criteria and update settings
  4. Click Go. The keywords that meet the words criteria will be compiled into a format for quick copy and paste to Adwords Editor

Watch the demo below:

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:
  1. to extract highly related keywords (all of them contain the words baby and boy and card OR baby and boy and cards
  2. 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.

Step 2's Detail Step-by-step image

1. Select Cells
2. Select "Table" checkbox in the Ribbon
3. Click on "Select" button in the Ribbon to trigger the "Select & Group to Table" dialog box
4. Enter words criteria and other settings
5. Click "Group" button

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. Select cells with keywords and header
2. Select "Data" tab
3. Click "Filter" button to enable filter function


1. Click the inverted triangle icon beside the header
2. Select "Text Filters"
3. Select "Contains"


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.

Keywords Editor has in total 5 major streamlined processes that allow users to extract/expand, group/organize and compile keywords into columns or table for easy upload to Adwords Editor. Read about how these 5 major streamlined processes can help you to speed up your works.

Other Resources

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

Keyword Research Books
  1. 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.
  2. MOZ.com has a very good chapter on Keyword Research from their book The Beginners Guide to SEO.
  3. Wordtracker Academy has classic write-ups and videos on Keyword Research for SEO.
  4. A real good interview with Larry Kim on How to Group Your Keywords

Using Excel for PPC
  1. In her blog post, Advanced Excel Tips for PPC Manager, Katie Walton listed down many advanced techniques written by various PPC experts in using Excel for PPC.
  2. Two very useful articles on using Excel for PPC by John Gagnon: 10 Quick Time-Saving Excel Shortcuts & Mouse Tricks for Marketers and Excel VLOOKUP Basics & Top 5 Mistakes Rookies Make

Keyword Tools to Expand keywords
A list of keyword research tools that are useful in your process of finding keywords for your niche:
  1. Bing Keyword Research Tool
  2. Google Adwords Keyword Planner
  3. I use Google Adwords's Ad Preview and Diagnosis Tool during keyword research phase to check competition and expand keywords
  4. Google provides a list of suggested keywords at the bottom of Search Engine Result Page
  5. A list of free Keyword Tools that you can use to expand your keywords

Other Keywords Grouper in the market

  1. 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.
  2. 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. 
  3. 12 Popular Keywords Organizing Tips and Tools by the online marketing industry veteran website, SEOBook. 
  4. A list of 5 Keyword Grouping Tools evaluated by Jarad Collier from PPC Campaign Generator
  5. Another list of 22 Free Keyword Tools for PPC and SEO by Elizabeth Marsten  though not limited to keyword grouping. Some tools in the article may be obsolete as it was published in 2010.
  6. Our free and simple keywords grouping tool, Wordz Group. It is an Excel Add-In (.xlam file) works on Excel 2007, 2010 and 2013. 


Wednesday, 23 July 2014

Keywords Editor Version 2.0.3 New Release

We have made a few important improvements in the release of Keywords Editor 2.0.3. We enhanced important commands of Keywords Editor to enable user to speed up their keywords tasks.


A) On Grouping/ Segregating a list of keywords into small, tightly knitted and highly relevant ad groups.


Function: Compile Keywords, “By Words”

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. 

For instance, there are 3 list of words below:

List 1          List 2                     List 3
baby boy    birthday                 card
baby girl   congratulation         cards
           (a space)

The outcomes are the new combinations of words like baby boy birthday card, baby girl birthday card, baby boy congratulation card, baby girl congratulation card, etc.

The space in the 2nd word list allow new words combination like baby boy card, baby boy cards, baby girl card and baby girl cards, which is without the words like birthday and congratulation. 

In earlier version, this cannot work well if you opted for Broad Match Modifier for the new words. Now broad match modifier, in "Combine" operation, can work with word lists that contain empty space.


C) On Cleaning Text from extra spaces and pluses


Function: Text Utilities, "Clean Text" > "Remove Extra Spaces and Pluses"

Remove excess spaces and plus signs.
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.

Read the Full Functionality of Keywords Editor here and find out how it can help you to group keywords quickly and to create effective and tightly knitted ad groups.