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.

Wednesday, 11 June 2014

5 Streamlined Keywords Processes before Compilation to PPC campaign

We identified 5 keywords process flows that can be streamlined before compiling them into a format that can be loaded to Adwords through Adwords Editor.

  1. Permute
  2. Combine
  3. Extract
  4. Filter
  5. Select 

Permutation


Permutation is the process of rearranging word order of a keyword phrase. This process is useful in expanding your existing campaigns in the following scenario:
  • When you have high performing Modified Broad Match keywords that you want to expand to Phrase Match and Exact Match in order to serve more precise ad copy and to have better control of CTR and CPC.
  • When you have high performing Phrase Match or Exact Match keywords that you want to explore variations of different word order.

4 Quick Steps:
  1. Select cells with the keywords you want to permute
  2. Click Permute Ribbon button
  3. Define settings, i.e. ad group grouping method and name, Max CPC, keywords status, etc.
  4. Click Permute button to process and compile keywords to a format readily to be copy and paste to Adwords Editor

The streamlined process is fast with Excel VBA (Macro) automation.


Notes:
  • You can permute as many keywords in any one time with the limit of 1,000,000 output keywords.
  • You can group the keyword variations based on 
    • the original keyword, and 
    • further grouped by match type. 
  • If you further grouped your variations by match type, you can easily select and copy 
    • the Exact Match output and load to Adwords as negative keywords in the Ad Group for Phrase Match
    • the Phrase Match output and  load to Adwords as negative keywords in the Ad Group for Broad Match
  • This will ensure a more predictable Adwords' ad triggering behavior.
  • More about Permutation Process.



  • Use first, pay later. Download now
  • 30-day evaluation period
  • Authentic full version (non trial)
  • 30-day money back guarantee
  • Future new functions and bug fix
  • You may download from Dropbox
It runs on desktop, Windows 7 and higher, Excel 2007 and higher.


Combination


Combination is the process to combine and mix words in multiple columns words lists to create new keywords. This is the process useful to build a new campaign from scratch. Below is an example:

You can combine multiple keywords list like:
  • sport wear, i.e. running shoes, athletic shoes, sneakers, etc.
  • colors, i.e. red, blue, white, rainbow, etc.
  • brand, i.e. Nike, Reebok, Puma, etc.

To keyword phrases like "running shoes red Nike", "running shoes blue Reebok", etc.

This process is particular useful when you start a new project where the search terms contain many possible combination of words.


4 Quick Steps:
  1. Select multiple columns of words (each column is a list of words)
  2. Click Combine Ribbon button
  3. Define settings, i.e. ad group grouping method and name, Max CPC, keywords status, etc.
  4. Click Combine button to process and compile keywords to a format readily to be copy and paste to Adwords Editor

The streamlined process is fast with Excel VBA (Macro) automation.

Note:

  • You can combine as many columns of words or as many words in a columns as you like. The limit is 1,000,000 output keywords.
  • You can select column or columns that the words in the columns will be combined to become ad group name. Keywords will be grouped accordingly.
  • You may further group the keywords by match types.
  • You can have extra combinations that skip words in certain columns
  • More about Combination Process


Extract


Keywords come from different sources, i.e. Google Keyword Planner, keywords competition tools, suggested search terms at the bottom of SERP, download from Adwords account, etc.

You can extract and compile the keywords that contain specific words as indicated in a text box.

4 Quick Steps:
  1. Select range of cells of the entire keyword list
  2. Click By Words Ribbon button
  3. Define settings, i.e. specific words, ad group grouping method and name, Max CPC, keywords status, etc.
  4. Click Group button to extract and compile keywords to a format readily to be copy and paste to Adwords Editor


The extracted keywords will be deleted from its original cells. You can continue to work on the remaining keywords without fear of duplication.

Extract and compile from raw keywords to table readily to be loaded to Adwords.


Filter


It works like Extract above, but it is the reversal. You extract and compile the keywords that does not contain specific words in the text box.

4 Quick Steps:
  1. Select range of cells of the entire keyword list
  2. Click By Words Ribbon button
  3. Define settings, i.e. specific words, mark Inverse check box, ad group grouping method and name, Max CPC, keywords status, etc.
  4. Click Group button to extract and compile keywords to a format readily to be copy and paste to Adwords Editor

The extracted keywords will be deleted from its original cells. You can continue to work on the remaining keywords without fear of duplication.

Filter out the keywords that contain specific words and extract the remaining.


Manually Select


How many times when you go through your keywords reports or SEO keywords lists, you hope to be able to just select, group and upload them to Adwords into ad groups? You can now.

4 Quick Steps:
  • Press Ctrl + multiple Mouse Clicks (and click and drag to select a range) to select the range or ranges of cells with keywords that you want to compile. 
  • Click Select Ribbon button
  • Define settings, i.e. use keywords in active cell as ad group name, match types, Max CPC, etc.
  • Click Group button. All your selected keywords will be compiled to a format readily to be copy and paste to Adwords Editor

The selected keywords will be deleted from its original cells. You can continue to work on the remaining keywords without fear of duplication.

Select the keywords, group and compile. More notes here.




  • Use first, pay later. Download now
  • 30-day evaluation period
  • Authentic full version (non trial)
  • 30-day money back guarantee
  • Future new functions and bug fix
  • You may download from Dropbox
It runs on desktop, Windows 7 and higher, Excel 2007 and higher.

  • The above 5 streamlined keyword processes are merely part of the functions of Keywords Editor.
  • Keywords Editor have more functions which are flexible enough for user to edit, expand and manipulate keywords on the fly and compile them quickly into a format readily for upload to Adwords.
  • Read more about Keywords Editor




Thursday, 5 June 2014

5 Ways to Shut Down Windows 8 Quickly

Here are the top 5 ways to shut down Windows 8 quickly.

Method No. 5

Use mouse only. One smooth swipe with 3 clicks.
  • Move your mouse cursor to bottom right corner to trigger Charms bar
  • Click on Settings > Power > Shut Down

shut down windows 8
A smooth swipe with 3 clicks

There are 2 problems with this method:
  • The swipe to bottom right corner do require some practice in order to be able to trigger charms consistently
  • 3 clicks is a bit too strenuous for shutting down a computer

Tuesday, 27 May 2014

Keyword Grouping

We segregate and group keywords in such a way that we can write effective and meaningful ads for each of the keywords group.

The outcome of negating and grouping keywords using Adwords' Keyword Planner can be quite unpredictable. It is quite difficult to write meaningful and effective ads based on the auto-suggested grouping of keywords. Yet it is time consuming to group these keywords manually in Adwords.

Most of the time, we feel we waste many unwanted keywords in the Keyword Planner because it is difficult to turn all of them into negative keywords using the Adwords interface.

Therefore we always download the entire list of keywords from Adwords' Keyword Planner and group them the way we understand the intent of the keywords. We can then write meaningful and effective ads for each Ad Group efficiently. More importantly this process also gives us a list of COMPLETE negative keywords. We don't waste a single keyword from our original downloaded list.

This is the keyword grouping tool we use.

keyword grouping tool download

Keyword Grouping Tool: Wordz Group


Wordz Group is an Excel add-in that extends functionality of your Excel to segregate and group keywords into multiple lists quickly. It segregates keywords based on specific word or words that contain in the keywords.

Watch this demo to understand this simple keyword tool:
  • We have a keywords list on "Baby Card" downloaded from Keyword Planner
  • We want to segregate the list into multiple lists
    • with different intentions like baby shower invitation card, baby announcement card, baby congratulation card, baby thank you card, etc. and 
    • with more specific intentions like baby girl card, baby boy card, personalized baby card, etc.

Segregate the keywords list downloaded from Adwords' Keyword Planner into multiple lists.


Step-by-Step


  • Just select the cells that contain the keywords list and click the ribbon button "Group Keywords" to call out a dialog box
  • Enter the word(s) that contain in keywords (which you want to include in the new list) into a text box and press Group button
  • Keywords that contain the word(s) will be grouped into a new list and placed at the right column of the selected cells. These keywords will be deleted from the original list.

keyword grouping tool download


Processes Before and After Grouping


You can have your keywords list downloaded from Keyword Planner sorted and grouped in a minute or two. You can then use the Keywords Editor's Adwords Wrapper to tag the keywords with match type and upload them to Adwords through either web based interface or Adwords Editor.


Keywords Editor

Try Keywords Editor, a keyword tool running on Excel with more complete keywords grouping and compiling functionality. 30-day free trial. READ how to extract, group and compile keywords in a most efficient way.

Thursday, 22 May 2014

Broad Match Modifier and Tools

We designed this keyword tool, Keywords Editor's Wrapper to streamline the process of tagging words with plus (+) sign and quotes for Broad Match Modifier and other match types.

You can copy and paste the output to Adwords Editor or web-based Adwords interface. It is easy to use, just double click the downloaded add-in file and the functionality will be added to your current Excel session.




  • Keywords Editor's Adwords Wrapper
  • Download at Google drive


Macro Functions for Broad Match Modifier


1) Add Plus (+) Sign to ALL Words in the Keywords

Just select the range of cells that contain the keyword phrases and execute the command. It is easy.

1. Select the range,  2. Click to "Modified All Words" and done.


2) Add Plus (+) Sign to SPECIFIC Words in the Keywords

You can tag plus sign to specific word or a list of words to the entire list of keyword phrases.

Specify the word or words you want to add modifier in the text box.

You may indicate to tag all words with plus sign EXCEPT for words specified in the text box.

Tag all with + sign EXCEPT these words in the text box.


3) Add Plus Sign to SPECIFIC Words in the Keywords based on Word Order

This command allow you to add plus sign based on word order from left or word order from right.

Add plus sign based on word order.


4) Upload Through Adwords Editor

Convert the match types to a format that you can copy and paste to Adwords Editor.

Just copy and paste to Adwords Editor.


5) Key features of Keywords Editor's Wrapper

Tagging Broad Match Modifier is only part of the full functionality of KE Wrapper. Find out more about Keywords Editor's Wrapper here.




  • You can download the Keywords Editor's Wrapper, an Excel Add-In file (file with xlam extension) here. It is free of charge for use. You may share it with your friends without changing any part of the file. It is digitally signed.
  • System requirements, i.e. Microsoft Excel 2007, 2010 and 2013, Windows 7 and above.
  • More information on installation and how it works.
  • More information on key features.
  • Help page.
It is easy to use. Just double click the xlam file and the functionality will be added to your Excel during the current session (until you close all Excel Workbook).


List of Popular Broad Match Modifier Tools


You can find many useful Modified Broad Match keywords tools from the Internet. Here is a list of the popular one:

Online text box
  • Keyword Wrapper from SEOM Interactive. A simple and effective online keywords wrapping tool that includes BMM tagging based on specific word or words.
  • Adwords Broad Keyword Converter from acquisio.com. A popular online Broad Match Modifier tool.

Browser Add-On
  • Usability Booster for AdWords optimizers is an amazing web based interface Adwords tool from Data-Inside. It is an add-on to Chrome and Firefox browsers for all match types. For Broad Match Modifier, you can only tag all words (and not specific words). Introduced by Holger Schulz at Google+.

Adwords Editor
  • You can tag keywords with Broad Match Modifier directly inside Adwords Editor (Read guides below).

Excel Spreadsheet with VBA Macro or Formula
  • Modified Broad Match Keyword Tool from Chad Summerhill. It is an Excel file with macro capability to manipulate the keywords. You can tag BMM to specific words in keywords phrases.
  • Spreadsheet and formulas (Read guides below)
  • Excel with automated macro program like Keywords Editor's Wrapper (KEW) from us. These are automated Excel macro that tag your keywords quickly with Broad Match Modifier or other match types. KEW is designed to load keywords to Adwords Editor smoothly.


Guides on Tagging Plus (+) Sign, Broad Match Modifier


The how-to guides found on the Internet to tag Broad Match Modifier can be generalized into two categories. The first group is on tagging BMM in Adwords Editor and the second group is on tagging BMM using Excel. Here is the list:

Guides to use Adwords Editor for Broad Match Modifier:

Although both guides above explain on tagging ALL words with BMM, their "Find Replace" method can be used to tag BMM to specific words too.

Guides to use Excel formula or Macro for Broad Match Modifier:



Why Broad Match Modifier matters?


Broad Match Modifier or Modified Broad Match (BMM) is an important feature of PPC advertising. It allows the advertisers to explore unknown search terms just like the use of Broad Match, yet it gives an extra control to disallow deviations from specific words.

When we start a new campaign or project, we usually have a few Ad Groups with Broad Match Modifier and Negative Keywords. We will check the "SEARCH TERMS" report to further refine our keywords list by adding negative, phrase match and exact match keywords. It is a simple but effective strategy to start a new campaign.

Here are the list of explanations from the horse mouth, i.e. Google and Microsoft's Help Page:


Guides and Strategies of using Broad Match Modifiers from industry experts:


Back to Top

Monday, 19 May 2014

Wordz TagALL: A URL Builder to Tag All Types of Parameters

Wordz TagAll is a URL builder designed to tag all types of parameters to URLs in bulk.

Steps:
  • Select the range of cells where the first row is parameter name and first column at left is URLs.
  • Decide if you want to encode special characters in the parameter values.
  • Click Tag. 

Watch this:
Tag anything to your URLs.

To explain further:
  • The first row is Parameter Names
  • Second row onward is URLs and their respective parameter values
  • The first column at left is the original URLs to be tagged
  • The output (tagged URLs) will be at the last column at right.

It is easy to use this Excel add-in. Just double click the Excel add-in file and this function will be available in your Excel program. It will close once you close all workbooks in the same session.

  • Improved Version 1.1.0 released on 22 May 2014
  • It is digitally signed.
  • System requirements, i.e. Microsoft Excel 2007, 2010 and 2013, Windows 7 and above.

Wordz TagAll allows you to tag tracking parameters from different web analytics services and not just Google Analytics. It is easy to use. Just double click the xlam file and the functionality will be added to your Excel during the entire current session (until you close all Excel Workbook).


List of Web Analytics Vendors

(and their web tracking services)


List of URLs Tagging Tools (URL Builder)



More Interesting Resources on Web Analytics



Friday, 16 May 2014

Simple Ways to Use Excel Add-In (.xlam)

Excel add-in is an Excel file type that adds extra functionality to Excel spreadsheet. It contains programming codes that give extra features, i.e. commands, formulas, etc. to Excel. This file type ends with extension .xlam.

There are two methods to use an Excel Add-In application. The easier method is as simple as just double click the file.


Method 1: Double click the file


You use the add-in file just like a portable software application. Just double click the Excel add-in and Excel will start with the extra functionality provided by the Excel add-in.

Just double click the xlam file and its functionality will be available for use.


To explain further:
  • When you double click the downloaded add-in file to start an Excel session Excel will start without a workbook opened.
  • You can start a new blank workbook or open an existing workbook to start working with the extra commands and functions provided by the add-in. You can work with multiple workbooks and save your workbooks as usual.
  • The add-in does not change your Excel Settings. It commands and functions work only during current session.
  • This session will end once you close all Excel workbooks. The functionality in the add-in will cease.
In your next Excel session, the add-in will not start until you double click on the add-in file again.



Method 2: Install before use


You can choose to start the Excel add-in automatically every time you start Excel. Remember, you don't need this method if you don't need the Excel add-in to start automatically every time you start Excel.

You need to perform two tasks to setup the Excel add-in:
  1. To locate and add (install) the add-in file to Add-Ins dialog box list (by manual or installation)
  2. To activate the add-in by marking the check box
Then, the activated add-in will start whenever the Excel starts.


Step 1: To locate and add (install) the add-in file to Add-Ins dialog box

Step 1.1 First we need to open the Add-Ins dialog box:
  • For Excel 2010 and 2013: Click File Tab and Excel will display the backstage > Select Options at the left panel and Excel Options dialog box will open > Select Add-Ins at the left panel > Look at the bottom of the dialog box. Select Excel Add-ins from the Manage's drop down list and click Go > The Add-Ins dialog box will open
  • For Excel 2007: Click the Office Button at the top left corner of Excel program > Select Options at the left panel and Excel Options dialog box will open > Select Add-Ins at the left panel of Excel Options dialog box > Look at the bottom of the dialog box. Select Excel Add-ins from the Manage's drop down list and click Go > The Add-Ins dialog box will open
Open the Add-Ins dialog box in Excel 2013 and 2010.


Step 1.2, again there are two methods to list/ install an add-in to the Add-Ins dialog box.

Method (A)

In the Add-Ins dialog box, click the Browse button to open the Browse dialog box. Then browse and locate the Excel add-in. Double click the add-in you want to "install". This Excel add-in will be listed in the Add-Ins dialog box and marked as activated. Watch the image below.

Open the Browse dialog box and locate the add-in file. Double click the add-in file to list and activate it in Add-Ins dialog box.

To remove the add-in from the Add-Ins dialog box's list is easy. Just deactivate the Excel add-in and delete it from its existing location. Excel will detect the deletion and ask your permission to remove it from the list. (Window will prevent the deletion when the add-in is activated (in use)) Watch the image below.

Delete an add-in from the Add-Ins dialog box.


Method (B)

In the Add-Ins dialog box, click the Browse button to open the Browse dialog box. The default folder in the Browse dialog box is the default Add-Ins library. Just copy or move the Excel add-in to the folder and double click the Excel add-in. This Excel add-in will be listed in the Add-Ins dialog box and marked as activated. Watch the image below.

Add the Excel add-in to Add-Ins dialog box and library.



To remove the add-in from the Add-Ins dialog box's list (and the Add-Ins library folder) is easy. Just deactivate and delete the add-in from its existing location. Excel will detect the deletion and ask your permission to remove it from the list.

Delete the Add-Ins from the Add-Ins dialog box and library.



Step 2: To activate the installed Excel add-in by marking the check box

The image below shows Add-Ins Dialog Box and how to activate and deactivate installed add-ins.

To deactivate an add-in and activate another add-in.

The animated image above show how you deactivate an add-in and activate another add-in using Add-Ins dialog box. The problem to most people is that the steps to open the Add-Ins dialog box are cumbersome. Read the notes below to add quick access to Add-Ins dialog box.

Conclusion

  • Using an add-in with extra functionality just simple, just double click the add-in file (.xlam) to start
  • You don't have to use Method 2 if you don't need the add-in to start automatically every time you start Excel.

--------------------------------------------------------------------------------------------

Notes: More about Add-Ins Dialog Box

It takes many steps into obscure interfaces to open Add-Ins dialog box. Here are 2 methods to add shortcut to open Add-Ins dialog box on Excel 2013.

Method 1: Add a quick access icon to open Add-Ins dialog box

Setup quick access icon to open Add-Ins dialog box.

Method 2: Add a Developer Tab

Just add a Developer Tab to the Ribbon. The Developer Tab has a button to open Add-Ins dialog box quickly.

Adding Developer Tab.



Wednesday, 14 May 2014

Bulk URLs Builder

Google URL Builder is an online tool to help online marketers to tag Google Analytics tracking parameter values (query string) on URL. These parameter values enable Google Analytics to track website traffic. When you use Google URL Builder you can only tag one URL at a time.

We developed Links Editor's URLs Builder, a tiny Excel Add-In, to tag URLs in bulk quickly. It is an Excel Add In file (.xlam) that you can download to use without charge. The file size is less than 80KB. We illustrate 3 main features here, watch below:




(A) Tag URLs


It is easy to use. Just select the cells with URLs that you want to tag, write the parameter values and click "Tag" button. ALL the selected URLs will be tagged.

Tag URLs in bulk. 

This Add-In also allows you to choose whether you want to encode the special characters in URLs, i.e. space, brackets, etc.


(B) Remove


You can remove the parameter values in a click too.



(C) Formulas


You can use formulas of this Add-In to extract URL parts, i.e. path and file, web address, hostname (subdomain plus domain name), etc.


Using formulas to extract URL parts. Read help page to find out more formulas available.


DOWNLOAD 



It is easy to use. Just double click the xlam file and the functionality will be added to your Excel during the entire current session (until you close all Excel Workbook).

A list of URL Builder Tools available on Internet


#urlsbuilder
#googleanalytics
#analytics