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