Making Good Use Of Those Location Extensions
November 17, 2014
When the time comes to really push your accounts, it’s helpful to know where to push and what will help connect users to your product or service. This can be especially vital when you have both online retail business as well as brick & mortar locations.
Sure you have location extensions enabled (you do, right??) but do you simply bid up all of those locations with bid modifiers? Do you target them specifically in their own geo-segmented campaigns? Or do you still see people doing most of their traceable shopping online?
The report that will help you identify exactly what locations are promoting in-store response, not just online response, is a segmented version of your AdWords location extension report. And you’re gonna learn how to use this yourself, with a couple quick steps from your PPC Heroes.
Getting Your Data
- You’ll begin with an ad extension report. You’ll want to pull a location extension report for a time period that makes sense for you. Have you recently changed your locations or the volume of your locations? Have you recently had a huge in-store offer that would skew the data? Look for an appropriate time period. In this example, we’re using a recent 30-day window, which is when we began a new seasonal strategy.
- Before hitting the Download button, be sure to divide your data into 2 very important groupings using the Segment feature: This Extension Vs. Other.
Exciting, right? Are you starting to feel the pieces come together?
Once you’ve downloaded this report, you’ll want to pull the “This extension” data into its own tab.
Cleaning Up Your Data
Your “This Extension” data probably looks like this:
First you’ll want to employ the Text To Columns feature in Excel:
You may simply divide all your Attribute data using the semicolon option, depending on how your location data comes through.
Pro tip: Because I like to get the extra stuff out of the way, I “Find & Replace” the country code with an asterisk. I then use the delimited text to columns on the asterisk:
and then I use text to columns to divide the data by semicolon. This provides me with just the data I’m looking for:
This tells me that for all the times my location extension showed, here is the data for when the location extension itself was clicked upon (Read: Someone was trying to find the store and encountered your link!). Because we assume the person looking for your IRL store may not have concluded their online search with an online purchase, this helps us gain visibility as to what they’re doing instead – visiting your store!
Using Your Data
Now that you have the data you can use, it’s time to figure out exactly where people want to shop. The data here shows me the top click-through-rates for each of my extensions! Yay, Pittsburgh, right?
I can also use a pivot table to group together cities or states, depending on the volume of businesses and also the detail to which I want to target.
You may to choose to pivot by state, which may result in a view like this:
Don’t forget to use Calculated Fields when gauging performance by a ratio (such as CTR or Conv Rate), or else you’ll be looking at some goofy data, friends.
From here I get a nice, clean view of the locations that may not be leading to direct online purchases, but are certainly connecting shoppers to my store. If I were to simply look at this data by a geographical report, I might think that there aren’t many shoppers in Pittsburgh as seen by their online conversions. But what I now see is that there are several folks looking for our store and perhaps my Pittsburgh location is actually benefiting from these extensions.
Although your first glance at your location extensions may tell you to pull back on certain cities or states, today’s report shows you when there’s actually quite a bit of value in targeting this area. An overly simplified report can do more harm than good sometimes, and this is an excellent example.
So give it a whirl and see what kind of new insights you glean from this report. And remember, not everything is based on the bottom line conversion… you just have to find the right report to show you the way!
Browse By Category
Update Bids and Monitor Changes with AdWords Scripts
Explore different ways to use Google Sheets and AdWords Scripts to change bids and handle uploads. Get started with creating your own bidding system!
Google Speed Update – What It Means & The PPC Impact
The Google Indexing Speed Update implemented site speed as a SERP ranking factor for mobile web pages. Learn how the update could affect your PPC campaigns.
Dynamic Search Ads for Advanced Users
Explore a few advanced ways to use Dynamic Search Ads in your account!
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
What is 3rd Party Data and How Do You Use it?
Data is everywhere in online advertising. 3rd party data is an extremely useful way of getting your message in front of the right prospects. But what is 3rd party data and how do i use it.
Launch Your Multi-App Marketing Strategy
Understand what three things you need to know to start your Multi-App Marketing strategy.
Time for an Honest Discussion about RSA's
Join Hanapin’s Matt Umbro and Directive Consulting’s Garrett Mehrguth as they engage in an honest discussion about responsive search ads, walking through all the pros and cons and advice around using the new ad type in your campaigns.
Load More »