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	Use in Adverity
Amount	Amount	dimension
App title	App title	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
Calendar Month	Calendar Month	dimension
Calendar Year	Calendar Year	metric
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
Customer ID	Customer ID	dimension
Customer accepts marketing	Customer accepts marketing	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 order index	Customer journey order index	metric
Customer locale	Customer locale	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 status	Disputes status	dimension
Duties	Duties	metric
Ends at	Ends at	dimension
Ends at date	Ends at date	dimension
Estimated taxes	Estimated taxes	dimension
Financial status	Financial status	dimension
Fiscal Month	Fiscal Month	dimension
Fiscal Year	Fiscal Year	metric
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
Max Month	Max Month	metric
Max date	Max date	dimension
Min Date	Min Date	dimension
Min Month	Min Month	metric
Net product quantity	Net product quantity	metric
Net sales	Net sales	metric
Once per customer	Once per customer	dimension
Order Count	Order Count	metric
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	dimension
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	metric
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
Start Date	Start Date	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
Variant ID	Variant ID	metric
Variant Inventory quantity	Variant Inventory quantity	metric
Variant SKU	Variant SKU	dimension
Variant barcode	Variant barcode	dimension
Variant compare at price	Variant compare at price	dimension
Variant image ID	Variant image ID	dimension
Variant inventory item ID	Variant inventory item ID	dimension
Variant inventory policy	Variant inventory policy	dimension
Variant position	Variant position	metric
Variant price	Variant price	metric
Variant product ID	Variant product ID	dimension
Variant requires shipping	Variant requires shipping	dimension
Variant tax code	Variant tax code	dimension
Variant taxable	Variant taxable	dimension
Variant title	Variant title	dimension
Variant weight	Variant weight	metric
Variant weight unit	Variant weight unit	dimension
Week	Week	metric
Week Range	Week Range	dimension
addresses	addresses	dimension
channelInformation	channelInformation	dimension
channelInformation.channelDefinition	channelInformation.channelDefinition	dimension
channel_name	channel_name	dimension
createdAt	createdAt	dimension
createdAt.date	createdAt.date	dimension
currency	currency	dimension
customer	customer	dimension
customer.created	customer.created	dimension
customerJourneySummary.firstVisit	customerJourneySummary.firstVisit	dimension
customer_id	customer_id	dimension
date	date	dimension
descriptionHtml	descriptionHtml	dimension
discount_amount	discount_amount	metric
email	email	dimension
emailMarketingConsent.consentUpdatedAt	emailMarketingConsent.consentUpdatedAt	dimension
emailMarketingConsent.marketingOptInLevel	emailMarketingConsent.marketingOptInLevel	dimension
emailMarketingConsent.marketingState	emailMarketingConsent.marketingState	dimension
exchangeLineItems.id	exchangeLineItems.id	dimension
exchangeLineItems.lineItem.id	exchangeLineItems.lineItem.id	dimension
firstName	firstName	dimension
fulfillmentLineItem.lineItem.id	fulfillmentLineItem.lineItem.id	dimension
gross_sales	gross_sales	metric
handle	handle	dimension
id	id	dimension
lastName	lastName	dimension
metafield.createdAt	metafield.createdAt	dimension
metafield.description	metafield.description	dimension
metafield.id	metafield.id	metric
metafield.key	metafield.key	dimension
metafield.namespace	metafield.namespace	dimension
metafield.ownerType	metafield.ownerType	dimension
metafield.type	metafield.type	dimension
metafield.updatedAt	metafield.updatedAt	dimension
metafield.value	metafield.value	dimension
multipassIdentifier	multipassIdentifier	dimension
netPaymentSet.shopMoney	netPaymentSet.shopMoney	dimension
net_payment_amount	net_payment_amount	metric
note	note	dimension
numberOfOrders	numberOfOrders	metric
options	options	dimension
order_date	order_date	dimension
order_publication_id	order_publication_id	dimension
orders	orders	metric
ownerId	ownerId	metric
phone	phone	metric
productType	productType	dimension
publishedAt	publishedAt	dimension
publishedAt.date	publishedAt.date	dimension
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.order.updated_at	return.order.updated_at	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
revenue	revenue	metric
shipping_amount	shipping_amount	metric
shop.address1	shop.address1	dimension
shop.address2	shop.address2	dimension
shop.city	shop.city	dimension
shop.country	shop.country	dimension
shop.created_at	shop.created_at	dimension
shop.currency	shop.currency	dimension
shop.customer_email	shop.customer_email	dimension
shop.domain	shop.domain	dimension
shop.email	shop.email	dimension
shop.finances	shop.finances	dimension
shop.iana_timezone	shop.iana_timezone	dimension
shop.id	shop.id	metric
shop.latitude	shop.latitude	metric
shop.longitude	shop.longitude	metric
shop.name	shop.name	dimension
shop.phone	shop.phone	dimension
shop.plan_name	shop.plan_name	dimension
shop.province	shop.province	dimension
shop.province_code	shop.province_code	dimension
shop.shop_owner	shop.shop_owner	dimension
shop.source	shop.source	dimension
shop.timezone	shop.timezone	dimension
shop.updated_at	shop.updated_at	dimension
shop.zip	shop.zip	dimension
state	state	dimension
status	status	dimension
tags	tags	dimension
taxExempt	taxExempt	dimension
templateSuffix	templateSuffix	dimension
title	title	dimension
totalDiscountsSet.shopMoney	totalDiscountsSet.shopMoney	dimension
totalOutstandingSet.shopMoney	totalOutstandingSet.shopMoney	dimension
totalPriceSet.shopMoney	totalPriceSet.shopMoney	dimension
totalRefundedSet.shopMoney	totalRefundedSet.shopMoney	dimension
totalRefundedShippingSet.shopMoney	totalRefundedShippingSet.shopMoney	dimension
totalShippingPriceSet.shopMoney	totalShippingPriceSet.shopMoney	dimension
totalSpent	totalSpent	metric
totalTaxSet.shopMoney	totalTaxSet.shopMoney	dimension
total_order_amount	total_order_amount	metric
total_sales	total_sales	metric
updatedAt	updatedAt	dimension
updatedAt.date	updatedAt.date	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
vendor	vendor	dimension
verifiedEmail	verifiedEmail	dimension