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
Created at	Created at	The timestamp indicating when a record or resource was created.	dimension
Created at date	Created at date	The date and time when the discount 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
Discount code	Discount code	The actual code that customers enter to redeem the discount.	dimension
Discount redeem code ID	Discount redeem code ID	The unique identifier for a specific, individually generated discount redeem code.	dimension
Ends at	Ends at	The date and time when the discount promotion ends and is no longer valid for use.	dimension
Ends at date	Ends at date	The calendar date on which the discount promotion ends.	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
Starts at	Starts at	The date and time when the discount promotion becomes active and can be used by customers.	dimension
Starts at date	Starts at date	The calendar date on which the discount promotion becomes active.	dimension
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
Updated at date	Updated at date	The date and time when the discount record was last modified or updated.	dimension
id	id	The unique identifier for the discount entry.	metric