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

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

# 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

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