Shopify

Orders

report_type: orders · 14 metrics · 28 dimensions

Metrics

Field name	Label	Type
`num_of_orders`	Ordersformula	NUMBER
`AOV`	Average order valueformula	NUMBER
`order_discount_amount`	Order level discount share	NUMBER
`order_gross_amount`	Gross sales	NUMBER
`order_net_amount`	Net sales	NUMBER
`order_received_amount`	Order received amount	NUMBER
`order_refunded_amount`	Returns	NUMBER
`order_shipping_amount`	Shipping	NUMBER
`order_tax_amount`	Order tax	NUMBER
`order_total_amount`	Total sales	NUMBER
`order_total_discount_amount`	Discounts	NUMBER
`order_total_tip_received`	Tips	NUMBER
`orders`	IsOrder	NUMBER
`subtotalLineItemsQuantity`	Items	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`dataFreshness`	PMA data freshness	STRING
`date`	Date and time	STRING
`entity_id`	Entity ID	STRING
`order_id`	Order ID	STRING
`shop_id`	Shop ID	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`year_week`	Year weekformula	STRING
`dataPlatform`	Data platform	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Base orders and line items

report_type: base_orders_and_line_items · 0 metrics · 11 dimensions

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Orders dimensions

report_type: orders_dimensions · 6 metrics · 81 dimensions

Metrics

Field name	Label	Type
`num_of_orders`	Ordersformula	NUMBER
`returning_customer_rate`	Returning customer rateformula	NUMBER
`num_of_customers`	Customersformula	NUMBER
`is_returning_customer`	Is returning customer	NUMBER
`requiresShipping`	Requires shipping	NUMBER
`restockable`	Restockable	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`is_returning_customer_readable`	Customer typeformula	STRING
`customer_name`	Customer nameformula	STRING
`billingAddress_city`	Billing city	STRING
`billingAddress_company`	Billing company	STRING
`billingAddress_country`	Billing country/region	STRING
`billingAddress_province`	Billing region	STRING
`billingAddress_zip`	Billing postal code	STRING
`cancelReason`	Cancel reason	STRING
`cancelledAt`	Cancelled date	STRING
`channel_name`	Sales channel name	STRING
`currencyCode`	Checkout currency	STRING
`customerID`	Customer ID number	STRING
`customer_id`	Customer ID	STRING
`customer_email`	Customer email	STRING
`customer_firstName`	Customer first name	STRING
`customer_lastName`	Customer last name	STRING
`customer_tags`	Customer tags	STRING
`customerJourney_firstVisit_landingPage`	First visit landing page	STRING
`customerJourney_firstVisit_referralCode`	First visit referral code	STRING
`customerJourney_firstVisit_referrerUrl`	Referrer URL first	STRING
`customerJourney_firstVisit_source`	Referrer name first	STRING
`customerJourney_firstVisit_sourceType`	First visit source type	STRING
`customerJourney_firstVisit_utmParameters_campaign`	UTM campaign name first	STRING
`customerJourney_firstVisit_utmParameters_content`	UTM campaign content first	STRING
`customerJourney_firstVisit_utmParameters_medium`	UTM campaign medium first	STRING
`customerJourney_firstVisit_utmParameters_source`	UTM campaign source first	STRING
`customerJourney_firstVisit_utmParameters_term`	UTM campaign term first	STRING
`customerJourney_lastVisit_landingPage`	Landing page URL	STRING
`customerJourney_lastVisit_referralCode`	Last visit referral code	STRING
`customerJourney_lastVisit_referrerUrl`	Referrer URL last	STRING
`customerJourney_lastVisit_source`	Referrer source last	STRING
`customerJourney_lastVisit_sourceType`	Last visit source type	STRING
`customerJourney_lastVisit_utmParameters_campaign`	UTM campaign	STRING
`customerJourney_lastVisit_utmParameters_content`	UTM content	STRING
`customerJourney_lastVisit_utmParameters_medium`	UTM medium	STRING
`customerJourney_lastVisit_utmParameters_source`	UTM source	STRING
`customerJourney_lastVisit_utmParameters_term`	UTM term	STRING
`date`	Date and time	STRING
`date_actual`	Dateformula	STRING
`discountCode`	Discount code	STRING
`displayFinancialStatus`	Payment status	STRING
`displayFulfillmentStatus`	Order fulfilment status	STRING
`name`	Order name	STRING
`order_id`	Order ID	STRING
`order_refund_created_at`	Date of refund	STRING
`payment_method`	Payment method	STRING
`referrer_source`	Referrer source	STRING
`shippingAddress_city`	Shipping address city	STRING
`shippingAddress_country`	Shipping country/region	STRING
`shippingAddress_countryCode`	Shipping country code	STRING
`shippingAddress_province`	Shipping region	STRING
`shippingAddress_zip`	Shipping postal code	STRING
`shippingLine_title`	Delivery method	STRING
`tags`	Order tags	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`year_week`	Year weekformula	STRING
`dataFreshness`	PMA data freshness	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Inventory

report_type: inventory · 2 metrics · 34 dimensions

Metrics

Field name	Label	Type
`totalInventory`	Total inventory	NUMBER
`totalVariants`	Total variants	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`dataFreshness`	PMA data freshness	STRING
`date`	Date and time	STRING
`description`	Product description	STRING
`featuredImage_originalSrc`	Product image	STRING
`productType`	Product type	STRING
`product_id`	Product ID	STRING
`product_tags`	Product tags	STRING
`shop_id`	Shop ID	STRING
`status`	Product status	STRING
`title`	Product title	STRING
`vendor`	Vendor	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Inventory variations

report_type: inventory_variations · 3 metrics · 33 dimensions

Metrics

Field name	Label	Type
`inventoryItem_unitCost_amount`	Cost per item	NUMBER
`inventoryQuantity`	Inventory quantity	NUMBER
`price`	Price	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`barcode`	Barcode	STRING
`dataFreshness`	PMA data freshness	STRING
`date`	Date and time	STRING
`image_originalSrc`	Variant image	STRING
`inventoryItem_countryCodeOfOrigin`	Country code of origin	STRING
`inventoryItem_harmonizedSystemCode`	Harmonized system code	STRING
`product_id`	Product ID	STRING
`shop_id`	Shop ID	STRING
`sku`	Variant SKU	STRING
`variantTitle`	Variant title	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Line items

report_type: line_items · 19 metrics · 32 dimensions

Metrics

Field name	Label	Type
`num_of_orders`	Ordersformula	NUMBER
`COGS`	Cost of goods soldformula	NUMBER
`revenue`	Revenueformula	NUMBER
`gross_profit`	Gross profitformula	NUMBER
`gross_margin`	Gross margin %formula	NUMBER
`product_profit`	Product profitformula	NUMBER
`product_margin`	Product margin %formula	NUMBER
`line_item_amount`	Item price (line items)	NUMBER
`line_item_discount`	Line item discount	NUMBER
`line_item_gross_amount`	Gross sales (line items)	NUMBER
`line_item_net_amount`	Net sales (line items)	NUMBER
`line_item_return`	Line item returns	NUMBER
`line_item_shipping`	Shipping (line items)	NUMBER
`line_item_taxes`	Taxes (line items)	NUMBER
`line_item_total_amount`	Total sales (line items)	NUMBER
`orders`	IsOrder	NUMBER
`quantity`	Item quantity	NUMBER
`refundableQuantity`	Refundable quantity	NUMBER
`requiresShipping`	Requires shipping	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`dataFreshness`	PMA data freshness	STRING
`date`	Date and time	STRING
`fulfillmentStatus`	Item fulfilment status	STRING
`order_id`	Order ID	STRING
`product_id`	Product ID	STRING
`product_vendor`	Product vendor	STRING
`shop_id`	Shop ID	STRING
`sku`	Variant SKU	STRING
`title`	Product title	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`year_week`	Year weekformula	STRING
`dataPlatform`	Data platform	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Inventory locations

report_type: inventory_locations · 5 metrics · 32 dimensions

Metrics

Field name	Label	Type
`available`	Available	NUMBER
`committed`	Committed	NUMBER
`incoming`	Incoming	NUMBER
`on_hand`	On hand	NUMBER
`reserved`	Reserved	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`dataFreshness`	PMA data freshness	STRING
`date`	Date and time	STRING
`location_address_city`	Location address city	STRING
`location_address_country`	Location address country	STRING
`location_address_province`	Location address province	STRING
`location_name`	Location name	STRING
`product_id`	Product ID	STRING
`shop_id`	Shop ID	STRING
`sku`	Variant SKU	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`dataPlatform`	Data platform	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Orders, line items and inventory in one warehouse

No native MCP

No native MCP

Every queryable field in PMA

Orders

Base orders and line items

Orders dimensions

Inventory

Inventory variations

Line items

Inventory locations