---
title: "Squarespace Commerce metrics and dimensions"
slug: "squarespace-commerce-fields"
description: "Explore the Squarespace Commerce metrics and dimensions available through Supermetrics. Find the fields you need for your ideal marketing reports."
updated: 2026-03-05T14:11:35Z
published: 2026-03-05T14:11:35Z
canonical: "docs.supermetrics.com/squarespace-commerce-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.

# Squarespace Commerce metrics and dimensions

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

7 metrics50 dimensionsSearch fields

### 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_address_1 \| \| --- \| \| \\| Field label \\| Billing address 1 \\| \\| --- \\| --- \\| \\| Description \\| Billing address 1 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing address 1 \| \| Description \| Billing address 1 \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| billing_address_1 |
| \| Field label \| Billing address 1 \| \| --- \| --- \| \| Description \| Billing address 1 \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Field label | Billing address 1 |
| Description | Billing address 1 |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_address_2 \| \| --- \| \| \\| Field label \\| Billing address 2 \\| \\| --- \\| --- \\| \\| Description \\| Billing address 2 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing address 2 \| \| Description \| Billing address 2 \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| billing_address_2 |
| \| Field label \| Billing address 2 \| \| --- \| --- \| \| Description \| Billing address 2 \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Field label | Billing address 2 |
| Description | Billing address 2 |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_city \| \| --- \| \| \\| Field label \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| Billing city \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing city \| \| Description \| Billing city \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| billing_city |
| \| Field label \| Billing city \| \| --- \| --- \| \| Description \| Billing city \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | Billing city |
| Description | Billing city |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| billing_state \| \| --- \| \| \\| Field label \\| Billing state \\| \\| --- \\| --- \\| \\| Description \\| Billing state \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing state \| \| Description \| Billing state \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_state |
| \| Field label \| Billing state \| \| --- \| --- \| \| Description \| Billing state \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing state |
| Description | Billing state |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_country_code \| \| --- \| \| \\| Field label \\| Billing country code \\| \\| --- \\| --- \\| \\| Description \\| Billing country code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing country code \| \| Description \| Billing country code \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| billing_country_code |
| \| Field label \| Billing country code \| \| --- \| --- \| \| Description \| Billing country code \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Field label | Billing country code |
| Description | Billing country code |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| billing_postal_code \| \| --- \| \| \\| Field label \\| Billing postal code \\| \\| --- \\| --- \\| \\| Description \\| Billing postal code \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.zip](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing postal code \| \| Description \| Billing postal code \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| billing_postal_code |
| \| Field label \| Billing postal code \| \| --- \| --- \| \| Description \| Billing postal code \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| Field label | Billing postal code |
| Description | Billing postal code |
| Field type | dimension |
| Data type | [string.geo.zip](/apidocs/field-data-types#geographical) |
| \| billing_phone \| \| --- \| \| \\| Field label \\| Billing phone \\| \\| --- \\| --- \\| \\| Description \\| Billing phone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing phone \| \| Description \| Billing phone \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| billing_phone |
| \| Field label \| Billing phone \| \| --- \| --- \| \| Description \| Billing phone \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Field label | Billing phone |
| Description | Billing phone |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |

### CUSTOMER

| \| customer_email \| \| --- \| \| \\| Field label \\| Customer email \\| \\| --- \\| --- \\| \\| Description \\| Email address provided at checkout or, for recurring subscription orders, the customer's current email address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer email \| \| Description \| Email address provided at checkout or, for recurring subscription orders, the customer's current email address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| --- |
| customer_email |
| \| Field label \| Customer email \| \| --- \| --- \| \| Description \| Email address provided at checkout or, for recurring subscription orders, the customer's current email address \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Field label | Customer email |
| Description | Email address provided at checkout or, for recurring subscription orders, the customer's current email address |
| Field type | dimension |
| Data type | [string.text.email](/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) |

### ORDER

| \| order_id \| \| --- \| \| \\| Field label \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| Unique order ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order ID \| \| Description \| Unique order ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| order_id |
| \| Field label \| Order ID \| \| --- \| --- \| \| Description \| Unique order ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order ID |
| Description | Unique order ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_number \| \| --- \| \| \\| Field label \\| Order number \\| \\| --- \\| --- \\| \\| Description \\| Unique, sequential number for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order number \| \| Description \| Unique, sequential number for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_number |
| \| Field label \| Order number \| \| --- \| --- \| \| Description \| Unique, sequential number for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order number |
| Description | Unique, sequential number for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_channel \| \| --- \| \| \\| Field label \\| Order channel \\| \\| --- \\| --- \\| \\| Description \\| Where the order originated; possible values are: `web` and `pos` \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order channel \| \| Description \| Where the order originated; possible values are: `web` and `pos` \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_channel |
| \| Field label \| Order channel \| \| --- \| --- \| \| Description \| Where the order originated; possible values are: `web` and `pos` \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order channel |
| Description | Where the order originated; possible values are: `web` and `pos` |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_fulfillment_status \| \| --- \| \| \\| Field label \\| Order fulfillment status \\| \\| --- \\| --- \\| \\| Description \\| Current fulfillment status of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order fulfillment status \| \| Description \| Current fulfillment status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_fulfillment_status |
| \| Field label \| Order fulfillment status \| \| --- \| --- \| \| Description \| Current fulfillment status of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order fulfillment status |
| Description | Current fulfillment status of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_channel_name \| \| --- \| \| \\| Field label \\| Order channel name \\| \\| --- \\| --- \\| \\| Description \\| Name of the third-party sales channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order channel name \| \| Description \| Name of the third-party sales channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_channel_name |
| \| Field label \| Order channel name \| \| --- \| --- \| \| Description \| Name of the third-party sales channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order channel name |
| Description | Name of the third-party sales channel |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| subtotal \| \| --- \| \| \\| Field label \\| Subtotal \\| \\| --- \\| --- \\| \\| Description \\| Order subtotal \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Subtotal \| \| Description \| Order subtotal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| subtotal |
| \| Field label \| Subtotal \| \| --- \| --- \| \| Description \| Order subtotal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Subtotal |
| Description | Order subtotal |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shipping_total \| \| --- \| \| \\| Field label \\| Shipping total \\| \\| --- \\| --- \\| \\| Description \\| Order shipping total \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Shipping total \| \| Description \| Order shipping total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shipping_total |
| \| Field label \| Shipping total \| \| --- \| --- \| \| Description \| Order shipping total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Shipping total |
| Description | Order shipping total |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| discount_total \| \| --- \| \| \\| Field label \\| Discount total \\| \\| --- \\| --- \\| \\| Description \\| Order discount total \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Discount total \| \| Description \| Order discount total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| discount_total |
| \| Field label \| Discount total \| \| --- \| --- \| \| Description \| Order discount total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Discount total |
| Description | Order discount total |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| tax_total \| \| --- \| \| \\| Field label \\| Tax total \\| \\| --- \\| --- \\| \\| Description \\| Order tax total \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Tax total \| \| Description \| Order tax total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| tax_total |
| \| Field label \| Tax total \| \| --- \| --- \| \| Description \| Order tax total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Tax total |
| Description | Order tax total |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| refunded_total \| \| --- \| \| \\| Field label \\| Refunded total \\| \\| --- \\| --- \\| \\| Description \\| Order refunded total \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Refunded total \| \| Description \| Order refunded total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| refunded_total |
| \| Field label \| Refunded total \| \| --- \| --- \| \| Description \| Order refunded total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Refunded total |
| Description | Order refunded total |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| grand_total \| \| --- \| \| \\| Field label \\| Grand total \\| \\| --- \\| --- \\| \\| Description \\| Order grand total \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Grand total \| \| Description \| Order grand total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| grand_total |
| \| Field label \| Grand total \| \| --- \| --- \| \| Description \| Order grand total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Grand total |
| Description | Order grand total |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| orders \| \| --- \| \| \\| Field label \\| Orders \\| \\| --- \\| --- \\| \\| Description \\| Order total \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Orders \| \| Description \| Order total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| orders |
| \| Field label \| Orders \| \| --- \| --- \| \| Description \| Order total \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Orders |
| Description | Order total |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |

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

### STORE

| \| store_name \| \| --- \| \| \\| Field label \\| Store name \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| store_name |
| \| Field label \| Store name \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| store_id \| \| --- \| \| \\| Field label \\| Store ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| store_id |
| \| Field label \| Store ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| store_url \| \| --- \| \| \\| Field label \\| Store URL \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Store URL \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| store_url |
| \| Field label \| Store URL \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Field label | Store URL |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| store_currency \| \| --- \| \| \\| Field label \\| Store currency \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Store currency \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| store_currency |
| \| Field label \| Store currency \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Store currency |
| 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 \\| ISO 8601 UTC date string; represents the moment when the order was placed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order created date \| \| Description \| ISO 8601 UTC date string; represents the moment when the order was placed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| order_created_date |
| \| Field label \| Order created date \| \| --- \| --- \| \| Description \| ISO 8601 UTC date string; represents the moment when the order was placed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Order created date |
| Description | ISO 8601 UTC date string; represents the moment when the order was placed |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_created_datetime \| \| --- \| \| \\| Field label \\| Order created datetime \\| \\| --- \\| --- \\| \\| Description \\| ISO 8601 UTC date and time string; represents the moment when the order was placed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order created datetime \| \| Description \| ISO 8601 UTC date and time string; represents the moment when the order was placed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_created_datetime |
| \| Field label \| Order created datetime \| \| --- \| --- \| \| Description \| ISO 8601 UTC date and time string; represents the moment when the order was placed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Order created datetime |
| Description | ISO 8601 UTC date and time string; represents the moment when the order was placed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_modified_date \| \| --- \| \| \\| Field label \\| Order modified date \\| \\| --- \\| --- \\| \\| Description \\| ISO 8601 UTC date string; represents when the order was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Order modified date \| \| Description \| ISO 8601 UTC date string; represents when the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| order_modified_date |
| \| Field label \| Order modified date \| \| --- \| --- \| \| Description \| ISO 8601 UTC date string; represents when the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Order modified date |
| Description | ISO 8601 UTC date string; represents when the order was last modified |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_modified_datetime \| \| --- \| \| \\| Field label \\| Order modified datetime \\| \\| --- \\| --- \\| \\| Description \\| ISO 8601 UTC date and time string; represents when the order was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Order modified datetime \| \| Description \| ISO 8601 UTC date and time string; represents when the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_modified_datetime |
| \| Field label \| Order modified datetime \| \| --- \| --- \| \| Description \| ISO 8601 UTC date and time string; represents when the order was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Order modified datetime |
| Description | ISO 8601 UTC date and time string; represents when the order was last modified |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |