Turn Browsers Into Buyers

How to calculate Google Seller Ratings’ effect on CTR for Google Ads

Friday, April 20, 2018
How to calculate Google Seller Ratings effect on Adwords CTR

In case you missed it, the powerful search marketing effects of Google Seller Ratings (GSRs), are now available in all markets. This means companies across the globe can take advantage of the benefits GSRs provides in search marketing efforts.

Google states Seller Ratings can boost your text ads’ CTR by up to 10% which can make a big difference to any company battling with their competitors on Google ads.

For an optimized Google Ads campaign running with a decent budget, just increasing the CTR 1% can generate a lot of money in additional revenue and can also lead to significant savings when Google’s bill comes around.

In this guest post, Thomas Fogt, Product Marketing Manager and Søren Sieg Jensen, Partner and CTO of Cykelpartner, will walk through a how-to on calculating the effect of Google Seller Ratings on Gooogle ads CTR. You can learn more about how Cykelpartner used Trustpilot to reduce their CPA in Google ads here.

What are Google Seller Ratings?

Google Seller Ratings showcase advertisers with high ratings (above 3.5 stars) aggregated by Google from reputable business review sources. Here’s an example below.

Trustpilot for Google Seller Ratings

Google Seller Ratings are displayed in text ads in Google ads, Search Network campaigns, and on Shopping Ads in Google Shopping.

Read more about Google Seller Ratings in our support article here.

How effective is Google Seller Ratings for your company?

A 10% increase in CTR is quite the increase so the question is - will you get this amazing 10% CTR increase too? How can you track it? What effect can you expect to get?

We worked with Søren from danish Cykelpartner.dk to calculate and track the effect of GSR on their Google ads.

After some hours trying different things, scratching our heads, and playing around with Excel, we found an easy way to calculate it!

We put this how-to-guide so you can calculate how Google Seller Ratings affects your Google ads performance.

1. Ensure you have Google Seller Ratings

If you have Seller Ratings, reviews will show when you insert your domain address (no www.) below:

https://www.google.com/shopping/seller?q=YOURDOMAIN.COM .

Please note: This page will be blank until you qualify for Seller Ratings.

Learn how to get them here.

2. Select a campaign in Google ads


3. Click the tab “Ad Extensions”


4. Click “AUTOMATED EXTENSIONS” and look for “Seller Ratings”


Not all campaigns will have Seller Ratings so if you can’t find it on one campaign, try and check another.

5. Data clean up: Separate ads with and without Seller Ratings

The overall campaign data contains a mix of data from ads with and without Seller Ratings so you should use a spreadsheet to calculate the difference between the two ads.

We provided a free template for you to use to calculate your GSR performance:

Type the data from your “Total - all ad groups” into the top row:

Separate ads with and without Seller Ratings

Type the “Seller Ratings” data into the Seller Ratings row.


The spreadsheet will automatically calculate the data from ads without Seller Ratings, the difference between the ads with and without Seller Ratings and ultimately Seller Ratings effect on your ads.

Please note: Our spreadsheet and how Google ads calculates eg. CTR, CPC, Conversion Rate and CPA can differ slightly as the tools use different amounts of decimals when making the calculations. So please expect minor discrepancies when comparing to the Google ads numbers as below.

6. First results

download (7)

So on this specific campaign Cykelpartner.dk saw their CTR decrease 4.45% and CPC increase 7.04% which of course isn’t what we expected nor wanted to see when Google states they can improve CTR up to 10%. As expected, one company’s experience can be massively different compared to an average.

However, more importantly, their Conversion Rate jumped a massive 34.66% resulting in a substantial overall 20.51% decrease in Cost Per Conversion/Acquisition (CPA) the ads with Google Seller Ratings - which is what you should focus on.

Ultimately Google Seller Ratings provided Cykelpartner.dk an average 11.42% decrease in CPA and saves them more than €40.000/yearly!

7. Time to calculate your effect!

We strongly recommend you enter data from 5 different campaigns to get an average that can be used to calculate the effect on your Google ads based on your yearly spend for that channel.

The spreadsheet will automatically calculate if you input your yearly Google ads spend in the bottom of the spreadsheet.

Please note: If you see a positive number, it means Seller Ratings are saving you money. If you see a negative number, then it means it is costing you money.

If needed, there’s an example in the bottom showing how you should fill the data in correctly.

Accounting for differences in campaign results

Cykelpartner.dk saves +€40.000/yearly with Google Seller Ratings. But what if you have different results, or worse, negative results? Not to worry, here are a few tips to ensure you’re tracking everything correctly:

  • Have you looked across a representative number of campaigns for your account? For some 5 campaigns is not enough as results can vary greatly and some might have a negative impact but overall it should be positive.
  • Know your competitive environment. Do your competitors have better Seller Ratings and more reviews than you?
  • Did your avg. ad position drop on your ads with Seller Ratings? This can, of course, affect the ad performance.
  • Consider whether Google Seller ratings are right for your company. They might just not work for your business, industry, Google ads setup, bidding structure etc. Because Google Seller Ratings are an automated extension, you need to disable them if they are producing negative results. See how here.

Making the most of Google Seller Ratings

Consumers have an abundance of choice today and it requires quick decision-making and adapting to a new consumer environment for businesses. If your competitors have a better Seller Rating and/or more reviews than you, they might be beating you to the sale. If that’s the case, the way to get ahead to get more reviews and a better rating by improving your review collection and your service.

Most businesses have an abundance of happy customers but they don’t proactively invite all customers to leave a review of them on a Google Seller Rating qualified platform.

Proactive collection will lead to a higher quantity of reviews and offers a better representation of your company. Remember, an unhappy customer will always find a way to make their voice heard so it’s up to you to make sure you’re giving your happy customers a platform as well.

Reviews aren’t only beneficial for your potential customers - as many of our clients have realized, reviews power benefits like Google Seller Ratings that can accelerate CTR, conversions, and revenue. Reviews can also be used to improve traffic, on-page conversions, and in a number of marketing campaigns. Google Seller Ratings is just the beginning!


Related stories