Google Shopping Campaigns: How do SEA specialists score with new insights

With the advent of Google Smart Shopping Campaigns, following the standard Google Shopping, more and more of the insights seem to go away. After all, Automation means becoming more machine-driven, and less control and insight when you run the operation yourself.

If you want to continue to perform optimally and stay one step ahead of the competition, SEA specialists will need to focus more on other elements, such as focusing on optimization that is based on sales and product insights.

In this article, I will explain how to optimize your Google Smart Shopping Campaigns. Depending on your range, you can adjust your offering or targets in advance using insights in cross-sell and upsell and/or custom insights or instruct your procurement department on time.

The advertisement of product A does not lead to the purchase of product A

First, I will briefly go over the way in which SEA specialists view the results of their Google Shopping Campaigns. As a SEA specialist, you probably look mainly at the revenue resulting from advertisements. Most likely you will settle on an ROI or ROAS target.

Because you look at the turnover from orders, you probably never drill down to how the order came about and what has contributed to the order. This is still very important. That which you are advertising is not always what you are selling.

In many cases, more than SEA specialists and online marketers realize, the advertisement of product A does not lead to the purchase of product A. We are talking about more than 50% (!) of sales for some advertisers. Based on the product advertising contribution model, I explain why this observation and insights are of such great importance.

Google Shopping Campaigns & Product advertising contribution model

In the model below, you can immediately see at the advertisement for product A does not always lead to the purchase of (just) product A:

Product advertising contribution model

Notes:

In that collection, guitar A and D are well-known guitar brands. Guitar B, on the other hand, is a private label, but rather similar to guitars A and D.

Because it is likely that when someone buys product A, B or D, these products are often cross-sellers of each other. Product C is a guitar stand. This product is cheaper than A, B and D and is often purchased. It is therefore an upsell product.

If product A is used as a marketing content and only product A is purchased, we call this direct advertising contribution. If by advertising product A, product A and product C are purchased then product C falls under the upsell of product A.

If you reach product B through the marketing of product A and buy only product B, Then we are talking about cross-sell.

From a different angle: The number of times product A is purchased from the advertisement of product D, we refer to it as indirect advertising contribution. In this case, product A can also be called the cross-sell of the product D ad.

Margin and inventory: important cross and upsell insights

A critic will say: why are these insights interesting? After all, the conversion value that you see in Google Ads already incorporate the cross-sell conversion value, because if guitar B (144 euros) is bought by the advertisement of guitar A (265 euros), the conversion value in Google Ads is 265 euros. So, the cross-sell conversion value is already in Ads.

However, what is not included here are the margin and the impact of a product being (possibly) out of stock.

Why are these cross- and upsell insights such as margin and stock important?

The right products in stock

Suppose product A generates much cross-sells but of itself is not sold very much. If product A is no longer in stock – and therefore product A is no longer advertised – the cross-sell products of product A are likely to be sold less. It is therefore important that product A is kept in stock.

The right target at the right margin

Suppose product A has a low margin, but almost only cross-sell products with a large margin are sold through the product A advertisement. In that case you would want to adjust your ROAS target accordingly.

How does this work? I will explain based on the calculation example below, for which I will use the guitars once again:

Total sales from advertisement

As you can see, the advertisement of guitar A often leads to guitar B sales which has a higher margin. If you “merely” assume that the advertisement of guitar A leads to the sale of guitar A, then you would set a high ROAS target for it, because the margin is small.

If you consider sales insights and know that the advertisement of guitar A often leads to the sale of guitar B, then you will see that a low ROAS target is actually much more appropriate.

The same goes, of course, for upsells, for which the margins differ a lot from the product being advertised. With the above cross and upsell insights, you can now reach the right targets.

It would be even smarter to work towards POAS target, by which you look not only at the (“misleading”) revenue, but at the total profitability of an advertisement.

Hypothesis testing with specific categories/variables

Following the examples above: as a starting point, you could also test your own made category of products. For example, do you suspect that your advertisements of sneakers over 120 euros often lead to the purchase of a certain B-brand sneakers of around 80 euros? Or alternatively: might it be good to test this?

Size insights: link your stock to your size chart

If we look at the clothing industry – or other industries that sell products in multiple sizes – size insights are also interesting. People often do not look specifically for a product size but come to you for one of the sizes.

An overview of the sizes sold in the past, for example by product, by brand and/or by product type, we also call a size chart. If you link it to the current stock of a product, you come to an interesting insight: the weighted availability. It expresses as a percentage for how many buyers the matching size is in stock. 

The size chart in combination with the weighted availability looks like this:

Gewogen beschikbaarheid laag

Notes:

Suppose that sizes XS, S, M, L and XL are purchased from the clothing item above. In the past, size XS 10%, S 25%, M 40%, L 20% and XL 5% have been sold.

If sizes XS, L and XL are available, but sizes S and M are out of stock, sales performance is likely to decline. 65% of sales relate to a product in size S and M. If the sizes XS and XL are sold out, this has much less impact on sales performance.

In the image above, the weighted availability in the first example is much lower than in the second example. The sizes XS and XL in stock, in the second example, have much less influence. The difference in weighted availability is therefore significantly large.

With insight into the weighted availability, you can optimize the advertising correctly, for example just for the remaining sizes, and/or adjust your procurement.

Customize your offer or target with the right insights

Depending on which industry you operate in, the above insights can help you optimize your campaigns. By optimizing I mean adjusting your offer or target in advance and/or managing the procurement department better.

In any case, you need to be able to work well with data in order to be able to reach such insights. For small data sets you could do the above in Excel, but I prefer a program where you can process more data, like with a script in R or Python.

However, you can also easily display the above insights in PPC management software in a clear dashboard by product, category, brand or total.

Do you have any questions, comments, tips or tricks? Then I’d love to hear from you.

Read more interesting content about Google (Smart) Shopping