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
Billing city	Billing city	The city specified in the customer’s billing address.	dimension
Billing country	Billing country	The country specified in the customer’s billing address.	dimension
Billing region	Billing region	The state, province, or region specified in the customer’s billing address.	dimension
Created at	Created at	The timestamp indicating when a record or resource was created.	dimension
Day	Day	A temporal dimension representing a specific day, used for reporting and aggregating sales or other data on a daily basis.	dimension
Discounts	Discounts	The total monetary value of price reductions applied to an order or products.	dimension
Discounts adjustments	Discounts adjustments	The modifications or net effect of discounts applied to an order’s financial totals.	metric
Duties	Duties	Additional fees applied to an order, such as import duties or customs charges.	metric
Gross sales	Gross sales	The total amount of revenue generated from sales before any deductions for returns, allowances, or discounts.	dimension
Gross sales adjustments	Gross sales adjustments	Monetary changes or corrections applied to gross sales, which can include refunds, returns, or other edits made to an order after its initial creation.	metric
Net product quantity	Net product quantity	The quantity of products in an order after any adjustments, such as returns or cancellations.	metric
Net sales	Net sales	The total revenue from sales after subtracting returns, allowances, and discounts.	dimension
Order ID	Order ID	A unique internal identifier assigned by Shopify to each order.	metric
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
Ordered product quantity	Ordered product quantity	The total quantity of a specific product ordered by the customer within an order.	metric
Orders	Orders	A collection of customer purchase transactions, including details like products, customer information, and financial data.	dimension
Returned product quantity	Returned product quantity	The quantity of a particular product that has been returned by a customer.	metric
Returns	Returns	A collection of transactions where customers have sent back purchased items for a refund or exchange.	metric
Sales channel	Sales channel	The platform or avenue (e.g., online store, retail, social media) through which products are sold to customers.	dimension
Shipping	Shipping	The shipping costs associated with an order, including any discounts or taxes applied.	dimension
Shipping city	Shipping city	The city for the shipping destination.	dimension
Shipping country	Shipping country	The country for the shipping destination.	dimension
Shipping region	Shipping region	The state, province, or region for the shipping destination.	dimension
Taxes	Taxes	The total taxes applied to an order or its individual line items and shipping charges.	metric
Tips	Tips	Additional voluntary payments added by the customer to an order.	metric
Total order amount	Total order amount	The grand total value of an order, including products, shipping, and taxes, before any refunds.	metric
Updated at	Updated at	The timestamp indicating when a record or resource was last modified.	dimension
order_publication_id	order_publication_id	The unique identifier of the sales channel (publication) through which the order originated.	dimension
utm_campaign	utm_campaign	The UTM campaign parameter from the URL that led to the order or customer acquisition.	dimension
utm_content	utm_content	The UTM content parameter from the URL that led to the order or customer acquisition.	dimension
utm_medium	utm_medium	The UTM medium parameter from the URL that led to the order or customer acquisition.	dimension
utm_source	utm_source	The UTM source parameter from the URL that led to the order or customer acquisition.	dimension
utm_term	utm_term	The UTM term parameter from the URL that led to the order or customer acquisition.	dimension