---
title: "Shopify metrics and dimensions"
slug: "shopify-fields"
description: "Explore the complete list of Shopify metrics and dimensions available through Supermetrics. Find every data field you need to build your marketing reports."
updated: 2026-09-23T11:02:39Z
published: 2026-09-23T11:02:39Z
canonical: "docs.supermetrics.com/shopify-fields"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Shopify metrics and dimensions

> Supermetrics brings all your Shopify data into [Google Sheets](https://workspace.google.com/marketplace/app/supermetrics/523876908005), [Looker Studio](https://supermetrics.com/products/looker-studio), [Power BI](https://supermetrics.com/products/power-bi), [Excel](https://supermetrics.com/products/excel), [BigQuery](https://supermetrics.com/products/bigquery), [Snowflake](https://supermetrics.com/products/snowflake), [Redshift](https://supermetrics.com/products/amazon-redshift), [Azure](https://supermetrics.com/products/azure-synapse)

21 metrics134 dimensionsSearch fields

### CUSTOMER

| \| customer_count \| \| --- \| \| \\| Field label \\| Customer count \\| \\| --- \\| --- \\| \\| Description \\| The total count of the customers \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Customer count \| \| Description \| The total count of the customers \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| --- |
| customer_count |
| \| Field label \| Customer count \| \| --- \| --- \| \| Description \| The total count of the customers \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Customer count |
| Description | The total count of the customers |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

### CUSTOMER DETAILS

| \| customer_id \| \| --- \| \| \\| Field label \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer ID \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| customer_id |
| \| Field label \| Customer ID \| \| --- \| --- \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer ID |
| Description | The unique identifier of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_first_name \| \| --- \| \| \\| Field label \\| First name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| First name \| \| Description \| The first name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_first_name |
| \| Field label \| First name \| \| --- \| --- \| \| Description \| The first name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | First name |
| Description | The first name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_last_name \| \| --- \| \| \\| Field label \\| Last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Last name \| \| Description \| The last name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_last_name |
| \| Field label \| Last name \| \| --- \| --- \| \| Description \| The last name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Last name |
| Description | The last name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_email \| \| --- \| \| \\| Field label \\| Email \\| \\| --- \\| --- \\| \\| Description \\| The email of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| Email \| \| Description \| The email of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| customer_email |
| \| Field label \| Email \| \| --- \| --- \| \| Description \| The email of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Field label | Email |
| Description | The email of the customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| customer_tags \| \| --- \| \| \\| Field label \\| Customer tags \\| \\| --- \\| --- \\| \\| Description \\| The email of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer tags \| \| Description \| The email of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| customer_tags |
| \| Field label \| Customer tags \| \| --- \| --- \| \| Description \| The email of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Customer tags |
| Description | The email of the customer |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| customer_last_order_created_at \| \| --- \| \| \\| Field label \\| Last order created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the last order of the customer was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Last order created datetime \| \| Description \| The date and time the last order of the customer was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| customer_last_order_created_at |
| \| Field label \| Last order created datetime \| \| --- \| --- \| \| Description \| The date and time the last order of the customer was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Last order created datetime |
| Description | The date and time the last order of the customer was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| customer_last_order_created_at_iso \| \| --- \| \| \\| Field label \\| Last order created date (ISO) \\| \\| --- \\| --- \\| \\| Description \\| The date and time the last order of the customer was created in ISO format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \\| Destinations \\| Data warehouse \\| \| \| Field label \| Last order created date (ISO) \| \| Description \| The date and time the last order of the customer was created in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| customer_last_order_created_at_iso |
| \| Field label \| Last order created date (ISO) \| \| --- \| --- \| \| Description \| The date and time the last order of the customer was created in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| Field label | Last order created date (ISO) |
| Description | The date and time the last order of the customer was created in ISO format |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| Destinations | Data warehouse |
| \| customer_last_order_created_at_date \| \| --- \| \| \\| Field label \\| Last order created date \\| \\| --- \\| --- \\| \\| Description \\| The date the last order of the customer was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Last order created date \| \| Description \| The date the last order of the customer was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| customer_last_order_created_at_date |
| \| Field label \| Last order created date \| \| --- \| --- \| \| Description \| The date the last order of the customer was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Last order created date |
| Description | The date the last order of the customer was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| customer_lifetime_duration \| \| --- \| \| \\| Field label \\| Account age in days \\| \\| --- \\| --- \\| \\| Description \\| The amount of days since the customer was first added to the online store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Account age in days \| \| Description \| The amount of days since the customer was first added to the online store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_lifetime_duration |
| \| Field label \| Account age in days \| \| --- \| --- \| \| Description \| The amount of days since the customer was first added to the online store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Account age in days |
| Description | The amount of days since the customer was first added to the online store |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_created_at \| \| --- \| \| \\| Field label \\| Account created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the customer was added to the online store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Account created datetime \| \| Description \| The date and time the customer was added to the online store \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| customer_created_at |
| \| Field label \| Account created datetime \| \| --- \| --- \| \| Description \| The date and time the customer was added to the online store \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Account created datetime |
| Description | The date and time the customer was added to the online store |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| customer_created_at_iso \| \| --- \| \| \\| Field label \\| Account created time (ISO) \\| \\| --- \\| --- \\| \\| Description \\| The date and time the customer was added to the online store in ISO format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \\| Destinations \\| Data warehouse \\| \| \| Field label \| Account created time (ISO) \| \| Description \| The date and time the customer was added to the online store in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| customer_created_at_iso |
| \| Field label \| Account created time (ISO) \| \| --- \| --- \| \| Description \| The date and time the customer was added to the online store in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| Field label | Account created time (ISO) |
| Description | The date and time the customer was added to the online store in ISO format |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| Destinations | Data warehouse |
| \| customer_created_at_date \| \| --- \| \| \\| Field label \\| Account created date \\| \\| --- \\| --- \\| \\| Description \\| The date the customer was added to the online store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Account created date \| \| Description \| The date the customer was added to the online store \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| customer_created_at_date |
| \| Field label \| Account created date \| \| --- \| --- \| \| Description \| The date the customer was added to the online store \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Account created date |
| Description | The date the customer was added to the online store |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| customer_notes \| \| --- \| \| \\| Field label \\| Customer notes \\| \\| --- \\| --- \\| \\| Description \\| Note about the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer notes \| \| Description \| Note about the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_notes |
| \| Field label \| Customer notes \| \| --- \| --- \| \| Description \| Note about the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer notes |
| Description | Note about the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### CUSTOMER GEO

| \| customer_country \| \| --- \| \| \\| Field label \\| Country \\| \\| --- \\| --- \\| \\| Description \\| The country of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Country \| \| Description \| The country of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| --- |
| customer_country |
| \| Field label \| Country \| \| --- \| --- \| \| Description \| The country of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Field label | Country |
| Description | The country of the customer |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| customer_country_code \| \| --- \| \| \\| Field label \\| Country code \\| \\| --- \\| --- \\| \\| Description \\| The country code of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Country code \| \| Description \| The country code of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| customer_country_code |
| \| Field label \| Country code \| \| --- \| --- \| \| Description \| The country code of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Field label | Country code |
| Description | The country code of the customer |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| customer_city \| \| --- \| \| \\| Field label \\| City \\| \\| --- \\| --- \\| \\| Description \\| The city of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| City \| \| Description \| The city of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| customer_city |
| \| Field label \| City \| \| --- \| --- \| \| Description \| The city of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | City |
| Description | The city of the customer |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |

### DATASOURCE

| \| dataSourceName \| \| --- \| \| \\| Field label \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| |
| --- |
| dataSourceName |
| \| Field label \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| |
| Field label | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| Destinations | API, Data warehouse |
| \| system_metadata.data_source_logins \| \| --- \| \| \\| Field label \\| Data source logins \\| \\| --- \\| --- \\| \\| Description \\| The data source login accounts that were used to authenticate against the data source \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source logins \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.data_source_logins |
| \| Field label \| Data source logins \| \| --- \| --- \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Data source logins |
| Description | The data source login accounts that were used to authenticate against the data source |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.data_source_login_owners \| \| --- \| \| \\| Field label \\| Data source login owners \\| \\| --- \\| --- \\| \\| Description \\| The Supermetrics users that created the data source login connections \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source login owners \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.data_source_login_owners |
| \| Field label \| Data source login owners \| \| --- \| --- \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Data source login owners |
| Description | The Supermetrics users that created the data source login connections |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |

### DEPRECATED

| \| items \| \| --- \| \| \\| Field label \\| Items \\| \\| --- \\| --- \\| \\| Description \\| The amount of the line item. \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \\| 🚫 Deprecated \\| Deprecated on 2025-01-30 \\| \| \| Field label \| Items \| \| Description \| The amount of the line item. \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| \| 🚫 Deprecated \| Deprecated on 2025-01-30 \| |
| --- |
| items |
| \| Field label \| Items \| \| --- \| --- \| \| Description \| The amount of the line item. \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| \| 🚫 Deprecated \| Deprecated on 2025-01-30 \| |
| Field label | Items |
| Description | The amount of the line item. |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| 🚫 Deprecated | Deprecated on 2025-01-30 |
| \| avg_items \| \| --- \| \| \\| Field label \\| Avg. number of items \\| \\| --- \\| --- \\| \\| Description \\| The average number of sold items. Order adjustments and shipping is not calculated towards this metric. \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \\| 🚫 Deprecated \\| Deprecated on 2025-01-30 \\| \| \| Field label \| Avg. number of items \| \| Description \| The average number of sold items. Order adjustments and shipping is not calculated towards this metric. \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| \| 🚫 Deprecated \| Deprecated on 2025-01-30 \| |
| avg_items |
| \| Field label \| Avg. number of items \| \| --- \| --- \| \| Description \| The average number of sold items. Order adjustments and shipping is not calculated towards this metric. \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| \| 🚫 Deprecated \| Deprecated on 2025-01-30 \| |
| Field label | Avg. number of items |
| Description | The average number of sold items. Order adjustments and shipping is not calculated towards this metric. |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| 🚫 Deprecated | Deprecated on 2025-01-30 |

### INVENTORY ITEM

| \| inventory_item_cost_per_item \| \| --- \| \| \\| Field label \\| Cost per item \\| \\| --- \\| --- \\| \\| Description \\| Cost of the inventory item \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Cost per item \| \| Description \| Cost of the inventory item \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| --- |
| inventory_item_cost_per_item |
| \| Field label \| Cost per item \| \| --- \| --- \| \| Description \| Cost of the inventory item \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Cost per item |
| Description | Cost of the inventory item |
| Field type | dimension |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| cost_of_goods_sold \| \| --- \| \| \\| Field label \\| Cost of goods sold \\| \\| --- \\| --- \\| \\| Description \\| The total cost of all the units of goods sold \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Cost of goods sold \| \| Description \| The total cost of all the units of goods sold \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| cost_of_goods_sold |
| \| Field label \| Cost of goods sold \| \| --- \| --- \| \| Description \| The total cost of all the units of goods sold \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Cost of goods sold |
| Description | The total cost of all the units of goods sold |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| gross_profit \| \| --- \| \| \\| Field label \\| Gross profit \\| \\| --- \\| --- \\| \\| Description \\| The total profit made calculated by subtracting the cost from net sales \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Gross profit \| \| Description \| The total profit made calculated by subtracting the cost from net sales \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| gross_profit |
| \| Field label \| Gross profit \| \| --- \| --- \| \| Description \| The total profit made calculated by subtracting the cost from net sales \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Gross profit |
| Description | The total profit made calculated by subtracting the cost from net sales |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### LINE ITEM

| \| line_item_id \| \| --- \| \| \\| Field label \\| Line item ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the line item row \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Line item ID \| \| Description \| ID of the line item row \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| line_item_id |
| \| Field label \| Line item ID \| \| --- \| --- \| \| Description \| ID of the line item row \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Line item ID |
| Description | ID of the line item row |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_type \| \| --- \| \| \\| Field label \\| Line item type \\| \\| --- \\| --- \\| \\| Description \\| Type classification by Supermetrics. Possible values are "Product", "Refund", "Order adjustment", and "Shipping" \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Line item type \| \| Description \| Type classification by Supermetrics. Possible values are "Product", "Refund", "Order adjustment", and "Shipping" \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_type |
| \| Field label \| Line item type \| \| --- \| --- \| \| Description \| Type classification by Supermetrics. Possible values are "Product", "Refund", "Order adjustment", and "Shipping" \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Line item type |
| Description | Type classification by Supermetrics. Possible values are "Product", "Refund", "Order adjustment", and "Shipping" |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_properties \| \| --- \| \| \\| Field label \\| Line item properties \\| \\| --- \\| --- \\| \\| Description \\| An array of custom information for the line item in the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Line item properties \| \| Description \| An array of custom information for the line item in the order \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| line_item_properties |
| \| Field label \| Line item properties \| \| --- \| --- \| \| Description \| An array of custom information for the line item in the order \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Line item properties |
| Description | An array of custom information for the line item in the order |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| line_item_fulfillment_date \| \| --- \| \| \\| Field label \\| Line item fulfillment date \\| \\| --- \\| --- \\| \\| Description \\| The date that the specific line item fulfillment was completed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Line item fulfillment date \| \| Description \| The date that the specific line item fulfillment was completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| line_item_fulfillment_date |
| \| Field label \| Line item fulfillment date \| \| --- \| --- \| \| Description \| The date that the specific line item fulfillment was completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Line item fulfillment date |
| Description | The date that the specific line item fulfillment was completed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| line_item_is_gift_card \| \| --- \| \| \\| Field label \\| Is gift card \\| \\| --- \\| --- \\| \\| Description \\| Whether or not the line item is a gift card \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Is gift card \| \| Description \| Whether or not the line item is a gift card \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| line_item_is_gift_card |
| \| Field label \| Is gift card \| \| --- \| --- \| \| Description \| Whether or not the line item is a gift card \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Is gift card |
| Description | Whether or not the line item is a gift card |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| line_item_name \| \| --- \| \| \\| Field label \\| Line item name \\| \\| --- \\| --- \\| \\| Description \\| The name of the product variant for the line item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Line item name \| \| Description \| The name of the product variant for the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_name |
| \| Field label \| Line item name \| \| --- \| --- \| \| Description \| The name of the product variant for the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Line item name |
| Description | The name of the product variant for the line item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_title \| \| --- \| \| \\| Field label \\| Line item title \\| \\| --- \\| --- \\| \\| Description \\| The title of the product for the line item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Line item title \| \| Description \| The title of the product for the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_title |
| \| Field label \| Line item title \| \| --- \| --- \| \| Description \| The title of the product for the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Line item title |
| Description | The title of the product for the line item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### ORDER

| \| order_id \| \| --- \| \| \\| Field label \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order ID \| \| Description \| The unique identifier of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| order_id |
| \| Field label \| Order ID \| \| --- \| --- \| \| Description \| The unique identifier of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order ID |
| Description | The unique identifier of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_name \| \| --- \| \| \\| Field label \\| Order name \\| \\| --- \\| --- \\| \\| Description \\| The name of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order name \| \| Description \| The name of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_name |
| \| Field label \| Order name \| \| --- \| --- \| \| Description \| The name of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order name |
| Description | The name of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_note \| \| --- \| \| \\| Field label \\| Order note \\| \\| --- \\| --- \\| \\| Description \\| The note on the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order note \| \| Description \| The note on the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_note |
| \| Field label \| Order note \| \| --- \| --- \| \| Description \| The note on the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order note |
| Description | The note on the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_tags \| \| --- \| \| \\| Field label \\| Order tags \\| \\| --- \\| --- \\| \\| Description \\| Tags attached to the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order tags \| \| Description \| Tags attached to the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_tags |
| \| Field label \| Order tags \| \| --- \| --- \| \| Description \| Tags attached to the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order tags |
| Description | Tags attached to the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_financial_status \| \| --- \| \| \\| Field label \\| Financial status \\| \\| --- \\| --- \\| \\| Description \\| The status of payments associated with the order. Possible values include: pending, authorized, partially_paid, paid, partially_refunded, refunded, voided \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Financial status \| \| Description \| The status of payments associated with the order. Possible values include: pending, authorized, partially_paid, paid, partially_refunded, refunded, voided \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_financial_status |
| \| Field label \| Financial status \| \| --- \| --- \| \| Description \| The status of payments associated with the order. Possible values include: pending, authorized, partially_paid, paid, partially_refunded, refunded, voided \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Financial status |
| Description | The status of payments associated with the order. Possible values include: pending, authorized, partially_paid, paid, partially_refunded, refunded, voided |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_note_attributes \| \| --- \| \| \\| Field label \\| Order note attributes \\| \\| --- \\| --- \\| \\| Description \\| Extra information that is added to the order. Appears in the Additional details section of an order details page \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Order note attributes \| \| Description \| Extra information that is added to the order. Appears in the Additional details section of an order details page \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| order_note_attributes |
| \| Field label \| Order note attributes \| \| --- \| --- \| \| Description \| Extra information that is added to the order. Appears in the Additional details section of an order details page \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Order note attributes |
| Description | Extra information that is added to the order. Appears in the Additional details section of an order details page |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| order_created_at \| \| --- \| \| \\| Field label \\| Order created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order created datetime \| \| Description \| The date and time the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_created_at |
| \| Field label \| Order created datetime \| \| --- \| --- \| \| Description \| The date and time the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Order created datetime |
| Description | The date and time the order was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_created_at_iso \| \| --- \| \| \\| Field label \\| Order created time (ISO) \\| \\| --- \\| --- \\| \\| Description \\| The date and time the order was created in ISO format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \\| Destinations \\| Data warehouse \\| \| \| Field label \| Order created time (ISO) \| \| Description \| The date and time the order was created in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| order_created_at_iso |
| \| Field label \| Order created time (ISO) \| \| --- \| --- \| \| Description \| The date and time the order was created in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| Field label | Order created time (ISO) |
| Description | The date and time the order was created in ISO format |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| Destinations | Data warehouse |
| \| order_created_at_date \| \| --- \| \| \\| Field label \\| Order created date \\| \\| --- \\| --- \\| \\| Description \\| The date the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order created date \| \| Description \| The date the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_created_at_date |
| \| Field label \| Order created date \| \| --- \| --- \| \| Description \| The date the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Order created date |
| Description | The date the order was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_closed_at \| \| --- \| \| \\| Field label \\| Order closed datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the order was closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order closed datetime \| \| Description \| The date and time the order was closed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_closed_at |
| \| Field label \| Order closed datetime \| \| --- \| --- \| \| Description \| The date and time the order was closed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Order closed datetime |
| Description | The date and time the order was closed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_closed_at_iso \| \| --- \| \| \\| Field label \\| Order closed time (ISO) \\| \\| --- \\| --- \\| \\| Description \\| The date and time the order was closed in ISO format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \\| Destinations \\| Data warehouse \\| \| \| Field label \| Order closed time (ISO) \| \| Description \| The date and time the order was closed in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| order_closed_at_iso |
| \| Field label \| Order closed time (ISO) \| \| --- \| --- \| \| Description \| The date and time the order was closed in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| Field label | Order closed time (ISO) |
| Description | The date and time the order was closed in ISO format |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| Destinations | Data warehouse |
| \| order_closed_at_date \| \| --- \| \| \\| Field label \\| Order closed date \\| \\| --- \\| --- \\| \\| Description \\| The date the order was closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order closed date \| \| Description \| The date the order was closed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_closed_at_date |
| \| Field label \| Order closed date \| \| --- \| --- \| \| Description \| The date the order was closed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Order closed date |
| Description | The date the order was closed |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_cancelled_at \| \| --- \| \| \\| Field label \\| Order cancelled datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time of the order cancellation \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order cancelled datetime \| \| Description \| The date and time of the order cancellation \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_cancelled_at |
| \| Field label \| Order cancelled datetime \| \| --- \| --- \| \| Description \| The date and time of the order cancellation \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Order cancelled datetime |
| Description | The date and time of the order cancellation |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_cancelled_at_iso \| \| --- \| \| \\| Field label \\| Order cancelled time (ISO) \\| \\| --- \\| --- \\| \\| Description \\| The date and time when the order was cancelled in ISO format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \\| Destinations \\| Data warehouse \\| \| \| Field label \| Order cancelled time (ISO) \| \| Description \| The date and time when the order was cancelled in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| order_cancelled_at_iso |
| \| Field label \| Order cancelled time (ISO) \| \| --- \| --- \| \| Description \| The date and time when the order was cancelled in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| Field label | Order cancelled time (ISO) |
| Description | The date and time when the order was cancelled in ISO format |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| Destinations | Data warehouse |
| \| order_cancelled_at_date \| \| --- \| \| \\| Field label \\| Order cancelled date \\| \\| --- \\| --- \\| \\| Description \\| The date of the order cancellation \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order cancelled date \| \| Description \| The date of the order cancellation \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_cancelled_at_date |
| \| Field label \| Order cancelled date \| \| --- \| --- \| \| Description \| The date of the order cancellation \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Order cancelled date |
| Description | The date of the order cancellation |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_processed_at \| \| --- \| \| \\| Field label \\| Order processed datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time when the order was processed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order processed datetime \| \| Description \| The date and time when the order was processed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_processed_at |
| \| Field label \| Order processed datetime \| \| --- \| --- \| \| Description \| The date and time when the order was processed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Order processed datetime |
| Description | The date and time when the order was processed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_processed_at_date \| \| --- \| \| \\| Field label \\| Order processed date \\| \\| --- \\| --- \\| \\| Description \\| The date when the order was processed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order processed date \| \| Description \| The date when the order was processed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_processed_at_date |
| \| Field label \| Order processed date \| \| --- \| --- \| \| Description \| The date when the order was processed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Order processed date |
| Description | The date when the order was processed |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_shipping_address1 \| \| --- \| \| \\| Field label \\| Shipping address 1 \\| \\| --- \\| --- \\| \\| Description \\| The street address of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping address 1 \| \| Description \| The street address of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_shipping_address1 |
| \| Field label \| Shipping address 1 \| \| --- \| --- \| \| Description \| The street address of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping address 1 |
| Description | The street address of the shipping address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_shipping_address2 \| \| --- \| \| \\| Field label \\| Shipping address 2 \\| \\| --- \\| --- \\| \\| Description \\| An optional additional field for the street address of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping address 2 \| \| Description \| An optional additional field for the street address of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_shipping_address2 |
| \| Field label \| Shipping address 2 \| \| --- \| --- \| \| Description \| An optional additional field for the street address of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping address 2 |
| Description | An optional additional field for the street address of the shipping address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_shipping_phone \| \| --- \| \| \\| Field label \\| Shipping phone \\| \\| --- \\| --- \\| \\| Description \\| The phone number at the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping phone \| \| Description \| The phone number at the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| order_shipping_phone |
| \| Field label \| Shipping phone \| \| --- \| --- \| \| Description \| The phone number at the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Field label | Shipping phone |
| Description | The phone number at the shipping address |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| order_shipping_post_code \| \| --- \| \| \\| Field label \\| Shipping post code \\| \\| --- \\| --- \\| \\| Description \\| The postal code (zip, postcode, Eircode, …) of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.zip](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping post code \| \| Description \| The postal code (zip, postcode, Eircode, …) of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| order_shipping_post_code |
| \| Field label \| Shipping post code \| \| --- \| --- \| \| Description \| The postal code (zip, postcode, Eircode, …) of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping post code |
| Description | The postal code (zip, postcode, Eircode, …) of the shipping address |
| Field type | dimension |
| Data type | [string.geo.zip](/apidocs/field-data-types#geographical) |
| \| order_shipping_city \| \| --- \| \| \\| Field label \\| Shipping city \\| \\| --- \\| --- \\| \\| Description \\| The city, town, or village of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping city \| \| Description \| The city, town, or village of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| order_shipping_city |
| \| Field label \| Shipping city \| \| --- \| --- \| \| Description \| The city, town, or village of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping city |
| Description | The city, town, or village of the shipping address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| order_shipping_province \| \| --- \| \| \\| Field label \\| Shipping province \\| \\| --- \\| --- \\| \\| Description \\| The name of the region (province, state, prefecture, …) of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping province \| \| Description \| The name of the region (province, state, prefecture, …) of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| order_shipping_province |
| \| Field label \| Shipping province \| \| --- \| --- \| \| Description \| The name of the region (province, state, prefecture, …) of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping province |
| Description | The name of the region (province, state, prefecture, …) of the shipping address |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| order_shipping_country \| \| --- \| \| \\| Field label \\| Shipping country \\| \\| --- \\| --- \\| \\| Description \\| The name of the country of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping country \| \| Description \| The name of the country of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| order_shipping_country |
| \| Field label \| Shipping country \| \| --- \| --- \| \| Description \| The name of the country of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping country |
| Description | The name of the country of the shipping address |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| order_billing_address1 \| \| --- \| \| \\| Field label \\| Billing address 1 \\| \\| --- \\| --- \\| \\| Description \\| The street address of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing address 1 \| \| Description \| The street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_billing_address1 |
| \| Field label \| Billing address 1 \| \| --- \| --- \| \| Description \| The street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing address 1 |
| Description | The street address of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_billing_address2 \| \| --- \| \| \\| Field label \\| Billing address 2 \\| \\| --- \\| --- \\| \\| Description \\| An optional additional field for the street address of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing address 2 \| \| Description \| An optional additional field for the street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_billing_address2 |
| \| Field label \| Billing address 2 \| \| --- \| --- \| \| Description \| An optional additional field for the street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing address 2 |
| Description | An optional additional field for the street address of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_billing_phone \| \| --- \| \| \\| Field label \\| Billing phone \\| \\| --- \\| --- \\| \\| Description \\| The phone number at the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing phone \| \| Description \| The phone number at the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| order_billing_phone |
| \| Field label \| Billing phone \| \| --- \| --- \| \| Description \| The phone number at the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Field label | Billing phone |
| Description | The phone number at the billing address |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| order_billing_post_code \| \| --- \| \| \\| Field label \\| Billing post code \\| \\| --- \\| --- \\| \\| Description \\| The postal code (for example, zip, postcode, or Eircode) of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.zip](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing post code \| \| Description \| The postal code (for example, zip, postcode, or Eircode) of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| order_billing_post_code |
| \| Field label \| Billing post code \| \| --- \| --- \| \| Description \| The postal code (for example, zip, postcode, or Eircode) of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| Field label | Billing post code |
| Description | The postal code (for example, zip, postcode, or Eircode) of the billing address |
| Field type | dimension |
| Data type | [string.geo.zip](/apidocs/field-data-types#geographical) |
| \| order_billing_city \| \| --- \| \| \\| Field label \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| The city, town, or village of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing city \| \| Description \| The city, town, or village of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| order_billing_city |
| \| Field label \| Billing city \| \| --- \| --- \| \| Description \| The city, town, or village of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | Billing city |
| Description | The city, town, or village of the billing address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| order_billing_province \| \| --- \| \| \\| Field label \\| Billing province \\| \\| --- \\| --- \\| \\| Description \\| The name of the region (for example, province, state, or prefecture) of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing province \| \| Description \| The name of the region (for example, province, state, or prefecture) of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| order_billing_province |
| \| Field label \| Billing province \| \| --- \| --- \| \| Description \| The name of the region (for example, province, state, or prefecture) of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Field label | Billing province |
| Description | The name of the region (for example, province, state, or prefecture) of the billing address |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| order_billing_country \| \| --- \| \| \\| Field label \\| Billing country \\| \\| --- \\| --- \\| \\| Description \\| The name of the country of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing country \| \| Description \| The name of the country of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| order_billing_country |
| \| Field label \| Billing country \| \| --- \| --- \| \| Description \| The name of the country of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Field label | Billing country |
| Description | The name of the country of the billing address |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| order_channel \| \| --- \| \| \\| Field label \\| Channel \\| \\| --- \\| --- \\| \\| Description \\| The sales channel of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Channel \| \| Description \| The sales channel of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_channel |
| \| Field label \| Channel \| \| --- \| --- \| \| Description \| The sales channel of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Channel |
| Description | The sales channel of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_channel_app_name \| \| --- \| \| \\| Field label \\| Channel (App name) \\| \\| --- \\| --- \\| \\| Description \\| The sales channel's app name of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Channel (App name) \| \| Description \| The sales channel's app name of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_channel_app_name |
| \| Field label \| Channel (App name) \| \| --- \| --- \| \| Description \| The sales channel's app name of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Channel (App name) |
| Description | The sales channel's app name of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_confirmed \| \| --- \| \| \\| Field label \\| Order confirmed \\| \\| --- \\| --- \\| \\| Description \\| Whether inventory has been reserved for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Order confirmed \| \| Description \| Whether inventory has been reserved for the order \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| order_confirmed |
| \| Field label \| Order confirmed \| \| --- \| --- \| \| Description \| Whether inventory has been reserved for the order \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Order confirmed |
| Description | Whether inventory has been reserved for the order |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_currency_code \| \| --- \| \| \\| Field label \\| Currency \\| \\| --- \\| --- \\| \\| Description \\| ISO 4217 currency code for the order, e.g. USD \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Currency \| \| Description \| ISO 4217 currency code for the order, e.g. USD \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| order_currency_code |
| \| Field label \| Currency \| \| --- \| --- \| \| Description \| ISO 4217 currency code for the order, e.g. USD \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Currency |
| Description | ISO 4217 currency code for the order, e.g. USD |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| order_email \| \| --- \| \| \\| Field label \\| Order email \\| \\| --- \\| --- \\| \\| Description \\| The email associated with the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| Order email \| \| Description \| The email associated with the order \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| order_email |
| \| Field label \| Order email \| \| --- \| --- \| \| Description \| The email associated with the order \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Field label | Order email |
| Description | The email associated with the order |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| order_fully_paid \| \| --- \| \| \\| Field label \\| Fully paid \\| \\| --- \\| --- \\| \\| Description \\| Whether the order is fully paid or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Fully paid \| \| Description \| Whether the order is fully paid or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| order_fully_paid |
| \| Field label \| Fully paid \| \| --- \| --- \| \| Description \| Whether the order is fully paid or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Fully paid |
| Description | Whether the order is fully paid or not |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_discount_code \| \| --- \| \| \\| Field label \\| Discount reason \\| \\| --- \\| --- \\| \\| Description \\| The reason for the applied order's item-level discount \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Discount reason \| \| Description \| The reason for the applied order's item-level discount \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_discount_code |
| \| Field label \| Discount reason \| \| --- \| --- \| \| Description \| The reason for the applied order's item-level discount \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Discount reason |
| Description | The reason for the applied order's item-level discount |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_discount_type \| \| --- \| \| \\| Field label \\| Discount type \\| \\| --- \\| --- \\| \\| Description \\| The type of discount. Possible values are "fixed_amount", "percentage", and "shipping" \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Discount type \| \| Description \| The type of discount. Possible values are "fixed_amount", "percentage", and "shipping" \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_discount_type |
| \| Field label \| Discount type \| \| --- \| --- \| \| Description \| The type of discount. Possible values are "fixed_amount", "percentage", and "shipping" \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Discount type |
| Description | The type of discount. Possible values are "fixed_amount", "percentage", and "shipping" |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_payment_gateway_names \| \| --- \| \| \\| Field label \\| Payment gateway names \\| \\| --- \\| --- \\| \\| Description \\| The list of payment gateways used for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Payment gateway names \| \| Description \| The list of payment gateways used for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_payment_gateway_names |
| \| Field label \| Payment gateway names \| \| --- \| --- \| \| Description \| The list of payment gateways used for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Payment gateway names |
| Description | The list of payment gateways used for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_location \| \| --- \| \| \\| Field label \\| Location name \\| \\| --- \\| --- \\| \\| Description \\| The location name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Location name \| \| Description \| The location name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_location |
| \| Field label \| Location name \| \| --- \| --- \| \| Description \| The location name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Location name |
| Description | The location name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_shipping_description \| \| --- \| \| \\| Field label \\| Shipping description \\| \\| --- \\| --- \\| \\| Description \\| Description of the shipping selected for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping description \| \| Description \| Description of the shipping selected for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_shipping_description |
| \| Field label \| Shipping description \| \| --- \| --- \| \| Description \| Description of the shipping selected for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping description |
| Description | Description of the shipping selected for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_is_returning_customer \| \| --- \| \| \\| Field label \\| Is returning customer \\| \\| --- \\| --- \\| \\| Description \\| Whether the customer is returning or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Is returning customer \| \| Description \| Whether the customer is returning or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| order_is_returning_customer |
| \| Field label \| Is returning customer \| \| --- \| --- \| \| Description \| Whether the customer is returning or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Is returning customer |
| Description | Whether the customer is returning or not |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_display_fulfillment_status \| \| --- \| \| \\| Field label \\| Fulfillment status \\| \\| --- \\| --- \\| \\| Description \\| Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Fulfillment status \| \| Description \| Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_display_fulfillment_status |
| \| Field label \| Fulfillment status \| \| --- \| --- \| \| Description \| Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Fulfillment status |
| Description | Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_fulfillment_date \| \| --- \| \| \\| Field label \\| Fulfillment date \\| \\| --- \\| --- \\| \\| Description \\| The date that the order fulfillment was completed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Fulfillment date \| \| Description \| The date that the order fulfillment was completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_fulfillment_date |
| \| Field label \| Fulfillment date \| \| --- \| --- \| \| Description \| The date that the order fulfillment was completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Fulfillment date |
| Description | The date that the order fulfillment was completed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| ordered_quantity \| \| --- \| \| \\| Field label \\| Ordered quantity \\| \\| --- \\| --- \\| \\| Description \\| Total number of items ordered. Calculated by Net quantity + Returned quantity \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Ordered quantity \| \| Description \| Total number of items ordered. Calculated by Net quantity + Returned quantity \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| ordered_quantity |
| \| Field label \| Ordered quantity \| \| --- \| --- \| \| Description \| Total number of items ordered. Calculated by Net quantity + Returned quantity \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Ordered quantity |
| Description | Total number of items ordered. Calculated by Net quantity + Returned quantity |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| returned_quantity \| \| --- \| \| \\| Field label \\| Returned quantity \\| \\| --- \\| --- \\| \\| Description \\| Total number of items returned \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Returned quantity \| \| Description \| Total number of items returned \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| returned_quantity |
| \| Field label \| Returned quantity \| \| --- \| --- \| \| Description \| Total number of items returned \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Returned quantity |
| Description | Total number of items returned |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| net_quantity \| \| --- \| \| \\| Field label \\| Net quantity \\| \\| --- \\| --- \\| \\| Description \\| Net quantity of line items ordered. It shows number of sold items minus the number of returned items \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Net quantity \| \| Description \| Net quantity of line items ordered. It shows number of sold items minus the number of returned items \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| net_quantity |
| \| Field label \| Net quantity \| \| --- \| --- \| \| Description \| Net quantity of line items ordered. It shows number of sold items minus the number of returned items \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Net quantity |
| Description | Net quantity of line items ordered. It shows number of sold items minus the number of returned items |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| units_per_transaction \| \| --- \| \| \\| Field label \\| Units per transaction \\| \\| --- \\| --- \\| \\| Description \\| Average number of items per transaction. Calculated by Net quantity / Orders \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| Units per transaction \| \| Description \| Average number of items per transaction. Calculated by Net quantity / Orders \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| units_per_transaction |
| \| Field label \| Units per transaction \| \| --- \| --- \| \| Description \| Average number of items per transaction. Calculated by Net quantity / Orders \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| Field label | Units per transaction |
| Description | Average number of items per transaction. Calculated by Net quantity / Orders |
| Field type | metric |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| sm_order_count \| \| --- \| \| \\| Field label \\| Orders \\| \\| --- \\| --- \\| \\| Description \\| The amount of orders \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Orders \| \| Description \| The amount of orders \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| sm_order_count |
| \| Field label \| Orders \| \| --- \| --- \| \| Description \| The amount of orders \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Orders |
| Description | The amount of orders |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| avg_total_sales \| \| --- \| \| \\| Field label \\| Avg. order value \\| \\| --- \\| --- \\| \\| Description \\| The average total sales \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Avg. order value \| \| Description \| The average total sales \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| avg_total_sales |
| \| Field label \| Avg. order value \| \| --- \| --- \| \| Description \| The average total sales \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Avg. order value |
| Description | The average total sales |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### PRODUCT

| \| sku \| \| --- \| \| \\| Field label \\| SKU \\| \\| --- \\| --- \\| \\| Description \\| Variant SKU number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| SKU \| \| Description \| Variant SKU number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| sku |
| \| Field label \| SKU \| \| --- \| --- \| \| Description \| Variant SKU number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | SKU |
| Description | Variant SKU number |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_id \| \| --- \| \| \\| Field label \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product ID \| \| Description \| The unique identifier of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_id |
| \| Field label \| Product ID \| \| --- \| --- \| \| Description \| The unique identifier of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product ID |
| Description | The unique identifier of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| variant_id \| \| --- \| \| \\| Field label \\| Variant ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the product variant \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Variant ID \| \| Description \| The unique identifier of the product variant \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| variant_id |
| \| Field label \| Variant ID \| \| --- \| --- \| \| Description \| The unique identifier of the product variant \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Variant ID |
| Description | The unique identifier of the product variant |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| title \| \| --- \| \| \\| Field label \\| Product title \\| \\| --- \\| --- \\| \\| Description \\| The title of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product title \| \| Description \| The title of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| title |
| \| Field label \| Product title \| \| --- \| --- \| \| Description \| The title of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product title |
| Description | The title of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| variant_title \| \| --- \| \| \\| Field label \\| Variant title \\| \\| --- \\| --- \\| \\| Description \\| The title of the product variant \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Variant title \| \| Description \| The title of the product variant \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| variant_title |
| \| Field label \| Variant title \| \| --- \| --- \| \| Description \| The title of the product variant \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Variant title |
| Description | The title of the product variant |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_tags \| \| --- \| \| \\| Field label \\| Product tags \\| \\| --- \\| --- \\| \\| Description \\| Tags attached to the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product tags \| \| Description \| Tags attached to the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_tags |
| \| Field label \| Product tags \| \| --- \| --- \| \| Description \| Tags attached to the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product tags |
| Description | Tags attached to the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_status \| \| --- \| \| \\| Field label \\| Product status \\| \\| --- \\| --- \\| \\| Description \\| Status of the product, which determines if its ready to be sold. Possible values are ACTIVE, ARCHIVED, and DRAFT \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product status \| \| Description \| Status of the product, which determines if its ready to be sold. Possible values are ACTIVE, ARCHIVED, and DRAFT \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_status |
| \| Field label \| Product status \| \| --- \| --- \| \| Description \| Status of the product, which determines if its ready to be sold. Possible values are ACTIVE, ARCHIVED, and DRAFT \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product status |
| Description | Status of the product, which determines if its ready to be sold. Possible values are ACTIVE, ARCHIVED, and DRAFT |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| price \| \| --- \| \| \\| Field label \\| Price \\| \\| --- \\| --- \\| \\| Description \\| The price of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Price \| \| Description \| The price of the product \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| price |
| \| Field label \| Price \| \| --- \| --- \| \| Description \| The price of the product \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Price |
| Description | The price of the product |
| Field type | dimension |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| description \| \| --- \| \| \\| Field label \\| Description \\| \\| --- \\| --- \\| \\| Description \\| Description of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Description \| \| Description \| Description of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| description |
| \| Field label \| Description \| \| --- \| --- \| \| Description \| Description of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Description |
| Description | Description of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| vendor \| \| --- \| \| \\| Field label \\| Vendor \\| \\| --- \\| --- \\| \\| Description \\| The vendor of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Vendor \| \| Description \| The vendor of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| vendor |
| \| Field label \| Vendor \| \| --- \| --- \| \| Description \| The vendor of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Vendor |
| Description | The vendor of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| type \| \| --- \| \| \\| Field label \\| Type \\| \\| --- \\| --- \\| \\| Description \\| The type of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Type \| \| Description \| The type of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| type |
| \| Field label \| Type \| \| --- \| --- \| \| Description \| The type of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Type |
| Description | The type of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| image_src \| \| --- \| \| \\| Field label \\| Image URL \\| \\| --- \\| --- \\| \\| Description \\| The image URL of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Image URL \| \| Description \| The image URL of the product \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| image_src |
| \| Field label \| Image URL \| \| --- \| --- \| \| Description \| The image URL of the product \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Field label | Image URL |
| Description | The image URL of the product |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| product_created_at \| \| --- \| \| \\| Field label \\| Product created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the product was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Product created datetime \| \| Description \| The date and time the product was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| product_created_at |
| \| Field label \| Product created datetime \| \| --- \| --- \| \| Description \| The date and time the product was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Product created datetime |
| Description | The date and time the product was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| product_created_at_iso \| \| --- \| \| \\| Field label \\| Product created time (ISO) \\| \\| --- \\| --- \\| \\| Description \\| The date and time the product was created in ISO format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \\| Destinations \\| Data warehouse \\| \| \| Field label \| Product created time (ISO) \| \| Description \| The date and time the product was created in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| product_created_at_iso |
| \| Field label \| Product created time (ISO) \| \| --- \| --- \| \| Description \| The date and time the product was created in ISO format \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| \| Destinations \| Data warehouse \| |
| Field label | Product created time (ISO) |
| Description | The date and time the product was created in ISO format |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| Destinations | Data warehouse |
| \| product_created_at_date \| \| --- \| \| \\| Field label \\| Product created date \\| \\| --- \\| --- \\| \\| Description \\| The date the product was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Product created date \| \| Description \| The date the product was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| product_created_at_date |
| \| Field label \| Product created date \| \| --- \| --- \| \| Description \| The date the product was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Product created date |
| Description | The date the product was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| product_inventory_value \| \| --- \| \| \\| Field label \\| Inventory value \\| \\| --- \\| --- \\| \\| Description \\| The sell value of the product inventory \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Inventory value \| \| Description \| The sell value of the product inventory \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| product_inventory_value |
| \| Field label \| Inventory value \| \| --- \| --- \| \| Description \| The sell value of the product inventory \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Inventory value |
| Description | The sell value of the product inventory |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| product_inventory_quantity \| \| --- \| \| \\| Field label \\| Inventory quantity \\| \\| --- \\| --- \\| \\| Description \\| The product quantity in inventory \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Inventory quantity \| \| Description \| The product quantity in inventory \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| product_inventory_quantity |
| \| Field label \| Inventory quantity \| \| --- \| --- \| \| Description \| The product quantity in inventory \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Inventory quantity |
| Description | The product quantity in inventory |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

### QUERY

| \| system_metadata.query_date_range_start \| \| --- \| \| \\| Field label \\| Start date \\| \\| --- \\| --- \\| \\| Description \\| The start date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Start date \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| system_metadata.query_date_range_start |
| \| Field label \| Start date \| \| --- \| --- \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Start date |
| Description | The start date of the requested query |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| system_metadata.query_date_range_end \| \| --- \| \| \\| Field label \\| End date \\| \\| --- \\| --- \\| \\| Description \\| The end date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| End date \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_range_end |
| \| Field label \| End date \| \| --- \| --- \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | End date |
| Description | The end date of the requested query |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| system_metadata.query_timezone \| \| --- \| \| \\| Field label \\| Timezone \\| \\| --- \\| --- \\| \\| Description \\| The timezone that is supplied to the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.timezone](/apidocs/field-data-types#time) \\| \| \| Field label \| Timezone \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| system_metadata.query_timezone |
| \| Field label \| Timezone \| \| --- \| --- \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| Field label | Timezone |
| Description | The timezone that is supplied to the query |
| Field type | dimension |
| Data type | [string.time.timezone](/apidocs/field-data-types#time) |
| \| system_metadata.query_filters \| \| --- \| \| \\| Field label \\| Filters \\| \\| --- \\| --- \\| \\| Description \\| All filters used in the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Filters \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_filters |
| \| Field label \| Filters \| \| --- \| --- \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Filters |
| Description | All filters used in the query |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.query_date_start \| \| --- \| \| \\| Field label \\| Start \\| \\| --- \\| --- \\| \\| Description \\| When the query was started \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Start \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_start |
| \| Field label \| Start \| \| --- \| --- \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Start |
| Description | When the query was started |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| system_metadata.query_date_end \| \| --- \| \| \\| Field label \\| End \\| \\| --- \\| --- \\| \\| Description \\| When the query completed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| End \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_end |
| \| Field label \| End \| \| --- \| --- \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | End |
| Description | When the query completed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| system_metadata.query_duration \| \| --- \| \| \\| Field label \\| Duration \\| \\| --- \\| --- \\| \\| Description \\| The duration in seconds of the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.duration.seconds](/apidocs/field-data-types#duration) \\| \| \| Field label \| Duration \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| |
| system_metadata.query_duration |
| \| Field label \| Duration \| \| --- \| --- \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| |
| Field label | Duration |
| Description | The duration in seconds of the query |
| Field type | dimension |
| Data type | [int.duration.seconds](/apidocs/field-data-types#duration) |
| \| system_metadata.query_accounts \| \| --- \| \| \\| Field label \\| Accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of accounts of which the data was pulled from \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Accounts \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_accounts |
| \| Field label \| Accounts \| \| --- \| --- \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Accounts |
| Description | A list of accounts of which the data was pulled from |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.query_excluded_accounts \| \| --- \| \| \\| Field label \\| Excluded invalid accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Excluded invalid accounts \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_excluded_accounts |
| \| Field label \| Excluded invalid accounts \| \| --- \| --- \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Excluded invalid accounts |
| Description | A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |

### REFUND

| \| refund_note \| \| --- \| \| \\| Field label \\| Refund note \\| \\| --- \\| --- \\| \\| Description \\| Optional note that may be attached to a refund \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Refund note \| \| Description \| Optional note that may be attached to a refund \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| refund_note |
| \| Field label \| Refund note \| \| --- \| --- \| \| Description \| Optional note that may be attached to a refund \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Refund note |
| Description | Optional note that may be attached to a refund |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| refund_id \| \| --- \| \| \\| Field label \\| Refund ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the refund \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Refund ID \| \| Description \| The unique identifier of the refund \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| refund_id |
| \| Field label \| Refund ID \| \| --- \| --- \| \| Description \| The unique identifier of the refund \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Refund ID |
| Description | The unique identifier of the refund |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| refund_processed_at \| \| --- \| \| \\| Field label \\| Refund processed datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time when the refund was processed or imported into Shopify \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Refund processed datetime \| \| Description \| The date and time when the refund was processed or imported into Shopify \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| refund_processed_at |
| \| Field label \| Refund processed datetime \| \| --- \| --- \| \| Description \| The date and time when the refund was processed or imported into Shopify \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Refund processed datetime |
| Description | The date and time when the refund was processed or imported into Shopify |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| refund_processed_at_date \| \| --- \| \| \\| Field label \\| Refund processed date \\| \\| --- \\| --- \\| \\| Description \\| The date when the refund was processed or imported into Shopify \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Refund processed date \| \| Description \| The date when the refund was processed or imported into Shopify \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| refund_processed_at_date |
| \| Field label \| Refund processed date \| \| --- \| --- \| \| Description \| The date when the refund was processed or imported into Shopify \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Refund processed date |
| Description | The date when the refund was processed or imported into Shopify |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |

### SALES

| \| gross_sales \| \| --- \| \| \\| Field label \\| Gross sales \\| \\| --- \\| --- \\| \\| Description \\| The total price for the line item without any discounts applied \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Gross sales \| \| Description \| The total price for the line item without any discounts applied \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| --- |
| gross_sales |
| \| Field label \| Gross sales \| \| --- \| --- \| \| Description \| The total price for the line item without any discounts applied \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Gross sales |
| Description | The total price for the line item without any discounts applied |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| discounts \| \| --- \| \| \\| Field label \\| Discounts \\| \\| --- \\| --- \\| \\| Description \\| The total amount of discounts applied on the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Discounts \| \| Description \| The total amount of discounts applied on the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| discounts |
| \| Field label \| Discounts \| \| --- \| --- \| \| Description \| The total amount of discounts applied on the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Discounts |
| Description | The total amount of discounts applied on the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| returns \| \| --- \| \| \\| Field label \\| Returns \\| \\| --- \\| --- \\| \\| Description \\| The total amount refunded for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Returns \| \| Description \| The total amount refunded for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| returns |
| \| Field label \| Returns \| \| --- \| --- \| \| Description \| The total amount refunded for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Returns |
| Description | The total amount refunded for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| net_sales \| \| --- \| \| \\| Field label \\| Net sales \\| \\| --- \\| --- \\| \\| Description \\| The net sales of the line \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Net sales \| \| Description \| The net sales of the line \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| net_sales |
| \| Field label \| Net sales \| \| --- \| --- \| \| Description \| The net sales of the line \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Net sales |
| Description | The net sales of the line |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shipping \| \| --- \| \| \\| Field label \\| Shipping \\| \\| --- \\| --- \\| \\| Description \\| The total shipping amount including returns \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shipping \| \| Description \| The total shipping amount including returns \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shipping |
| \| Field label \| Shipping \| \| --- \| --- \| \| Description \| The total shipping amount including returns \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shipping |
| Description | The total shipping amount including returns |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| tax \| \| --- \| \| \\| Field label \\| Tax \\| \\| --- \\| --- \\| \\| Description \\| The total amount of tax for the line. Takes returns into account \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Tax \| \| Description \| The total amount of tax for the line. Takes returns into account \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| tax |
| \| Field label \| Tax \| \| --- \| --- \| \| Description \| The total amount of tax for the line. Takes returns into account \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Tax |
| Description | The total amount of tax for the line. Takes returns into account |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| duties \| \| --- \| \| \\| Field label \\| Duties \\| \\| --- \\| --- \\| \\| Description \\| The total amount of duties based on the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Duties \| \| Description \| The total amount of duties based on the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| duties |
| \| Field label \| Duties \| \| --- \| --- \| \| Description \| The total amount of duties based on the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Duties |
| Description | The total amount of duties based on the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_sales \| \| --- \| \| \\| Field label \\| Total sales \\| \\| --- \\| --- \\| \\| Description \\| The total sales for line \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total sales \| \| Description \| The total sales for line \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_sales |
| \| Field label \| Total sales \| \| --- \| --- \| \| Description \| The total sales for line \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total sales |
| Description | The total sales for line |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### STORE

| \| shop_id \| \| --- \| \| \\| Field label \\| Store ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store ID \| \| Description \| The unique identifier of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| shop_id |
| \| Field label \| Store ID \| \| --- \| --- \| \| Description \| The unique identifier of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store ID |
| Description | The unique identifier of the store |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shop_name \| \| --- \| \| \\| Field label \\| Store name \\| \\| --- \\| --- \\| \\| Description \\| The name of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store name \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shop_name |
| \| Field label \| Store name \| \| --- \| --- \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store name |
| Description | The name of the store |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### TIME

| \| today \| \| --- \| \| \\| Field label \\| Today \\| \\| --- \\| --- \\| \\| Description \\| Today's date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Today \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| |
| --- |
| today |
| \| Field label \| Today \| \| --- \| --- \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| |
| Field label | Today |
| Description | Today's date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| Destinations | API, Data warehouse |
| \| year \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Description \\| Year, e.g. 2017 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Description \| Year, e.g. 2017 \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year |
| \| Field label \| Year \| \| --- \| --- \| \| Description \| Year, e.g. 2017 \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year |
| Description | Year, e.g. 2017 |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| yearOfWeek \| \| --- \| \| \\| Field label \\| Year of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Description \\| Year of week for US-style Sunday-Saturday weeks, e.g. 2017 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Sun-Sat) \| \| Description \| Year of week for US-style Sunday-Saturday weeks, e.g. 2017 \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| yearOfWeek |
| \| Field label \| Year of week (Sun-Sat) \| \| --- \| --- \| \| Description \| Year of week for US-style Sunday-Saturday weeks, e.g. 2017 \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year of week (Sun-Sat) |
| Description | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| yearOfWeekIso \| \| --- \| \| \\| Field label \\| Year of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Description \\| Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Mon-Sun) \| \| Description \| Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| yearOfWeekIso |
| \| Field label \| Year of week (Mon-Sun) \| \| --- \| --- \| \| Description \| Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year of week (Mon-Sun) |
| Description | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| yearMonth \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Description \\| Year and month, e.g. 2017\\\|06 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Description \| Year and month, e.g. 2017\\|06 \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| |
| yearMonth |
| \| Field label \| Year & month \| \| --- \| --- \| \| Description \| Year and month, e.g. 2017\\|06 \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| |
| Field label | Year & month |
| Description | Year and month, e.g. 2017\|06 |
| Field type | dimension |
| Data type | [string.time.yearmonth](/apidocs/field-data-types#time) |
| \| month \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Description \\| Month, e.g. 09 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Description \| Month, e.g. 09 \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| |
| month |
| \| Field label \| Month \| \| --- \| --- \| \| Description \| Month, e.g. 09 \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| |
| Field label | Month |
| Description | Month, e.g. 09 |
| Field type | dimension |
| Data type | [string.time.month](/apidocs/field-data-types#time) |
| \| yearWeek \| \| --- \| \| \\| Field label \\| Year & week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| |
| yearWeek |
| \| Field label \| Year & week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| |
| Field label | Year & week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.yearweek](/apidocs/field-data-types#time) |
| \| yearWeekIso \| \| --- \| \| \\| Field label \\| Year & week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Description \\| Year and week for ISO standard Monday-Sunday weeks, e.g. 2017\\\|08 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Mon-Sun) \| \| Description \| Year and week for ISO standard Monday-Sunday weeks, e.g. 2017\\|08 \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| |
| yearWeekIso |
| \| Field label \| Year & week (Mon-Sun) \| \| --- \| --- \| \| Description \| Year and week for ISO standard Monday-Sunday weeks, e.g. 2017\\|08 \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| |
| Field label | Year & week (Mon-Sun) |
| Description | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017\|08 |
| Field type | dimension |
| Data type | [string.time.yearweekiso](/apidocs/field-data-types#time) |
| \| week \| \| --- \| \| \\| Field label \\| Week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Description \\| US week number, e.g. 51 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.week](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Sun-Sat) \| \| Description \| US week number, e.g. 51 \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| |
| week |
| \| Field label \| Week (Sun-Sat) \| \| --- \| --- \| \| Description \| US week number, e.g. 51 \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| |
| Field label | Week (Sun-Sat) |
| Description | US week number, e.g. 51 |
| Field type | dimension |
| Data type | [string.time.week](/apidocs/field-data-types#time) |
| \| weekIso \| \| --- \| \| \\| Field label \\| Week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Description \\| ISO week number, e.g. 51 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.weekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Mon-Sun) \| \| Description \| ISO week number, e.g. 51 \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| |
| weekIso |
| \| Field label \| Week (Mon-Sun) \| \| --- \| --- \| \| Description \| ISO week number, e.g. 51 \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| |
| Field label | Week (Mon-Sun) |
| Description | ISO week number, e.g. 51 |
| Field type | dimension |
| Data type | [string.time.weekiso](/apidocs/field-data-types#time) |
| \| dayOfMonth \| \| --- \| \| \\| Field label \\| Day of month \\| \\| --- \\| --- \\| \\| Description \\| Day of month, e.g. 2 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of month \| \| Description \| Day of month, e.g. 2 \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| |
| dayOfMonth |
| \| Field label \| Day of month \| \| --- \| --- \| \| Description \| Day of month, e.g. 2 \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| |
| Field label | Day of month |
| Description | Day of month, e.g. 2 |
| Field type | dimension |
| Data type | [string.time.dayofmonth](/apidocs/field-data-types#time) |
| \| dayOfWeekName \| \| --- \| \| \\| Field label \\| Day of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Description \\| Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Sun-Sat) \| \| Description \| Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| |
| dayOfWeekName |
| \| Field label \| Day of week (Sun-Sat) \| \| --- \| --- \| \| Description \| Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| |
| Field label | Day of week (Sun-Sat) |
| Description | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday |
| Field type | dimension |
| Data type | [string.time.dayofweek](/apidocs/field-data-types#time) |
| \| dayOfWeekNameIso \| \| --- \| \| \\| Field label \\| Day of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Description \\| Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Mon-Sun) \| \| Description \| Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| |
| dayOfWeekNameIso |
| \| Field label \| Day of week (Mon-Sun) \| \| --- \| --- \| \| Description \| Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| |
| Field label | Day of week (Mon-Sun) |
| Description | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday |
| Field type | dimension |
| Data type | [string.time.dayofweekiso](/apidocs/field-data-types#time) |
| \| date \| \| --- \| \| \\| Field label \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date |
| \| Field label \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| hour \| \| --- \| \| \\| Field label \\| Hour \\| \\| --- \\| --- \\| \\| Description \\| Hour in a 24-hour clock, e.g. 18 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.hour](/apidocs/field-data-types#time) \\| \| \| Field label \| Hour \| \| Description \| Hour in a 24-hour clock, e.g. 18 \| \| Field type \| dimension \| \| Data type \| [string.time.hour](/apidocs/field-data-types#time) \| |
| hour |
| \| Field label \| Hour \| \| --- \| --- \| \| Description \| Hour in a 24-hour clock, e.g. 18 \| \| Field type \| dimension \| \| Data type \| [string.time.hour](/apidocs/field-data-types#time) \| |
| Field label | Hour |
| Description | Hour in a 24-hour clock, e.g. 18 |
| Field type | dimension |
| Data type | [string.time.hour](/apidocs/field-data-types#time) |

### TRAFFIC SOURCE

| \| order_landing_page_url \| \| --- \| \| \\| Field label \\| Landing page URL \\| \\| --- \\| --- \\| \\| Description \\| The URL of the landing page \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Landing page URL \| \| Description \| The URL of the landing page \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| --- |
| order_landing_page_url |
| \| Field label \| Landing page URL \| \| --- \| --- \| \| Description \| The URL of the landing page \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Field label | Landing page URL |
| Description | The URL of the landing page |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| order_referral_code \| \| --- \| \| \\| Field label \\| Referral code \\| \\| --- \\| --- \\| \\| Description \\| Referral code that led the customer making the order to the store. However this is set when a customer first enters the store. So if they have been to the store previously without a referral, then the referral code will stay empty even if they would later visit the store via a referral link \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Referral code \| \| Description \| Referral code that led the customer making the order to the store. However this is set when a customer first enters the store. So if they have been to the store previously without a referral, then the referral code will stay empty even if they would later visit the store via a referral link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_referral_code |
| \| Field label \| Referral code \| \| --- \| --- \| \| Description \| Referral code that led the customer making the order to the store. However this is set when a customer first enters the store. So if they have been to the store previously without a referral, then the referral code will stay empty even if they would later visit the store via a referral link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Referral code |
| Description | Referral code that led the customer making the order to the store. However this is set when a customer first enters the store. So if they have been to the store previously without a referral, then the referral code will stay empty even if they would later visit the store via a referral link |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_referrer_url \| \| --- \| \| \\| Field label \\| Order referrer URL \\| \\| --- \\| --- \\| \\| Description \\| The web page the customer clicked a link on that sent them to the online store that led to the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Order referrer URL \| \| Description \| The web page the customer clicked a link on that sent them to the online store that led to the order \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| order_referrer_url |
| \| Field label \| Order referrer URL \| \| --- \| --- \| \| Description \| The web page the customer clicked a link on that sent them to the online store that led to the order \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Field label | Order referrer URL |
| Description | The web page the customer clicked a link on that sent them to the online store that led to the order |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| order_utm_content \| \| --- \| \| \\| Field label \\| UTM content \\| \\| --- \\| --- \\| \\| Description \\| A/B testing and content-targeted ads to differentiate ads or links that point to the same URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| UTM content \| \| Description \| A/B testing and content-targeted ads to differentiate ads or links that point to the same URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_utm_content |
| \| Field label \| UTM content \| \| --- \| --- \| \| Description \| A/B testing and content-targeted ads to differentiate ads or links that point to the same URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | UTM content |
| Description | A/B testing and content-targeted ads to differentiate ads or links that point to the same URL |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_utm_term \| \| --- \| \| \\| Field label \\| UTM term \\| \\| --- \\| --- \\| \\| Description \\| The keywords associated with an ad \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| UTM term \| \| Description \| The keywords associated with an ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_utm_term |
| \| Field label \| UTM term \| \| --- \| --- \| \| Description \| The keywords associated with an ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | UTM term |
| Description | The keywords associated with an ad |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_utm_medium \| \| --- \| \| \\| Field label \\| UTM medium \\| \\| --- \\| --- \\| \\| Description \\| The ad medium, such as email or cost-per-click (cpc) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| UTM medium \| \| Description \| The ad medium, such as email or cost-per-click (cpc) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_utm_medium |
| \| Field label \| UTM medium \| \| --- \| --- \| \| Description \| The ad medium, such as email or cost-per-click (cpc) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | UTM medium |
| Description | The ad medium, such as email or cost-per-click (cpc) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_utm_source \| \| --- \| \| \\| Field label \\| UTM source \\| \\| --- \\| --- \\| \\| Description \\| Identifies a search engine, a newsletter name, or other source \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| UTM source \| \| Description \| Identifies a search engine, a newsletter name, or other source \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_utm_source |
| \| Field label \| UTM source \| \| --- \| --- \| \| Description \| Identifies a search engine, a newsletter name, or other source \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | UTM source |
| Description | Identifies a search engine, a newsletter name, or other source |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_utm_name \| \| --- \| \| \\| Field label \\| UTM campaign name \\| \\| --- \\| --- \\| \\| Description \\| The name that you give a promotion or campaign to identify it \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| UTM campaign name \| \| Description \| The name that you give a promotion or campaign to identify it \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_utm_name |
| \| Field label \| UTM campaign name \| \| --- \| --- \| \| Description \| The name that you give a promotion or campaign to identify it \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | UTM campaign name |
| Description | The name that you give a promotion or campaign to identify it |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_journey_customer_order_index \| \| --- \| \| \\| Field label \\| Customer journey order index \\| \\| --- \\| --- \\| \\| Description \\| The position of the current order within the customer's order history. Test orders aren't included \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer journey order index \| \| Description \| The position of the current order within the customer's order history. Test orders aren't included \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_journey_customer_order_index |
| \| Field label \| Customer journey order index \| \| --- \| --- \| \| Description \| The position of the current order within the customer's order history. Test orders aren't included \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer journey order index |
| Description | The position of the current order within the customer's order history. Test orders aren't included |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_journey_customer_first_visit_landing_page \| \| --- \| \| \\| Field label \\| Customer journey first visit landing page \\| \\| --- \\| --- \\| \\| Description \\| URL of the first page the customer landed on for the session \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer journey first visit landing page \| \| Description \| URL of the first page the customer landed on for the session \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| customer_journey_customer_first_visit_landing_page |
| \| Field label \| Customer journey first visit landing page \| \| --- \| --- \| \| Description \| URL of the first page the customer landed on for the session \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Field label | Customer journey first visit landing page |
| Description | URL of the first page the customer landed on for the session |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| customer_journey_customer_first_visit_referrer_url \| \| --- \| \| \\| Field label \\| Customer journey first visit referrer URL \\| \\| --- \\| --- \\| \\| Description \\| Webpage where the customer clicked a link that sent them to the online store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer journey first visit referrer URL \| \| Description \| Webpage where the customer clicked a link that sent them to the online store \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| customer_journey_customer_first_visit_referrer_url |
| \| Field label \| Customer journey first visit referrer URL \| \| --- \| --- \| \| Description \| Webpage where the customer clicked a link that sent them to the online store \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Field label | Customer journey first visit referrer URL |
| Description | Webpage where the customer clicked a link that sent them to the online store |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| customer_journey_customer_first_visit_source \| \| --- \| \| \\| Field label \\| Customer journey first visit source \\| \\| --- \\| --- \\| \\| Description \\| Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer journey first visit source \| \| Description \| Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_journey_customer_first_visit_source |
| \| Field label \| Customer journey first visit source \| \| --- \| --- \| \| Description \| Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer journey first visit source |
| Description | Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_journey_customer_first_visit_utm_campaign \| \| --- \| \| \\| Field label \\| Customer journey first visit UTM campaign \\| \\| --- \\| --- \\| \\| Description \\| Marketing campaign set as the UTM parameter on the referrer URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer journey first visit UTM campaign \| \| Description \| Marketing campaign set as the UTM parameter on the referrer URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_journey_customer_first_visit_utm_campaign |
| \| Field label \| Customer journey first visit UTM campaign \| \| --- \| --- \| \| Description \| Marketing campaign set as the UTM parameter on the referrer URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer journey first visit UTM campaign |
| Description | Marketing campaign set as the UTM parameter on the referrer URL |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_journey_customer_first_visit_utm_content \| \| --- \| \| \\| Field label \\| Customer journey first visit UTM content \\| \\| --- \\| --- \\| \\| Description \\| Content type set as the UTM parameter on the referrer URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer journey first visit UTM content \| \| Description \| Content type set as the UTM parameter on the referrer URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_journey_customer_first_visit_utm_content |
| \| Field label \| Customer journey first visit UTM content \| \| --- \| --- \| \| Description \| Content type set as the UTM parameter on the referrer URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer journey first visit UTM content |
| Description | Content type set as the UTM parameter on the referrer URL |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_journey_customer_first_visit_utm_medium \| \| --- \| \| \\| Field label \\| Customer journey first visit UTM medium \\| \\| --- \\| --- \\| \\| Description \\| Medium used in the campaign set as the UTM parameter on the referrer URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer journey first visit UTM medium \| \| Description \| Medium used in the campaign set as the UTM parameter on the referrer URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_journey_customer_first_visit_utm_medium |
| \| Field label \| Customer journey first visit UTM medium \| \| --- \| --- \| \| Description \| Medium used in the campaign set as the UTM parameter on the referrer URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer journey first visit UTM medium |
| Description | Medium used in the campaign set as the UTM parameter on the referrer URL |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_journey_customer_first_visit_utm_source \| \| --- \| \| \\| Field label \\| Customer journey first visit UTM source \\| \\| --- \\| --- \\| \\| Description \\| Source of traffic set as the UTM parameter on the referrer URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer journey first visit UTM source \| \| Description \| Source of traffic set as the UTM parameter on the referrer URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_journey_customer_first_visit_utm_source |
| \| Field label \| Customer journey first visit UTM source \| \| --- \| --- \| \| Description \| Source of traffic set as the UTM parameter on the referrer URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer journey first visit UTM source |
| Description | Source of traffic set as the UTM parameter on the referrer URL |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_journey_customer_first_visit_utm_term \| \| --- \| \| \\| Field label \\| Customer journey first visit UTM term \\| \\| --- \\| --- \\| \\| Description \\| Paid search terms set as the UTM parameter on the referrer URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer journey first visit UTM term \| \| Description \| Paid search terms set as the UTM parameter on the referrer URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_journey_customer_first_visit_utm_term |
| \| Field label \| Customer journey first visit UTM term \| \| --- \| --- \| \| Description \| Paid search terms set as the UTM parameter on the referrer URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer journey first visit UTM term |
| Description | Paid search terms set as the UTM parameter on the referrer URL |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |