How to Add Product Groups to Intelligems Analytics
Last updated
Was this helpful?
Last updated
Was this helpful?
By default, analytics will display for all products. For certain tests, it may be beneficial to look at the results for certain product groups, or even get as granular as looking at the results for individual products. To do this, you can use the Product Groups dropdown in the Results dashboard. Follow these steps below to set up Product Groups.
Product groups can be added anytime before or during a test.
This template pulls data from Shopify and includes a list of all products in your store. As the name states, this template is typically used for uploading cost of goods sold (COGS), but it is also used to upload Product Groups. Feel free to upload both COGS and Product Groups at the same time! You can find the template in the Settings tab under your plan options.
When you click "Download Template" you will see the download process at the top of the app. Once it has processed, click "Download" and open the file in a spreadsheet editing tool.
Input Product Group information into the productGroup column for each product and variant. How you set your product groups up is fully customizable. A few common ways we see brands use this feature include:
Creating a product group for each unique product
Creating a product group for each category (e.g. shirts vs pants vs accessories)
Creating a product group for different price or size tiers (e.g. travel size vs. 8oz vs. 32oz)
In Intelligems, product group mix will be shown on a stacked bar chart. Any product group accounting for at least 1% of net revenue will be shown — others will be grouped together as "Other":
Before saving your file, convert the product_id and variant_id from scientific notation to unformatted number notation (No commas, No decimals). Many spreadsheet editors default to scientific notation, but an upload will fail if IDs are not converted.
Once you have added all data and converted the product_id and variant_id columns, save your file as an Excel file (.xlsx). Once you have saved your file, head back to the settings tab in the Intelligems app. Select the button to 'Upload COGS Excel File' and upload your file.
Product Group data will be available 1-2 hours after you have uploaded it.
Once the data has been uploaded, you'll be able to track the experiment's results by product group in the Product Group tab.
You can also and analyze in Excel or your preferred data visualization tool.
