This article includes standard dimensions and metrics for Shopify data in the Sellforte Marketing Mix Modeling (MMM).
1. Order-data
Dimensions | Metrics |
Date Store ID Store name Order ID Order name Order created date Order closed date Order cancelled date Last order created date Account created date Shipping province Shipping country Shipping description Channel Channel (App name) Currency Discount reason Is returning customer UTM medium UTM source UTM campaign name Country Country code | Gross sales Discounts Returns Net sales Shipping Tax Total sales Items Orders Cost of goods sold Gross profit |
2. Item-data
Dimensions | Metrics |
Date Store ID Store name Order ID Order name SKU Product ID Product title Vendor Type Line item ID Line item type Currency Country Country code Price | Gross sales Discounts Returns Net sales Shipping Tax Total sales Items Cost of goods sold Gross profit |