Shopify (GraphQL): Most-used fields

The table below gives information about most-used fields that you can import from Shopify (GraphQL). 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.

API name	Adverity UI name	Description	Use in Adverity
Additional fees amount	Additional fees amount	The monetary value of additional charges applied to an order beyond standard product and shipping costs, such as duties, import fees, or special handling charges.	dimension
Billing address post code	Billing address post code	The postal code or zip code of the billing address associated with the order. This maps to the zip field within the BillingAddress object.	dimension
Cancel reason	Cancel reason	The reason provided for why an order was canceled, such as customer request, payment decline, fraud, or insufficient inventory.	dimension
Cancelled at	Cancelled at	The date and time in ISO 8601 format when an order was canceled. This field is null if the order has not been canceled.	dimension
Channel ID	Channel ID	The unique identifier for the sales channel through which the order was placed or a product was published. This maps to Channel.id in the API.	dimension
Channel name	Channel name	The human-readable name of the sales channel (e.g., ‘Online Store’, ‘Point of Sale’). This maps to Channel.name in the API.	dimension
Closed at	Closed at	The date and time in ISO 8601 format when an order was closed. An order is considered closed when all its line items have been fulfilled or canceled, and all financial transactions are complete.	dimension
Created at	Created at	The timestamp indicating when a record or resource was created.	dimension
Current cart discount amount	Current cart discount amount	The total amount of all discounts applied to the entire order after any returns, refunds, order edits, and cancellations. This includes discount codes and automatic discounts.	metric
Customer ID	Customer ID	The unique identifier for the customer. This maps to Customer.id in the API.	dimension
Customer email	Customer email	The primary email address of the customer. This maps to Customer.email in the API.	dimension
Customer journey attribution ready	Customer journey attribution ready	Indicates whether data relevant to customer journey tracking and marketing attribution, such as session data, attribution sources (e.g., UTM parameters, referrers), and the timeline from initial visit to purchase, has been collected and is available for analysis. This leverages Shopify’s CustomerJourney and CustomerJourneySummary objects.	dimension
Customer journey first session ID	Customer journey first session ID	The unique identifier for the customer’s first recorded session leading to the order within the attribution window.	dimension
Customer journey first session UTM campaign	Customer journey first session UTM campaign	The UTM campaign parameter from the customer’s first session, indicating the specific marketing campaign that drove the visit. This is part of the utmParameters.campaign field within CustomerVisit or CustomerJourneySummary objects.	dimension
Customer journey first session UTM content	Customer journey first session UTM content	The UTM content parameter from the customer’s first session, used to differentiate between similar content or links within a marketing campaign. This is part of the utmParameters.content field within CustomerVisit or CustomerJourneySummary objects.	dimension
Customer journey first session UTM medium	Customer journey first session UTM medium	The UTM medium parameter from the customer’s first session, indicating the marketing medium (e.g., email, CPC). This is part of the utmParameters.medium field within CustomerVisit or CustomerJourneySummary objects.	dimension
Customer journey first session UTM source	Customer journey first session UTM source	The UTM source parameter from the customer’s first session, indicating where the traffic originated (e.g., Google, Facebook). This is part of the utmParameters.source field within CustomerVisit or CustomerJourneySummary objects.	dimension
Customer journey first session UTM term	Customer journey first session UTM term	The UTM term parameter captured during the customer’s first session, indicating keywords or specific terms associated with the marketing campaign.	dimension
Customer journey first session landing page	Customer journey first session landing page	The URL of the first page the customer landed on during their initial session. This is represented by the landingPage property within CustomerJourneySummary or CustomerVisit objects in the GraphQL Admin API.	dimension
Customer journey first session occured at	Customer journey first session occured at	The date and time when the customer’s first session occurred, leading to the order within the attribution window.	dimension
Customer journey first session referral code	Customer journey first session referral code	The marketing referral code from the link that the customer clicked to visit the store during their first session.	dimension
Customer journey first session referrer URL	Customer journey first session referrer URL	The URL of the page that referred the customer to the store for their first session. This is part of the referrerUrl field within CustomerJourneySummary or CustomerVisit objects.	dimension
Customer journey first session source	Customer journey first session source	The high-level source of traffic for the customer’s first session (e.g., direct, organic, referral). This is part of the source field within CustomerJourneySummary or CustomerVisit objects.	dimension
Customer journey first session source description	Customer journey first session source description	A detailed description of the source from which the customer visited the store during their first session, providing more context than the source type.	dimension
Customer journey first session source type	Customer journey first session source type	The type of source from which the customer visited the store during their first session, such as a platform (e.g., Facebook, Google), email, direct, or unknown.	dimension
Customer journey last session ID	Customer journey last session ID	The unique identifier for the customer’s last recorded session immediately preceding the order within the attribution window.	dimension
Customer journey last session UTM campaign	Customer journey last session UTM campaign	The UTM campaign parameter from the customer’s last session, indicating the specific marketing campaign that drove the most recent visit. This is part of the utmParameters.campaign field within CustomerVisit or CustomerJourneySummary objects.	dimension
Customer journey last session UTM content	Customer journey last session UTM content	The UTM content parameter from the customer’s last session, used to differentiate between similar content or links within a campaign. This is part of the utmParameters.content field within CustomerVisit or CustomerJourneySummary objects.	dimension
Customer journey last session UTM medium	Customer journey last session UTM medium	The UTM medium parameter from the customer’s last session, indicating the marketing medium (e.g., email, CPC). This is part of the utmParameters.medium field within CustomerVisit or CustomerJourneySummary objects.	dimension
Customer journey last session UTM source	Customer journey last session UTM source	The UTM source parameter from the customer’s last session, indicating where the traffic originated (e.g., Google, Facebook). This is part of the utmParameters.source field within CustomerVisit or CustomerJourneySummary objects.	dimension
Customer journey last session UTM term	Customer journey last session UTM term	The UTM term parameter captured during the customer’s last session, indicating keywords or specific terms associated with the marketing campaign.	dimension
Customer journey last session landing page	Customer journey last session landing page	The URL of the last page the customer landed on during their most recent session. This is represented by the landingPage property within CustomerJourneySummary or CustomerVisit objects in the GraphQL Admin API.	dimension
Customer journey last session occured at	Customer journey last session occured at	The date and time when the customer’s last session occurred, immediately preceding the order within the attribution window.	dimension
Customer journey last session referral code	Customer journey last session referral code	The marketing referral code from the link that the customer clicked to visit the store during their last session.	dimension
Customer journey last session referrer URL	Customer journey last session referrer URL	The URL of the page that referred the customer to the store for their last session. This is part of the referrerUrl field within CustomerJourneySummary or CustomerVisit objects.	dimension
Customer journey last session source	Customer journey last session source	The high-level source of traffic for the customer’s last session (e.g., direct, organic, referral). This is part of the source field within CustomerJourneySummary or CustomerVisit objects.	dimension
Customer journey last session source description	Customer journey last session source description	A detailed description of the source from which the customer visited the store during their last session, providing more context than the source type.	dimension
Customer journey last session source type	Customer journey last session source type	The type of source from which the customer visited the store during their last session, such as a platform (e.g., Facebook, Google), email, direct, or unknown.	dimension
Customer journey order index	Customer journey order index	The sequential position of the current order within the customer’s complete purchase history.	metric
Customer sale type (by fetch date)	Customer sale type (by fetch date)	Represents the type of line item associated with a sale, such as product, shipping, additional fee, duty, or gift card. This categorizes the nature of the transaction from a customer’s perspective.	dimension
Day	Day	A temporal dimension representing a specific day, used for reporting and aggregating sales or other data on a daily basis.	dimension
Discount code	Discount code	The specific code entered by a customer to apply a discount to an order. This field is null if no discount code was applied.	dimension
Discount codes	Discount codes	A collection of all discount applications on an order, which can include both specific discount codes and automatic discounts that reduce the order’s total.	dimension
Financial status	Financial status	The current financial status of an order, such as pending, authorized, paid, partially refunded, or refunded, as displayed in the Shopify admin.	dimension
Line items quantities	Line items quantities	The total quantity of all individual items (line items) within an order. This is a sum of the LineItem.quantity for all line items associated with an order.	metric
Order ID	Order ID	A unique internal identifier assigned by Shopify to each order.	dimension
Order closed	Order closed	A boolean indicator specifying whether an order has been marked as closed. A closed order implies all line items are fulfilled or canceled, and all financial transactions are complete.	dimension
Order id	Order id	A unique internal identifier assigned by Shopify to each order.	metric
Order name	Order name	A customer-facing and customizable name or number for an order, often visible in the Shopify admin.	dimension
Order net payment amount	Order net payment amount	The total amount of money received for an order after all applicable discounts, returns, and allowances have been applied.	metric
Processed at	Processed at	The date and time when an order was processed.	dimension
Publication name	Publication name	The name of the publication or sales channel where a product or collection is published. This relates to the Channel.name field.	dimension
Return status	Return status	The aggregated return status for an order, which indicates the overall state of any associated returns, such as requested, approved, or completed.	dimension
Shipping address country	Shipping address country	The country specified in the shipping address for the order. This maps to the country field within the ShippingAddress object.	dimension
Tags	Tags	A list of searchable, custom tags associated with an order or customer. This is a standard field on Order and Customer objects.	dimension
Tax lines amount	Tax lines amount	The total monetary amount of taxes applied to line items or shipping lines on an order, calculated after discounts and before returns, in both shop and presentment currencies.	dimension
Tax lines rate	Tax lines rate	The proportional rate at which tax is applied to a line item or shipping line, represented as a decimal or percentage.	dimension
Total discounts amount	Total discounts amount	The total monetary amount of all discounts applied to an order. This is represented by totalDiscountsSet.shopMoney.amount on the Order object.	metric
Total order amount	Total order amount	The grand total value of an order, including products, shipping, and taxes, before any refunds.	metric
Total refunded amount	Total refunded amount	The sum of all money returned to a customer for an order, encompassing all refunded amounts and associated transactions.	metric
Total shipping amount	Total shipping amount	The total monetary amount charged for shipping on an order. This is represented by totalShippingPriceSet.shopMoney.amount on the Order object.	metric
Total tax amount	Total tax amount	The total monetary amount of all taxes applied to an order. This is represented by totalTaxSet.shopMoney.amount on the Order object.	metric
Updated at	Updated at	The timestamp indicating when a record or resource was last modified.	dimension
Variant ID	Variant ID	The unique identifier for a specific product variant. A product variant represents a particular version of a product, such as a different size or color.	dimension
Variant Inventory quantity	Variant Inventory quantity	The available stock quantity for a particular product variant, used for inventory tracking and management.	metric
Variant SKU	Variant SKU	A unique identifier for a specific product variant, used for inventory tracking, searching, and connecting to fulfillment services.	dimension
Variant compare at price	Variant compare at price	The original or ‘MSRP’ price of a product variant, against which the current selling price can be compared to show a discount or saving to the customer. This price is in the default shop currency.	metric
Variant price	Variant price	The price of a specific product variant in the shop’s default currency. This can include a standard price and a compare-at price, and can be influenced by price lists.	metric
Variant title	Variant title	The descriptive title of a specific product variant, often including details like size, color, or style, to differentiate it from other variants of the same product.	dimension
createdAt	createdAt	The date and time when the record (e.g., order, customer) was created. This is a standard API field available on many Shopify GraphQL objects.	dimension
createdAt.date	createdAt.date	The date and time when the record (e.g., Order, Product, Discount code) was created.	dimension
customer_id	customer_id	The unique identifier for the customer. This is an alias for ‘Customer ID’ and maps to Customer.id in the API.	dimension
customer_type	customer_type	A classification used to categorize customers based on attributes such as their purchase history, marketing preferences, or whether they represent a business entity (B2B). While not a direct API field, this data can be derived from various customer properties available through the API.	dimension
date	date	A timestamp indicating a specific point in time related to an order or resource, such as when an order was created (createdAt) or last updated (updatedAt).	dimension
descriptionHtml	descriptionHtml	The detailed description of a product, which can include HTML tags for formatting text such as bold or italic.	dimension
handle	handle	A unique, URL-friendly string derived from the product’s title, used to identify the product in online store URLs.	dimension
id	id	The unique identifier for the discount entry.	dimension
numberOfOrders	numberOfOrders	The total count of orders placed by a customer. This can be retrieved by querying the Customer.orders.totalCount or similar aggregation of orders associated with a customer.	metric
order_date	order_date	The date when the order was placed by the customer. This is often represented by a date component of createdAt on the Order object and can be used as a filter for order queries.	dimension
orders	orders	Represents a collection of customer orders. This refers to the Order object in the Shopify GraphQL Admin API.	metric
ownerId	ownerId	The globally unique identifier (GID) of the resource that owns a specific record, such as the customer, product, product variant, collection, or order to which a metafield is attached.	metric
productType	productType	A categorization defined by merchants to classify their products, aiding in organization and filtering.	dimension
revenue	revenue	The total monetary value generated from sales. For orders, this typically refers to the totalPriceSet which includes taxes and discounts. It can also refer to AppRevenueAttributionRecord for revenue captured outside Shopify’s billing system.	metric
tags	tags	Keywords or labels assigned to products to help categorize, filter, and organize them for both merchants and customers.	dimension
title	title	The primary name given to a product, used for identification and display across the store.	dimension
updatedAt	updatedAt	The date and time when the record (e.g., order, customer) was last updated. This is a standard API field available on many Shopify GraphQL objects.	dimension
updatedAt.date	updatedAt.date	The date and time when the record (e.g., Order, Metafield, Discount code, Return, Collection) was last updated or modified.	dimension
vendor	vendor	The name of the company or individual that supplies the product.	dimension