---
title: "Shopify data warehouse table groups"
slug: "shopify-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for Shopify. See all the tables and the fields included in them."
updated: 2026-05-26T09:00:35Z
published: 2026-05-26T09:00:35Z
canonical: "docs.supermetrics.com/shopify-data-warehouse-table-groups"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Shopify data warehouse table groups

Search fields

### Table: SALES

| \| customer_city \| \| --- \| \| \\| Display name \\| City \\| \\| --- \\| --- \\| \\| Description \\| The city of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| City \| \| Description \| The city of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| --- |
| customer_city |
| \| Display name \| City \| \| --- \| --- \| \| Description \| The city of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Display name | City |
| Description | The city of the customer |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| customer_country \| \| --- \| \| \\| Display name \\| Country \\| \\| --- \\| --- \\| \\| Description \\| The country of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Country \| \| Description \| The country of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| customer_country |
| \| Display name \| Country \| \| --- \| --- \| \| Description \| The country of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Display name | Country |
| Description | The country of the customer |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| customer_country_code \| \| --- \| \| \\| Display name \\| Country code \\| \\| --- \\| --- \\| \\| Description \\| The country code of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Country code \| \| Description \| The country code of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| customer_country_code |
| \| Display name \| Country code \| \| --- \| --- \| \| Description \| The country code of the customer \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Display name | Country code |
| Description | The country code of the customer |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| customer_created_at \| \| --- \| \| \\| Display name \\| Account created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the customer was added to the online store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Account created datetime \| \| Description \| The date and time the customer was added to the online store \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| customer_created_at |
| \| Display name \| Account created datetime \| \| --- \| --- \| \| Description \| The date and time the customer was added to the online store \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Account created datetime |
| Description | The date and time the customer was added to the online store |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| customer_email \| \| --- \| \| \\| Display name \\| Email \\| \\| --- \\| --- \\| \\| Description \\| The email of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Email \| \| Description \| The email of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| customer_email |
| \| Display name \| Email \| \| --- \| --- \| \| Description \| The email of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Email |
| Description | The email of the customer |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| customer_first_name \| \| --- \| \| \\| Display name \\| First name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| First name \| \| Description \| The first name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_first_name |
| \| Display name \| First name \| \| --- \| --- \| \| Description \| The first name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | First name |
| Description | The first name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_id \| \| --- \| \| \\| Display name \\| Customer ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Customer ID \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_id |
| \| Display name \| Customer ID \| \| --- \| --- \| \| Description \| The unique identifier of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Customer ID |
| Description | The unique identifier of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_last_name \| \| --- \| \| \\| Display name \\| Last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the customer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Last name \| \| Description \| The last name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_last_name |
| \| Display name \| Last name \| \| --- \| --- \| \| Description \| The last name of the customer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Last name |
| Description | The last name of the customer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| customer_last_order_created_at \| \| --- \| \| \\| Display name \\| Last order created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the last order of the customer was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Last order created datetime \| \| Description \| The date and time the last order of the customer was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| customer_last_order_created_at |
| \| Display name \| Last order created datetime \| \| --- \| --- \| \| Description \| The date and time the last order of the customer was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Last order created datetime |
| Description | The date and time the last order of the customer was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| customer_lifetime_duration \| \| --- \| \| \\| Display name \\| Account age in days \\| \\| --- \\| --- \\| \\| Description \\| The amount of days since the customer was first added to the online store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account age in days \| \| Description \| The amount of days since the customer was first added to the online store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| customer_lifetime_duration |
| \| Display name \| Account age in days \| \| --- \| --- \| \| Description \| The amount of days since the customer was first added to the online store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account age in days |
| Description | The amount of days since the customer was first added to the online store |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| dataSourceName |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date |
| \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| discounts \| \| --- \| \| \\| Display name \\| Discounts \\| \\| --- \\| --- \\| \\| Description \\| The total amount of discounts applied on the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Discounts \| \| Description \| The total amount of discounts applied on the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| discounts |
| \| Display name \| Discounts \| \| --- \| --- \| \| Description \| The total amount of discounts applied on the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Discounts |
| Description | The total amount of discounts applied on the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| gross_sales \| \| --- \| \| \\| Display name \\| Gross sales \\| \\| --- \\| --- \\| \\| Description \\| The total price for the line item without any discounts applied \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Gross sales \| \| Description \| The total price for the line item without any discounts applied \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| gross_sales |
| \| Display name \| Gross sales \| \| --- \| --- \| \| Description \| The total price for the line item without any discounts applied \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Gross sales |
| Description | The total price for the line item without any discounts applied |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| items \| \| --- \| \| \\| Display name \\| Items \\| \\| --- \\| --- \\| \\| Description \\| The amount of the line item. Please note that this field will be removed on 2025-01-30 \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Items \| \| Description \| The amount of the line item. Please note that this field will be removed on 2025-01-30 \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| items |
| \| Display name \| Items \| \| --- \| --- \| \| Description \| The amount of the line item. Please note that this field will be removed on 2025-01-30 \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Items |
| Description | The amount of the line item. Please note that this field will be removed on 2025-01-30 |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| line_item_id \| \| --- \| \| \\| Display name \\| Line item ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the line item row \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Line item ID \| \| Description \| ID of the line item row \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_id |
| \| Display name \| Line item ID \| \| --- \| --- \| \| Description \| ID of the line item row \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Line item ID |
| Description | ID of the line item row |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| line_item_is_gift_card \| \| --- \| \| \\| Display name \\| Is gift card \\| \\| --- \\| --- \\| \\| Description \\| Whether or not the line item is a gift card \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is gift card \| \| Description \| Whether or not the line item is a gift card \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| line_item_is_gift_card |
| \| Display name \| Is gift card \| \| --- \| --- \| \| Description \| Whether or not the line item is a gift card \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Is gift card |
| Description | Whether or not the line item is a gift card |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| line_item_type \| \| --- \| \| \\| Display name \\| Line item type \\| \\| --- \\| --- \\| \\| Description \\| Type classification by Supermetrics. Possible values are "Product", "Refund", "Order adjustment", and "Shipping" \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Line item type \| \| Description \| Type classification by Supermetrics. Possible values are "Product", "Refund", "Order adjustment", and "Shipping" \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| line_item_type |
| \| Display name \| Line item type \| \| --- \| --- \| \| Description \| Type classification by Supermetrics. Possible values are "Product", "Refund", "Order adjustment", and "Shipping" \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Line item type |
| Description | Type classification by Supermetrics. Possible values are "Product", "Refund", "Order adjustment", and "Shipping" |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| net_sales \| \| --- \| \| \\| Display name \\| Net sales \\| \\| --- \\| --- \\| \\| Description \\| The net sales of the line \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Net sales \| \| Description \| The net sales of the line \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| net_sales |
| \| Display name \| Net sales \| \| --- \| --- \| \| Description \| The net sales of the line \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Net sales |
| Description | The net sales of the line |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_cancelled_at \| \| --- \| \| \\| Display name \\| Order cancelled datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time of the order cancellation \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order cancelled datetime \| \| Description \| The date and time of the order cancellation \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_cancelled_at |
| \| Display name \| Order cancelled datetime \| \| --- \| --- \| \| Description \| The date and time of the order cancellation \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order cancelled datetime |
| Description | The date and time of the order cancellation |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_channel \| \| --- \| \| \\| Display name \\| Channel \\| \\| --- \\| --- \\| \\| Description \\| The sales channel of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel \| \| Description \| The sales channel of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_channel |
| \| Display name \| Channel \| \| --- \| --- \| \| Description \| The sales channel of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Channel |
| Description | The sales channel of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_closed_at \| \| --- \| \| \\| Display name \\| Order closed datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the order was closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order closed datetime \| \| Description \| The date and time the order was closed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_closed_at |
| \| Display name \| Order closed datetime \| \| --- \| --- \| \| Description \| The date and time the order was closed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order closed datetime |
| Description | The date and time the order was closed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_confirmed \| \| --- \| \| \\| Display name \\| Order confirmed \\| \\| --- \\| --- \\| \\| Description \\| Whether inventory has been reserved for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Order confirmed \| \| Description \| Whether inventory has been reserved for the order \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| order_confirmed |
| \| Display name \| Order confirmed \| \| --- \| --- \| \| Description \| Whether inventory has been reserved for the order \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Order confirmed |
| Description | Whether inventory has been reserved for the order |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_created_at \| \| --- \| \| \\| Display name \\| Order created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the order was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Order created datetime \| \| Description \| The date and time the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| order_created_at |
| \| Display name \| Order created datetime \| \| --- \| --- \| \| Description \| The date and time the order was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Order created datetime |
| Description | The date and time the order was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| order_currency_code \| \| --- \| \| \\| Display name \\| Currency \\| \\| --- \\| --- \\| \\| Description \\| ISO 4217 currency code for the order, e.g. USD \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Currency \| \| Description \| ISO 4217 currency code for the order, e.g. USD \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| order_currency_code |
| \| Display name \| Currency \| \| --- \| --- \| \| Description \| ISO 4217 currency code for the order, e.g. USD \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Display name | Currency |
| Description | ISO 4217 currency code for the order, e.g. USD |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| order_discount_code \| \| --- \| \| \\| Display name \\| Discount reason \\| \\| --- \\| --- \\| \\| Description \\| The reason for the applied order's item-level discount \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Discount reason \| \| Description \| The reason for the applied order's item-level discount \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_discount_code |
| \| Display name \| Discount reason \| \| --- \| --- \| \| Description \| The reason for the applied order's item-level discount \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Discount reason |
| Description | The reason for the applied order's item-level discount |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_display_fulfillment_status \| \| --- \| \| \\| Display name \\| Fulfillment status \\| \\| --- \\| --- \\| \\| Description \\| Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Fulfillment status \| \| Description \| Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_display_fulfillment_status |
| \| Display name \| Fulfillment status \| \| --- \| --- \| \| Description \| Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Fulfillment status |
| Description | Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_email \| \| --- \| \| \\| Display name \\| Order email \\| \\| --- \\| --- \\| \\| Description \\| The email associated with the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Order email \| \| Description \| The email associated with the order \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| order_email |
| \| Display name \| Order email \| \| --- \| --- \| \| Description \| The email associated with the order \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Order email |
| Description | The email associated with the order |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| order_fully_paid \| \| --- \| \| \\| Display name \\| Fully paid \\| \\| --- \\| --- \\| \\| Description \\| Whether the order is fully paid or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Fully paid \| \| Description \| Whether the order is fully paid or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| order_fully_paid |
| \| Display name \| Fully paid \| \| --- \| --- \| \| Description \| Whether the order is fully paid or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Fully paid |
| Description | Whether the order is fully paid or not |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_id \| \| --- \| \| \\| Display name \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order ID \| \| Description \| The unique identifier of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_id |
| \| Display name \| Order ID \| \| --- \| --- \| \| Description \| The unique identifier of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order ID |
| Description | The unique identifier of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_is_returning_customer \| \| --- \| \| \\| Display name \\| Is returning customer \\| \\| --- \\| --- \\| \\| Description \\| Whether the customer is returning or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is returning customer \| \| Description \| Whether the customer is returning or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| order_is_returning_customer |
| \| Display name \| Is returning customer \| \| --- \| --- \| \| Description \| Whether the customer is returning or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Is returning customer |
| Description | Whether the customer is returning or not |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_landing_page_url \| \| --- \| \| \\| Display name \\| Landing page URL \\| \\| --- \\| --- \\| \\| Description \\| The URL of the landing page \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Landing page URL \| \| Description \| The URL of the landing page \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| order_landing_page_url |
| \| Display name \| Landing page URL \| \| --- \| --- \| \| Description \| The URL of the landing page \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Landing page URL |
| Description | The URL of the landing page |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| order_location \| \| --- \| \| \\| Display name \\| Location name \\| \\| --- \\| --- \\| \\| Description \\| The location name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Location name \| \| Description \| The location name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_location |
| \| Display name \| Location name \| \| --- \| --- \| \| Description \| The location name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Location name |
| Description | The location name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_name \| \| --- \| \| \\| Display name \\| Order name \\| \\| --- \\| --- \\| \\| Description \\| The name of the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order name \| \| Description \| The name of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_name |
| \| Display name \| Order name \| \| --- \| --- \| \| Description \| The name of the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order name |
| Description | The name of the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_note \| \| --- \| \| \\| Display name \\| Order note \\| \\| --- \\| --- \\| \\| Description \\| The note on the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order note \| \| Description \| The note on the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_note |
| \| Display name \| Order note \| \| --- \| --- \| \| Description \| The note on the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order note |
| Description | The note on the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_referral_code \| \| --- \| \| \\| Display name \\| Referral code \\| \\| --- \\| --- \\| \\| Description \\| Referral code that led the customer making the order to the store. However this is set when a customer first enters the store. So if they have been to the store previously without a referral, then the referral code will stay empty even if they would later visit the store via a referral link \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Referral code \| \| Description \| Referral code that led the customer making the order to the store. However this is set when a customer first enters the store. So if they have been to the store previously without a referral, then the referral code will stay empty even if they would later visit the store via a referral link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_referral_code |
| \| Display name \| Referral code \| \| --- \| --- \| \| Description \| Referral code that led the customer making the order to the store. However this is set when a customer first enters the store. So if they have been to the store previously without a referral, then the referral code will stay empty even if they would later visit the store via a referral link \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Referral code |
| Description | Referral code that led the customer making the order to the store. However this is set when a customer first enters the store. So if they have been to the store previously without a referral, then the referral code will stay empty even if they would later visit the store via a referral link |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_referrer_url \| \| --- \| \| \\| Display name \\| Order referrer URL \\| \\| --- \\| --- \\| \\| Description \\| The web page the customer clicked a link on that sent them to the online store that led to the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Order referrer URL \| \| Description \| The web page the customer clicked a link on that sent them to the online store that led to the order \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| order_referrer_url |
| \| Display name \| Order referrer URL \| \| --- \| --- \| \| Description \| The web page the customer clicked a link on that sent them to the online store that led to the order \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Order referrer URL |
| Description | The web page the customer clicked a link on that sent them to the online store that led to the order |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| order_shipping_description \| \| --- \| \| \\| Display name \\| Shipping description \\| \\| --- \\| --- \\| \\| Description \\| Description of the shipping selected for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Shipping description \| \| Description \| Description of the shipping selected for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_shipping_description |
| \| Display name \| Shipping description \| \| --- \| --- \| \| Description \| Description of the shipping selected for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Shipping description |
| Description | Description of the shipping selected for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_utm_content \| \| --- \| \| \\| Display name \\| UTM content \\| \\| --- \\| --- \\| \\| Description \\| A/B testing and content-targeted ads to differentiate ads or links that point to the same URL \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| UTM content \| \| Description \| A/B testing and content-targeted ads to differentiate ads or links that point to the same URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_utm_content |
| \| Display name \| UTM content \| \| --- \| --- \| \| Description \| A/B testing and content-targeted ads to differentiate ads or links that point to the same URL \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | UTM content |
| Description | A/B testing and content-targeted ads to differentiate ads or links that point to the same URL |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_utm_medium \| \| --- \| \| \\| Display name \\| UTM medium \\| \\| --- \\| --- \\| \\| Description \\| The ad medium, such as email or cost-per-click (cpc) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| UTM medium \| \| Description \| The ad medium, such as email or cost-per-click (cpc) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_utm_medium |
| \| Display name \| UTM medium \| \| --- \| --- \| \| Description \| The ad medium, such as email or cost-per-click (cpc) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | UTM medium |
| Description | The ad medium, such as email or cost-per-click (cpc) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_utm_name \| \| --- \| \| \\| Display name \\| UTM campaign name \\| \\| --- \\| --- \\| \\| Description \\| The name that you give a promotion or campaign to identify it \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| UTM campaign name \| \| Description \| The name that you give a promotion or campaign to identify it \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_utm_name |
| \| Display name \| UTM campaign name \| \| --- \| --- \| \| Description \| The name that you give a promotion or campaign to identify it \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | UTM campaign name |
| Description | The name that you give a promotion or campaign to identify it |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_utm_source \| \| --- \| \| \\| Display name \\| UTM source \\| \\| --- \\| --- \\| \\| Description \\| Identifies a search engine, a newsletter name, or other source \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| UTM source \| \| Description \| Identifies a search engine, a newsletter name, or other source \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_utm_source |
| \| Display name \| UTM source \| \| --- \| --- \| \| Description \| Identifies a search engine, a newsletter name, or other source \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | UTM source |
| Description | Identifies a search engine, a newsletter name, or other source |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| order_utm_term \| \| --- \| \| \\| Display name \\| UTM term \\| \\| --- \\| --- \\| \\| Description \\| The keywords associated with an ad \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| UTM term \| \| Description \| The keywords associated with an ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_utm_term |
| \| Display name \| UTM term \| \| --- \| --- \| \| Description \| The keywords associated with an ad \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | UTM term |
| Description | The keywords associated with an ad |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| price \| \| --- \| \| \\| Display name \\| Price \\| \\| --- \\| --- \\| \\| Description \\| The price of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Price \| \| Description \| The price of the product \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| price |
| \| Display name \| Price \| \| --- \| --- \| \| Description \| The price of the product \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Price |
| Description | The price of the product |
| Field type | dimension |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| product_id \| \| --- \| \| \\| Display name \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product ID \| \| Description \| The unique identifier of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_id |
| \| Display name \| Product ID \| \| --- \| --- \| \| Description \| The unique identifier of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product ID |
| Description | The unique identifier of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| returns \| \| --- \| \| \\| Display name \\| Returns \\| \\| --- \\| --- \\| \\| Description \\| The total amount refunded for the order \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Returns \| \| Description \| The total amount refunded for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| returns |
| \| Display name \| Returns \| \| --- \| --- \| \| Description \| The total amount refunded for the order \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Returns |
| Description | The total amount refunded for the order |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shipping \| \| --- \| \| \\| Display name \\| Shipping \\| \\| --- \\| --- \\| \\| Description \\| The total shipping amount including returns \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Shipping \| \| Description \| The total shipping amount including returns \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| shipping |
| \| Display name \| Shipping \| \| --- \| --- \| \| Description \| The total shipping amount including returns \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Shipping |
| Description | The total shipping amount including returns |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| shop_id \| \| --- \| \| \\| Display name \\| Store ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Store ID \| \| Description \| The unique identifier of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shop_id |
| \| Display name \| Store ID \| \| --- \| --- \| \| Description \| The unique identifier of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Store ID |
| Description | The unique identifier of the store |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shop_name \| \| --- \| \| \\| Display name \\| Store name \\| \\| --- \\| --- \\| \\| Description \\| The name of the store \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Store name \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shop_name |
| \| Display name \| Store name \| \| --- \| --- \| \| Description \| The name of the store \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Store name |
| Description | The name of the store |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| sku \| \| --- \| \| \\| Display name \\| SKU \\| \\| --- \\| --- \\| \\| Description \\| Variant SKU number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| SKU \| \| Description \| Variant SKU number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| sku |
| \| Display name \| SKU \| \| --- \| --- \| \| Description \| Variant SKU number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | SKU |
| Description | Variant SKU number |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| tax \| \| --- \| \| \\| Display name \\| Tax \\| \\| --- \\| --- \\| \\| Description \\| The total amount of tax for the line. Takes returns into account \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Tax \| \| Description \| The total amount of tax for the line. Takes returns into account \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| tax |
| \| Display name \| Tax \| \| --- \| --- \| \| Description \| The total amount of tax for the line. Takes returns into account \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Tax |
| Description | The total amount of tax for the line. Takes returns into account |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| total_sales \| \| --- \| \| \\| Display name \\| Total sales \\| \\| --- \\| --- \\| \\| Description \\| The total sales for line \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Total sales \| \| Description \| The total sales for line \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| total_sales |
| \| Display name \| Total sales \| \| --- \| --- \| \| Description \| The total sales for line \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Total sales |
| Description | The total sales for line |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| variant_id \| \| --- \| \| \\| Display name \\| Variant ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the product variant \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Variant ID \| \| Description \| The unique identifier of the product variant \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| variant_id |
| \| Display name \| Variant ID \| \| --- \| --- \| \| Description \| The unique identifier of the product variant \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Variant ID |
| Description | The unique identifier of the product variant |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### Table: PRODUCT_LIST

| \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| dataSourceName |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| description \| \| --- \| \| \\| Display name \\| Description \\| \\| --- \\| --- \\| \\| Description \\| Description of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Description \| \| Description \| Description of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| description |
| \| Display name \| Description \| \| --- \| --- \| \| Description \| Description of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Description |
| Description | Description of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| image_src \| \| --- \| \| \\| Display name \\| Image URL \\| \\| --- \\| --- \\| \\| Description \\| The image URL of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Image URL \| \| Description \| The image URL of the product \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| image_src |
| \| Display name \| Image URL \| \| --- \| --- \| \| Description \| The image URL of the product \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Image URL |
| Description | The image URL of the product |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| price \| \| --- \| \| \\| Display name \\| Price \\| \\| --- \\| --- \\| \\| Description \\| The price of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Price \| \| Description \| The price of the product \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| price |
| \| Display name \| Price \| \| --- \| --- \| \| Description \| The price of the product \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Price |
| Description | The price of the product |
| Field type | dimension |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| product_created_at \| \| --- \| \| \\| Display name \\| Product created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the product was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Product created datetime \| \| Description \| The date and time the product was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| product_created_at |
| \| Display name \| Product created datetime \| \| --- \| --- \| \| Description \| The date and time the product was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Product created datetime |
| Description | The date and time the product was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| product_id \| \| --- \| \| \\| Display name \\| Product ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product ID \| \| Description \| The unique identifier of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| product_id |
| \| Display name \| Product ID \| \| --- \| --- \| \| Description \| The unique identifier of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product ID |
| Description | The unique identifier of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| sku \| \| --- \| \| \\| Display name \\| SKU \\| \\| --- \\| --- \\| \\| Description \\| Variant SKU number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| SKU \| \| Description \| Variant SKU number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| sku |
| \| Display name \| SKU \| \| --- \| --- \| \| Description \| Variant SKU number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | SKU |
| Description | Variant SKU number |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| title \| \| --- \| \| \\| Display name \\| Product title \\| \\| --- \\| --- \\| \\| Description \\| The title of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product title \| \| Description \| The title of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| title |
| \| Display name \| Product title \| \| --- \| --- \| \| Description \| The title of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product title |
| Description | The title of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| type \| \| --- \| \| \\| Display name \\| Type \\| \\| --- \\| --- \\| \\| Description \\| The type of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Type \| \| Description \| The type of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| type |
| \| Display name \| Type \| \| --- \| --- \| \| Description \| The type of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Type |
| Description | The type of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| variant_id \| \| --- \| \| \\| Display name \\| Variant ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the product variant \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Variant ID \| \| Description \| The unique identifier of the product variant \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| variant_id |
| \| Display name \| Variant ID \| \| --- \| --- \| \| Description \| The unique identifier of the product variant \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Variant ID |
| Description | The unique identifier of the product variant |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| variant_title \| \| --- \| \| \\| Display name \\| Variant title \\| \\| --- \\| --- \\| \\| Description \\| The title of the product variant \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Variant title \| \| Description \| The title of the product variant \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| variant_title |
| \| Display name \| Variant title \| \| --- \| --- \| \| Description \| The title of the product variant \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Variant title |
| Description | The title of the product variant |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| vendor \| \| --- \| \| \\| Display name \\| Vendor \\| \\| --- \\| --- \\| \\| Description \\| The vendor of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Vendor \| \| Description \| The vendor of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| vendor |
| \| Display name \| Vendor \| \| --- \| --- \| \| Description \| The vendor of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Vendor |
| Description | The vendor of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |