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.


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.