---
title: "BigCommerce data warehouse table groups"
slug: "bigcommerce-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for BigCommerce. See all the tables and the fields included in them."
updated: 2026-03-05T14:06:51Z
published: 2026-03-05T14:06:51Z
canonical: "docs.supermetrics.com/bigcommerce-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.

# BigCommerce data warehouse table groups

Search fields

### Table: ORDER

| \| billing_city \| \| --- \| \| \\| Display name \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| City of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing city \| \| Description \| 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 \| City of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Billing city |
| Description | 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 \\| Company name of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing company \| \| Description \| Company name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_company |
| \| Display name \| Billing company \| \| --- \| --- \| \| Description \| Company name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing company |
| Description | Company name of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_country \| \| --- \| \| \\| Display name \\| Billing country \\| \\| --- \\| --- \\| \\| Description \\| Country of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing country \| \| Description \| Country of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| billing_country |
| \| Display name \| Billing country \| \| --- \| --- \| \| Description \| Country of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Display name | Billing country |
| Description | Country of the billing address |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| billing_country_iso2 \| \| --- \| \| \\| Display name \\| Billing country (ISO2) \\| \\| --- \\| --- \\| \\| Description \\| ISO 2-letter code for the billing country \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing country (ISO2) \| \| Description \| ISO 2-letter code for the billing country \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| billing_country_iso2 |
| \| Display name \| Billing country (ISO2) \| \| --- \| --- \| \| Description \| ISO 2-letter code for the billing country \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Display name | Billing country (ISO2) |
| Description | ISO 2-letter code for the billing country |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| billing_email \| \| --- \| \| \\| Display name \\| Billing email \\| \\| --- \\| --- \\| \\| Description \\| Email address of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing email \| \| Description \| Email address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| billing_email |
| \| Display name \| Billing email \| \| --- \| --- \| \| Description \| Email address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Billing email |
| Description | Email address of the billing address |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| billing_first_name \| \| --- \| \| \\| Display name \\| Billing first name \\| \\| --- \\| --- \\| \\| Description \\| First name of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing first name \| \| Description \| First name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_first_name |
| \| Display name \| Billing first name \| \| --- \| --- \| \| Description \| First name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing first name |
| Description | First name of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_last_name \| \| --- \| \| \\| Display name \\| Billing last name \\| \\| --- \\| --- \\| \\| Description \\| Last name of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing last name \| \| Description \| Last name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_last_name |
| \| Display name \| Billing last name \| \| --- \| --- \| \| Description \| Last name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing last name |
| Description | Last name of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_phone \| \| --- \| \| \\| Display name \\| Billing phone \\| \\| --- \\| --- \\| \\| Description \\| Phone number of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing phone \| \| Description \| Phone number of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| billing_phone |
| \| Display name \| Billing phone \| \| --- \| --- \| \| Description \| Phone number of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Billing phone |
| Description | Phone number of the billing address |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| billing_state \| \| --- \| \| \\| Display name \\| Billing state \\| \\| --- \\| --- \\| \\| Description \\| State/province of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing state \| \| Description \| State/province of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| billing_state |
| \| Display name \| Billing state \| \| --- \| --- \| \| Description \| State/province of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Display name | Billing state |
| Description | State/province of the billing address |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| billing_street_1 \| \| --- \| \| \\| Display name \\| Billing street 1 \\| \\| --- \\| --- \\| \\| Description \\| Street address of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing street 1 \| \| Description \| Street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| billing_street_1 |
| \| Display name \| Billing street 1 \| \| --- \| --- \| \| Description \| Street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Display name | Billing street 1 |
| Description | Street address of the billing address |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_street_2 \| \| --- \| \| \\| Display name \\| Billing street 2 \\| \\| --- \\| --- \\| \\| Description \\| Additional street address of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing street 2 \| \| Description \| Additional street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| billing_street_2 |
| \| Display name \| Billing street 2 \| \| --- \| --- \| \| Description \| Additional street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Display name | Billing street 2 |
| Description | Additional street address of the billing address |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_zip \| \| --- \| \| \\| Display name \\| Billing zip \\| \\| --- \\| --- \\| \\| Description \\| Zip/postal code of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.zip](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing zip \| \| Description \| Zip/postal code of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| billing_zip |
| \| Display name \| Billing zip \| \| --- \| --- \| \| Description \| Zip/postal code of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| Display name | Billing zip |
| Description | Zip/postal code of the billing address |
| Field type | dimension |
| Data type | [string.geo.zip](/apidocs/field-data-types#geographical) |
| \| channel_id \| \| --- \| \| \\| Display name \\| Channel ID \\| \\| --- \\| --- \\| \\| Description \\| Shows where the order originated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel ID \| \| Description \| Shows where the order originated \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| channel_id |
| \| Display name \| Channel ID \| \| --- \| --- \| \| Description \| Shows where the order originated \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Channel ID |
| Description | Shows where the order originated |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| coupon \| \| --- \| \| \\| Display name \\| Coupon \\| \\| --- \\| --- \\| \\| Description \\| The coupon amount that the shopper has redeemed on this individual order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Coupon \| \| Description \| The coupon amount that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| coupon |
| \| Display name \| Coupon \| \| --- \| --- \| \| Description \| The coupon amount that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Coupon |
| Description | The coupon amount that the shopper has redeemed on this individual order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| created_date \| \| --- \| \| \\| Display name \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| Date the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date \| \| Description \| Date the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| created_date |
| \| Display name \| Created date \| \| --- \| --- \| \| Description \| Date the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Created date |
| Description | Date the order was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| created_datetime \| \| --- \| \| \\| Display name \\| Created datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Created datetime \| \| Description \| Date and time the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| created_datetime |
| \| Display name \| Created datetime \| \| --- \| --- \| \| Description \| Date and time the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Created datetime |
| Description | Date and time the order was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| currency_code \| \| --- \| \| \\| Display name \\| Currency code \\| \\| --- \\| --- \\| \\| Description \\| The currency code associated with the price record being acted upon \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Currency code \| \| Description \| The currency code associated with the price record being acted upon \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| currency_code |
| \| Display name \| Currency code \| \| --- \| --- \| \| Description \| The currency code associated with the price record being acted upon \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Display name | Currency code |
| Description | The currency code associated with the price record being acted upon |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| currency_id \| \| --- \| \| \\| Display name \\| Currency ID \\| \\| --- \\| --- \\| \\| Description \\| The active currency ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Currency ID \| \| Description \| The active currency ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| currency_id |
| \| Display name \| Currency ID \| \| --- \| --- \| \| Description \| The active currency ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Currency ID |
| Description | The active currency ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| custom_status \| \| --- \| \| \\| Display name \\| Custom status \\| \\| --- \\| --- \\| \\| Description \\| Custom status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Custom status \| \| Description \| Custom status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| custom_status |
| \| Display name \| Custom status \| \| --- \| --- \| \| Description \| Custom status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Custom status |
| Description | Custom status of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_id \| \| --- \| \| \\| Display name \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer ID \| \| Description \| Unique identifier for the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_id |
| \| Display name \| Customer ID \| \| --- \| --- \| \| Description \| Unique identifier for the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer ID |
| Description | Unique identifier for the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_message \| \| --- \| \| \\| Display name \\| Customer message \\| \\| --- \\| --- \\| \\| Description \\| Message that the customer entered \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer message \| \| Description \| Message that the customer entered \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_message |
| \| Display name \| Customer message \| \| --- \| --- \| \| Description \| Message that the customer entered \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer message |
| Description | Message that the customer entered |
| 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) |
| \| discount_amount \| \| --- \| \| \\| Display name \\| Discount \\| \\| --- \\| --- \\| \\| Description \\| Amount of discount for this transaction \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Discount \| \| Description \| Amount of discount for this transaction \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| discount_amount |
| \| Display name \| Discount \| \| --- \| --- \| \| Description \| Amount of discount for this transaction \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Discount |
| Description | Amount of discount for this transaction |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| external_id \| \| --- \| \| \\| Display name \\| External ID \\| \\| --- \\| --- \\| \\| Description \\| The order ID in another system, such as the Amazon order ID if this is an Amazon order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| External ID \| \| Description \| The order ID in another system, such as the Amazon order ID if this is an Amazon order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| external_id |
| \| Display name \| External ID \| \| --- \| --- \| \| Description \| The order ID in another system, such as the Amazon order ID if this is an Amazon order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | External ID |
| Description | The order ID in another system, such as the Amazon order ID if this is an Amazon order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| geoip_country \| \| --- \| \| \\| Display name \\| GeoIP country \\| \\| --- \\| --- \\| \\| Description \\| The full name of the country where the customer made the purchase, based on the IP \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Display name \| GeoIP country \| \| Description \| The full name of the country where the customer made the purchase, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| geoip_country |
| \| Display name \| GeoIP country \| \| --- \| --- \| \| Description \| The full name of the country where the customer made the purchase, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Display name | GeoIP country |
| Description | The full name of the country where the customer made the purchase, based on the IP |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| geoip_country_iso2 \| \| --- \| \| \\| Display name \\| GeoIP country (ISO2) \\| \\| --- \\| --- \\| \\| Description \\| The country where the customer made the purchase, in ISO2 format, based on the IP \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Display name \| GeoIP country (ISO2) \| \| Description \| The country where the customer made the purchase, in ISO2 format, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| geoip_country_iso2 |
| \| Display name \| GeoIP country (ISO2) \| \| --- \| --- \| \| Description \| The country where the customer made the purchase, in ISO2 format, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Display name | GeoIP country (ISO2) |
| Description | The country where the customer made the purchase, in ISO2 format, based on the IP |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| gift_certificate \| \| --- \| \| \\| Display name \\| Gift certificate \\| \\| --- \\| --- \\| \\| Description \\| The gift certificate that the shopper has redeemed on this individual order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Gift certificate \| \| Description \| The gift certificate that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| gift_certificate |
| \| Display name \| Gift certificate \| \| --- \| --- \| \| Description \| The gift certificate that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Gift certificate |
| Description | The gift certificate that the shopper has redeemed on this individual order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| handling \| \| --- \| \| \\| Display name \\| Handling \\| \\| --- \\| --- \\| \\| Description \\| The value of the handling cost, including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Handling \| \| Description \| The value of the handling cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| handling |
| \| Display name \| Handling \| \| --- \| --- \| \| Description \| The value of the handling cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Handling |
| Description | The value of the handling cost, including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| ip_address \| \| --- \| \| \\| Display name \\| IP address \\| \\| --- \\| --- \\| \\| Description \\| IPv4 Address of the customer, if known \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| IP address \| \| Description \| IPv4 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| ip_address |
| \| Display name \| IP address \| \| --- \| --- \| \| Description \| IPv4 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | IP address |
| Description | IPv4 Address of the customer, if known |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| ip_address_v6 \| \| --- \| \| \\| Display name \\| IP address v6 \\| \\| --- \\| --- \\| \\| Description \\| IPv6 Address of the customer, if known \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| IP address v6 \| \| Description \| IPv6 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| ip_address_v6 |
| \| Display name \| IP address v6 \| \| --- \| --- \| \| Description \| IPv6 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | IP address v6 |
| Description | IPv6 Address of the customer, if known |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| items_shipped \| \| --- \| \| \\| Display name \\| Items shipped \\| \\| --- \\| --- \\| \\| Description \\| The number of items that have been shipped \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Items shipped \| \| Description \| The number of items that have been shipped \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| items_shipped |
| \| Display name \| Items shipped \| \| --- \| --- \| \| Description \| The number of items that have been shipped \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Items shipped |
| Description | The number of items that have been shipped |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| items_total \| \| --- \| \| \\| Display name \\| Items total \\| \\| --- \\| --- \\| \\| Description \\| The total number of items in the order \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Items total \| \| Description \| The total number of items in the order \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| items_total |
| \| Display name \| Items total \| \| --- \| --- \| \| Description \| The total number of items in the order \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Items total |
| Description | The total number of items in the order |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| modified_date \| \| --- \| \| \\| Display name \\| Modified date \\| \\| --- \\| --- \\| \\| Description \\| Date the order was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Modified date \| \| Description \| Date the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| modified_date |
| \| Display name \| Modified date \| \| --- \| --- \| \| Description \| Date the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Modified date |
| Description | Date the order was last modified |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| modified_datetime \| \| --- \| \| \\| Display name \\| Modified datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time the order was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Modified datetime \| \| Description \| Date and time the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| modified_datetime |
| \| Display name \| Modified datetime \| \| --- \| --- \| \| Description \| Date and time the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Modified datetime |
| Description | Date and time the order was last modified |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_id \| \| --- \| \| \\| Display name \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order ID \| \| Description \| Unique identifier for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_id |
| \| Display name \| Order ID \| \| --- \| --- \| \| Description \| Unique identifier for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order ID |
| Description | Unique identifier for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_is_digital \| \| --- \| \| \\| Display name \\| Order is digital \\| \\| --- \\| --- \\| \\| Description \\| Whether this is an order for digital products \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Order is digital \| \| Description \| Whether this is an order for digital products \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| order_is_digital |
| \| Display name \| Order is digital \| \| --- \| --- \| \| Description \| Whether this is an order for digital products \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Order is digital |
| Description | Whether this is an order for digital products |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_source \| \| --- \| \| \\| Display name \\| Order source \\| \\| --- \\| --- \\| \\| Description \\| Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order source \| \| Description \| Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_source |
| \| Display name \| Order source \| \| --- \| --- \| \| Description \| Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order source |
| Description | Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_method \| \| --- \| \| \\| Display name \\| Payment method \\| \\| --- \\| --- \\| \\| Description \\| The payment method for this order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment method \| \| Description \| The payment method for this order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_method |
| \| Display name \| Payment method \| \| --- \| --- \| \| Description \| The payment method for this order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment method |
| Description | The payment method for this order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_provider_id \| \| --- \| \| \\| Display name \\| Payment provider ID \\| \\| --- \\| --- \\| \\| Description \\| The external transaction ID/payment ID within this order’s payment provider \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment provider ID \| \| Description \| The external transaction ID/payment ID within this order’s payment provider \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_provider_id |
| \| Display name \| Payment provider ID \| \| --- \| --- \| \| Description \| The external transaction ID/payment ID within this order’s payment provider \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment provider ID |
| Description | The external transaction ID/payment ID within this order’s payment provider |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_status \| \| --- \| \| \\| Display name \\| Payment status \\| \\| --- \\| --- \\| \\| Description \\| Status of the payment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment status \| \| Description \| Status of the payment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_status |
| \| Display name \| Payment status \| \| --- \| --- \| \| Description \| Status of the payment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment status |
| Description | Status of the payment |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| refunded_amount \| \| --- \| \| \\| Display name \\| Refunded amount \\| \\| --- \\| --- \\| \\| Description \\| The amount refunded from this transaction \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Refunded amount \| \| Description \| The amount refunded from this transaction \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| refunded_amount |
| \| Display name \| Refunded amount \| \| --- \| --- \| \| Description \| The amount refunded from this transaction \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Refunded amount |
| Description | The amount refunded from this transaction |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shipped_date \| \| --- \| \| \\| Display name \\| Shipped date \\| \\| --- \\| --- \\| \\| Description \\| Date the order was shipped \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Shipped date \| \| Description \| Date the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| shipped_date |
| \| Display name \| Shipped date \| \| --- \| --- \| \| Description \| Date the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Shipped date |
| Description | Date the order was shipped |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| shipped_datetime \| \| --- \| \| \\| Display name \\| Shipped datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time the order was shipped \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Shipped datetime \| \| Description \| Date and time the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| shipped_datetime |
| \| Display name \| Shipped datetime \| \| --- \| --- \| \| Description \| Date and time the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Shipped datetime |
| Description | Date and time the order was shipped |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| shipping \| \| --- \| \| \\| Display name \\| Shipping \\| \\| --- \\| --- \\| \\| Description \\| The value of shipping cost, including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Shipping \| \| Description \| The value of shipping cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shipping |
| \| Display name \| Shipping \| \| --- \| --- \| \| Description \| The value of shipping cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Shipping |
| Description | The value of shipping cost, including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| status \| \| --- \| \| \\| Display name \\| Status \\| \\| --- \\| --- \\| \\| Description \\| Current status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Status \| \| Description \| Current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| status |
| \| Display name \| Status \| \| --- \| --- \| \| Description \| Current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Status |
| Description | Current status of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| status_id \| \| --- \| \| \\| Display name \\| Status ID \\| \\| --- \\| --- \\| \\| Description \\| The status ID of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Status ID \| \| Description \| The status ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| status_id |
| \| Display name \| Status ID \| \| --- \| --- \| \| Description \| The status ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Status ID |
| Description | The status ID of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| store_credit \| \| --- \| \| \\| Display name \\| Store credit \\| \\| --- \\| --- \\| \\| Description \\| The store credit that the shopper has redeemed on this individual order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Store credit \| \| Description \| The store credit that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| store_credit |
| \| Display name \| Store credit \| \| --- \| --- \| \| Description \| The store credit that the shopper has redeemed on this individual order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Store credit |
| Description | The store credit that the shopper has redeemed on this individual order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| store_hash \| \| --- \| \| \\| Display name \\| Store hash \\| \\| --- \\| --- \\| \\| Description \\| The name of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Store hash \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| store_hash |
| \| Display name \| Store hash \| \| --- \| --- \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Store hash |
| Description | The name of the store |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| subtotal \| \| --- \| \| \\| Display name \\| Subtotal \\| \\| --- \\| --- \\| \\| Description \\| The value of subtotal including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Subtotal \| \| Description \| The value of subtotal including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| subtotal |
| \| Display name \| Subtotal \| \| --- \| --- \| \| Description \| The value of subtotal including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Subtotal |
| Description | The value of subtotal including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total \| \| --- \| \| \\| Display name \\| Total \\| \\| --- \\| --- \\| \\| Description \\| Total value of the order including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Total \| \| Description \| Total value of the order including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total |
| \| Display name \| Total \| \| --- \| --- \| \| Description \| Total value of the order including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Total |
| Description | Total value of the order including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| wrapping \| \| --- \| \| \\| Display name \\| Wrapping \\| \\| --- \\| --- \\| \\| Description \\| The value of the wrapping cost, including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Wrapping \| \| Description \| The value of the wrapping cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| wrapping |
| \| Display name \| Wrapping \| \| --- \| --- \| \| Description \| The value of the wrapping cost, including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Wrapping |
| Description | The value of the wrapping cost, including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### Table: ORDER_ITEM

| \| billing_city \| \| --- \| \| \\| Display name \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| City of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing city \| \| Description \| 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 \| City of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Billing city |
| Description | 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 \\| Company name of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing company \| \| Description \| Company name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_company |
| \| Display name \| Billing company \| \| --- \| --- \| \| Description \| Company name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing company |
| Description | Company name of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_country \| \| --- \| \| \\| Display name \\| Billing country \\| \\| --- \\| --- \\| \\| Description \\| Country of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing country \| \| Description \| Country of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| billing_country |
| \| Display name \| Billing country \| \| --- \| --- \| \| Description \| Country of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Display name | Billing country |
| Description | Country of the billing address |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| billing_country_iso2 \| \| --- \| \| \\| Display name \\| Billing country (ISO2) \\| \\| --- \\| --- \\| \\| Description \\| ISO 2-letter code for the billing country \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing country (ISO2) \| \| Description \| ISO 2-letter code for the billing country \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| billing_country_iso2 |
| \| Display name \| Billing country (ISO2) \| \| --- \| --- \| \| Description \| ISO 2-letter code for the billing country \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Display name | Billing country (ISO2) |
| Description | ISO 2-letter code for the billing country |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| billing_email \| \| --- \| \| \\| Display name \\| Billing email \\| \\| --- \\| --- \\| \\| Description \\| Email address of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing email \| \| Description \| Email address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| billing_email |
| \| Display name \| Billing email \| \| --- \| --- \| \| Description \| Email address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Billing email |
| Description | Email address of the billing address |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| billing_first_name \| \| --- \| \| \\| Display name \\| Billing first name \\| \\| --- \\| --- \\| \\| Description \\| First name of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing first name \| \| Description \| First name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_first_name |
| \| Display name \| Billing first name \| \| --- \| --- \| \| Description \| First name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing first name |
| Description | First name of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_last_name \| \| --- \| \| \\| Display name \\| Billing last name \\| \\| --- \\| --- \\| \\| Description \\| Last name of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing last name \| \| Description \| Last name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_last_name |
| \| Display name \| Billing last name \| \| --- \| --- \| \| Description \| Last name of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing last name |
| Description | Last name of the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_phone \| \| --- \| \| \\| Display name \\| Billing phone \\| \\| --- \\| --- \\| \\| Description \\| Phone number of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing phone \| \| Description \| Phone number of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| billing_phone |
| \| Display name \| Billing phone \| \| --- \| --- \| \| Description \| Phone number of the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Billing phone |
| Description | Phone number of the billing address |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| billing_state \| \| --- \| \| \\| Display name \\| Billing state \\| \\| --- \\| --- \\| \\| Description \\| State/province of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing state \| \| Description \| State/province of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| billing_state |
| \| Display name \| Billing state \| \| --- \| --- \| \| Description \| State/province of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| |
| Display name | Billing state |
| Description | State/province of the billing address |
| Field type | dimension |
| Data type | [string.geo.region](/apidocs/field-data-types#geographical) |
| \| billing_street_1 \| \| --- \| \| \\| Display name \\| Billing street 1 \\| \\| --- \\| --- \\| \\| Description \\| Street address of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing street 1 \| \| Description \| Street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| billing_street_1 |
| \| Display name \| Billing street 1 \| \| --- \| --- \| \| Description \| Street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Display name | Billing street 1 |
| Description | Street address of the billing address |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_street_2 \| \| --- \| \| \\| Display name \\| Billing street 2 \\| \\| --- \\| --- \\| \\| Description \\| Additional street address of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing street 2 \| \| Description \| Additional street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| billing_street_2 |
| \| Display name \| Billing street 2 \| \| --- \| --- \| \| Description \| Additional street address of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Display name | Billing street 2 |
| Description | Additional street address of the billing address |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_zip \| \| --- \| \| \\| Display name \\| Billing zip \\| \\| --- \\| --- \\| \\| Description \\| Zip/postal code of the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.zip](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing zip \| \| Description \| Zip/postal code of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| billing_zip |
| \| Display name \| Billing zip \| \| --- \| --- \| \| Description \| Zip/postal code of the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| Display name | Billing zip |
| Description | Zip/postal code of the billing address |
| Field type | dimension |
| Data type | [string.geo.zip](/apidocs/field-data-types#geographical) |
| \| brand \| \| --- \| \| \\| Display name \\| Brand \\| \\| --- \\| --- \\| \\| Description \\| The products brand \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Brand \| \| Description \| The products brand \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| brand |
| \| Display name \| Brand \| \| --- \| --- \| \| Description \| The products brand \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Brand |
| Description | The products brand |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| channel_id \| \| --- \| \| \\| Display name \\| Channel ID \\| \\| --- \\| --- \\| \\| Description \\| Shows where the order originated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel ID \| \| Description \| Shows where the order originated \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| channel_id |
| \| Display name \| Channel ID \| \| --- \| --- \| \| Description \| Shows where the order originated \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Channel ID |
| Description | Shows where the order originated |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| created_date \| \| --- \| \| \\| Display name \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| Date the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date \| \| Description \| Date the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| created_date |
| \| Display name \| Created date \| \| --- \| --- \| \| Description \| Date the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Created date |
| Description | Date the order was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| created_datetime \| \| --- \| \| \\| Display name \\| Created datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Created datetime \| \| Description \| Date and time the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| created_datetime |
| \| Display name \| Created datetime \| \| --- \| --- \| \| Description \| Date and time the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Created datetime |
| Description | Date and time the order was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| currency_code \| \| --- \| \| \\| Display name \\| Currency code \\| \\| --- \\| --- \\| \\| Description \\| The currency code associated with the price record being acted upon \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Currency code \| \| Description \| The currency code associated with the price record being acted upon \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| currency_code |
| \| Display name \| Currency code \| \| --- \| --- \| \| Description \| The currency code associated with the price record being acted upon \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Display name | Currency code |
| Description | The currency code associated with the price record being acted upon |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| currency_id \| \| --- \| \| \\| Display name \\| Currency ID \\| \\| --- \\| --- \\| \\| Description \\| The active currency ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Currency ID \| \| Description \| The active currency ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| currency_id |
| \| Display name \| Currency ID \| \| --- \| --- \| \| Description \| The active currency ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Currency ID |
| Description | The active currency ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| custom_status \| \| --- \| \| \\| Display name \\| Custom status \\| \\| --- \\| --- \\| \\| Description \\| Custom status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Custom status \| \| Description \| Custom status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| custom_status |
| \| Display name \| Custom status \| \| --- \| --- \| \| Description \| Custom status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Custom status |
| Description | Custom status of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_id \| \| --- \| \| \\| Display name \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer ID \| \| Description \| Unique identifier for the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_id |
| \| Display name \| Customer ID \| \| --- \| --- \| \| Description \| Unique identifier for the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer ID |
| Description | Unique identifier for the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_message \| \| --- \| \| \\| Display name \\| Customer message \\| \\| --- \\| --- \\| \\| Description \\| Message that the customer entered \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer message \| \| Description \| Message that the customer entered \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_message |
| \| Display name \| Customer message \| \| --- \| --- \| \| Description \| Message that the customer entered \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer message |
| Description | Message that the customer entered |
| 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) |
| \| external_id \| \| --- \| \| \\| Display name \\| External ID \\| \\| --- \\| --- \\| \\| Description \\| The order ID in another system, such as the Amazon order ID if this is an Amazon order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| External ID \| \| Description \| The order ID in another system, such as the Amazon order ID if this is an Amazon order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| external_id |
| \| Display name \| External ID \| \| --- \| --- \| \| Description \| The order ID in another system, such as the Amazon order ID if this is an Amazon order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | External ID |
| Description | The order ID in another system, such as the Amazon order ID if this is an Amazon order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| geoip_country \| \| --- \| \| \\| Display name \\| GeoIP country \\| \\| --- \\| --- \\| \\| Description \\| The full name of the country where the customer made the purchase, based on the IP \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Display name \| GeoIP country \| \| Description \| The full name of the country where the customer made the purchase, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| geoip_country |
| \| Display name \| GeoIP country \| \| --- \| --- \| \| Description \| The full name of the country where the customer made the purchase, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Display name | GeoIP country |
| Description | The full name of the country where the customer made the purchase, based on the IP |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| geoip_country_iso2 \| \| --- \| \| \\| Display name \\| GeoIP country (ISO2) \\| \\| --- \\| --- \\| \\| Description \\| The country where the customer made the purchase, in ISO2 format, based on the IP \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Display name \| GeoIP country (ISO2) \| \| Description \| The country where the customer made the purchase, in ISO2 format, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| geoip_country_iso2 |
| \| Display name \| GeoIP country (ISO2) \| \| --- \| --- \| \| Description \| The country where the customer made the purchase, in ISO2 format, based on the IP \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Display name | GeoIP country (ISO2) |
| Description | The country where the customer made the purchase, in ISO2 format, based on the IP |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| ip_address \| \| --- \| \| \\| Display name \\| IP address \\| \\| --- \\| --- \\| \\| Description \\| IPv4 Address of the customer, if known \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| IP address \| \| Description \| IPv4 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| ip_address |
| \| Display name \| IP address \| \| --- \| --- \| \| Description \| IPv4 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | IP address |
| Description | IPv4 Address of the customer, if known |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| ip_address_v6 \| \| --- \| \| \\| Display name \\| IP address v6 \\| \\| --- \\| --- \\| \\| Description \\| IPv6 Address of the customer, if known \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| IP address v6 \| \| Description \| IPv6 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| ip_address_v6 |
| \| Display name \| IP address v6 \| \| --- \| --- \| \| Description \| IPv6 Address of the customer, if known \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | IP address v6 |
| Description | IPv6 Address of the customer, if known |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| modified_date \| \| --- \| \| \\| Display name \\| Modified date \\| \\| --- \\| --- \\| \\| Description \\| Date the order was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Modified date \| \| Description \| Date the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| modified_date |
| \| Display name \| Modified date \| \| --- \| --- \| \| Description \| Date the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Modified date |
| Description | Date the order was last modified |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| modified_datetime \| \| --- \| \| \\| Display name \\| Modified datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time the order was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Modified datetime \| \| Description \| Date and time the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| modified_datetime |
| \| Display name \| Modified datetime \| \| --- \| --- \| \| Description \| Date and time the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Modified datetime |
| Description | Date and time the order was last modified |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_id \| \| --- \| \| \\| Display name \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order ID \| \| Description \| Unique identifier for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_id |
| \| Display name \| Order ID \| \| --- \| --- \| \| Description \| Unique identifier for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order ID |
| Description | Unique identifier for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_is_digital \| \| --- \| \| \\| Display name \\| Order is digital \\| \\| --- \\| --- \\| \\| Description \\| Whether this is an order for digital products \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Order is digital \| \| Description \| Whether this is an order for digital products \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| order_is_digital |
| \| Display name \| Order is digital \| \| --- \| --- \| \| Description \| Whether this is an order for digital products \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Order is digital |
| Description | Whether this is an order for digital products |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_source \| \| --- \| \| \\| Display name \\| Order source \\| \\| --- \\| --- \\| \\| Description \\| Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order source \| \| Description \| Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_source |
| \| Display name \| Order source \| \| --- \| --- \| \| Description \| Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order source |
| Description | Reflects the origin of the order. It can affect the order’s icon and source as defined in the control panel listing |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_method \| \| --- \| \| \\| Display name \\| Payment method \\| \\| --- \\| --- \\| \\| Description \\| The payment method for this order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment method \| \| Description \| The payment method for this order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_method |
| \| Display name \| Payment method \| \| --- \| --- \| \| Description \| The payment method for this order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment method |
| Description | The payment method for this order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_provider_id \| \| --- \| \| \\| Display name \\| Payment provider ID \\| \\| --- \\| --- \\| \\| Description \\| The external transaction ID/payment ID within this order’s payment provider \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment provider ID \| \| Description \| The external transaction ID/payment ID within this order’s payment provider \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_provider_id |
| \| Display name \| Payment provider ID \| \| --- \| --- \| \| Description \| The external transaction ID/payment ID within this order’s payment provider \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment provider ID |
| Description | The external transaction ID/payment ID within this order’s payment provider |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_status \| \| --- \| \| \\| Display name \\| Payment status \\| \\| --- \\| --- \\| \\| Description \\| Status of the payment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment status \| \| Description \| Status of the payment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_status |
| \| Display name \| Payment status \| \| --- \| --- \| \| Description \| Status of the payment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment status |
| Description | Status of the payment |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| price_base \| \| --- \| \| \\| Display name \\| Price (base) \\| \\| --- \\| --- \\| \\| Description \\| The product’s cost price \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Price (base) \| \| Description \| The product’s cost price \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| price_base |
| \| Display name \| Price (base) \| \| --- \| --- \| \| Description \| The product’s cost price \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Price (base) |
| Description | The product’s cost price |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| price_inc_tax \| \| --- \| \| \\| Display name \\| Price (inc tax) \\| \\| --- \\| --- \\| \\| Description \\| The product’s cost price including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Price (inc tax) \| \| Description \| The product’s cost price including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| price_inc_tax |
| \| Display name \| Price (inc tax) \| \| --- \| --- \| \| Description \| The product’s cost price including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Price (inc tax) |
| Description | The product’s cost price including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| product_id \| \| --- \| \| \\| Display name \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| Numeric ID of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product ID \| \| Description \| Numeric ID of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_id |
| \| Display name \| Product ID \| \| --- \| --- \| \| Description \| Numeric ID of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product ID |
| Description | Numeric ID of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_name \| \| --- \| \| \\| Display name \\| Product name \\| \\| --- \\| --- \\| \\| Description \\| Name of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product name \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_name |
| \| Display name \| Product name \| \| --- \| --- \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product name |
| Description | Name of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| quantity \| \| --- \| \| \\| Display name \\| Quantity \\| \\| --- \\| --- \\| \\| Description \\| Quantity of the product ordered \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Quantity \| \| Description \| Quantity of the product ordered \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| quantity |
| \| Display name \| Quantity \| \| --- \| --- \| \| Description \| Quantity of the product ordered \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Quantity |
| Description | Quantity of the product ordered |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| quantity_refunded \| \| --- \| \| \\| Display name \\| Quantity refunded \\| \\| --- \\| --- \\| \\| Description \\| The total quantity of product refunded from this transaction \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Quantity refunded \| \| Description \| The total quantity of product refunded from this transaction \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| quantity_refunded |
| \| Display name \| Quantity refunded \| \| --- \| --- \| \| Description \| The total quantity of product refunded from this transaction \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Quantity refunded |
| Description | The total quantity of product refunded from this transaction |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| shipped_date \| \| --- \| \| \\| Display name \\| Shipped date \\| \\| --- \\| --- \\| \\| Description \\| Date the order was shipped \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Shipped date \| \| Description \| Date the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| shipped_date |
| \| Display name \| Shipped date \| \| --- \| --- \| \| Description \| Date the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Shipped date |
| Description | Date the order was shipped |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| shipped_datetime \| \| --- \| \| \\| Display name \\| Shipped datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time the order was shipped \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Shipped datetime \| \| Description \| Date and time the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| shipped_datetime |
| \| Display name \| Shipped datetime \| \| --- \| --- \| \| Description \| Date and time the order was shipped \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Shipped datetime |
| Description | Date and time the order was shipped |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| sku \| \| --- \| \| \\| Display name \\| SKU \\| \\| --- \\| --- \\| \\| Description \\| User-defined product code/stock keeping unit (SKU) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| SKU \| \| Description \| User-defined product code/stock keeping unit (SKU) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| sku |
| \| Display name \| SKU \| \| --- \| --- \| \| Description \| User-defined product code/stock keeping unit (SKU) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | SKU |
| Description | User-defined product code/stock keeping unit (SKU) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| status \| \| --- \| \| \\| Display name \\| Status \\| \\| --- \\| --- \\| \\| Description \\| Current status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Status \| \| Description \| Current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| status |
| \| Display name \| Status \| \| --- \| --- \| \| Description \| Current status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Status |
| Description | Current status of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| status_id \| \| --- \| \| \\| Display name \\| Status ID \\| \\| --- \\| --- \\| \\| Description \\| The status ID of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Status ID \| \| Description \| The status ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| status_id |
| \| Display name \| Status ID \| \| --- \| --- \| \| Description \| The status ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Status ID |
| Description | The status ID of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| store_hash \| \| --- \| \| \\| Display name \\| Store hash \\| \\| --- \\| --- \\| \\| Description \\| The name of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Store hash \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| store_hash |
| \| Display name \| Store hash \| \| --- \| --- \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Store hash |
| Description | The name of the store |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| total_base \| \| --- \| \| \\| Display name \\| Total (base) \\| \\| --- \\| --- \\| \\| Description \\| Total base price \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Total (base) \| \| Description \| Total base price \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_base |
| \| Display name \| Total (base) \| \| --- \| --- \| \| Description \| Total base price \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Total (base) |
| Description | Total base price |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_inc_tax \| \| --- \| \| \\| Display name \\| Total (inc tax) \\| \\| --- \\| --- \\| \\| Description \\| Total base price including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Total (inc tax) \| \| Description \| Total base price including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_inc_tax |
| \| Display name \| Total (inc tax) \| \| --- \| --- \| \| Description \| Total base price including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Total (inc tax) |
| Description | Total base price including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| type \| \| --- \| \| \\| Display name \\| Type \\| \\| --- \\| --- \\| \\| Description \\| Type of product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Type \| \| Description \| Type of product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| type |
| \| Display name \| Type \| \| --- \| --- \| \| Description \| Type of product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Type |
| Description | Type of product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| upc \| \| --- \| \| \\| Display name \\| UPC \\| \\| --- \\| --- \\| \\| Description \\| Universal product code. Can be written to for custom products and catalog products \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| UPC \| \| Description \| Universal product code. Can be written to for custom products and catalog products \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| upc |
| \| Display name \| UPC \| \| --- \| --- \| \| Description \| Universal product code. Can be written to for custom products and catalog products \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | UPC |
| Description | Universal product code. Can be written to for custom products and catalog products |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |