Google Shopping & the Long Tail: A Google Ads Script to Detect Your Budget Eaters

 

We love Google Shopping — and we have a lot of experience with it. That’s why we realized quite quickly that there is a paradigm shift regarding one of the most important Google Ads phenomena: the long tail.

 

If you like our budget eater script, check out the other scripts we provide on smarter-ecommerce.com. Have fun!

 

Tl;dr

  • Classic Long Tail approach says that 20% of the products are responsible for 80% of the revenue. The other 80% of the products generate 20% of the revenue.
  • SEA experts argue with the classic Long Tail.
  • We conducted our own analysis to test the SEA experts’ statement
  • Where your costs and conversions come from – a Google Ads script
  • Introduction how you can use Google Ads scripts

 

The Long Tail

 

Do you remember what Chris Anderson said about the long tail? It was 2004 when he wrote in an article for wired: “Forget squeezing millions from a few megahits at the top of the charts. The future of entertainment is in the millions of niche markets at the shallow end of the bitstream.” When it comes to the Google Shopping business, the term long tail implies rank-size distributions and rank-frequency distributions. In general, the classic long tail approach says that 20% of the products (top sellers) are responsible for 80% of the revenue. The other 80% of the products generate 20% of the revenue.

 

Long Tail vs Short Head

 

Many online retailers and SEA experts argue with the classic long tail approach — but if you observe the revenue generated from Shopping ads, you can quickly find that about 80% of products are responsible for 80% of the revenue here, whereby only one or a maximum of two conversions is associated with each individual product.

long tail vs short head new

 

To prove this statement, we analyzed 246 accounts with surprisingly similar results: Up to 70% of costs accrued in Google Shopping derive from articles with as few as 0 conversions, while up to 80% of the revenue is generated by Long Tail products with just 1 or 2 conversions per month.

Long Tail Google Shopping

 

Many people follow their gut feeling and drastically reduce the CPC for articles with few conversions or completely remove them from their campaigns – but is this the best approach? Most likely it isn’t. Articles which only accrued 0 or 1 conversions during the last month might have the potential to generate more conversions during the coming months. Missing this potential could be fatal as these articles in total generate 80% of the turnover.

Our data scientist Thomas Otzasek wrote an article with the title Avoid Common ROAS Optimization Pitfalls In Google Shopping.

 

Questions? Don’t hesitate to contact us!

Contact our Team

 

Script: Where costs and conversions come from

 

In order to give you an impression of the correlation between costs, conversions and the Long Tail within your own account, we sat down and wrote a Google Ads (AdWords) script for you. This script will evaluate the Long Tail and the Non-Converters from the last 30 days. The code won’t change anything about your Google Ads campaigns, it just analyzes your existing data and provides you with an automatic evaluation. Conversion tracking is a pre-requisite though!

 

How to use Google Ads scripts: 

 

Step 1:

Log in to your Google Ads Account (the one with your Shopping campaigns). Click on bulk operations > Scripts

AdWords Script Step 1

 

Step 2:

Add a new script.

AdWords Script Step 2

 

Step 3:

Authorize the new script.

AdWords Script Step 3

 

Step 4:

Allow script to use your information.

AdWords Script Step 4

Step 5:

Delete the existing code and copy the new script. Click on Preview.

Download Script

 

AdWords Script Step 5

 

Step 6:

See your results in Logs.

AdWords Script Step 6

 

If you like our budget eater script, check out the other scripts we provide on smarter-ecommerce.com. Have fun!