---
title: "BigCommerce metrics and dimensions"
slug: "bigcommerce-fields"
description: "Explore the complete list of BigCommerce metrics and dimensions available through Supermetrics. Find every data field you need to build your ideal marketing reports."
updated: 2026-03-05T14:06:50Z
published: 2026-03-05T14:06:50Z
---

> ## 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.

# BigCommerce metrics and dimensions

> Supermetrics brings all your BigCommerce 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)

33 metrics71 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">

### BILLING

| \| billing_first_name** \| \| --- \| \| \\| Field label \\| Billing first name \\| \\| --- \\| --- \\| \\| Description \\| First name of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing first name \| \| Description \| First name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| billing_first_name** |
| \| Field label \| Billing first name \| \| --- \| --- \| \| Description \| First name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing first name |
| Description | First name of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_last_name** \| \| --- \| \| \\| Field label \\| Billing last name \\| \\| --- \\| --- \\| \\| Description \\| Last name of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing last name \| \| Description \| Last name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_last_name** |
| \| Field label \| Billing last name \| \| --- \| --- \| \| Description \| Last name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing last name |
| Description | Last name of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_company** \| \| --- \| \| \\| Field label \\| Billing company \\| \\| --- \\| --- \\| \\| Description \\| Company name of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing company \| \| Description \| Company name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_company** |
| \| Field label \| Billing company \| \| --- \| --- \| \| Description \| Company name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing company |
| Description | Company name of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_street_1** \| \| --- \| \| \\| Field label \\| Billing street 1 \\| \\| --- \\| --- \\| \\| Description \\| Street address of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing street 1 \| \| Description \| Street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| billing_street_1** |
| \| Field label \| Billing street 1 \| \| --- \| --- \| \| Description \| Street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Field label | Billing street 1 |
| Description | Street address of the billing address |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_street_2** \| \| --- \| \| \\| Field label \\| Billing street 2 \\| \\| --- \\| --- \\| \\| Description \\| Additional street address of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing street 2 \| \| Description \| Additional street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| billing_street_2** |
| \| Field label \| Billing street 2 \| \| --- \| --- \| \| Description \| Additional street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Field label | Billing street 2 |
| Description | Additional street address of the billing address |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_city** \| \| --- \| \| \\| Field label \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| City of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing city \| \| Description \| City of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| billing_city** |
| \| Field label \| Billing city \| \| --- \| --- \| \| Description \| City of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | Billing city |
| Description | City of the billing address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| billing_state** \| \| --- \| \| \\| Field label \\| Billing state \\| \\| --- \\| --- \\| \\| Description \\| State/province of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing state \| \| Description \| State/province of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| billing_state** |
| \| Field label \| Billing state \| \| --- \| --- \| \| Description \| State/province of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Field label | Billing state |
| Description | State/province of the billing address |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| billing_zip** \| \| --- \| \| \\| Field label \\| Billing zip \\| \\| --- \\| --- \\| \\| Description \\| Zip/postal code of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.zip](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing zip \| \| Description \| Zip/postal code of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| billing_zip** |
| \| Field label \| Billing zip \| \| --- \| --- \| \| Description \| Zip/postal code of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| Field label | Billing zip |
| Description | Zip/postal code of the billing address |
| Field type | dimension |
| Data type | [string.geo.zip](/apidocs/field-data-types#geographical) |
| \| billing_country** \| \| --- \| \| \\| Field label \\| Billing country \\| \\| --- \\| --- \\| \\| Description \\| Country of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing country \| \| Description \| Country of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| billing_country** |
| \| Field label \| Billing country \| \| --- \| --- \| \| Description \| Country of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Field label | Billing country |
| Description | Country of the billing address |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| billing_country_iso2** \| \| --- \| \| \\| Field label \\| Billing country (ISO2) \\| \\| --- \\| --- \\| \\| Description \\| ISO 2-letter code for the billing country \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing country (ISO2) \| \| Description \| ISO 2-letter code for the billing country \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| billing_country_iso2** |
| \| Field label \| Billing country (ISO2) \| \| --- \| --- \| \| Description \| ISO 2-letter code for the billing country \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Field label | Billing country (ISO2) |
| Description | ISO 2-letter code for the billing country |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| billing_phone** \| \| --- \| \| \\| Field label \\| Billing phone \\| \\| --- \\| --- \\| \\| Description \\| Phone number of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing phone \| \| Description \| Phone number of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| billing_phone** |
| \| Field label \| Billing phone \| \| --- \| --- \| \| Description \| Phone number of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Field label | Billing phone |
| Description | Phone number of the billing address |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| billing_email** \| \| --- \| \| \\| Field label \\| Billing email \\| \\| --- \\| --- \\| \\| Description \\| Email address of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing email \| \| Description \| Email address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| billing_email** |
| \| Field label \| Billing email \| \| --- \| --- \| \| Description \| Email address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Field label | Billing email |
| Description | Email address of the billing address |
| Field type | dimension |
| Data type | [string.text.email](/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) |

### DISCOUNT

| \| store_credit** \| \| --- \| \| \\| Field label \\| Store credit \\| \\| --- \\| --- \\| \\| Description \\| The store credit that the shopper has redeemed on this individual order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Store credit \| \| Description \| The store credit that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| --- |
| store_credit** |
| \| Field label \| Store credit \| \| --- \| --- \| \| Description \| The store credit that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Store credit |
| Description | The store credit that the shopper has redeemed on this individual order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| gift_certificate** \| \| --- \| \| \\| Field label \\| Gift certificate \\| \\| --- \\| --- \\| \\| Description \\| The gift certificate that the shopper has redeemed on this individual order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Gift certificate \| \| Description \| The gift certificate that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| gift_certificate** |
| \| Field label \| Gift certificate \| \| --- \| --- \| \| Description \| The gift certificate that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Gift certificate |
| Description | The gift certificate that the shopper has redeemed on this individual order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| coupon** \| \| --- \| \| \\| Field label \\| Coupon \\| \\| --- \\| --- \\| \\| Description \\| The coupon amount that the shopper has redeemed on this individual order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Coupon \| \| Description \| The coupon amount that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| coupon** |
| \| Field label \| Coupon \| \| --- \| --- \| \| Description \| The coupon amount that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Coupon |
| Description | The coupon amount that the shopper has redeemed on this individual order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| refunded_amount** \| \| --- \| \| \\| Field label \\| Refunded amount \\| \\| --- \\| --- \\| \\| Description \\| The amount refunded from this transaction \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Refunded amount \| \| Description \| The amount refunded from this transaction \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| refunded_amount** |
| \| Field label \| Refunded amount \| \| --- \| --- \| \| Description \| The amount refunded from this transaction \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Refunded amount |
| Description | The amount refunded from this transaction |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### EXCLUDING TAX

| \| subtotal_ex_tax** \| \| --- \| \| \\| Field label \\| Subtotal (ex tax) \\| \\| --- \\| --- \\| \\| Description \\| The value of subtotal, excluding tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Subtotal (ex tax) \| \| Description \| The value of subtotal, excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| --- |
| subtotal_ex_tax** |
| \| Field label \| Subtotal (ex tax) \| \| --- \| --- \| \| Description \| The value of subtotal, excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Subtotal (ex tax) |
| Description | The value of subtotal, excluding tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shipping_ex_tax** \| \| --- \| \| \\| Field label \\| Shipping (ex tax) \\| \\| --- \\| --- \\| \\| Description \\| The value of shipping cost, excluding tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shipping (ex tax) \| \| Description \| The value of shipping cost, excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shipping_ex_tax** |
| \| Field label \| Shipping (ex tax) \| \| --- \| --- \| \| Description \| The value of shipping cost, excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shipping (ex tax) |
| Description | The value of shipping cost, excluding tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| handling_ex_tax** \| \| --- \| \| \\| Field label \\| Handling (ex tax) \\| \\| --- \\| --- \\| \\| Description \\| The value of the handling cost, excluding tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Handling (ex tax) \| \| Description \| The value of the handling cost, excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| handling_ex_tax** |
| \| Field label \| Handling (ex tax) \| \| --- \| --- \| \| Description \| The value of the handling cost, excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Handling (ex tax) |
| Description | The value of the handling cost, excluding tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| wrapping_ex_tax** \| \| --- \| \| \\| Field label \\| Wrapping (ex tax) \\| \\| --- \\| --- \\| \\| Description \\| The value of the wrapping cost, excluding tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Wrapping (ex tax) \| \| Description \| The value of the wrapping cost, excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| wrapping_ex_tax** |
| \| Field label \| Wrapping (ex tax) \| \| --- \| --- \| \| Description \| The value of the wrapping cost, excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Wrapping (ex tax) |
| Description | The value of the wrapping cost, excluding tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_ex_taxes** \| \| --- \| \| \\| Field label \\| Total (ex tax) \\| \\| --- \\| --- \\| \\| Description \\| The value of the order, excluding tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total (ex tax) \| \| Description \| The value of the order, excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_ex_taxes** |
| \| Field label \| Total (ex tax) \| \| --- \| --- \| \| Description \| The value of the order, excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total (ex tax) |
| Description | The value of the order, excluding tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### ITEMS

| \| items_total** \| \| --- \| \| \\| Field label \\| Items total \\| \\| --- \\| --- \\| \\| Description \\| The total number of items in the order \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Items total \| \| Description \| The total number of items in the order \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| --- |
| items_total** |
| \| Field label \| Items total \| \| --- \| --- \| \| Description \| The total number of items in the order \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Items total |
| Description | The total number of items in the order |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| items_shipped** \| \| --- \| \| \\| Field label \\| Items shipped \\| \\| --- \\| --- \\| \\| Description \\| The number of items that have been shipped \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Items shipped \| \| Description \| The number of items that have been shipped \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| items_shipped** |
| \| Field label \| Items shipped \| \| --- \| --- \| \| Description \| The number of items that have been shipped \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Items shipped |
| Description | The number of items that have been shipped |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

### ORDER

| \| order_id** \| \| --- \| \| \\| Field label \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order ID \| \| Description \| Unique identifier for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| order_id** |
| \| Field label \| Order ID \| \| --- \| --- \| \| Description \| Unique identifier for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order ID |
| Description | Unique identifier for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_id** \| \| --- \| \| \\| Field label \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer ID \| \| Description \| Unique identifier for the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_id** |
| \| Field label \| Customer ID \| \| --- \| --- \| \| Description \| Unique identifier for the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer ID |
| Description | Unique identifier for the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| status_id** \| \| --- \| \| \\| Field label \\| Status ID \\| \\| --- \\| --- \\| \\| Description \\| The status ID of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Status ID \| \| Description \| The status ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| status_id** |
| \| Field label \| Status ID \| \| --- \| --- \| \| Description \| The status ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Status ID |
| Description | The status ID of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| status** \| \| --- \| \| \\| Field label \\| Status \\| \\| --- \\| --- \\| \\| Description \\| Current status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Status \| \| Description \| Current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| status** |
| \| Field label \| Status \| \| --- \| --- \| \| Description \| Current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Status |
| Description | Current status of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| custom_status** \| \| --- \| \| \\| Field label \\| Custom status \\| \\| --- \\| --- \\| \\| Description \\| Custom status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Custom status \| \| Description \| Custom status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| custom_status** |
| \| Field label \| Custom status \| \| --- \| --- \| \| Description \| Custom status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Custom status |
| Description | Custom status of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_message** \| \| --- \| \| \\| Field label \\| Customer message \\| \\| --- \\| --- \\| \\| Description \\| Message that the customer entered \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer message \| \| Description \| Message that the customer entered \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_message** |
| \| Field label \| Customer message \| \| --- \| --- \| \| Description \| Message that the customer entered \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer message |
| Description | Message that the customer entered |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_is_digital** \| \| --- \| \| \\| Field label \\| Order is digital \\| \\| --- \\| --- \\| \\| Description \\| Whether this is an order for digital products \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Order is digital \| \| Description \| Whether this is an order for digital products \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| order_is_digital** |
| \| Field label \| Order is digital \| \| --- \| --- \| \| Description \| Whether this is an order for digital products \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Order is digital |
| Description | Whether this is an order for digital products |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| ip_address** \| \| --- \| \| \\| Field label \\| IP address \\| \\| --- \\| --- \\| \\| Description \\| IPv4 Address of the customer, if known \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| IP address \| \| Description \| IPv4 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| ip_address** |
| \| Field label \| IP address \| \| --- \| --- \| \| Description \| IPv4 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | IP address |
| Description | IPv4 Address of the customer, if known |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| ip_address_v6** \| \| --- \| \| \\| Field label \\| IP address v6 \\| \\| --- \\| --- \\| \\| Description \\| IPv6 Address of the customer, if known \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| IP address v6 \| \| Description \| IPv6 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| ip_address_v6** |
| \| Field label \| IP address v6 \| \| --- \| --- \| \| Description \| IPv6 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | IP address v6 |
| Description | IPv6 Address of the customer, if known |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| geoip_country** \| \| --- \| \| \\| Field label \\| GeoIP country \\| \\| --- \\| --- \\| \\| Description \\| The full name of the country where the customer made the purchase, based on the IP \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Field label \| GeoIP country \| \| Description \| The full name of the country where the customer made the purchase, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| geoip_country** |
| \| Field label \| GeoIP country \| \| --- \| --- \| \| Description \| The full name of the country where the customer made the purchase, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Field label | GeoIP country |
| Description | The full name of the country where the customer made the purchase, based on the IP |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| geoip_country_iso2** \| \| --- \| \| \\| Field label \\| GeoIP country (ISO2) \\| \\| --- \\| --- \\| \\| Description \\| The country where the customer made the purchase, in ISO2 format, based on the IP \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| GeoIP country (ISO2) \| \| Description \| The country where the customer made the purchase, in ISO2 format, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| geoip_country_iso2** |
| \| Field label \| GeoIP country (ISO2) \| \| --- \| --- \| \| Description \| The country where the customer made the purchase, in ISO2 format, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Field label | GeoIP country (ISO2) |
| Description | The country where the customer made the purchase, in ISO2 format, based on the IP |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| order_source** \| \| --- \| \| \\| Field label \\| Order source \\| \\| --- \\| --- \\| \\| Description \\| Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order source \| \| Description \| Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_source** |
| \| Field label \| Order source \| \| --- \| --- \| \| Description \| Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order source |
| Description | Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| channel_id** \| \| --- \| \| \\| Field label \\| Channel ID \\| \\| --- \\| --- \\| \\| Description \\| Shows where the order originated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Channel ID \| \| Description \| Shows where the order originated \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| channel_id** |
| \| Field label \| Channel ID \| \| --- \| --- \| \| Description \| Shows where the order originated \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Channel ID |
| Description | Shows where the order originated |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| external_id** \| \| --- \| \| \\| Field label \\| External ID \\| \\| --- \\| --- \\| \\| Description \\| The order ID in another system, such as the Amazon order ID if this is an Amazon order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| External ID \| \| Description \| The order ID in another system, such as the Amazon order ID if this is an Amazon order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| external_id** |
| \| Field label \| External ID \| \| --- \| --- \| \| Description \| The order ID in another system, such as the Amazon order ID if this is an Amazon order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | External ID |
| Description | The order ID in another system, such as the Amazon order ID if this is an Amazon order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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) |
| \| subtotal** \| \| --- \| \| \\| Field label \\| Subtotal \\| \\| --- \\| --- \\| \\| Description \\| The value of subtotal including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Subtotal \| \| Description \| The value of subtotal including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| subtotal** |
| \| Field label \| Subtotal \| \| --- \| --- \| \| Description \| The value of subtotal including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Subtotal |
| Description | The value of subtotal including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| discount_amount** \| \| --- \| \| \\| Field label \\| Discount \\| \\| --- \\| --- \\| \\| Description \\| Amount of discount for this transaction \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Discount \| \| Description \| Amount of discount for this transaction \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| discount_amount** |
| \| Field label \| Discount \| \| --- \| --- \| \| Description \| Amount of discount for this transaction \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Discount |
| Description | Amount of discount for this transaction |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shipping** \| \| --- \| \| \\| Field label \\| Shipping \\| \\| --- \\| --- \\| \\| Description \\| The value of shipping cost, including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shipping \| \| Description \| The value of shipping cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shipping** |
| \| Field label \| Shipping \| \| --- \| --- \| \| Description \| The value of shipping cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shipping |
| Description | The value of shipping cost, including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| handling** \| \| --- \| \| \\| Field label \\| Handling \\| \\| --- \\| --- \\| \\| Description \\| The value of the handling cost, including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Handling \| \| Description \| The value of the handling cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| handling** |
| \| Field label \| Handling \| \| --- \| --- \| \| Description \| The value of the handling cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Handling |
| Description | The value of the handling cost, including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| wrapping** \| \| --- \| \| \\| Field label \\| Wrapping \\| \\| --- \\| --- \\| \\| Description \\| The value of the wrapping cost, including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Wrapping \| \| Description \| The value of the wrapping cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| wrapping** |
| \| Field label \| Wrapping \| \| --- \| --- \| \| Description \| The value of the wrapping cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Wrapping |
| Description | The value of the wrapping cost, including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total** \| \| --- \| \| \\| Field label \\| Total \\| \\| --- \\| --- \\| \\| Description \\| Total value of the order including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total \| \| Description \| Total value of the order including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total** |
| \| Field label \| Total \| \| --- \| --- \| \| Description \| Total value of the order including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total |
| Description | Total value of the order including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### PAYMENT

| \| payment_method** \| \| --- \| \| \\| Field label \\| Payment method \\| \\| --- \\| --- \\| \\| Description \\| The payment method for this order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Payment method \| \| Description \| The payment method for this order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| payment_method** |
| \| Field label \| Payment method \| \| --- \| --- \| \| Description \| The payment method for this order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Payment method |
| Description | The payment method for this order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_provider_id** \| \| --- \| \| \\| Field label \\| Payment provider ID \\| \\| --- \\| --- \\| \\| Description \\| The external transaction ID/payment ID within this order’s payment provider \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Payment provider ID \| \| Description \| The external transaction ID/payment ID within this order’s payment provider \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_provider_id** |
| \| Field label \| Payment provider ID \| \| --- \| --- \| \| Description \| The external transaction ID/payment ID within this order’s payment provider \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Payment provider ID |
| Description | The external transaction ID/payment ID within this order’s payment provider |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_status** \| \| --- \| \| \\| Field label \\| Payment status \\| \\| --- \\| --- \\| \\| Description \\| Status of the payment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Payment status \| \| Description \| Status of the payment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_status** |
| \| Field label \| Payment status \| \| --- \| --- \| \| Description \| Status of the payment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Payment status |
| Description | Status of the payment |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| currency_id** \| \| --- \| \| \\| Field label \\| Currency ID \\| \\| --- \\| --- \\| \\| Description \\| The active currency ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Currency ID \| \| Description \| The active currency ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| currency_id** |
| \| Field label \| Currency ID \| \| --- \| --- \| \| Description \| The active currency ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Currency ID |
| Description | The active currency ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| currency_code** \| \| --- \| \| \\| Field label \\| Currency code \\| \\| --- \\| --- \\| \\| Description \\| The currency code associated with the price record being acted upon \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Currency code \| \| Description \| The currency code associated with the price record being acted upon \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| currency_code** |
| \| Field label \| Currency code \| \| --- \| --- \| \| Description \| The currency code associated with the price record being acted upon \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Currency code |
| Description | The currency code associated with the price record being acted upon |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |

### PRODUCT

| \| product_id** \| \| --- \| \| \\| Field label \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| Numeric ID of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product ID \| \| Description \| Numeric ID of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| product_id** |
| \| Field label \| Product ID \| \| --- \| --- \| \| Description \| Numeric ID of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product ID |
| Description | Numeric ID 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) |
| \| sku** \| \| --- \| \| \\| Field label \\| SKU \\| \\| --- \\| --- \\| \\| Description \\| User-defined product code/stock keeping unit (SKU) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| SKU \| \| Description \| User-defined product code/stock keeping unit (SKU) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| sku** |
| \| Field label \| SKU \| \| --- \| --- \| \| Description \| User-defined product code/stock keeping unit (SKU) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | SKU |
| Description | User-defined product code/stock keeping unit (SKU) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| upc** \| \| --- \| \| \\| Field label \\| UPC \\| \\| --- \\| --- \\| \\| Description \\| Universal product code. Can be written to for custom products and catalog products \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| UPC \| \| Description \| Universal product code. Can be written to for custom products and catalog products \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| upc** |
| \| Field label \| UPC \| \| --- \| --- \| \| Description \| Universal product code. Can be written to for custom products and catalog products \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | UPC |
| Description | Universal product code. Can be written to for custom products and catalog products |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| type** \| \| --- \| \| \\| Field label \\| Type \\| \\| --- \\| --- \\| \\| Description \\| Type of product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Type \| \| Description \| Type of product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| type** |
| \| Field label \| Type \| \| --- \| --- \| \| Description \| Type of product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Type |
| Description | Type of product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| brand** \| \| --- \| \| \\| Field label \\| Brand \\| \\| --- \\| --- \\| \\| Description \\| The products brand \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Brand \| \| Description \| The products brand \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| brand** |
| \| Field label \| Brand \| \| --- \| --- \| \| Description \| The products brand \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Brand |
| Description | The products brand |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| quantity** \| \| --- \| \| \\| Field label \\| Quantity \\| \\| --- \\| --- \\| \\| Description \\| Quantity of the product ordered \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Quantity \| \| Description \| Quantity of the product ordered \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| quantity** |
| \| Field label \| Quantity \| \| --- \| --- \| \| Description \| Quantity of the product ordered \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Quantity |
| Description | Quantity of the product ordered |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| quantity_refunded** \| \| --- \| \| \\| Field label \\| Quantity refunded \\| \\| --- \\| --- \\| \\| Description \\| The total quantity of product refunded from this transaction \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Quantity refunded \| \| Description \| The total quantity of product refunded from this transaction \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| quantity_refunded** |
| \| Field label \| Quantity refunded \| \| --- \| --- \| \| Description \| The total quantity of product refunded from this transaction \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Quantity refunded |
| Description | The total quantity of product refunded from this transaction |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| price_base** \| \| --- \| \| \\| Field label \\| Price (base) \\| \\| --- \\| --- \\| \\| Description \\| The product’s cost price \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Price (base) \| \| Description \| The product’s cost price \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| price_base** |
| \| Field label \| Price (base) \| \| --- \| --- \| \| Description \| The product’s cost price \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Price (base) |
| Description | The product’s cost price |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| price_ex_tax** \| \| --- \| \| \\| Field label \\| Price (ex tax) \\| \\| --- \\| --- \\| \\| Description \\| The product cost price excluding tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Price (ex tax) \| \| Description \| The product cost price excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| price_ex_tax** |
| \| Field label \| Price (ex tax) \| \| --- \| --- \| \| Description \| The product cost price excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Price (ex tax) |
| Description | The product cost price excluding tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| price_inc_tax** \| \| --- \| \| \\| Field label \\| Price (inc tax) \\| \\| --- \\| --- \\| \\| Description \\| The product’s cost price including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Price (inc tax) \| \| Description \| The product’s cost price including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| price_inc_tax** |
| \| Field label \| Price (inc tax) \| \| --- \| --- \| \| Description \| The product’s cost price including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Price (inc tax) |
| Description | The product’s cost price including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| price_tax** \| \| --- \| \| \\| Field label \\| Price tax \\| \\| --- \\| --- \\| \\| Description \\| The product cost price excluding tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Price tax \| \| Description \| The product cost price excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| price_tax** |
| \| Field label \| Price tax \| \| --- \| --- \| \| Description \| The product cost price excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Price tax |
| Description | The product cost price excluding tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_base** \| \| --- \| \| \\| Field label \\| Total (base) \\| \\| --- \\| --- \\| \\| Description \\| Total base price \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total (base) \| \| Description \| Total base price \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_base** |
| \| Field label \| Total (base) \| \| --- \| --- \| \| Description \| Total base price \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total (base) |
| Description | Total base price |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_ex_tax** \| \| --- \| \| \\| Field label \\| Total (ex tax) \\| \\| --- \\| --- \\| \\| Description \\| Total base price excluding tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total (ex tax) \| \| Description \| Total base price excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_ex_tax** |
| \| Field label \| Total (ex tax) \| \| --- \| --- \| \| Description \| Total base price excluding tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total (ex tax) |
| Description | Total base price excluding tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_inc_tax** \| \| --- \| \| \\| Field label \\| Total (inc tax) \\| \\| --- \\| --- \\| \\| Description \\| Total base price including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total (inc tax) \| \| Description \| Total base price including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_inc_tax** |
| \| Field label \| Total (inc tax) \| \| --- \| --- \| \| Description \| Total base price including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total (inc tax) |
| Description | Total base price including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_tax** \| \| --- \| \| \\| Field label \\| Total tax \\| \\| --- \\| --- \\| \\| Description \\| Total tax applied to products \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total tax \| \| Description \| Total tax applied to products \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_tax** |
| \| Field label \| Total tax \| \| --- \| --- \| \| Description \| Total tax applied to products \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total tax |
| Description | Total tax applied to products |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### 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) |

### STORE

| \| store_hash** \| \| --- \| \| \\| Field label \\| Store hash \\| \\| --- \\| --- \\| \\| Description \\| The name of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store hash \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| store_hash** |
| \| Field label \| Store hash \| \| --- \| --- \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store hash |
| Description | The name of the store |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### TAX

| \| shipping_tax** \| \| --- \| \| \\| Field label \\| Shipping tax \\| \\| --- \\| --- \\| \\| Description \\| Tax amount for shipping \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shipping tax \| \| Description \| Tax amount for shipping \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| --- |
| shipping_tax** |
| \| Field label \| Shipping tax \| \| --- \| --- \| \| Description \| Tax amount for shipping \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shipping tax |
| Description | Tax amount for shipping |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| handling_tax** \| \| --- \| \| \\| Field label \\| Handling tax \\| \\| --- \\| --- \\| \\| Description \\| Tax amount for handling \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Handling tax \| \| Description \| Tax amount for handling \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| handling_tax** |
| \| Field label \| Handling tax \| \| --- \| --- \| \| Description \| Tax amount for handling \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Handling tax |
| Description | Tax amount for handling |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| wrapping_tax** \| \| --- \| \| \\| Field label \\| Wrapping tax \\| \\| --- \\| --- \\| \\| Description \\| Tax amount for wrapping \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Wrapping tax \| \| Description \| Tax amount for wrapping \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| wrapping_tax** |
| \| Field label \| Wrapping tax \| \| --- \| --- \| \| Description \| Tax amount for wrapping \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Wrapping tax |
| Description | Tax amount for wrapping |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| subtotal_tax** \| \| --- \| \| \\| Field label \\| Subtotal tax \\| \\| --- \\| --- \\| \\| Description \\| Tax amount for the subtotal \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Subtotal tax \| \| Description \| Tax amount for the subtotal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| subtotal_tax** |
| \| Field label \| Subtotal tax \| \| --- \| --- \| \| Description \| Tax amount for the subtotal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Subtotal tax |
| Description | Tax amount for the subtotal |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_taxes** \| \| --- \| \| \\| Field label \\| Total tax \\| \\| --- \\| --- \\| \\| Description \\| Total tax amount for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total tax \| \| Description \| Total tax amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_taxes** |
| \| Field label \| Total tax \| \| --- \| --- \| \| Description \| Total tax amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total tax |
| Description | Total tax amount for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### 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

| \| created_date** \| \| --- \| \| \\| Field label \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| Date the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Created date \| \| Description \| Date the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| created_date** |
| \| Field label \| Created date \| \| --- \| --- \| \| Description \| Date the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Created date |
| Description | Date the order was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| created_datetime** \| \| --- \| \| \\| Field label \\| Created datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Created datetime \| \| Description \| Date and time the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| created_datetime** |
| \| Field label \| Created datetime \| \| --- \| --- \| \| Description \| Date and time the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Created datetime |
| Description | Date and time the order was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| modified_date** \| \| --- \| \| \\| Field label \\| Modified date \\| \\| --- \\| --- \\| \\| Description \\| Date the order was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Modified date \| \| Description \| Date the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| modified_date** |
| \| Field label \| Modified date \| \| --- \| --- \| \| Description \| Date the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Modified date |
| Description | Date the order was last modified |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| modified_datetime** \| \| --- \| \| \\| Field label \\| Modified datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time the order was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Modified datetime \| \| Description \| Date and time the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| modified_datetime** |
| \| Field label \| Modified datetime \| \| --- \| --- \| \| Description \| Date and time the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Modified datetime |
| Description | Date and time the order was last modified |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| shipped_date** \| \| --- \| \| \\| Field label \\| Shipped date \\| \\| --- \\| --- \\| \\| Description \\| Date the order was shipped \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Shipped date \| \| Description \| Date the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| shipped_date** |
| \| Field label \| Shipped date \| \| --- \| --- \| \| Description \| Date the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Shipped date |
| Description | Date the order was shipped |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| shipped_datetime** \| \| --- \| \| \\| Field label \\| Shipped datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time the order was shipped \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Shipped datetime \| \| Description \| Date and time the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| shipped_datetime** |
| \| Field label \| Shipped datetime \| \| --- \| --- \| \| Description \| Date and time the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Shipped datetime |
| Description | Date and time the order was shipped |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |