Revealing geographic AdWords performance statistics using Google Analytics

If you’re running an AdWords campaign that serves multiple countries, you may want to see how each country is performing individually. I came across this again recently when discussing AdWords performance with one of my e-commerce clients. In his campaign, he is running ads in both the US and Canada. “How is Canada performing compared to the US?”, we wondered.

As far as I can tell, AdWords Report Center does not have a method for seeing data per country. Their demographics reporting is limited to age and gender. Here’s my method for revealing the data using Google Analytics. Your AdWords account must be properly linked to your Google Analytics account for this to work.

1. Log into your Analytics account and in the Dashboard, select Visitors > Map Overlay.

From your Google Analytics Dashboard, select Map Overlay.

2. On the Map Overlay screen, select the country of interest, in my case that was Canada. You can drill as deep as you like here.

Select your country of interest.

3. In the Dimension selection drop-down, choose Campaign.

Choose Campaign in the Dimension drop-down

4. Now, you can see the productivity of your Campaign(s) in the geographic region that you selected.

AdWords Campaigns revealed.

Now you want to know what to do with this new data? Well, I hope it convinces you to segment all of your countries into separate campaigns. For this client, Canada’s conversion rate is 68% lower than the site average. I’ll be splitting out Canada into a separate campaign as soon as I finish this post and redistributing my spend. I’ll also be talking with my client about updating his site to include Canadian shipping rates and landing pages for Canadian customers.

For a hot tip on how to make doubly sure that Google is only serving your US targeted campaign to US customers, see Uber Affilliate’s article, “QuickTip Time : Adwords International Traffic

UPDATE 09/03/2008: Looks like Google AdWords finally decided that

Creating a second FireFox profile for SEO

Note: A link to instructions for Mac users is at the bottom of this post -s

I started reading up on how to develop a FireFox Extension and one of the first recommendations is to create a separate FireFox profile. The second profile is recommended so you don’t have to clutter up your “regular” FireFox profile with a bunch of debuggers and development tools. And, both profiles can be run at the same time. This got me thinking about other uses for 2 profiles:

  • Having 2 profiles would allow you to be logged into 2 different Google accounts at the same time.
  • You could run keyphrase searches and view “personalized” vs generic SERPs.
  • Run one profile through a proxy service to see if your IP address is being served alternate content.
  • Compare different extensions, security settings. Manage an alternate set of bookmarks, etc.
  • Keep your “work” & “personal” browsing history separate.

Here’s the setup for Windows, using FireFox 2.x. I’ll try to add the Mac version shortly

  1. Make sure you close all FireFox windows. In FireFox, “File => Exit” should to the trick.
  2. Run the FireFox Profile Manager. Click on the Windows “Start” button, then choose “Run” Type firefox.exe -ProfileManager in the box next to “Open” and then click the “OK” button.

    Run the FireFox Profile Manager

  3. Create a new profile. Just click “Create,” give it the name seo & hit “Finish.”

    Create a seo FireFox profile

Now that the new profile is created, you need a way to run that profile along with your “default” profile. At this point, any of your usual methods of starting FireFox should bring up your “default” profile. I’m going to roll a couple tips into one here, so you’ll end up with a way to run your “seo” profile AND give it the shiny icon of your choice.

  1. Open Notepad: Start => Programs => Accessories => Notepad
  2. enter the following in Notepad:
    set MOZ_NO_REMOTE=1
    start "" "%ProgramFiles%\Mozilla Firefox\firefox.exe" -P seo
  3. Make sure that the text after -P in the second line is the same as the profile name you created.
  4. Save the file in your “My Documents” folder, and name it “firefoxSEO.bat”

Double-clicking the “firefoxSEO.bat” file will launch FireFox with your “seo” profile. So technically, we’re done and you can start running two FireFox profiles side-by-side right now. But as you can see, the default icon for .bat files is pretty ugly. And there’s no easy way to change it. The default icon can also be a problem later on, if you want to create even more profiles, and would like individual icons for each profile.

The solution is to create a shortcut to “firefoxSEO.bat,” and give it any icon you like!

  1. Right-click on “firefoxSEO.bat” and choose the “Create Shortcut” option.
  2. Move and/or copy the shortcut anywhere you like: your desktop, shortcut bar, QuickLaunch bar, etc.
  3. Now, right-click on the shortcut, and choose “Properties.”
  4. On the second tab “Shortcut” click the button labeled “Change Icon”

    Shortcut Properties & Change Icon button

  5. You may get a message like the following. Just click “OK”

    Icon Warning Message

  6. Now, pick an icon! Usually Windows will direct you to the file %SystemRoot%\system32\SHELL32.dll which has many icons to choose from. There are some additional (& quite retro) icons in %SystemRoot%\system32\moricons.dll
  7. You can also design your own icons with a graphics program, or there are several websites with icons & even some online icon creator sites.

You’re all set!

UPDATE: Here’s a link to Asa Dotzler’s blog where he covers how to create a shortcut to launch a specific firefox profile on mac. Pretty simple to do using Apple Script. -Sally (the Mac user of this team)

PubCon 2007 “Tools of the Trade” session

For all of you asking for notes from the SEO Tools presentation, here are the links to (most) of the tools mentioned:

Derek Vaugn, Techpad Agency

http://webceo.com/
Keyword rank checking; like WebPosition. Downloadable Windows software that runs in the background. Long lists (~200+ Keywords) can take several hours to run.
IndexTools: Last 100 Visits report
View the last 100 visitors in realtime. Helps identify trends in realtime & provides details of where the visitors are coming from.
http://spyfu.com/
Keyword Competitive Intelligence
http://google.com/trends
Useful for popular terms, may not have accurate data on lower volume terms. Can be used over time to add new terms.
https://adwords.google.com/select/KeywordToolExternal
Free keyword tool, works without an Adwords account. Has a "Site-Related Keywords" tab that shows related terms based on the content of an URL.

Todd Malicoat, Meta4creations, LLC

Server information:

http://ip-report.com/
Find “safe” IP blocks
http://www.seologs.com/ip-domains.html
Information on the number of sites for a given IP address

Competitive Information:

Backlinks:

Keyword Info:

Header & Page Level

Spidering

Project Management/Small Shop SEO

Many more tools

Jessie Stricchiola, Alchemist Media, Inc.

Links & Link Value

Cumbrowski’s Query & Link Stats Converter
Processes the raw data from Google Webmaster Central .CSV files
Joost de Valk’s Google Webmaster Tools External links tools
Provides additional information on sites linking to you: PageRank, rel=nofollow, “link not found,” image link, frame
dnScoop domain & site value tool
SEO Tools – Link Price Calculator

Project Management

Blackjack

Joe Laratro, Tandem Interactive

From the Q&A

Finally, I’ll have to admit I didn’t note some of the tools that "everyone knows about" already. While not a complete list, here are some tools in that category: