Advanced Marketing Tools: Google Consumer Surveys

Google's product updates come fast and furious, so it's easy to miss some interesting product developments. I've been guilty of this too. Today, I learned about Google Consumer Surveys. This product was first introduced in March of this year, but was under my radar until I received a promo code to run a survey.

How it works is simple: you design a survey and Google traffics the survey on its ad network. Users can complete your survey to unlock premium content on partner sites. The marketer gets fast survey results at a low price, the publisher gets a share of the revenue, and Google gets the rest. Win, win, win.

More info can be found here: http://www.google.com/insights/consumersurveys/home

Simple Step to improve SEM Performance

Here's an article I wrote outlining some easy wins to boost your SEM campaigns.

Enjoy!
Richard

http://blog.mixrank.com/cure-your-sem-blues-with-this-4-step-account-85202

Bing Sitelinks have arrived!

Is AdCenter finally rolling out Sitelink Extensions?

Below is a screenshot taken from the new Bing Ads Editor showing the export dialogue box. Apparently, they are laying the groundwork for Sitelink Extensions. This has been a long sought for additional to the AdCenter / Bing Ads platform and will likely have a positive impact on advertiser's campaign performance. Stay tuned....

SEM Account Audits

Often, when taking on a new client or new job, SEM marketers are faced with the daunting task of familiarizing themselves with a new account. To help ease this process, I’ve put together a framework for conducting SEM account audits. This is a deep dive into the accounts and is useful for both understanding the account and identifying new opportunities.

Account Structure

A good starting point with any new account is to examine the overall account structure. What are the themes for the various campaigns? Do the campaign names easy to understand? Are the campaigns organized in a logical structure (such as mirroring the structure of the website)?


Next, I like to pull a summary keyword performance report for the past twelve months. The columns I use are campaign, ad group, keyword, match type, keyword state, status, average position, quality score, impressions, clicks, cost, conversions, and revenue. You do not need any calculated metrics (such as CTR, CPC, etc.) because you will create these in your PivotTable. Once I have the raw data, I add my own columns for engine (Google vs. Bing), distribution (Search, Content, Mobile, Display, Remarketing), type (Brand vs. Non-Brand), impression weighted position (impressions x average position), and impression weighted quality score (impressions x quality score).


Once you have the data, click Insert > PivotTable. Once the PivotTable has been created, click PivotTable Tools > Options > Fields, Items, & Sets > Calculated Field. Here is where you create the formulas for calculated fields such as CTR, CPC, Conversion Rate, CPA, and ROI. You’ll also want to create calculated fields for average position (impression weighted position/impressions) and quality score (impression weighted quality score/impressions). This may seem like a lot of work, but it’s crucial for your data to display correctly as you slice and dice it.


Now that your PivotTable is set, we get to the quantitative analysis. First, pull the campaigns and ad groups into your PivotTable to get a count of the number of campaigns and ad groups. Then pull the keywords into the ‘∑ Values’ box and change the field value setting from ‘Sum’ to ‘Count’. If you highlight the ‘Count of Keyword’ column you just created, you can see some useful metrics in the lower left hand corner; the average number of keywords per ad group and the total number of keywords. The average number of keywords per ad group is a useful indicator of how tightly themed your ad groups are. A good average is 5 – 20. Anything larger and you’ll want to break up some ad groups into smaller, more tightly themed groupings.

Pull the ‘Campaigns’ field out of your PivotTable and you can now sort by the number of keywords per ad group. This will help you zero in on ad groups that are too large. In the example below, you can see that some ad groups with over 400 keywords. Not good.

Another red flag to look for in the Account Structure is overlapping campaigns. Are there multiple versions of the Brand campaigns? Are there ad groups for a product that appears in multiple campaigns?

Keyword Management

Since we have the keyword data handy, let’s take a look at the keyword distribution. Remove the ‘Ad Group’ field out of your PivotTable and pull in ‘Conversions’. Sum the data based on the number of conversions to give yourself a sense of the distribution of head, torso, and tail terms. For example:

Here you can see that the account has far too many long-tail keywords. Over 94% of keywords had zero conversions in the past twelve months and over 43% of the budget was wasted on these non-converting terms. By pausing out these non-performers, you can have a significant impact on ROI.


Next, we’ll look for warning message by pulling in the ‘Status’ column to your PivotTable. Of all of your active keywords, how many are below the first page bid? How many have low quality score or are disapproved?

Match Types

Just like we examined the distribution of keywords between the head and tail, you should look at the distribution of keywords amongst the different match type. By pulling the ‘Match Type’ into your PivotTable, you can get a good feel of how the volume is balanced, just be sure to set your PivotTable filters to Non-Brand and Search so that you get the most accurate picture.

As a rule of thumb, I like to see at least 50% of Non-Brand Search traffic coming from Phrase and Exact match keywords. In this example, the Brand distribution looks good, but over 90% of non-brand costs are on Broad match terms (which also had the poorest ROI of the three match types). There’s a big opportunity here to expand the match types on high performing keywords and then bid back aggressively on Broad to improve ROI.

Negatives

Negative keywords and placements can be a great way to improve ROI by excluding irrelevant traffic. Simply pull a Search Query Report and Placement Performance report, sort by volume, and see if there are any keywords or sites you want to exclude.

Budget and Delivery

Now we can start diving into the campaign settings. In AdWords, simply click on the ‘Settings’ tab, highlight the campaigns and settings, and use Paste > Paste Special > Text to paste the data into Excel. The settings you will want to review are the Budget, Location, Language, Network, Devices, Bid Type, End Date, Ad Scheduling, Delivery Method, and Ad Rotation. For Bing it’s a little trickier and you’ll probably have to manually review the settings using the AdCenter Desktop Tool.


The first thing we’re going to look for are campaigns that are hitting their daily budget and pausing out early. Ideally, you should never be hitting your daily budget. Using bids to manage daily spend will increase your volume for the same given budget.


Next, review the budget delivery method. All campaigns should be set to Accelerated Delivery so that you’re participating in every auction (in the AdCenter Desktop Tool, this is found under the ‘Additional Settings’ dropdown on the ‘Campaigns’ tab).
The next area to examine is the Ad Scheduling. Are you adjusting bids by day of week? What about time of day and day of week? Are you pausing your campaigns during unprofitable time periods? If not, then it’s time to dig into the data. In AdWords, click on the ‘Dimensions’ tab and select View > Time > Day of Week. Click the download icon and then click Add Segment > Time > Hour of Day. Once you’ve downloaded the data, create a PivotTable with the day of week on the horizontal axis and the time of day on the vertical axis. Then create a calculated formula for conversion rate. The end result should look something like this:

As a final step, create an index by dividing the day/hour conversion rate by the average conversion rate (2.9%/6.2% - 1).

This is the actual percentage that you should increase or decrease your bids for each day/hour combination. In this example, the advertiser sees strong performance on Tuesdays and Wednesday and weak performance on Sundays. Based on the data, I would also recommend pausing the campaigns between midnight and 4am Saturday through Monday.

Distribution

Naturally, campaigns will perform differently depending on the location, language, device, and distribution channel. The primary thing we’re looking for here is that the accounts are properly segmented so that each channel can be optimized independently.


Are the campaigns geo-targeted? Do you have separate campaigns for major geographical areas, such as US vs Canada? Are there opportunities to expand your geo-targets to capture new customers? Do the language settings compliment the geo-targeting? Is there an opportunity to reach new customer such as Spanish speaking Americans or French speaking Canadians?


For the network settings, check that you’re not mixing Search and Content in the same campaign (Content should always be broken out into its own campaigns). On Bing, is there an opportunity to split out the Yahoo!/Bing owned and operated sites from their search partners? From a high level, how does the performance differ between Search and Content? In the example below, the Content campaigns have an incredibly strong ROI, but only receive 3% of the budget. This is a major opportunity to grow volume.

Within your Content campaigns, are you using Remarketing to convert comparison shoppers? Are you using Interest Category Targeting to prospect for new sites to target (Interest Categories are a form of Remarketing based on your search query history. To see what Google thinks you’re interested in, go to www.google.com/ads/preferences)?

One of the biggest emerging opportunities is in Mobile Search, but like Content, these should be broken out into their own campaigns. Within the mobile campaigns, are you driving traffic to a mobile optimized landing page? Are you bidding aggressively enough to appear in the top two positions (you can use your keyword PivotTable to find out)? Is your call to action appealing to a customer on the road?

Ad Optimization

The first thing I look for here is how the ad rotation settings in the search engine UIs. Google AdWords offers three settings; optimize for clicks, optimize for conversions, or rotate evenly. Optimize for clicks works to maximize your CTR, which is good for Google, but clicks do not necessarily mean conversions (try putting ‘Free’ in your ads to see this in action). Optimize to conversions shows ads based on a blend of the CTR and conversion rate. This is an improvement, but doesn’t help you much when you’re trying to methodically test creative. Generally, I recommend rotate evenly for all campaigns where you are testing creative. This allows for the ads to get roughly even exposure so that you can make statistically significant decisions.


Next, I recommend pulling an ad performance report to get a feel for how many unique headlines and unique description lines you are actually testing. The approach is the same as the work you did for the keywords. Simply pull the raw data, pivot, and then count the number of uniques. It may also be worthwhile to see what percentage of impressions is going to the same headline or description line. This can give you a sense of how often new creative is being tested. If volume is concentrated on a small group of headlines, then you may want to increase the frequency of testing, particularly in high volume ad groups. Below are a few areas for potential testing:


Headline testing

Description line testing

Call to action testing (buy now, order now)

Value proposition testing (price, selection, service, speed, features, warranty, etc.)

Ad Extensions

Google ad extensions include Sitelinks, Location Extensions, Call Extensions, Product Extensions, and Social Extensions. On Yahoo!/Bing, ad extensions include their Rich Ads in Search ad format (basically, Sitelinks plus a companion image). Ad extensions can raise CTR and push competitors further down the page, so my best practice is to have at least Sitelinks on all Search campaigns. Location Extensions are good if you have brick and mortar stores and want to drive offline traffic. Call Extensions are best for Mobile campaigns, particularly when running click-to-call only. Product Extensions are primarily for ecommerce, though tend to get low visibility (try Product Listing Ads instead). Social Extensions are for building up your +1s, which in 2012 will likely become a factor influencing quality score and become a nice way for Google to make more money.

Summary

I hope this helps you to systematically evaluate some of the key performance drivers of SEM accounts. This is by no means comprehensive, but should serve as a good starting point for digging into the details and identifying areas of opportunity. Good luck!

When to Cut the Long Tail

The long tail has been a cornerstone of search engine marketing strategy since Chris Anderson first introduced the term in 2004. The underlying idea is that high-volume head terms tend to be fiercely contested, which raises CPCs, reduces ROI, and prices advertisers out of the market. So, instead of competing for limited space on a crowded page, marketers should focus on long tail terms that have low search volume, but are highly specific, relatively cheap, and collectively deliver a significant amount of clicks. This line of thinking has led many SEM marketers to aggressively expand their keyword set. SEM tool providers have gotten in on the act as well, using automated scripts to add long tail terms on an industrial scale. But is this effort really worth it? What is the right number of keywords for an account?

To answer these questions, marketers need to dig deep into their data to identify how their keywords are actually distributed. As a first step, I recommend pulling a keyword performance report for the last twelve months and then using a PivotTable to organize the data into a usable format.

My preferred method is to drag the Conversions into the Row Labels box and the Keywords and Cost into the Values box. Your Keywords will likely default to ‘Sum of Keywords’, so just click the dropdown arrow on the ‘Sum of Keywords’ menu, select ‘Value Field Settings’, and choose ‘Count’. Once you’ve organized your PivotTable, sum the data based on the number of conversions to give yourself a sense of the distribution of head, torso, and tail terms. So what does this data tell you? Let’s look at a few examples.

In this example, the advertiser has about 90,000 keywords in their account. They have a very long tail, but it is not delivering conversions. Over 93% of these keywords have had zero conversions in the past twelve months. Not good, but at least these keywords only accounted for about 14% of spend.

In this next example, the situation is more severe. Not only are 94% of keywords non-performing, but over 40% of the SEM spend was being wasted. What’s more surprising, the average non-performing keyword spent less than $5 per month.


This is a perverse version of the long tail; each of these keywords doesn’t generate enough volume to raise alarms, but collectively, the negative impact of these low-volume keywords is huge. This highlights the inherent tradeoff between granularity and transparency. The more volume that is derived from the long tail, the less data is available for managing each keyword. Taken to the extreme, conversion data can become nothing more than a series of 1s and 0s. By reducing the number of keywords, you can consolidate data into fewer elements, allowing for better decision making.

Based on this advertiser’s data, I aggressively cut back on the long-tail and paused all keywords that have had no conversions in the past twelve months. The result? ROI increased 5x, which freed up budget to reinvest in growing volume on performing terms.

The long tail can be a great source of efficient traffic and every account should have a healthy balance of head, torso, and tail terms, but marketers need to exercise caution. Here are a few steps to help better manage your campaigns:

• Periodically measure your campaigns to see how your keyword volume is distributed.
• Use caution with automated keyword expansion tools. No keyword should be added simply because someone searched on the term. Set criteria such as a minimum number of impressions or conversions before adding keywords to your account.
• When the tail starts wagging the dog, it’s time to cut. Consider pausing out non-performing long tail terms (even those with very little spend). If it hasn’t converted in a year, you probably don’t need it in your account.

Quality Score Demystified

Many marketers have experienced the impact of Google's Quality Score in their AdWords campaigns and know it's an important piece of the SEM puzzle. But what exactly is Quality Score and how can it be improved?

As publicly traded companies, the primary objective of search engines is to maximize their short- and long-term revenues. To do this, they have created auction based systems that prioritize ad delivery based on the predicted revenue they will receive by displaying an ad. Ads that are predicted to deliver high revenues are shown higher in search results than ads with lower predicted revenues. This is the basis of ad rank.

The predicted revenue that an ad will generate depends on two factors; how much an advertiser will pay for a click and how likely it is that an ad will be clicked on. Thus, ad rank = bid x predicted CTR.

In the simplest terms, Quality Score is the predicted CTR of an ad. So how do you predict whether an ad will be clicked on? Google uses numerous factors to predict CTR, but the most heavily weighted element is the historic CTR. This makes sense as the historic CTR is an objective measurement of past performance and a relatively good indicator of future performance. Here's an example to illustrate how the bid and historic CTR work together:

              Bid     Historic CTR     Predicted Revenue     Ad Rank 
Ad 1       $1            10%                    $0.10                     1
Ad 2       $2             3%                     $0.06                     2
Ad 3       $4             1%                     $0.04                     3

As you can see, Ad 1 has the highest predicted revenue due to its high historic CTR and is shown in the top position. Even though its bid is lower than the other ads, its high CTR means that it is more likely to generate revenues for the search engine. One interesting note is that it is not the absolute CTR that improves ad rank, but having a CTR that is higher than your competitors.

So far, so good, but the historic CTR isn't the only factor that influences Quality Score. Another factor is the relationship between the keyword, creative, and landing page. This is to help ensure that search results remain relevant and that users aren't deceived with bait and switch tactics. The search engines crawl the landing pages of advertiser sites and identify the themes of each page. They then compare those themes with the themes of the keywords and ads. If there is a common theme for all three, then the Quality Score is unaffected. However, if one or more components is unrelated to the others, the Quality Score is penalized. For example, a search for 'new iPad' that shows an ad for the Amazon Kindle and then lands a user on a page promoting a get rich quick scheme would likely be penalized to the point where there ad would not show, even with a ridiculously high bid.

So how can you improve your Quality Score? Either 1) improve your CTR, 2) make sure you align your keywords, creative, and landing pages, or 3) both. Your efforts will be rewarded with a lower CPC and a higher ad rank.

Google Search Retargeting in 2012?

Many articles have already been written about the Google’s decision to direct signed-in users to encrypted search, which effectively hides a sizable portion of referring keyword data from marketers. Estimates of the amount of impacted queries range from 15% - 20%. This figure is likely to rise with the introduction of Google Plus and its integration into the SERP, which encourage users to log in.

Google’s official explanation for the move is that it was intended to protect user privacy, but as Danny Sullivan pointed out, this explanation doesn’t make sense given that the referring keyword data is still available to AdWords advertisers. However, there is another lens to view this change through; the competitive environment.

Google has a long track record of acquiring or disintermediating third parties who develop businesses based on its ecosystem. Businesses that rely upon Google to provide traffic and data tend to end up competing against a Google product. This may soon be the case with search retargeting.

Over the past few years, we’ve the rise of search retargeting services such as Magnetic and Chango and data exchanges such as Blue Kai. These services utilize behavioral data (including search data) to target display ads. Google generates and owns a good portion of that search data. See where I’m going with this?

For now, Google’s competing retargeting products are relatively unsophisticated. AdWords advertisers can retarget based on 1) pixeling visitors to their sites or 2) interest categories as defined by Google. Interest categories are fairly broad buckets (you can see what Google thinks you’re interested in by visiting www.google.com/ads/preferences). So how are users classified into interest categories? According to Google, it’s “…based on the types of websites you like to visit”. This is in contrast to ads on Google.com, which are “…related to websites you visit, recent searches and clicks, or information from your Gmail inbox”.

However, Google could enhance the value of its retargeting product by incorporating that rich search query data and allowing advertisers to target display ads based on both the sites users visit and their search history. In addition to providing more granular targeting, such a move might also allow advertisers to make use of the 15% - 20% of referring keyword data which is now held exclusively by Google. This is not necessarily bad for the existing players; Google's entry may increase the visibility of search retargeting as a marketing tool.

This is not implausible given that Yahoo! had just such a product prior to the Bing merger and the ongoing rumors of a Google data exchange (which would sell this targeting data for use outside of AdWords). It's a logical way for Google to monetize its data stream and to exhance the value of AdWords. So, my prediction for 2012 is that we’ll see a Google search retargeting product, a Google data exchange for buying rich targeting data, or both.

The Forgotten Beta: Third-Party Ad Serving on the Google Display Network

Buried in the archives of the AdWords help site is an interesting gem: the ability to serve third-party ads on the Google Display Network. What’s a third-party ad? Let me explain.

Virtually all display ads trafficked on the internet are stored on dedicated computers called ad servers, which are separate from the servers which host websites. Think of ad servers as giant warehouses for ads. When you post a display ad in the AdWords UI, that ad is stored on a Google ad server. For most other display ad networks, ads are stored on ad serving platforms like Dart for Advertisers, Atlas, and MediaPlex.

When a user visits a website, that site may contain a snippet of code called a ‘tag’ that retrieves a display ad from the ad server to show on the page. This also occurs on sites in the Google Display Network. On those sites, a Google tag retrieves the ad from Google’s ad servers. The concept of third-party ad serving is simple; instead of the Google tag pulling an ad from Google’s ad server, it pulls the ad from the advertiser’s ad server (the advertiser is the ‘third party’).

The key benefit of this is that advertisers can update their ads on their ad server and the ads will automatically be updated as they run on the Google Display Network. This can be a huge benefit for advertiser with constantly changing ads. For example, travel companies can update fares, ecommerce providers can change which product they showcase, and deal sites can show a daily deal – all without having to manually post hundreds of ads to the AdWords UI. In addition, this beta is an easy way for companies that do a lot of display advertising to extend their reach on the Google Display Network.

This may also be the future direction of display ads on the Google Display Network. With their acquisition of Teracent, it’s only a matter of time before we see dynamic display ads that automatically update based on the cookie of the individual viewer. Think of it as remarketing 2.0 – display ads with intelligence.

So what’s the downside? Per Google “Third-party ad serving is available by invitation only to a select number of participants”, so unless you have a good relationship with your search engine rep, you may be out of luck. Also, there are also a lot of requirements on the acceptable ad format (found here: http://support.google.com/adwordspolicy/bin/answer.py?hl=en&answer=94230), though these are somewhat similar to the existing policies for the Google Display Network.