One of our clients struggled with assessing

[nusaiba128]

the effectiveness of the carousel of recommended products on product pages. This type of solution on the website is really great for users - I know because I bought many things online thanks to the recommended products. BUT! Choosing which products to put there is a real analytical art. It cannot be based on: "I think" or "maybe now this". It turns out that even monitoring clicks on products does not give the full picture: neither GA4 nor CRM provided information about which products were actually purchased together with the main one.

After analyzing the client's needs, I created a BigQuery implementation vnpay database plan that precisely described the tool's integration and subsequent analysis steps. After two months of working with the data, we discovered that most products that were frequently purchased with the main product either did not appear in the carousel at all or were poorly exposed in it. Such knowledge allows you to do a lot, in this case I proposed moving these "companion" products to a dedicated section under the CTA button on the product page. Needless to say, better exposure affected the average basket value.