How to Add Profit to Intelligems Analytics

Provide cost of goods sold (COGS) data to Intelligems to track profit.

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.

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.

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.

Manual Management 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 under your plan options. When you click "Download COGS Template, you will see the download process at the top of the app. Once it is processed, click "Download" there and open the file in a spreadsheet editing tool.

Step 3: Using a spreadsheet editing tool, populate the 'cogs' column

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 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.

Formatting IDs in Excel

In Excel, choose "Number" formatting, and then remove the decimal places.

The ID should look like: 10732173902

Formatting IDs in Google Sheets

In Google Sheets, choose "Plain Text" formatting.

The ID should look like: 10732173902

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:

  =INDEX('COGS Source Data'!$C:$C,MATCH(E39,'COGS Source Data'!$B:$B,0))

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 product_id and variant_id 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 convert any numbers in scientific notation to rounded numbers and cause information to be lost. Be sure to convert all numbers from scientific notation to unformatted numbers (i.e. 12345678890) before saving a document as a CSV.

  • A file with multiple tabs cannot be saved as a CSV. If you added a second tab to your file, consider saving the file in another format that allows for multiple tabs, like .xlsx.

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.

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