---
title: "Adobe Commerce (Magento 2) data warehouse table groups"
slug: "adobe-commerce-magento-2-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for Adobe Commerce (Magento 2). See all the tables and the fields included in them."
updated: 2026-03-05T14:19:57Z
published: 2026-03-05T14:19:57Z
canonical: "docs.supermetrics.com/adobe-commerce-magento-2-data-warehouse-table-groups"
---

> ## 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) data warehouse table groups

Search fields

### Table: ORDER

| \| billing_address_type \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_city \| \| --- \| \| \\| Display name \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| The city of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing city \| \| Description \| The city of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| billing_city |
| \| Display name \| Billing city \| \| --- \| --- \| \| Description \| The city of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Billing city |
| Description | The city of the billing address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| billing_company \| \| --- \| \| \\| Display name \\| Billing company \\| \\| --- \\| --- \\| \\| Description \\| The company name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing company \| \| --- \| --- \| \| Description \| The company name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing company |
| Description | The company name of the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_country_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| Billing email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing email \| \| --- \| --- \| \| Description \| The email address of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Billing email |
| Description | The email address of the billing customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| billing_fax \| \| --- \| \| \\| Display name \\| Billing fax \\| \\| --- \\| --- \\| \\| Description \\| The fax number of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing fax \| \| --- \| --- \| \| Description \| The fax number of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing fax |
| Description | The fax number of the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_first_name \| \| --- \| \| \\| Display name \\| Billing first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing first name \| \| --- \| --- \| \| Description \| The first name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_last_name \| \| --- \| \| \\| Display name \\| Billing last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing last name \| \| --- \| --- \| \| Description \| The last name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_middle_name \| \| --- \| \| \\| Display name \\| Billing middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing middle name \| \| --- \| --- \| \| Description \| The middle name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_postal_code \| \| --- \| \| \\| Display name \\| Billing postal code \\| \\| --- \\| --- \\| \\| Description \\| The postal code of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing postal code \| \| --- \| --- \| \| Description \| The postal code of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_region \| \| --- \| \| \\| Display name \\| Billing region \\| \\| --- \\| --- \\| \\| Description \\| The region or state of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Billing region \| \| --- \| --- \| \| Description \| The region or state of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Display name | 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_code \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_street \| \| --- \| \| \\| Display name \\| Billing street \\| \\| --- \\| --- \\| \\| Description \\| The street address of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Billing street \| \| --- \| --- \| \| Description \| The street address of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Display name | Billing street |
| Description | The street address of the billing customer |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_telephone \| \| --- \| \| \\| Display name \\| Billing telephone \\| \\| --- \\| --- \\| \\| Description \\| The telephone number of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing telephone \| \| --- \| --- \| \| Description \| The telephone number of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Billing telephone |
| Description | The telephone number of the billing customer |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| customer_dob \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| Customer email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer email \| \| Description \| The email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| customer_email |
| \| Display name \| Customer email \| \| --- \| --- \| \| Description \| The email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Customer email |
| Description | The email address of the customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| customer_first_name \| \| --- \| \| \\| Display name \\| Customer first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer first name \| \| --- \| --- \| \| Description \| The first name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer first name |
| Description | The first name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_gender \| \| --- \| \| \\| Display name \\| Customer gender \\| \\| --- \\| --- \\| \\| Description \\| The gender of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.person.gender](/apidocs/field-data-types#person) \\| \| \| Display name \| Customer gender \| \| Description \| The gender of the customer \| \| Field type \| dimension \| \| Data type \| [string.person.gender](/apidocs/field-data-types#person) \| |
| customer_gender |
| \| Display name \| Customer gender \| \| --- \| --- \| \| Description \| The gender of the customer \| \| Field type \| dimension \| \| Data type \| [string.person.gender](/apidocs/field-data-types#person) \| |
| Display name | Customer gender |
| Description | The gender of the customer |
| Field type | dimension |
| Data type | [string.person.gender](/apidocs/field-data-types#person) |
| \| customer_group_id \| \| --- \| \| \\| Display name \\| Customer group ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the customer group \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer group ID \| \| --- \| --- \| \| Description \| The unique identifier of the customer group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_id \| \| --- \| \| \\| Display name \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer ID \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_id |
| \| Display name \| Customer ID \| \| --- \| --- \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer ID |
| Description | The unique identifier of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_is_guest \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_last_name \| \| --- \| \| \\| Display name \\| Customer last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer last name \| \| --- \| --- \| \| Description \| The last name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer last name |
| Description | The last name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_middle_name \| \| --- \| \| \\| Display name \\| Customer middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer middle name \| \| --- \| --- \| \| Description \| The middle name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer middle name |
| Description | The middle name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_prefix \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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) |
| \| dataSourceName \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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) \| |
| dataSourceName |
| \| Display name \| 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) \| |
| Display name | 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) |
| \| date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date |
| \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_created_date \| \| --- \| \| \\| Display name \\| Order created date \\| \\| --- \\| --- \\| \\| Description \\| The date when the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| 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 |
| \| Display name \| Order created date \| \| --- \| --- \| \| Description \| The date when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_currency \| \| --- \| \| \\| Display name \\| Order currency \\| \\| --- \\| --- \\| \\| Description \\| The currency used for the order transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| 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 |
| \| Display name \| Order currency \| \| --- \| --- \| \| Description \| The currency used for the order transaction \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Display name | Order currency |
| Description | The currency used for the order transaction |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| order_discount \| \| --- \| \| \\| Display name \\| Order discount \\| \\| --- \\| --- \\| \\| Description \\| The total discount amount applied to the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| 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 |
| \| Display name \| Order discount \| \| --- \| --- \| \| Description \| The total discount amount applied to the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | 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_grand_total \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_increment_id \| \| --- \| \| \\| Display name \\| Order increment ID \\| \\| --- \\| --- \\| \\| Description \\| The incrementing identifier for each order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Order increment ID \| \| --- \| --- \| \| Description \| The incrementing identifier for each order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order increment ID |
| Description | The incrementing identifier for each order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_quantity \| \| --- \| \| \\| Display name \\| Order quantity \\| \\| --- \\| --- \\| \\| Description \\| The total quantity of items in the order \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| 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 |
| \| Display name \| Order quantity \| \| --- \| --- \| \| Description \| The total quantity of items in the order \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | 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_shipping_and_handling \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_status \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_subtotal \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_tax \| \| --- \| \| \\| Display name \\| Order tax \\| \\| --- \\| --- \\| \\| Description \\| The total tax amount applied to the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| 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 |
| \| Display name \| Order tax \| \| --- \| --- \| \| Description \| The total tax amount applied to the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | 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_total_due \| \| --- \| \| \\| Display name \\| Order total due \\| \\| --- \\| --- \\| \\| Description \\| The total amount due for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| 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 |
| \| Display name \| Order total due \| \| --- \| --- \| \| Description \| The total amount due for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | 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_paid \| \| --- \| \| \\| Display name \\| Order total paid \\| \\| --- \\| --- \\| \\| Description \\| The total amount paid for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| 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 |
| \| Display name \| Order total paid \| \| --- \| --- \| \| Description \| The total amount paid for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| Order total refunded \\| \\| --- \\| --- \\| \\| Description \\| The total amount refunded for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| 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 |
| \| Display name \| Order total refunded \| \| --- \| --- \| \| Description \| The total amount refunded for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | 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_updated_date \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| Orders \\| \\| --- \\| --- \\| \\| Description \\| The total number of orders placed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Orders \| \| Description \| The total number of orders placed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| orders |
| \| Display name \| Orders \| \| --- \| --- \| \| Description \| The total number of orders placed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Orders |
| Description | The total number of orders placed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| shipping_address_type \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_city \| \| --- \| \| \\| Display name \\| Shipping city \\| \\| --- \\| --- \\| \\| Description \\| The city of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Shipping city \| \| Description \| The city of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| shipping_city |
| \| Display name \| Shipping city \| \| --- \| --- \| \| Description \| The city of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Shipping city |
| Description | The city of the shipping address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| shipping_company \| \| --- \| \| \\| Display name \\| Shipping company \\| \\| --- \\| --- \\| \\| Description \\| The company name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping company \| \| --- \| --- \| \| Description \| The company name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping company |
| Description | The company name of the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_country_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| Shipping email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping email \| \| --- \| --- \| \| Description \| The email address of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Shipping email |
| Description | The email address of the shipping customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| shipping_fax \| \| --- \| \| \\| Display name \\| Shipping fax \\| \\| --- \\| --- \\| \\| Description \\| The fax number of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping fax \| \| --- \| --- \| \| Description \| The fax number of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping fax |
| Description | The fax number of the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_first_name \| \| --- \| \| \\| Display name \\| Shipping first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping first name \| \| --- \| --- \| \| Description \| The first name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_last_name \| \| --- \| \| \\| Display name \\| Shipping last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping last name \| \| --- \| --- \| \| Description \| The last name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_middle_name \| \| --- \| \| \\| Display name \\| Shipping middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping middle name \| \| --- \| --- \| \| Description \| The middle name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_postal_code \| \| --- \| \| \\| Display name \\| Shipping postal code \\| \\| --- \\| --- \\| \\| Description \\| The postal code of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping postal code \| \| --- \| --- \| \| Description \| The postal code of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_region \| \| --- \| \| \\| Display name \\| Shipping region \\| \\| --- \\| --- \\| \\| Description \\| The region or state of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping region \| \| --- \| --- \| \| Description \| The region or state of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Display name | 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_code \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_street \| \| --- \| \| \\| Display name \\| Shipping street \\| \\| --- \\| --- \\| \\| Description \\| The street address of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping street \| \| --- \| --- \| \| Description \| The street address of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Display name | Shipping street |
| Description | The street address of the shipping customer |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| shipping_telephone \| \| --- \| \| \\| Display name \\| Shipping telephone \\| \\| --- \\| --- \\| \\| Description \\| The telephone number of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping telephone \| \| --- \| --- \| \| Description \| The telephone number of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Shipping telephone |
| Description | The telephone number of the shipping customer |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| store_domain \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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) |

### Table: ORDER_ITEM

| \| billing_address_type \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_city \| \| --- \| \| \\| Display name \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| The city of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing city \| \| Description \| The city of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| billing_city |
| \| Display name \| Billing city \| \| --- \| --- \| \| Description \| The city of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Billing city |
| Description | The city of the billing address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| billing_company \| \| --- \| \| \\| Display name \\| Billing company \\| \\| --- \\| --- \\| \\| Description \\| The company name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing company \| \| --- \| --- \| \| Description \| The company name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing company |
| Description | The company name of the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_country_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| Billing email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing email \| \| --- \| --- \| \| Description \| The email address of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Billing email |
| Description | The email address of the billing customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| billing_fax \| \| --- \| \| \\| Display name \\| Billing fax \\| \\| --- \\| --- \\| \\| Description \\| The fax number of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing fax \| \| --- \| --- \| \| Description \| The fax number of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing fax |
| Description | The fax number of the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_first_name \| \| --- \| \| \\| Display name \\| Billing first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing first name \| \| --- \| --- \| \| Description \| The first name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_last_name \| \| --- \| \| \\| Display name \\| Billing last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing last name \| \| --- \| --- \| \| Description \| The last name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_middle_name \| \| --- \| \| \\| Display name \\| Billing middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing middle name \| \| --- \| --- \| \| Description \| The middle name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_postal_code \| \| --- \| \| \\| Display name \\| Billing postal code \\| \\| --- \\| --- \\| \\| Description \\| The postal code of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing postal code \| \| --- \| --- \| \| Description \| The postal code of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_region \| \| --- \| \| \\| Display name \\| Billing region \\| \\| --- \\| --- \\| \\| Description \\| The region or state of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Billing region \| \| --- \| --- \| \| Description \| The region or state of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Display name | 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_code \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_street \| \| --- \| \| \\| Display name \\| Billing street \\| \\| --- \\| --- \\| \\| Description \\| The street address of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Billing street \| \| --- \| --- \| \| Description \| The street address of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Display name | Billing street |
| Description | The street address of the billing customer |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_telephone \| \| --- \| \| \\| Display name \\| Billing telephone \\| \\| --- \\| --- \\| \\| Description \\| The telephone number of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing telephone \| \| --- \| --- \| \| Description \| The telephone number of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Billing telephone |
| Description | The telephone number of the billing customer |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| customer_dob \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| Customer email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer email \| \| Description \| The email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| customer_email |
| \| Display name \| Customer email \| \| --- \| --- \| \| Description \| The email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Customer email |
| Description | The email address of the customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| customer_first_name \| \| --- \| \| \\| Display name \\| Customer first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer first name \| \| --- \| --- \| \| Description \| The first name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer first name |
| Description | The first name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_gender \| \| --- \| \| \\| Display name \\| Customer gender \\| \\| --- \\| --- \\| \\| Description \\| The gender of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.person.gender](/apidocs/field-data-types#person) \\| \| \| Display name \| Customer gender \| \| Description \| The gender of the customer \| \| Field type \| dimension \| \| Data type \| [string.person.gender](/apidocs/field-data-types#person) \| |
| customer_gender |
| \| Display name \| Customer gender \| \| --- \| --- \| \| Description \| The gender of the customer \| \| Field type \| dimension \| \| Data type \| [string.person.gender](/apidocs/field-data-types#person) \| |
| Display name | Customer gender |
| Description | The gender of the customer |
| Field type | dimension |
| Data type | [string.person.gender](/apidocs/field-data-types#person) |
| \| customer_group_id \| \| --- \| \| \\| Display name \\| Customer group ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the customer group \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer group ID \| \| --- \| --- \| \| Description \| The unique identifier of the customer group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_id \| \| --- \| \| \\| Display name \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer ID \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_id |
| \| Display name \| Customer ID \| \| --- \| --- \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer ID |
| Description | The unique identifier of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_is_guest \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_last_name \| \| --- \| \| \\| Display name \\| Customer last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer last name \| \| --- \| --- \| \| Description \| The last name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer last name |
| Description | The last name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_middle_name \| \| --- \| \| \\| Display name \\| Customer middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer middle name \| \| --- \| --- \| \| Description \| The middle name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer middle name |
| Description | The middle name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_prefix \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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) |
| \| dataSourceName \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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) \| |
| dataSourceName |
| \| Display name \| 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) \| |
| Display name | 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) |
| \| date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date |
| \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| item_created_date \| \| --- \| \| \\| Display name \\| Item created date \\| \\| --- \\| --- \\| \\| Description \\| The date when the item was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| 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 |
| \| Display name \| Item created date \| \| --- \| --- \| \| Description \| The date when the item was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_discount_amount \| \| --- \| \| \\| Display name \\| Item discount amount \\| \\| --- \\| --- \\| \\| Description \\| The discount amount applied to the item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| 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 |
| \| Display name \| Item discount amount \| \| --- \| --- \| \| Description \| The discount amount applied to the item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | 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_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_order_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_original_price \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_canceled \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_invoiced \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_ordered \| \| --- \| \| \\| Display name \\| Item quantity ordered \\| \\| --- \\| --- \\| \\| Description \\| The total quantity of the item ordered \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| 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 |
| \| Display name \| Item quantity ordered \| \| --- \| --- \| \| Description \| The total quantity of the item ordered \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | 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_refunded \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_shipped \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_refund_amount \| \| --- \| \| \\| Display name \\| Item refund amount \\| \\| --- \\| --- \\| \\| Description \\| The amount refunded for the item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| 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 |
| \| Display name \| Item refund amount \| \| --- \| --- \| \| Description \| The amount refunded for the item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Item refund amount |
| Description | The amount refunded for the item |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_sku \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_subtotal \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| Item tax amount \\| \\| --- \\| --- \\| \\| Description \\| The tax amount applied to the item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| 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 |
| \| Display name \| Item tax amount \| \| --- \| --- \| \| Description \| The tax amount applied to the item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_total \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_updated_date \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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) |
| \| order_created_date \| \| --- \| \| \\| Display name \\| Order created date \\| \\| --- \\| --- \\| \\| Description \\| The date when the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| 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 |
| \| Display name \| Order created date \| \| --- \| --- \| \| Description \| The date when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_currency \| \| --- \| \| \\| Display name \\| Order currency \\| \\| --- \\| --- \\| \\| Description \\| The currency used for the order transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| 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 |
| \| Display name \| Order currency \| \| --- \| --- \| \| Description \| The currency used for the order transaction \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Display name | Order currency |
| Description | The currency used for the order transaction |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| order_increment_id \| \| --- \| \| \\| Display name \\| Order increment ID \\| \\| --- \\| --- \\| \\| Description \\| The incrementing identifier for each order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Order increment ID \| \| --- \| --- \| \| Description \| The incrementing identifier for each order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_updated_date \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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) |
| \| product_id \| \| --- \| \| \\| Display name \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| A unique identifier for each product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product ID \| \| Description \| A unique identifier for each product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_id |
| \| Display name \| Product ID \| \| --- \| --- \| \| Description \| A unique identifier for each product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product ID |
| Description | A unique identifier for each product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_name \| \| --- \| \| \\| Display name \\| Product name \\| \\| --- \\| --- \\| \\| Description \\| The name of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product name \| \| Description \| The name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_name |
| \| Display name \| Product name \| \| --- \| --- \| \| Description \| The name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product name |
| Description | The name of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_type \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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) |
| \| shipping_address_type \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_city \| \| --- \| \| \\| Display name \\| Shipping city \\| \\| --- \\| --- \\| \\| Description \\| The city of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Shipping city \| \| Description \| The city of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| shipping_city |
| \| Display name \| Shipping city \| \| --- \| --- \| \| Description \| The city of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Shipping city |
| Description | The city of the shipping address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| shipping_company \| \| --- \| \| \\| Display name \\| Shipping company \\| \\| --- \\| --- \\| \\| Description \\| The company name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping company \| \| --- \| --- \| \| Description \| The company name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping company |
| Description | The company name of the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_country_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| Shipping email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping email \| \| --- \| --- \| \| Description \| The email address of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Shipping email |
| Description | The email address of the shipping customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| shipping_fax \| \| --- \| \| \\| Display name \\| Shipping fax \\| \\| --- \\| --- \\| \\| Description \\| The fax number of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping fax \| \| --- \| --- \| \| Description \| The fax number of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping fax |
| Description | The fax number of the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_first_name \| \| --- \| \| \\| Display name \\| Shipping first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping first name \| \| --- \| --- \| \| Description \| The first name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_last_name \| \| --- \| \| \\| Display name \\| Shipping last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping last name \| \| --- \| --- \| \| Description \| The last name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_middle_name \| \| --- \| \| \\| Display name \\| Shipping middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping middle name \| \| --- \| --- \| \| Description \| The middle name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_postal_code \| \| --- \| \| \\| Display name \\| Shipping postal code \\| \\| --- \\| --- \\| \\| Description \\| The postal code of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping postal code \| \| --- \| --- \| \| Description \| The postal code of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_region \| \| --- \| \| \\| Display name \\| Shipping region \\| \\| --- \\| --- \\| \\| Description \\| The region or state of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping region \| \| --- \| --- \| \| Description \| The region or state of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Display name | 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_code \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_street \| \| --- \| \| \\| Display name \\| Shipping street \\| \\| --- \\| --- \\| \\| Description \\| The street address of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping street \| \| --- \| --- \| \| Description \| The street address of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Display name | Shipping street |
| Description | The street address of the shipping customer |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| shipping_telephone \| \| --- \| \| \\| Display name \\| Shipping telephone \\| \\| --- \\| --- \\| \\| Description \\| The telephone number of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping telephone \| \| --- \| --- \| \| Description \| The telephone number of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Shipping telephone |
| Description | The telephone number of the shipping customer |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| store_domain \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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) |

### Table: CUSTOMER

| \| billing_city \| \| --- \| \| \\| Display name \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| The city of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing city \| \| Description \| The city of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| --- |
| billing_city |
| \| Display name \| Billing city \| \| --- \| --- \| \| Description \| The city of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Billing city |
| Description | The city of the billing address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| billing_company \| \| --- \| \| \\| Display name \\| Billing company \\| \\| --- \\| --- \\| \\| Description \\| The company name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing company \| \| --- \| --- \| \| Description \| The company name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing company |
| Description | The company name of the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_country_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_fax \| \| --- \| \| \\| Display name \\| Billing fax \\| \\| --- \\| --- \\| \\| Description \\| The fax number of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing fax \| \| --- \| --- \| \| Description \| The fax number of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing fax |
| Description | The fax number of the billing customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_first_name \| \| --- \| \| \\| Display name \\| Billing first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing first name \| \| --- \| --- \| \| Description \| The first name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_last_name \| \| --- \| \| \\| Display name \\| Billing last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing last name \| \| --- \| --- \| \| Description \| The last name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_middle_name \| \| --- \| \| \\| Display name \\| Billing middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing middle name \| \| --- \| --- \| \| Description \| The middle name of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_postal_code \| \| --- \| \| \\| Display name \\| Billing postal code \\| \\| --- \\| --- \\| \\| Description \\| The postal code of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing postal code \| \| --- \| --- \| \| Description \| The postal code of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_region \| \| --- \| \| \\| Display name \\| Billing region \\| \\| --- \\| --- \\| \\| Description \\| The region or state of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Billing region \| \| --- \| --- \| \| Description \| The region or state of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Display name | 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_code \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_street \| \| --- \| \| \\| Display name \\| Billing street \\| \\| --- \\| --- \\| \\| Description \\| The street address of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Billing street \| \| --- \| --- \| \| Description \| The street address of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Display name | Billing street |
| Description | The street address of the billing customer |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_telephone \| \| --- \| \| \\| Display name \\| Billing telephone \\| \\| --- \\| --- \\| \\| Description \\| The telephone number of the billing customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Billing telephone \| \| --- \| --- \| \| Description \| The telephone number of the billing customer \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Billing telephone |
| Description | The telephone number of the billing customer |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| customer_created_date \| \| --- \| \| \\| Display name \\| Customer created date \\| \\| --- \\| --- \\| \\| Description \\| The date the customer was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| 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 |
| \| Display name \| Customer created date \| \| --- \| --- \| \| Description \| The date the customer was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_in \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_dob \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| Customer email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer email \| \| Description \| The email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| customer_email |
| \| Display name \| Customer email \| \| --- \| --- \| \| Description \| The email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Customer email |
| Description | The email address of the customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| customer_first_name \| \| --- \| \| \\| Display name \\| Customer first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer first name \| \| --- \| --- \| \| Description \| The first name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer first name |
| Description | The first name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_gender \| \| --- \| \| \\| Display name \\| Customer gender \\| \\| --- \\| --- \\| \\| Description \\| The gender of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.person.gender](/apidocs/field-data-types#person) \\| \| \| Display name \| Customer gender \| \| Description \| The gender of the customer \| \| Field type \| dimension \| \| Data type \| [string.person.gender](/apidocs/field-data-types#person) \| |
| customer_gender |
| \| Display name \| Customer gender \| \| --- \| --- \| \| Description \| The gender of the customer \| \| Field type \| dimension \| \| Data type \| [string.person.gender](/apidocs/field-data-types#person) \| |
| Display name | Customer gender |
| Description | The gender of the customer |
| Field type | dimension |
| Data type | [string.person.gender](/apidocs/field-data-types#person) |
| \| customer_group_id \| \| --- \| \| \\| Display name \\| Customer group ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the customer group \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer group ID \| \| --- \| --- \| \| Description \| The unique identifier of the customer group \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_id \| \| --- \| \| \\| Display name \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer ID \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_id |
| \| Display name \| Customer ID \| \| --- \| --- \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer ID |
| Description | The unique identifier of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_last_name \| \| --- \| \| \\| Display name \\| Customer last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer last name \| \| --- \| --- \| \| Description \| The last name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer last name |
| Description | The last name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_middle_name \| \| --- \| \| \\| Display name \\| Customer middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Customer middle name \| \| --- \| --- \| \| Description \| The middle name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer middle name |
| Description | The middle name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_name_suffix \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_prefix \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_tax_vat_number \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_updated_date \| \| --- \| \| \\| Display name \\| Customer updated date \\| \\| --- \\| --- \\| \\| Description \\| The date the customer was last updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| 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 |
| \| Display name \| Customer updated date \| \| --- \| --- \| \| Description \| The date the customer was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| Customers \\| \\| --- \\| --- \\| \\| Description \\| The number of customers \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Customers \| \| Description \| The number of customers \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| customers |
| \| Display name \| Customers \| \| --- \| --- \| \| Description \| The number of customers \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Customers |
| Description | The number of customers |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| dataSourceName \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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) \| |
| dataSourceName |
| \| Display name \| 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) \| |
| Display name | 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) |
| \| date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date |
| \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| shipping_city \| \| --- \| \| \\| Display name \\| Shipping city \\| \\| --- \\| --- \\| \\| Description \\| The city of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Shipping city \| \| Description \| The city of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| shipping_city |
| \| Display name \| Shipping city \| \| --- \| --- \| \| Description \| The city of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Shipping city |
| Description | The city of the shipping address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| shipping_company \| \| --- \| \| \\| Display name \\| Shipping company \\| \\| --- \\| --- \\| \\| Description \\| The company name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping company \| \| --- \| --- \| \| Description \| The company name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping company |
| Description | The company name of the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_country_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_fax \| \| --- \| \| \\| Display name \\| Shipping fax \\| \\| --- \\| --- \\| \\| Description \\| The fax number of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping fax \| \| --- \| --- \| \| Description \| The fax number of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping fax |
| Description | The fax number of the shipping customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_first_name \| \| --- \| \| \\| Display name \\| Shipping first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping first name \| \| --- \| --- \| \| Description \| The first name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_last_name \| \| --- \| \| \\| Display name \\| Shipping last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping last name \| \| --- \| --- \| \| Description \| The last name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_middle_name \| \| --- \| \| \\| Display name \\| Shipping middle name \\| \\| --- \\| --- \\| \\| Description \\| The middle name of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping middle name \| \| --- \| --- \| \| Description \| The middle name of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_postal_code \| \| --- \| \| \\| Display name \\| Shipping postal code \\| \\| --- \\| --- \\| \\| Description \\| The postal code of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping postal code \| \| --- \| --- \| \| Description \| The postal code of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | 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_region \| \| --- \| \| \\| Display name \\| Shipping region \\| \\| --- \\| --- \\| \\| Description \\| The region or state of the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping region \| \| --- \| --- \| \| Description \| The region or state of the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Display name | 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_code \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_id \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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_street \| \| --- \| \| \\| Display name \\| Shipping street \\| \\| --- \\| --- \\| \\| Description \\| The street address of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping street \| \| --- \| --- \| \| Description \| The street address of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Display name | Shipping street |
| Description | The street address of the shipping customer |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| shipping_telephone \| \| --- \| \| \\| Display name \\| Shipping telephone \\| \\| --- \\| --- \\| \\| Description \\| The telephone number of the shipping customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| 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 |
| \| Display name \| Shipping telephone \| \| --- \| --- \| \| Description \| The telephone number of the shipping customer \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Shipping telephone |
| Description | The telephone number of the shipping customer |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| store_domain \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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 \| \| --- \| \| \\| Display name \\| 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) \\| \| \| Display name \| 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 |
| \| Display name \| 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) \| |
| Display name | 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) |