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

# WooCommerce data warehouse table groups

Search fields

### Table: ORDERS

| \| account_name \| \| --- \| \| \\| Display name \\| Store URL \\| \\| --- \\| --- \\| \\| Description \\| The URL of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Store URL \| \| Description \| The URL of the store \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| --- |
| account_name |
| \| Display name \| Store URL \| \| --- \| --- \| \| Description \| The URL of the store \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Store URL |
| Description | The URL of the store |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| billing_address_line_1 \| \| --- \| \| \\| Display name \\| Billing address line 1 \\| \\| --- \\| --- \\| \\| Description \\| Address line 1 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing address line 1 \| \| Description \| Address line 1 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_address_line_1 |
| \| Display name \| Billing address line 1 \| \| --- \| --- \| \| Description \| Address line 1 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing address line 1 |
| Description | Address line 1 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_address_line_2 \| \| --- \| \| \\| Display name \\| Billing address line 2 \\| \\| --- \\| --- \\| \\| Description \\| Address line 2 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing address line 2 \| \| Description \| Address line 2 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_address_line_2 |
| \| Display name \| Billing address line 2 \| \| --- \| --- \| \| Description \| Address line 2 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing address line 2 |
| Description | Address line 2 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_city \| \| --- \| \| \\| Display name \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| City name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing city \| \| Description \| City name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| billing_city |
| \| Display name \| Billing city \| \| --- \| --- \| \| Description \| City name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Billing city |
| Description | City name |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| billing_company_name \| \| --- \| \| \\| Display name \\| Billing company name \\| \\| --- \\| --- \\| \\| Description \\| Company name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing company name \| \| Description \| Company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_company_name |
| \| Display name \| Billing company name \| \| --- \| --- \| \| Description \| Company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing company name |
| Description | Company name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_country \| \| --- \| \| \\| Display name \\| Billing country code \\| \\| --- \\| --- \\| \\| Description \\| Shipping country. Country code in ISO 3166-1 alpha-2 format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing country code \| \| Description \| Shipping country. Country code in ISO 3166-1 alpha-2 format \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| billing_country |
| \| Display name \| Billing country code \| \| --- \| --- \| \| Description \| Shipping country. Country code in ISO 3166-1 alpha-2 format \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Display name | Billing country code |
| Description | Shipping country. Country code in ISO 3166-1 alpha-2 format |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| billing_email \| \| --- \| \| \\| Display name \\| Billing email \\| \\| --- \\| --- \\| \\| Description \\| Email address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing email \| \| Description \| Email address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| billing_email |
| \| Display name \| Billing email \| \| --- \| --- \| \| Description \| Email address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Billing email |
| Description | Email address |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| billing_first_name \| \| --- \| \| \\| Display name \\| Billing first name \\| \\| --- \\| --- \\| \\| Description \\| Billing first name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing first name \| \| Description \| Billing first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_first_name |
| \| Display name \| Billing first name \| \| --- \| --- \| \| Description \| Billing first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing first name |
| Description | Billing first name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_last_name \| \| --- \| \| \\| Display name \\| Billing last name \\| \\| --- \\| --- \\| \\| Description \\| Billing last name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing last name \| \| Description \| Billing last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_last_name |
| \| Display name \| Billing last name \| \| --- \| --- \| \| Description \| Billing last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing last name |
| Description | Billing last name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_phone \| \| --- \| \| \\| Display name \\| Billing phone \\| \\| --- \\| --- \\| \\| Description \\| Phone number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing phone \| \| Description \| Phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| billing_phone |
| \| Display name \| Billing phone \| \| --- \| --- \| \| Description \| Phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Billing phone |
| Description | Phone number |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| billing_postcode \| \| --- \| \| \\| Display name \\| Billing post code \\| \\| --- \\| --- \\| \\| Description \\| Postal code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing post code \| \| Description \| Postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_postcode |
| \| Display name \| Billing post code \| \| --- \| --- \| \| Description \| Postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing post code |
| Description | Postal code |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_state \| \| --- \| \| \\| Display name \\| Billing state \\| \\| --- \\| --- \\| \\| Description \\| Shipping state. ISO code or name of the state, province or district \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing state \| \| Description \| Shipping state. ISO code or name of the state, province or district \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_state |
| \| Display name \| Billing state \| \| --- \| --- \| \| Description \| Shipping state. ISO code or name of the state, province or district \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing state |
| Description | Shipping state. ISO code or name of the state, province or district |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| created_via \| \| --- \| \| \\| Display name \\| Order created via \\| \\| --- \\| --- \\| \\| Description \\| Shows where the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order created via \| \| Description \| Shows where the order was created \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| created_via |
| \| Display name \| Order created via \| \| --- \| --- \| \| Description \| Shows where the order was created \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order created via |
| Description | Shows where the order was created |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_id \| \| --- \| \| \\| Display name \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| User ID who owns the order. 0 for guests. Default is 0 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer ID \| \| Description \| User ID who owns the order. 0 for guests. Default is 0 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_id |
| \| Display name \| Customer ID \| \| --- \| --- \| \| Description \| User ID who owns the order. 0 for guests. Default is 0 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer ID |
| Description | User ID who owns the order. 0 for guests. Default is 0 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_ip_address \| \| --- \| \| \\| Display name \\| Customer IP address \\| \\| --- \\| --- \\| \\| Description \\| Customer's IP address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer IP address \| \| Description \| Customer's IP address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_ip_address |
| \| Display name \| Customer IP address \| \| --- \| --- \| \| Description \| Customer's IP address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer IP address |
| Description | Customer's IP address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_note \| \| --- \| \| \\| Display name \\| Customer note \\| \\| --- \\| --- \\| \\| Description \\| Note left by customer during checkout \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer note \| \| Description \| Note left by customer during checkout \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_note |
| \| Display name \| Customer note \| \| --- \| --- \| \| Description \| Note left by customer during checkout \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer note |
| Description | Note left by customer during checkout |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_user_agent \| \| --- \| \| \\| Display name \\| Customer user agent \\| \\| --- \\| --- \\| \\| Description \\| User agent of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer user agent \| \| Description \| User agent of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_user_agent |
| \| Display name \| Customer user agent \| \| --- \| --- \| \| Description \| User agent of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer user agent |
| Description | User agent of the customer |
| 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) |
| \| needs_payment \| \| --- \| \| \\| Display name \\| Order is paid \\| \\| --- \\| --- \\| \\| Description \\| Define if the order is paid. It will set the status to processing and reduce stock items \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Order is paid \| \| Description \| Define if the order is paid. It will set the status to processing and reduce stock items \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| needs_payment |
| \| Display name \| Order is paid \| \| --- \| --- \| \| Description \| Define if the order is paid. It will set the status to processing and reduce stock items \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Order is paid |
| Description | Define if the order is paid. It will set the status to processing and reduce stock items |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_cart_tax \| \| --- \| \| \\| Display name \\| Order cart tax \\| \\| --- \\| --- \\| \\| Description \\| Sum of line item taxes only \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order cart tax \| \| Description \| Sum of line item taxes only \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_cart_tax |
| \| Display name \| Order cart tax \| \| --- \| --- \| \| Description \| Sum of line item taxes only \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Order cart tax |
| Description | Sum of line item taxes only |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_completed_date \| \| --- \| \| \\| Display name \\| Order completed date \\| \\| --- \\| --- \\| \\| Description \\| The date the order was completed, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order completed date \| \| Description \| The date the order was completed, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_completed_date |
| \| Display name \| Order completed date \| \| --- \| --- \| \| Description \| The date the order was completed, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order completed date |
| Description | The date the order was completed, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_completed_date_gmt \| \| --- \| \| \\| Display name \\| Order completed date (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The date the order was completed, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order completed date (GMT) \| \| Description \| The date the order was completed, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_completed_date_gmt |
| \| Display name \| Order completed date (GMT) \| \| --- \| --- \| \| Description \| The date the order was completed, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order completed date (GMT) |
| Description | The date the order was completed, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_completed_datetime \| \| --- \| \| \\| Display name \\| Order completed datetime \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was completed, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order completed datetime \| \| Description \| The datetime the order was completed, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_completed_datetime |
| \| Display name \| Order completed datetime \| \| --- \| --- \| \| Description \| The datetime the order was completed, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order completed datetime |
| Description | The datetime the order was completed, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_completed_datetime_gmt \| \| --- \| \| \\| Display name \\| Order completed datetime (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was completed, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order completed datetime (GMT) \| \| Description \| The datetime the order was completed, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_completed_datetime_gmt |
| \| Display name \| Order completed datetime (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was completed, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order completed datetime (GMT) |
| Description | The datetime the order was completed, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_created_date \| \| --- \| \| \\| Display name \\| Order created date \\| \\| --- \\| --- \\| \\| Description \\| The date the order was created, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order created date \| \| Description \| The date the order was created, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_created_date |
| \| Display name \| Order created date \| \| --- \| --- \| \| Description \| The date the order was created, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order created date |
| Description | The date the order was created, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_created_datetime \| \| --- \| \| \\| Display name \\| Order created datetime \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was created, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order created datetime \| \| Description \| The datetime the order was created, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_created_datetime |
| \| Display name \| Order created datetime \| \| --- \| --- \| \| Description \| The datetime the order was created, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order created datetime |
| Description | The datetime the order was created, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_created_datetime_gmt \| \| --- \| \| \\| Display name \\| Order created datetime (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was created, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order created datetime (GMT) \| \| Description \| The datetime the order was created, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_created_datetime_gmt |
| \| Display name \| Order created datetime (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was created, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order created datetime (GMT) |
| Description | The datetime the order was created, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_created_gmt \| \| --- \| \| \\| Display name \\| Order created date (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was created, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order created date (GMT) \| \| Description \| The datetime the order was created, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_created_gmt |
| \| Display name \| Order created date (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was created, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order created date (GMT) |
| Description | The datetime the order was created, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_currency \| \| --- \| \| \\| Display name \\| Order currency \\| \\| --- \\| --- \\| \\| Description \\| Currency the order was created with, in ISO format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order currency \| \| Description \| Currency the order was created with, in ISO format \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| order_currency |
| \| Display name \| Order currency \| \| --- \| --- \| \| Description \| Currency the order was created with, in ISO format \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Display name | Order currency |
| Description | Currency the order was created with, in ISO format |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| order_discount_tax \| \| --- \| \| \\| Display name \\| Order discount tax \\| \\| --- \\| --- \\| \\| Description \\| Total discount tax amount for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order discount tax \| \| Description \| Total discount tax amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_discount_tax |
| \| Display name \| Order discount tax \| \| --- \| --- \| \| Description \| Total discount tax amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Order discount tax |
| Description | Total discount tax amount for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_discount_total \| \| --- \| \| \\| Display name \\| Order discount total \\| \\| --- \\| --- \\| \\| Description \\| Total discount amount for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order discount total \| \| Description \| Total discount amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_discount_total |
| \| Display name \| Order discount total \| \| --- \| --- \| \| Description \| Total discount amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Order discount total |
| Description | Total discount amount for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| 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_key \| \| --- \| \| \\| Display name \\| Order key \\| \\| --- \\| --- \\| \\| Description \\| Key of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order key \| \| Description \| Key of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_key |
| \| Display name \| Order key \| \| --- \| --- \| \| Description \| Key of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order key |
| Description | Key of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_modified_date \| \| --- \| \| \\| Display name \\| Order modified date \\| \\| --- \\| --- \\| \\| Description \\| The date the order was last modified, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order modified date \| \| Description \| The date the order was last modified, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_modified_date |
| \| Display name \| Order modified date \| \| --- \| --- \| \| Description \| The date the order was last modified, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order modified date |
| Description | The date the order was last modified, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_modified_datetime \| \| --- \| \| \\| Display name \\| Order modified datetime \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was last modified, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order modified datetime \| \| Description \| The datetime the order was last modified, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_modified_datetime |
| \| Display name \| Order modified datetime \| \| --- \| --- \| \| Description \| The datetime the order was last modified, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order modified datetime |
| Description | The datetime the order was last modified, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_modified_datetime_gmt \| \| --- \| \| \\| Display name \\| Order modified datetime (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was last modified, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order modified datetime (GMT) \| \| Description \| The datetime the order was last modified, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_modified_datetime_gmt |
| \| Display name \| Order modified datetime (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was last modified, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order modified datetime (GMT) |
| Description | The datetime the order was last modified, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_modified_gmt \| \| --- \| \| \\| Display name \\| Order modified date (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was last modified, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order modified date (GMT) \| \| Description \| The datetime the order was last modified, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_modified_gmt |
| \| Display name \| Order modified date (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was last modified, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order modified date (GMT) |
| Description | The datetime the order was last modified, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_number \| \| --- \| \| \\| Display name \\| Order number \\| \\| --- \\| --- \\| \\| Description \\| Number of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order number \| \| Description \| Number of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_number |
| \| Display name \| Order number \| \| --- \| --- \| \| Description \| Number of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order number |
| Description | Number of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_paid_date \| \| --- \| \| \\| Display name \\| Order paid date \\| \\| --- \\| --- \\| \\| Description \\| The date the order was paid, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order paid date \| \| Description \| The date the order was paid, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_paid_date |
| \| Display name \| Order paid date \| \| --- \| --- \| \| Description \| The date the order was paid, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order paid date |
| Description | The date the order was paid, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_paid_date_gmt \| \| --- \| \| \\| Display name \\| Order paid date (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The date the order was paid, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order paid date (GMT) \| \| Description \| The date the order was paid, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_paid_date_gmt |
| \| Display name \| Order paid date (GMT) \| \| --- \| --- \| \| Description \| The date the order was paid, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order paid date (GMT) |
| Description | The date the order was paid, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_paid_datetime \| \| --- \| \| \\| Display name \\| Order paid datetime \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was paid, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order paid datetime \| \| Description \| The datetime the order was paid, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_paid_datetime |
| \| Display name \| Order paid datetime \| \| --- \| --- \| \| Description \| The datetime the order was paid, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order paid datetime |
| Description | The datetime the order was paid, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_paid_datetime_gmt \| \| --- \| \| \\| Display name \\| Order paid datetime (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was paid, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order paid datetime (GMT) \| \| Description \| The datetime the order was paid, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_paid_datetime_gmt |
| \| Display name \| Order paid datetime (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was paid, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order paid datetime (GMT) |
| Description | The datetime the order was paid, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_shipping_tax \| \| --- \| \| \\| Display name \\| Order shipping tax \\| \\| --- \\| --- \\| \\| Description \\| Total shipping tax amount for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order shipping tax \| \| Description \| Total shipping tax amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_shipping_tax |
| \| Display name \| Order shipping tax \| \| --- \| --- \| \| Description \| Total shipping tax amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Order shipping tax |
| Description | Total shipping tax amount for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_shipping_total \| \| --- \| \| \\| Display name \\| Order shipping total \\| \\| --- \\| --- \\| \\| Description \\| Total shipping amount for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order shipping total \| \| Description \| Total shipping amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_shipping_total |
| \| Display name \| Order shipping total \| \| --- \| --- \| \| Description \| Total shipping amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Order shipping total |
| Description | Total shipping amount for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_status \| \| --- \| \| \\| Display name \\| Order status \\| \\| --- \\| --- \\| \\| Description \\| Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order status \| \| Description \| Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_status |
| \| Display name \| Order status \| \| --- \| --- \| \| Description \| Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order status |
| Description | Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_total \| \| --- \| \| \\| Display name \\| Order total \\| \\| --- \\| --- \\| \\| Description \\| Grand total \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order total \| \| Description \| Grand total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_total |
| \| Display name \| Order total \| \| --- \| --- \| \| Description \| Grand total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Order total |
| Description | Grand total |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_total_tax \| \| --- \| \| \\| Display name \\| Order total tax \\| \\| --- \\| --- \\| \\| Description \\| Sum of all taxes \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order total tax \| \| Description \| Sum of all taxes \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_total_tax |
| \| Display name \| Order total tax \| \| --- \| --- \| \| Description \| Sum of all taxes \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Order total tax |
| Description | Sum of all taxes |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| parent_id \| \| --- \| \| \\| Display name \\| Order parent ID \\| \\| --- \\| --- \\| \\| Description \\| Parent ID of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order parent ID \| \| Description \| Parent ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| parent_id |
| \| Display name \| Order parent ID \| \| --- \| --- \| \| Description \| Parent ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order parent ID |
| Description | Parent ID of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_method \| \| --- \| \| \\| Display name \\| Payment method ID \\| \\| --- \\| --- \\| \\| Description \\| Payment method ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment method ID \| \| Description \| Payment method ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_method |
| \| Display name \| Payment method ID \| \| --- \| --- \| \| Description \| Payment method ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment method ID |
| Description | Payment method ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_method_title \| \| --- \| \| \\| Display name \\| Payment method title \\| \\| --- \\| --- \\| \\| Description \\| Payment method title \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment method title \| \| Description \| Payment method title \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_method_title |
| \| Display name \| Payment method title \| \| --- \| --- \| \| Description \| Payment method title \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment method title |
| Description | Payment method title |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| prices_include_tax \| \| --- \| \| \\| Display name \\| Prices include tax \\| \\| --- \\| --- \\| \\| Description \\| True the prices included tax during checkout \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Prices include tax \| \| Description \| True the prices included tax during checkout \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| prices_include_tax |
| \| Display name \| Prices include tax \| \| --- \| --- \| \| Description \| True the prices included tax during checkout \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Prices include tax |
| Description | True the prices included tax during checkout |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| shipping_address_line_1 \| \| --- \| \| \\| Display name \\| Shipping address line 1 \\| \\| --- \\| --- \\| \\| Description \\| Shipping address line 1 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping address line 1 \| \| Description \| Shipping address line 1 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_address_line_1 |
| \| Display name \| Shipping address line 1 \| \| --- \| --- \| \| Description \| Shipping address line 1 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping address line 1 |
| Description | Shipping address line 1 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_address_line_2 \| \| --- \| \| \\| Display name \\| Shipping address line 2 \\| \\| --- \\| --- \\| \\| Description \\| Shipping address line 2 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping address line 2 \| \| Description \| Shipping address line 2 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_address_line_2 |
| \| Display name \| Shipping address line 2 \| \| --- \| --- \| \| Description \| Shipping address line 2 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping address line 2 |
| Description | Shipping address line 2 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_city \| \| --- \| \| \\| Display name \\| Shipping city \\| \\| --- \\| --- \\| \\| Description \\| Shipping city name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Shipping city \| \| Description \| Shipping city name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| shipping_city |
| \| Display name \| Shipping city \| \| --- \| --- \| \| Description \| Shipping city name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Shipping city |
| Description | Shipping city name |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| shipping_company_name \| \| --- \| \| \\| Display name \\| Shipping company name \\| \\| --- \\| --- \\| \\| Description \\| Shipping company name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping company name \| \| Description \| Shipping company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_company_name |
| \| Display name \| Shipping company name \| \| --- \| --- \| \| Description \| Shipping company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping company name |
| Description | Shipping company name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_country \| \| --- \| \| \\| Display name \\| Shipping country code \\| \\| --- \\| --- \\| \\| Description \\| Shipping country. Country code in ISO 3166-1 alpha-2 format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Shipping country code \| \| Description \| Shipping country. Country code in ISO 3166-1 alpha-2 format \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| shipping_country |
| \| Display name \| Shipping country code \| \| --- \| --- \| \| Description \| Shipping country. Country code in ISO 3166-1 alpha-2 format \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Display name | Shipping country code |
| Description | Shipping country. Country code in ISO 3166-1 alpha-2 format |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| shipping_first_name \| \| --- \| \| \\| Display name \\| Shipping first name \\| \\| --- \\| --- \\| \\| Description \\| Shipping first name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping first name \| \| Description \| Shipping first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_first_name |
| \| Display name \| Shipping first name \| \| --- \| --- \| \| Description \| Shipping first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping first name |
| Description | Shipping first name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_last_name \| \| --- \| \| \\| Display name \\| Shipping last name \\| \\| --- \\| --- \\| \\| Description \\| Shipping last name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping last name \| \| Description \| Shipping last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_last_name |
| \| Display name \| Shipping last name \| \| --- \| --- \| \| Description \| Shipping last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping last name |
| Description | Shipping last name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_phone \| \| --- \| \| \\| Display name \\| Shipping phone \\| \\| --- \\| --- \\| \\| Description \\| Shipping phone number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping phone \| \| Description \| Shipping phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| shipping_phone |
| \| Display name \| Shipping phone \| \| --- \| --- \| \| Description \| Shipping phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Shipping phone |
| Description | Shipping phone number |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| shipping_postcode \| \| --- \| \| \\| Display name \\| Shipping post code \\| \\| --- \\| --- \\| \\| Description \\| Shipping postal code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping post code \| \| Description \| Shipping postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_postcode |
| \| Display name \| Shipping post code \| \| --- \| --- \| \| Description \| Shipping postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping post code |
| Description | Shipping postal code |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_state \| \| --- \| \| \\| Display name \\| Shipping state \\| \\| --- \\| --- \\| \\| Description \\| Shipping state. ISO code or name of the state, province or district \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping state \| \| Description \| Shipping state. ISO code or name of the state, province or district \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_state |
| \| Display name \| Shipping state \| \| --- \| --- \| \| Description \| Shipping state. ISO code or name of the state, province or district \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping state |
| Description | Shipping state. ISO code or name of the state, province or district |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| transaction_id \| \| --- \| \| \\| Display name \\| Unique transaction ID \\| \\| --- \\| --- \\| \\| Description \\| Unique transaction ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Unique transaction ID \| \| Description \| Unique transaction ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| transaction_id |
| \| Display name \| Unique transaction ID \| \| --- \| --- \| \| Description \| Unique transaction ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Unique transaction ID |
| Description | Unique transaction ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### Table: ORDER_ITEMS

| \| account_name \| \| --- \| \| \\| Display name \\| Store URL \\| \\| --- \\| --- \\| \\| Description \\| The URL of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Store URL \| \| Description \| The URL of the store \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| --- |
| account_name |
| \| Display name \| Store URL \| \| --- \| --- \| \| Description \| The URL of the store \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Store URL |
| Description | The URL of the store |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| billing_address_line_1 \| \| --- \| \| \\| Display name \\| Billing address line 1 \\| \\| --- \\| --- \\| \\| Description \\| Address line 1 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing address line 1 \| \| Description \| Address line 1 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_address_line_1 |
| \| Display name \| Billing address line 1 \| \| --- \| --- \| \| Description \| Address line 1 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing address line 1 |
| Description | Address line 1 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_address_line_2 \| \| --- \| \| \\| Display name \\| Billing address line 2 \\| \\| --- \\| --- \\| \\| Description \\| Address line 2 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing address line 2 \| \| Description \| Address line 2 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_address_line_2 |
| \| Display name \| Billing address line 2 \| \| --- \| --- \| \| Description \| Address line 2 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing address line 2 |
| Description | Address line 2 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_city \| \| --- \| \| \\| Display name \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| City name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing city \| \| Description \| City name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| billing_city |
| \| Display name \| Billing city \| \| --- \| --- \| \| Description \| City name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Billing city |
| Description | City name |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| billing_company_name \| \| --- \| \| \\| Display name \\| Billing company name \\| \\| --- \\| --- \\| \\| Description \\| Company name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing company name \| \| Description \| Company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_company_name |
| \| Display name \| Billing company name \| \| --- \| --- \| \| Description \| Company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing company name |
| Description | Company name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_country \| \| --- \| \| \\| Display name \\| Billing country code \\| \\| --- \\| --- \\| \\| Description \\| Shipping country. Country code in ISO 3166-1 alpha-2 format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Billing country code \| \| Description \| Shipping country. Country code in ISO 3166-1 alpha-2 format \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| billing_country |
| \| Display name \| Billing country code \| \| --- \| --- \| \| Description \| Shipping country. Country code in ISO 3166-1 alpha-2 format \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Display name | Billing country code |
| Description | Shipping country. Country code in ISO 3166-1 alpha-2 format |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| billing_email \| \| --- \| \| \\| Display name \\| Billing email \\| \\| --- \\| --- \\| \\| Description \\| Email address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing email \| \| Description \| Email address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| billing_email |
| \| Display name \| Billing email \| \| --- \| --- \| \| Description \| Email address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Billing email |
| Description | Email address |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| billing_first_name \| \| --- \| \| \\| Display name \\| Billing first name \\| \\| --- \\| --- \\| \\| Description \\| Billing first name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing first name \| \| Description \| Billing first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_first_name |
| \| Display name \| Billing first name \| \| --- \| --- \| \| Description \| Billing first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing first name |
| Description | Billing first name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_last_name \| \| --- \| \| \\| Display name \\| Billing last name \\| \\| --- \\| --- \\| \\| Description \\| Billing last name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing last name \| \| Description \| Billing last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_last_name |
| \| Display name \| Billing last name \| \| --- \| --- \| \| Description \| Billing last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing last name |
| Description | Billing last name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_phone \| \| --- \| \| \\| Display name \\| Billing phone \\| \\| --- \\| --- \\| \\| Description \\| Phone number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing phone \| \| Description \| Phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| billing_phone |
| \| Display name \| Billing phone \| \| --- \| --- \| \| Description \| Phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Billing phone |
| Description | Phone number |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| billing_postcode \| \| --- \| \| \\| Display name \\| Billing post code \\| \\| --- \\| --- \\| \\| Description \\| Postal code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing post code \| \| Description \| Postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_postcode |
| \| Display name \| Billing post code \| \| --- \| --- \| \| Description \| Postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing post code |
| Description | Postal code |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_state \| \| --- \| \| \\| Display name \\| Billing state \\| \\| --- \\| --- \\| \\| Description \\| Shipping state. ISO code or name of the state, province or district \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Billing state \| \| Description \| Shipping state. ISO code or name of the state, province or district \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_state |
| \| Display name \| Billing state \| \| --- \| --- \| \| Description \| Shipping state. ISO code or name of the state, province or district \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Billing state |
| Description | Shipping state. ISO code or name of the state, province or district |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| created_via \| \| --- \| \| \\| Display name \\| Order created via \\| \\| --- \\| --- \\| \\| Description \\| Shows where the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order created via \| \| Description \| Shows where the order was created \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| created_via |
| \| Display name \| Order created via \| \| --- \| --- \| \| Description \| Shows where the order was created \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order created via |
| Description | Shows where the order was created |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_id \| \| --- \| \| \\| Display name \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| User ID who owns the order. 0 for guests. Default is 0 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer ID \| \| Description \| User ID who owns the order. 0 for guests. Default is 0 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_id |
| \| Display name \| Customer ID \| \| --- \| --- \| \| Description \| User ID who owns the order. 0 for guests. Default is 0 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer ID |
| Description | User ID who owns the order. 0 for guests. Default is 0 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_ip_address \| \| --- \| \| \\| Display name \\| Customer IP address \\| \\| --- \\| --- \\| \\| Description \\| Customer's IP address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer IP address \| \| Description \| Customer's IP address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_ip_address |
| \| Display name \| Customer IP address \| \| --- \| --- \| \| Description \| Customer's IP address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer IP address |
| Description | Customer's IP address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_note \| \| --- \| \| \\| Display name \\| Customer note \\| \\| --- \\| --- \\| \\| Description \\| Note left by customer during checkout \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer note \| \| Description \| Note left by customer during checkout \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_note |
| \| Display name \| Customer note \| \| --- \| --- \| \| Description \| Note left by customer during checkout \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer note |
| Description | Note left by customer during checkout |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_user_agent \| \| --- \| \| \\| Display name \\| Customer user agent \\| \\| --- \\| --- \\| \\| Description \\| User agent of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer user agent \| \| Description \| User agent of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_user_agent |
| \| Display name \| Customer user agent \| \| --- \| --- \| \| Description \| User agent of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer user agent |
| Description | User agent of the customer |
| 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) |
| \| line_item_discount \| \| --- \| \| \\| Display name \\| Item discount \\| \\| --- \\| --- \\| \\| Description \\| Discount applied for the line-item. (Item discount = Item subtotal - Item total) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Item discount \| \| Description \| Discount applied for the line-item. (Item discount = Item subtotal - Item total) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| line_item_discount |
| \| Display name \| Item discount \| \| --- \| --- \| \| Description \| Discount applied for the line-item. (Item discount = Item subtotal - Item total) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Item discount |
| Description | Discount applied for the line-item. (Item discount = Item subtotal - Item total) |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| line_item_id \| \| --- \| \| \\| Display name \\| Line item ID \\| \\| --- \\| --- \\| \\| Description \\| Item ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Line item ID \| \| Description \| Item ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_id |
| \| Display name \| Line item ID \| \| --- \| --- \| \| Description \| Item ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Line item ID |
| Description | Item ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_image_id \| \| --- \| \| \\| Display name \\| Line item image ID \\| \\| --- \\| --- \\| \\| Description \\| Line item image ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Line item image ID \| \| Description \| Line item image ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_image_id |
| \| Display name \| Line item image ID \| \| --- \| --- \| \| Description \| Line item image ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Line item image ID |
| Description | Line item image ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_image_url \| \| --- \| \| \\| Display name \\| Line item image URL \\| \\| --- \\| --- \\| \\| Description \\| Line item image URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Line item image URL \| \| Description \| Line item image URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| line_item_image_url |
| \| Display name \| Line item image URL \| \| --- \| --- \| \| Description \| Line item image URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Line item image URL |
| Description | Line item image URL |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| line_item_name \| \| --- \| \| \\| Display name \\| Product name \\| \\| --- \\| --- \\| \\| Description \\| Product name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product name \| \| Description \| Product name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_name |
| \| Display name \| Product name \| \| --- \| --- \| \| Description \| Product name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product name |
| Description | Product name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_parent_name \| \| --- \| \| \\| Display name \\| Product parent name \\| \\| --- \\| --- \\| \\| Description \\| Product parent name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product parent name \| \| Description \| Product parent name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_parent_name |
| \| Display name \| Product parent name \| \| --- \| --- \| \| Description \| Product parent name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product parent name |
| Description | Product parent name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_price \| \| --- \| \| \\| Display name \\| Item price \\| \\| --- \\| --- \\| \\| Description \\| Cost per line item unit \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Item price \| \| Description \| Cost per line item unit \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| line_item_price |
| \| Display name \| Item price \| \| --- \| --- \| \| Description \| Cost per line item unit \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Item price |
| Description | Cost per line item unit |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| line_item_product_id \| \| --- \| \| \\| Display name \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| Product ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product ID \| \| Description \| Product ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_product_id |
| \| Display name \| Product ID \| \| --- \| --- \| \| Description \| Product ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product ID |
| Description | Product ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_sku \| \| --- \| \| \\| Display name \\| Line item SKU \\| \\| --- \\| --- \\| \\| Description \\| Product SKU \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Line item SKU \| \| Description \| Product SKU \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_sku |
| \| Display name \| Line item SKU \| \| --- \| --- \| \| Description \| Product SKU \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Line item SKU |
| Description | Product SKU |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_subtotal \| \| --- \| \| \\| Display name \\| Item subtotal \\| \\| --- \\| --- \\| \\| Description \\| Line item subtotal (before discounts) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Item subtotal \| \| Description \| Line item subtotal (before discounts) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| line_item_subtotal |
| \| Display name \| Item subtotal \| \| --- \| --- \| \| Description \| Line item subtotal (before discounts) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Item subtotal |
| Description | Line item subtotal (before discounts) |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| line_item_tax_class \| \| --- \| \| \\| Display name \\| Line item tax class \\| \\| --- \\| --- \\| \\| Description \\| Slug of the tax class of product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Line item tax class \| \| Description \| Slug of the tax class of product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_tax_class |
| \| Display name \| Line item tax class \| \| --- \| --- \| \| Description \| Slug of the tax class of product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Line item tax class |
| Description | Slug of the tax class of product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_total \| \| --- \| \| \\| Display name \\| Item total \\| \\| --- \\| --- \\| \\| Description \\| Line total (after discounts) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Item total \| \| Description \| Line total (after discounts) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| line_item_total |
| \| Display name \| Item total \| \| --- \| --- \| \| Description \| Line total (after discounts) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Item total |
| Description | Line total (after discounts) |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| line_item_total_tax \| \| --- \| \| \\| Display name \\| Item tax \\| \\| --- \\| --- \\| \\| Description \\| Tax for the line item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Item tax \| \| Description \| Tax for the line item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| line_item_total_tax |
| \| Display name \| Item tax \| \| --- \| --- \| \| Description \| Tax for the line item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Item tax |
| Description | Tax for the line item |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| line_item_variation_id \| \| --- \| \| \\| Display name \\| Product variation ID \\| \\| --- \\| --- \\| \\| Description \\| Variation ID, if applicable \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product variation ID \| \| Description \| Variation ID, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_variation_id |
| \| Display name \| Product variation ID \| \| --- \| --- \| \| Description \| Variation ID, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product variation ID |
| Description | Variation ID, if applicable |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| needs_payment \| \| --- \| \| \\| Display name \\| Order is paid \\| \\| --- \\| --- \\| \\| Description \\| Define if the order is paid. It will set the status to processing and reduce stock items \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Order is paid \| \| Description \| Define if the order is paid. It will set the status to processing and reduce stock items \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| needs_payment |
| \| Display name \| Order is paid \| \| --- \| --- \| \| Description \| Define if the order is paid. It will set the status to processing and reduce stock items \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Order is paid |
| Description | Define if the order is paid. It will set the status to processing and reduce stock items |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_completed_date \| \| --- \| \| \\| Display name \\| Order completed date \\| \\| --- \\| --- \\| \\| Description \\| The date the order was completed, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order completed date \| \| Description \| The date the order was completed, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_completed_date |
| \| Display name \| Order completed date \| \| --- \| --- \| \| Description \| The date the order was completed, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order completed date |
| Description | The date the order was completed, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_completed_date_gmt \| \| --- \| \| \\| Display name \\| Order completed date (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The date the order was completed, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order completed date (GMT) \| \| Description \| The date the order was completed, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_completed_date_gmt |
| \| Display name \| Order completed date (GMT) \| \| --- \| --- \| \| Description \| The date the order was completed, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order completed date (GMT) |
| Description | The date the order was completed, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_completed_datetime \| \| --- \| \| \\| Display name \\| Order completed datetime \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was completed, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order completed datetime \| \| Description \| The datetime the order was completed, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_completed_datetime |
| \| Display name \| Order completed datetime \| \| --- \| --- \| \| Description \| The datetime the order was completed, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order completed datetime |
| Description | The datetime the order was completed, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_completed_datetime_gmt \| \| --- \| \| \\| Display name \\| Order completed datetime (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was completed, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order completed datetime (GMT) \| \| Description \| The datetime the order was completed, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_completed_datetime_gmt |
| \| Display name \| Order completed datetime (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was completed, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order completed datetime (GMT) |
| Description | The datetime the order was completed, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_created_date \| \| --- \| \| \\| Display name \\| Order created date \\| \\| --- \\| --- \\| \\| Description \\| The date the order was created, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order created date \| \| Description \| The date the order was created, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_created_date |
| \| Display name \| Order created date \| \| --- \| --- \| \| Description \| The date the order was created, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order created date |
| Description | The date the order was created, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_created_datetime \| \| --- \| \| \\| Display name \\| Order created datetime \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was created, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order created datetime \| \| Description \| The datetime the order was created, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_created_datetime |
| \| Display name \| Order created datetime \| \| --- \| --- \| \| Description \| The datetime the order was created, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order created datetime |
| Description | The datetime the order was created, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_created_datetime_gmt \| \| --- \| \| \\| Display name \\| Order created datetime (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was created, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order created datetime (GMT) \| \| Description \| The datetime the order was created, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_created_datetime_gmt |
| \| Display name \| Order created datetime (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was created, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order created datetime (GMT) |
| Description | The datetime the order was created, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_created_gmt \| \| --- \| \| \\| Display name \\| Order created date (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was created, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order created date (GMT) \| \| Description \| The datetime the order was created, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_created_gmt |
| \| Display name \| Order created date (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was created, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order created date (GMT) |
| Description | The datetime the order was created, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_currency \| \| --- \| \| \\| Display name \\| Order currency \\| \\| --- \\| --- \\| \\| Description \\| Currency the order was created with, in ISO format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order currency \| \| Description \| Currency the order was created with, in ISO format \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| order_currency |
| \| Display name \| Order currency \| \| --- \| --- \| \| Description \| Currency the order was created with, in ISO format \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Display name | Order currency |
| Description | Currency the order was created with, in ISO format |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| 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_key \| \| --- \| \| \\| Display name \\| Order key \\| \\| --- \\| --- \\| \\| Description \\| Key of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order key \| \| Description \| Key of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_key |
| \| Display name \| Order key \| \| --- \| --- \| \| Description \| Key of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order key |
| Description | Key of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_modified_date \| \| --- \| \| \\| Display name \\| Order modified date \\| \\| --- \\| --- \\| \\| Description \\| The date the order was last modified, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order modified date \| \| Description \| The date the order was last modified, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_modified_date |
| \| Display name \| Order modified date \| \| --- \| --- \| \| Description \| The date the order was last modified, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order modified date |
| Description | The date the order was last modified, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_modified_datetime \| \| --- \| \| \\| Display name \\| Order modified datetime \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was last modified, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order modified datetime \| \| Description \| The datetime the order was last modified, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_modified_datetime |
| \| Display name \| Order modified datetime \| \| --- \| --- \| \| Description \| The datetime the order was last modified, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order modified datetime |
| Description | The datetime the order was last modified, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_modified_datetime_gmt \| \| --- \| \| \\| Display name \\| Order modified datetime (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was last modified, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order modified datetime (GMT) \| \| Description \| The datetime the order was last modified, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_modified_datetime_gmt |
| \| Display name \| Order modified datetime (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was last modified, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order modified datetime (GMT) |
| Description | The datetime the order was last modified, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_modified_gmt \| \| --- \| \| \\| Display name \\| Order modified date (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was last modified, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order modified date (GMT) \| \| Description \| The datetime the order was last modified, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_modified_gmt |
| \| Display name \| Order modified date (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was last modified, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order modified date (GMT) |
| Description | The datetime the order was last modified, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_number \| \| --- \| \| \\| Display name \\| Order number \\| \\| --- \\| --- \\| \\| Description \\| Number of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order number \| \| Description \| Number of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_number |
| \| Display name \| Order number \| \| --- \| --- \| \| Description \| Number of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order number |
| Description | Number of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_paid_date \| \| --- \| \| \\| Display name \\| Order paid date \\| \\| --- \\| --- \\| \\| Description \\| The date the order was paid, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order paid date \| \| Description \| The date the order was paid, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_paid_date |
| \| Display name \| Order paid date \| \| --- \| --- \| \| Description \| The date the order was paid, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order paid date |
| Description | The date the order was paid, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_paid_date_gmt \| \| --- \| \| \\| Display name \\| Order paid date (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The date the order was paid, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Order paid date (GMT) \| \| Description \| The date the order was paid, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_paid_date_gmt |
| \| Display name \| Order paid date (GMT) \| \| --- \| --- \| \| Description \| The date the order was paid, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Order paid date (GMT) |
| Description | The date the order was paid, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_paid_datetime \| \| --- \| \| \\| Display name \\| Order paid datetime \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was paid, in the site's timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order paid datetime \| \| Description \| The datetime the order was paid, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_paid_datetime |
| \| Display name \| Order paid datetime \| \| --- \| --- \| \| Description \| The datetime the order was paid, in the site's timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order paid datetime |
| Description | The datetime the order was paid, in the site's timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_paid_datetime_gmt \| \| --- \| \| \\| Display name \\| Order paid datetime (GMT) \\| \\| --- \\| --- \\| \\| Description \\| The datetime the order was paid, in the GMT timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order paid datetime (GMT) \| \| Description \| The datetime the order was paid, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_paid_datetime_gmt |
| \| Display name \| Order paid datetime (GMT) \| \| --- \| --- \| \| Description \| The datetime the order was paid, in the GMT timezone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order paid datetime (GMT) |
| Description | The datetime the order was paid, in the GMT timezone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_status \| \| --- \| \| \\| Display name \\| Order status \\| \\| --- \\| --- \\| \\| Description \\| Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order status \| \| Description \| Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_status |
| \| Display name \| Order status \| \| --- \| --- \| \| Description \| Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order status |
| Description | Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| parent_id \| \| --- \| \| \\| Display name \\| Order parent ID \\| \\| --- \\| --- \\| \\| Description \\| Parent ID of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order parent ID \| \| Description \| Parent ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| parent_id |
| \| Display name \| Order parent ID \| \| --- \| --- \| \| Description \| Parent ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order parent ID |
| Description | Parent ID of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_method \| \| --- \| \| \\| Display name \\| Payment method ID \\| \\| --- \\| --- \\| \\| Description \\| Payment method ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment method ID \| \| Description \| Payment method ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_method |
| \| Display name \| Payment method ID \| \| --- \| --- \| \| Description \| Payment method ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment method ID |
| Description | Payment method ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_method_title \| \| --- \| \| \\| Display name \\| Payment method title \\| \\| --- \\| --- \\| \\| Description \\| Payment method title \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Payment method title \| \| Description \| Payment method title \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_method_title |
| \| Display name \| Payment method title \| \| --- \| --- \| \| Description \| Payment method title \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Payment method title |
| Description | Payment method title |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| prices_include_tax \| \| --- \| \| \\| Display name \\| Prices include tax \\| \\| --- \\| --- \\| \\| Description \\| True the prices included tax during checkout \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Prices include tax \| \| Description \| True the prices included tax during checkout \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| prices_include_tax |
| \| Display name \| Prices include tax \| \| --- \| --- \| \| Description \| True the prices included tax during checkout \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Prices include tax |
| Description | True the prices included tax during checkout |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| quantity \| \| --- \| \| \\| Display name \\| Item quantity \\| \\| --- \\| --- \\| \\| Description \\| Number of line item units \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Item quantity \| \| Description \| Number of line item units \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| quantity |
| \| Display name \| Item quantity \| \| --- \| --- \| \| Description \| Number of line item units \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Item quantity |
| Description | Number of line item units |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| shipping_address_line_1 \| \| --- \| \| \\| Display name \\| Shipping address line 1 \\| \\| --- \\| --- \\| \\| Description \\| Shipping address line 1 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping address line 1 \| \| Description \| Shipping address line 1 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_address_line_1 |
| \| Display name \| Shipping address line 1 \| \| --- \| --- \| \| Description \| Shipping address line 1 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping address line 1 |
| Description | Shipping address line 1 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_address_line_2 \| \| --- \| \| \\| Display name \\| Shipping address line 2 \\| \\| --- \\| --- \\| \\| Description \\| Shipping address line 2 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping address line 2 \| \| Description \| Shipping address line 2 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_address_line_2 |
| \| Display name \| Shipping address line 2 \| \| --- \| --- \| \| Description \| Shipping address line 2 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping address line 2 |
| Description | Shipping address line 2 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_city \| \| --- \| \| \\| Display name \\| Shipping city \\| \\| --- \\| --- \\| \\| Description \\| Shipping city name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Shipping city \| \| Description \| Shipping city name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| shipping_city |
| \| Display name \| Shipping city \| \| --- \| --- \| \| Description \| Shipping city name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | Shipping city |
| Description | Shipping city name |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| shipping_company_name \| \| --- \| \| \\| Display name \\| Shipping company name \\| \\| --- \\| --- \\| \\| Description \\| Shipping company name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping company name \| \| Description \| Shipping company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_company_name |
| \| Display name \| Shipping company name \| \| --- \| --- \| \| Description \| Shipping company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping company name |
| Description | Shipping company name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_country \| \| --- \| \| \\| Display name \\| Shipping country code \\| \\| --- \\| --- \\| \\| Description \\| Shipping country. Country code in ISO 3166-1 alpha-2 format \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Shipping country code \| \| Description \| Shipping country. Country code in ISO 3166-1 alpha-2 format \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| shipping_country |
| \| Display name \| Shipping country code \| \| --- \| --- \| \| Description \| Shipping country. Country code in ISO 3166-1 alpha-2 format \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Display name | Shipping country code |
| Description | Shipping country. Country code in ISO 3166-1 alpha-2 format |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| shipping_first_name \| \| --- \| \| \\| Display name \\| Shipping first name \\| \\| --- \\| --- \\| \\| Description \\| Shipping first name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping first name \| \| Description \| Shipping first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_first_name |
| \| Display name \| Shipping first name \| \| --- \| --- \| \| Description \| Shipping first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping first name |
| Description | Shipping first name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_last_name \| \| --- \| \| \\| Display name \\| Shipping last name \\| \\| --- \\| --- \\| \\| Description \\| Shipping last name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping last name \| \| Description \| Shipping last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_last_name |
| \| Display name \| Shipping last name \| \| --- \| --- \| \| Description \| Shipping last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping last name |
| Description | Shipping last name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_phone \| \| --- \| \| \\| Display name \\| Shipping phone \\| \\| --- \\| --- \\| \\| Description \\| Shipping phone number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping phone \| \| Description \| Shipping phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| shipping_phone |
| \| Display name \| Shipping phone \| \| --- \| --- \| \| Description \| Shipping phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Shipping phone |
| Description | Shipping phone number |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| shipping_postcode \| \| --- \| \| \\| Display name \\| Shipping post code \\| \\| --- \\| --- \\| \\| Description \\| Shipping postal code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping post code \| \| Description \| Shipping postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_postcode |
| \| Display name \| Shipping post code \| \| --- \| --- \| \| Description \| Shipping postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping post code |
| Description | Shipping postal code |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_state \| \| --- \| \| \\| Display name \\| Shipping state \\| \\| --- \\| --- \\| \\| Description \\| Shipping state. ISO code or name of the state, province or district \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping state \| \| Description \| Shipping state. ISO code or name of the state, province or district \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_state |
| \| Display name \| Shipping state \| \| --- \| --- \| \| Description \| Shipping state. ISO code or name of the state, province or district \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping state |
| Description | Shipping state. ISO code or name of the state, province or district |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| transaction_id \| \| --- \| \| \\| Display name \\| Unique transaction ID \\| \\| --- \\| --- \\| \\| Description \\| Unique transaction ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Unique transaction ID \| \| Description \| Unique transaction ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| transaction_id |
| \| Display name \| Unique transaction ID \| \| --- \| --- \| \| Description \| Unique transaction ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Unique transaction ID |
| Description | Unique transaction ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |