A Step-By-Step Guide To Query-Level Bidding In Google Shopping

Columnist Kirk Williams walks you through how to adopt an increasingly-popular -- though somewhat complicated -- bidding strategy.

Chat with SearchBot

google-buy-shopping2-ss

I was mining through my Google Shopping Search Query Report a few weeks ago and discovered this exact match query.

bad query in shopping campaign

This is not a joke. That was not PhotoShopped.

My product (a coffee maker) was, in fact, showing up for the exact match letter “m.” Unless I’m selling bobble-head versions of James Bond’s superior or Facebook’s new personal assistant app, I don’t want to show up for [m].

The Problem with Google Shopping

This has always been the problem with Google Shopping. Because there is no keyword targeting, we are dependent upon Google to find the most relevant keywords and match them to our products.

If we want to adjust the bids for queries that appear, we must change the bid on our products or product groups. But this has its issues. If a product is bid to $5.00, we will be bidding:

  • $5.00 if the keyword is as general as: [microwave]
  • $5.00 if the keyword is as specific as: [i have cash in hand and want to buy an Acme Model 406 space saving microwave now now now].

With this model (the Shopping model the majority of advertisers use), you really are stuck. You have three options:

Microwave Oven Ss 1920

  1. Exclude [microwave] if it gets enough cost with no conversions (But what if you still want to show up for this general query? What if it converts at a lower CPC but converts nonetheless?).
  2. Bid the product lower. The problem with this, of course, is that if you do this, you will lower the bid on the awesome-converting specific query, as well as the more general query.
  3. Add another ad group, exclude [microwave] from one of the two and adjust your bidding (This will be an exceptional nightmare of time-consuming management when your client has 8,000 products).

So here is my question for you as you consider whether to finish this exceptionally long article (4,500 words at last count). Do you want to bid a separate amount for: [microwave] than you want to bid for: [i have cash in hand and want to buy an Acme Model 406 space saving microwave now now now], and yet have them both remain in the account?

If you want this control over Google Shopping, then continue reading.

In this article, I will explain Martin Roettgerding’s strategy for Shopping Query-Level Bidding and detail my own step-by-step process for setting it up in my own accounts. (Don’t worry if you don’t know Roettgarding — aka Röttgerding — I’ll introduce him later.)

A Brief Froogle/Product Search/Product Listing Ads/Shopping History

In May 2012, when Google announced that it was moving Product Search from a free to a paid solution, we grimaced. Now we were going to have an additional cost for the same revenue we earned before. Much groaning and whining occurred in the PPC space.

However, while the echoes of disgruntled-ness wafted through the air, something interesting happened.

We began to investigate advanced Product Listing Ads strategies and discovered that the majority of advertisers were slow adopters. Because of this, our revenue from PLAs began to increase exponentially, and we happily settled in. Over time, advertisers and strategies began to catch up, and participation become the status quo. We saw increased CPCs and lower conversions as auctions became full, but we still enjoyed a significant source of revenue and ROAS.

Then Google changed things up on us again. In October 2013, it announced it was moving to a newer new model: Shopping Campaigns. This began to roll out to all advertisers and was not without its lack of issues (Remember the great No Ad Groups debacle?).

When the current iteration of Google Shopping came out (I struggle just to keep the names straight), I shrugged my shoulders, rolled my eyes and transferred my old PLA strategy over to the new campaign type. Of course, there were adjustments in CPC and revenue as things shifted, but for the most part, I continued my PLA strategy.

While this was not wrong, I, like many others, was missing a big opportunity with this mindset.

Enter Martin Roettgerding Of Bloofusion In Germany

Martin Roettgerding Headshot

Martin (or @bloomarty as you may know him from Twitter) began diving into a strategy in Google Shopping unlike any I’d yet seen. In December 2014, Martin released his strategy on his blog: Taking Google Shopping to the Next Level by way of video. I warn you, the video is so chock-full of insights you may have to watch it more than once (I did).

Below I will summarize the gist of it. It is quite simple, actually, once you understand the principle of it. However, the ramifications are huge.

Query-Level Bidding Strategy Breakdown

The Goal:

Create a Google Shopping strategy that allows you to quickly and easily bid separately depending upon the search query. In other words,

  1. If the query is more general, bid it low.
  2. If the query is branded or more specific, bid it higher.
  3. If the query includes a SKU (identifying a visitor far along in the sales funnel), bid it top-dollar.

The Strategy:

Once you break it down, it’s actually quite simple.  The key components to each campaign in this strategy are:

  • Priority Setting
  • Negative Keywords
  • Shared Budgets
  • Product Bids

The Priority Setting tells Shopping which campaign should be used first for a query, the Negative Keywords filter the queries into the correct campaign, the bid sets the place in the auction for that query, and the Shared Budget keeps the whole thing working by ensuring no campaign at a higher priority drops out of the auction and blows the whole thing.

Here is a simplified version of how each campaign will look. If you keep reading to the end of the article, we will go through how to set these up in your account, step by step.

No-Brand Campaign

This picks up general, low converting queries.

  • E.g. [best widget]

Campaign Name: Shopping – Widgets – NB – US

Priority Level: High

Bidding: Low bids, say $0.50

Negative Keywords: All brand and SKU keywords

Budget: One shared budget between each campaign in this strategy

Brand Campaign

This picks up more specific (no SKU) brand queries.

  • For example, [Acme widget for sale]

Campaign Name: Shopping – Widgets – BR – US

Priority Level: Medium

Bidding: Higher bids, say $2.00

Negative Keywords: All SKU keywords and specific product name keywords

Budget: One shared budget between each campaign in this strategy

SKU Campaign

This picks up ultra-specific queries that include SKUs.

  • For example, [Acme model 43567 widget]

Campaign Name: Shopping – Widgets – SKU – US

Priority Level: Low

Bidding: High bids, say $5.00

Negative Keywords: Only those SKU keywords that you see over time are high cost and low conversion

Budget: One shared budget between each campaign in this strategy

 

Think of it like a French press for coffee. The press (the general No-Brand campaign) captures the grounds (the more general queries) and allows the coffee (the specific queries) to remain in the press (the Brand campaign).

If you are like me, and you don’t love French press coffee because it still has particles in it from the metal filter, then you can actually filter it one more time.

To do this, you’d take the filtered French press and pour it over a cone with a paper filter (the SKU campaign); now you are filtering out the sediment (the Brand queries), as well.

You have made an excellent, sediment-free cup of coffee (with SKU queries only) by filtering it twice. As in the illustration, the strategy here actually employs two filters — the No-Brand campaign and the Brand campaign — before it finally shows ads only to the highest converting queries, the SKU level.

French-Press-Illustration-SS

 

The Outcome:

The sign of a good strategy is the test of time. Ever since I heard Martin’s strategy, I have been implementing variations of it in my accounts. For various reasons, it works in certain accounts better than others. However, while results vary, overall I am convinced of the long-term value of this strategy.

Just for fun, I pulled several different manufacturers from different accounts in which I am running this strategy and came away with these takeaways.

  • Shopping Traffic Volume And Cost Tend To Increase. This makes sense, since you are getting into higher CPC auctions that you wouldn’t have been able to get into before because of forced lower CPCs on all terms. Be aware of the potential for this to occur, so it doesn’t take you by surprise.
  • Conversion Rate Tends To Rise Significantly. I’ve seen conversion rates increase by 21 percent and by 168 percent. This gets to the heart of this strategy, since you are hoping to decrease your budget (and thus traffic) from general, less conversion-likely clicks and increase your budget (and thus traffic) from more specific, conversion-friendly terms. I did see one instance where the conversion rate decreased, but this manufacturer’s key product was unavailable for nearly a month, so I believe this significantly skewed the results of that particular brand’s analysis of this strategy.
  • Average Order Value (AOV) May Decrease. Honestly, I have no idea why this is the case, but I thought it fair to include this in my analysis. I am not sure if there is a reason or if I just don’t have enough data for a truly fair analysis. Regardless, in many manufacturers I analyzed, I saw an AOV decrease when I compared stats from before and after this was implemented. Most of the time, however, overall revenue would increase significantly, so losing some money per order may be worth it to you to gain more revenue overall. It is worth noting that this was not the case in every instance, and there are always other factors involved, so take this takeaway with a grain of salt.
  • Don’t Expect To “Wow” The Boss From Day One. Overall, I found this to be a successful long-term strategy. The longer the strategy runs, the more it seems to pay for itself as data is accrued in new segmented ways that can be acted upon.
    • Think of it like a jumbo jet taking off compared to a little propeller plane. The nimble Cessna will hop off the ground and jump up, impressing with loops and barrel-rolls, however, it will quickly reach its maximum altitude and distance and have to land for refueling.
    • The jumbo jet, on the other hand, will lumber slowly off the ground, but then it will soar higher and fly farther than you thought was possible after seeing the Cessna.

747 Shopping Campaign Ss

It really does take time to gather data in these new campaigns and make optimization decisions — and that takes time and budget. However, from the accounts I analyzed after having them running for awhile, I am already seeing encouraging things and making decisions to reduce wasted spend and pump budget into those keywords that are performing well.

Step By Step: Setting Up Query-Level Bidding In Your Shopping Account

While I have great respect for Martin, my purpose in writing this post wasn’t merely to fawn over his intelligent strategy. I thought it would be helpful to actually walk you through my process for setting this up in my accounts, screenshots and all.

This is a step-by-step walk-through of how I set up my query-level targeting campaigns.

• Step 1: Set Up Your Non-Brand Campaign

If you are setting up this strategy in an account with existing shopping campaigns, go to Part 1.

If you are setting up this strategy in an account with no existing shopping campaigns, go to Part 2.

♦ Part 1. Existing Shopping Campaign
I wanted to address this separately because you don’t want to lose all of the data you have in an established account with live Shopping Campaigns. Here is how I have handled this situation in the past:

  1. Open the existing Shopping campaign.
  2. Navigate to the Search Query Report.

shopping search query report

  1. Filter for the most common “brand” term (in this example, the brand is Acme).
  2. Compare the view that “contains” brand and that “does not contain” brand.

filter search query report

  1. If one is clearly sending more conversions, then don’t risk losing that data. You just determined which campaign this will be.

In other words, if the existing campaign sent 100 conversions at a $40 CPA through brand terms, and the no-brand campaign sent 450 conversions at $50 CPA, I suggest you make this campaign into your No-Brand campaign, so you don’t lose the majority of your conversion data.

Helpful Hint

Keep in mind that no matter how you organize your products in an ad group, your products will always retain their data if they are still in that same ad group.

Often, when I take over an account, I see that the previous PPCer organized their Shopping account with one campaign and one ad group. This stinks, but at least I can go ahead and reorganize the ad group the way I want to without losing any of that historical data.

Now that you have decided this should be the No-Brand campaign, it’s time to make it so.

  • Navigate to the Settings tab
  • Change the name to Shopping – Widgets – NB – US
  • Change the Campaign Priority to “High”

rename campaign

Setting Up A Shared Budget

Now, you need to set up your shared budget. Remember, this is how you make sure all campaigns are showing at the same time, so your filter will work.

  • Navigate to the Shared library tab on the bottom left of the Adwords UI
  • Make a name for your budget, select the correct campaign, set the budget, Save it

shared budget for shopping

Setting Up Negative Keywords

Now, time to add Negative Keywords.

  • Navigate to the keywords tab in your Campaign

negative keywords in shopping campaign

  • Add “all” possible brand term variations and SKU terms (I like to overkill here). Remember, you don’t want any of these terms to show in the campaign, because you will have everything bid low.

add campaign level negatives

Adjust Bidding

Last step. Now it’s time to drop your bids.

  • Select the Ad group, then navigate to the Product groups tab
  • Select all products, and bid them as low as you feel they should be. Some of my client brands are profitable on no-brand queries, while others are not profitable at all. Identify your specific client situation and bid accordingly.
  • Large Clients: Now, if you have a ton of Product groups or products, there is a trick here: Don’t adjust bids in the interface. AdWords Editor doesn’t fully support Shopping campaigns, but it does allow you to edit bids in existing Product groups. This is a HUGE time saver.
    • Open Editor
    • Get recent changes
    • Select your new Shopping – Widgets – NB – US campaign
    • Go to Keywords and targeting, and select Product groups

product group bulk edits

    • Sort the column by Max CPC, highlight all CPCs with a value and change the Max CPC to $0.50.

editor product groups bidding

    • Post changes (Check to make sure everything looks right)

There you have it. Your first Campaign following this strategy is set up.

Now, go to Step 2 (Go ahead and skip Part 2 below; that is only for people who need to create a brand-new Non-Brand Shopping Campaign).

♦ Part 2. New Shopping Campaign

If you are working on an account with no current Shopping campaigns, then things will be a little smoother for you.

The first step is to choose the manufacturer you want to focus on in this first run at Shopping. This is usually pretty easy to identify, since most businesses will have a manufacturer that rises to the top. Once you have decided on a manufacturer to use for your test, create a Shopping Campaign.

Create A New Shopping Campaign

Create a google shopping campaign

Let’s start with the No-Brand campaign first:

  • Set the name to Shopping – Widgets – NB – US
  • Set the Campaign Priority to “High”
  • Set the Merchant identifier to the correct Merchant Center account
  • Create a custom inventory filter to only find the products for the specific brand in this campaign

priority settings shopping campaign

  • Set everything else up like you normally would (For the sake of time on this already ridiculously long blog post, we won’t go through all other settings in campaign creation)
  • Save your newly created non-brand campaign

Now comes the fun part, setting ad groups in your campaign. Here is where you decide how to break out your products in your campaign for this brand. Note carefully that you will want to do this well, but once you do it in this account, you can simply copy the entire campaign over for the other two versions of this campaign set.

Setting Up Ad Groups

Note: I tend to put more emphasis on Ad Groups than others I have read in the past. I do this because you will reap many segmentation benefits in the future if you do the extra work now. Why? Because you can use negative keywords to funnel traffic into the right ad group.

For example, I may set up a new Shopping Campaign like this:

Shopping – Apple Computers – NB – US

  • Macbook Pro
  • Macbook Air
  • iMac
  • Mac Pro

 

In the preceding example, you may even want to add the sizes into different ad groups, as well.

 

Shopping – Apple Computers – NB – US

  • Macbook Pro 15
  • Macbook Pro 13
  • Macbook Air 13
  • Macbook Air 11
  • iMac 27
  • iMac 21
  • Mac Pro

If you have the traffic volume, you will be amazed how much this cleans up your decisions when viewing the search query report (SQR). You may see that you keep having “Macbook Pro 13 inch” queries show up in your 15 inch ad group without converting. Now, because you have segmented things out so well in the beginning, you can see that and make a decision on it instantaneously.

It can be monotonous, but now use the handy-dandy Shopping Product groups to filter your products correctly. Again, remember that if you do it now, you can simply copy over your entire campaign into the other campaigns in this strategy, and you’re done.

By the time you’re done, your ad groups should something look like this:

Shopping – Apple Computers – NB – US

  • Macbook Pro 15 [ad group]
    • product group filter: brand: Apple
      • product group filter: Product type: Macbook
        • product group filter: size: 15 inch
          • product group filter: Item ID:
            • applemb15-2013
            • applemb15-2012
            • applemb15-2011
  • Macbook Pro 13
    • product group filter: brand: Apple
      • product group filter: Product type: Macbook
        • product group filter: size: 13 inch
          • product group filter: Item ID:
            • applemb13-2013
            • applemb13-2012
            • applemb13-2011

 

It looks complicated, right? Segmentation is never easy, but if you do it right, you will be bidding on what you want to bid on, while your competitors will be bidding on everything. There is a huge difference between these two options.

NOTE: Don’t forget to exclude the terribly frustrating “all products” checkbox in each product group.

all products checkbox in google shopping

If you want more information on why this is important, I wrote on this here: Is This One Checkbox Killing Your Google Shopping Strategy.

Setting Up A Shared Budget

Now, you need to set up your shared budget (Remember, this is how you make sure all campaigns are showing at the same time, so your filter will work).

  • Navigate to the Shared library tab on the bottom left of the AdWords UI
  • Make a name for your budget, select the correct campaign, set the budget, Save it

shared budget shopping

Setting Up Negative Keywords

Now, time to add Negative Keywords.

  • Navigate to the keywords tab in your Campaign

negative keywords in shopping campaign

  • Add “all” possible brand term variations and SKU terms (I like to overkill here). Remember, you don’t want any of these terms to show in the campaign, because you will have everything bid low.

add campaign level negatives

There you have it. Your first Campaign in this strategy is set up. Now, on to Step 2.

• Step 2: Set Up Your Brand Campaign

You made it through the first campaign. The good news is that it gets easier from here. The trick is bulk edits.

Copy And Paste The Non-Brand Campaign In The AdWords UI 

  • Select the Shopping – Widgets – NB – US campaign. Copy and Paste it.

copy Shopping NB campaign and paste

  • Open the campaign settings tab
  • Change the name to Shopping – Widgets – BR – US
  • Change the Campaign Priority to Medium

brand shopping campaign setup

  • Ensure the Shared Shopping Budget is still Applied

shopping budget

 

Add Negative Keywords

Just as in the Non-Brand campaign, you will need to add negative keywords.

Before you do this, make sure to delete the brand keywords that were in this campaign when you copied it over from the Non-Brand campaign. If you don’t do this, you will end up destroying your entire strategy.

After doing this, because you want your brand terms to show in this specific campaign, you will only add the Product SKUs into this campaign as negatives.

There is actually a simple bulk way to do this.

  • Go to the Products tab in your campaign
  • Highlight all of the products listed here
  • Open Excel, paste into Excel. This will make everything pop neatly into columns
  • Simply copy the “Item ID” column from this Excel file (I set mine as my SKUs for this reason), and add directly as campaign level negatives

Shopping campaign product SKUs

Don’t forget, this is an essential step, because it is how you are filtering out the SKUs so they can then be bid on directly in the final Campaign: the SKU-Level Campaign. Remember, the Campaign Priority, the Negative Keywords and the Shared Budgets work together here.

Adjust Bidding

Last step. Now it’s time to raise your bids. Remember, your non-brand campaign has super-low bids so you aren’t wasting any money on those pesky general queries.

For your brand campaign, you want to set slightly higher bids.

  • Bulk Bid Edit: Don’t adjust bids in the interface. AdWords Editor doesn’t fully support Shopping campaigns, but it does allow you to edit bids in existing Product groups. This is a HUGE time saver.
    • Open Editor
    • Get recent changes
    • Select your new Shopping – Widgets – BR – US campaign
    • Go to Keywords and targeting, and select Product groups

shopping bulk bid editing

    • Sort the column by Max CPC, highlight all CPCs with a value and change the Max CPC to something higher, say $2.00.

Bid brand shopping product groups

    • Post changes (Check to make sure everything looks right).

There you have it. Your second Campaign in this strategy is now set up. To finish everything up and watch the magic begin, create your third campaign.

• Step 3: Set Up Your SKU Query Level Campaign

You’re almost done. This process will be very similar to the second campaign.

Copy & Paste the Non-Brand Campaign In The AdWords UI

  • Select the Shopping – Widgets – NB – US campaign, Copy and Paste it

copy Shopping NB campaign and paste

  • Open the campaign settings tab
  • Change the name to Shopping – Widgets – SKU – US
  • Change the Campaign Priority to Low

shopping SKU level campaign

  • Ensure the Shared Shopping Budget is still Applied.

shopping budget

 

Remove Negative Keywords

Unlike in the other campaigns, you will need to remove all Brand or SKU negative keywords. Remember, in this strategy, your filters are the other campaigns, so you don’t need nearly as many negative keywords.

Remember, the Campaign Priority, the Negative Keywords and the Shared Budgets work together in this strategy.

Adjust Bidding

Now it’s time to raise your bids. You are now tweaking the campaign that will only show up on highly targeted SKU queries. The majority of people searching for these queries (make sure to exclude “parts” and “used”) are far enough along in the funnel to know exactly what they want. They just need to be convinced to buy from you.

Honestly, bid these suckers high at first. I see ridiculously high CTRs and Conversion Rates on these SKU campaigns. Because I can make sure I’m always in first position for these queries I want to appear for, it makes a big difference.

Use the same bulk bid edit you used in Step 2. This time, I suggest you bid the products to something like $5, or maybe $10, or maybe $15. Figure out what works best in your industry, but don’t be afraid to bid them higher.

Remember that your traffic volume will be significantly lower in this campaign, and your Conversion Rate will (should) be significantly higher, so you can afford to pay more per click. Sort the column by Max CPC, highlight all CPCs with a value and change the Max CPC to something higher, say $5.00.

sku level shopping bids

 

Strategy Summary

So there you have it. A detailed step-by-step look at setting up a SKU-level Shopping strategy. When you are done, you should see something like this in your account for each Manufacturer:

The finished google shopping strategy

This strategy has been tested and tried by more and more people. It is not uncommon for me to hear of people on Twitter who use it and respect it. On the other hand, if you don’t believe me, then by all means continue using one campaign and one ad group for all your products, especially if you are my competition.

Commonly Asked Questions

To close this incredibly long post, it would be worth looking at a few common questions in thinking through this strategy

Q. What if Brand Keywords Drive Negligible Traffic For Me?

I have a client like this. Brand sends such low amounts of traffic one would be a fool to set up this strategy I outlined. In this case, you have to get creative.

Here is one idea to try: Converting query campaigns. Consider taking conversion data to funnel traffic from high-conversion queries into the Medium priority campaign with higher bids. You would do this by excluding all conversion-friendly queries in your more “general” query campaign with a High Priority setting (and shared budget, of course).

Q. My Current Setup Makes Us Money, Though It Is Pretty Simplistic. Is It Really Worth Switching To This New, Crazy, Detailed Strategy?

This is a great question and the one you will receive when you pitch this complicated strategy to your boss/client. I have three responses to this question:

  1. We will be transitioning things slowly to keep a close eye on things. Here is the first manufacturer we will try; we will give it one month and then compare numbers to see what happens. This will not be an account “blow-up” but a graduated transition as profit is demonstrated.
  2. We will still be maintaining the majority of traffic and conversions that were coming through in the core campaign and will leave that campaign/ad group(s) alone, other than changing the priority setting and adding negative keywords (Remember how we did that in Step 1, Part 1 above? This is why it’s important to choose which campaign you overhaul, rather than simply starting a new one and losing all your historical data).
  3. Yes. Yes it really is worth it in the long term (Remember the jumbo jet illustration). If we look at what the numbers are doing today and tomorrow, consider what the numbers could be doing over the next 12 months, as we begin getting highly targeted queries in the right ad groups at the right bids. Right now, we are bidding any amount on any query. In the future, we can bid up just the queries we want to bid on.

Q. Will This Make Me Millions Tomorrow?

It takes time to accrue data because of all of this segmentation. It’s important to stress the long-term value of this strategy. I have explained it in detail to clients. They always have questions, but they always walk away convinced of the benefit and willing to spend the time necessary to build up the data because of the undeniable power in this level of segmentation.

Q. Where Do You Add Additional Negative Keywords?

When you add a negative keyword to any campaign, you must add it to all of the campaigns lower in the funnel, as well. If you don’t do this, you will simply be filtering it further down and actually end up paying more for that query.

So there you have it. This is how I create and carry out Martin’s strategy for Query-Level bidding in Google Shopping. I have seen awesome returns so far, and I’m excited to continue to monitor things as my clients continue to accrue actionable data.

Any questions or comments on this strategy? Let me know in the comments below, and I’ll do my best to answer them.


Opinions expressed in this article are those of the guest author and not necessarily Search Engine Land. Staff authors are listed here.


About the author

Kirk Williams
Contributor
Kirk is the owner of ZATO, his micro-agency focused solely on Paid Search Advertising, and has been working in Digital Marketing since 2009. He has been named one of the Top 25 Most Influential PPCers in the world by PPC Hero the past 5 years in a row, and is known for his e-commerce PPC articles across various industry publications. Pre-COVID, he was an international conference speaker presenting on all things Paid Search (especially Shopping Ads) around the world but now sticks to podcasts and online conferences to share his latest tips on Google Shopping Ads. Kirk currently resides in Billings, MT with his wife, 5 children, Trek bikes, Taylor guitar, books, and little sleep.

Get the must-read newsletter for search marketers.