AdWord Excelizer .com

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:

Done! As below.

Download Adword Excelizer Grouping Wizard.

Comments(4)

When we activate Search Network at Campaign Setting, how do we know which search engines that our ads or creatives will display?

Search-this.com has a very interesting interactive chart, called Search Engine Decoder (Relationship Chart), to identify which search engines receive the Ads feed from Google and Yahoo (overture).

Go to the web site to check it out. First click on Google in the image and follow the yellow arrow to see how the paid ads are flowing.

You should able to find out the search engines included in Google’s search network are:
1. Lycos
2. AOL
3. Alexa
4. Netscape
5. AskJeeves
6. Teoma
7. Hotbot

You can also find out from the chart which search engines that your Overture’s ads appeared.

Comments(0)

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.

Step2:

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

Sign up to download free AE beta.

Comments(1)

This is one of the most interesting threads I read recently. It is from WebmasterWorld.com…Google Adwords rules of thumb. It was started by a new member and joined in by many Adwords experts.

Comments(0)

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.

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.

Comments(1)

Do you really think you know how to do a proper ads split test? You may be surprise to find out that you have been using a wrong method…

If you don’t know what split test is…
Split test is a process to test the effectiveness of two or more Ad copies or, in another term, creatives. It is usually measured in term of click through rate (CTR). When we do a split test, we want to find out which Ads are more effective in generating click.

Setting:

First step of split test is to tick off (in another words, stop running) Seach network and Content network. Leave only Google search in Campaign settings.

Generally, the CTRs of an Ad in Google search and Search network are quite different. Comparing CTRs of two Ads with one in Google search and another in Google+Network search are like comparing apple with orange. When we add a new ad, this ad will display instantly for Google Search but not Search Network. Google team will take a while to review the new ad before approving it to be displayed in Search Network. So if we compare the CTRs of an old ad (displayed in both Google Search & Search Network) with a new ad (displayed only in Google search), we will get a distorted picture of comparison.

We can wait until the new ad is displayed in Search Network to do the comparison, but we don’t know the exact date when the new ad started to be displayed in Search Network. So the logical method is to deactivate the old ad from displaying in Search Network for a fair comparison.

Second, you tick of Ad rotation and, therefore, NOT to show better ads more often.

More about split testing technique at Google Groups Adwords Help forum.

Unit of comparison:

CTR, instead of number of clicks, should be the comparison factor. But how many clicks should be sufficient for a fair comparinson of CTR? This is from the thread by jtara from the Google Groups Adwords Help forum.

30 clicks is a good rule of thumb. A more accurate way is to use statistical confidence. There’s a handy statistical confidence calculator for AdWords here;

http://splittester.com/

You enter the # of clicks and CTR for each of the two ads, and it will calculate a confidence level.

This is the explanation on splittester’s methodology.

Comparing CTR:

After a few days (it really depends on the click popularity of your ads and keywords.) we may start comparing your newly create ads and old ads. From the image below, we should choose a date after the new ads were created. We will have a fair comparison of the effectiveness of the ads.

Creation and variations of ads:

You may find more about creating variations of ads for split testing at the blog by Brad Geddes.

Comments(0)

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]

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.

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.

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.

Finally, keywords moved as per image below. DONE.

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.

Sign up to download free AE beta.

Comments Off

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.

Comments(0)