---
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 ideal marketing reports."
updated: 2026-05-26T09:00:34Z
published: 2026-05-26T09:00:34Z
---

> ## 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<input type="text" id="field-search" placeholder="Search by field name, label, or description…" aria-label="Search fields by name, label, or description" autocomplete="off">

### 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 \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year** |
| \| Field label \| Year \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| yearOfWeek** \| \| --- \| \| \\| Field label \\| Year of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| yearOfWeek** |
| \| Field label \| Year of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year of week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| yearOfWeekIso** \| \| --- \| \| \\| Field label \\| Year of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| yearOfWeekIso** |
| \| Field label \| Year of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year of week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| yearMonth** \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| |
| yearMonth** |
| \| Field label \| Year & month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| |
| Field label | Year & month |
| Field type | dimension |
| Data type | [string.time.yearmonth](/apidocs/field-data-types#time) |
| \| month** \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| |
| month** |
| \| Field label \| Month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| |
| Field label | Month |
| 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) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| |
| yearWeekIso** |
| \| Field label \| Year & week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| |
| Field label | Year & week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.yearweekiso](/apidocs/field-data-types#time) |
| \| week** \| \| --- \| \| \\| Field label \\| Week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.week](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| |
| week** |
| \| Field label \| Week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| |
| Field label | Week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.week](/apidocs/field-data-types#time) |
| \| weekIso** \| \| --- \| \| \\| Field label \\| Week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.weekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| |
| weekIso** |
| \| Field label \| Week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| |
| Field label | Week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.weekiso](/apidocs/field-data-types#time) |
| \| dayOfMonth** \| \| --- \| \| \\| Field label \\| Day of month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of month \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| |
| dayOfMonth** |
| \| Field label \| Day of month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| |
| Field label | Day of month |
| Field type | dimension |
| Data type | [string.time.dayofmonth](/apidocs/field-data-types#time) |
| \| dayOfWeekName** \| \| --- \| \| \\| Field label \\| Day of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| |
| dayOfWeekName** |
| \| Field label \| Day of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| |
| Field label | Day of week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.dayofweek](/apidocs/field-data-types#time) |
| \| dayOfWeekNameIso** \| \| --- \| \| \\| Field label \\| Day of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| |
| dayOfWeekNameIso** |
| \| Field label \| Day of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| |
| Field label | Day of week (Mon-Sun) |
| 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) |