---
title: "Recharge metrics and dimensions"
slug: "recharge-fields"
description: "Explore the Recharge metrics and dimensions available through Supermetrics. Find every data field you need to build your marketing reports."
updated: 2026-03-05T14:17:59Z
published: 2026-03-05T14:17:59Z
canonical: "docs.supermetrics.com/recharge-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.

# Recharge metrics and dimensions

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

31 metrics98 dimensionsSearch fields

### BILLING

| \| billing_first_name \| \| --- \| \| \\| Field label \\| Billing first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the customer for billing purposes \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing first name \| \| Description \| The first name of the customer for billing purposes \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| billing_first_name |
| \| Field label \| Billing first name \| \| --- \| --- \| \| Description \| The first name of the customer for billing purposes \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing first name |
| Description | The first name of the customer for billing purposes |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_last_name \| \| --- \| \| \\| Field label \\| Billing last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the customer for billing purposes \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing last name \| \| Description \| The last name of the customer for billing purposes \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_last_name |
| \| Field label \| Billing last name \| \| --- \| --- \| \| Description \| The last name of the customer for billing purposes \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing last name |
| Description | The last name of the customer for billing purposes |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_company \| \| --- \| \| \\| Field label \\| Billing company \\| \\| --- \\| --- \\| \\| Description \\| The company name associated with the billing address, if applicable \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing company \| \| Description \| The company name associated with the billing address, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_company |
| \| Field label \| Billing company \| \| --- \| --- \| \| Description \| The company name associated with the billing address, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing company |
| Description | The company name associated with the billing address, if applicable |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_address_1 \| \| --- \| \| \\| Field label \\| Billing address 1 \\| \\| --- \\| --- \\| \\| Description \\| The primary street address for billing \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing address 1 \| \| Description \| The primary street address for billing \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| billing_address_1 |
| \| Field label \| Billing address 1 \| \| --- \| --- \| \| Description \| The primary street address for billing \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Field label | Billing address 1 |
| Description | The primary street address for billing |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_address_2 \| \| --- \| \| \\| Field label \\| Billing address 2 \\| \\| --- \\| --- \\| \\| Description \\| The secondary street address for billing, if applicable \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing address 2 \| \| Description \| The secondary street address for billing, if applicable \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| billing_address_2 |
| \| Field label \| Billing address 2 \| \| --- \| --- \| \| Description \| The secondary street address for billing, if applicable \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Field label | Billing address 2 |
| Description | The secondary street address for billing, if applicable |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| billing_city \| \| --- \| \| \\| Field label \\| Billing city \\| \\| --- \\| --- \\| \\| Description \\| The city for the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing city \| \| Description \| The city for the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| billing_city |
| \| Field label \| Billing city \| \| --- \| --- \| \| Description \| The city for the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | Billing city |
| Description | The city for the billing address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| billing_zip \| \| --- \| \| \\| Field label \\| Billing zip \\| \\| --- \\| --- \\| \\| Description \\| The postal code or ZIP code for the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.zip](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing zip \| \| Description \| The postal code or ZIP code for the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| billing_zip |
| \| Field label \| Billing zip \| \| --- \| --- \| \| Description \| The postal code or ZIP code for the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| Field label | Billing zip |
| Description | The postal code or ZIP code for the billing address |
| Field type | dimension |
| Data type | [string.geo.zip](/apidocs/field-data-types#geographical) |
| \| billing_province \| \| --- \| \| \\| Field label \\| Billing province \\| \\| --- \\| --- \\| \\| Description \\| The province or state for the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing province \| \| Description \| The province or state for the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| billing_province |
| \| Field label \| Billing province \| \| --- \| --- \| \| Description \| The province or state for the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Billing province |
| Description | The province or state for the billing address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| billing_country_code \| \| --- \| \| \\| Field label \\| Billing country code \\| \\| --- \\| --- \\| \\| Description \\| The country code for the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Billing country code \| \| Description \| The country code for the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| billing_country_code |
| \| Field label \| Billing country code \| \| --- \| --- \| \| Description \| The country code for the billing address \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Field label | Billing country code |
| Description | The country code for the billing address |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| billing_phone \| \| --- \| \| \\| Field label \\| Billing phone \\| \\| --- \\| --- \\| \\| Description \\| The phone number associated with the billing address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Field label \| Billing phone \| \| Description \| The phone number associated with the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| billing_phone |
| \| Field label \| Billing phone \| \| --- \| --- \| \| Description \| The phone number associated with the billing address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Field label | Billing phone |
| Description | The phone number associated with the billing address |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |

### CHARGE

| \| charge_id \| \| --- \| \| \\| Field label \\| Charge ID \\| \\| --- \\| --- \\| \\| Description \\| The unique numeric identifier for the charge \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Charge ID \| \| Description \| The unique numeric identifier for the charge \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| charge_id |
| \| Field label \| Charge ID \| \| --- \| --- \| \| Description \| The unique numeric identifier for the charge \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Charge ID |
| Description | The unique numeric identifier for the charge |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| charge_type \| \| --- \| \| \\| Field label \\| Charge type \\| \\| --- \\| --- \\| \\| Description \\| An indicator of the charge’s type, either checkout or recurring \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Charge type \| \| Description \| An indicator of the charge’s type, either checkout or recurring \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| charge_type |
| \| Field label \| Charge type \| \| --- \| --- \| \| Description \| An indicator of the charge’s type, either checkout or recurring \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Charge type |
| Description | An indicator of the charge’s type, either checkout or recurring |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| charge_status \| \| --- \| \| \\| Field label \\| Charge status \\| \\| --- \\| --- \\| \\| Description \\| The status of the charge \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Charge status \| \| Description \| The status of the charge \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| charge_status |
| \| Field label \| Charge status \| \| --- \| --- \| \| Description \| The status of the charge \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Charge status |
| Description | The status of the charge |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| charge_currency \| \| --- \| \| \\| Field label \\| Charge currency \\| \\| --- \\| --- \\| \\| Description \\| The code of the currency for this charge, such as USD \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Charge currency \| \| Description \| The code of the currency for this charge, such as USD \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| charge_currency |
| \| Field label \| Charge currency \| \| --- \| --- \| \| Description \| The code of the currency for this charge, such as USD \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Charge currency |
| Description | The code of the currency for this charge, such as USD |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| charge_note \| \| --- \| \| \\| Field label \\| Charge note \\| \\| --- \\| --- \\| \\| Description \\| Notes associated with the charge \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Charge note \| \| Description \| Notes associated with the charge \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| charge_note |
| \| Field label \| Charge note \| \| --- \| --- \| \| Description \| Notes associated with the charge \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Charge note |
| Description | Notes associated with the charge |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| charge_payment_processor \| \| --- \| \| \\| Field label \\| Charge payment processor \\| \\| --- \\| --- \\| \\| Description \\| The payment processor used for the charge \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Charge payment processor \| \| Description \| The payment processor used for the charge \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| charge_payment_processor |
| \| Field label \| Charge payment processor \| \| --- \| --- \| \| Description \| The payment processor used for the charge \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Charge payment processor |
| Description | The payment processor used for the charge |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| charge_scheduled_at \| \| --- \| \| \\| Field label \\| Charge scheduled at \\| \\| --- \\| --- \\| \\| Description \\| The date when the charge is scheduled to process \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Charge scheduled at \| \| Description \| The date when the charge is scheduled to process \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| charge_scheduled_at |
| \| Field label \| Charge scheduled at \| \| --- \| --- \| \| Description \| The date when the charge is scheduled to process \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Charge scheduled at |
| Description | The date when the charge is scheduled to process |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| charge_tags \| \| --- \| \| \\| Field label \\| Charge tags \\| \\| --- \\| --- \\| \\| Description \\| A comma-separated list of tags on the charge \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Charge tags \| \| Description \| A comma-separated list of tags on the charge \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| charge_tags |
| \| Field label \| Charge tags \| \| --- \| --- \| \| Description \| A comma-separated list of tags on the charge \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Charge tags |
| Description | A comma-separated list of tags on the charge |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| charge_is_taxable \| \| --- \| \| \\| Field label \\| Charge is taxable \\| \\| --- \\| --- \\| \\| Description \\| A boolean indicator of the taxability of the charge \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Charge is taxable \| \| Description \| A boolean indicator of the taxability of the charge \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| charge_is_taxable |
| \| Field label \| Charge is taxable \| \| --- \| --- \| \| Description \| A boolean indicator of the taxability of the charge \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Charge is taxable |
| Description | A boolean indicator of the taxability of the charge |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| charge_total_line_items_price \| \| --- \| \| \\| Field label \\| Total line items price \\| \\| --- \\| --- \\| \\| Description \\| The total price of all line items of the charge \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total line items price \| \| Description \| The total price of all line items of the charge \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| charge_total_line_items_price |
| \| Field label \| Total line items price \| \| --- \| --- \| \| Description \| The total price of all line items of the charge \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total line items price |
| Description | The total price of all line items of the charge |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| charge_subtotal_price \| \| --- \| \| \\| Field label \\| Subtotal price \\| \\| --- \\| --- \\| \\| Description \\| The combined price of all line_items without taxes and shipping \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Subtotal price \| \| Description \| The combined price of all line_items without taxes and shipping \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| charge_subtotal_price |
| \| Field label \| Subtotal price \| \| --- \| --- \| \| Description \| The combined price of all line_items without taxes and shipping \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Subtotal price |
| Description | The combined price of all line_items without taxes and shipping |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| charge_total_price \| \| --- \| \| \\| Field label \\| Total price \\| \\| --- \\| --- \\| \\| Description \\| The sum of all the prices of all the items in the charge, taxes and discounts included (must be positive) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total price \| \| Description \| The sum of all the prices of all the items in the charge, taxes and discounts included (must be positive) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| charge_total_price |
| \| Field label \| Total price \| \| --- \| --- \| \| Description \| The sum of all the prices of all the items in the charge, taxes and discounts included (must be positive) \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total price |
| Description | The sum of all the prices of all the items in the charge, taxes and discounts included (must be positive) |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| charge_total_refunds \| \| --- \| \| \\| Field label \\| Total refunds \\| \\| --- \\| --- \\| \\| Description \\| The sum of all refunds that were applied to the charge \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total refunds \| \| Description \| The sum of all refunds that were applied to the charge \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| charge_total_refunds |
| \| Field label \| Total refunds \| \| --- \| --- \| \| Description \| The sum of all refunds that were applied to the charge \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total refunds |
| Description | The sum of all refunds that were applied to the charge |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| charge_total_tax \| \| --- \| \| \\| Field label \\| Total tax \\| \\| --- \\| --- \\| \\| Description \\| The total tax due associated with the charge \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total tax \| \| Description \| The total tax due associated with the charge \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| charge_total_tax |
| \| Field label \| Total tax \| \| --- \| --- \| \| Description \| The total tax due associated with the charge \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total tax |
| Description | The total tax due associated with the charge |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| charge_total_discounts \| \| --- \| \| \\| Field label \\| Total discounts \\| \\| --- \\| --- \\| \\| Description \\| The sum of the discounts applied to the charge \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total discounts \| \| Description \| The sum of the discounts applied to the charge \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| charge_total_discounts |
| \| Field label \| Total discounts \| \| --- \| --- \| \| Description \| The sum of the discounts applied to the charge \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total discounts |
| Description | The sum of the discounts applied to the charge |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| charge_total_duties \| \| --- \| \| \\| Field label \\| Total duties \\| \\| --- \\| --- \\| \\| Description \\| The total cost of duties for the charge \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total duties \| \| Description \| The total cost of duties for the charge \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| charge_total_duties |
| \| Field label \| Total duties \| \| --- \| --- \| \| Description \| The total cost of duties for the charge \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total duties |
| Description | The total cost of duties for the charge |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| charge_total_weight_grams \| \| --- \| \| \\| Field label \\| Total weight grams \\| \\| --- \\| --- \\| \\| Description \\| The total weight of the charge's line items in grams \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Total weight grams \| \| Description \| The total weight of the charge's line items in grams \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| charge_total_weight_grams |
| \| Field label \| Total weight grams \| \| --- \| --- \| \| Description \| The total weight of the charge's line items in grams \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Total weight grams |
| Description | The total weight of the charge's line items in grams |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| charge_orders \| \| --- \| \| \\| Field label \\| Orders \\| \\| --- \\| --- \\| \\| Description \\| The number of orders generated from this charge (>1 for prepaid Subscriptions) \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Orders \| \| Description \| The number of orders generated from this charge (>1 for prepaid Subscriptions) \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| charge_orders |
| \| Field label \| Orders \| \| --- \| --- \| \| Description \| The number of orders generated from this charge (>1 for prepaid Subscriptions) \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Orders |
| Description | The number of orders generated from this charge (>1 for prepaid Subscriptions) |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| charges \| \| --- \| \| \\| Field label \\| Charges \\| \\| --- \\| --- \\| \\| Description \\| The number of charges \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Charges \| \| Description \| The number of charges \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| charges |
| \| Field label \| Charges \| \| --- \| --- \| \| Description \| The number of charges \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Charges |
| Description | The number of charges |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

### CUSTOMER

| \| customer_id \| \| --- \| \| \\| Field label \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| The ID of the associated customer record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer ID \| \| Description \| The ID of the associated customer record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| customer_id |
| \| Field label \| Customer ID \| \| --- \| --- \| \| Description \| The ID of the associated customer record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Customer ID |
| Description | The ID of the associated customer record |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_email \| \| --- \| \| \\| Field label \\| Customer email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| Customer email \| \| Description \| The email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| customer_email |
| \| Field label \| Customer email \| \| --- \| --- \| \| Description \| The email address of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Field label | Customer email |
| Description | The email address of the customer |
| 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) |

### LINE ITEM

| \| purchase_item_id \| \| --- \| \| \\| Field label \\| Purchase item ID \\| \\| --- \\| --- \\| \\| Description \\| The Subscription or Onetime ID associated with the line_item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Purchase item ID \| \| Description \| The Subscription or Onetime ID associated with the line_item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| purchase_item_id |
| \| Field label \| Purchase item ID \| \| --- \| --- \| \| Description \| The Subscription or Onetime ID associated with the line_item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Purchase item ID |
| Description | The Subscription or Onetime ID associated with the line_item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| purchase_item_type \| \| --- \| \| \\| Field label \\| Purchase item type \\| \\| --- \\| --- \\| \\| Description \\| An indicator of the type of the purchase item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Purchase item type \| \| Description \| An indicator of the type of the purchase item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| purchase_item_type |
| \| Field label \| Purchase item type \| \| --- \| --- \| \| Description \| An indicator of the type of the purchase item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Purchase item type |
| Description | An indicator of the type of the purchase item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| item_title \| \| --- \| \| \\| Field label \\| Item title \\| \\| --- \\| --- \\| \\| Description \\| The title of the product of this line_item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item title \| \| Description \| The title of the product of this line_item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| item_title |
| \| Field label \| Item title \| \| --- \| --- \| \| Description \| The title of the product of this line_item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Item title |
| Description | The title of the product of this line_item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| item_variant_title \| \| --- \| \| \\| Field label \\| Item variant title \\| \\| --- \\| --- \\| \\| Description \\| The name of a variant of the Product of this line_item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item variant title \| \| Description \| The name of a variant of the Product of this line_item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| item_variant_title |
| \| Field label \| Item variant title \| \| --- \| --- \| \| Description \| The name of a variant of the Product of this line_item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Item variant title |
| Description | The name of a variant of the Product of this line_item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| sku \| \| --- \| \| \\| Field label \\| SKU \\| \\| --- \\| --- \\| \\| Description \\| The SKU (stock keeping unit) of the product associated with the line_item \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| SKU \| \| Description \| The SKU (stock keeping unit) of the product associated with the line_item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| sku |
| \| Field label \| SKU \| \| --- \| --- \| \| Description \| The SKU (stock keeping unit) of the product associated with the line_item \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | SKU |
| Description | The SKU (stock keeping unit) of the product associated with the line_item |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| item_handle \| \| --- \| \| \\| Field label \\| Item handle \\| \\| --- \\| --- \\| \\| Description \\| A unique, human-friendly string for the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Item handle \| \| Description \| A unique, human-friendly string for the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| item_handle |
| \| Field label \| Item handle \| \| --- \| --- \| \| Description \| A unique, human-friendly string for the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Item handle |
| Description | A unique, human-friendly string for the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| taxable \| \| --- \| \| \\| Field label \\| Taxable \\| \\| --- \\| --- \\| \\| Description \\| A boolean indicating if the line_item is taxable or non-taxable \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Taxable \| \| Description \| A boolean indicating if the line_item is taxable or non-taxable \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| taxable |
| \| Field label \| Taxable \| \| --- \| --- \| \| Description \| A boolean indicating if the line_item is taxable or non-taxable \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Taxable |
| Description | A boolean indicating if the line_item is taxable or non-taxable |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| unit_price_includes_tax \| \| --- \| \| \\| Field label \\| Unit price includes tax \\| \\| --- \\| --- \\| \\| Description \\| A boolean indicator if tax is included in the price of an item \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Unit price includes tax \| \| Description \| A boolean indicator if tax is included in the price of an item \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| unit_price_includes_tax |
| \| Field label \| Unit price includes tax \| \| --- \| --- \| \| Description \| A boolean indicator if tax is included in the price of an item \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Unit price includes tax |
| Description | A boolean indicator if tax is included in the price of an item |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| item_unit_price \| \| --- \| \| \\| Field label \\| Item unit price \\| \\| --- \\| --- \\| \\| Description \\| The unit price of the line_item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item unit price \| \| Description \| The unit price of the line_item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_unit_price |
| \| Field label \| Item unit price \| \| --- \| --- \| \| Description \| The unit price of the line_item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item unit price |
| Description | The unit price of the line_item |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_original_price \| \| --- \| \| \\| Field label \\| Item original price \\| \\| --- \\| --- \\| \\| Description \\| The original price of the line_item without discounts or taxes \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item original price \| \| Description \| The original price of the line_item without discounts or taxes \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_original_price |
| \| Field label \| Item original price \| \| --- \| --- \| \| Description \| The original price of the line_item without discounts or taxes \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item original price |
| Description | The original price of the line_item without discounts or taxes |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_quantity \| \| --- \| \| \\| Field label \\| Item quantity \\| \\| --- \\| --- \\| \\| Description \\| The quantity of the line_item \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Item quantity \| \| Description \| The quantity of the line_item \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| item_quantity |
| \| Field label \| Item quantity \| \| --- \| --- \| \| Description \| The quantity of the line_item \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Item quantity |
| Description | The quantity of the line_item |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| item_tax_due \| \| --- \| \| \\| Field label \\| Item tax due \\| \\| --- \\| --- \\| \\| Description \\| The total tax due associated with the line_item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item tax due \| \| Description \| The total tax due associated with the line_item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_tax_due |
| \| Field label \| Item tax due \| \| --- \| --- \| \| Description \| The total tax due associated with the line_item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item tax due |
| Description | The total tax due associated with the line_item |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_taxable_amount \| \| --- \| \| \\| Field label \\| Item taxable amount \\| \\| --- \\| --- \\| \\| Description \\| The taxable revenue associated with the line_item \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item taxable amount \| \| Description \| The taxable revenue associated with the line_item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_taxable_amount |
| \| Field label \| Item taxable amount \| \| --- \| --- \| \| Description \| The taxable revenue associated with the line_item \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item taxable amount |
| Description | The taxable revenue associated with the line_item |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_total_price \| \| --- \| \| \\| Field label \\| Item total price \\| \\| --- \\| --- \\| \\| Description \\| The total price of the line_item including tax \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Item total price \| \| Description \| The total price of the line_item including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| item_total_price |
| \| Field label \| Item total price \| \| --- \| --- \| \| Description \| The total price of the line_item including tax \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Item total price |
| Description | The total price of the line_item including tax |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| item_grams \| \| --- \| \| \\| Field label \\| Item grams \\| \\| --- \\| --- \\| \\| Description \\| The weight of the item in grams \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Item grams \| \| Description \| The weight of the item in grams \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| item_grams |
| \| Field label \| Item grams \| \| --- \| --- \| \| Description \| The weight of the item in grams \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Item grams |
| Description | The weight of the item in grams |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

### ORDER

| \| order_id \| \| --- \| \| \\| Field label \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| The unique numeric identifier for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order ID \| \| Description \| The unique numeric identifier for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| order_id |
| \| Field label \| Order ID \| \| --- \| --- \| \| Description \| The unique numeric identifier for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order ID |
| Description | The unique numeric identifier for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_type \| \| --- \| \| \\| Field label \\| Order type \\| \\| --- \\| --- \\| \\| Description \\| An indicator of the order’s type \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order type \| \| Description \| An indicator of the order’s type \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_type |
| \| Field label \| Order type \| \| --- \| --- \| \| Description \| An indicator of the order’s type \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order type |
| Description | An indicator of the order’s type |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_status \| \| --- \| \| \\| Field label \\| Order status \\| \\| --- \\| --- \\| \\| Description \\| The status of creating the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order status \| \| Description \| The status of creating the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_status |
| \| Field label \| Order status \| \| --- \| --- \| \| Description \| The status of creating the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order status |
| Description | The status of creating the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_currency \| \| --- \| \| \\| Field label \\| Order currency \\| \\| --- \\| --- \\| \\| Description \\| The currency of the payment used to create the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Order currency \| \| Description \| The currency of the payment used to create the order \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| order_currency |
| \| Field label \| Order currency \| \| --- \| --- \| \| Description \| The currency of the payment used to create the order \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Order currency |
| Description | The currency of the payment used to create the order |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| order_tags \| \| --- \| \| \\| Field label \\| Order tags \\| \\| --- \\| --- \\| \\| Description \\| A comma separated list of tags on the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order tags \| \| Description \| A comma separated list of tags on the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_tags |
| \| Field label \| Order tags \| \| --- \| --- \| \| Description \| A comma separated list of tags on the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order tags |
| Description | A comma separated list of tags on the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_note \| \| --- \| \| \\| Field label \\| Order note \\| \\| --- \\| --- \\| \\| Description \\| Notes associated with the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order note \| \| Description \| Notes associated with the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_note |
| \| Field label \| Order note \| \| --- \| --- \| \| Description \| Notes associated with the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order note |
| Description | Notes associated with the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_is_prepaid \| \| --- \| \| \\| Field label \\| Order is prepaid \\| \\| --- \\| --- \\| \\| Description \\| A boolean representing if this order is generated from a prepaid purchase \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Order is prepaid \| \| Description \| A boolean representing if this order is generated from a prepaid purchase \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| order_is_prepaid |
| \| Field label \| Order is prepaid \| \| --- \| --- \| \| Description \| A boolean representing if this order is generated from a prepaid purchase \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Order is prepaid |
| Description | A boolean representing if this order is generated from a prepaid purchase |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_is_taxable \| \| --- \| \| \\| Field label \\| Order is taxable \\| \\| --- \\| --- \\| \\| Description \\| A boolean indicator of the taxability of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Order is taxable \| \| Description \| A boolean indicator of the taxability of the order \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| order_is_taxable |
| \| Field label \| Order is taxable \| \| --- \| --- \| \| Description \| A boolean indicator of the taxability of the order \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Order is taxable |
| Description | A boolean indicator of the taxability of the order |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| total_line_items_price \| \| --- \| \| \\| Field label \\| Total line items price \\| \\| --- \\| --- \\| \\| Description \\| The total price of all line items of the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total line items price \| \| Description \| The total price of all line items of the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_line_items_price |
| \| Field label \| Total line items price \| \| --- \| --- \| \| Description \| The total price of all line items of the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total line items price |
| Description | The total price of all line items of the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| subtotal_price \| \| --- \| \| \\| Field label \\| Subtotal price \\| \\| --- \\| --- \\| \\| Description \\| The subtotal price (sum of all line items * their quantity) of the order less discounts \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Subtotal price \| \| Description \| The subtotal price (sum of all line items * their quantity) of the order less discounts \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| subtotal_price |
| \| Field label \| Subtotal price \| \| --- \| --- \| \| Description \| The subtotal price (sum of all line items * their quantity) of the order less discounts \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Subtotal price |
| Description | The subtotal price (sum of all line items * their quantity) of the order less discounts |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_price \| \| --- \| \| \\| Field label \\| Total price \\| \\| --- \\| --- \\| \\| Description \\| The total amount due of the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total price \| \| Description \| The total amount due of the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_price |
| \| Field label \| Total price \| \| --- \| --- \| \| Description \| The total amount due of the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total price |
| Description | The total amount due of the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_refunds \| \| --- \| \| \\| Field label \\| Total refunds \\| \\| --- \\| --- \\| \\| Description \\| The total amount of refunds associated with the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total refunds \| \| Description \| The total amount of refunds associated with the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_refunds |
| \| Field label \| Total refunds \| \| --- \| --- \| \| Description \| The total amount of refunds associated with the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total refunds |
| Description | The total amount of refunds associated with the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_tax \| \| --- \| \| \\| Field label \\| Total tax \\| \\| --- \\| --- \\| \\| Description \\| The total tax due associated with the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total tax \| \| Description \| The total tax due associated with the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_tax |
| \| Field label \| Total tax \| \| --- \| --- \| \| Description \| The total tax due associated with the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total tax |
| Description | The total tax due associated with the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_discounts \| \| --- \| \| \\| Field label \\| Total discounts \\| \\| --- \\| --- \\| \\| Description \\| The total discounted value of the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total discounts \| \| Description \| The total discounted value of the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_discounts |
| \| Field label \| Total discounts \| \| --- \| --- \| \| Description \| The total discounted value of the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total discounts |
| Description | The total discounted value of the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_duties \| \| --- \| \| \\| Field label \\| Total duties \\| \\| --- \\| --- \\| \\| Description \\| The total cost of duties for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Total duties \| \| Description \| The total cost of duties for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_duties |
| \| Field label \| Total duties \| \| --- \| --- \| \| Description \| The total cost of duties for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Total duties |
| Description | The total cost of duties for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_weight_grams \| \| --- \| \| \\| Field label \\| Total weight grams \\| \\| --- \\| --- \\| \\| Description \\| The total weight of the order in grams \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Total weight grams \| \| Description \| The total weight of the order in grams \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| total_weight_grams |
| \| Field label \| Total weight grams \| \| --- \| --- \| \| Description \| The total weight of the order in grams \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Total weight grams |
| Description | The total weight of the order in grams |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| orders \| \| --- \| \| \\| Field label \\| Orders \\| \\| --- \\| --- \\| \\| Description \\| The number of orders \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Orders \| \| Description \| The number of orders \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| orders |
| \| Field label \| Orders \| \| --- \| --- \| \| Description \| The number of orders \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Orders |
| Description | The number of orders |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

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

### SHIPPING

| \| shipping_first_name \| \| --- \| \| \\| Field label \\| Shipping first name \\| \\| --- \\| --- \\| \\| Description \\| The first name for the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping first name \| \| Description \| The first name for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| shipping_first_name |
| \| Field label \| Shipping first name \| \| --- \| --- \| \| Description \| The first name for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping first name |
| Description | The first name for the shipping address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_last_name \| \| --- \| \| \\| Field label \\| Shipping last name \\| \\| --- \\| --- \\| \\| Description \\| The last name for the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping last name \| \| Description \| The last name for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_last_name |
| \| Field label \| Shipping last name \| \| --- \| --- \| \| Description \| The last name for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping last name |
| Description | The last name for the shipping address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_company \| \| --- \| \| \\| Field label \\| Shipping company \\| \\| --- \\| --- \\| \\| Description \\| The company name for the shipping address, if applicable \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping company \| \| Description \| The company name for the shipping address, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_company |
| \| Field label \| Shipping company \| \| --- \| --- \| \| Description \| The company name for the shipping address, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping company |
| Description | The company name for the shipping address, if applicable |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_address_1 \| \| --- \| \| \\| Field label \\| Shipping address 1 \\| \\| --- \\| --- \\| \\| Description \\| The primary street address for shipping \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping address 1 \| \| Description \| The primary street address for shipping \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| shipping_address_1 |
| \| Field label \| Shipping address 1 \| \| --- \| --- \| \| Description \| The primary street address for shipping \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping address 1 |
| Description | The primary street address for shipping |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| shipping_address_2 \| \| --- \| \| \\| Field label \\| Shipping address 2 \\| \\| --- \\| --- \\| \\| Description \\| The secondary street address for shipping, if applicable \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping address 2 \| \| Description \| The secondary street address for shipping, if applicable \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| shipping_address_2 |
| \| Field label \| Shipping address 2 \| \| --- \| --- \| \| Description \| The secondary street address for shipping, if applicable \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping address 2 |
| Description | The secondary street address for shipping, if applicable |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| shipping_city \| \| --- \| \| \\| Field label \\| Shipping city \\| \\| --- \\| --- \\| \\| Description \\| The city for the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping city \| \| Description \| The city for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| shipping_city |
| \| Field label \| Shipping city \| \| --- \| --- \| \| Description \| The city for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping city |
| Description | The city for the shipping address |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| shipping_zip \| \| --- \| \| \\| Field label \\| Shipping zip \\| \\| --- \\| --- \\| \\| Description \\| The postal code or ZIP code for the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.zip](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping zip \| \| Description \| The postal code or ZIP code for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| shipping_zip |
| \| Field label \| Shipping zip \| \| --- \| --- \| \| Description \| The postal code or ZIP code for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping zip |
| Description | The postal code or ZIP code for the shipping address |
| Field type | dimension |
| Data type | [string.geo.zip](/apidocs/field-data-types#geographical) |
| \| shipping_province \| \| --- \| \| \\| Field label \\| Shipping province \\| \\| --- \\| --- \\| \\| Description \\| The province or state for the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping province \| \| Description \| The province or state for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shipping_province |
| \| Field label \| Shipping province \| \| --- \| --- \| \| Description \| The province or state for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Shipping province |
| Description | The province or state for the shipping address |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shipping_country_code \| \| --- \| \| \\| Field label \\| Shipping country code \\| \\| --- \\| --- \\| \\| Description \\| The country code for the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Shipping country code \| \| Description \| The country code for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| shipping_country_code |
| \| Field label \| Shipping country code \| \| --- \| --- \| \| Description \| The country code for the shipping address \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Field label | Shipping country code |
| Description | The country code for the shipping address |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| shipping_phone \| \| --- \| \| \\| Field label \\| Shipping phone \\| \\| --- \\| --- \\| \\| Description \\| The phone number associated with the shipping address \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Field label \| Shipping phone \| \| Description \| The phone number associated with the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| shipping_phone |
| \| Field label \| Shipping phone \| \| --- \| --- \| \| Description \| The phone number associated with the shipping address \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Field label | Shipping phone |
| Description | The phone number associated with the shipping address |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |

### STORE

| \| store_name \| \| --- \| \| \\| Field label \\| Store name \\| \\| --- \\| --- \\| \\| Description \\| The name of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Store name \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| store_name |
| \| Field label \| Store name \| \| --- \| --- \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Store name |
| Description | The name of the store |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### SUBSCRIPTION

| \| subscription_id \| \| --- \| \| \\| Field label \\| Subscription ID \\| \\| --- \\| --- \\| \\| Description \\| Unique numeric identifier for the subscription \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Subscription ID \| \| Description \| Unique numeric identifier for the subscription \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| subscription_id |
| \| Field label \| Subscription ID \| \| --- \| --- \| \| Description \| Unique numeric identifier for the subscription \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Subscription ID |
| Description | Unique numeric identifier for the subscription |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| status \| \| --- \| \| \\| Field label \\| Status \\| \\| --- \\| --- \\| \\| Description \\| The status of the subscription \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Status \| \| Description \| The status of the subscription \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| status |
| \| Field label \| Status \| \| --- \| --- \| \| Description \| The status of the subscription \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Status |
| Description | The status of the subscription |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_title \| \| --- \| \| \\| Field label \\| Product title \\| \\| --- \\| --- \\| \\| Description \\| The name of the product in a store’s catalog \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Product title \| \| Description \| The name of the product in a store’s catalog \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_title |
| \| Field label \| Product title \| \| --- \| --- \| \| Description \| The name of the product in a store’s catalog \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Product title |
| Description | The name of the product in a store’s catalog |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| variant_title \| \| --- \| \| \\| Field label \\| Variant title \\| \\| --- \\| --- \\| \\| Description \\| The name of the variant in a shop’s catalog \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Variant title \| \| Description \| The name of the variant in a shop’s catalog \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| variant_title |
| \| Field label \| Variant title \| \| --- \| --- \| \| Description \| The name of the variant in a shop’s catalog \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Variant title |
| Description | The name of the variant in a shop’s catalog |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| product_sku \| \| --- \| \| \\| Field label \\| SKU \\| \\| --- \\| --- \\| \\| Description \\| A unique identifier of the item in the fulfillment. In cases where SKU is blank, it will be dynamically pulled whenever it is used \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| SKU \| \| Description \| A unique identifier of the item in the fulfillment. In cases where SKU is blank, it will be dynamically pulled whenever it is used \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_sku |
| \| Field label \| SKU \| \| --- \| --- \| \| Description \| A unique identifier of the item in the fulfillment. In cases where SKU is blank, it will be dynamically pulled whenever it is used \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | SKU |
| Description | A unique identifier of the item in the fulfillment. In cases where SKU is blank, it will be dynamically pulled whenever it is used |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| cancellation_reason \| \| --- \| \| \\| Field label \\| Cancellation reason \\| \\| --- \\| --- \\| \\| Description \\| Reason provided for cancellation \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Cancellation reason \| \| Description \| Reason provided for cancellation \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| cancellation_reason |
| \| Field label \| Cancellation reason \| \| --- \| --- \| \| Description \| Reason provided for cancellation \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Cancellation reason |
| Description | Reason provided for cancellation |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| cancellation_reason_comments \| \| --- \| \| \\| Field label \\| Cancellation reason comments \\| \\| --- \\| --- \\| \\| Description \\| Additional comment for cancellation. Maximum length is 1024 characters \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Cancellation reason comments \| \| Description \| Additional comment for cancellation. Maximum length is 1024 characters \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| cancellation_reason_comments |
| \| Field label \| Cancellation reason comments \| \| --- \| --- \| \| Description \| Additional comment for cancellation. Maximum length is 1024 characters \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Cancellation reason comments |
| Description | Additional comment for cancellation. Maximum length is 1024 characters |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| expire_after_specific_number_of_charges \| \| --- \| \| \\| Field label \\| Expire after specific number of charges \\| \\| --- \\| --- \\| \\| Description \\| Set the number of charges until subscription expires \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Expire after specific number of charges \| \| Description \| Set the number of charges until subscription expires \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| expire_after_specific_number_of_charges |
| \| Field label \| Expire after specific number of charges \| \| --- \| --- \| \| Description \| Set the number of charges until subscription expires \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Expire after specific number of charges |
| Description | Set the number of charges until subscription expires |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| has_queue_charges \| \| --- \| \| \\| Field label \\| Has queue charges \\| \\| --- \\| --- \\| \\| Description \\| Retrieves true if there is queued charge. Otherwise, retrieves false \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Has queue charges \| \| Description \| Retrieves true if there is queued charge. Otherwise, retrieves false \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| has_queue_charges |
| \| Field label \| Has queue charges \| \| --- \| --- \| \| Description \| Retrieves true if there is queued charge. Otherwise, retrieves false \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Has queue charges |
| Description | Retrieves true if there is queued charge. Otherwise, retrieves false |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| is_prepaid \| \| --- \| \| \\| Field label \\| Is prepaid \\| \\| --- \\| --- \\| \\| Description \\| Value is set to true if it is a prepaid item \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Is prepaid \| \| Description \| Value is set to true if it is a prepaid item \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| is_prepaid |
| \| Field label \| Is prepaid \| \| --- \| --- \| \| Description \| Value is set to true if it is a prepaid item \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Is prepaid |
| Description | Value is set to true if it is a prepaid item |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| is_swappable \| \| --- \| \| \\| Field label \\| Is swappable \\| \\| --- \\| --- \\| \\| Description \\| Value is set to true if it is not a prepaid item and if in customer portal settings swap is allowed for customers \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Is swappable \| \| Description \| Value is set to true if it is not a prepaid item and if in customer portal settings swap is allowed for customers \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| is_swappable |
| \| Field label \| Is swappable \| \| --- \| --- \| \| Description \| Value is set to true if it is not a prepaid item and if in customer portal settings swap is allowed for customers \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Is swappable |
| Description | Value is set to true if it is not a prepaid item and if in customer portal settings swap is allowed for customers |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| max_retries_reached \| \| --- \| \| \\| Field label \\| Max retries reached \\| \\| --- \\| --- \\| \\| Description \\| Retrieves true if charge has an error max retries reached. Otherwise, retrieves false \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Max retries reached \| \| Description \| Retrieves true if charge has an error max retries reached. Otherwise, retrieves false \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| max_retries_reached |
| \| Field label \| Max retries reached \| \| --- \| --- \| \| Description \| Retrieves true if charge has an error max retries reached. Otherwise, retrieves false \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Field label | Max retries reached |
| Description | Retrieves true if charge has an error max retries reached. Otherwise, retrieves false |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| next_charge_scheduled_at \| \| --- \| \| \\| Field label \\| Next charge scheduled at \\| \\| --- \\| --- \\| \\| Description \\| Date of the next charge for the subscription \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Next charge scheduled at \| \| Description \| Date of the next charge for the subscription \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| next_charge_scheduled_at |
| \| Field label \| Next charge scheduled at \| \| --- \| --- \| \| Description \| Date of the next charge for the subscription \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Next charge scheduled at |
| Description | Date of the next charge for the subscription |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| order_interval_unit \| \| --- \| \| \\| Field label \\| Order interval unit \\| \\| --- \\| --- \\| \\| Description \\| The frequency unit used to determine when a subscription’s order is created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Order interval unit \| \| Description \| The frequency unit used to determine when a subscription’s order is created \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_interval_unit |
| \| Field label \| Order interval unit \| \| --- \| --- \| \| Description \| The frequency unit used to determine when a subscription’s order is created \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Order interval unit |
| Description | The frequency unit used to determine when a subscription’s order is created |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| presentment_currency \| \| --- \| \| \\| Field label \\| Presentment currency \\| \\| --- \\| --- \\| \\| Description \\| The presentment currency of the subscription \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Presentment currency \| \| Description \| The presentment currency of the subscription \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| presentment_currency |
| \| Field label \| Presentment currency \| \| --- \| --- \| \| Description \| The presentment currency of the subscription \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Presentment currency |
| Description | The presentment currency of the subscription |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| price \| \| --- \| \| \\| Field label \\| Price \\| \\| --- \\| --- \\| \\| Description \\| The price of the item before discounts, taxes, or shipping have been applied \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Price \| \| Description \| The price of the item before discounts, taxes, or shipping have been applied \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| price |
| \| Field label \| Price \| \| --- \| --- \| \| Description \| The price of the item before discounts, taxes, or shipping have been applied \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Price |
| Description | The price of the item before discounts, taxes, or shipping have been applied |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| quantity \| \| --- \| \| \\| Field label \\| Quantity \\| \\| --- \\| --- \\| \\| Description \\| The number of items in the subscription \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Quantity \| \| Description \| The number of items in the subscription \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| quantity |
| \| Field label \| Quantity \| \| --- \| --- \| \| Description \| The number of items in the subscription \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Quantity |
| Description | The number of items in the subscription |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| charge_interval_frequency \| \| --- \| \| \\| Field label \\| Charge interval frequency \\| \\| --- \\| --- \\| \\| Description \\| The number of units (specified in order_interval_unit) between each charge. For example, order_interval_unit=month and charge_interval_frequency=3, indicate charge every 3 months \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Charge interval frequency \| \| Description \| The number of units (specified in order_interval_unit) between each charge. For example, order_interval_unit=month and charge_interval_frequency=3, indicate charge every 3 months \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| charge_interval_frequency |
| \| Field label \| Charge interval frequency \| \| --- \| --- \| \| Description \| The number of units (specified in order_interval_unit) between each charge. For example, order_interval_unit=month and charge_interval_frequency=3, indicate charge every 3 months \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Charge interval frequency |
| Description | The number of units (specified in order_interval_unit) between each charge. For example, order_interval_unit=month and charge_interval_frequency=3, indicate charge every 3 months |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| order_interval_frequency \| \| --- \| \| \\| Field label \\| Order interval frequency \\| \\| --- \\| --- \\| \\| Description \\| The number of units (specified in order_interval_unit) between each order. For example, order_interval_unit=month and order_interval_frequency=3, indicate order every 3 months. Max value: 1000 \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Order interval frequency \| \| Description \| The number of units (specified in order_interval_unit) between each order. For example, order_interval_unit=month and order_interval_frequency=3, indicate order every 3 months. Max value: 1000 \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| order_interval_frequency |
| \| Field label \| Order interval frequency \| \| --- \| --- \| \| Description \| The number of units (specified in order_interval_unit) between each order. For example, order_interval_unit=month and order_interval_frequency=3, indicate order every 3 months. Max value: 1000 \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Order interval frequency |
| Description | The number of units (specified in order_interval_unit) between each order. For example, order_interval_unit=month and order_interval_frequency=3, indicate order every 3 months. Max value: 1000 |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| subscriptions \| \| --- \| \| \\| Field label \\| Subscriptions \\| \\| --- \\| --- \\| \\| Description \\| The number of subscriptions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Subscriptions \| \| Description \| The number of subscriptions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| subscriptions |
| \| Field label \| Subscriptions \| \| --- \| --- \| \| Description \| The number of subscriptions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Subscriptions |
| Description | The number of subscriptions |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

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

| \| created_date \| \| --- \| \| \\| Field label \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| The date when the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Created date \| \| Description \| The date when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| created_date |
| \| Field label \| Created date \| \| --- \| --- \| \| Description \| The date when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Created date |
| Description | The date when the order was created |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| created_datetime \| \| --- \| \| \\| Field label \\| Created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time when the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Created datetime \| \| Description \| The date and time when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| created_datetime |
| \| Field label \| Created datetime \| \| --- \| --- \| \| Description \| The date and time when the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Created datetime |
| Description | The date and time when the order was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| updated_date \| \| --- \| \| \\| Field label \\| Updated date \\| \\| --- \\| --- \\| \\| Description \\| The date when the order was last updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Updated date \| \| Description \| The date when the order was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| updated_date |
| \| Field label \| Updated date \| \| --- \| --- \| \| Description \| The date when the order was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Updated date |
| Description | The date when the order was last updated |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| updated_datetime \| \| --- \| \| \\| Field label \\| Updated datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time when the order was last updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Updated datetime \| \| Description \| The date and time when the order was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| updated_datetime |
| \| Field label \| Updated datetime \| \| --- \| --- \| \| Description \| The date and time when the order was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Updated datetime |
| Description | The date and time when the order was last updated |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| processed_date \| \| --- \| \| \\| Field label \\| Processed date \\| \\| --- \\| --- \\| \\| Description \\| The date when the charge was processed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Processed date \| \| Description \| The date when the charge was processed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| processed_date |
| \| Field label \| Processed date \| \| --- \| --- \| \| Description \| The date when the charge was processed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Processed date |
| Description | The date when the charge was processed |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| processed_datetime \| \| --- \| \| \\| Field label \\| Processed datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time when the charge was processed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Processed datetime \| \| Description \| The date and time when the charge was processed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| processed_datetime |
| \| Field label \| Processed datetime \| \| --- \| --- \| \| Description \| The date and time when the charge was processed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Processed datetime |
| Description | The date and time when the charge was processed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| cancelled_date \| \| --- \| \| \\| Field label \\| Cancelled date \\| \\| --- \\| --- \\| \\| Description \\| The date when the subscription was cancelled \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Cancelled date \| \| Description \| The date when the subscription was cancelled \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| cancelled_date |
| \| Field label \| Cancelled date \| \| --- \| --- \| \| Description \| The date when the subscription was cancelled \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Cancelled date |
| Description | The date when the subscription was cancelled |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| cancelled_datetime \| \| --- \| \| \\| Field label \\| Cancelled datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time when the subscription was cancelled \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Cancelled datetime \| \| Description \| The date and time when the subscription was cancelled \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| cancelled_datetime |
| \| Field label \| Cancelled datetime \| \| --- \| --- \| \| Description \| The date and time when the subscription was cancelled \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Cancelled datetime |
| Description | The date and time when the subscription was cancelled |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |