Shopify (GraphQL)

The table below gives information about all the data fields that you can import from Shopify (GraphQL).

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs. As a result, the fields shown here may not be the same as the fields available in Adverity. If you notice a difference between this documentation and the fields you see in Adverity, please contact your Adverity account manager for more information.

To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.

Field UI name	Field API name	Use in Adverity
Additional fees	Additional fees	metric
Additional fees ID	Additional fees ID	dimension
Additional fees amount	Additional fees amount	dimension
Additional fees amount currency code	Additional fees amount currency code	dimension
Additional fees name	Additional fees name	dimension
Additional fees tax amount	Additional fees tax amount	dimension
Additional fees tax amount currency code	Additional fees tax amount currency code	dimension
Allocation limit	Allocation limit	dimension
Allocation method	Allocation method	dimension
Amount	Amount	metric
Biling address matches shipping address	Biling address matches shipping address	dimension
Billing address city	Billing address city	dimension
Billing address country	Billing address country	dimension
Billing address line 1	Billing address line 1	dimension
Billing address line 2	Billing address line 2	dimension
Billing address post code	Billing address post code	dimension
Billing city	Billing city	dimension
Billing country	Billing country	dimension
Billing region	Billing region	dimension
Cancel reason	Cancel reason	dimension
Cancellation staff note	Cancellation staff note	dimension
Cancelled at	Cancelled at	dimension
Capturable payment	Capturable payment	dimension
Channel ID	Channel ID	dimension
Channel name	Channel name	dimension
Closed at	Closed at	dimension
Confirmation number	Confirmation number	dimension
Country	Country	dimension
Created at	Created at	dimension
Created at date	Created at date	dimension
Currency	Currency	dimension
Currency code	Currency code	dimension
Current cart discount amount	Current cart discount amount	metric
Current cart discount amount currency code	Current cart discount amount currency code	dimension
Custom attributes name	Custom attributes name	dimension
Custom attributes value	Custom attributes value	dimension
Customer ID	Customer ID	dimension
Customer accepts marketing	Customer accepts marketing	dimension
Customer days to conversion	Customer days to conversion	dimension
Customer email	Customer email	dimension
Customer full name	Customer full name	dimension
Customer journey attribution ready	Customer journey attribution ready	dimension
Customer journey first session ID	Customer journey first session ID	dimension
Customer journey first session UTM campaign	Customer journey first session UTM campaign	dimension
Customer journey first session UTM content	Customer journey first session UTM content	dimension
Customer journey first session UTM medium	Customer journey first session UTM medium	dimension
Customer journey first session UTM source	Customer journey first session UTM source	dimension
Customer journey first session UTM term	Customer journey first session UTM term	dimension
Customer journey first session landing page	Customer journey first session landing page	dimension
Customer journey first session occured at	Customer journey first session occured at	dimension
Customer journey first session referral code	Customer journey first session referral code	dimension
Customer journey first session referrer URL	Customer journey first session referrer URL	dimension
Customer journey first session source	Customer journey first session source	dimension
Customer journey first session source description	Customer journey first session source description	dimension
Customer journey first session source type	Customer journey first session source type	dimension
Customer journey last session ID	Customer journey last session ID	dimension
Customer journey last session UTM campaign	Customer journey last session UTM campaign	dimension
Customer journey last session UTM content	Customer journey last session UTM content	dimension
Customer journey last session UTM medium	Customer journey last session UTM medium	dimension
Customer journey last session UTM source	Customer journey last session UTM source	dimension
Customer journey last session UTM term	Customer journey last session UTM term	dimension
Customer journey last session landing page	Customer journey last session landing page	dimension
Customer journey last session occured at	Customer journey last session occured at	dimension
Customer journey last session referral code	Customer journey last session referral code	dimension
Customer journey last session referrer URL	Customer journey last session referrer URL	dimension
Customer journey last session source	Customer journey last session source	dimension
Customer journey last session source description	Customer journey last session source description	dimension
Customer journey last session source type	Customer journey last session source type	dimension
Customer journey moments count	Customer journey moments count	metric
Customer journey moments count precision	Customer journey moments count precision	dimension
Customer journey order index	Customer journey order index	metric
Customer lifetime duration	Customer lifetime duration	dimension
Customer locale	Customer locale	dimension
Customer predicted spend tier	Customer predicted spend tier	dimension
Customer selection for all customers	Customer selection for all customers	dimension
Day	Day	dimension
Discount class	Discount class	dimension
Discount code	Discount code	dimension
Discount codes	Discount codes	dimension
Discount redeem code ID	Discount redeem code ID	dimension
Discounts	Discounts	metric
Discounts adjustments	Discounts adjustments	metric
Disputes ID	Disputes ID	dimension
Disputes initiated as	Disputes initiated as	dimension
Disputes status	Disputes status	dimension
Duties	Duties	metric
Ends at	Ends at	dimension
Ends at date	Ends at date	dimension
Entitlement quantity	Entitlement quantity	dimension
Estimated taxes	Estimated taxes	dimension
Financial status	Financial status	dimension
Fulfillable	Fulfillable	dimension
Fulfillment status	Fulfillment status	dimension
Fully paid	Fully paid	dimension
Gross sales	Gross sales	metric
Gross sales adjustments	Gross sales adjustments	metric
ID	ID	dimension
Inventory reservation confirmed	Inventory reservation confirmed	dimension
Line items quantities	Line items quantities	metric
Net product quantity	Net product quantity	metric
Net sales	Net sales	metric
Once per customer	Once per customer	dimension
Order ID	Order ID	metric
Order closed	Order closed	dimension
Order currency code	Order currency code	dimension
Order edited	Order edited	dimension
Order id	Order id	metric
Order name	Order name	metric
Order net payment amount	Order net payment amount	metric
Order note	Order note	dimension
Ordered product quantity	Ordered product quantity	metric
Orders	Orders	metric
Percentage	Percentage	metric
Prerequisite quantity	Prerequisite quantity	dimension
Prerequisite quantity range greater than	Prerequisite quantity range greater than	dimension
Prerequisite quantity range greater than or equal to	Prerequisite quantity range greater than or equal to	dimension
Prerequisite quantity range less than	Prerequisite quantity range less than	dimension
Prerequisite quantity range less than or equal to	Prerequisite quantity range less than or equal to	dimension
Prerequisite shipping price range greater than	Prerequisite shipping price range greater than	dimension
Prerequisite shipping price range greater than or equal to	Prerequisite shipping price range greater than or equal to	dimension
Prerequisite shipping price range less than	Prerequisite shipping price range less than	dimension
Prerequisite shipping price range less than or equal to	Prerequisite shipping price range less than or equal to	dimension
Prerequisite subtotal range greater than	Prerequisite subtotal range greater than	dimension
Prerequisite subtotal range greater than or equal to	Prerequisite subtotal range greater than or equal to	metric
Prerequisite subtotal range less than	Prerequisite subtotal range less than	dimension
Prerequisite subtotal range less than or equal to	Prerequisite subtotal range less than or equal to	dimension
Processed at	Processed at	dimension
Publication ID	Publication ID	dimension
Publication name	Publication name	dimension
Refundable	Refundable	dimension
Requires shipping	Requires shipping	dimension
Restockable	Restockable	dimension
Return status	Return status	dimension
Returned product quantity	Returned product quantity	metric
Returns	Returns	metric
Sales channel	Sales channel	dimension
Shipping	Shipping	metric
Shipping address 1	Shipping address 1	dimension
Shipping address 2	Shipping address 2	dimension
Shipping address city	Shipping address city	dimension
Shipping address country	Shipping address country	dimension
Shipping address post code	Shipping address post code	dimension
Shipping city	Shipping city	dimension
Shipping country	Shipping country	dimension
Shipping lines removed	Shipping lines removed	dimension
Shipping region	Shipping region	dimension
Starts at	Starts at	dimension
Starts at date	Starts at date	dimension
Status	Status	dimension
Tags	Tags	dimension
Target	Target	dimension
Target all line items	Target all line items	dimension
Target all shipping lines	Target all shipping lines	dimension
Tax exempt	Tax exempt	dimension
Tax lines amount	Tax lines amount	dimension
Tax lines channel liable	Tax lines channel liable	dimension
Tax lines rate	Tax lines rate	dimension
Tax lines rate percentage	Tax lines rate percentage	dimension
Tax lines title	Tax lines title	dimension
Taxes	Taxes	metric
Taxes included	Taxes included	dimension
Tips	Tips	metric
Title	Title	dimension
Total discounts amount	Total discounts amount	metric
Total duties amount	Total duties amount	dimension
Total order amount	Total order amount	metric
Total outstanding amount	Total outstanding amount	metric
Total refunded amount	Total refunded amount	metric
Total refunded shipping amount	Total refunded shipping amount	metric
Total shipping amount	Total shipping amount	metric
Total tax amount	Total tax amount	metric
Total tip received amount	Total tip received amount	metric
Total weight	Total weight	metric
Updated at	Updated at	dimension
Updated at date	Updated at date	dimension
Usage count	Usage count	metric
Usage limit	Usage limit	metric
additionalFees	additionalFees	dimension
channelInformation	channelInformation	dimension
channelInformation.channelDefinition	channelInformation.channelDefinition	dimension
customer	customer	dimension
customerJourneySummary.firstVisit	customerJourneySummary.firstVisit	dimension
exchangeLineItems.id	exchangeLineItems.id	dimension
exchangeLineItems.lineItem.id	exchangeLineItems.lineItem.id	dimension
fulfillmentLineItem.lineItem.id	fulfillmentLineItem.lineItem.id	dimension
id	id	dimension
metafield.id	metafield.id	metric
metafield.key	metafield.key	dimension
metafield.namespace	metafield.namespace	dimension
metafield.ownerType	metafield.ownerType	dimension
metafield.value	metafield.value	dimension
numberOfOrders	numberOfOrders	metric
order_publication_id	order_publication_id	dimension
ownerId	ownerId	metric
return.id	return.id	dimension
return.name	return.name	dimension
return.order.created_at	return.order.created_at	dimension
return.order.id	return.order.id	dimension
return.status	return.status	dimension
return.totalQuantity	return.totalQuantity	metric
returnLineItems.customerNote	returnLineItems.customerNote	dimension
returnLineItems.id	returnLineItems.id	dimension
returnLineItems.quantity	returnLineItems.quantity	metric
returnLineItems.refundableQuantity	returnLineItems.refundableQuantity	metric
returnLineItems.refundedQuantity	returnLineItems.refundedQuantity	metric
returnLineItems.returnReason	returnLineItems.returnReason	dimension
returnLineItems.returnReasonNote	returnLineItems.returnReasonNote	dimension
totalDiscountsSet.shopMoney	totalDiscountsSet.shopMoney	dimension
totalPriceSet.shopMoney	totalPriceSet.shopMoney	dimension
totalShippingPriceSet.shopMoney	totalShippingPriceSet.shopMoney	dimension
totalTaxSet.shopMoney	totalTaxSet.shopMoney	dimension
utm_campaign	utm_campaign	dimension
utm_content	utm_content	dimension
utm_medium	utm_medium	dimension
utm_source	utm_source	dimension
utm_term	utm_term	dimension