I really absolutely had to blog about this one.  My computer crashed and I needed to move my accounts from Adwords Editor to my new computer.   Unfortunately, I have Gigs of Adwords Editor data and some of which were old and I had forgotten the password.  So I didn’t have the time, patience, nor capability to bring them all over.  I contacted Google support on multiple occassions and they told me it wasn’t possible.  No bear with me while I say I was absolutely shocked that someone at Google was wrong about their own product yet having told me that they were 100% positive! (you can decide whether or not I’m being sarcastic) 

Please excuse me while I try to refer to this issue in as many ways as possible.  I couldn’t find this solution online and I looked for hours.  Hopefully the next person will find my blog if they have to import their Google Adwords Editor to their new computer, if  he/she has to migrate Google Adwords Editor from one computer to another computer, or he/she is wants to know how to migrate ape.db files from one version of Adwords Editor to a different computer.

Alright, I think I covered the bases.

Some things you need to know:

1.  When you download accounts in adwords editor, each account appears as ape_[xxxxx].db within a folder on your computer.

2.  Account downloads are not cross-compatible from one version of Adwords Editor to another; They are not cross-compatible in any direction: old files don’t work with newer versions of Adwords Editor and new files don’t work with older versions of Adwords Editor.  I know it sounds ridiculous and hard to believe, but it’s true.   Sadly, we are going to have to leave cross-compatibility to Microsoft.  Go figure!

 

Soooo, how is it done?  Let’s assume that you are moving the data from one computer to another…

1.  Make sure the new computer has the same version of Adwords Editor as the old one did.  You need to make sure you have installed *exactly* the same version [Note: I prefer the versions pre-2009 by FAR.  They have significantly better functionality. We will leave that to a later post].  If you don’t install the same version it won’t work and I will point you to an indicator. 

2.  Open Adwords Editor and download an account, any account.  This will help you spot whether you do the following steps correctly.

3.  Close Adwords Editor!

4.  Go to C:/users/UserName/AppData/Local/Google/Adwords-Editor/Profiles on the old machine. That may not be the exact path for your version, but you should be able to spot a path that looks very similar.   If you still can’t find it, do a search of your machine for the file ape.db;  this file is located within the Profiles folder.

5.  Find the same Profiles folder on your new machine.  Because you downloaded 1 account, you will find the ape.db file which essentially is a pointer to each of the account files.  You will also see 1 account file (because of Step 2) and that account will be labeled ape_[xxxxx].db .  Replace the contents of the new Profiles folder with the contents of the old Profiles folder.

6. Open up your new Adwords Editor.  If you can open up the individual accounts, then it worked!  If the individual accounts are labeled “Not Downloaded”, you only made 1 mistake: You installed the wrong version of Adwords Editor!  

7.  If it failed, uninstall Adwords Editor and install a different version.  You can skip steps 2-5 because uninstalling will not delete the Profiles folder nor even delete the Adwords-Editor folder within the local user. 

 

That’s it!  Don’t hesitate to contact me if you have any questions.

As promised, I am adding my first “black hat” trick to my blog.  Admittedly, I hate using the phrase “black hat”, “white hat”… or even “gray hat” for anything that is not used to cover my head.  I think the phrases are a little silly, but I digress…

 

So, Google doesn’t allow ALL CAPS anything within their search results.  In other words, Google will not approve an ad written as such:

FIVE MILL ALL CAPS TITLE

Black Hat Trick #1 by Five Mill Inc

Here is a FIVE MILL ALL CAPS TITLE!

www.FiveMill.com

 

… but there is a work around.

Dynamic Keyword Insertion

 
Dynamic Keyword Insertion (DKI) is typically used when someone has a lot of keywords and wants to alter the ad’s appearance accordingly.  As a result, advertisers will utilize DKI in order to save the effort of creating a new adgroup for each keyword. 
I typically don’t use DKI, because I try to keep my adgroups so granular such that the ad is already perfect for all of the keywords.  This Black Hat example is really a large majority of my use of DKI.

One very important thing to note is, it doesn’t matter what the user has searched, per se, rather what keyword was bid on that caused the ad to display.  For instance, if the keyword is “Search Marketing” (phrase match) and someone searches with the query Five Mill Search Marketing, then the phrase that is dynamically inserted is Search Marketing, NOT Five Mill Search Marketing.

There are multiple ways you can utilize DKI.  You can use:
 
 
{keyword: }
DKI Ad:
   {keyword:Five Mill Inc}
   Black Hat Trick #1 by Five Mill Inc
   Here is a {keyword:DKI Ad}!
keyword: “poor ad”
Resulting Ad:
   poor ad
   Black Hat Trick #1 by Five Mill Inc
   Here is a poor ad!
 
 
{Keyword: }
DKI Ad:
   {Keyword:Five Mill Inc}
   Black Hat Trick #1 by Five Mill Inc
   Here is {Keyword:DKI Ad}!
keyword: “poor use of caps”
Resulting Ad:
   Poor use of caps
   Black Hat Trick #1 by Five Mill Inc
   Here is Poor use of caps!
 
 
{KeyWord: }
DKI Ad:
   {KeyWord:Five Mill Inc}
   Black Hat Trick #1 by Five Mill Inc
   Here is a {KeyWord:DKI Ad}!
keyword: “Good Ad”
Resulting Ad:
   Good Ad
   Black Hat Trick #1 by Five Mill Inc
   Here is a Good Ad!
 
 
{keyWord: }
DKI Ad:
   {keyWord:Five Mill Inc}
   Black Hat Trick #1 by Five Mill Inc
   Here is a {keyWord:DKI Ad}!
keyword: “poor caps Again”
Resulting Ad:
   poor caps Again
   Black Hat Trick #1 by Five Mill Inc
   Here is poor caps Again!
 
 
{KEYword: }
DKI Ad:
   {KEYword:Five Mill Inc}
   Black Hat Trick #1 by Five Mill Inc
   a {KEYword:DKI Ad} Agency!
keyword: “ca search marketing”
Resulting Ad:
   CA search marketing
   Black Hat Trick #1 by Five Mill Inc
   a CA search marketing Agency!
 
 
{keyWORD: }
DKI Ad:
   {keyWORD:Five Mill Inc}
   Black Hat Trick #1 by Five Mill Inc
   a {KeyWORD:DKI Ad} Agency!
keyword: “search marketing ca”
Resulting Ad:
   search marketing CA
   Black Hat Trick #1 by Five Mill Inc
   a Search Marketing CA Agency!
..
.
And any iteration of the above. 
 
 
But this is my favorite use:
 
 
{KEYWORD: }
DKI Ad:
   {KEYWORD:Five Mill Inc}
   Black Hat Trick #1 by Five Mill Inc
   Is {KEYWORD:Five Mill Inc} All Caps?
keyword: “Five Mill Inc”
Resulting Ad:
   FIVE MILL INC
   Black Hat Trick #1 by Five Mill Inc
   Is FIVE MILL INC All Caps?
This often works but sometimes Google just changes the DKI from “KEYWORD” to “KeyWord”.
If you want to see this in action, but don’t want to go through the effort, you can either search “five mill inc” on Google, or you can check out my screenshot.  I’m going to leave the ad live and let’s see how long it is until Google catches me! :-P
Five_Mill-All_Caps_Title

There are some really great things about Google’s ad display algorithm and there have been some VERY significant changes made recently.  Typically their changes with which keyword/ad combination is displayed are good… this time, not so much.

So, I’ve already discussed the Five Mill Tree Method, but it was a high level explanation.  In order to do the actual “slicing and dicing” of keyword traffic, you need to have the tools to make this possible.  Unfortunately, Yahoo doesn’t give you the tools to effectively and efficiently do so, but Google does.

Let’s first go through a couple quick basic rules of Google keyword matching…. and then I will explain how Google just recently made it better, then made it worse.

Match Type “Trumping”

Let’s say you are running:

- 2 Identical Ads

- 2 Different Match Types

- 2 Different Bids

We are dealing with 2 different Ad/Keyword/Match combinations.

#1

Keyword:  socks

Match Type: Broad

CPC: $3

#2

Keyword:  [socks]

Match Type: Exact

CPC: $1

Let’s now say that a user searches the query: [socks] (Exact match)

One might assume: The match type for combination #2 is the same, but the bid for #1 is the higher.  Due to the fact that both match types could address the query [socks], the corresponding bid/combination would be the higher bid; the higher bid broad match has cannibalized the traffic.  This assumption is entirely WRONG.   Google associates the keyword of closest match with the query. In other words, first Google notes that there are multiple keywords that are the same (but different match types) and matches the one with the most restrictive match type.  In this case, the keyword is [socks], and the bid corresponds to the lower bid because the match type is most restrictive.

Geo-Target “Trumping”

This time:

- 2 Identical Ads

- 2 Identical Match Types

- 2 Different Geo-targets

- 2 Different Bids

#1

Keyword: [socks]

Match Type: Exact

Geo-Target: USA

CPC: $3

#2

Keyword: [socks]

Match Type: Exact

Geo-Target: California

CPC: $1

User Query: [socks]

User Location: San Francisco, California

Similarly to Match Type “Trumping”, the query is mapped to combination #2 because the Geo-target is most restrictive, despite the lower bid.  No canibalization occurs (but it would cannibalize with Yahoo!).

There are a few caveats, but, for the most part, the above is correct.  Two major changes have been made, one for the better and one that is not.

Change #1: A Keyword Below Minimum Bid Threshold, is Still a Keyword

Previously, if your keyword was below the minimum bid threshold, it would not compete in the bid auction.  For example, let’s say that in combination #2 in the above examples, the bid was below the minimum bid requirement.  If this were the case, Google pretends that the keyword doesn’t exist and it would map to the higher bid despite the keyword of closer match.  This change NOW takes into account keywords that are below the minimum bid threshold.

This change is fantastic.  This gives us the opportunity to target keywords in as much granularity as we desire and bid based on our metrics of success.  We no longer have to worry about the effect of a keyword dropping below the bid threshold.

Change #2: Google Matches Keywords When it is Better “Quality”

So, everything I’ve said above blows up (although very marginally) based on this new caveat that Google adds to the equation.  The deal is that everything above is true, EXCEPT in the case when a keyword that is not a “closer match” has a lower max CPC and higher Bid x Quality Score (essentially Bid x CTR) value .

This is how Google says it:

On rare occasions, the system will prefer to use a keyword that is cheaper (i.e., it has a lower bid), has a higher Quality Score, and has a higher Ad Rank. Here’s an example:

Query: plumber tool
Keyword 1: plumber tools (maximum CPC bid = $0.10, Quality Score = 30, Ad Rank = 3.0)
Keyword 2: plumber tool (maximum CPC bid = $0.15, Quality Score = 4, Ad Rank = 0.6)

Ordinarily, Keyword 2 would be preferred because it matches the query more closely than Keyword 1. However, Keyword 1 is cheaper, has a higher a Quality Score, and has a higher Ad Rank. Therefore, the system will prefer showing Keyword 1 in this instance.

Keep in mind that Quality Score is calculated every time your keyword matches a search query — that is, every time your keyword has the potential to trigger an ad.

As a result the ability to be extra granular gets thrown off, because at anytime Google can match your less granular keywords with queries when it gives Google an opportunity to make more money. (You can word this sentence however you want, but it will mean the same thing.)  Google will argue that you are getting a chance to appear on a better performing keyword combination.

So, here is where Google entirely fails.

1.  When you take away an advertisers ability to be as granular as they want to be and when you make advertising less clear, the ability to advertise most effectively gets impaired.  The venn diagrams that you see in my previous posts are now better drawn with dashed lines because it is now impossible to be definitively granular.

2.  The person/people at Google that came up with this one may or may not have thought they were doing advertisers a favor, but the reality is that they have created extra revenue for Google in the short-term and that’s all.  Personally, I advertise with so much granularity and analyze keywords at the keyword level, that changes like this will only make my advertising less effective.  In fact, any advertiser that is scientifically managing their bids will be hurt by this change.  By making advertisers less effective, advertisers cannot optimize for metrics of success as scientifically as they were previously able to do.  Assuming that advertisers are advertising with financial efficiency (which is a gross assumption with many advertisers), the long-term effect, by definition, is a loss of revenue for Google, a devaluation of Google advertising, and a financially negative effect on its advertisers (until they realize that less money should be spent on Google).

Keep in mind, though, that this change is very negative, but it’s effect will be barely noticeable.  But, in “advertising equilibrium”, as I like to refer to it, it is bad for everyone.

In short, I challenge anyone to find an example where this change actually benefits advertisers…

Ps. Check out this link: http://adwords.google.com/support/aw/bin/answer.py?hl=en&answer=66292 to read more information about Google Keyword Matching

Pps. in light of this post, i’m adding a parent category and a sub-category: “Google”, “Fail”