--- title: "Shopware metrics and dimensions" slug: "shopware-fields" description: "Explore the complete list of Shopware metrics and dimensions available through Supermetrics. Find every data field you need to build your reports." updated: 2026-03-24T10:00:46Z published: 2026-03-24T10:00:46Z --- > ## 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. # Shopware metrics and dimensions > Supermetrics brings all your Shopware 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) 10 metrics67 dimensionsSearch fields ### BILLING | \| billing_address** \| \| --- \| \| \\| Field label \\| Billing address \\| \\| --- \\| --- \\| \\| Description \\| Complete billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing address \| \| Description \| Complete billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | billing_address** | | \| Field label \| Billing address \| \| --- \| --- \| \| Description \| Complete billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Billing address | | Description | Complete billing address | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| billing_country** \| \| --- \| \| \\| Field label \\| Billing country \\| \\| --- \\| --- \\| \\| Description \\| Billing address country name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing country \| \| Description \| Billing address country name \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| | | billing_country** | | \| Field label \| Billing country \| \| --- \| --- \| \| Description \| Billing address country name \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| | | Field label | Billing country | | Description | Billing address country name | | Field type | dimension | | Data type | [string.geo.country](/apidocs/field-data-types#geographical) | | \| billing_country_code** \| \| --- \| \| \\| Field label \\| Billing country code \\| \\| --- \\| --- \\| \\| Description \\| Billing address country code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing country code \| \| Description \| Billing address country code \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | billing_country_code** | | \| Field label \| Billing country code \| \| --- \| --- \| \| Description \| Billing address country code \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | Field label | Billing country code | | Description | Billing address country code | | Field type | dimension | | Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) | | \| billing_city** \| \| --- \| \| \\| Field label \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| Billing address city \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing city \| \| Description \| Billing address city \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| | | billing_city** | | \| Field label \| Billing city \| \| --- \| --- \| \| Description \| Billing address city \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| | | Field label | Billing city | | Description | Billing address city | | Field type | dimension | | Data type | [string.geo.city](/apidocs/field-data-types#geographical) | ### CUSTOMER | \| customer_id** \| \| --- \| \| \\| Field label \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer ID \| \| Description \| 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 \| Unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Customer ID | | Description | Unique identifier of the customer | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| customer_number** \| \| --- \| \| \\| Field label \\| Customer number \\| \\| --- \\| --- \\| \\| Description \\| Customer number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer number \| \| Description \| Customer number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | customer_number** | | \| Field label \| Customer number \| \| --- \| --- \| \| Description \| Customer number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Customer number | | Description | Customer number | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| customer_first_name** \| \| --- \| \| \\| Field label \\| Customer first name \\| \\| --- \\| --- \\| \\| Description \\| First name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer first name \| \| Description \| First name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | customer_first_name** | | \| Field label \| Customer first name \| \| --- \| --- \| \| Description \| First name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Customer first name | | Description | First name of the customer | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| customer_last_name** \| \| --- \| \| \\| Field label \\| Customer last name \\| \\| --- \\| --- \\| \\| Description \\| Last name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer last name \| \| Description \| Last name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | customer_last_name** | | \| Field label \| Customer last name \| \| --- \| --- \| \| Description \| Last name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Customer last name | | Description | Last name of the customer | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| customer_email** \| \| --- \| \| \\| Field label \\| Customer email \\| \\| --- \\| --- \\| \\| Description \\| Email address of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer email \| \| Description \| Email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| | | customer_email** | | \| Field label \| Customer email \| \| --- \| --- \| \| Description \| Email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| | | Field label | Customer email | | Description | Email address of the customer | | Field type | dimension | | Data type | [string.text.email](/apidocs/field-data-types#text) | | \| customer_company** \| \| --- \| \| \\| Field label \\| Customer company \\| \\| --- \\| --- \\| \\| Description \\| Company name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer company \| \| Description \| Company name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | customer_company** | | \| Field label \| Customer company \| \| --- \| --- \| \| Description \| Company name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Customer company | | Description | Company name of the customer | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### 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) | ### ITEM | \| item_id** \| \| --- \| \| \\| Field label \\| Item ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier of the line item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item ID \| \| Description \| Unique identifier of the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | item_id** | | \| Field label \| Item ID \| \| --- \| --- \| \| Description \| Unique identifier of the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Item ID | | Description | Unique identifier of the line item | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| item_name** \| \| --- \| \| \\| Field label \\| Item name \\| \\| --- \\| --- \\| \\| Description \\| Name/label of the line item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item name \| \| Description \| Name/label of the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | item_name** | | \| Field label \| Item name \| \| --- \| --- \| \| Description \| Name/label of the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Item name | | Description | Name/label of the line item | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| product_number** \| \| --- \| \| \\| Field label \\| Product number \\| \\| --- \\| --- \\| \\| Description \\| Product number/SKU \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product number \| \| Description \| Product number/SKU \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | product_number** | | \| Field label \| Product number \| \| --- \| --- \| \| Description \| Product number/SKU \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Product number | | Description | Product number/SKU | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| product_id** \| \| --- \| \| \\| Field label \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product ID \| \| Description \| 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 \| Unique identifier of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Product ID | | Description | Unique identifier of the product | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| product_name** \| \| --- \| \| \\| Field label \\| Product name \\| \\| --- \\| --- \\| \\| Description \\| Name of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product name \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | product_name** | | \| Field label \| Product name \| \| --- \| --- \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Product name | | Description | Name of the product | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| product_ean** \| \| --- \| \| \\| Field label \\| Product EAN \\| \\| --- \\| --- \\| \\| Description \\| EAN code of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product EAN \| \| Description \| EAN code of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | product_ean** | | \| Field label \| Product EAN \| \| --- \| --- \| \| Description \| EAN code of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Product EAN | | Description | EAN code of the product | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| total_price** \| \| --- \| \| \\| Field label \\| Total price \\| \\| --- \\| --- \\| \\| Description \\| Total price of the line item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total price \| \| Description \| Total price of the line item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | total_price** | | \| Field label \| Total price \| \| --- \| --- \| \| Description \| Total price of the line item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Total price | | Description | Total price of the line item | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| unit_price** \| \| --- \| \| \\| Field label \\| Unit price \\| \\| --- \\| --- \\| \\| Description \\| Unit price of the line item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Unit price \| \| Description \| Unit price of the line item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | unit_price** | | \| Field label \| Unit price \| \| --- \| --- \| \| Description \| Unit price of the line item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Unit price | | Description | Unit price of the line item | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| item_tax** \| \| --- \| \| \\| Field label \\| Tax \\| \\| --- \\| --- \\| \\| Description \\| Tax amount for the line item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Tax \| \| Description \| Tax amount for the line item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | item_tax** | | \| Field label \| Tax \| \| --- \| --- \| \| Description \| Tax amount for the line item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Tax | | Description | Tax amount for the line item | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| quantity** \| \| --- \| \| \\| Field label \\| Quantity \\| \\| --- \\| --- \\| \\| Description \\| Quantity of items ordered \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Quantity \| \| Description \| Quantity of items ordered \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | quantity** | | \| Field label \| Quantity \| \| --- \| --- \| \| Description \| Quantity of items ordered \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Quantity | | Description | Quantity of items ordered | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | ### ORDER | \| order_id** \| \| --- \| \| \\| Field label \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order ID \| \| Description \| 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 \| Unique identifier of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Order ID | | Description | Unique identifier of the order | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| order_number** \| \| --- \| \| \\| Field label \\| Order number \\| \\| --- \\| --- \\| \\| Description \\| Human-readable order number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order number \| \| Description \| Human-readable order number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | order_number** | | \| Field label \| Order number \| \| --- \| --- \| \| Description \| Human-readable order number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Order number | | Description | Human-readable order number | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| order_status** \| \| --- \| \| \\| Field label \\| Order status \\| \\| --- \\| --- \\| \\| Description \\| Current status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order status \| \| Description \| Current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | order_status** | | \| Field label \| Order status \| \| --- \| --- \| \| Description \| Current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Order status | | Description | Current status of the order | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| payment_status** \| \| --- \| \| \\| Field label \\| Payment status \\| \\| --- \\| --- \\| \\| Description \\| Payment status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Payment status \| \| Description \| Payment status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | payment_status** | | \| Field label \| Payment status \| \| --- \| --- \| \| Description \| Payment status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Payment status | | Description | Payment status of the order | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| delivery_status** \| \| --- \| \| \\| Field label \\| Delivery status \\| \\| --- \\| --- \\| \\| Description \\| Delivery status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Delivery status \| \| Description \| Delivery status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | delivery_status** | | \| Field label \| Delivery status \| \| --- \| --- \| \| Description \| Delivery status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Delivery status | | Description | Delivery status of the order | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| currency** \| \| --- \| \| \\| Field label \\| Currency \\| \\| --- \\| --- \\| \\| Description \\| Currency code of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Currency \| \| Description \| Currency code of the order \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | currency** | | \| Field label \| Currency \| \| --- \| --- \| \| Description \| Currency code of the order \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Field label | Currency | | Description | Currency code of the order | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | | \| affiliate_code** \| \| --- \| \| \\| Field label \\| Affiliate code \\| \\| --- \\| --- \\| \\| Description \\| Affiliate tracking code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Affiliate code \| \| Description \| Affiliate tracking code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | affiliate_code** | | \| Field label \| Affiliate code \| \| --- \| --- \| \| Description \| Affiliate tracking code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Affiliate code | | Description | Affiliate tracking code | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaign_code** \| \| --- \| \| \\| Field label \\| Campaign code \\| \\| --- \\| --- \\| \\| Description \\| Campaign tracking code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Campaign code \| \| Description \| Campaign tracking code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign_code** | | \| Field label \| Campaign code \| \| --- \| --- \| \| Description \| Campaign tracking code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Campaign code | | Description | Campaign tracking code | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| promotion_code** \| \| --- \| \| \\| Field label \\| Promotion code \\| \\| --- \\| --- \\| \\| Description \\| Promotion code applied to the line item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Promotion code \| \| Description \| Promotion code applied to the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | promotion_code** | | \| Field label \| Promotion code \| \| --- \| --- \| \| Description \| Promotion code applied to the line item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Promotion code | | Description | Promotion code applied to the line item | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| total_gross** \| \| --- \| \| \\| Field label \\| Total (gross) \\| \\| --- \\| --- \\| \\| Description \\| Total order value including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total (gross) \| \| Description \| Total order value including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | total_gross** | | \| Field label \| Total (gross) \| \| --- \| --- \| \| Description \| Total order value including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Total (gross) | | Description | Total order value including tax | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| total_net** \| \| --- \| \| \\| Field label \\| Total (net) \\| \\| --- \\| --- \\| \\| Description \\| Total order value excluding tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total (net) \| \| Description \| Total order value excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | total_net** | | \| Field label \| Total (net) \| \| --- \| --- \| \| Description \| Total order value excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Total (net) | | Description | Total order value excluding tax | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| position_price** \| \| --- \| \| \\| Field label \\| Position price \\| \\| --- \\| --- \\| \\| Description \\| Total price of all line items \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Position price \| \| Description \| Total price of all line items \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | position_price** | | \| Field label \| Position price \| \| --- \| --- \| \| Description \| Total price of all line items \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Position price | | Description | Total price of all line items | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| shipping_total** \| \| --- \| \| \\| Field label \\| Shipping total \\| \\| --- \\| --- \\| \\| Description \\| Total shipping costs \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shipping total \| \| Description \| Total shipping costs \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | shipping_total** | | \| Field label \| Shipping total \| \| --- \| --- \| \| Description \| Total shipping costs \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Shipping total | | Description | Total shipping costs | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| order_tax** \| \| --- \| \| \\| Field label \\| Tax \\| \\| --- \\| --- \\| \\| Description \\| Total tax amount \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Tax \| \| Description \| Total tax amount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | order_tax** | | \| Field label \| Tax \| \| --- \| --- \| \| Description \| Total tax amount \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Tax | | Description | Total tax amount | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| orders** \| \| --- \| \| \\| Field label \\| Orders \\| \\| --- \\| --- \\| \\| Description \\| Number of orders \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Orders \| \| Description \| Number of orders \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | orders** | | \| Field label \| Orders \| \| --- \| --- \| \| Description \| Number of orders \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Orders | | Description | Number of orders | | 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) | ### SALES CHANNEL | \| sales_channel_name** \| \| --- \| \| \\| Field label \\| Sales channel name \\| \\| --- \\| --- \\| \\| Description \\| Name of the sales channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Sales channel name \| \| Description \| Name of the sales channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | sales_channel_name** | | \| Field label \| Sales channel name \| \| --- \| --- \| \| Description \| Name of the sales channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Sales channel name | | Description | Name of the sales channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| sales_channel_id** \| \| --- \| \| \\| Field label \\| Sales channel ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the sales channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Sales channel ID \| \| Description \| ID of the sales channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | sales_channel_id** | | \| Field label \| Sales channel ID \| \| --- \| --- \| \| Description \| ID of the sales channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Sales channel ID | | Description | ID of the sales channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| sales_channel_url** \| \| --- \| \| \\| Field label \\| Sales channel URL \\| \\| --- \\| --- \\| \\| Description \\| URL of the sales channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Sales channel URL \| \| Description \| URL of the sales channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | sales_channel_url** | | \| Field label \| Sales channel URL \| \| --- \| --- \| \| Description \| URL of the sales channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Sales channel URL | | Description | URL of the sales channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### SHIPPING | \| shipping_address** \| \| --- \| \| \\| Field label \\| Shipping address \\| \\| --- \\| --- \\| \\| Description \\| Complete shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping address \| \| Description \| Complete shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | shipping_address** | | \| Field label \| Shipping address \| \| --- \| --- \| \| Description \| Complete shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Shipping address | | Description | Complete shipping address | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| shipping_country** \| \| --- \| \| \\| Field label \\| Shipping country \\| \\| --- \\| --- \\| \\| Description \\| Shipping address country name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping country \| \| Description \| Shipping address country name \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| | | shipping_country** | | \| Field label \| Shipping country \| \| --- \| --- \| \| Description \| Shipping address country name \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| | | Field label | Shipping country | | Description | Shipping address country name | | Field type | dimension | | Data type | [string.geo.country](/apidocs/field-data-types#geographical) | | \| shipping_country_code** \| \| --- \| \| \\| Field label \\| Shipping country code \\| \\| --- \\| --- \\| \\| Description \\| Shipping address country code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping country code \| \| Description \| Shipping address country code \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | shipping_country_code** | | \| Field label \| Shipping country code \| \| --- \| --- \| \| Description \| Shipping address country code \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| | | Field label | Shipping country code | | Description | Shipping address country code | | Field type | dimension | | Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) | | \| shipping_city** \| \| --- \| \| \\| Field label \\| Shipping city \\| \\| --- \\| --- \\| \\| Description \\| Shipping address city \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping city \| \| Description \| Shipping address city \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| | | shipping_city** | | \| Field label \| Shipping city \| \| --- \| --- \| \| Description \| Shipping address city \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| | | Field label | Shipping city | | Description | Shipping address city | | Field type | dimension | | Data type | [string.geo.city](/apidocs/field-data-types#geographical) | ### 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) | | \| year_of_week** \| \| --- \| \| \\| 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) \| | | year_of_week** | | \| 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) | | \| year_of_week_iso** \| \| --- \| \| \\| 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) \| | | year_of_week_iso** | | \| 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) | | \| year_month** \| \| --- \| \| \\| 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) \| | | year_month** | | \| 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) | | \| year_week** \| \| --- \| \| \\| 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) \| | | year_week** | | \| 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) | | \| year_week_iso** \| \| --- \| \| \\| 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) \| | | year_week_iso** | | \| 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) | | \| week_iso** \| \| --- \| \| \\| 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) \| | | week_iso** | | \| 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) | | \| day_of_month** \| \| --- \| \| \\| 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) \| | | day_of_month** | | \| 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) | | \| day_of_week_name** \| \| --- \| \| \\| 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) \| | | day_of_week_name** | | \| 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) | | \| day_of_week_name_iso** \| \| --- \| \| \\| 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) \| | | day_of_week_name_iso** | | \| 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) | | \| atom** \| \| --- \| \| \\| Field label \\| Datetime \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Datetime \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | atom** | | \| Field label \| Datetime \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Datetime | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | ### TIMESTAMP | \| order_date** \| \| --- \| \| \\| Field label \\| Order date \\| \\| --- \\| --- \\| \\| Description \\| Date when the order was placed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order date \| \| Description \| Date when the order was placed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | --- | | order_date** | | \| Field label \| Order date \| \| --- \| --- \| \| Description \| Date when the order was placed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Order date | | Description | Date when the order was placed | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| order_datetime** \| \| --- \| \| \\| Field label \\| Order datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the order was placed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order datetime \| \| Description \| Date and time when the order was placed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | order_datetime** | | \| Field label \| Order datetime \| \| --- \| --- \| \| Description \| Date and time when the order was placed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Order datetime | | Description | Date and time when the order was placed | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| order_created_date** \| \| --- \| \| \\| Field label \\| Order created date \\| \\| --- \\| --- \\| \\| Description \\| Date when the order was created in the system \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order created date \| \| Description \| Date when the order was created in the system \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | order_created_date** | | \| Field label \| Order created date \| \| --- \| --- \| \| Description \| Date when the order was created in the system \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Order created date | | Description | Date when the order was created in the system | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| order_created_datetime** \| \| --- \| \| \\| Field label \\| Order created datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the order was created in the system \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order created datetime \| \| Description \| Date and time when the order was created in the system \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | order_created_datetime** | | \| Field label \| Order created datetime \| \| --- \| --- \| \| Description \| Date and time when the order was created in the system \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Order created datetime | | Description | Date and time when the order was created in the system | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| order_modified_date** \| \| --- \| \| \\| Field label \\| Order modified date \\| \\| --- \\| --- \\| \\| Description \\| Date when the order was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order modified date \| \| Description \| Date when the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | order_modified_date** | | \| Field label \| Order modified date \| \| --- \| --- \| \| Description \| Date when the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Order modified date | | Description | Date when the order was last modified | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| order_modified_datetime** \| \| --- \| \| \\| Field label \\| Order modified datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the order was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order modified datetime \| \| Description \| Date and time when the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | order_modified_datetime** | | \| Field label \| Order modified datetime \| \| --- \| --- \| \| Description \| Date and time when the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Order modified datetime | | Description | Date and time when the order was last modified | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| item_created_date** \| \| --- \| \| \\| Field label \\| Item created date \\| \\| --- \\| --- \\| \\| Description \\| Date when the line item was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Item created date \| \| Description \| Date when the line item was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | item_created_date** | | \| Field label \| Item created date \| \| --- \| --- \| \| Description \| Date when the line item was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Item created date | | Description | Date when the line item was created | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| item_created_datetime** \| \| --- \| \| \\| Field label \\| Item created datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the line item was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Item created datetime \| \| Description \| Date and time when the line item was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | item_created_datetime** | | \| Field label \| Item created datetime \| \| --- \| --- \| \| Description \| Date and time when the line item was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Item created datetime | | Description | Date and time when the line item was created | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) |