Total Amount (Shop Money) by Source [Shopify]

Follow the Metric Recipe below to create the metric Total Amount (Shop Money) by Source from Shopify.

1. Configure the dataset

If you already have an existing dataset, ensure that you have the following views and columns included. Read more about how to create a dataset.

a) Include these columns in the Sales Dataset

b) Include these columns in the Orders Dataset

c) Include these columns in the Sales Agreement Dataset

d) Merge Datasets together

First merge Sales with Sales Agreements:

Then merge the result with Orders:

2. Create the Custom Metric

Navigate to Metric Builder and create a new Custom Metric by selecting the merged dataset created in the previous step. Read more about how to create a custom metric.

Check out the Schema Explorer to learn more about all supported views and columns/properties: https://schema-explorer.databox.com/?integrationkey=Shopify