0405123696 petra@web-data-analytics.com

For a while I have been wanting a report that shows me how my ecommerce clients rank against their competitors in Google Shopping campaigns, on a per product basis.

Unfortunately product data and much of the competitive data can’t be automatically pulled into Google Data Studio from Google Ads (I have no idea why). 🤔

So today I had a little time up my sleeve and I whipped up this beauty using data manually imported from Google Ads, plus a bit of data analyst magic.

The report tells you exactly which Product Titles were relatively more or less competitive in the Google Shopping marketplace.

Basically the column titled Relative Attractiveness against Competitors will be a dark colour if you’re doing well, and a light colour if you are not doing so well. If you rank them by revenue, you’ll want to work on your least competitive, high revenue products. These are your low-hanging fruit.

Google Ads Shopping Campaign Product Competition › Google Ads Shopping Campaign Product Competition

I really like this report, because it lets you immediately see which products you need to work on. Once you have many SKUs in your shop it can become overwhelming to work out where to start with regards to improving text, images, titles, offers, sales and the like.

The key metric here is the one I have named Relative Attractiveness Against Competitors.

Low numbers indicate your competitors offerings were more attractive to the user, whereas high numbers mean that yours came up trumps. The metric is a combination of Click Share and Search Impression Share.

Do you sell products through a Google Ads shopping campaign? If you do I can create this report for you too! Contact Me.

Share this article!

SleepWise Clinic

Petra was instrumental in pulling all our clinic's web analytics into one easy to read, dynamic report that's accessible to me at any time, and works with our EXACT booking system.

This has allowed me to see, at a glance, what marketing initiatives are working, need tweaking, or changing altogether, saving me both time and money. I can't recommend her or her analytic services enough.

Ian Gale SleepWise Clinic Strategy Session August 1, 2018

shares