---
title: "Centra metrics and dimensions"
slug: "centra-fields"
description: "Explore the complete list of Centra metrics and dimensions available through Supermetrics. Find every data field you need to build your ideal marketing reports."
updated: 2026-03-05T14:19:02Z
published: 2026-03-05T14:19:02Z
canonical: "docs.supermetrics.com/centra-fields"
---

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

# Centra metrics and dimensions

> Supermetrics brings all your Centra 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)

9 metrics49 dimensionsSearch fields

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

### ORDER

| \| order_id \| \| --- \| \| \\| Field label \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| The order's ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order ID \| \| Description \| The order's ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| order_id |
| \| Field label \| Order ID \| \| --- \| --- \| \| Description \| The order's ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order ID |
| Description | The order's ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_market \| \| --- \| \| \\| Field label \\| Order market \\| \\| --- \\| --- \\| \\| Description \\| The order's market \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order market \| \| Description \| The order's market \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_market |
| \| Field label \| Order market \| \| --- \| --- \| \| Description \| The order's market \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order market |
| Description | The order's market |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_status \| \| --- \| \| \\| Field label \\| Order status \\| \\| --- \\| --- \\| \\| Description \\| The order's status \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order status \| \| Description \| The order's status \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_status |
| \| Field label \| Order status \| \| --- \| --- \| \| Description \| The order's status \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order status |
| Description | The order's status |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### PRODUCT

| \| product_name \| \| --- \| \| \\| Field label \\| Product name \\| \\| --- \\| --- \\| \\| Description \\| Name of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product name \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| product_name |
| \| Field label \| Product name \| \| --- \| --- \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product name |
| Description | Name of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_ean \| \| --- \| \| \\| Field label \\| Product EAN \\| \\| --- \\| --- \\| \\| Description \\| European Article Number / GTIN-13, standardized unique identifier of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product EAN \| \| Description \| European Article Number / GTIN-13, standardized unique identifier of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_ean |
| \| Field label \| Product EAN \| \| --- \| --- \| \| Description \| European Article Number / GTIN-13, standardized unique identifier of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product EAN |
| Description | European Article Number / GTIN-13, standardized unique identifier of the product |
| 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) |

### RETURN

| \| return_status \| \| --- \| \| \\| Field label \\| Return status \\| \\| --- \\| --- \\| \\| Description \\| The return's status \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Return status \| \| Description \| The return's status \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| return_status |
| \| Field label \| Return status \| \| --- \| --- \| \| Description \| The return's status \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Return status |
| Description | The return's status |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| return_shipment_id \| \| --- \| \| \\| Field label \\| Return shipment ID \\| \\| --- \\| --- \\| \\| Description \\| The return's shipment ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Return shipment ID \| \| Description \| The return's shipment ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| return_shipment_id |
| \| Field label \| Return shipment ID \| \| --- \| --- \| \| Description \| The return's shipment ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Return shipment ID |
| Description | The return's shipment ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| items_returned \| \| --- \| \| \\| Field label \\| Items returned \\| \\| --- \\| --- \\| \\| Description \\| The quantity of returned items \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Items returned \| \| Description \| The quantity of returned items \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| items_returned |
| \| Field label \| Items returned \| \| --- \| --- \| \| Description \| The quantity of returned items \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Items returned |
| Description | The quantity of returned items |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| item_total_returned \| \| --- \| \| \\| Field label \\| Item total returned \\| \\| --- \\| --- \\| \\| Description \\| Line items total returned in base currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item total returned \| \| Description \| Line items total returned in base currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_total_returned |
| \| Field label \| Item total returned \| \| --- \| --- \| \| Description \| Line items total returned in base currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item total returned |
| Description | Line items total returned in base currency |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_total_returned_ex_tax \| \| --- \| \| \\| Field label \\| Item total returned (excluding tax) \\| \\| --- \\| --- \\| \\| Description \\| Line item total returned excluding tax in base currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item total returned (excluding tax) \| \| Description \| Line item total returned excluding tax in base currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_total_returned_ex_tax |
| \| Field label \| Item total returned (excluding tax) \| \| --- \| --- \| \| Description \| Line item total returned excluding tax in base currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item total returned (excluding tax) |
| Description | Line item total returned excluding tax in base currency |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### SALES

| \| item_quantity \| \| --- \| \| \\| Field label \\| Item quantity \\| \\| --- \\| --- \\| \\| Description \\| The current quantity for the order line, excluding cancelled units \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Item quantity \| \| Description \| The current quantity for the order line, excluding cancelled units \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| --- |
| item_quantity |
| \| Field label \| Item quantity \| \| --- \| --- \| \| Description \| The current quantity for the order line, excluding cancelled units \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Item quantity |
| Description | The current quantity for the order line, excluding cancelled units |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| item_price \| \| --- \| \| \\| Field label \\| Item price \\| \\| --- \\| --- \\| \\| Description \\| Line items unit price in base currency. This field is only available when line item level dimensions are applied \\| \\| 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 \| Line items unit price in base currency. This field is only available when line item level dimensions are applied \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| \| Aggregation \| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \| |
| item_price |
| \| Field label \| Item price \| \| --- \| --- \| \| Description \| Line items unit price in base currency. This field is only available when line item level dimensions are applied \| \| 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 | Line items unit price in base currency. This field is only available when line item level dimensions are applied |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| Aggregation | [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) |
| \| item_original_price \| \| --- \| \| \\| Field label \\| Item original price \\| \\| --- \\| --- \\| \\| Description \\| Original unit price of the product, in base currency. This field is only available when line item level dimensions are applied \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \\| Aggregation \\| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \\| \| \| Field label \| Item original price \| \| Description \| Original unit price of the product, in base currency. This field is only available when line item level dimensions are applied \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| \| Aggregation \| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \| |
| item_original_price |
| \| Field label \| Item original price \| \| --- \| --- \| \| Description \| Original unit price of the product, in base currency. This field is only available when line item level dimensions are applied \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| \| Aggregation \| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \| |
| Field label | Item original price |
| Description | Original unit price of the product, in base currency. This field is only available when line item level dimensions are applied |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| Aggregation | [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) |
| \| item_original_price_ex_tax \| \| --- \| \| \\| Field label \\| Item original price (excluding tax) \\| \\| --- \\| --- \\| \\| Description \\| Original unit price of the product, in base currency excluding tax. This field is only available when line item level dimensions are applied \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \\| Aggregation \\| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \\| \| \| Field label \| Item original price (excluding tax) \| \| Description \| Original unit price of the product, in base currency excluding tax. This field is only available when line item level dimensions are applied \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| \| Aggregation \| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \| |
| item_original_price_ex_tax |
| \| Field label \| Item original price (excluding tax) \| \| --- \| --- \| \| Description \| Original unit price of the product, in base currency excluding tax. This field is only available when line item level dimensions are applied \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| \| Aggregation \| [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) \| |
| Field label | Item original price (excluding tax) |
| Description | Original unit price of the product, in base currency excluding tax. This field is only available when line item level dimensions are applied |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| Aggregation | [Non-aggregatable metric](/apidocs/non-aggregatable-metrics) |
| \| item_subtotal \| \| --- \| \| \\| Field label \\| Item subtotal \\| \\| --- \\| --- \\| \\| Description \\| Line items total in base currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item subtotal \| \| Description \| Line items total in base currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_subtotal |
| \| Field label \| Item subtotal \| \| --- \| --- \| \| Description \| Line items total in base currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item subtotal |
| Description | Line items total in base currency |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_subtotal_ex_tax \| \| --- \| \| \\| Field label \\| Item subtotal (excluding tax) \\| \\| --- \\| --- \\| \\| Description \\| Line item total excluding tax in base currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item subtotal (excluding tax) \| \| Description \| Line item total excluding tax in base currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_subtotal_ex_tax |
| \| Field label \| Item subtotal (excluding tax) \| \| --- \| --- \| \| Description \| Line item total excluding tax in base currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item subtotal (excluding tax) |
| Description | Line item total excluding tax in base currency |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

### SHIPPING

| \| shipping_country_name \| \| --- \| \| \\| Field label \\| Shipping country name \\| \\| --- \\| --- \\| \\| Description \\| Name of the country where order is shipped to \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping country name \| \| Description \| Name of the country where order is shipped to \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| --- |
| shipping_country_name |
| \| Field label \| Shipping country name \| \| --- \| --- \| \| Description \| Name of the country where order is shipped to \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping country name |
| Description | Name of the country where order is shipped to |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| shipping_country_code \| \| --- \| \| \\| Field label \\| Shipping country code \\| \\| --- \\| --- \\| \\| Description \\| Country code of the country where order is shipped to \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping country code \| \| Description \| Country code of the country where order is shipped to \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| shipping_country_code |
| \| Field label \| Shipping country code \| \| --- \| --- \| \| Description \| Country code of the country where order is shipped to \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping country code |
| Description | Country code of the country where order is shipped to |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |

### STORE

| \| store_name \| \| --- \| \| \\| Field label \\| Store name \\| \\| --- \\| --- \\| \\| Description \\| The store's name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store name \| \| Description \| The store's name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| store_name |
| \| Field label \| Store name \| \| --- \| --- \| \| Description \| The store's name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store name |
| Description | The store's name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| store_id \| \| --- \| \| \\| Field label \\| Store ID \\| \\| --- \\| --- \\| \\| Description \\| The store's ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store ID \| \| Description \| The store's ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| store_id |
| \| Field label \| Store ID \| \| --- \| --- \| \| Description \| The store's ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store ID |
| Description | The store's ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| store_type \| \| --- \| \| \\| Field label \\| Store type \\| \\| --- \\| --- \\| \\| Description \\| The store's type. Direct to consumer or wholesale \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store type \| \| Description \| The store's type. Direct to consumer or wholesale \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| store_type |
| \| Field label \| Store type \| \| --- \| --- \| \| Description \| The store's type. Direct to consumer or wholesale \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store type |
| Description | The store's type. Direct to consumer or wholesale |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| store_url \| \| --- \| \| \\| Field label \\| Store URL \\| \\| --- \\| --- \\| \\| Description \\| The store's URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Store URL \| \| Description \| The store's URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| store_url |
| \| Field label \| Store URL \| \| --- \| --- \| \| Description \| The store's URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Field label | Store URL |
| Description | The store's URL |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| store_currency \| \| --- \| \| \\| Field label \\| Store currency \\| \\| --- \\| --- \\| \\| Description \\| The base currency code of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Store currency \| \| Description \| The base currency code of the store \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| store_currency |
| \| Field label \| Store currency \| \| --- \| --- \| \| Description \| The base currency code of the store \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Store currency |
| Description | The base currency code of the store |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |

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

### TIMESTAMP

| \| order_created_date \| \| --- \| \| \\| Field label \\| Order created date \\| \\| --- \\| --- \\| \\| Description \\| Date when the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order created date \| \| Description \| Date when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| order_created_date |
| \| Field label \| Order created date \| \| --- \| --- \| \| Description \| Date when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Order created date |
| Description | Date when the order was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_created_datetime \| \| --- \| \| \\| Field label \\| Order created datetime \\| \\| --- \\| --- \\| \\| Description \\| Date & time when the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order created datetime \| \| Description \| Date & time when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_created_datetime |
| \| Field label \| Order created datetime \| \| --- \| --- \| \| Description \| Date & time when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Order created datetime |
| Description | Date & time when the order was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_updated_date \| \| --- \| \| \\| Field label \\| Order updated date \\| \\| --- \\| --- \\| \\| Description \\| Date when the order was updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order updated date \| \| Description \| Date when the order was updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_updated_date |
| \| Field label \| Order updated date \| \| --- \| --- \| \| Description \| Date when the order was updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Order updated date |
| Description | Date when the order was updated |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_updated_datetime \| \| --- \| \| \\| Field label \\| Order updated datetime \\| \\| --- \\| --- \\| \\| Description \\| Date & time when the order was updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order updated datetime \| \| Description \| Date & time when the order was updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_updated_datetime |
| \| Field label \| Order updated datetime \| \| --- \| --- \| \| Description \| Date & time when the order was updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Order updated datetime |
| Description | Date & time when the order was updated |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| payment_capture_date \| \| --- \| \| \\| Field label \\| Payment capture date \\| \\| --- \\| --- \\| \\| Description \\| Date when the order payment was captured \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Payment capture date \| \| Description \| Date when the order payment was captured \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| payment_capture_date |
| \| Field label \| Payment capture date \| \| --- \| --- \| \| Description \| Date when the order payment was captured \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Payment capture date |
| Description | Date when the order payment was captured |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| payment_capture_datetime \| \| --- \| \| \\| Field label \\| Payment capture datetime \\| \\| --- \\| --- \\| \\| Description \\| Date & time when the order payment was captured \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Payment capture datetime \| \| Description \| Date & time when the order payment was captured \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| payment_capture_datetime |
| \| Field label \| Payment capture datetime \| \| --- \| --- \| \| Description \| Date & time when the order payment was captured \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Payment capture datetime |
| Description | Date & time when the order payment was captured |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_return_date \| \| --- \| \| \\| Field label \\| Order return date \\| \\| --- \\| --- \\| \\| Description \\| Date when a return for the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order return date \| \| Description \| Date when a return for the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_return_date |
| \| Field label \| Order return date \| \| --- \| --- \| \| Description \| Date when a return for the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Order return date |
| Description | Date when a return for the order was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_return_datetime \| \| --- \| \| \\| Field label \\| Order return datetime \\| \\| --- \\| --- \\| \\| Description \\| Date & time when a return for the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order return datetime \| \| Description \| Date & time when a return for the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_return_datetime |
| \| Field label \| Order return datetime \| \| --- \| --- \| \| Description \| Date & time when a return for the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Order return datetime |
| Description | Date & time when a return for the order was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |