AdWord Excelizer .com

Uploading to Google, Yahoo and MSN

There are easier ways to maintain all PPC campaigns in various search engine, i.e. Google Adwords, Yahoo Search Marketing (YSM) and Microsoft adcenter (Msad).

For one, we must make sure campaign names and adgroup names across the search engines are the same. With this, subsequent updates of new keywords into existing campaigns and adgroups can be easier.

I usually work on Adwords first. Then upload the campaigns and adgroups to YSM and Msad.

I update my Adwords campaign through Adwords Editor. The “Make multiple changes” function allow the user to copy and paste the excel files data to Adwords Editor quickly.

For YSM, the fastest way is to export from Google Adwords Editor, then upload through the import campaign functions. Details of the process is illustrated in YSM’s help.

For Msad, the fastest way is to use the same excel files I upload to Adwords Editor. I just need to change the header. The same excel files can be uploaded to Msad. You can read the details explanation in Msad’s help.

The above are mere general steps of how I can maintain consistency, with efficiency, of campaigns and adgroups across the PPC search engines.

June 15th 2010 Posted to Adwords Blog, Keywords processing, Adwords tips

Comments(1)

How to create keyword variations quickly?

You can use JOCE to create numerous variations for the entire keywords of your AdGroup quickly. Yes, in one click. You can add converting keywords like “buy”, “cheap”, etc. You can add variations like adding hyphen, eliminating space between words, etc. You can ride on users’ strange habit of adding “com”, “www.keyword.com”, etc. If you want to replace space between words with hyphen or plus sign, just click on the relevant button. The keywords in the entire AdGroup will be updated. Also wrapped, etc.
A list of standard variations avaiable in JOCE

Click to see a bigger picture.

Click on grey buttons to create the variations you desire for your whole AdGroup.

How to add ANY words into current keyword phrases of your entire AdGroup?

Step 1: Key in the word(s) that you want to add in cell I27, which is denoted as *(1) as indicated at the left side of the cell.
Step 2: Click on the grey button or select the dropdown list as per the image above, depends on where you want to add the word(s) in the current keywords.
Work on the original list, make variations out of previous variations.

Create your own variations of keywords
You can key in any keywords into the cells denoted with *(1), then choose relevant button to place the keywords into specific location of keywords phrases. You can replace certain keywords by key in to *(1) and *(2), and click on “Replace *(1) with *(2)” button.

Change on change OR change on the original keywords

When you are creating new variations you can always decide whether you want to
a. make variation on the original list of keywords, or
b. make variations on the preceding changed keywords.

change on original. Right click to view image

For instance, after adding “buy” on the original list of keywords you may want to add “bargain” on the original list of keywords without the words “buy”. For such change, make sure you put a tick at the above checkbox. Another example, after you replace spaces between keywords with “hyphen”, you may want to add “.com” on this “hyphened” words. In such a case, do not tick on the checkbox.

Work on ONE word only, instead of the whole column

If you want to change one selected word out of the entire column, remember to untick the “Entire column” checkbox (see image above). Subsequently you can create variations and change on highlighted keywords.

May 03rd 2006 Posted to Adwords Blog, Keywords processing

Comments(2)

Keywords Grouping Wizard

AE Grouping Wizard is our solution to simplify the daunting task of grouping long list of keywords into multiple AdGroup. It doesn’t require any sign up. You can just download it here.

It works like this.
Step 1: Select keywords
Step 2: Click “New AdGroup” button. Done.

The selected keywords are removed from the original list and are moved to a new AdGroup. The original list is sorted as well. It is an extremely quick way to sort out your keywords grouping when you obtain raw lists of keywords from various sources, i.e. keywords tools, web keywords suggestion tools, etc.

It also comes with a demo inside the Excel template to show how it works.

Here is the graphical illustration.

Step1:

Select keywords and click new adgroup button. Right click to view image.

Done! As below.

sorted and grouped keywords. Right click to view image.

Download Adword Excelizer Grouping Wizard.

March 28th 2006 Posted to Adwords Blog, Keywords processing

Comments(4)

Quick Start Guide for AE - Grouping keywords

This is the quickest way to group your newly acquired keywords into various AdGroups.

Step1:

As illustrate in the image below:

1. Click on “Selection to NewAG” button.
2. A dialog box will prompt you to specify range. Select the keywords within the column with click and drag. For non adjecent cells, press [ctrl] button and click.
3. Click the “OK” button of the dialog box.

Select to new adgroup. Right click to view image.

Step2:

A new AdGroup is created as the image below. Done.

new adgroup created. Right click to view image.

March 24th 2006 Posted to Adwords Blog, Keywords processing

Comments(1)

Quick Start Guide for AE - Wrapping keywords

To wrap keywords with the match of your choice:

First, choose match or combination of matches you want. In the image below we click on “Broad & phrase” match button. The entire column of AdGroup 5 (words on finger picking) will be wrapped with broad and phrase match and copied for pasting. The next step is just to press [ctrl-tab] to switch to Google Adwords for pasting.

Choose the wrapping type. Right click to view image.

In Google Adwords’ Add Keywords or Edit Keywords text box, just press [ctrl]-v. All the copied keywords will be pasted as board match and phrase match into the text box. Just click the “save” button and it is done.

ctrl v to paste keywords to adwords text box. Right click to view image.

March 21st 2006 Posted to Adwords Blog, Keywords processing

Comments(1)

Quick Start Guide for AE

This is the quick start step-by-step guide for AE. It shows you the fastest way to get your keywords grouped, processed and wrapped for your Adwords campaign using AE.

Step1:
Copy keywords from Google Adwords Keyword Tool. After highlighting the keywords, you can either right click to trigger the menu and click “Copy” or simply press [ctrl-c]

Copy keywords from Adwords keyword tool. Right click to view image.

Step2:
Switch to AE beta by pressing Alt-Tab key. Press the “Paste New KWs” button as indicated in the picture. The copied keywords will be pasted at the New Keywords column.

Press the paste new kws button. Right click to see image.

Step 3:
1. Click on “Move keywords” button. A dialog box will appear and ask you to specify range.
2. Select the cells containing keywords that you want (to create a new adgroup) by click and drag.
3. Select non adjacent cells by pressing [ctrl] and click on those cells.
4. Press the “ok” button in the dialog box.

Select keywords and move. Right click to view image.

Step 4:
A new dialog box will appear requesting you to specify the 1st cell of destination range for your selected keywords. You will choose a cell and press “ok” button of the dialog box.

Select destination. Right click to view image

Finally, keywords moved as per image below. DONE.
Keywords moved. Right click to view image.

Come to think of it…here is the quickest way to use AE to sort and group your keywords into various AdGroup.

More on…
1. One click keywords wrapping
2. Elimination of duplicating keywords of various AdGroup in a campaign.

March 18th 2006 Posted to Adwords Blog, Keywords processing

Comments Off

Keyword wrapper?

Just-One-Click-Experience (”JOCE”) is more than mere keywords wrapper. It wraps, dedupes, creates variations…in one click. It comes with ad drafter, a simple tool to draft ads quickly and easily.

Check this out, JOCE, the ultimate keywords wrapper, deduper and variations creator.

March 15th 2006 Posted to Adwords Blog, Keywords processing

Comments(0)

Quick Start Guide for JOCE - Variations

To create a variation like adding “www.” and “.com” in front and at the back of the key phrases of your entire Ad Group’s keywords, just click on the radio button [Add “www.” & “.com”].

Image: click on the radio button to add www & com

The click creates variations, and the variants (keywords) are then
1. de-duped
2. wrapped, and
3. copied for pasting into Adwords

The next step, again, is simply switch to Adwords and press [ctrl-v] to paste the keywords into the Add/ Edit Keywords’s textbox.

January 08th 2006 Posted to Keywords processing

Comments(1)

Quick Start Guide for JOCE

This is the quick start step-by-step guide for JOCE. It shows you the faster way to get your keywords processed for Adwords using JOCE.

Step 1:
Copy keywords from Google Adwords Keyword Tool. After highlighting the keywords, you can either right click to trigger the menu and click “Copy” or simply press [ctrl-c]

Image Step1: Google Adwords Keyword Tool

Step 2:
Switch to JOCE by pressing Alt-Tab key.

Image Adwords keyword processing before paste