Archive for the 'Google' Category

If you’re conducting a PPC campaign that is internationally geo-targeted to specific countries, then this post is for you. Especially, if you are unfamiliar with their native language.

Let’s take a PPC campaign geo-targeting Germany. Obviously you’d want to build a keyword list in German, and run it on Google.de.

First, I tried using Wordtracker and Keyword Discovery. They don’t work for building a foreign language keyword list. I generated the top 1000 search terms related to the word, “music“. The german word for music is, musik. It wasn’t listed at all. As a matter of fact, no foreign language was on the list. Just try generating a German language keywords. Or, try japanese. It’s just not happening with Keyword Discovery or Wordtracker.

Which led me to use the German Google Keyword Tool (Notice the .de extension on the url). My Google team told me within the Google Keyword Tool in Adwords, the default is United States only. “If you use the geo-targeting settings, you will be able to pull keyword data for the countries that are available. If you’d like additional ideas to the keywords that you’ve inputted, this can be done by clicking on the “Use Synonyms” option.”.

However, the Google Keyword Tool doesn’t seem to work.
I went to German Google Keyword Tool and logged in with my adwords login. Type in “music”, and “Use Synonyms” option. Surprisingly, there isn’t one german language word on the list! Google will not translate the words that are generated!

So, here’s 3 methods to generate a foreign language international keyword list.

Method #1:
You can use Google’s Keyword Tool to generate foreign language keyword lists by entering a website URL into the Keyword Tool to crawl for similar words. As a test, I used http://www.musik-service.de.

Although I have to admit, I can’t speak German, so I don’t know which of those keywords I want to bid on. Even though I can’t speak German, I’m lucky that my co-worker Carmen speaks German fluently. And, besides speaking German she is my queen of Google Analytics.

Within the tool, you can see how Google automatically groups the terms into adgroups for you. I inputted this URL into the Google Tool: http://www.realbeatz.de

Method #2:
Quantcast for “Similar sites”, then use Spyfu to mine the keywords.

Method #3:
Generate your keyword list in English, then use Yahoo Babelfish to translate all the terms.

Bottomline:
I have not been able to find a Keyword Volume Tool, similar to Wordtracker for foreign language countries. But following the above methods, you should get off to a good start.

Even after you’ve built your foreign language keyword list, unless you speak the language you won’t know how to group them into adgroups. At that point, you should make a connection with somebody who speaks the foreign language fluently.

Below is some “Google Internal” data. About a year and a half ago, I asked one of my Google reps if she had Average CTR’s by Industry for Google Only. I was going thru some old files, and I found this ppt slide. It doesn’t tell me what companies were used in the accessment, and whether or not the PPC Keywords were more brand-related than generic keywords. Obviously, brand-related keywords would skew the results with higher CTR’s.

In a previous post, I discussed Methods To Increase CTR on PPC Ads. For example, things like position, keywords, ad copy, dynamic keyword insertion, etc. have an impact on CTR.

Campaign objectives make a difference. It depends on each advertiser’s campaign objectives. If they are Conversion-Oriented, then their Clickthrough Rates are most likely lower. Because, those are the advertisers that can have their ad in Position #7 and that’s their sweet spot for conversion rates.

As opposed to the Brand-Oriented campaign. In which case, findability is crucial to their campaign success. That means a Position-based success metric. Hence, higher CTR’s. Some of these brand campaigns use CTR as an Analytic Metric, so their is a heavy emphasis on optimizing CTR.

I was told that these are from large comprehensive PPC campaigns from industry leaders. I don’t think this can really be used as representative data for the Avg CTR for each of these industries. But, it’s interesting data anyway.

Here’s a short post that’s meant to help you save time, and increase productivity.

For those of you that manage a Google MCC, there’s no need to click into every single account to generate a monthly invoice. Depending on the amount of accounts you manage, this exercise could take quite a long time.

So, here’s an easier method to grab all of your monthly invoices, broken out by specific accounts.

1) Log into your Google MCC Account.
2) Click on “My Account” tab.
3) Use dropdown to select Date Range.
4) The Billing Summary will appear on the next screen sorted by Month/year.

On that screen you are given several hyperlinks from which you can grab information. The choices are consolidated (.pdf) | spreadsheet | account-level (.zip) .

I prefer to use the account-level (.zip) which contains every invoice by account for that month.

That’s it. Hopefully, this post has saved you time and energy.

Related Posts:
Google MDS - Manager Defined Spend.
How to Upload an Adwords Bulksheet.

I just received my Google Holiday gift for 2007. It’s a Google branded Flip Video Camera. So, instead of taking a picture and displaying a photo image, I decided to take a video of the Flip Video Camera with another Flip Video Camera. This way you can see the level of quality of the video.

As of the writing of this post, Youtube hasn’t fully processed the Google Holiday Gift video, so there isn’t a “Video Still” yet. But, the video works regardless.