Saturday, 10 November 2018

Keywords Editor - Updates

Two updates of WORDz.co Keywords Editor

1. Analysis of the theme of a keywords list

You can know the frequency of word or words in a keywords list. Just select a column of keywords and press "Themes" button in the "Compile Keywords" functions group.

Simple report on frequency of word/ words of a keyword list


2. Change the "Destination URL" to "Final URL"

URL is one of the fields of the output table to be uploaded to Adwords Editor. We changed the header "Destination URL" to "Final URL".

Below shows how to Copy and Paste the output table to Adwords Editor.

Copy and Paste output table in Excel to Adwords Editor.

Monday, 29 October 2018

Group a Column of Keywords by Common Theme (Word or Words)

How to segregate and group a list of keywords by common theme? Without using any tool, the process is slow, tedious and exhausting.

Keywords Editor has a function, i.e. "By Words" (i.e. Compile Keywords by Words), that can segregate and group the list of keywords quickly based on common word/words contained in the keywords.

The two demos below show how the keyword tool works. Try it, you can download a free copy here.

1. The demo below shows how to group keywords that contained "sneaker" and "sport shoes" to one column and keywords that contained "glove" and "gloves" to another column.

Group and segregate keywords by common word/ words into columns


2. The demo below shows how to group keywords that contained "sneaker" and "sport shoes" into one table that can be uploaded to your campaign through Copy and Paste to Adwords Editor's "Making Multiple Changes" function.

Group and segregate keywords by common word/ words into table. Copy & paste the table to Adwords Editor.


You can download a free trial copy of WORDz.co Keywords Editor here.

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.