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.
Billing address post code Dimension
The postal code or zip code of the billing address associated with the order. This maps to the `zip` field within the `BillingAddress` object.
Channel ID Dimension
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.
Channel name Dimension
The human-readable name of the sales channel (e.g., 'Online Store', 'Point of Sale'). This maps to `Channel.name` in the API.
Created at Dimension
The timestamp indicating when a record or resource was created.
Customer ID Dimension
The unique identifier for the customer. This maps to `Customer.id` in the API.
Customer email Dimension
The primary email address of the customer. This maps to `Customer.email` in the API.
Customer journey attribution ready Dimension
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.
Customer journey first session ID Dimension
The unique identifier for the customer's first recorded session leading to the order within the attribution window.
Customer journey first session UTM campaign Dimension
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.
Customer journey first session UTM content Dimension
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.
Customer journey first session UTM medium Dimension
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.
Customer journey first session UTM source Dimension
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.
Customer journey first session UTM term Dimension
The UTM term parameter captured during the customer's first session, indicating keywords or specific terms associated with the marketing campaign.
Customer journey first session landing page Dimension
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.
Customer journey first session occured at Dimension
The date and time when the customer's first session occurred, leading to the order within the attribution window.
Customer journey first session referral code Dimension
The marketing referral code from the link that the customer clicked to visit the store during their first session.
Customer journey first session referrer URL Dimension
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.
Customer journey first session source Dimension
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.
Customer journey first session source description Dimension
A detailed description of the source from which the customer visited the store during their first session, providing more context than the source type.
Customer journey first session source type Dimension
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.
Customer journey last session ID Dimension
The unique identifier for the customer's last recorded session immediately preceding the order within the attribution window.
Customer journey last session UTM campaign Dimension
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.
Customer journey last session UTM content Dimension
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.
Customer journey last session UTM medium Dimension
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.
Customer journey last session UTM source Dimension
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.
Customer journey last session UTM term Dimension
The UTM term parameter captured during the customer's last session, indicating keywords or specific terms associated with the marketing campaign.
Customer journey last session landing page Dimension
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.
Customer journey last session occured at Dimension
The date and time when the customer's last session occurred, immediately preceding the order within the attribution window.
Customer journey last session referral code Dimension
The marketing referral code from the link that the customer clicked to visit the store during their last session.
Customer journey last session referrer URL Dimension
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.
Customer journey last session source Dimension
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.
Customer journey last session source description Dimension
A detailed description of the source from which the customer visited the store during their last session, providing more context than the source type.
Customer journey last session source type Dimension
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.
Customer journey order index Metric
The sequential position of the current order within the customer's complete purchase history.
Customer number of orders Metric
The total number of orders placed by a specific customer. This value is retrieved by filtering the `ordersCount` query with the customer's unique ID or email address.
Day Dimension
A temporal dimension representing a specific day, used for reporting and aggregating sales or other data on a daily basis.
Line items quantities Metric
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.
Order ID Dimension
A unique internal identifier assigned by Shopify to each order.
Order id Metric
A unique internal identifier assigned by Shopify to each order.
Order name Dimension
A customer-facing and customizable name or number for an order, often visible in the Shopify admin.
Processed at Dimension
The date and time when an order was processed.
Publication name Dimension
The name of the publication or sales channel where a product or collection is published. This relates to the `Channel.name` field.
Shipping address country Dimension
The country specified in the shipping address for the order. This maps to the `country` field within the `ShippingAddress` object.
Tags Dimension
A list of searchable, custom tags associated with an order or customer. This is a standard field on `Order` and `Customer` objects.
Total discounts amount Metric
The total monetary amount of all discounts applied to an order. This is represented by `totalDiscountsSet.shopMoney.amount` on the `Order` object.
Total order amount Metric
The grand total value of an order, including products, shipping, and taxes, before any refunds.
Total shipping amount Metric
The total monetary amount charged for shipping on an order. This is represented by `totalShippingPriceSet.shopMoney.amount` on the `Order` object.
Total tax amount Metric
The total monetary amount of all taxes applied to an order. This is represented by `totalTaxSet.shopMoney.amount` on the `Order` object.
Updated at Dimension
This field captures the date and time when a specific record, such as an order, product, or collection, was last modified in Shopify. This timestamp can change due to various actions, including inventory adjustments or other updates to the record's attributes.
date Dimension
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`).
orders Metric
Represents a collection of customer orders. This refers to the `Order` object in the Shopify GraphQL Admin API.
revenue Metric
Represents the total sales revenue generated by the Shopify store. This value is derived from the sales dataset, which reflects sale agreements with customers, including pending and unpaid orders, rather than strictly completed revenue. It reports when there's a reasonable belief that the value will be exchanged, but does not wait for actual payment or fulfillment.