Opinions expressed in this article are those of the sponsor. Search Engine Land neither confirms nor disputes any of the conclusions presented below.

Smart Shopping Campaigns: How SEA specialists score with new insights

Focus on cross-sell, upsell and other valuable insights.

Chat with SearchBot
Total Sales From Advertisements 1920x1080

In our last article, we’ve told you that by including both ROAS and new POAS objectives, you can steer on net margin, turnover, or both, depending on what fits the KPIs of your organization. Google recommends creating Smart Shopping Campaigns based on margin%. The most important thing is that you base this gross margin% on the orders resulting from the product’s advertisement.

The product you advertise on is not always the product you sell. You can optimize campaigns by adjusting your bid or target in advance and better managing your purchasing department.

Optimize Google Smart Shopping

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.

Suppose you want to continue to perform optimally and stay one step ahead of the competition. In that case, Search Engine Advertising (SEA) specialists will need to focus more on other elements, such as focusing on optimization that is based on sales and product insights.

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

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 great importance.

Product advertising contribution model

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

Product Advertising Contribution Model Dollar 600x500

In the above collection, guitar A (Fender) and D (Yamaha) 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 incorporates the cross-sell conversion value. If guitar B ($144) is bought by the advertisement of guitar A ($265), the conversion value in Google Ads is $144. 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 Advertisment Dollar 650x400

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, you will see that a low ROAS target is 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 the 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, you could also test your own made category of products as a starting point. For example, do you suspect that your advertisements of sneakers over $120 often lead to purchasing certain B-brand sneakers of around $80? Or alternatively: might it be good to test this?

A clear overview of cross and upsells

So how do you get clear overview in this jumble of connections? Search automation software can give you a clear overview. In the dashboard below, you can see the cross and upsell information for the product “Classical Guitar Blue.” As you can see in the blue box, the direct advertising contribution is $585.80, which is low compared to the more than $2600 coming in from cross and upsell products. So even if the “Classical Guitar Blue” itself doesn’t sell very well, it will be still important to advertise on it. In the yellow box at the right, you can see the best cross-sell and upsell products for the advertisement of this guitar. The dashboard allows you to check these facts and figures for each product you advertise on. In the near future, in this dashboard, there will be an automatic overview of your products that lead to the most cross and upsells.

Cross Sell Image Dashboard Adchieve

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:

Weighted Availability1
Weighted Availability 2

Suppose that a company purchases sizes XS, S, M, L and XL 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. As you can see in the first image above, the weighted product availability will be only 35%, because 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.

Looking at the second example: if sizes XS and XL are in stock, this will have much less negative influence because the weighted product availability will be 85%. The difference compared to situation 1 is, therefore, significantly large. With insight into the weighted product 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 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 a program where you can process more data, like with a script in R or Python is preferable.

However, you can also easily display the above insights in PPC management software in a clear dashboard by product, category, brand or total. This is where you can check our Adchieve Insights features: Adchieve Insights solution – advertising automation at its best.

We also invite you to follow the Adchieve Linkedin page for more advertising knowledge.


About the author

Sponsored Content: Adchieve
Adchieve offers a world leading and award winning PPC management/search automation tool, making large scale advertising easy and effective by using a unique combination of data science, smart people and automation. The software enables advertisers to steer on KPIs and results from advertisements on Google or Facebook and on Marketplaces such as Amazon. Adchieve is known for their expert team of writers that publishes world leading knowlegde and content about search and advertising. Adchieve works together with customers that offer a large and varied assortment and want to stay ahead of their competitors.

Get the must-read newsletter for search marketers.