Shopify analytics.

Percentage of your sales that is profit (factoring in cost of goods sold)

Average value of orders placed, excluding any post-order adjustments

Number of orders placed

Amount customers spent in your store (subtotal, discounts, taxes, fees, shipping, duties, returns)

Average lifetime spend for customers who ordered on each day

Number of customers who placed an order

Unique customers per day (helper for per-customer metrics)

Number of new customers who placed an order

Average lifetime order count for customers who ordered on each day

Percentage of returning customers relative to all customers who placed orders

Number of returning customers who placed an order

Sum of each active customer's lifetime order count (helper for orders_per_customer)

Sum of each active customer's lifetime total spent (helper for amount_spent_per_customer)

Cost of goods sold for returned items (by order date)

Cost of goods returned by refund date (positive)

Direct cost of goods sold, net of returns (blended: original - returned, matches Shopify)

Cost of goods sold by order date (before returns)

Amount discounted from sales revenue

Value of discounts on gift card sales (negative numbers)

Gift card sales revenue, before discounts and returns are factored in

Gift card sales revenue, discounts and returns factored in

Taxes for sales of gift cards

Amount of payments before any refunds

Sales revenue minus the cost of goods sold

Amount of payments after any refunds

Net sales for items with cost data, net of returns (blended: original - returned, matches Shopify)

Number of orders associated with payment transactions

Amount of refunded payments

Amount discounted by shipping-specific discounts

Tax on shipping charges (blended: original + returned, matches Shopify shipping_charge_taxes)

Original shipping tax (before returns)

Shipping tax refunded by refund date (negative)

Number of successful payment transactions

Taxes for the given sale

Taxes for the given sale, excluding those from gift cards

Average hours from first marketing touchpoint to order placement

Average number of marketing interactions before a customer places an order

Number of orders attributed to the first marketing touchpoint

Orders attributed to first touchpoint in customer journey (all traffic sources, not just campaigns)

Sales attributed to first touchpoint in customer journey (all traffic sources, not just campaigns)

Orders attributed to last touchpoint in customer journey (all traffic sources, not just campaigns)

Sales attributed to last touchpoint in customer journey (all traffic sources, not just campaigns)

Number of orders that had multiple marketing touchpoints before conversion

Number of orders that have customer journey tracking data

Number of orders completed in the same session as the first visit

Sum of hours from first touchpoint to order, used for calculating averages

Sum of marketing touchpoints across all orders, used for calculating averages

Average number of days from order placement to shipment

Number of days in the query period (from dim_date)

Forecasted number of days of inventory remaining

Value of discounts you got back from returns

Value of discounts recovered from returns, aggregated by original order date for cohort analysis

Physical units available at end of period (excluding committed and incoming)

Value of all units in inventory at the end of the given period, based on their retail price

Inventory units at the end of the given period

Value of all units in inventory at the end of the given period, based on their cost

Fulfillment rate (units fulfilled / units ordered)

Value of returns, before discounts are factored in

Return value before taxes and shipping adjustments, aggregated by original order date for cohort analysis

Percentage of SKUs that have inventory available

Number of unique SKUs with inventory greater than zero

Units reserved for unfulfilled orders

Units expected from purchase orders or transfers

Quantity of inventory units sold in a given period

Number of orders fulfilled in the selected time period

Percentage of SKUs with zero inventory

Number of unique SKUs with zero inventory

Percent of inventory sold during the given period

Number of items returned for the given sale

Number of items returned, attributed to the refund date (matches Shopify)

Ratio of items returned to items sold (refund-date returns / order-date sales)

Sell-through rate during the given period

Number of unique shipments

Quantity shipped between locations

Original shipping charges (before returns, after discounts, excl tax)

Value of shipping charges refunded to the customer

Shipping charges refunded, aggregated by original order date for cohort analysis

Inventory units at the start of the given period

Value of taxes refunded to the customer

Tax amount refunded on returns, aggregated by original order date for cohort analysis

Sum of days from order to shipment, used for calculating averages

Amount returned (subtotal, discounts, shipping, fees, taxes)

Total return value including product, tax, and shipping, aggregated by original order date for cohort analysis

Total number of unique product variants being tracked

Number of shipments that include tracking information

Percentage of orders with a valid tracking number

Additional fees charged on orders (e.g. handling, gift wrapping)

Number of orders with discounts applied

Import duties charged on orders

Sales revenue, before discounts and returns are factored in

Number of items in the given sale, with returns factored in

Sales revenue, with discounts and returns factored in

Net sales with returns deducted, aggregated by original order date for cohort analysis

Net sales for items with cost data, by order date (before returns)

Net sales returned for items with cost data, by refund date (positive)

Number of orders from first-time customers

Number of orders from customers who've bought from you before

Average number of items per order

Amount customers spent on shipping (blended: original + returned, matches Shopify)

Refund-date total returns for first-time customer orders

Refund-date total returns for returning customer orders

Total sales including taxes and shipping, aggregated by original order date for cohort analysis

Amount new customers spent in your store (subtotal, discounts, taxes, fees, shipping, returns)

Amount returning customers spent in your store (subtotal, discounts, taxes, fees, shipping, returns)

Order-date total sales from first-time customers (before returns)

Order-date total sales from returning customers (before returns)

Amount customers spent on shipping

Total quantity of items sold (gross, before returns)