Shopify: Most-used fields#
The table below gives information about most-used fields that you can import from Shopify. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
abandoned_checkout_url Dimension
The URL of the abandoned checkout.
accepts_marketing_updated_at.date Dimension
The date part of when the customer's marketing consent was last updated.
active Dimension
Indicates if a resource, such as a discount or inventory item, is currently active.
address1 Dimension
The primary street address of the customer or location.
address2 Dimension
The secondary street address, such as an apartment or suite number, of the customer or location.
addresses.city Dimension
The city of the address.
addresses.country Dimension
The country of the address.
addresses.country_code Dimension
The two-letter country code (ISO 3166-1 alpha-2) of the address.
addresses.country_name Dimension
The full name of the country of the address.
addresses.customer_id Dimension
The unique identifier of the customer.
addresses.id Dimension
The unique identifier of the address.
addresses.zip Dimension
The zip or postal code of the address.
addresses.{NUM}.address1 Dimension
The first line of a customer's address.
addresses.{NUM}.address2 Dimension
The second line of a customer's address.
addresses.{NUM}.city Dimension
The city of a customer's address.
addresses.{NUM}.company Dimension
The company name associated with a customer's address.
addresses.{NUM}.country Dimension
The country of a customer's address.
addresses.{NUM}.country_code Dimension
The two-letter country code for a customer's address.
addresses.{NUM}.country_name Dimension
The normalized country name for a customer's address.
addresses.{NUM}.customer_id Dimension
The unique identifier for the customer associated with this address.
addresses.{NUM}.default Dimension
Indicates if this is the customer's default address.
addresses.{NUM}.first_name Dimension
The first name of the customer at this address.
addresses.{NUM}.id Metric
The unique identifier for the address.
addresses.{NUM}.last_name Dimension
The last name of the customer at this address.
addresses.{NUM}.name Dimension
The full name of the customer at this address.
addresses.{NUM}.phone Dimension
The phone number associated with the address.
addresses.{NUM}.province Dimension
The province, state, or region of the address.
addresses.{NUM}.province_code Dimension
The alphanumeric code for the province, state, or district of the address.
addresses.{NUM}.zip Dimension
The zip or postal code of the address.
admin_graphql_api_id Dimension
The unique identifier for the resource in the Shopify GraphQL Admin API.
amount Metric
A monetary amount associated with a transaction or a discount.
app_id Dimension
The unique identifier of the app that created the order.
authorization Dimension
The authorization code or token for a payment transaction.
available Metric
The quantity of an inventory item available at a specific location.
available_for_sale availableForSale Dimension
A boolean indicating whether the product variant is currently available for purchase by customers.
barcode Dimension
The barcode, UPC, or ISBN number associated with the product variant for inventory management and scanning.
billingAddress.countryCode Dimension
The two-letter ISO 3166-1 alpha-2 code for the country of the billing address associated with an order or customer.
billing_address Dimension
The billing address associated with the payment method selected by the customer for an order.
billing_address.address1 Dimension
The first line of the customer's billing address.
billing_address.address2 Dimension
The second line of the customer's billing address (optional).
billing_address.city Dimension
The city of the customer's billing address.
billing_address.company Dimension
The company name associated with the customer's billing address.
billing_address.country Dimension
The country of the customer's billing address.
billing_address.country_code Dimension
The two-letter country code (ISO 3166-1 alpha-2) of the customer's billing address.
billing_address.first_name Dimension
The first name of the customer for the billing address.
billing_address.last_name Dimension
The last name of the customer for the billing address.
billing_address.latitude Metric
The latitude coordinate of the billing address.
billing_address.longitude Metric
The longitude coordinate of the billing address.
billing_address.name Dimension
The full name of the customer for the billing address.
billing_address.phone Dimension
The phone number for the billing address.
billing_address.province Dimension
The province or state of the customer's billing address.
billing_address.province_code Dimension
The two-letter province or state code of the customer's billing address.
billing_address.zip Dimension
The zip or postal code of the customer's billing address.
body_html Dimension
The HTML content for the body of a resource, such as a product description or blog post content.
browser_ip Dimension
The IP address of the browser used by the customer when they placed the order.
buyer_accepts_marketing Dimension
Indicates whether the customer has consented to receive marketing updates from the shop.
buyer_accepts_sms_marketing Dimension
Indicates whether the customer has consented to receive SMS marketing messages.
cancel_reason Dimension
The reason provided for canceling the order.
cancelled_at Dimension
The date and time when the order was canceled.
cancelled_at.date Dimension
The date when the order was canceled.
cart_token Dimension
The unique token associated with the shopping cart that led to the order.
checkout_token Dimension
A unique value that references the checkout associated with an order.
city Dimension
The city of the address.
client_details Dimension
Information about the client (e.g., browser, IP address) used to place the order.
client_details.accept_language Dimension
The 'Accept-Language' header sent by the client's browser, indicating preferred languages.
client_details.browser_height Metric
The height of the client's browser window in pixels.
client_details.browser_ip Dimension
The IP address of the browser used by the customer when they placed the order.
client_details.browser_width Metric
The width of the client's browser window in pixels.
client_details.session_hash Dimension
A hash that identifies the client's browser session.
client_details.user_agent Dimension
The 'User-Agent' header sent by the client's browser, identifying the browser and operating system.
closed_at Dimension
The date and time when the order was closed.
closed_at.date Dimension
The date when the order was closed.
code Dimension
A generic code or identifier associated with a resource, such as a discount code.
collection.admin_graphql_api_id Dimension
The unique identifier for the collection in the Shopify GraphQL Admin API.
collection.body_html Dimension
The HTML content of the collection's description.
collection.collection_type Dimension
The type of collection (e.g., 'smart' for automated, 'custom' for manual).
collection.descriptionHtml Dimension
The HTML content of the collection's description.
collection.handle Dimension
A URL-friendly version of the collection's title.
collection.id Metric
The unique identifier for the collection.
collection.image Dimension
The image associated with the collection.
collection.products_count Metric
The total number of products within the collection.
collection.published_at Dimension
The date and time when the collection was published.
collection.published_at.date Dimension
The date when the collection was published.
collection.published_scope Dimension
The scope of where the collection is published (e.g., 'web').
collection.sortOrder Dimension
The order in which products in the collection are sorted.
collection.sort_order Dimension
The order in which products are sorted within the collection.
collection.templateSuffix Dimension
The suffix of the liquid template used to render the collection.
collection.template_suffix Dimension
The suffix of the liquid template file used to render the collection.
collection.title Dimension
The title of the collection.
collection.updatedAt Dimension
The date and time when the collection was last updated.
collection.updated_at Dimension
The date and time when the collection was last updated.
collection.updated_at.date Dimension
The date when the collection was last updated.
compare_at_price compareAtPrice Metric
The original price of the product variant used to indicate a sale price, where 'compare_at_price' is higher than the current selling price.
completed_at Dimension
The date and time when the checkout or order was completed.
completed_at.date Dimension
The date when the checkout or order was completed.
cost Metric
The cost per item of a product variant.
count Metric
A numerical value representing the total number of items, records, or occurrences of a specific entity or event. This is commonly used in reports and API queries.
country Dimension
The country of the address.
country_code Dimension
The two-letter country code (ISO 3166-1 alpha-2) of the address.
country_code_of_origin Dimension
The two-letter country code (ISO 3166-1 alpha-2) of the product's origin.
country_harmonized_system_codes.country_code Dimension
The country code for which a specific Harmonized System (HS) code applies.
country_harmonized_system_codes.harmonized_system_code Dimension
The Harmonized System (HS) code for a product variant in a specific country, used for international shipping and customs.
country_name Dimension
The full name of the country of the address.
createdAt Dimension
The date and time (ISO 8601 format) when the resource was created.
created_at Dimension
The date and time (ISO 8601 format) when the resource was created.
created_at.date Dimension
The date when the order or resource was created.
created_at_from_date Dimension
A filter for resources created on or after this date.
created_at_to_date Dimension
A filter for resources created on or before this date.
currency Dimension
The three-letter code (ISO 4217) for the currency.
currency_exchange_adjustment Dimension
Represents a currency exchange adjustment applied to an order transaction.
current_subtotal_price Metric
The current subtotal price of the order after discounts but before taxes and shipping.
current_subtotal_price_set Dimension
The current subtotal price of all line items in an order after returns, refunds, order edits, and cancellations, including amounts in both shop and presentment currencies.
current_total_additional_fees_set Dimension
The current total amount of all additional fees applied to an order, considering any subsequent returns or modifications.
current_total_discounts Metric
The current total amount of discounts applied to the order.
current_total_discounts_set Dimension
The total amount discounted on the entire order after returns, refunds, order edits, and cancellations, including amounts in both shop and presentment currencies. This includes both order and line level discounts.
current_total_duties_set Dimension
The sum of all duties (customs fees) on the order, in presentment and shop currencies.
current_total_price Metric
The current grand total price of the order, including taxes and shipping after all discounts.
current_total_price_set Dimension
The total price of the order, including duties, taxes, and shipping, in presentment and shop currencies.
current_total_tax Metric
The current total tax amount applied to the order.
current_total_tax_set Dimension
The total amount of taxes charged on the order, in presentment and shop currencies.
customer Dimension
Represents the customer associated with an order, including their contact details and marketing preferences.
customer.accepts_marketing Dimension
Indicates if the customer accepts marketing.
customer.accepts_marketing_updated_at Dimension
The date and time when the customer's marketing acceptance status was last updated.
customer.accepts_marketing_updated_at.date Dimension
The date when the customer's marketing acceptance status was last updated.
customer.admin_graphql_api_id Dimension
The unique identifier for the customer in the Shopify GraphQL Admin API.
customer.created_at Dimension
The date and time when the customer account was created.
customer.created_at.date Dimension
The date when the customer account was created.
customer.currency Dimension
The default currency associated with the customer.
customer.default_address.address1 Dimension
The first line of the customer's default shipping address.
customer.default_address.address2 Dimension
The second line of the customer's default shipping address.
customer.default_address.city Dimension
The city of the customer's default address.
customer.default_address.company Dimension
The company name associated with the customer's default address.
customer.default_address.country Dimension
The country of the customer's default address.
customer.default_address.country_code Dimension
The two-letter country code for the customer's default address.
customer.default_address.country_name Dimension
The normalized country name for the customer's default address.
customer.default_address.customer_id Dimension
The unique identifier of the customer to whom the default address belongs.
customer.default_address.default Dimension
Indicates if this address is the customer's default address.
customer.default_address.first_name Dimension
The first name of the customer at their default address.
customer.default_address.id Metric
A unique identifier for the customer's default address.
customer.default_address.last_name Dimension
The last name of the customer at their default address.
customer.default_address.name Dimension
The full name of the customer at their default address.
customer.default_address.phone Dimension
The phone number for the customer's default address.
customer.default_address.province Dimension
The province or state name for the customer's default address.
customer.default_address.province_code Dimension
The alphanumeric code for the province or state of the customer's default address.
customer.default_address.zip Dimension
The postal code for the customer's default address.
customer.email Dimension
The email address of the customer.
customer.email_marketing_consent Dimension
Whether the customer has consented to receive email marketing.
customer.email_marketing_consent.consent_updated_at Dimension
The date and time when the customer's email marketing consent was last updated.
customer.email_marketing_consent.consent_updated_at.date Dimension
The date when the customer's email marketing consent was last updated.
customer.email_marketing_consent.opt_in_level Dimension
The opt-in level for the customer's email marketing consent.
customer.email_marketing_consent.state Dimension
The current state of the customer's email marketing consent.
customer.first_name Dimension
The first name of the customer.
customer.id Metric
A unique identifier for the customer.
customer.last_name Dimension
The last name of the customer.
customer.last_order_id Dimension
The unique identifier of the customer's last order.
customer.last_order_name Dimension
The name of the customer's last order.
customer.marketing_opt_in_level Dimension
The marketing opt-in level for the customer.
customer.multipass_identifier Dimension
A unique identifier for the customer used with Multipass login, which should be consistent between the merchant's website and Shopify.
customer.note Dimension
A general note or comment associated with the customer.
customer.orders_count Metric
The total number of orders placed by the customer.
customer.phone Metric
The primary phone number of the customer.
customer.sms_marketing_consent Dimension
Whether the customer has consented to receive SMS marketing.
customer.sms_marketing_consent.consent_collected_from Dimension
The source from which the customer's SMS marketing consent was collected.
customer.sms_marketing_consent.consent_updated_at Dimension
The date and time when the customer's SMS marketing consent was last updated.
customer.sms_marketing_consent.consent_updated_at.date Dimension
The date when the customer's SMS marketing consent was last updated.
customer.sms_marketing_consent.opt_in_level Dimension
The opt-in level for the customer's SMS marketing consent.
customer.sms_marketing_consent.state Dimension
The current state of the customer's SMS marketing consent.
customer.state Dimension
The state or province of the customer's default address.
customer.tags Dimension
A list of tags associated with the customer.
customer.tax_exempt Dimension
Indicates if the customer is exempt from paying taxes.
customer.tax_exemptions Dimension
A list of tax exemptions applicable to the customer.
customer.total_spent Metric
The total amount of money the customer has spent across all orders.
customer.updated_at Dimension
The date and time when the customer's record was last updated.
customer.updated_at.date Dimension
The date when the customer's record was last updated.
customer.verified_email Dimension
Indicates whether the customer's email address has been verified.
customer_locale Dimension
The locale of the customer who placed the order (e.g., en-US).
date Dimension
The date and time when the application charge was created. This field captures the initiation timestamp of a one-time charge associated with an app.
default_address.address1 Dimension
The first line of the customer's default address.
default_address.address2 Dimension
The second line of the customer's default address.
default_address.city Dimension
The city of the customer's default address.
default_address.company Dimension
The company name associated with the customer's default address.
default_address.country Dimension
The country of the customer's default address.
default_address.country_code Dimension
The two-letter country code for the customer's default address.
default_address.country_name Dimension
The normalized country name for the customer's default address.
default_address.customer_id Dimension
The unique identifier for the customer associated with this default address.
default_address.default Dimension
Indicates that this is the customer's default address.
default_address.first_name Dimension
The first name of the customer at their default address.
default_address.id Dimension
The unique identifier for the customer's default address.
default_address.last_name Dimension
The last name of the customer at their default address.
default_address.name Dimension
The full name of the customer at their default address.
default_address.phone Dimension
The phone number associated with the customer's default address.
default_address.province Dimension
The province, state, or region of the customer's default address.
default_address.province_code Dimension
The alphanumeric code for the province, state, or district of the customer's default address.
default_address.zip Dimension
The zip or postal code of the customer's default address.
device_id Dimension
A unique identifier for the device used when the order was placed or checkout occurred.
discount_allocations Dimension
A list of discounts applied to the item or order.
discount_applications Dimension
Details about the specific discounts applied to the order, including their types and amounts.
discount_codes Dimension
A list of discount codes applied to the order.
discount_codes.{NUM}.amount Metric
The amount of the discount applied by the discount code.
discount_codes.{NUM}.code Dimension
The actual discount code entered by the customer.
discount_codes.{NUM}.type Dimension
The type of discount applied (e.g., fixed_amount, percentage).
duties Dimension
Information related to customs duties applied to an order's line item, including the amount, country of origin, and Harmonized System Code.
email Dimension
The customer's email address.
email_marketing_consent Dimension
Contains information about the customer's consent to receive email marketing, including their subscription state and opt-in level.
estimated_taxes Dimension
Indicates whether the taxes on the order are estimated.
financial_status Dimension
The financial status of the order (e.g., 'pending', 'paid', 'refunded').
first_name Dimension
The first name of the customer.
fulfillable_quantity Metric
The quantity of a line item that is still available to be fulfilled.
fulfillment_status Dimension
The fulfillment status of the order (e.g., 'null', 'partially_fulfilled', 'fulfilled').
fulfillments Dimension
A list of fulfillment details for the order.
fulfillments.created_at Dimension
The date and time when the fulfillment was created.
fulfillments.created_at.date Dimension
The date part of when the fulfillment was created.
fulfillments.id Dimension
A unique identifier for the fulfillment.
fulfillments.line_items.duties Dimension
A list of duties associated with the line item in the fulfillment.
fulfillments.line_items.fulfillable_quantity Dimension
The quantity of a line item that is available to be fulfilled.
fulfillments.line_items.id Dimension
The unique identifier of the line item within the fulfillment.
fulfillments.line_items.name Dimension
The name of the product or variant being fulfilled.
fulfillments.line_items.pre_tax_price Dimension
The price of the line item before taxes.
fulfillments.line_items.price Dimension
The price of the line item in the fulfillment before discounts are applied, in the shop's currency.
fulfillments.line_items.product_id Dimension
The unique numeric identifier for the product associated with the line item in the fulfillment.
fulfillments.line_items.properties Dimension
Additional properties associated with the line item.
fulfillments.line_items.quantity Dimension
The number of units of the line item included in the fulfillment.
fulfillments.line_items.requires_shipping Dimension
Indicates whether a specific line item within a fulfillment requires physical shipping.
fulfillments.line_items.sku Dimension
The Stock Keeping Unit (SKU) of the product variant being fulfilled.
fulfillments.line_items.tax_lines Dimension
A list of tax applications for the line item in the fulfillment, including amounts, rates, and titles.
fulfillments.line_items.taxable Dimension
Indicates whether the line item in the fulfillment is taxable.
fulfillments.line_items.title Dimension
The title of the product being fulfilled.
fulfillments.line_items.total_discount Dimension
The total discount applied to a specific line item within a fulfillment.
fulfillments.line_items.variant_id Dimension
The unique numeric identifier for the product variant of the line item in the fulfillment.
fulfillments.line_items.variant_inventory_management Dimension
The inventory management system for the product variant (e.g., 'shopify', 'null').
fulfillments.line_items.variant_title Dimension
The title of the product variant being fulfilled.
fulfillments.line_items.vendor Dimension
The vendor of the product being fulfilled.
fulfillments.location_id Dimension
The unique identifier of the location where the fulfillment was processed.
fulfillments.name Dimension
The name or identifier of the fulfillment.
fulfillments.order_id Dimension
The unique numeric identifier for the order associated with this fulfillment.
fulfillments.origin_address Dimension
The address from which the fulfillment was shipped.
fulfillments.receipt Dimension
A receipt object for the fulfillment, containing details like tracking numbers.
fulfillments.service Dimension
The fulfillment service used (e.g., 'manual', 'shopify').
fulfillments.shipment_status Dimension
The current status of the shipment (e.g., 'delivered', 'in_transit').
fulfillments.status Dimension
The current status of the fulfillment (e.g., 'success', 'pending', 'cancelled').
fulfillments.tracking_company Dimension
The name of the tracking company for the fulfillment.
fulfillments.tracking_number Dimension
A single tracking number for the fulfillment.
fulfillments.tracking_numbers Dimension
A list of tracking numbers for the fulfillment.
fulfillments.tracking_url Dimension
A single URL for tracking the fulfillment.
fulfillments.tracking_urls Dimension
A list of URLs for tracking the fulfillment.
fulfillments.updated_at Dimension
The date and time when the fulfillment was last updated.
fulfillments.updated_at.date Dimension
The date part of when the fulfillment was last updated.
gateway Dimension
The payment gateway used for the order (e.g., 'shopify_payments', 'bogus').
gift_card Dimension
Indicates if the product is a gift card.
grams Metric
The weight of the product variant in grams.
handle Dimension
A URL-friendly version of the product or collection title.
harmonized_system_code Dimension
The Harmonized System (HS) code for the product variant, used for international shipping and customs.
id Metric
The unique identifier for the order.
image Dimension
The primary image associated with a product or collection.
image.url Dimension
The URL of an image associated with a product or a line item.
images Dimension
A list of images associated with a product.
inventoryItem.id Metric
A unique identifier for a physical good or inventory item. Each product variant is associated with an inventory item.
inventoryItem.unitCost Dimension
The cost per unit of the inventory item in the shop's default currency.
inventoryItem.unitCost.amount Metric
The monetary amount of the unit cost for a specific inventory item.
inventoryItem.unitCost.currencyCode Dimension
The three-letter ISO 4217 currency code for the unit cost of a specific inventory item.
inventory_item.admin_graphql_api_id Dimension
The unique identifier for the inventory item in the Shopify GraphQL Admin API.
inventory_item.created_at Dimension
The date and time when the inventory item was created.
inventory_item.created_at.date Dimension
The date when the inventory item was created.
inventory_item.updated_at Dimension
The date and time when the inventory item was last updated.
inventory_item.updated_at.date Dimension
The date when the inventory item was last updated.
inventory_item_id Dimension
The unique identifier for the inventory item, which links a product variant to its stock information.
inventory_level.admin_graphql_api_id Dimension
The unique identifier for the inventory level in the Shopify GraphQL Admin API.
inventory_level.updated_at Dimension
The date and time when the inventory level at a specific location was last updated.
inventory_level.updated_at.date Dimension
The date when the inventory level at a specific location was last updated.
inventory_quantity inventoryQuantity Metric
The quantity of a product variant available in inventory, which can be tracked and managed in various states (e.g., available, committed, reserved).
item_group_id Dimension
An identifier used to group closely related product variants, such as different sizes or colors of the same product, for purposes like product feeds (e.g., Google Merchant Center).
kind Dimension
The type of financial transaction associated with an order, such as Authorization, Sale, Capture, Void, or Refund.
landing_site Dimension
The URL of the landing site that the customer visited before placing the order.
last_name Dimension
The last name of the customer.
last_order_id Dimension
The unique identifier of the customer's last order.
last_order_name Dimension
The customer-facing name of the customer's last order (e.g., #1001).
lineItems.{NUM}.discountedTotalSet.shopMoney.amount Metric
The total discounted price of a specific line item in the shop's currency, including line-level discounts and discounts applied to refunded or removed quantities, but excluding order-level discounts.
lineItems.{NUM}.discountedUnitPriceSet.shopMoney.amount Metric
The approximate unit price of a line item in the shop's currency after line-level discounts are applied, including discounts applied to refunded or removed quantities, but excluding order-level or code-based discounts.
lineItems.{NUM}.id Metric
A unique identifier for a specific line item within an order.
lineItems.{NUM}.name Dimension
The name or title of the product or variant as it appears on the line item.
lineItems.{NUM}.originalTotalSet.shopMoney.amount Metric
The original total price of a specific line item in the shop's currency before any discounts are applied.
lineItems.{NUM}.originalUnitPriceSet.shopMoney.amount Metric
The original unit price of a line item in the shop's currency before any discounts are applied.
lineItems.{NUM}.product.id Metric
The unique identifier of the product associated with a specific line item.
lineItems.{NUM}.product.title Dimension
The title of the product associated with a specific line item.
lineItems.{NUM}.quantity Metric
The number of units of the product variant in a specific line item, minus any refunded quantity.
lineItems.{NUM}.sku Dimension
The Stock Keeping Unit (SKU) of the product variant associated with a specific line item.
lineItems.{NUM}.title Dimension
The title of the product or variant included in a specific line item within an order.
lineItems.{NUM}.totalDiscountSet.shopMoney.amount Metric
The total amount of all discounts allocated to a specific line item in the shop's currency, including discounts applied to refunded or removed quantities.
lineItems.{NUM}.variant Dimension
Details about the specific product variant associated with an individual line item in an order.
lineItems.{NUM}.variant.id Metric
The unique identifier of the product variant associated with a specific line item.
lineItems.{NUM}.variant.inventoryItem.unitCost Dimension
The unit cost of the inventory item linked to the product variant within a specific line item.
lineItems.{NUM}.variant.inventoryItem.unitCost.amount Metric
The monetary amount of the unit cost for the inventory item associated with the product variant in a specific line item.
lineItems.{NUM}.variant.inventoryItem.unitCost.currencyCode Dimension
The three-letter ISO 4217 currency code for the unit cost of the inventory item associated with the product variant in a specific line item.
lineItems.{NUM}.variant.sku Dimension
The Stock Keeping Unit (SKU) of the product variant associated with a specific line item.
lineItems.{NUM}.variantTitle Dimension
The title of the product variant associated with a specific line item.
line_item.admin_graphql_api_id Dimension
The globally unique identifier for the line item in the Shopify GraphQL Admin API.
line_item.discount_allocations Dimension
A list of discounts applied to this specific line item.
line_item.duties Dimension
A list of duties associated with this line item for international shipments.
line_item.fulfillable_quantity Metric
The quantity of this line item that is still available to be fulfilled.
line_item.fulfillment_status Dimension
The status of an order's line item in terms of fulfillment (e.g., 'fulfilled', 'unfulfilled', 'partial').
line_item.gift_card Dimension
Indicates if the line item represents a gift card.
line_item.grams Metric
The weight of one unit of the line item in grams.
line_item.id Metric
The unique identifier for the line item within an order.
line_item.name Dimension
The name of the product variant in the line item.
line_item.pre_tax_price Metric
The price of the line item before any taxes are applied.
line_item.pre_tax_price_set.presentment_money.amount Metric
The amount of the line item's price before tax in the currency presented to the customer.
line_item.pre_tax_price_set.presentment_money.currency_code Dimension
The three-letter code (ISO 4217) for the currency presented to the customer for the pre-tax price.
line_item.pre_tax_price_set.shop_money.amount Metric
The amount of the line item's price before tax in the shop's local currency.
line_item.pre_tax_price_set.shop_money.currency_code Dimension
The three-letter code (ISO 4217) for the shop's local currency for the pre-tax price.
line_item.price Metric
The price of the line item before discounts, in the shop currency.
line_item.price_set.presentment_money.amount Metric
The monetary amount of the line item's price in the currency presented to the customer.
line_item.price_set.presentment_money.currency_code Dimension
The three-letter code (ISO 4217) for the currency presented to the customer for the line item's price.
line_item.price_set.shop_money.amount Metric
The monetary amount of the line item's price in the shop's local currency.
line_item.price_set.shop_money.currency_code Dimension
The three-letter code (ISO 4217) for the shop's local currency for the line item's price.
line_item.product_exists Dimension
Indicates whether the product associated with this line item currently exists in the store.
line_item.product_id Dimension
The unique identifier of the product associated with this line item.
line_item.properties Dimension
A list of custom key-value pairs that provide additional details about the line item.
line_item.quantity Metric
The number of units of the product variant in the line item.
line_item.requires_shipping Dimension
Indicates whether the line item requires physical shipping.
line_item.sku Dimension
The Stock Keeping Unit (SKU) of the product variant in this line item.
line_item.tax_lines Dimension
A list of tax lines applied to this specific line item.
line_item.taxable Dimension
Indicates whether the line item is subject to taxes.
line_item.title Dimension
The title of the product or variant in the line item.
line_item.total_discount Metric
The total amount of discounts applied specifically to this line item.
line_item.total_discount_set.presentment_money.amount Metric
The monetary amount of the total discount applied to the line item in the currency presented to the customer.
line_item.total_discount_set.presentment_money.currency_code Dimension
The three-letter code (ISO 4217) for the currency presented to the customer for the total discount on this line item.
line_item.total_discount_set.shop_money.amount Metric
The monetary amount of the total discount applied to the line item in the shop's local currency.
line_item.total_discount_set.shop_money.currency_code Dimension
The three-letter code (ISO 4217) for the shop's local currency for the total discount on this line item.
line_item.variant_id Dimension
The unique identifier of the product variant associated with this line item.
line_item.variant_inventory_management Dimension
The system or method used for managing the inventory of the product variant (e.g., 'shopify', 'fulfillment_service').
line_item.variant_title Dimension
The title of the product variant in the line item (e.g., 'Small / Red').
line_item.vendor Dimension
The vendor or supplier of the product in this line item.
line_items Dimension
A list of product variants included in the order.
line_items.sku Dimension
The Stock Keeping Unit (SKU) for the product variant in the line item.
line_items.{NUM}.applied_discounts.{NUM}.amount Metric
The monetary value of a discount applied to a specific line item in the order, expressed in the shop's currency.
line_items.{NUM}.applied_discounts.{NUM}.application_type Dimension
The type of discount applied to a line item, such as 'fixed_amount', 'percentage', or 'shipping'.
line_items.{NUM}.applied_discounts.{NUM}.created_at Dimension
The date and time when the discount was created and applied to a specific line item within an order.
line_items.{NUM}.applied_discounts.{NUM}.created_at.date Dimension
The date component of when the discount was created and applied to a specific line item within an order.
line_items.{NUM}.applied_discounts.{NUM}.description Dimension
A descriptive text for the discount that was applied to the line item.
line_items.{NUM}.applied_discounts.{NUM}.discount_class Dimension
The class of the discount, indicating what it applies to (e.g., 'product', 'order', 'shipping').
line_items.{NUM}.applied_discounts.{NUM}.id Dimension
The unique identifier for the discount applied to a specific line item within an order.
line_items.{NUM}.compare_at_price Metric
The original price of the item before any sales or discounts, used for comparison.
line_items.{NUM}.destination_location_id Dimension
The unique identifier of the location where the line item is destined for fulfillment.
line_items.{NUM}.discount_allocations.{NUM}.amount Metric
The amount of money discounted for this specific discount allocation on the line item.
line_items.{NUM}.discount_allocations.{NUM}.application_type Dimension
The strategy or method by which a specific discount is applied to a line item, such as applying to 'ALL' items, the 'FIRST' eligible item, or the 'MAXIMUM' discount amount.
line_items.{NUM}.discount_allocations.{NUM}.created_at Dimension
The date and time when this discount allocation was created.
line_items.{NUM}.discount_allocations.{NUM}.created_at.date Dimension
The date when this discount allocation was created.
line_items.{NUM}.discount_allocations.{NUM}.description Dimension
A description of the discount applied in this allocation.
line_items.{NUM}.discount_allocations.{NUM}.id Dimension
A unique identifier for this specific discount allocation.
line_items.{NUM}.fulfillment_service Dimension
The name of the fulfillment service associated with the line item.
line_items.{NUM}.gift_card Dimension
Indicates if the line item represents a gift card.
line_items.{NUM}.grams Metric
The weight of the item in grams.
line_items.{NUM}.id Dimension
A unique identifier for the line item.
line_items.{NUM}.key Dimension
A unique key or identifier for a specific line item attribute.
line_items.{NUM}.line_price Metric
The total price of the line item, accounting for quantity and any applied line-item specific discounts.
line_items.{NUM}.origin_location_id Dimension
The unique identifier of the location from which the line item originated.
line_items.{NUM}.presentment_title Dimension
The title of the product as displayed in the customer's presentment currency.
line_items.{NUM}.presentment_variant_title Dimension
The variant title of the product as displayed in the customer's presentment currency.
line_items.{NUM}.price Metric
The price of a single unit of the line item before any discounts are applied.
line_items.{NUM}.product_id Dimension
The unique identifier of the product associated with the line item.
line_items.{NUM}.properties Dimension
A list of custom key-value pairs that provide additional details about this specific line item.
line_items.{NUM}.properties.{NUM}.name Dimension
The name of a custom property attached to the line item.
line_items.{NUM}.properties.{NUM}.value Dimension
The value of a custom property attached to the line item.
line_items.{NUM}.quantity Metric
The number of units of the line item purchased.
line_items.{NUM}.rank Metric
The rank or position of the line item within the order.
line_items.{NUM}.requires_shipping Dimension
Indicates whether the line item requires physical shipping.
line_items.{NUM}.selling_plan_application.api_client_id Dimension
The identifier of the API client that created or is associated with this selling plan application.
line_items.{NUM}.selling_plan_application.billing_anchors Dimension
The specific dates or intervals at which billing cycles for the selling plan are anchored.
line_items.{NUM}.selling_plan_application.billing_interval Dimension
The frequency or interval of the billing cycle for the selling plan (e.g., 'DAY', 'WEEK', 'MONTH', 'YEAR').
line_items.{NUM}.selling_plan_application.billing_interval_count Metric
The number of billing intervals (e.g., 3 for 'every 3 months').
line_items.{NUM}.selling_plan_application.billing_max_cycles Dimension
The maximum number of billing cycles for the selling plan.
line_items.{NUM}.selling_plan_application.billing_min_cycles Dimension
The minimum number of billing cycles for the selling plan.
line_items.{NUM}.selling_plan_application.delivery_anchors Dimension
The specific dates or intervals at which delivery cycles for the selling plan are anchored.
line_items.{NUM}.selling_plan_application.delivery_cutoff_period Dimension
The buffer period for orders to be included in the next fulfillment anchor.
line_items.{NUM}.selling_plan_application.delivery_intent Dimension
The intended delivery behavior for the selling plan (e.g., 'FULFILL_ALL_AT_ONCE', 'FULFILL_AS_SCHEDULED').
line_items.{NUM}.selling_plan_application.delivery_interval Dimension
The frequency or interval of the delivery cycle for the selling plan (e.g., 'DAY', 'WEEK', 'MONTH', 'YEAR').
line_items.{NUM}.selling_plan_application.delivery_interval_count Metric
The number of delivery intervals (e.g., 1 for 'every month').
line_items.{NUM}.selling_plan_application.delivery_pre_cutoff_behavior Dimension
The behavior of delivery for a selling plan application (e.g., subscription) before a specified cutoff time.
line_items.{NUM}.selling_plan_application.description Dimension
A detailed description of the selling plan application.
line_items.{NUM}.selling_plan_application.name Dimension
The name of the selling plan application.
line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.adjustment_type Dimension
The type of price adjustment applied by this pricing policy (e.g., 'PERCENTAGE', 'FIXED_AMOUNT').
line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.adjustment_value Metric
The value of the price adjustment, based on the `adjustment_type`.
line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.after_cycle Metric
The billing cycle number after which a specific recurring pricing policy for a selling plan becomes effective.
line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.base_price Metric
The base price used for calculations within this pricing policy.
line_items.{NUM}.selling_plan_application.pricing_policies.{NUM}.computed_price Metric
The final computed price after applying this pricing policy.
line_items.{NUM}.selling_plan_application.selling_plan_id Dimension
The unique identifier of the selling plan associated with this application.
line_items.{NUM}.selling_plan_id Dimension
The unique identifier of the selling plan applied to this line item.
line_items.{NUM}.sku Dimension
The Stock Keeping Unit (SKU) for a specific line item in an order.
line_items.{NUM}.tax_code Dimension
The tax code applicable to the line item.
line_items.{NUM}.tax_lines.{NUM}.channel_liable Dimension
Indicates if the sales channel that submitted the tax line is liable for remitting the tax.
line_items.{NUM}.tax_lines.{NUM}.compare_at Dimension
The original price of the item before any discounts or adjustments, specific to a tax line.
line_items.{NUM}.tax_lines.{NUM}.compare_at.date Dimension
The date associated with the original price of the item before any discounts or adjustments, specific to a tax line.
line_items.{NUM}.tax_lines.{NUM}.identifier Dimension
A unique identifier for the specific tax line.
line_items.{NUM}.tax_lines.{NUM}.jurisdiction_id Dimension
The unique identifier for the tax jurisdiction associated with this tax line.
line_items.{NUM}.tax_lines.{NUM}.jurisdiction_source Dimension
The source that determined the tax jurisdiction for this tax line.
line_items.{NUM}.tax_lines.{NUM}.jurisdiction_type Dimension
The type of tax jurisdiction (e.g., 'STATE', 'COUNTY', 'CITY').
line_items.{NUM}.tax_lines.{NUM}.position Metric
The sequential position of the tax line within the list of taxes applied to the line item.
line_items.{NUM}.tax_lines.{NUM}.price Metric
The price component associated with the tax line.
line_items.{NUM}.tax_lines.{NUM}.rate Metric
The tax rate applied for this tax line.
line_items.{NUM}.tax_lines.{NUM}.reporting_exempt_amount Dimension
The amount of the line item that is exempt from tax, for reporting purposes.
line_items.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_code Dimension
The code for the tax jurisdiction, used for reporting.
line_items.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_name Dimension
The name of the tax jurisdiction, used for reporting.
line_items.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_type Dimension
The type of tax jurisdiction (e.g., 'STATE', 'COUNTY', 'CITY'), used for reporting.
line_items.{NUM}.tax_lines.{NUM}.reporting_non_taxable_amount Dimension
The amount of the line item that is non-taxable, for reporting purposes.
line_items.{NUM}.tax_lines.{NUM}.reporting_taxable_amount Dimension
The amount of the line item that is taxable, for reporting purposes.
line_items.{NUM}.tax_lines.{NUM}.source Dimension
The source of the tax calculation or application.
line_items.{NUM}.tax_lines.{NUM}.tax_api_client_id Dimension
The identifier of the API client that calculated or provided this tax line.
line_items.{NUM}.tax_lines.{NUM}.tax_calculation_price Metric
The price used as the base for calculating this tax line.
line_items.{NUM}.tax_lines.{NUM}.tax_type Dimension
The specific type of tax applied (e.g., 'sales_tax', 'VAT').
line_items.{NUM}.tax_lines.{NUM}.title Dimension
The title or name of the tax.
line_items.{NUM}.tax_lines.{NUM}.zone Dimension
The geographical zone relevant to the calculation of a specific tax line on a line item.
line_items.{NUM}.taxable Dimension
Indicates if the line item is subject to taxes.
line_items.{NUM}.title Dimension
The title or name of the product.
line_items.{NUM}.unit_price_measurement Dimension
Contains details about the unit of measurement and value used to calculate the unit price of a line item.
line_items.{NUM}.unit_price_measurement.measured_type Dimension
The type of measurement used for the unit price of a line item, such as weight or volume.
line_items.{NUM}.unit_price_measurement.quantity_unit Dimension
The unit of quantity used in the unit price measurement for a line item (e.g., 'kg', 'ml').
line_items.{NUM}.unit_price_measurement.quantity_value Metric
The numeric value of the quantity used in the unit price measurement for a line item.
line_items.{NUM}.unit_price_measurement.reference_unit Dimension
The reference unit used in the unit price measurement for a line item to express the price per unit.
line_items.{NUM}.unit_price_measurement.reference_value Metric
The numeric value of the reference unit used in the unit price measurement for a line item.
line_items.{NUM}.user_id Dimension
The unique identifier for the customer who placed the order containing this line item.
line_items.{NUM}.variant_id Dimension
The unique identifier of the product variant associated with the line item.
line_items.{NUM}.variant_price Metric
The price of the product variant.
line_items.{NUM}.variant_title Dimension
The title of the product variant.
line_items.{NUM}.vendor Dimension
The vendor of the product.
localized_country_name Dimension
The localized name of the country for an address.
localized_province_name Dimension
The localized name of the province or state for an address.
location.admin_graphql_api_id Dimension
The unique identifier for the location in the Shopify GraphQL Admin API.
location.created_at Dimension
The date and time when the location was created.
location.created_at.date Dimension
The date when the location was created.
location.updated_at Dimension
The date and time when the location was last updated.
location.updated_at.date Dimension
The date when the location was last updated.
location_id Dimension
The unique identifier for the physical location where inventory is stocked or an order is fulfilled.
message Dimension
A general message or note associated with a resource, such as an order or a risk assessment.
metafields Dimension
Custom fields that can be added to Shopify resources to store additional, specific information not covered by standard fields.
multipass_identifier Dimension
A unique identifier for the customer used with Multipass login (Shopify Plus SSO).
name Dimension
The name of the resource, such as the customer's full name or the order's name.
note Dimension
Additional notes or comments associated with the order.
note_attributes Dimension
Additional key-value pairs of information attached to the order.
note_attributes.{NUM}.name Dimension
The name of a custom attribute associated with the order's notes.
note_attributes.{NUM}.value Dimension
The value of a custom attribute associated with the order's notes.
number Dimension
The order number presented to the customer.
options Dimension
A list of options for a product variant (e.g., 'Size: Small', 'Color: Red').
order.app_id Dimension
The unique identifier of the app that created this order.
order.billing_address Dimension
The billing address associated with the order.
order.browser_ip Dimension
The IP address of the browser used when the order was placed.
order.buyer_accepts_marketing Dimension
Indicates whether the customer for this order has consented to receive marketing updates from the shop.
order.cancel_reason Dimension
The reason provided for canceling this order.
order.cancelled_at Dimension
The date and time when this order was canceled.
order.cancelled_at.date Dimension
The date when this order was canceled.
order.cart_token Dimension
The unique token associated with the shopping cart that led to this order.
order.checkout_token Dimension
A unique token used to reference the checkout associated with the order.
order.client_details Dimension
Information about the client (e.g., browser, IP address) used to place this order.
order.closed_at Dimension
The date and time when this order was closed.
order.closed_at.date Dimension
The date when this order was closed.
order.created_at Dimension
The date and time when this order was created.
order.created_at.date Dimension
The date when this order was created.
order.currency Dimension
The three-letter code (ISO 4217 format) for the currency of this order.
order.current_subtotal_price Metric
The current subtotal price of the order before taxes, duties, and shipping.
order.current_subtotal_price_set Dimension
The current subtotal price of the order, including its value in shop and presentment currencies.
order.current_total_additional_fees_set Dimension
The current total amount of additional fees, such as customs fees or import taxes, in both shop and presentment currencies.
order.current_total_discounts Metric
The current total amount of discounts applied to the order.
order.current_total_discounts_set Dimension
The current total amount of discounts applied to the order, including its value in shop and presentment currencies.
order.current_total_duties_set Dimension
The current total amount of duties for the order, in both shop and presentment currencies.
order.current_total_price Metric
The current grand total price of this order, including taxes and shipping after all discounts.
order.current_total_price_set Dimension
The current total price of the order, in both shop and presentment currencies.
order.current_total_tax Metric
The current total amount of tax applied to the order.
order.current_total_tax_set Dimension
The current total amount of tax for the order, in both shop and presentment currencies.
order.customer_locale Dimension
The locale of the customer who placed this order (e.g., en-US).
order.discount_applications Dimension
Details about the specific discounts applied to this order.
order.discount_codes Dimension
A list of discount codes applied to this order.
order.email Dimension
The email address of the customer for this order.
order.estimated_taxes Dimension
The estimated tax amount for an order during the checkout process.
order.financial_status Dimension
The financial status of this order (e.g., 'pending', 'paid', 'refunded').
order.fulfillment_status Dimension
The fulfillment status of this order (e.g., 'null', 'partially_fulfilled', 'fulfilled').
order.fulfillments Dimension
A list of fulfillment details for this order.
order.id Metric
The unique identifier for this order.
order.landing_site Dimension
The URL of the landing site that the customer visited before placing this order.
order.location_id Dimension
The unique identifier for the location associated with this order.
order.name Dimension
The name of this order.
order.note Dimension
Additional notes or comments associated with this order.
order.note_attributes Dimension
Additional key-value pairs of information attached to this order.
order.number Metric
The order number presented to the customer for this order.
order.order_number Metric
The order number as it appears in the Shopify admin for this order.
order.order_status_url Dimension
The URL to this order's status page, where the customer can track their order.
order.original_total_additional_fees_set Dimension
The original total amount of additional fees for the order before any adjustments, in both shop and presentment currencies.
order.original_total_duties_set Dimension
The original total amount of duties for the order before any adjustments, in both shop and presentment currencies.
order.payment_gateway_names Dimension
A list of names of the payment gateways used for this order.
order.payment_terms Dimension
The agreed-upon terms for payment of the order, including due dates and any applicable discounts.
order.phone Metric
The phone number of the customer for this order.
order.presentment_currency Dimension
The three-letter code (ISO 4217) for the currency presented to the customer for the order.
order.processed_at Dimension
The date and time when this order was processed.
order.processed_at.date Dimension
The date when this order was processed.
order.referring_site Dimension
The URL of the referring website that directed the customer to the shop for this order.
order.refunds Dimension
A list of refund transactions associated with this order.
order.shipping_address Dimension
The shipping address associated with the order.
order.shipping_lines Dimension
A list of shipping methods and their associated costs for the order.
order.source_identifier Dimension
A unique identifier for the order from its originating platform, such as a Point of Sale (POS) system or a third-party channel.
order.source_name Dimension
The channel or source through which this order was created (e.g., 'web', 'pos').
order.source_url Dimension
The URL of the external platform or channel from which the order originated.
order.status Dimension
The overall status of this order.
order.subtotal_price Metric
The price of this order before taxes and shipping, and after discounts.
order.subtotal_price_set Dimension
The subtotal price of the order (total of line items before discounts and taxes), in both shop and presentment currencies.
order.tags Dimension
A comma-separated list of tags associated with this order.
order.taxes_included Dimension
Indicates whether taxes are included in the prices for this order.
order.test Dimension
Indicates whether this order is a test order.
order.token Dimension
A unique token associated with this order.
order.total_discounts Metric
The total amount of discounts applied to this order.
order.total_discounts_set Dimension
The total amount of discounts applied to the order, including its value in shop and presentment currencies.
order.total_line_items_price Metric
The total price of all line items in this order before any order-level discounts or taxes.
order.total_line_items_price_set Dimension
The total price of all line items in the order, in both shop and presentment currencies.
order.total_outstanding Metric
The total amount of money outstanding on the order.
order.total_price Metric
The grand total price of this order, including taxes and shipping after all discounts.
order.total_price_set Dimension
The grand total price of the order, in both shop and presentment currencies.
order.total_shipping_price_set Dimension
The total shipping price for the order, in both shop and presentment currencies.
order.total_tax Metric
The total tax amount charged for this order.
order.total_tax_set Dimension
The total amount of tax for the order, in both shop and presentment currencies.
order.total_tip_received Metric
The total amount of tip received for this order.
order.total_weight Metric
The total weight of this order in grams.
order.updated_at Dimension
The date and time when this order was last updated.
order.updated_at.date Dimension
The date when this order was last updated.
order.user_id Dimension
The unique identifier of the user (e.g., staff member) who processed this order.
order_id Dimension
The unique identifier for the order.
order_name order.name Dimension
The customer-facing name or identifier of the order.
order_number Metric
The order number as it appears in the Shopify admin.
order_status_url Dimension
The URL to the order's status page, where the customer can track their order.
orders_count Metric
The total number of orders the customer has placed.
original_total_additional_fees_set Dimension
The initial total amount of all additional fees (e.g., duties, import fees) that were applied when an order was originally created, before any modifications.
original_total_duties_set Dimension
The original sum of all duties (customs fees) on the order, in presentment and shop currencies, before any adjustments.
parent_id Dimension
The ID of a parent resource or transaction, often used to link a transaction (e.g., a capture or refund) to its original authorization transaction.
payment_details Dimension
Details pertaining to the payment transaction for the order.
payment_details.avs_result_code Dimension
The Address Verification System (AVS) response code from the credit card company.
payment_details.credit_card_bin Metric
The Bank Identification Number (BIN) or Issuer Identification Number (IIN) of the customer's credit card.
payment_details.credit_card_company Dimension
The name of the company that issued the customer's credit card (e.g., Visa).
payment_details.credit_card_expiration_month Metric
The expiration month of the credit card used for the payment.
payment_details.credit_card_expiration_year Metric
The expiration year of the credit card used for the payment.
payment_details.credit_card_name Dimension
The name of the credit card holder.
payment_details.credit_card_number Dimension
The customer's credit card number, usually with most leading digits redacted.
payment_details.credit_card_wallet Dimension
The digital wallet used for the credit card payment (e.g., Apple Pay, Google Pay).
payment_details.cvv_result_code Dimension
The Card Verification Value (CVV) response code from the credit card company.
payment_gateway_names Dimension
A list of names of the payment gateways used for the order.
payment_terms Dimension
The terms of payment associated with the order.
payments_refund_attributes.acquirer_reference_number Dimension
The acquirer reference number (ARN) for the payment refund, used to track transactions between banks.
payments_refund_attributes.status Dimension
The current status of the payment refund (e.g., pending, success, failed).
phone Dimension
The customer's phone number.
presentment_currency Dimension
The currency in which the order was presented to the customer.
price Metric
The base price of a product variant.
price_set Dimension
Represents a set of pricing details for a product variant on a specific price list. This includes the variant's price, compare-at price, and indicates if the price is fixed or adjusted based on rules.
price_set.presentment_money.amount Dimension
The monetary amount of the price in the currency presented to the customer.
price_set.presentment_money.currency_code Dimension
The three-letter currency code (e.g., USD) of the price presented to the customer.
price_set.shop_money.amount Metric
The monetary amount of the price in the shop's local currency.
price_set.shop_money.currency_code Dimension
The three-letter currency code (e.g., USD) of the price in the shop's local currency.
processed_at Dimension
The date and time when the order was processed.
processed_at.date Dimension
The date when the order was processed.
product.category Dimension
Represents the standardized product category assigned to a product, providing details about its position within Shopify's product taxonomy.
product.category.name Dimension
The name of the product's category within Shopify's standardized product taxonomy. For example, "Dog Beds".
product.createdAt Dimension
The date and time when the product was initially created in the store.
product.featuredImage Dimension
The main visual representation of a product. This field provides access to the image's URL, dimensions, and various transformation options, such as resizing and cropping, to optimize its display across different storefronts.
product.featuredImage.url Dimension
The URL where the product's featured image is hosted.
product.handle Dimension
A unique, human-readable identifier for the product, often used in URLs to access the product's page.
product.id Metric
A unique identifier for a product in the store.
product.onlineStoreUrl Dimension
The URL of the product as displayed on the online store. This field adheres to RFC 3986 and RFC 3987 URI standards and might be null if the store is password-protected.
product.productType Dimension
The classification or type of product (e.g., 'T-Shirt', 'Electronics', 'Footwear').
product.publishedAt Dimension
The date and time when a product was published to the online store and other sales channels.
product.status Dimension
The current status of the product, such as 'active' (available for sale), 'draft' (in progress), or 'archived' (no longer sold).
product.tags.{NUM} Dimension
A specific tag associated with the product, used for organization, filtering, and categorization.
product.title Dimension
The title or name of the product.
product.vendor Dimension
The name of the vendor or brand that supplies the product.
product_color Dimension
The color attribute of a product, used to distinguish different product variants. This is a key characteristic that customers can select.
product_exists Dimension
Indicates whether the product exists.
product_gender Dimension
The intended gender for which a product is designed, used for categorization, filtering, and product feeds (e.g., Google Merchant Center). This is often implemented via product metafields or tags.
product_id Dimension
The unique identifier for a product.
product_name Dimension
The primary title or name of a product displayed in the store, used for identification, search, and marketing.
product_type Dimension
A categorization for the product used for filtering and searching products.
properties Dimension
Any additional custom key-value pair properties associated with the line item.
province Dimension
The province or state of the address.
province_code Dimension
The two-letter province or state code of the address.
province_code_of_origin Dimension
The two-letter province or state code of the location from which an item originated.
published_at Dimension
The date and time when the product was published.
published_at.date Dimension
The date part of when the product was published.
published_scope Dimension
Indicates where a product is published, such as 'web' for the online store or 'global' for both online store and Point of Sale.
quantity Metric
The number of units of a specific item in a line item or a product variant.
receipt Dimension
Indicates whether a receipt was sent or provides details of the transaction receipt.
referring_site Dimension
The URL of the referring website that directed the customer to the shop.
refund.created_at Dimension
The date and time when the refund record was created.
refund.created_at.date Dimension
The date part of when the refund record was created.
refund.duties Dimension
A list of duties that were refunded as part of this refund.
refund.id Metric
The unique identifier for the refund record.
refund.note Dimension
An optional note or comment associated with the refund.
refund.order_adjustments Dimension
A list of adjustments applied to the order as part of the refund process.
refund.processed_at Dimension
The date and time when the refund transaction was processed.
refund.processed_at.date Dimension
The date part of when the refund transaction was processed.
refund.refund_duties Dimension
Indicates whether duties were refunded as part of a refund transaction.
refund_date Dimension
The date when the refund was issued.
refund_tax Metric
The amount of tax refunded.
refund_value Metric
The total monetary amount of the refund.
refunds Dimension
A list of refund transactions associated with the order.
report_date Dimension
The specific date for which a particular report or set of analytical data was generated or pertains to. This is often in YYYY-MM-DD format.
report_date_time_UTC Dimension
The date and time in UTC (Coordinated Universal Time) for which a report was generated or data was recorded.
requires_shipping Dimension
Indicates whether the inventory item requires a shipping address.
restock_type Dimension
How a refunded line item affects inventory levels (e.g., 'no_restock', 'cancel', 'return', 'replace').
risk.cause_cancel Dimension
Indicates whether the order risk assessment recommends canceling the order due to high fraud risk.
risk.checkout_id Dimension
The unique identifier of the checkout that the order risk belongs to.
risk.display Dimension
Indicates whether the order risk is displayed on the order details page in the Shopify admin.
risk.id Metric
A unique numeric identifier for the order risk.
risk.merchant_message Dimension
A message displayed to the merchant to indicate the results of the fraud check.
risk.message Dimension
A general message associated with the order risk.
risk.order_id Dimension
The unique identifier of the order that the order risk belongs to.
risk.recommendation Dimension
The recommendation for the order based on the risk assessment (e.g., 'cancel', 'investigate', 'accept').
risk.score Metric
A numerical score representing the level of risk associated with the order.
risk.source Dimension
The source that generated the order risk assessment.
selectedOptions.{NUM}.name Dimension
The name of a product option chosen for a specific product variant (e.g., 'Size', 'Color').
selectedOptions.{NUM}.value Dimension
The value of a product option chosen for a specific product variant (e.g., 'Large', 'Red').
shippingAddress.countryCode Dimension
The two-letter ISO 3166-1 alpha-2 code for the country of the shipping address associated with an order.
shipping_address Dimension
The complete shipping address for the order.
shipping_address.address1 Dimension
The first line of the street address for the customer's shipping address.
shipping_address.address2 Dimension
The second line of the street address for the customer's shipping address, providing additional address details.
shipping_address.city Dimension
The city of the shipping address.
shipping_address.company Dimension
The company name associated with the shipping address.
shipping_address.country Dimension
The full name of the country for the shipping address.
shipping_address.country_code Dimension
The two-letter ISO 3166-1 alpha-2 country code for the shipping address (e.g., US, CA).
shipping_address.first_name Dimension
The first name of the recipient at the shipping address.
shipping_address.last_name Dimension
The last name of the recipient at the shipping address.
shipping_address.latitude Metric
The latitude coordinate of the shipping address.
shipping_address.longitude Metric
The longitude coordinate of the shipping address.
shipping_address.name Dimension
The full name (first and last name) of the person associated with the shipping address.
shipping_address.phone Dimension
The phone number associated with the shipping address, formatted using E.164 standard.
shipping_address.province Dimension
The full name of the province, state, or region for the shipping address.
shipping_address.province_code Dimension
The alphanumeric code for the province, state, or district (e.g., ON for Ontario, Canada) of the shipping address.
shipping_address.zip Dimension
The zip or postal code of the shipping address.
shipping_lines Dimension
A list of shipping methods and their associated costs for the order.
shipping_lines.carrier_identifier Dimension
The identifier of the shipping carrier.
shipping_lines.code Dimension
The code associated with the shipping method.
shipping_lines.discount_allocations Dimension
An array of discount allocation objects applied to the shipping line.
shipping_lines.discounted_price Metric
The price of the shipping line after applying any discounts.
shipping_lines.id Dimension
The unique identifier of the shipping line.
shipping_lines.price Metric
The original price of the shipping line before any discounts are applied.
shipping_lines.source Dimension
The source of the shipping method (e.g., 'shopify', 'app').
shipping_lines.tax_lines Dimension
Tax line objects associated with the shipping lines.
shipping_lines.title Dimension
The title or name of the shipping method.
shipping_lines.{NUM}.api_client_id Dimension
The unique identifier for the API client or application that created or last modified the shipping line.
shipping_lines.{NUM}.applied_discounts.{NUM}.amount Metric
The amount of money discounted for this specific discount applied to the shipping line.
shipping_lines.{NUM}.applied_discounts.{NUM}.description Dimension
A description of the discount applied to the shipping line.
shipping_lines.{NUM}.applied_discounts.{NUM}.price_rule_id Dimension
The unique identifier of the price rule that generated this discount on the shipping line.
shipping_lines.{NUM}.applied_discounts.{NUM}.script_version_id Dimension
The unique identifier of the script version used to apply this discount to the shipping line.
shipping_lines.{NUM}.carrier_identifier Dimension
A unique identifier for the carrier service that provided the shipping rate.
shipping_lines.{NUM}.carrier_service_id Dimension
The unique identifier of the carrier service that provided the rate for the shipping line.
shipping_lines.{NUM}.code Dimension
A unique identifier for the specific shipping rate.
shipping_lines.{NUM}.custom_tax_lines Dimension
Indicates whether the tax lines applied to this shipping line are custom or manually defined, as opposed to being automatically calculated. The Shopify GraphQL API for `ShippingLine` has a `custom` field which indicates if the shipping line itself is custom.
shipping_lines.{NUM}.delivery_category Dimension
The general classification of the delivery method for a specific shipping line.
shipping_lines.{NUM}.delivery_expectation_range Dimension
The expected delivery timeframe for the shipping line, often represented as a range of dates or days.
shipping_lines.{NUM}.delivery_expectation_range.{NUM} Metric
A range representing the expected delivery dates for the shipping line.
shipping_lines.{NUM}.delivery_expectation_type Dimension
The type of delivery expectation, specifying how the delivery timeframe is determined or communicated (e.g., estimated, guaranteed).
shipping_lines.{NUM}.delivery_option_group.token Dimension
A token identifying the delivery option group for the shipping line.
shipping_lines.{NUM}.delivery_option_group.type Dimension
The type of merchandise or category within a delivery option group for a shipping line, such as 'ONE_TIME_PURCHASE' or 'SUBSCRIPTION'.
shipping_lines.{NUM}.delivery_option_group_type Dimension
The type of merchandise in the delivery group for a shipping line, such as 'ONE_TIME_PURCHASE' or 'SUBSCRIPTION'.
shipping_lines.{NUM}.discount_allocations Dimension
Details on how discounts are allocated to a specific shipping line.
shipping_lines.{NUM}.discounted_price Metric
The price of the shipping line after any discounts have been applied.
shipping_lines.{NUM}.discounted_price_set.presentment_money.amount Dimension
The amount of the discounted shipping price in the customer's presentment currency.
shipping_lines.{NUM}.discounted_price_set.presentment_money.currency_code Dimension
The currency code for the discounted shipping price in the customer's presentment currency.
shipping_lines.{NUM}.discounted_price_set.shop_money.amount Dimension
The amount of the discounted shipping price in the shop's currency.
shipping_lines.{NUM}.discounted_price_set.shop_money.currency_code Dimension
The currency code for the discounted shipping price in the shop's currency.
shipping_lines.{NUM}.estimated_delivery_time_range Dimension
The estimated time range for delivery of the shipping line.
shipping_lines.{NUM}.id Dimension
A unique identifier for the shipping line.
shipping_lines.{NUM}.markup Metric
The additional cost or markup applied to the shipping price.
shipping_lines.{NUM}.original_rate_price Metric
The original price of the shipping rate before any discounts or adjustments.
shipping_lines.{NUM}.original_shop_markup Metric
The original markup applied to the shipping price by the shop.
shipping_lines.{NUM}.original_shop_price Metric
The original pre-tax shipping price of the line item before any discounts are applied, in the shop's currency.
shipping_lines.{NUM}.phone Dimension
The phone number associated with the shipping address for this line.
shipping_lines.{NUM}.presentment_title Dimension
The title of the shipping line as displayed in the customer's presentment currency.
shipping_lines.{NUM}.price Metric
The original price of the shipping line before any discounts.
shipping_lines.{NUM}.price_set.presentment_money.amount Dimension
The amount of the shipping price in the customer's presentment currency, before discounts.
shipping_lines.{NUM}.price_set.presentment_money.currency_code Dimension
The currency code for the shipping price in the customer's presentment currency, before discounts.
shipping_lines.{NUM}.price_set.shop_money.amount Dimension
The amount of the shipping price in the shop's currency, before discounts.
shipping_lines.{NUM}.price_set.shop_money.currency_code Dimension
The currency code for the shipping price in the shop's currency, before discounts.
shipping_lines.{NUM}.requested_fulfillment_service_id Dimension
The unique identifier of the fulfillment service requested for this shipping line.
shipping_lines.{NUM}.source Dimension
The source of the shipping rate.
shipping_lines.{NUM}.tax_lines Dimension
An array of tax line objects associated with a specific shipping line, detailing the taxes applied.
shipping_lines.{NUM}.tax_lines.{NUM}.channel_liable Dimension
Indicates whether the channel that submitted the tax line for the shipping line is liable for remitting the tax.
shipping_lines.{NUM}.tax_lines.{NUM}.compare_at Dimension
The original price of the shipping line before any discounts or adjustments, specific to a tax line.
shipping_lines.{NUM}.tax_lines.{NUM}.compare_at.date Dimension
The date associated with the original price of the shipping line before any discounts or adjustments, specific to a tax line.
shipping_lines.{NUM}.tax_lines.{NUM}.identifier Dimension
A unique identifier for the specific tax line applied to the shipping cost.
shipping_lines.{NUM}.tax_lines.{NUM}.jurisdiction_id Dimension
The identifier of the tax jurisdiction for a specific tax line within a shipping line.
shipping_lines.{NUM}.tax_lines.{NUM}.jurisdiction_source Dimension
The source that provided the tax jurisdiction information for the shipping line.
shipping_lines.{NUM}.tax_lines.{NUM}.jurisdiction_type Dimension
The type of tax jurisdiction for a specific tax line within a shipping line.
shipping_lines.{NUM}.tax_lines.{NUM}.position Metric
The numerical position of this tax line within the list of tax lines for the shipping method.
shipping_lines.{NUM}.tax_lines.{NUM}.price Metric
The amount of tax charged for this specific shipping tax line.
shipping_lines.{NUM}.tax_lines.{NUM}.rate Metric
The tax rate percentage applied to the shipping cost for this tax line.
shipping_lines.{NUM}.tax_lines.{NUM}.reporting_exempt_amount Dimension
The amount of a shipping line's cost that is exempt from tax for reporting purposes.
shipping_lines.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_code Dimension
The code of the tax jurisdiction used for reporting purposes for a specific tax line within a shipping line.
shipping_lines.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_name Dimension
The name of the tax jurisdiction used for reporting purposes for a specific tax line within a shipping line.
shipping_lines.{NUM}.tax_lines.{NUM}.reporting_jurisdiction_type Dimension
The type of tax jurisdiction used for reporting purposes for a specific tax line within a shipping line.
shipping_lines.{NUM}.tax_lines.{NUM}.reporting_non_taxable_amount Dimension
The amount of a shipping line's cost that is non-taxable for reporting purposes.
shipping_lines.{NUM}.tax_lines.{NUM}.reporting_taxable_amount Dimension
The amount of a shipping line's cost that is taxable for reporting purposes.
shipping_lines.{NUM}.tax_lines.{NUM}.source Dimension
The origin or source of the tax calculation for a tax line on the shipping line.
shipping_lines.{NUM}.tax_lines.{NUM}.tax_api_client_id Dimension
The identifier of the API client or application responsible for calculating or providing a specific tax line on a shipping line.
shipping_lines.{NUM}.tax_lines.{NUM}.tax_calculation_price Metric
The price used as the base for calculating tax for a specific tax line on a shipping line.
shipping_lines.{NUM}.tax_lines.{NUM}.tax_type Dimension
The specific type of tax applied (e.g., VAT, GST) for a tax line within a shipping line.
shipping_lines.{NUM}.tax_lines.{NUM}.title Dimension
The title or name of the tax applied to the shipping cost (e.g., 'State Tax', 'VAT').
shipping_lines.{NUM}.tax_lines.{NUM}.zone Dimension
The geographical zone relevant to the calculation of a specific tax line on a shipping line.
shipping_lines.{NUM}.title Dimension
The title or name of the shipping method.
shipping_lines.{NUM}.validation_context Dimension
The context used for validating the shipping line details.
shop_created_at created_at Dimension
The date and time when the Shopify shop was created.
shop_currency currency Dimension
The three-letter code (ISO 4217 format) for the shop's default currency.
shop_id Dimension
The unique identifier for the Shopify shop.
shop_name Dimension
The name of the Shopify shop.
shop_taxes_included taxes_included Dimension
Indicates whether taxes are included in product prices by default for the shop.
shop_timezone Dimension
The timezone configured for the Shopify shop.
shop_updated_at updated_at Dimension
The date and time when the Shopify shop information was last updated.
shopify_domain Dimension
The primary domain name of the Shopify store.
sku Dimension
The Stock Keeping Unit (SKU) for a product variant, used for inventory tracking.
sms_marketing_phone Dimension
The customer's phone number designated for receiving SMS marketing communications.
source Dimension
The channel or method by which an order or other resource was created.
source_identifier Dimension
An identifier for the source that created the order or checkout.
source_name Dimension
The channel or source through which the order was created (e.g., 'web', 'pos').
source_url Dimension
The URL from which the order or checkout originated.
state Dimension
The state of the customer's account (e.g., 'enabled').
status Dimension
The status of an order or product. For products, this includes 'active', 'archived', 'draft'. For orders, statuses like 'Open', 'Archived', 'Canceled' exist, along with fulfillment statuses.
subtotal Metric
The subtotal price of all line items in an order before discounts, taxes, and shipping.
subtotal_price Metric
The price of the order before taxes and shipping, and after discounts.
subtotal_price_set Dimension
The subtotal price of the order, including its value in shop and presentment currencies.
subtotal_set Dimension
A complex object representing the subtotal price of all line items, including amounts in both shop and presentment currencies.
subtotal_set.presentment_money.amount Metric
The monetary amount of the subtotal in the currency presented to the customer.
subtotal_set.presentment_money.currency_code Dimension
The currency code of the subtotal in the currency presented to the customer.
subtotal_set.shop_money.amount Metric
The monetary amount of the subtotal in the shop's local currency.
subtotal_set.shop_money.currency_code Dimension
The currency code of the subtotal in the shop's local currency.
tags Dimension
A comma-separated list of tags associated with the order.
tax Metric
The amount of tax applied.
tax_exempt Dimension
Indicates whether the customer is exempt from being charged taxes on their orders.
tax_lines Dimension
A list of tax line items, detailing the taxes applied to the order.
tax_lines.{NUM}.channel_liable Dimension
Indicates whether the sales channel is responsible for collecting and remitting this specific tax line.
tax_lines.{NUM}.compare_at Dimension
The original price of an item or shipping line before any discounts or adjustments, specific to a tax line.
tax_lines.{NUM}.compare_at.date Dimension
The date associated with the original price of an item or shipping line before any discounts or adjustments, specific to a tax line.
tax_lines.{NUM}.identifier Dimension
A unique identifier for the specific tax line.
tax_lines.{NUM}.position Metric
The numerical position of this tax line within the list of tax lines.
tax_lines.{NUM}.price Metric
The amount of tax charged for this specific tax line.
tax_lines.{NUM}.rate Metric
The tax rate percentage applied for this tax line.
tax_lines.{NUM}.source Dimension
The source from which this tax line was generated or applied.
tax_lines.{NUM}.title Dimension
The title or name of the tax (e.g., 'State Tax', 'VAT').
tax_lines.{NUM}.zone Dimension
The geographical zone associated with the tax line.
tax_name Dimension
The name of the tax applied (e.g., 'GST', 'VAT').
taxable Dimension
Indicates whether a line item or product is subject to taxes.
taxes_included Dimension
Indicates whether taxes are included in the price of the item or order.
template_suffix Dimension
The suffix of the Liquid template being used for a product or page (e.g., 'custom' for product.custom.liquid).
test Dimension
Indicates whether the order is a test order.
title Dimension
The title of a product, product variant, or shipping line.
token Dimension
A unique token associated with the order.
total_discount Metric
The total amount of discounts applied to an order or line item.
total_discount_set Dimension
The total amount discounted on an order, including both order and line-level discounts, represented as a monetary value object.
total_discounts Metric
The total amount of discounts applied to the order.
total_discounts_set Dimension
The total amount of discounts applied to the order, including its value in shop and presentment currencies.
total_duties Dimension
The total amount of duties applied to an order.
total_line_items_price Metric
The total price of all line items in the order before any order-level discounts or taxes.
total_line_items_price_set Dimension
The sum of prices of all line items before any discounts, taxes, or shipping are applied, including amounts in both shop and presentment currencies.
total_outstanding Metric
The total outstanding amount that still needs to be paid for the order.
total_price Metric
The grand total price of the order, including taxes and shipping after all discounts.
total_price_set Dimension
The total price of the order in both shop and presentment currencies.
total_price_usd Metric
The total price of the order converted to USD.
total_refunded totalRefundedSet.shopMoney.amount Metric
The total monetary amount that has been refunded for an order.
total_refunded_set Dimension
A monetary value object representing the total amount refunded for an order, including amount and currency code.
total_shipping_price_set Dimension
The total shipping price of the order in both shop and presentment currencies.
total_shipping_price_set.presentment_money.amount Metric
The monetary amount of the total shipping price in the currency presented to the customer.
total_shipping_price_set.presentment_money.currency_code Dimension
The currency code of the total shipping price in the currency presented to the customer.
total_shipping_price_set.shop_money.amount Metric
The monetary amount of the total shipping price in the shop's local currency.
total_shipping_price_set.shop_money.currency_code Dimension
The currency code of the total shipping price in the shop's local currency.
total_spent Metric
The total amount the customer has spent on orders in their lifetime.
total_tax Metric
The total tax amount charged for the order.
total_tax_set Dimension
The total amount of taxes applied to an order, including amounts in both shop and presentment currencies.
total_tax_set.presentment_money.amount Metric
The monetary amount of the total tax in the currency presented to the customer.
total_tax_set.presentment_money.currency_code Dimension
The currency code of the total tax in the currency presented to the customer.
total_tax_set.shop_money.amount Metric
The monetary amount of the total tax in the shop's local currency.
total_tax_set.shop_money.currency_code Dimension
The currency code of the total tax in the shop's local currency.
total_tip_received Metric
The total amount of tip received for the order.
total_unsettled_set.presentment_money.amount Metric
The total amount of unsettled funds in the currency presented to the customer.
total_unsettled_set.presentment_money.currency Dimension
The currency code of the unsettled funds as presented to the customer.
total_unsettled_set.shop_money.amount Metric
The total amount of unsettled funds in the shop's local currency.
total_unsettled_set.shop_money.currency Dimension
The currency code of the unsettled funds in the shop's local currency.
total_weight Metric
The total weight of the order in grams.
tracked Dimension
Indicates whether the inventory levels for an item are being tracked by Shopify.
updatedAt Dimension
The date and time (ISO 8601 format) when the resource was last updated.
updated_at Dimension
The date and time (ISO 8601 format) when the resource was last updated.
updated_at.date Dimension
The date when the order or resource was last updated.
user_id Dimension
The unique identifier of the user (e.g., staff member) who processed the order.
variant_id Dimension
The unique identifier for a product variant.
variant_inventory_management Dimension
The inventory management system used for a product variant (e.g., 'shopify' if tracked by Shopify, or 'null' if not tracked).
variant_title Dimension
The title of the product variant, often generated from its options (e.g., 'Small / Red').
variants.barcode Dimension
The barcode (UPC, ISBN, or GTIN) associated with the product variant.
variants.compare_at_price Metric
The original price of the product variant before any discounts.
variants.fulfillment_service Dimension
The fulfillment service associated with the product variant.
variants.grams Metric
The weight of the product variant in grams.
variants.id Dimension
The unique identifier of the product variant.
variants.image_id Dimension
The unique identifier of the image associated with the product variant.
variants.inventory_item_id Dimension
The unique identifier of the inventory item associated with the product variant.
variants.inventory_management Dimension
The inventory management system for the product variant (e.g., 'shopify', 'null').
variants.inventory_policy Dimension
The policy for inventory tracking, such as 'deny' (no backorders) or 'continue' (allow backorders).
variants.inventory_quantity Metric
The quantity of available inventory for a specific product variant.
variants.position Metric
The position of the variant in the list of product variants.
variants.price Metric
The price of the product variant.
variants.product_id Dimension
The unique identifier of the product this variant belongs to.
variants.requires_shipping Dimension
Indicates whether the product variant requires shipping.
variants.sku Dimension
The Stock Keeping Unit (SKU) for the product variant.
variants.tax_code Dimension
The tax classification code for the product variant.
variants.taxable Dimension
Indicates whether the product variant is subject to taxes.
variants.title Dimension
The title of the product variant.
variants.weight Metric
The weight of the product variant.
variants.weight_unit Dimension
The unit of measurement for the product variant's weight (e.g., 'kg', 'lb').
vendor Dimension
The name of the product's vendor or supplier.
verified_email Dimension
Indicates whether the customer has verified their email address. Defaults to true if created via admin or API.
zip Dimension
The zip or postal code of the address.