How to Add Product Groups to Intelligems Analytics
Last updated
Last updated
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 tab in the Analytics Dashboard. Follow these steps below to set up Product Groups.
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)
Keep in mind that in the Intelligems app, this data will be visualized as a stacked bar chart. Avoid creating too many groups to keep the data readable on this chart.
You can also export the data and analyze in Excel or your preferred data visualization tool.
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. See more here for the analytics included under the Product Group tab.
