---
title: "Adobe Commerce (Magento 2) metrics and dimensions"
slug: "adobe-commerce-magento-2-fields"
description: "Explore the complete list of Adobe Commerce (Magento 2) metrics and dimensions available through Supermetrics. Find every data field you need to build your ideal marketing reports."
updated: 2026-03-05T14:19:18Z
published: 2026-03-05T14:19:18Z
---

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

# Adobe Commerce (Magento 2) metrics and dimensions

> Supermetrics brings all your Adobe Commerce (Magento 2) 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)

25 metrics94 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 \\| The first name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing first name \| \| Description \| The first name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| billing_first_name** |
| \| Field label \| Billing first name \| \| --- \| --- \| \| Description \| The first name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing first name |
| Description | The first name of the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_middle_name** \| \| --- \| \| \\| Field label \\| Billing middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing middle name \| \| Description \| The middle name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_middle_name** |
| \| Field label \| Billing middle name \| \| --- \| --- \| \| Description \| The middle name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing middle name |
| Description | The middle name of the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_last_name** \| \| --- \| \| \\| Field label \\| Billing last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing last name \| \| Description \| The last name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_last_name** |
| \| Field label \| Billing last name \| \| --- \| --- \| \| Description \| The last name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing last name |
| Description | The last name of the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_company** \| \| --- \| \| \\| Field label \\| Billing company \\| \\| --- \\| --- \\| \\| Description \\| The company name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing company \| \| Description \| The company name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_company** |
| \| Field label \| Billing company \| \| --- \| --- \| \| Description \| The company name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing company |
| Description | The company name of the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_address_type** \| \| --- \| \| \\| Field label \\| Billing address type \\| \\| --- \\| --- \\| \\| Description \\| The type of address associated with the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing address type \| \| Description \| The type of address associated with the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_address_type** |
| \| Field label \| Billing address type \| \| --- \| --- \| \| Description \| The type of address associated with the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing address type |
| Description | The type of address associated with the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_street** \| \| --- \| \| \\| Field label \\| Billing street \\| \\| --- \\| --- \\| \\| Description \\| The street address of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing street \| \| Description \| The street address of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| billing_street** |
| \| Field label \| Billing street \| \| --- \| --- \| \| Description \| The street address of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Field label | Billing street |
| Description | The street address of the billing customer |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_city** \| \| --- \| \| \\| Field label \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| The city of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing city \| \| Description \| The 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 \| The city of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | Billing city |
| Description | The city of the billing address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| billing_region** \| \| --- \| \| \\| Field label \\| Billing region \\| \\| --- \\| --- \\| \\| Description \\| The region or state of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing region \| \| Description \| The region or state of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| billing_region** |
| \| Field label \| Billing region \| \| --- \| --- \| \| Description \| The region or state of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Field label | Billing region |
| Description | The region or state of the billing address |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| billing_region_id** \| \| --- \| \| \\| Field label \\| Billing region ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier for the region of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing region ID \| \| Description \| The unique identifier for the region of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| billing_region_id** |
| \| Field label \| Billing region ID \| \| --- \| --- \| \| Description \| The unique identifier for the region of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Field label | Billing region ID |
| Description | The unique identifier for the region of the billing address |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| billing_region_code** \| \| --- \| \| \\| Field label \\| Billing region code \\| \\| --- \\| --- \\| \\| Description \\| The code representing the region of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing region code \| \| Description \| The code representing the region of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| billing_region_code** |
| \| Field label \| Billing region code \| \| --- \| --- \| \| Description \| The code representing the region of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Field label | Billing region code |
| Description | The code representing the region of the billing address |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| billing_postal_code** \| \| --- \| \| \\| Field label \\| Billing postal code \\| \\| --- \\| --- \\| \\| Description \\| The postal code of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing postal code \| \| Description \| The postal code of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_postal_code** |
| \| Field label \| Billing postal code \| \| --- \| --- \| \| Description \| The postal code of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing postal code |
| Description | The postal code of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_country_id** \| \| --- \| \| \\| Field label \\| Billing country ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier for the country of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing country ID \| \| Description \| The unique identifier for the country of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| billing_country_id** |
| \| Field label \| Billing country ID \| \| --- \| --- \| \| Description \| The unique identifier for the country of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Field label | Billing country ID |
| Description | The unique identifier for the country of the billing address |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| billing_email** \| \| --- \| \| \\| Field label \\| Billing email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing email \| \| Description \| The email address of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| billing_email** |
| \| Field label \| Billing email \| \| --- \| --- \| \| Description \| The email address of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Field label | Billing email |
| Description | The email address of the billing customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| billing_telephone** \| \| --- \| \| \\| Field label \\| Billing telephone \\| \\| --- \\| --- \\| \\| Description \\| The telephone number of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing telephone \| \| Description \| The telephone number of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| billing_telephone** |
| \| Field label \| Billing telephone \| \| --- \| --- \| \| Description \| The telephone number of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Field label | Billing telephone |
| Description | The telephone number of the billing customer |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| billing_fax** \| \| --- \| \| \\| Field label \\| Billing fax \\| \\| --- \\| --- \\| \\| Description \\| The fax number of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing fax \| \| Description \| The fax number of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_fax** |
| \| Field label \| Billing fax \| \| --- \| --- \| \| Description \| The fax number of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing fax |
| Description | The fax number of the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### CUSTOMER

| \| customer_id** \| \| --- \| \| \\| Field label \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer ID \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| customer_id** |
| \| Field label \| Customer ID \| \| --- \| --- \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer ID |
| Description | The unique identifier of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_group_id** \| \| --- \| \| \\| Field label \\| Customer group ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the customer group \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer group ID \| \| Description \| The unique identifier of the customer group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_group_id** |
| \| Field label \| Customer group ID \| \| --- \| --- \| \| Description \| The unique identifier of the customer group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer group ID |
| Description | The unique identifier of the customer group |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_prefix** \| \| --- \| \| \\| Field label \\| Customer prefix \\| \\| --- \\| --- \\| \\| Description \\| The prefix for the customer's name (e.g., Mr., Ms.) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer prefix \| \| Description \| The prefix for the customer's name (e.g., Mr., Ms.) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_prefix** |
| \| Field label \| Customer prefix \| \| --- \| --- \| \| Description \| The prefix for the customer's name (e.g., Mr., Ms.) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer prefix |
| Description | The prefix for the customer's name (e.g., Mr., Ms.) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_first_name** \| \| --- \| \| \\| Field label \\| Customer first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer first name \| \| Description \| The first name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_first_name** |
| \| Field label \| Customer first name \| \| --- \| --- \| \| Description \| The first name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer first name |
| Description | The first name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_middle_name** \| \| --- \| \| \\| Field label \\| Customer middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer middle name \| \| Description \| The middle name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_middle_name** |
| \| Field label \| Customer middle name \| \| --- \| --- \| \| Description \| The middle name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer middle name |
| Description | The middle name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_last_name** \| \| --- \| \| \\| Field label \\| Customer last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer last name \| \| Description \| The last name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_last_name** |
| \| Field label \| Customer last name \| \| --- \| --- \| \| Description \| The last name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer last name |
| Description | The last name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_name_suffix** \| \| --- \| \| \\| Field label \\| Customer name suffix \\| \\| --- \\| --- \\| \\| Description \\| The suffix for the customer's name (e.g., Jr., Sr., III) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer name suffix \| \| Description \| The suffix for the customer's name (e.g., Jr., Sr., III) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_name_suffix** |
| \| Field label \| Customer name suffix \| \| --- \| --- \| \| Description \| The suffix for the customer's name (e.g., Jr., Sr., III) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer name suffix |
| Description | The suffix for the customer's name (e.g., Jr., Sr., III) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_gender** \| \| --- \| \| \\| Field label \\| Customer gender \\| \\| --- \\| --- \\| \\| Description \\| The gender of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.person.gender](/apidocs/field-data-types#person) \\| \| \| Field label \| Customer gender \| \| Description \| The gender of the customer \| \| Field type \| dimension \| \| Data type \| [string.person.gender](/apidocs/field-data-types#person) \| |
| customer_gender** |
| \| Field label \| Customer gender \| \| --- \| --- \| \| Description \| The gender of the customer \| \| Field type \| dimension \| \| Data type \| [string.person.gender](/apidocs/field-data-types#person) \| |
| Field label | Customer gender |
| Description | The gender of the customer |
| Field type | dimension |
| Data type | [string.person.gender](/apidocs/field-data-types#person) |
| \| customer_dob** \| \| --- \| \| \\| Field label \\| Customer date of birth \\| \\| --- \\| --- \\| \\| Description \\| The date of birth of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Customer date of birth \| \| Description \| The date of birth of the customer \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| customer_dob** |
| \| Field label \| Customer date of birth \| \| --- \| --- \| \| Description \| The date of birth of the customer \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Customer date of birth |
| Description | The date of birth of the customer |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| customer_email** \| \| --- \| \| \\| Field label \\| Customer email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer email \| \| Description \| The email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| customer_email** |
| \| Field label \| Customer email \| \| --- \| --- \| \| Description \| The email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Field label | Customer email |
| Description | The email address of the customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| customer_is_guest** \| \| --- \| \| \\| Field label \\| Customer is guest \\| \\| --- \\| --- \\| \\| Description \\| Indicates whether the customer is a guest or a registered customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer is guest \| \| Description \| Indicates whether the customer is a guest or a registered customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_is_guest** |
| \| Field label \| Customer is guest \| \| --- \| --- \| \| Description \| Indicates whether the customer is a guest or a registered customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer is guest |
| Description | Indicates whether the customer is a guest or a registered customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_tax_vat_number** \| \| --- \| \| \\| Field label \\| Customer tax/VAT number \\| \\| --- \\| --- \\| \\| Description \\| The tax or VAT number of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer tax/VAT number \| \| Description \| The tax or VAT number of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_tax_vat_number** |
| \| Field label \| Customer tax/VAT number \| \| --- \| --- \| \| Description \| The tax or VAT number of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer tax/VAT number |
| Description | The tax or VAT number of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_created_in** \| \| --- \| \| \\| Field label \\| Customer created in \\| \\| --- \\| --- \\| \\| Description \\| The store in which the customer was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer created in \| \| Description \| The store in which the customer was created \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_created_in** |
| \| Field label \| Customer created in \| \| --- \| --- \| \| Description \| The store in which the customer was created \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer created in |
| Description | The store in which the customer was created |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_created_date** \| \| --- \| \| \\| Field label \\| Customer created date \\| \\| --- \\| --- \\| \\| Description \\| The date the customer was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Customer created date \| \| Description \| The date the customer was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| customer_created_date** |
| \| Field label \| Customer created date \| \| --- \| --- \| \| Description \| The date the customer was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Customer created date |
| Description | The date the customer was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| customer_created_datetime** \| \| --- \| \| \\| Field label \\| Customer created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the customer was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Customer created datetime \| \| Description \| The date and time the customer was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| customer_created_datetime** |
| \| Field label \| Customer created datetime \| \| --- \| --- \| \| Description \| The date and time the customer was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Customer created datetime |
| Description | The date and time the customer was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| customer_updated_date** \| \| --- \| \| \\| Field label \\| Customer updated date \\| \\| --- \\| --- \\| \\| Description \\| The date the customer was last updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Customer updated date \| \| Description \| The date the customer was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| customer_updated_date** |
| \| Field label \| Customer updated date \| \| --- \| --- \| \| Description \| The date the customer was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Customer updated date |
| Description | The date the customer was last updated |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| customer_updated_datetime** \| \| --- \| \| \\| Field label \\| Customer updated datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the customer was last updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Customer updated datetime \| \| Description \| The date and time the customer was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| customer_updated_datetime** |
| \| Field label \| Customer updated datetime \| \| --- \| --- \| \| Description \| The date and time the customer was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Customer updated datetime |
| Description | The date and time the customer was last updated |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| customers** \| \| --- \| \| \\| Field label \\| Customers \\| \\| --- \\| --- \\| \\| Description \\| The number of customers \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Customers \| \| Description \| The number of customers \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| customers** |
| \| Field label \| Customers \| \| --- \| --- \| \| Description \| The number of customers \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Customers |
| Description | The number of customers |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

### DATASOURCE

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

### ITEM

| \| product_name** \| \| --- \| \| \\| Field label \\| Product name \\| \\| --- \\| --- \\| \\| Description \\| The name of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product name \| \| Description \| The name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| product_name** |
| \| Field label \| Product name \| \| --- \| --- \| \| Description \| The name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product name |
| Description | The name of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_type** \| \| --- \| \| \\| Field label \\| Product type \\| \\| --- \\| --- \\| \\| Description \\| The type or category of the product (e.g., simple, configurable, virtual) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product type \| \| Description \| The type or category of the product (e.g., simple, configurable, virtual) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_type** |
| \| Field label \| Product type \| \| --- \| --- \| \| Description \| The type or category of the product (e.g., simple, configurable, virtual) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product type |
| Description | The type or category of the product (e.g., simple, configurable, virtual) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_id** \| \| --- \| \| \\| Field label \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| A unique identifier for each product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product ID \| \| Description \| A unique identifier for each product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_id** |
| \| Field label \| Product ID \| \| --- \| --- \| \| Description \| A unique identifier for each product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product ID |
| Description | A unique identifier for each product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| item_order_id** \| \| --- \| \| \\| Field label \\| Item order ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the order associated with the ordered item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item order ID \| \| Description \| The unique identifier of the order associated with the ordered item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| item_order_id** |
| \| Field label \| Item order ID \| \| --- \| --- \| \| Description \| The unique identifier of the order associated with the ordered item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Item order ID |
| Description | The unique identifier of the order associated with the ordered item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| item_id** \| \| --- \| \| \\| Field label \\| Item ID \\| \\| --- \\| --- \\| \\| Description \\| A unique identifier for each item in the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item ID \| \| Description \| A unique identifier for each item in the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| item_id** |
| \| Field label \| Item ID \| \| --- \| --- \| \| Description \| A unique identifier for each item in the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Item ID |
| Description | A unique identifier for each item in the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| item_sku** \| \| --- \| \| \\| Field label \\| Item SKU \\| \\| --- \\| --- \\| \\| Description \\| The Stock Keeping Unit (SKU) associated with the product in the item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item SKU \| \| Description \| The Stock Keeping Unit (SKU) associated with the product in the item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| item_sku** |
| \| Field label \| Item SKU \| \| --- \| --- \| \| Description \| The Stock Keeping Unit (SKU) associated with the product in the item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Item SKU |
| Description | The Stock Keeping Unit (SKU) associated with the product in the item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| item_created_date** \| \| --- \| \| \\| Field label \\| Item created date \\| \\| --- \\| --- \\| \\| Description \\| The date when the item was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Item created date \| \| Description \| The date when the item was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| item_created_date** |
| \| Field label \| Item created date \| \| --- \| --- \| \| Description \| The date when the item was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Item created date |
| Description | The date when the item was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| item_created_datetime** \| \| --- \| \| \\| Field label \\| Item created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time when the item was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Item created datetime \| \| Description \| The date and time when the item was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| item_created_datetime** |
| \| Field label \| Item created datetime \| \| --- \| --- \| \| Description \| The date and time when the item was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Item created datetime |
| Description | The date and time when the item was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| item_updated_date** \| \| --- \| \| \\| Field label \\| Item updated date \\| \\| --- \\| --- \\| \\| Description \\| The date when the item was last updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Item updated date \| \| Description \| The date when the item was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| item_updated_date** |
| \| Field label \| Item updated date \| \| --- \| --- \| \| Description \| The date when the item was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Item updated date |
| Description | The date when the item was last updated |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| item_updated_datetime** \| \| --- \| \| \\| Field label \\| Item updated datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time when the item was last updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Item updated datetime \| \| Description \| The date and time when the item was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| item_updated_datetime** |
| \| Field label \| Item updated datetime \| \| --- \| --- \| \| Description \| The date and time when the item was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Item updated datetime |
| Description | The date and time when the item was last updated |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| item_original_price** \| \| --- \| \| \\| Field label \\| Item original price \\| \\| --- \\| --- \\| \\| Description \\| The original price of the item before any discounts or adjustments \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item original price \| \| Description \| The original price of the item before any discounts or adjustments \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_original_price** |
| \| Field label \| Item original price \| \| --- \| --- \| \| Description \| The original price of the item before any discounts or adjustments \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item original price |
| Description | The original price of the item before any discounts or adjustments |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_price** \| \| --- \| \| \\| Field label \\| Item price \\| \\| --- \\| --- \\| \\| Description \\| The final price of the item after any discounts or adjustments \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item price \| \| Description \| The final price of the item after any discounts or adjustments \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_price** |
| \| Field label \| Item price \| \| --- \| --- \| \| Description \| The final price of the item after any discounts or adjustments \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item price |
| Description | The final price of the item after any discounts or adjustments |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_quantity_ordered** \| \| --- \| \| \\| Field label \\| Item quantity ordered \\| \\| --- \\| --- \\| \\| Description \\| The total quantity of the item ordered \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Item quantity ordered \| \| Description \| The total quantity of the item ordered \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| item_quantity_ordered** |
| \| Field label \| Item quantity ordered \| \| --- \| --- \| \| Description \| The total quantity of the item ordered \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Item quantity ordered |
| Description | The total quantity of the item ordered |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| item_quantity_invoiced** \| \| --- \| \| \\| Field label \\| Item quantity invoiced \\| \\| --- \\| --- \\| \\| Description \\| The quantity of the item that has been invoiced \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Item quantity invoiced \| \| Description \| The quantity of the item that has been invoiced \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| item_quantity_invoiced** |
| \| Field label \| Item quantity invoiced \| \| --- \| --- \| \| Description \| The quantity of the item that has been invoiced \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Item quantity invoiced |
| Description | The quantity of the item that has been invoiced |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| item_quantity_shipped** \| \| --- \| \| \\| Field label \\| Item quantity shipped \\| \\| --- \\| --- \\| \\| Description \\| The quantity of the item that has been shipped \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Item quantity shipped \| \| Description \| The quantity of the item that has been shipped \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| item_quantity_shipped** |
| \| Field label \| Item quantity shipped \| \| --- \| --- \| \| Description \| The quantity of the item that has been shipped \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Item quantity shipped |
| Description | The quantity of the item that has been shipped |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| item_quantity_refunded** \| \| --- \| \| \\| Field label \\| Item quantity refunded \\| \\| --- \\| --- \\| \\| Description \\| The quantity of the item that has been refunded \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Item quantity refunded \| \| Description \| The quantity of the item that has been refunded \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| item_quantity_refunded** |
| \| Field label \| Item quantity refunded \| \| --- \| --- \| \| Description \| The quantity of the item that has been refunded \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Item quantity refunded |
| Description | The quantity of the item that has been refunded |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| item_quantity_returned** \| \| --- \| \| \\| Field label \\| Item quantity returned \\| \\| --- \\| --- \\| \\| Description \\| The quantity of the item that has been returned \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Item quantity returned \| \| Description \| The quantity of the item that has been returned \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| item_quantity_returned** |
| \| Field label \| Item quantity returned \| \| --- \| --- \| \| Description \| The quantity of the item that has been returned \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Item quantity returned |
| Description | The quantity of the item that has been returned |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| item_quantity_canceled** \| \| --- \| \| \\| Field label \\| Item quantity canceled \\| \\| --- \\| --- \\| \\| Description \\| The quantity of the item that has been canceled \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Item quantity canceled \| \| Description \| The quantity of the item that has been canceled \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| item_quantity_canceled** |
| \| Field label \| Item quantity canceled \| \| --- \| --- \| \| Description \| The quantity of the item that has been canceled \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Item quantity canceled |
| Description | The quantity of the item that has been canceled |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| item_subtotal** \| \| --- \| \| \\| Field label \\| Item subtotal \\| \\| --- \\| --- \\| \\| Description \\| The subtotal amount for the item before tax and discounts \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item subtotal \| \| Description \| The subtotal amount for the item before tax and discounts \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_subtotal** |
| \| Field label \| Item subtotal \| \| --- \| --- \| \| Description \| The subtotal amount for the item before tax and discounts \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item subtotal |
| Description | The subtotal amount for the item before tax and discounts |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_tax_amount** \| \| --- \| \| \\| Field label \\| Item tax amount \\| \\| --- \\| --- \\| \\| Description \\| The tax amount applied to the item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item tax amount \| \| Description \| The tax amount applied to the item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_tax_amount** |
| \| Field label \| Item tax amount \| \| --- \| --- \| \| Description \| The tax amount applied to the item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item tax amount |
| Description | The tax amount applied to the item |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_tax_percent** \| \| --- \| \| \\| Field label \\| Item tax percent \\| \\| --- \\| --- \\| \\| Description \\| The tax percentage rate applied to the item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.percentage](/apidocs/field-data-types#number) \\| \| \| Field label \| Item tax percent \| \| Description \| The tax percentage rate applied to the item \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| |
| item_tax_percent** |
| \| Field label \| Item tax percent \| \| --- \| --- \| \| Description \| The tax percentage rate applied to the item \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| |
| Field label | Item tax percent |
| Description | The tax percentage rate applied to the item |
| Field type | metric |
| Data type | [float.number.percentage](/apidocs/field-data-types#number) |
| \| item_discount_amount** \| \| --- \| \| \\| Field label \\| Item discount amount \\| \\| --- \\| --- \\| \\| Description \\| The discount amount applied to the item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item discount amount \| \| Description \| The discount amount applied to the item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_discount_amount** |
| \| Field label \| Item discount amount \| \| --- \| --- \| \| Description \| The discount amount applied to the item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item discount amount |
| Description | The discount amount applied to the item |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_total** \| \| --- \| \| \\| Field label \\| Item total \\| \\| --- \\| --- \\| \\| Description \\| The total amount for the item after all adjustments \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item total \| \| Description \| The total amount for the item after all adjustments \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_total** |
| \| Field label \| Item total \| \| --- \| --- \| \| Description \| The total amount for the item after all adjustments \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item total |
| Description | The total amount for the item after all adjustments |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_refund_amount** \| \| --- \| \| \\| Field label \\| Item refund amount \\| \\| --- \\| --- \\| \\| Description \\| The amount refunded for the item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item refund amount \| \| Description \| The amount refunded for the item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_refund_amount** |
| \| Field label \| Item refund amount \| \| --- \| --- \| \| Description \| The amount refunded for the item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item refund amount |
| Description | The amount refunded for the item |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### ORDER

| \| order_increment_id** \| \| --- \| \| \\| Field label \\| Order increment ID \\| \\| --- \\| --- \\| \\| Description \\| The incrementing identifier for each order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order increment ID \| \| Description \| The incrementing identifier for each order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| order_increment_id** |
| \| Field label \| Order increment ID \| \| --- \| --- \| \| Description \| The incrementing identifier for each order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order increment ID |
| Description | The incrementing identifier for each order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_status** \| \| --- \| \| \\| Field label \\| Order status \\| \\| --- \\| --- \\| \\| Description \\| The current status of the order (e.g., pending, processing, completed) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order status \| \| Description \| The current status of the order (e.g., pending, processing, completed) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_status** |
| \| Field label \| Order status \| \| --- \| --- \| \| Description \| The current status of the order (e.g., pending, processing, completed) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order status |
| Description | The current status of the order (e.g., pending, processing, completed) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_currency** \| \| --- \| \| \\| Field label \\| Order currency \\| \\| --- \\| --- \\| \\| Description \\| The currency used for the order transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order currency \| \| Description \| The currency used for the order transaction \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| order_currency** |
| \| Field label \| Order currency \| \| --- \| --- \| \| Description \| The currency used for the order transaction \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Order currency |
| Description | The currency used for the order transaction |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| order_created_date** \| \| --- \| \| \\| Field label \\| Order created date \\| \\| --- \\| --- \\| \\| Description \\| The date when the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order created date \| \| Description \| The date when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_created_date** |
| \| Field label \| Order created date \| \| --- \| --- \| \| Description \| The date when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Order created date |
| Description | The date when the order was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_created_datetime** \| \| --- \| \| \\| Field label \\| Order created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time when the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order created datetime \| \| Description \| The date and time when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_created_datetime** |
| \| Field label \| Order created datetime \| \| --- \| --- \| \| Description \| The date and time when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Order created datetime |
| Description | The date and time when the order was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_updated_date** \| \| --- \| \| \\| Field label \\| Order updated date \\| \\| --- \\| --- \\| \\| Description \\| The date when the order was last updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order updated date \| \| Description \| The date when the order was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_updated_date** |
| \| Field label \| Order updated date \| \| --- \| --- \| \| Description \| The date when the order was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Order updated date |
| Description | The date when the order was last updated |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_updated_datetime** \| \| --- \| \| \\| Field label \\| Order updated datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time when the order was last updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order updated datetime \| \| Description \| The date and time when the order was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_updated_datetime** |
| \| Field label \| Order updated datetime \| \| --- \| --- \| \| Description \| The date and time when the order was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Order updated datetime |
| Description | The date and time when the order was last updated |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| orders** \| \| --- \| \| \\| Field label \\| Orders \\| \\| --- \\| --- \\| \\| Description \\| The total number of orders placed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Orders \| \| Description \| The total number of orders placed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| orders** |
| \| Field label \| Orders \| \| --- \| --- \| \| Description \| The total number of orders placed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Orders |
| Description | The total number of orders placed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| order_quantity** \| \| --- \| \| \\| Field label \\| Order quantity \\| \\| --- \\| --- \\| \\| Description \\| The total quantity of items in the order \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Order quantity \| \| Description \| The total quantity of items in the order \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| order_quantity** |
| \| Field label \| Order quantity \| \| --- \| --- \| \| Description \| The total quantity of items in the order \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Order quantity |
| Description | The total quantity of items in the order |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| order_subtotal** \| \| --- \| \| \\| Field label \\| Order subtotal \\| \\| --- \\| --- \\| \\| Description \\| The subtotal amount for the order before tax and discounts \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order subtotal \| \| Description \| The subtotal amount for the order before tax and discounts \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_subtotal** |
| \| Field label \| Order subtotal \| \| --- \| --- \| \| Description \| The subtotal amount for the order before tax and discounts \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order subtotal |
| Description | The subtotal amount for the order before tax and discounts |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_discount** \| \| --- \| \| \\| Field label \\| Order discount \\| \\| --- \\| --- \\| \\| Description \\| The total discount amount applied to the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order discount \| \| Description \| The total discount amount applied to the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_discount** |
| \| Field label \| Order discount \| \| --- \| --- \| \| Description \| The total discount amount applied to the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order discount |
| Description | The total discount amount applied to the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_tax** \| \| --- \| \| \\| Field label \\| Order tax \\| \\| --- \\| --- \\| \\| Description \\| The total tax amount applied to the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order tax \| \| Description \| The total tax amount applied to the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_tax** |
| \| Field label \| Order tax \| \| --- \| --- \| \| Description \| The total tax amount applied to the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order tax |
| Description | The total tax amount applied to the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_shipping_and_handling** \| \| --- \| \| \\| Field label \\| Order shipping & handling \\| \\| --- \\| --- \\| \\| Description \\| The total shipping and handling charges for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order shipping & handling \| \| Description \| The total shipping and handling charges for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_shipping_and_handling** |
| \| Field label \| Order shipping & handling \| \| --- \| --- \| \| Description \| The total shipping and handling charges for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order shipping & handling |
| Description | The total shipping and handling charges for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_grand_total** \| \| --- \| \| \\| Field label \\| Order grand total \\| \\| --- \\| --- \\| \\| Description \\| The grand total amount for the order after all adjustments \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order grand total \| \| Description \| The grand total amount for the order after all adjustments \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_grand_total** |
| \| Field label \| Order grand total \| \| --- \| --- \| \| Description \| The grand total amount for the order after all adjustments \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order grand total |
| Description | The grand total amount for the order after all adjustments |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_total_paid** \| \| --- \| \| \\| Field label \\| Order total paid \\| \\| --- \\| --- \\| \\| Description \\| The total amount paid for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order total paid \| \| Description \| The total amount paid for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_total_paid** |
| \| Field label \| Order total paid \| \| --- \| --- \| \| Description \| The total amount paid for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order total paid |
| Description | The total amount paid for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_total_refunded** \| \| --- \| \| \\| Field label \\| Order total refunded \\| \\| --- \\| --- \\| \\| Description \\| The total amount refunded for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order total refunded \| \| Description \| The total amount refunded for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_total_refunded** |
| \| Field label \| Order total refunded \| \| --- \| --- \| \| Description \| The total amount refunded for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order total refunded |
| Description | The total amount refunded for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_total_due** \| \| --- \| \| \\| Field label \\| Order total due \\| \\| --- \\| --- \\| \\| Description \\| The total amount due for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order total due \| \| Description \| The total amount due for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_total_due** |
| \| Field label \| Order total due \| \| --- \| --- \| \| Description \| The total amount due for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order total due |
| Description | The total amount due for the order |
| 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) |

### SHIPPING

| \| shipping_first_name** \| \| --- \| \| \\| Field label \\| Shipping first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping first name \| \| Description \| The first name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| shipping_first_name** |
| \| Field label \| Shipping first name \| \| --- \| --- \| \| Description \| The first name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping first name |
| Description | The first name of the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_middle_name** \| \| --- \| \| \\| Field label \\| Shipping middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping middle name \| \| Description \| The middle name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_middle_name** |
| \| Field label \| Shipping middle name \| \| --- \| --- \| \| Description \| The middle name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping middle name |
| Description | The middle name of the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_last_name** \| \| --- \| \| \\| Field label \\| Shipping last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping last name \| \| Description \| The last name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_last_name** |
| \| Field label \| Shipping last name \| \| --- \| --- \| \| Description \| The last name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping last name |
| Description | The last name of the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_company** \| \| --- \| \| \\| Field label \\| Shipping company \\| \\| --- \\| --- \\| \\| Description \\| The company name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping company \| \| Description \| The company name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_company** |
| \| Field label \| Shipping company \| \| --- \| --- \| \| Description \| The company name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping company |
| Description | The company name of the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_address_type** \| \| --- \| \| \\| Field label \\| Shipping address type \\| \\| --- \\| --- \\| \\| Description \\| The type of address associated with the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping address type \| \| Description \| The type of address associated with the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_address_type** |
| \| Field label \| Shipping address type \| \| --- \| --- \| \| Description \| The type of address associated with the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping address type |
| Description | The type of address associated with the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_street** \| \| --- \| \| \\| Field label \\| Shipping street \\| \\| --- \\| --- \\| \\| Description \\| The street address of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping street \| \| Description \| The street address of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| shipping_street** |
| \| Field label \| Shipping street \| \| --- \| --- \| \| Description \| The street address of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping street |
| Description | The street address of the shipping customer |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| shipping_city** \| \| --- \| \| \\| Field label \\| Shipping city \\| \\| --- \\| --- \\| \\| Description \\| The city of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping city \| \| Description \| The city of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| shipping_city** |
| \| Field label \| Shipping city \| \| --- \| --- \| \| Description \| The city of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping city |
| Description | The city of the shipping address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| shipping_region** \| \| --- \| \| \\| Field label \\| Shipping region \\| \\| --- \\| --- \\| \\| Description \\| The region or state of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping region \| \| Description \| The region or state of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| shipping_region** |
| \| Field label \| Shipping region \| \| --- \| --- \| \| Description \| The region or state of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping region |
| Description | The region or state of the shipping address |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| shipping_region_id** \| \| --- \| \| \\| Field label \\| Shipping region ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier for the region of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping region ID \| \| Description \| The unique identifier for the region of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| shipping_region_id** |
| \| Field label \| Shipping region ID \| \| --- \| --- \| \| Description \| The unique identifier for the region of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping region ID |
| Description | The unique identifier for the region of the shipping address |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| shipping_region_code** \| \| --- \| \| \\| Field label \\| Shipping region code \\| \\| --- \\| --- \\| \\| Description \\| The code representing the region of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping region code \| \| Description \| The code representing the region of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| shipping_region_code** |
| \| Field label \| Shipping region code \| \| --- \| --- \| \| Description \| The code representing the region of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping region code |
| Description | The code representing the region of the shipping address |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| shipping_postal_code** \| \| --- \| \| \\| Field label \\| Shipping postal code \\| \\| --- \\| --- \\| \\| Description \\| The postal code of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping postal code \| \| Description \| The postal code of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_postal_code** |
| \| Field label \| Shipping postal code \| \| --- \| --- \| \| Description \| The postal code of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping postal code |
| Description | The postal code of the shipping address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_country_id** \| \| --- \| \| \\| Field label \\| Shipping country ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier for the country of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping country ID \| \| Description \| The unique identifier for the country of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| shipping_country_id** |
| \| Field label \| Shipping country ID \| \| --- \| --- \| \| Description \| The unique identifier for the country of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping country ID |
| Description | The unique identifier for the country of the shipping address |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| shipping_email** \| \| --- \| \| \\| Field label \\| Shipping email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping email \| \| Description \| The email address of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| shipping_email** |
| \| Field label \| Shipping email \| \| --- \| --- \| \| Description \| The email address of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Field label | Shipping email |
| Description | The email address of the shipping customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| shipping_telephone** \| \| --- \| \| \\| Field label \\| Shipping telephone \\| \\| --- \\| --- \\| \\| Description \\| The telephone number of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping telephone \| \| Description \| The telephone number of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| shipping_telephone** |
| \| Field label \| Shipping telephone \| \| --- \| --- \| \| Description \| The telephone number of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Field label | Shipping telephone |
| Description | The telephone number of the shipping customer |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| shipping_fax** \| \| --- \| \| \\| Field label \\| Shipping fax \\| \\| --- \\| --- \\| \\| Description \\| The fax number of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping fax \| \| Description \| The fax number of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_fax** |
| \| Field label \| Shipping fax \| \| --- \| --- \| \| Description \| The fax number of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping fax |
| Description | The fax number of the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### STORE

| \| store_domain** \| \| --- \| \| \\| Field label \\| Store domain \\| \\| --- \\| --- \\| \\| Description \\| The domain associated with the store from which the order was placed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Store domain \| \| Description \| The domain associated with the store from which the order was placed \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| --- |
| store_domain** |
| \| Field label \| Store domain \| \| --- \| --- \| \| Description \| The domain associated with the store from which the order was placed \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Field label | Store domain |
| Description | The domain associated with the store from which the order was placed |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| store_id** \| \| --- \| \| \\| Field label \\| Store ID \\| \\| --- \\| --- \\| \\| Description \\| A unique identifier for the store within the Magento system \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store ID \| \| Description \| A unique identifier for the store within the Magento system \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| store_id** |
| \| Field label \| Store ID \| \| --- \| --- \| \| Description \| A unique identifier for the store within the Magento system \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store ID |
| Description | A unique identifier for the store within the Magento system |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| store_name** \| \| --- \| \| \\| Field label \\| Store name \\| \\| --- \\| --- \\| \\| Description \\| The name of the store from which the order was placed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store name \| \| Description \| The name of the store from which the order was placed \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| store_name** |
| \| Field label \| Store name \| \| --- \| --- \| \| Description \| The name of the store from which the order was placed \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store name |
| Description | The name of the store from which the order was placed |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### TIME

| \| today** \| \| --- \| \| \\| Field label \\| Today \\| \\| --- \\| --- \\| \\| Description \\| Today's date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Today \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| |
| --- |
| today** |
| \| Field label \| Today \| \| --- \| --- \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| |
| Field label | Today |
| Description | Today's date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| Destinations | API, Data warehouse |
| \| year** \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year** |
| \| Field label \| Year \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| 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) |