Schedule your FREE growth strategy session

If your website generates over $20k per month, let’s chat. We’ll discuss your goals and figure out how we can help your business get to its next stage of revenue and growth. 

Client feedback

Mac Steer
Mac SteerSims Direct Owner
Read More
“Almost $4 million in revenue from basically nothing.”
Matt Childs
Matt ChildsWine Stash
Read More
“[They] helped us to more than 10x our conversions while decreasing the amount we're spending on Adwords almost every day.”
Ellen McCaleb
Ellen McCalebHeadwaters Studio
Read More
"My conversion rate went from like 1.83 to over 9%."
Pat Langley
Pat LangleyVaikobi
Read More
“We've been using them for just over a year now and we've had incredible success. We've grown our online business 145% and achieved a ROAS of 4.9. Fantastic return on investment!”
Read More
"Our ROI's went from 88% to 275%, which is huge."

Over 1.4 million views and growing fast on YouTube

We’re proud to be helping thousands of ecommerce business owners by giving the most digestible, battle-tested advice to be found online about succeeding with Google Ads.

Be sure to follow our channel to stay in the loop.


The Best Bid Strategy for Google Shopping – Plus Free Bidding Template

In this post, you’re going to learn the best bid strategy for Google Shopping that generated more than twelve million dollars in Ecommerce sales for our clients.

We have outlined here the exact steps on how we do Google Shopping bidding. I invented this strategy myself, and it's what my whole team uses to manage our clients’ Shopping campaigns and scale them like crazy.

If you want to access the FREE Google Shopping Bidding Template, just enter your name and email address below and we’ll send the link to the template directly to your email.

Get Your Google Shopping Bidding Template Here!

Why are we giving this information for free?

Yes, the Google Shopping bidding template is free but we don't want to give this to everybody. We only want to give access to this very valuable template to Ecommerce store owners who are serious about managing and scaling their Google Shopping campaigns.

Apart from getting access to our Google Shopping ads bidding template, you are also going to learn the step-by-step bidding management system that we've used to scale up dozens of successful Google Shopping campaigns.

We call this the best bid strategy for Google Shopping not because we invented it. It’s because this strategy uses real data in your Google Shopping campaigns and takes into account the conversion rate and the profit margin on your products to work out exactly how much you need to bid.

The template will tell you exactly how much to bid to break-even on your products and how to actually make profits on your Shopping campaigns. You only need to provide your conversion rate, the average cost per click, and your profit margin. These pieces of information, when entered into the template, will help you figure out how much you need to bid to break-even on all your products.

This may sound like some “mad scientist” digital marketing stuff, but we've been using this strategy for years now and it absolutely works. There’s just a couple of things you need to have to make this strategy work.

  1. You need to have multiple conversions in your Shopping campaign already: ten or more. It will still work if you have less than that, but the data isn't going to be as accurate. The more conversions you have, the more accurate this data is going to be.
  2. You also need to know your profit margin for your store or for your individual products. It’s very important to know your profit margin when you're doing the finances for your store. Check out this post to learn how to calculate your Ecommerce profit margin for the products in your store.

Steps to Use the Key Commerce Google Shopping Bid Strategy Template

STEP 1: Request Access to the Google Shopping bidding template

To access our free template, first, you need to enter your name and email address on the form above. You will then receive a notification in your email with the Download Link to the sheet.

STEP 2: Go to your Google Ads account

In your Google Ads dashboard, navigate to the campaigns tab for your Shopping campaigns. Choose a campaign and select an Ad Group if you have multiple ad groups.

STEP 3: Subdivide your product (if you have multiple products)

Make sure to split out all the different products in your ad group on an individual basis. To do that, click on the Edit button and subdivide all products by Item ID.

Select all the products and make sure to scroll down to check that all products have been selected, then click on the CONTINUE TO EDIT BIDS button. Then, click on SAVE.


STEP 4: Choose the appropriate columns

The columns that you need for this Google Shopping bidding strategy are your Max CPC, Avg CPC, Clicks, Conversions, and Conv value. If you haven’t unhide or set up these columns yet, you only need to click on the COLUMNS button, then MODIFY COLUMNS


To show the Avg CPC and Clicks columns, go to the Performance section and tick on the Avg CPC and Clicks boxes. 


To show the Conversion and Conv value columns, go to the Conversions section and tick on the appropriate boxes. 


Make sure that you show the columns in the exact order as shown in the image below. To do that, just drag the column names into the right position. Then click on APPLY


STEP 5: Set the right date period

The next thing you need to do is set the right date period. If this is your first time setting this data up and you’ve been running this campaign for a long time (a month, for example), you want to set the date for that period. The longer the date period you set, the more data you’re going to get. But the shorter the date period, the fewer the data you get from your campaign.

However, you also need to consider all the big changes you’ve implemented in your campaigns for the date period you’re going to select. For example, if you’ve excluded some of your products during the previous month, then the data you’ll be getting might not make sense for you.

We recommend setting the date period for a month, or up to three months if you’ve not made any major changes in your campaigns. So to set the date period, click on the Custom date option on the upper right portion of your account, then select the date period. 


STEP 6: Download the report

When you’ve finally set up all the columns and data you need, the next step is to download all the information in CSV format. Click on the Download button, then choose CSV


STEP 7: Set up the free Google Shopping bidding template

Once the report has been successfully downloaded, open it in Excel sheets or you can just drag and drop it to Google drive to view it using Google sheets.

Once opened, copy all the juicy information with all the columns and data you’ve generated from your campaign, as shown in the image below. 

You then need to paste this data on our Google Shopping ads bidding template. Just click on the cell where it says “Campaign,” then paste the data you’ve copied. 


How the Google Shopping Bidding Template Works

Once the template has been filled out with your data, all the other columns will automatically get populated with the juicy information you need to know exactly how much you need to bid to break-even and make profits on your Shopping campaigns.


This template pulls in the data you’ve entered, including the average amount you've been paying for clicks so far (Avg CPC), the amount of Clicks, the number of Conversions, and the total Conversion Value.

As you can see in the image above, we have 5 columns that are highlighted in yellow:

Click until conversion – Calculates how many clicks you need to get a conversion

Avg conversion value – Calculates the average conversion value per order

Max CPA (cost per acquisition) – The formula here involves multiplying your average conversion value by your profit margin. For example, your profit margin is 30% (0.30), you need to change the formula to L2*0.30, and just drag it down so all the data in the Max CPC column will also update using the new profit margin you’ve set.

This is the maximum amount you are willing to pay for a customer. If you pay one cent more than the amount you’ll get here, then you’re losing money.

New Max CPC – This column tells you exactly how much you want to bid per click just to break even.

We’ve specifically set up these columns using formulas to calculate all the different values you’ve entered in the template. Basically, what you need to do here is find the balance between the volume of clicks and profitability of clicks in your Google Shopping campaigns.

It's this beautiful elastic little seesaw, where as a Google Ads manager, you're basically changing your bids to find out when you can increase your bids to make your campaigns more competitive in the Google Ads auction.

Increasing your bids will result in your ads getting more volume of clicks, because you’re showing for more impressions and you're beating out the competition. But if those clicks cost too much, then you're losing money because your profit margins on those orders go down.

You can have a thousand orders and make $2 per order ($2,000), or you could have a hundred orders and make $30 per order ($3,000). So that’s $3,000 in profit versus $2,000 in profit. What's changing there is the volume and the profit per conversion.

Bid Smart, Bid Profitably

This free Google Shopping Ads bidding template offers you with very useful data that tells you how to beat out the competition in Ecommerce. You competitors are not doing it this way. They just set up their account, leave it, and don't even go into the technical details I’ve shown you here. But now, you have full access to this template that’s going to massively help you scale your campaigns.

Using this template, you can now look at your bidding strategy from a profit perspective, and that's when you can really have some fantastic results in your campaigns.

However, this strategy is not something you just do once. You want to keep doing this AdWords bid management process on a regular basis. It really depends on how much data is generated in your account, but I recommend doing this process every two or four weeks, or once a month.

Always keep an eye on your account and monitor it on a regular basis to see how it's actually performing after implementing all the changes. This is quite an advanced in-depth Google Shopping bidding strategy. But our team of Google Ads experts here at Key Commerce used it so many times in Google Shopping to manage the bids, especially before we changed to automated bidding at the very start of the campaign.

Share this article:

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

'How To Write Successful
Google Ads'

Google Ad Ebook Cover
We are committed to protecting your privacy, as described in our Privacy policy.
Sam single blog pages

I hope you enjoy reading this article.

If you want us to help you scale up your ecommerce business, book a free strategy call.

Subscribe to Our Newsletter to Improve Your eCommerce Digital Marketing!

Thank you for your interest in our newsletters. We will send you only the most important news and updates. No spam, we promise.

We are committed to protecting your privacy, as described in our Privacy policy.

What’s your goal today?

1. Hire us to grow your ecommerce store

We’ve generated millions for our clients, using the methods we’ve developed over years with a singular focus on Google Ads for ecommerce. To discover how we can help grow your business:

Claim your FREE website strategy session with one of our renowned experts.

2. Learn & develop your ecommerce skills

Watch our highly regarded YouTube channel, followed by over 23,000 store owners and ecommerce learners from around the world.

You can also subscribe to our weekly email newsletter to get real-world tested growth and optimization strategies, as well as notifications on anything you may need to know as an ecommerce store owner.

Browse our blog, written and structured to be the best resource in the world for anyone starting and growing their online store. It includes strategy guides, setup instructions, checklists, and tools.

Explore our KeyCompendium, which is a comprehensive wiki of digital marketing terms. Many readers have commented on the usefulness of this content.

3. Join our team

If you want to join our team—or discover why our team members love working with KeyCommerce—then see our “Careers” page.

4. Contact us

We help ecommerce store owners around the world, so get in touch!