Google Shopping & the Long Tail: An AdWords Script to Detect Your Budget Eaters

We love Google Shopping and Shopping Ads. We have gained a lot of experience with our customers. Because of that, we realized there is a real paradigm shift with one of the most common definitions in E-commerce. We are talking about the Long Tail.

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 – an AdWords script
  • Introduction how you can use AdWords scripts

Do you remember what Chris Anderson said about the Long Tail? It was 2004 when he wrote 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.”

 

The Long Tail

When it comes to business, the term Long Tail is applied to 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, it can quickly be established that about 80% of the products are responsible for 80% of the revenue here, whereby only one or two conversions are 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.

Where your costs and conversions come from – AdWords scripts

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 an 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 AdWords campaigns, it just analyzes your existing data and provides you with an automatic evaluation. Conversion tracking is a pre-requisite though! 😉

Download script here:

GET SCRIPT

 

How to use AdWords scripts: 

 

Step 1:

Log in to your AdWords 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.

AdWords Script Step 5

 

Step 6:

See your results in Logs.

AdWords Script Step 6

 

You like our script? There is something else you want to let us know? Don’t hesitate to write us 🙂