---
title: "WooCommerce metrics and dimensions"
slug: "woocommerce-fields"
description: "Explore the complete list of WooCommerce metrics and dimensions available through Supermetrics. Find every data field you need to build your ideal marketing reports."
updated: 2026-03-05T14:11:30Z
published: 2026-03-05T14:11:30Z
---

> ## 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 metrics and dimensions

> Supermetrics brings all your WooCommerce data into [Google Sheets](https://workspace.google.com/marketplace/app/supermetrics/523876908005), [Looker Studio](https://supermetrics.com/products/looker-studio), [Power BI](https://supermetrics.com/products/power-bi), [Excel](https://supermetrics.com/products/excel), [BigQuery](https://supermetrics.com/products/bigquery), [Snowflake](https://supermetrics.com/products/snowflake), [Redshift](https://supermetrics.com/products/amazon-redshift), [Azure](https://supermetrics.com/products/azure-synapse)

28 metrics93 dimensionsSearch fields<input type="text" id="field-search" placeholder="Search by field name, label, or description…" aria-label="Search fields by name, label, or description" autocomplete="off">

### BILLING

| \| billing_first_name** \| \| --- \| \| \\| Field label \\| Billing first name \\| \\| --- \\| --- \\| \\| Description \\| Billing first name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing first name \| \| Description \| Billing first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| billing_first_name** |
| \| Field label \| Billing first name \| \| --- \| --- \| \| Description \| Billing first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing first name |
| Description | Billing first name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_last_name** \| \| --- \| \| \\| Field label \\| Billing last name \\| \\| --- \\| --- \\| \\| Description \\| Billing last name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing last name \| \| Description \| Billing last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_last_name** |
| \| Field label \| Billing last name \| \| --- \| --- \| \| Description \| Billing last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing last name |
| Description | Billing last name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_company_name** \| \| --- \| \| \\| Field label \\| Billing company name \\| \\| --- \\| --- \\| \\| Description \\| Company name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing company name \| \| Description \| Company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_company_name** |
| \| Field label \| Billing company name \| \| --- \| --- \| \| Description \| Company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing company name |
| Description | Company name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_address_line_1** \| \| --- \| \| \\| Field label \\| Billing address line 1 \\| \\| --- \\| --- \\| \\| Description \\| Address line 1 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** |
| \| Field label \| Billing address line 1 \| \| --- \| --- \| \| Description \| Address line 1 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | 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** \| \| --- \| \| \\| Field label \\| Billing address line 2 \\| \\| --- \\| --- \\| \\| Description \\| Address line 2 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** |
| \| Field label \| Billing address line 2 \| \| --- \| --- \| \| Description \| Address line 2 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing address line 2 |
| Description | Address line 2 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_city** \| \| --- \| \| \\| Field label \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| City name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing city \| \| Description \| City name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| billing_city** |
| \| Field label \| Billing city \| \| --- \| --- \| \| Description \| City name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | Billing city |
| Description | City name |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| billing_state** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_postcode** \| \| --- \| \| \\| Field label \\| Billing post code \\| \\| --- \\| --- \\| \\| Description \\| Postal code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing post code \| \| Description \| Postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_postcode** |
| \| Field label \| Billing post code \| \| --- \| --- \| \| Description \| Postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing post code |
| Description | Postal code |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_country** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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** \| \| --- \| \| \\| Field label \\| Billing email \\| \\| --- \\| --- \\| \\| Description \\| Email address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing email \| \| Description \| Email address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| billing_email** |
| \| Field label \| Billing email \| \| --- \| --- \| \| Description \| Email address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Field label | Billing email |
| Description | Email address |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| billing_phone** \| \| --- \| \| \\| Field label \\| Billing phone \\| \\| --- \\| --- \\| \\| Description \\| Phone number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing phone \| \| Description \| Phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| billing_phone** |
| \| Field label \| Billing phone \| \| --- \| --- \| \| Description \| Phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Field label | Billing phone |
| Description | Phone number |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |

### CUSTOMER

| \| customer_id** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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** \| \| --- \| \| \\| Field label \\| Customer IP address \\| \\| --- \\| --- \\| \\| Description \\| Customer's IP address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer IP address \| \| Description \| Customer's IP address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_ip_address** |
| \| Field label \| Customer IP address \| \| --- \| --- \| \| Description \| Customer's IP address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer IP address |
| Description | Customer's IP address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_user_agent** \| \| --- \| \| \\| Field label \\| Customer user agent \\| \\| --- \\| --- \\| \\| Description \\| User agent of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** |
| \| Field label \| Customer user agent \| \| --- \| --- \| \| Description \| User agent of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer user agent |
| Description | User agent of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_note** \| \| --- \| \| \\| Field label \\| Customer note \\| \\| --- \\| --- \\| \\| Description \\| Note left by customer during checkout \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer note \| \| Description \| Note left by customer during checkout \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_note** |
| \| Field label \| Customer note \| \| --- \| --- \| \| Description \| Note left by customer during checkout \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer note |
| Description | Note left by customer during checkout |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### DATASOURCE

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

### LINE ITEM

| \| line_item_parent_name** \| \| --- \| \| \\| Field label \\| Product parent name \\| \\| --- \\| --- \\| \\| Description \\| Product parent name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product parent name \| \| Description \| Product parent name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| line_item_parent_name** |
| \| Field label \| Product parent name \| \| --- \| --- \| \| Description \| Product parent name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product parent name |
| Description | Product parent name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_name** \| \| --- \| \| \\| Field label \\| Product name \\| \\| --- \\| --- \\| \\| Description \\| Product name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product name \| \| Description \| Product name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_name** |
| \| Field label \| Product name \| \| --- \| --- \| \| Description \| Product name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product name |
| Description | Product name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_product_id** \| \| --- \| \| \\| Field label \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| Product ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product ID \| \| Description \| Product ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_product_id** |
| \| Field label \| Product ID \| \| --- \| --- \| \| Description \| Product ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product ID |
| Description | Product ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_variation_id** \| \| --- \| \| \\| Field label \\| Product variation ID \\| \\| --- \\| --- \\| \\| Description \\| Variation ID, if applicable \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** |
| \| Field label \| Product variation ID \| \| --- \| --- \| \| Description \| Variation ID, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product variation ID |
| Description | Variation ID, if applicable |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_id** \| \| --- \| \| \\| Field label \\| Line item ID \\| \\| --- \\| --- \\| \\| Description \\| Item ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Line item ID \| \| Description \| Item ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_id** |
| \| Field label \| Line item ID \| \| --- \| --- \| \| Description \| Item ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Line item ID |
| Description | Item ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_tax_class** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_sku** \| \| --- \| \| \\| Field label \\| Line item SKU \\| \\| --- \\| --- \\| \\| Description \\| Product SKU \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Line item SKU \| \| Description \| Product SKU \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_sku** |
| \| Field label \| Line item SKU \| \| --- \| --- \| \| Description \| Product SKU \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Line item SKU |
| Description | Product SKU |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_image_id** \| \| --- \| \| \\| Field label \\| Line item image ID \\| \\| --- \\| --- \\| \\| Description \\| Line item image ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** |
| \| Field label \| Line item image ID \| \| --- \| --- \| \| Description \| Line item image ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | 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** \| \| --- \| \| \\| Field label \\| Line item image URL \\| \\| --- \\| --- \\| \\| Description \\| Line item image URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** |
| \| Field label \| Line item image URL \| \| --- \| --- \| \| Description \| Line item image URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Field label | Line item image URL |
| Description | Line item image URL |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| line_item_price** \| \| --- \| \| \\| Field label \\| Item price \\| \\| --- \\| --- \\| \\| Description \\| Cost per line item unit \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \\| Aggregation \\| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \\| \| \| Field label \| Item price \| \| Description \| Cost per line item unit \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| \| Aggregation \| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \| |
| line_item_price** |
| \| Field label \| Item price \| \| --- \| --- \| \| Description \| Cost per line item unit \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| \| Aggregation \| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \| |
| Field label | Item price |
| Description | Cost per line item unit |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| Aggregation | [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) |
| \| quantity** \| \| --- \| \| \\| Field label \\| Item quantity \\| \\| --- \\| --- \\| \\| Description \\| Number of line item units \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Item quantity \| \| Description \| Number of line item units \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| quantity** |
| \| Field label \| Item quantity \| \| --- \| --- \| \| Description \| Number of line item units \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Item quantity |
| Description | Number of line item units |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| line_item_subtotal** \| \| --- \| \| \\| Field label \\| Item subtotal \\| \\| --- \\| --- \\| \\| Description \\| Line item subtotal (before discounts) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item subtotal \| \| Description \| Line item subtotal (before discounts) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| line_item_subtotal** |
| \| Field label \| Item subtotal \| \| --- \| --- \| \| Description \| Line item subtotal (before discounts) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item subtotal |
| Description | Line item subtotal (before discounts) |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| line_item_discount** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_total** \| \| --- \| \| \\| Field label \\| Item total \\| \\| --- \\| --- \\| \\| Description \\| Line total (after discounts) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item total \| \| Description \| Line total (after discounts) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| line_item_total** |
| \| Field label \| Item total \| \| --- \| --- \| \| Description \| Line total (after discounts) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item total |
| Description | Line total (after discounts) |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| line_item_total_tax** \| \| --- \| \| \\| Field label \\| Item tax \\| \\| --- \\| --- \\| \\| Description \\| Tax for the line item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| 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** |
| \| Field label \| Item tax \| \| --- \| --- \| \| Description \| Tax for the line item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item tax |
| Description | Tax for the line item |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### ORDER

| \| order_number** \| \| --- \| \| \\| Field label \\| Order number \\| \\| --- \\| --- \\| \\| Description \\| Number of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order number \| \| Description \| Number of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| order_number** |
| \| Field label \| Order number \| \| --- \| --- \| \| Description \| Number of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order number |
| Description | Number of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_id** \| \| --- \| \| \\| Field label \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order ID \| \| Description \| Unique identifier for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_id** |
| \| Field label \| Order ID \| \| --- \| --- \| \| Description \| Unique identifier for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order ID |
| Description | Unique identifier for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| parent_id** \| \| --- \| \| \\| Field label \\| Order parent ID \\| \\| --- \\| --- \\| \\| Description \\| Parent ID of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order parent ID \| \| Description \| Parent ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| parent_id** |
| \| Field label \| Order parent ID \| \| --- \| --- \| \| Description \| Parent ID of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order parent ID |
| Description | Parent ID of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_key** \| \| --- \| \| \\| Field label \\| Order key \\| \\| --- \\| --- \\| \\| Description \\| Key of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order key \| \| Description \| Key of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_key** |
| \| Field label \| Order key \| \| --- \| --- \| \| Description \| Key of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order key |
| Description | Key of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_status** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_currency** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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) |
| \| created_via** \| \| --- \| \| \\| Field label \\| Order created via \\| \\| --- \\| --- \\| \\| Description \\| Shows where the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** |
| \| Field label \| Order created via \| \| --- \| --- \| \| Description \| Shows where the order was created \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order created via |
| Description | Shows where the order was created |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_count** \| \| --- \| \| \\| Field label \\| Orders \\| \\| --- \\| --- \\| \\| Description \\| The number of new orders placed for a selected date range \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Orders \| \| Description \| The number of new orders placed for a selected date range \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| order_count** |
| \| Field label \| Orders \| \| --- \| --- \| \| Description \| The number of new orders placed for a selected date range \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Orders |
| Description | The number of new orders placed for a selected date range |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| avg_order_value** \| \| --- \| \| \\| Field label \\| Average order value \\| \\| --- \\| --- \\| \\| Description \\| The average value of orders placed for a selected date range. (Average order value = Net Sales / Orders) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Average order value \| \| Description \| The average value of orders placed for a selected date range. (Average order value = Net Sales / Orders) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| avg_order_value** |
| \| Field label \| Average order value \| \| --- \| --- \| \| Description \| The average value of orders placed for a selected date range. (Average order value = Net Sales / Orders) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Average order value |
| Description | The average value of orders placed for a selected date range. (Average order value = Net Sales / Orders) |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| num_items_sold** \| \| --- \| \| \\| Field label \\| Items sold \\| \\| --- \\| --- \\| \\| Description \\| The discrete number of items sold \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Items sold \| \| Description \| The discrete number of items sold \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| num_items_sold** |
| \| Field label \| Items sold \| \| --- \| --- \| \| Description \| The discrete number of items sold \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Items sold |
| Description | The discrete number of items sold |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| avg_items_per_order** \| \| --- \| \| \\| Field label \\| Average items per order \\| \\| --- \\| --- \\| \\| Description \\| The average number of items placed for a selected date range. (Average items per order = Items sold / Orders) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Average items per order \| \| Description \| The average number of items placed for a selected date range. (Average items per order = Items sold / Orders) \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| avg_items_per_order** |
| \| Field label \| Average items per order \| \| --- \| --- \| \| Description \| The average number of items placed for a selected date range. (Average items per order = Items sold / Orders) \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| Field label | Average items per order |
| Description | The average number of items placed for a selected date range. (Average items per order = Items sold / Orders) |
| Field type | metric |
| Data type | [float.number.value](/apidocs/field-data-types#number) |
| \| total_customers** \| \| --- \| \| \\| Field label \\| Customers \\| \\| --- \\| --- \\| \\| Description \\| The unique count of customers in the period \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \\| Aggregation \\| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \\| \| \| Field label \| Customers \| \| Description \| The unique count of customers in the period \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| \| Aggregation \| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \| |
| total_customers** |
| \| Field label \| Customers \| \| --- \| --- \| \| Description \| The unique count of customers in the period \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| \| Aggregation \| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \| |
| Field label | Customers |
| Description | The unique count of customers in the period |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| Aggregation | [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) |
| \| order_total** \| \| --- \| \| \\| Field label \\| Order total \\| \\| --- \\| --- \\| \\| Description \\| Grand total \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order total \| \| Description \| Grand total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_total** |
| \| Field label \| Order total \| \| --- \| --- \| \| Description \| Grand total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order total |
| Description | Grand total |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_shipping_total** \| \| --- \| \| \\| Field label \\| Order shipping total \\| \\| --- \\| --- \\| \\| Description \\| Total shipping amount for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| 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** |
| \| Field label \| Order shipping total \| \| --- \| --- \| \| Description \| Total shipping amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order shipping total |
| Description | Total shipping amount for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_discount_total** \| \| --- \| \| \\| Field label \\| Order discount total \\| \\| --- \\| --- \\| \\| Description \\| Total discount amount for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| 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** |
| \| Field label \| Order discount total \| \| --- \| --- \| \| Description \| Total discount amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order discount total |
| Description | Total discount amount for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_shipping_tax** \| \| --- \| \| \\| Field label \\| Order shipping tax \\| \\| --- \\| --- \\| \\| Description \\| Total shipping tax amount for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| 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** |
| \| Field label \| Order shipping tax \| \| --- \| --- \| \| Description \| Total shipping tax amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | 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_discount_tax** \| \| --- \| \| \\| Field label \\| Order discount tax \\| \\| --- \\| --- \\| \\| Description \\| Total discount tax amount for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| 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** |
| \| Field label \| Order discount tax \| \| --- \| --- \| \| Description \| Total discount tax amount for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | 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_cart_tax** \| \| --- \| \| \\| Field label \\| Order cart tax \\| \\| --- \\| --- \\| \\| Description \\| Sum of line item taxes only \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| 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** |
| \| Field label \| Order cart tax \| \| --- \| --- \| \| Description \| Sum of line item taxes only \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order cart tax |
| Description | Sum of line item taxes only |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_total_tax** \| \| --- \| \| \\| Field label \\| Order total tax \\| \\| --- \\| --- \\| \\| Description \\| Sum of all taxes \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order total tax \| \| Description \| Sum of all taxes \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_total_tax** |
| \| Field label \| Order total tax \| \| --- \| --- \| \| Description \| Sum of all taxes \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Order total tax |
| Description | Sum of all taxes |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### ORDER TIMESTAMP

| \| order_created_date** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_modified_date** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_paid_date** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_datetime** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_completed_date** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_datetime** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_created_gmt** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_datetime_gmt** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_modified_gmt** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_datetime_gmt** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_paid_date_gmt** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_gmt** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_completed_date_gmt** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_gmt** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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) |

### PAYMENT

| \| needs_payment** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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) |
| \| payment_method** \| \| --- \| \| \\| Field label \\| Payment method ID \\| \\| --- \\| --- \\| \\| Description \\| Payment method ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Payment method ID \| \| Description \| Payment method ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_method** |
| \| Field label \| Payment method ID \| \| --- \| --- \| \| Description \| Payment method ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Payment method ID |
| Description | Payment method ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| payment_method_title** \| \| --- \| \| \\| Field label \\| Payment method title \\| \\| --- \\| --- \\| \\| Description \\| Payment method title \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Payment method title \| \| Description \| Payment method title \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| payment_method_title** |
| \| Field label \| Payment method title \| \| --- \| --- \| \| Description \| Payment method title \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Payment method title |
| Description | Payment method title |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| transaction_id** \| \| --- \| \| \\| Field label \\| Unique transaction ID \\| \\| --- \\| --- \\| \\| Description \\| Unique transaction ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Unique transaction ID \| \| Description \| Unique transaction ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| transaction_id** |
| \| Field label \| Unique transaction ID \| \| --- \| --- \| \| Description \| Unique transaction ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Unique transaction ID |
| Description | Unique transaction ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| prices_include_tax** \| \| --- \| \| \\| Field label \\| Prices include tax \\| \\| --- \\| --- \\| \\| Description \\| True the prices included tax during checkout \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| 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** |
| \| Field label \| Prices include tax \| \| --- \| --- \| \| Description \| True the prices included tax during checkout \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Prices include tax |
| Description | True the prices included tax during checkout |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |

### PRODUCT

| \| product_id** \| \| --- \| \| \\| Field label \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product ID \| \| Description \| ID of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| product_id** |
| \| Field label \| Product ID \| \| --- \| --- \| \| Description \| ID of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product ID |
| Description | ID of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_title** \| \| --- \| \| \\| Field label \\| Product title \\| \\| --- \\| --- \\| \\| Description \\| Name of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product title \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_title** |
| \| Field label \| Product title \| \| --- \| --- \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product title |
| Description | Name of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| sku** \| \| --- \| \| \\| Field label \\| SKU \\| \\| --- \\| --- \\| \\| Description \\| Stock keeping unit \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| SKU \| \| Description \| Stock keeping unit \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| sku** |
| \| Field label \| SKU \| \| --- \| --- \| \| Description \| Stock keeping unit \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | SKU |
| Description | Stock keeping unit |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### QUERY

| \| system_metadata.query_date_range_start** \| \| --- \| \| \\| Field label \\| Start date \\| \\| --- \\| --- \\| \\| Description \\| The start date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Start date \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| system_metadata.query_date_range_start** |
| \| Field label \| Start date \| \| --- \| --- \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Start date |
| Description | The start date of the requested query |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| system_metadata.query_date_range_end** \| \| --- \| \| \\| Field label \\| End date \\| \\| --- \\| --- \\| \\| Description \\| The end date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| End date \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_range_end** |
| \| Field label \| End date \| \| --- \| --- \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | End date |
| Description | The end date of the requested query |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| system_metadata.query_timezone** \| \| --- \| \| \\| Field label \\| Timezone \\| \\| --- \\| --- \\| \\| Description \\| The timezone that is supplied to the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.timezone](/apidocs/field-data-types#time) \\| \| \| Field label \| Timezone \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| system_metadata.query_timezone** |
| \| Field label \| Timezone \| \| --- \| --- \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| Field label | Timezone |
| Description | The timezone that is supplied to the query |
| Field type | dimension |
| Data type | [string.time.timezone](/apidocs/field-data-types#time) |
| \| system_metadata.query_filters** \| \| --- \| \| \\| Field label \\| Filters \\| \\| --- \\| --- \\| \\| Description \\| All filters used in the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Filters \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_filters** |
| \| Field label \| Filters \| \| --- \| --- \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Filters |
| Description | All filters used in the query |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.query_date_start** \| \| --- \| \| \\| Field label \\| Start \\| \\| --- \\| --- \\| \\| Description \\| When the query was started \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Start \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_start** |
| \| Field label \| Start \| \| --- \| --- \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Start |
| Description | When the query was started |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| system_metadata.query_date_end** \| \| --- \| \| \\| Field label \\| End \\| \\| --- \\| --- \\| \\| Description \\| When the query completed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| End \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_end** |
| \| Field label \| End \| \| --- \| --- \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | End |
| Description | When the query completed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| system_metadata.query_duration** \| \| --- \| \| \\| Field label \\| Duration \\| \\| --- \\| --- \\| \\| Description \\| The duration in seconds of the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.duration.seconds](/apidocs/field-data-types#duration) \\| \| \| Field label \| Duration \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| |
| system_metadata.query_duration** |
| \| Field label \| Duration \| \| --- \| --- \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| |
| Field label | Duration |
| Description | The duration in seconds of the query |
| Field type | dimension |
| Data type | [int.duration.seconds](/apidocs/field-data-types#duration) |
| \| system_metadata.query_accounts** \| \| --- \| \| \\| Field label \\| Accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of accounts of which the data was pulled from \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Accounts \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_accounts** |
| \| Field label \| Accounts \| \| --- \| --- \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Accounts |
| Description | A list of accounts of which the data was pulled from |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.query_excluded_accounts** \| \| --- \| \| \\| Field label \\| Excluded invalid accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Excluded invalid accounts \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_excluded_accounts** |
| \| Field label \| Excluded invalid accounts \| \| --- \| --- \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Excluded invalid accounts |
| Description | A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |

### REVENUE

| \| gross_sales** \| \| --- \| \| \\| Field label \\| Gross sales \\| \\| --- \\| --- \\| \\| Description \\| Sale price of product(s) multiplied by quantity ordered. Does not include refunds, coupons, taxes, or shipping \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Gross sales \| \| Description \| Sale price of product(s) multiplied by quantity ordered. Does not include refunds, coupons, taxes, or shipping \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| --- |
| gross_sales** |
| \| Field label \| Gross sales \| \| --- \| --- \| \| Description \| Sale price of product(s) multiplied by quantity ordered. Does not include refunds, coupons, taxes, or shipping \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Gross sales |
| Description | Sale price of product(s) multiplied by quantity ordered. Does not include refunds, coupons, taxes, or shipping |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| refunds** \| \| --- \| \| \\| Field label \\| Returns \\| \\| --- \\| --- \\| \\| Description \\| Money returned to the customer via a refund \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Returns \| \| Description \| Money returned to the customer via a refund \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| refunds** |
| \| Field label \| Returns \| \| --- \| --- \| \| Description \| Money returned to the customer via a refund \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Returns |
| Description | Money returned to the customer via a refund |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| coupons** \| \| --- \| \| \\| Field label \\| Coupons \\| \\| --- \\| --- \\| \\| Description \\| Total sum of discounts from coupons \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Coupons \| \| Description \| Total sum of discounts from coupons \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| coupons** |
| \| Field label \| Coupons \| \| --- \| --- \| \| Description \| Total sum of discounts from coupons \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Coupons |
| Description | Total sum of discounts from coupons |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| net_revenue** \| \| --- \| \| \\| Field label \\| Net sales \\| \\| --- \\| --- \\| \\| Description \\| Net sale in the period. (Net sales = Gross Sales – Returns – Coupons (referred to as “Sales” in the legacy WooCommerce Reports)) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Net sales \| \| Description \| Net sale in the period. (Net sales = Gross Sales – Returns – Coupons (referred to as “Sales” in the legacy WooCommerce Reports)) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| net_revenue** |
| \| Field label \| Net sales \| \| --- \| --- \| \| Description \| Net sale in the period. (Net sales = Gross Sales – Returns – Coupons (referred to as “Sales” in the legacy WooCommerce Reports)) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Net sales |
| Description | Net sale in the period. (Net sales = Gross Sales – Returns – Coupons (referred to as “Sales” in the legacy WooCommerce Reports)) |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| taxes** \| \| --- \| \| \\| Field label \\| Taxes \\| \\| --- \\| --- \\| \\| Description \\| The total tax applied to items in an order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Taxes \| \| Description \| The total tax applied to items in an order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| taxes** |
| \| Field label \| Taxes \| \| --- \| --- \| \| Description \| The total tax applied to items in an order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Taxes |
| Description | The total tax applied to items in an order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shipping** \| \| --- \| \| \\| Field label \\| Shipping \\| \\| --- \\| --- \\| \\| Description \\| The shipping charges associated with an order or refund \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shipping \| \| Description \| The shipping charges associated with an order or refund \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shipping** |
| \| Field label \| Shipping \| \| --- \| --- \| \| Description \| The shipping charges associated with an order or refund \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shipping |
| Description | The shipping charges associated with an order or refund |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_sales** \| \| --- \| \| \\| Field label \\| Total sales \\| \\| --- \\| --- \\| \\| Description \\| Total sale in the period. (Total sales = Gross Sales – Returns – Coupons + Taxes + Shipping) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total sales \| \| Description \| Total sale in the period. (Total sales = Gross Sales – Returns – Coupons + Taxes + Shipping) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_sales** |
| \| Field label \| Total sales \| \| --- \| --- \| \| Description \| Total sale in the period. (Total sales = Gross Sales – Returns – Coupons + Taxes + Shipping) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total sales |
| Description | Total sale in the period. (Total sales = Gross Sales – Returns – Coupons + Taxes + Shipping) |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### SALES

| \| product_net_sales** \| \| --- \| \| \\| Field label \\| Net sales \\| \\| --- \\| --- \\| \\| Description \\| Product net sales \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Net sales \| \| Description \| Product net sales \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| --- |
| product_net_sales** |
| \| Field label \| Net sales \| \| --- \| --- \| \| Description \| Product net sales \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Net sales |
| Description | Product net sales |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| product_items_sold** \| \| --- \| \| \\| Field label \\| Items sold \\| \\| --- \\| --- \\| \\| Description \\| Number of items sold \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Items sold \| \| Description \| Number of items sold \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| product_items_sold** |
| \| Field label \| Items sold \| \| --- \| --- \| \| Description \| Number of items sold \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Items sold |
| Description | Number of items sold |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| product_orders_count** \| \| --- \| \| \\| Field label \\| Orders \\| \\| --- \\| --- \\| \\| Description \\| Number of order \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Orders \| \| Description \| Number of order \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| product_orders_count** |
| \| Field label \| Orders \| \| --- \| --- \| \| Description \| Number of order \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Orders |
| Description | Number of order |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

### SHIPPING

| \| shipping_first_name** \| \| --- \| \| \\| Field label \\| Shipping first name \\| \\| --- \\| --- \\| \\| Description \\| Shipping first name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping first name \| \| Description \| Shipping first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| shipping_first_name** |
| \| Field label \| Shipping first name \| \| --- \| --- \| \| Description \| Shipping first name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping first name |
| Description | Shipping first name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_last_name** \| \| --- \| \| \\| Field label \\| Shipping last name \\| \\| --- \\| --- \\| \\| Description \\| Shipping last name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping last name \| \| Description \| Shipping last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_last_name** |
| \| Field label \| Shipping last name \| \| --- \| --- \| \| Description \| Shipping last name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping last name |
| Description | Shipping last name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_company_name** \| \| --- \| \| \\| Field label \\| Shipping company name \\| \\| --- \\| --- \\| \\| Description \\| Shipping company name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping company name \| \| Description \| Shipping company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_company_name** |
| \| Field label \| Shipping company name \| \| --- \| --- \| \| Description \| Shipping company name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping company name |
| Description | Shipping company name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_address_line_1** \| \| --- \| \| \\| Field label \\| Shipping address line 1 \\| \\| --- \\| --- \\| \\| Description \\| Shipping address line 1 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** |
| \| Field label \| Shipping address line 1 \| \| --- \| --- \| \| Description \| Shipping address line 1 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | 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** \| \| --- \| \| \\| Field label \\| Shipping address line 2 \\| \\| --- \\| --- \\| \\| Description \\| Shipping address line 2 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** |
| \| Field label \| Shipping address line 2 \| \| --- \| --- \| \| Description \| Shipping address line 2 \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping address line 2 |
| Description | Shipping address line 2 |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_city** \| \| --- \| \| \\| Field label \\| Shipping city \\| \\| --- \\| --- \\| \\| Description \\| Shipping city name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping city \| \| Description \| Shipping city name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| shipping_city** |
| \| Field label \| Shipping city \| \| --- \| --- \| \| Description \| Shipping city name \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping city |
| Description | Shipping city name |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| shipping_state** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_postcode** \| \| --- \| \| \\| Field label \\| Shipping post code \\| \\| --- \\| --- \\| \\| Description \\| Shipping postal code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping post code \| \| Description \| Shipping postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_postcode** |
| \| Field label \| Shipping post code \| \| --- \| --- \| \| Description \| Shipping postal code \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping post code |
| Description | Shipping postal code |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_country** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** |
| \| Field label \| 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) \| |
| Field label | 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_phone** \| \| --- \| \| \\| Field label \\| Shipping phone \\| \\| --- \\| --- \\| \\| Description \\| Shipping phone number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping phone \| \| Description \| Shipping phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| shipping_phone** |
| \| Field label \| Shipping phone \| \| --- \| --- \| \| Description \| Shipping phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Field label | Shipping phone |
| Description | Shipping phone number |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |

### STORE

| \| account_name** \| \| --- \| \| \\| Field label \\| Store URL \\| \\| --- \\| --- \\| \\| Description \\| The URL of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Store URL \| \| Description \| The URL of the store \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| --- |
| account_name** |
| \| Field label \| Store URL \| \| --- \| --- \| \| Description \| The URL of the store \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Field label | Store URL |
| Description | The URL of the store |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |

### TIME

| \| today** \| \| --- \| \| \\| Field label \\| Today \\| \\| --- \\| --- \\| \\| Description \\| Today's date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Today \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| |
| --- |
| today** |
| \| Field label \| Today \| \| --- \| --- \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| |
| Field label | Today |
| Description | Today's date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| Destinations | API, Data warehouse |
| \| year** \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year** |
| \| Field label \| Year \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| year_of_week** \| \| --- \| \| \\| Field label \\| Year of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year_of_week** |
| \| Field label \| Year of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year of week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| year_of_week_iso** \| \| --- \| \| \\| Field label \\| Year of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year_of_week_iso** |
| \| Field label \| Year of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year of week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| year_month** \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| |
| year_month** |
| \| Field label \| Year & month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| |
| Field label | Year & month |
| Field type | dimension |
| Data type | [string.time.yearmonth](/apidocs/field-data-types#time) |
| \| month** \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| |
| month** |
| \| Field label \| Month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| |
| Field label | Month |
| Field type | dimension |
| Data type | [string.time.month](/apidocs/field-data-types#time) |
| \| year_week** \| \| --- \| \| \\| Field label \\| Year & week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| |
| year_week** |
| \| Field label \| Year & week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| |
| Field label | Year & week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.yearweek](/apidocs/field-data-types#time) |
| \| year_week_iso** \| \| --- \| \| \\| Field label \\| Year & week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| |
| year_week_iso** |
| \| Field label \| Year & week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| |
| Field label | Year & week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.yearweekiso](/apidocs/field-data-types#time) |
| \| week** \| \| --- \| \| \\| Field label \\| Week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.week](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| |
| week** |
| \| Field label \| Week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| |
| Field label | Week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.week](/apidocs/field-data-types#time) |
| \| week_iso** \| \| --- \| \| \\| Field label \\| Week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.weekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| |
| week_iso** |
| \| Field label \| Week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| |
| Field label | Week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.weekiso](/apidocs/field-data-types#time) |
| \| day_of_month** \| \| --- \| \| \\| Field label \\| Day of month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of month \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| |
| day_of_month** |
| \| Field label \| Day of month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| |
| Field label | Day of month |
| Field type | dimension |
| Data type | [string.time.dayofmonth](/apidocs/field-data-types#time) |
| \| day_of_week_name** \| \| --- \| \| \\| Field label \\| Day of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| |
| day_of_week_name** |
| \| Field label \| Day of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| |
| Field label | Day of week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.dayofweek](/apidocs/field-data-types#time) |
| \| day_of_week_name_iso** \| \| --- \| \| \\| Field label \\| Day of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| |
| day_of_week_name_iso** |
| \| Field label \| Day of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| |
| Field label | Day of week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.dayofweekiso](/apidocs/field-data-types#time) |
| \| date** \| \| --- \| \| \\| Field label \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date** |
| \| Field label \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| atom** \| \| --- \| \| \\| Field label \\| Datetime \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Datetime \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| atom** |
| \| Field label \| Datetime \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Datetime |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |