Location Targeting

Do you sell on a local level? Perhaps state-wide, nationwide or do you have a global reach? With Google Ads, you can target the following levels:

• Region
• State
• Congressional District
• City
• City Region
• Neighborhood
• Borough
• District
• County
• Municipality
• Postal Code
• Nielsen® DMA® Region
• Radius around a certain pinpoint
• Airport
• University

Location Exclusions

Have areas you don’t want to reach? Perhaps you know a certain zip code or state is just not profitable. Perhaps you have an agreement with your competition not to poach on their territory. Then, location exclusions can help you, well, exclude areas you do not want to reach. Similar to negative keywords, if a user is based in your excluded location your ads should not display to them.

Location Options

As a paid search advertiser, you also have options for how to target or exclude users. These options can help you expand or refine your targeted/excluded areas. You can target:

These options are also available for excluded locations. Again, depending on your budget and offering, you may want to tailor your setting in order to make the most of your ad dollars.

Location Targeting Best Practices

Below are just a couple reasons how to make the best use of location targeting. Please share your reasons or tactics in the comment section below this post.

• Budget: Keep in mind the budget you have to work with. If you’re on a limited budget (as most advertisers are) and you sell on a national level, you may want to consider advertising in areas you know are your top performers. Then, expand once you have success and more budget to put forth.
• IMC (Integrated Marketing Communications): Consider where your TV, radio, billboard, or print ads are showing and mimic those areas in your online advertising. This will help create a consistent presence for users who are searching online after seeing an offline ad.
• Segment by State: If you are advertising nationwide, consider putting each state in separately, instead of targeting the whole United States. This will enable you to see state-by-state performance, as well as increase or decrease bids on the state level. (See screenshot under Reporting, below.)
  • If you’re targeting multiple states within the U.S. they can be in the same campaign, unless you want/need different ad copy per state. In this case, you would want separate campaigns.
• Segment by Country: As a best practice, you should segment campaigns by different regions, more so when advertising to different countries. Here are a couple of scenarios:
  • If you market to different countries, you will want to create a separate campaign for each country. You can lump them together if the countries have similar psychographics (i.e. values, attitudes, interests, lifestyles), but for the most part, they should be separate, especially if you’re targeting different languages.

Reporting

Geo-location is very helpful, not just from a segmentation standpoint, but also from a reporting and analytic perspective. Organizing campaigns by geography is also beneficial since costs and competition can vary by market. This segmentation can help you see, at-a-glance, what’s working or not working, and optimize for that particular market.

Check out our comprehensive guide to location-based reporting in Pivot Tables: The Unsung Hero of PPC Performance Evaluation.

Also, if you’re still wondering whether PPC or SEO is the right choice for you, we can help with that, too:

Have anything to add? Want to share how you’re utilizing geo-targeting? We’d love to hear from you!

The post Location Targeting & Best Practices for Paid Search Advertising appeared first on Direct Online Marketing.

This blog post shows you how to extract location data from Google Ads into an Excel sheet, transform that data into a pivot table, and then manipulate that table to pull out performance insights.

Pivot tables are potent and complex. I hope that this careful, step-by-step example of PPC analysis—complete with (one might even say replete with) screenshots to guide you—will start to demystify pivot tables.

Exporting Location Performance Data from Google Ads to Excel

We’re going to extract our data via this path: Locations > User location report > Campaign view > Download

Let’s begin by setting the date range to examine. In the example here, I’m going to look quite far back; I want to take a deep dive into the historical performance of this account.

Navigate to: Locations > User location report

I’m selecting the “User location report” because I’m interested in where users actually were when they interacted with my ads.

The “Geographic report” factors in user interest in addition to user location.

Pick the report that best suits your product or service. For example, a tour company specializing in treks up Mount Kilimanjaro would benefit from knowing when people are interested in Tanzania.

Select “Campaign view,” not “Location view.”

If you select “Location view,” you won’t be able to segment out how each campaign did in each location; you’ll only be able to see total performance, for all campaigns, by location.

Set your columns for the metrics you want to pull into the pivot table.

Make sure to include “Location type.”

With your desired columns in place, download your data.

I recommend downloading it as a .xlsx file; a .csv file does not support saving advanced Excel elements (like pivot tables). I’ve had my stomach drop one too many times upon opening a file and finding all my work gone.

The resulting Excel should look something like this.

Setting Up the Pivot Table

Navigate to: Insert > PivotTable

Select the data that you’ve just pulled into the Excel sheet, including column headings.

Choose to place the pivot table on a new worksheet. (I find this keeps your work cleaner, and keeping all your raw data in a separate sheet is convenient in case you need to refer to it or create a new table.)

Click “OK.”

Populate your pivot table fields. You do this by checking the boxes that correspond to the columns you’ve pulled into Excel.

You can then drag the enabled fields between the 4 pivot table areas: Filters, Columns, Rows, Values. Shifting the fields from one area to another adjusts the pivot table for numerous avenues of analysis.

Here, I’m going to analyze how campaigns performed by country (and vice versa) looking at impressions, clicks, conversions, cost, and cost/conv.

Using a Pivot Table to Identify Performance Insights

Pivot tables can be a bit overwhelming. So let me begin with some navigation tips; then we can get to analyzing.

Expanding and Collapsing Your Locations and Campaigns

In the screenshot below, campaigns are nested within locations in column A. Being able to expand and collapse your rows is key to identifying general trends and then drilling down for granular performance analysis.

Navigate this path to open and close the nesting: Hover over the column you want to change > Right-click > Expand/Collapse > Collapse Entire Field

Sorting Your Metrics

There are many ways to sort within the nesting of a pivot table. This means there are many possible insights to be gained, but getting your sorting technique down can be finicky.

Where you click within the table to sort is crucial. The process to sort each time will be the same. Paying close attention to the cell you select, navigate this path to sort: Hover over a cell of the level/metric you want to sort by > Right-click > Sort > Sort Largest to Smallest

In the screenshot above, I am sorting locations by the total impressions they received from any campaigns. Excel is letting me sort this way because I right-clicked on cell B4, which is on the location level of nesting and under the total of impressions metric.

You can also sort by how the campaigns performed within a location. Starting this same sorting procedure by right-clicking on B5 would have sorted the campaigns nested within Singapore by impressions (and it would have the same effect on all the other campaigns within all the other locations below).

Warning: Don’t sort on column headings.

Sorting by any of the metric headings (here, any of row 3 cells B, C, D, E, or F) results in the rearrangement of your columns by the totals of the various metrics in each column. That is, the structure of your pivot table will likely change, as your metric columns are moved left or right to be in order from largest to smallest total. (You can also see the results of this change in the reordering of your fields within the areas in the panel on the right.)

See how C3 is now occupied by “Sum of Cost/conv” rather than “Sum of Clicks”; D3, E3, and F3 have been similarly affected.

Analyzing by Location

This pivot table lets us look at this account from (at least) two perspectives: how well our campaigns did in a particular country, and how various countries contributed to the performance of a single campaign. I’ll begin with the former.

Here I’ve collapsed the campaign level and then sorted by conversions to reveal which locations drove the most conversions.

From this, I can see that I want to nurture my efforts towards the United States, the Philippines, Indonesia, Singapore, and Iraq.

What campaigns in particular, though, should I focus on?

To answer this, I’ll expand the nesting to reveal the campaigns under each location and then sort by conversions by right-clicking on D5.

Now I can see that Campaign C has driven the most conversions in the United States and that Campaign A has driven the most conversions in the other 4 locations.

I could also sort by cost/conv to see that while Campaign C has driven the most conversions in the US (107.8), Campaign E has driven about one-fifth (39.1) of all conversions (206.5) in the US for about half (5.69) the cost/conv of Campaign C (11.72). So I’ll want to investigate Campaign C to see what’s going right there and do more of it.

Let’s also identify where there’s fat to be trimmed. When I sort by cost in the US, I see that Campaign H has spent the third-most of any campaign (727.78) for only 4.6 conversions; this campaign might not be worth running at that level of return.

Before I just pause the campaign altogether, though, I should dig into the ad groups and keywords within the campaign to see whether there’s a clear poor performer that can be carefully excised without axing the whole campaign.

See this blog post for how to pinpoint PPC performance changes. It shows you how to take a scalpel, rather than a sledgehammer, to poor performers.

Analyzing by Campaign

Time to switch it around.

Go to the panel on the right, to the “Rows” area, and move “Location” below “Campaign.” This will reverse the nesting in column A: locations will now be nested under each campaign.

Collapsing the locations reveals the big picture of performance by campaign.

Campaign C has driven the most conversions and at a cost/conv of just 11.72; on the other hand, Campaign A has spent thousands more for nearly the same number of conversions. Let’s investigate.

Here I’ve sorted by cost and then highlighted locations that have not converted in the nearly year-and-a-half that we’re looking at. It might be time to consider excluding these locations from our targeting.

We can also switch back to looking at locations overall and do this same evaluation across all campaigns.

I hope you’ve gotten the flavor of the numerous avenues of analysis that pivot tables open up.

For more help you PPC efforts, check these out:

• How to Pinpoint PPC Performance Changes
• Catch a Competitor Bidding and Ranking for Your Brand? Here’re Your Options
• Now It’s Free to List Your Products on Google

Happy analyzing!

The post Pivot Tables: The Unsung Hero of PPC Performance Evaluation appeared first on Direct Online Marketing.

There are a host of benefits that come along with running PPC marketing campaigns including budget control, only paying for ad clicks, detailed reporting, and targeting.

Let’s focus on targeting.

What Targeting Options Are Available?

1. Keyword Targeting: Create a campaign focusing on keywords that relate to your product or service and your ads will appear when someone is searching with the same or similar keywords. This puts your ads in front of searchers who are the most interested in your business and likely to click on your ad.
2. Location Targeting: You can set specific geographic locations to only show ads where your customers are located or have your ads show when someone searches for related products or services near you. Have a delivery service? Use radius targeting to only include the distance you’re willing to travel.
3. Device Targeting: Reach customers when they are nearby and show them ads tailored to increase calls to your business. By the way, mobile is very important—learn more from us here, here, or here.
4. Day/Time Targeting: Schedule your ads to display on specific days or times when your customers are online.

PPC targeting doesn’t end with these three options. You can also add targeting for specific demographics, languages, websites, and more.

Want to hear additional insider knowledge and get a free breakfast?
Of course you do!

Reserve your seat for our Grow with Google event in Frederick, MD. It’s Tuesday, August 25 at the Delaplaine Visual Arts Center and comes jam-packed with news from Google execs, one-on-one SEO & PPC consultations, and a delicious breakfast.

There is a lot to learn when it comes to PPC advertising, but the results are highly measurable and can be very profitable for your business. Let us help get you on the right path.

The post How To PPC Target Prospects in Frederick, MD and Beyond appeared first on Direct Online Marketing.