Thursday, 21 March 2019

Smooth PPC WorkFlow using Keywords Editor

It should take you less than 3 minutes to compile keywords for your campaign
  • from a list of keywords in Excel 
  • to properly grouped keywords into Ad Groups in Adwords Editor, with Max CPC, Campaign name, Ad Group name, URL, etc. 

Yes, it takes just 3 minutes to compile a long list of raw keywords into grouped and compiled keywords in Ad Groups in Adwords Editor with relevant information for a search campaign. Tested and proven.

This is the workflow using Keywords Editor to compile keywords for Google Adwords's PPC campaign. You can download the trial version here.

Watch the demos below, 3 steps.

Step 1: Group your keywords list based on common word or words into column. You can add match types, including broad modifiers. This process should take less than 10 seconds for each column of keywords.

In 1 minutes, you would have at least 6 groups of keywords in 6 columns.

Group keywords into columns based on common word or words.


Step 2: Convert the columns format to table format in Excel spreadsheet to be uploaded to Adwords Editor. All match types, including broad modifiers and negative, will be converted to table format too. 

This process should take less than 1 minutes.

Compile the keywords list into table format for upload. Grouping the keywords based on column and maintaining the match types, including the broad modifiers.

Step 3: Copy and paste the compiled keywords in table format from Excel spreadsheet to Adwords Editor.

This process should take less than 1 minutes.

Upload the keywords table in Excel spreadsheet to Adwords Editor. 

Basically your keywords for the campaign are done after this. Just concentrate to write your ads. You may download the Keywords Editor here.



Keywords Editor (Update 2): Group your Keywords List from Multiple Columns to table

This update of Keywords Editor enhance the PPC process to become smoother and quicker.

We can group the keywords in to Ad Group based on column in the Excel spreadsheet, i.e. one column of keywords into one Ad Group. There is an option to further break down into different Ad Group by match type.

In the previous version, this process will delete the match types of the keywords in the column. User had to define match types when converting column to table.

In this updated version, users can define match types when they group the keywords by column. This process will not delete the match types but instead will pick up the match types (including all broad modifiers) in the column format to be converted to table format (for upload to Adwords Editor). 

It becomes a very smooth PPC workflow. Watch the demo below.


Group by different columns and maintain the match types (include broad modifier) of keywords in the column.

Watch the demo in the next blog post showing the entire smooth PPC workflow to compile the keywords from list into campaign in Adwords Editor.

You may download the trial version of Keywords Editor here.

#ppcworkflow

Wednesday, 20 March 2019

Keywords Editor (Update 1): More analysis on the theme of a keywords list

This update of Keywords Editor helps users to find out the most common word or words in a keywords list.

We added in earlier version the capability for users to know the frequency of word or words in a keywords list. Users select a column of keywords and press "Themes" button in the "Compile Keywords" functions group.

This version we expand the analysis on frequency of keywords/phrases up to 6 words. Watch the demo below.


Analyse your keywords in details. Simple report on frequency of word/ words of a keyword list up to 6 words in your keywords/ phrases. 

It provides more information as compared to the earlier version. (Trial version remains at max 3 words.)

You may download the trial version of Keywords Editor here.

Saturday, 16 March 2019

Unit Converter

Microsoft Excel has a CONVERT function that will convert a number from one measurement unit to another measurement unit.
Formula: =CONVERT(number, from unit, to unit)
Example: =CONVERT(1.5, "ozm", "g")
This is a powerful function as it contains a comprehensive list of measurement units and full range of metric prefixes from yocto (x10-24) to yotta (x1024). In between these Yocto and Yotta are prefixes like Kilo (x103), Mega(x106), Giga(x109), Mili (x10-3), Micro (x10-6), etc. just to name a few of the famous one. Among the measurement units, one may scratch his head to find out the codes for Angstrom or light year in the =CONVERT() formula to calculate distance.

As you can see, finding a specific unit code and metric prefix code for the CONVERT formula is not straight forward for most users. This Unit Converter, an Excel Add-In, makes the unit conversion and insertion of =CONVERT formula extremely easy.

WORDzco Unit Converter

WORDzco Unit Converter converts number values in all selected cells from a measurement unit to another unit. You can choose the converted output as EITHER number OR in CONVERT formula, i.e. =CONVERT(2.6,"mi","m"). It is fast and is easy to use and it runs on your own desktop. Watch this:

Convert Square Feet to Square Meter 

Full list of metric prefixes from the ultimate big Yotta, Zetta, Exa, etc. to Tera, Giga, Mega, Kilo to mili, micro, nano, right down to ultimate small atto, zepto, yocto.


You may download and try the free complimentary version here, OR WATCH DEMO of the complete functionality of the Unit Converter.

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.