Thursday, August 13, 2009

Create New High Quality Display Ads with Display Ad Builder

Creating display ads that look truly professional is hard work. Last year, we launched Display Ad Builder to help you easily design display ad campaigns. Since then, we've provided advertisers in over 40 countries with more than 90 templates to streamline the design process.

Today, we have introduced a new set of "Elegant" ad templates in the "General" category of Display Ad Builder that make it even easier to create high quality display ads. These templates have ready-made buttons and backgrounds that give each ad a cohesive look and feel. More specifically, the backgrounds use subtle gradients and the new buttons have unique shapes, icons and color treatments. The goal of these ads is to make it as easy as possible to create high-quality ads in a matter of seconds without having to use complex graphics software. Here are a few examples:


With some of these new templates, all you have to do is upload your product image and write some text to get a professional looking display ad out in no time.

To start creating your ads, click Display Ad Builder on the Create an ad page within a new or existing campaign in your AdWords account. If you want to learn more about creating and running display ads, visit the Display Ads 101 tutorial.

Wednesday, August 12, 2009

Analytics Data In Excel Through Our API

Many of our clients use Excel to manage their ad campaigns, visualize marketing performance, and perform complex data analysis. Most analysts use the Google Analytics Export feature to manually export their report data to CSV files. Then they import the CSV file into Excel. No longer! Now, with the Google Analytics API you can bypass this manual step and export Google Analytics data directly from within Excel! Once you've set it up, there's no need to visit the Analytics reports to view data in Excel.

Thanks to a variety of developers, here are four solutions that can transform you from a reporting monkey to an analysis ninja (as Avinash would say).
  • VBA Macros - The simplest solution of them all. Mikael Thuneberg's page explains how to make API requests directly from Excel using VBA Scripts and includes a pre-built Excel worksheet to get you started.

  • The Tatvic Excel Plugin - Another easy-to-use plugin for Windows users that supports both Excel 2003 and Excel 2007. To get started you download the plugin then register to use the tool. Its simple UI helps you build complex queries and get data from Analytics right into your Excel worksheet.

    Tatvic's Plugin Query Builder

  • Excellent Analytics - Is an open-source initiative by Mark Red and Dropit. This Excel 2007 plugin works on Vista/XP and comes with a query builder to help you create Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this plugin.

    Excellent Analytic's Query Builder Interface

  • ShufflePoint - Works somewhat differently than the solutions above. ShufflePoint has developed a query language that works with the Google Analytics API to achieve common tasks, such as defining the last 30 days as a date range. One then uses this language to construct an Analytics Data Export API query either by navigating to a URL within Excel, or by using their web-based query builder, then importing this data into Excel. This process allows the ShufflePoint solution to work across most versions of Excel, as well as Powerpoint, and iGoogle gadgets.

    Shufflepoint's Web Based Query Builder
We continue to be impressed by the new solutions developers are bringing to market by leveraging the Google Analytics Platform. If you have developed a useful new tool or integration on top of Google Analytics, drop us an email at analytics-api@google.com. If it's innovative and useful we'll highlight it to our readers on this blog.


Monday, August 10, 2009

Back to Basics: Direct, referral or organic - definitions straight from the source

In your Analytics reports, you'll see some of the same entries come up again and again in your data tables. In the last Back to Basics post, we learned about 'not set' entries -- this week we'll learn what it means when you see 'direct,' 'referral' and 'organic' under the Sources column in your reports.

  • (direct)[(none)] - Visitors who visited the site by typing the URL directly into their browser. 'Direct' can also refer to the visitors who clicked on the links from their bookmarks/favorites, untagged links within emails, or links from documents that don't include tracking variables (such as PDFs or Word documents).

  • [referral] - Visitors referred by links on other websites. (Links that have been tagged with campaign variables won't show up as [referral] unless they happen to have been tagged with utm_medium=referral. )

  • [organic] - Visitors referred by an unpaid search engine listing, e.g. a Google.com search.

Once you learn where the traffic to your site is coming from, you can start analyzing the information to make intelligent decisions for your website. For example, the Referring Sites report shows you which websites have been most effective at driving people to your site -- and which ones haven't been effective. Furthermore, if you have defined as goals the key pages you want visitors to see, you can see the percentage of visits from each referral during which the visitor saw these pages. (Just click Goals tab to see your conversion rates for each goal.)

To learn more about how to spot quality traffic from your Goals tab, please refer to this earlier Back to Basics post.

Friday, August 7, 2009

Join us at SES San Jose next week

Next week is the Search Engine Strategies San Jose conference, and Google will be there. If you're coming to the conference, we'd love to meet you. Googlers will be speaking in a number of sessions on topics ranging from website architecture to quality score. Also, Nick Fox, Business Product Management Director for Google AdWords, will be giving Wednesday's keynote.

Tuesday, August 11th, 2009
  • Duplicate Content - Greg Grothaus - 9am-10:15am
  • The Next Wave for Online Video - Erin Bouchier - 11:45am-12:45pm
  • Successful Site Architecture - Johannes Henkel - 11:45am-12:45pm
  • How to Turn Your Web Analytics into a Money Making Machine - Avinash Kaushik- 1:45pm - 2:45pm
  • Keeping it Local - Josh Siegel - 4:30pm-5:30pm
Wednesday, August 12th, 2009
  • Convert Your Visitors to Customers - Nitin Mangtani - 10:45am - 12:00pm
  • Conference Keynote - Nick Fox - 1:00pm - 2:00pm
  • Google AdWords, Analytics & Website Optimizer Secrets Revealed + Google Science Fair - 2:30pm - 3:45pm
  • Real World Multivariate Testing - Trevor Claiborne - 4:00pm - 5:15pm
Thursday, August 13th, 2009
  • Extreme Site Makeover - Tiffany Lane - 10:30am - 11:45am
  • Quality Score - Jonathan Alferness - 10:30am - 11:45am
  • Images & Search Engines - RJ Pittman - 2:15pm - 3:30pm
  • Search Becomes the Display OS - Rajas Moonka - 3:45pm - 5:00pm
We're looking forward to meeting you next week.

Posted by Dan Friedman, Inside AdWords crew

SES San Jose Next Week!

The Search Engine Strategies San Jose conference is next week! This conference has become probably the most well-attended conference for anything related to doing business on the web. You'll see everything - booths representing cutting edge, fledgling technologies as well as the traditional online companies - and everyone, from experts in almost every facet of the web, to analysts, media and bloggers, to ad execs.

There's a ton of great sessions to attend and networking to be done, and a bunch of Googlers will be there including many of us on the Google Analytics team. We'll also have a booth where we will be demoing and answering your questions, along with Google Website Optimizer, AdWords, AdSense, Webmaster Tools, YouTube, and Doubleclick. You can register now and save 20% with the code SJ20SES.

Here are some sessions that might be of interest for you, oh ye of the analytical leanings:

Monday, August 10th, 2009
All day Web Analytics Association Base Camp - training on ways to optimize your website and what tools to use.

Tuesday, August 11th, 2009
10:00-11:30 - Always Be Testing - Bryan Eisenberg
11:45-12:45 - Creating a Web Analytics Culture - Feras Alhlou
1:45-2:45 - How to Turn Your Web Analytics into a Money Making Machine - Avinash Kaushik, Bryan Eisenberg, Jim Sterne
3:00 - 4:00 - Meaningful SEO Metrics: Going Beyond the Numbers
4:30-5:30 - Extreme Makeover: Conversion Edition - Bryan Eisenberg

Wednesday, August 12th, 2009
10:45am - 12:00pm - Convert Your Visitors to Customers (Google Site Search) - Nitin Mangtani
10:45-12:00 - Landing Page Testing & Tuning - Tim Ash
1:00pm - 2:00pm - Conference Keynote - Nick Fox, Google
2:30pm - 3:45pm - Google AdWords, Analytics & Website Optimizer Secrets Revealed + Google Science Fair
4:00pm - 5:15pm - Real World Multivariate Testing - Trevor Claiborne from Google Website Optimizer, Jim McDonald, Ayat Shukairy, David Sprinkle

Thursday, August 13
10:30-11:45 - Advanced Paid Search Techniques
2:15-3:30 - Extreme Makeover: Live Landing Page Clinic - Tim Ash


We hope to see you there!


Making Sense of it all...

Not sure if you have heard of Andrew J. Hall...but he has become a symbol for all bankers. He is the head of a company called Phibro, a small commodities trading firm in Westport, Connecticut.

The deal is that Phibro is a subsidiary of Citigroup. They trade energy commodities and have made a ton of money....almost $2 BILLION in net revenue in the past 5 years. That equates to about 20% of Citigroup's net revenue...think about that. One guy and his team of 54 employees have made 20% or more of Citigroups operating profit!!

Impressive....

Perhaps more impressive, or scary, depending on your viewpoint, is the $100 million bonus he is about to receive....the 2nd $100+ million bonus he has received in the past 3 years.

Earned? No doubt. Citgroup obligated to pay? Yes, it is in his contract. Out of sight bonus? You bet! I will offer no other commentary...other than to say you know what I could do with $100 million???? (maybe buy a German castle with 150 rooms like Andrew Hall did!)

This gives us all cause to pause....certainly our community banks and CUs are not paying such bonuses to the degree of Citi, but we will all be, again, grouped into one pot. All taking a hit on our reputation and trust factors.

Today, we are hosting a Reputation Management eCollege session....this is EXACTLY why you have to proactively manage your own reputation. Because if you do not, someone else will!

I encourage you to proactively think about your brand and your reputation...there has never been a more important time!

With the strategic planning "season" coming upon us...you need to add this to your agenda!

Cheers...

Bruce Clapp

PS: Remember, we can help make 2010 the "Best Year Yet" with our proven strategic planning process!! Give us a call or email...

Here is the article on Andrew Hall

Thursday, August 6, 2009

New Interface Thursdays: Keep tabs on your account with custom alerts

The new interface helps you focus on the data you care about with tools like filters and customizable columns. But wouldn't it be great if, instead of having to search for important changes in your metrics, you could be notified when a change you care about occurs?

That's why we've released a new feature called custom alerts. Custom alerts help you stay on top of your account's performance by notifying you whenever important changes occur in your account.

For example, what if you wanted to know when there was a spike in impressions for any of your branded keywords? Simply navigate to your branded keywords ad group, and in the Keywords tab, click More actions, then Create a custom alert.


Here, we've defined an alert to notify us when impressions for the brand terms ad group have increased more than 20% over the previous day:

As another example, you might want to be notified when a campaign is coming close to hitting its budget. To set up this alert, you'll first navigate to All online campaigns. Under More actions, select Create a custom alert. You can set up a ">90% of daily budget spent" alert for a selected campaign, or for every campaign in your account.


Getting alerts
Once you've set up an alert, AdWords will be on the lookout for changes. After an alert is triggered, you'll see it in the Messages section at the top of your account.
If you set up email notification, you don't even need to log in, you'll be emailed when the important change occurs.

Clicking the plus-box shows the full alert:

You can then dismiss the alert from your messages, or click View to see the parts of your account that triggered the notification.

Managing your custom alerts
To look at the alerts you've already set up, select Manage custom alerts under the More actions menu. You can see all the alerts you've set up for your account by first navigating to the Campaigns tab in All online campaigns.

When managing your alerts you can make a number of changes, like pausing or deleting an alert. You can also modify an alert's settings using in-line editing. Lastly, you can turn email notification on or off for a particular alert.

Custom alerts are one of our favorite features in the new AdWords interface, and we're excited about all the different ways you can use them. So the next time you want to keep a close eye on your account, remember that AdWords can stay alert for you.

Meet the new AdWords interface team
There are two upcoming chances to meet the new interface team. Next week, we'll be at the Search Engine Strategies San Jose conference. Join us for our session Google AdWords, Analytics & Website Optimizer: Secrets Revealed! on August 12th at 2:30 PM. After the session, we'll be holding a "science fair" where you can meet many of the AdWords engineers.

We also have one more webinar on August 20th at 9:30 AM PDT. You can register for the free webinar on the new interface webinars site.