Shopify — data fields

Orders, revenue, discounts, tax, shipping and refunds. Every field id you can pass to fields= in the API, Looker Studio, exports and AI chats. Shared ids line up across sources so they blend.

All sources Meta Ads (Facebook & Instagram)Google Ads TikTok Ads LinkedIn Ads Google Analytics 4 Google Search Console Facebook Pages (organic)Instagram (organic)YouTube Analytics Shopify WooCommerce Klaviyo

Field id	Name	Kind	Type	Description
`account_id`	Account ID	dimension	string
`account_name`	Account name	dimension	string
`conversions`	Orders (as conversions)	metric	integer
`currency`	Currency	dimension	string
`customer_id`	Customer ID	dimension	string
`datasource`	Data source	dimension	string	Connector the row came from
`date`	Order date	dimension	date
`discounts`	Discounts	metric	currency
`financial_status`	Financial status	dimension	string
`fulfillment_status`	Fulfillment status	dimension	string
`items_sold`	Items sold	metric	integer
`net_revenue`	Net sales (total - refunded)	metric	currency
`order_id`	Order ID	dimension	string
`order_name`	Order number	dimension	string
`orders`	Orders	metric	integer
`refunds`	Refunded	metric	currency
`revenue`	Total sales	metric	currency
`sales_channel`	Sales channel	dimension	string
`shipping`	Shipping	metric	currency
`subtotal`	Subtotal	metric	currency
`tax`	Tax	metric	currency

Date parts

Available on any source with date. Metrics are re-aggregated to the period.

weekWeek (starting Monday)year_weekYear-week (2026-W42)monthMonth (2026-10)quarterQuarter (2026-Q4)yearYearday_of_weekDay of week (Mon..Sun)

Calculated metrics

Computed after aggregation wherever the inputs exist.

roasrevenue / nullif(spend, 0)cpaspend / nullif(conversions, 0)conversion_rateconversions / nullif(clicks, 0) * 100aovrevenue / nullif(orders, 0)

Filters

Pass JSON in filters=:

[["spend","gt",100],"and",
 ["campaign","contains","brand"]]

Operators: eq, neq, gt, gte, lt, lte, contains, ncontains, null, notnull, in.