Assortment Analytics with Google - Optimize your product assortment with the help of Google’s Merchant Center

Assortment Analytics is an open-source solution to help you optimize your product assortment in terms of:

1. Product and brand popularity
2. Gaps in your product and brand coverage
3. Product pricing

Prerequisites

• Access to BigQuery’s graphical user interface
• Access to Merchant Center product feeds

How-to setup (step-by-step guide and how-to videos available here)

1. Copy, adjust and execute the SQL scripts provided in this repository.
2. Create a copy of the following dashboard template.
3. Adjust the dashboard’s existing data sources with your newly created tables.

Done.

Authors

• Tim Hausweiler, Marius Busen & Till Dietrich

For questions, please reach out to mango-analytics-dev@google.com.

Licensing

Terms of the release - Copyright 2021 Google LLC. Licensed under the Apache License, Version 2.0.

This is not an officially supported Google product.