How to Add Profit to Intelligems Analytics
Provide cost of goods sold (COGS) data to Intelligems to track profit.
Background
While top-line metrics such as conversion and revenue are possible for us to track "out of the box", additional cost data is required to measure profit.
There are two ways that you can provide COGS information to Intelligems, both found on the Settings page of the Intelligems app.
Option 1: Automatic Management
If you include your COGS information in Shopify and don't need to make any changes to it before uploading to Intelligems, this is your best option. We will pull in all COGS that you have in Shopify when you click this button, and you can toggle on a daily update as well. Note that you can still set values for your average shipping / fulfillment cost per order and transaction fee percent within the manual section if you choose this option. Also note that if you choose this option, any manually defined Product Groups in your COGS upload will be ignored.
Option 2: Manual Management
If you do not include your COGS information in Shopify or would like to make any changes to how it is uploaded to Intelligems, this is your best option. Follow the steps below to upload COGS using this method.
Step 1: Determine what cost structure best aligns with your store or business model
We have two options for how we incorporate the cost of shipping and fulfillment:
Option 1: Include the cost of shipping and fulfillment in COGS for each product variant. For example, Product A has COGS of $5, including shipping and fulfillment
Option 2: Exclude the cost of shipping and fulfillment from product cost and, instead, factor it in at the order level. For example, Product A has COGS of $3, Product B has COGS of $4 and each order costs $10 to ship and fulfill. If this reflects the way your store accounts for COGS, please include the shipping and fulfillment cost per order in the body of the email you send to Intelligems with your COGS data
Incorporating other cost models will require custom analyses outside of the Intelligems analytics product. Such analyses may be possible using our data exports. Please reach out to support@intelligems.io if you have questions around this.
Step 2: Download the COGS template from the Intelligems App
You can find this in the Settings tab. When you click "Download Template", you will see the download process at the top of the page. Once it is processed, click "Download" and open the file in a spreadsheet editing tool.
Step 3: Using a spreadsheet editing tool, populate the 'cogs' column
The file will download as an .xlsx file, but you'll need to save it as a .csv file to upload it.
Input COGS information into the cogs column for each product and variant. This information may already be filled out if your COGS is up to date in Shopify! Feel free to edit as needed.
A few notes as you do this:
Formatting Product and Variant IDs
Before saving your file, convert the productId
and variantId
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.
Pulling data from your own datasets
If you keep COGS data in a separate spreadsheet, we recommend copying that spreadsheet into the download from Intelligems. There are several fields (product_id, variant_id, SKU, etc.) that you can use to pull in existing COGS data. The example below shows how you could use an Excel formula to add COGS data from a source that contains COGS by SKU. In this example, column B of the COGS Data Source
tab (not pictured) contains SKUs and column C contains COGS corresponding to those SKUs. In this case, the COGS for SKU-38 is $5.00.
The formula in cell M39 above is:
We recommend including COGS for all products on your store, even if they're not part of the test. Providing COGS for only some products may result in overstated profit for the products with missing COGS information.
Step 4: Save your file and upload it to Intelligems
Once you have added all data and converted the productId
and variantId
columns, save your file. See below for a list of best practices to keep in mind when saving your COGS files:
A file saved with a .csv extension will automatically convert any numbers in scientific notation to rounded numbers and cause information to be lost. To prevent this, be sure to convert all numbers from scientific notation to unformatted numbers (i.e. 12345678890) before saving a document as a CSV
If you're working from a spreadsheet that has multiple tabs, it cannot be saved as a CSV. You'll need to start a new file with only one tab and save that to a CSV
Once you have saved your file, head back to the settings tab in the Intelligems app. Select the button to 'Upload COGS' and upload your file.
If you have chosen to incorporate shipping and fulfillment costs at the order level, you can also input your average shipping and fulfillment cost here. If you have chosen to include that cost at the product level in your COGS download, you can leave this field blank. You can also add a transaction fee percentage if you would like to include that information in the profit analysis.
Step 5: Analyze profit results in the Intelligems app
Profit data will be available 1-2 hours after you have uploaded it, and will apply to test results retroactively!
Once the data has been uploaded, you will see a 'Profit' tab under the Analytics menu for your experiments. You'll be able to track the experiment's measurement of profit per site visitor and profit per order. See more here for the analytics included under the Profit tab.
Last updated