Bundles are a great way to drive up AOV. But can be annoying as hell when analyzing your data.
How many hours have you wasted breaking up bundles into individual products to provide the OPS team with a demand forecast or understand user journeys?
โ
With our new ๐จ๐ป๐ฏ๐๐ป๐ฑ๐น๐ถ๐ป๐ด ๐๐ฒ๐ฎ๐๐๐ฟ๐ฒ in Klar, this happens automatically.
โ
Once bundles are configured, you can look at your data in a bundled AND unbundled state.
For all the details, watch this quick video below ๐
Here is how it works:
Create the Bundle datasource in one of your stores and open it.
Add the Variant ID of the bundle in the first column.
Add the Variant IDs of the products that are part of the bundle in the second column and separate them with a comma.
Make sure to use the actual variant IDs instead of the product IDs in Shopify!
โ
We'd recommend using the description column to write down the bundled product and the unique product variants inside that bundle, as the variant IDs are not really identifiable making it harder to understand what you have set up in the future.
For Shopify, you can find the variant in the URL of the product (see screenshot):
That's it. You can now use the dimensions Product Title & Variant (Unbundled) and Product SKU (Unbundled) in the Revenue & Profit Flex Table.
โ
Here are also two advanced aspects that make the Unbundling feature awesome ๐
โ
1๏ธโฃ Revenue Splitting
In the Bundle datasource, you can define if you want to distribute the revenue of the unbundled product equally, based on their price, or set a custom logic.
โ
2๏ธโฃ Match Products
You can not only use it to unbundle products but also match the same products onto each other.
Many brands have dirty product catalogues with the same product being in there multiple times which makes analyzing data hard. This fixes it.
โ
With Klar, we work on all the little things that make eCom data messy and build solutions to fix them. Without the need for a full BI team.
Check if your bundles are set up correctlyโ
Go to the Revenue & Profit Flex Table.
Set the first dimension to the "Product & Variant" title
Filter for the name of the bundled product.
Note down the number of gross units sold for later.
Now set the Product Display to "Unbundled". The bundled product should completely disappear.
Afterwards, set the product display back again to "Bundled".
Now filter for one of the unique product variants inside that bundle. Note down the number of gross units sold for that product as well.
Now switch the product display back to "Unbundled".
The number of gross units sold should now match the sum of the gross units sold of the bundle and the unique product variant (keep in mind that it could also be a higher number if the unique product is part of multiple bundles).