WooCommerce

Orders

report_type: orders · 14 metrics · 41 dimensions

Metrics

Field name	Label	Type
`num_of_orders`	Ordersformula	NUMBER
`net_sales`	Net salesformula	NUMBER
`gross_amount`	Gross salesformula	NUMBER
`AOV`	Average order valueformula	NUMBER
`is_discounted_order`	Discounted ordersformula	NUMBER
`cart_tax`	Cart tax	NUMBER
`discount_tax`	Discount tax	NUMBER
`discount_total`	Discount total	NUMBER
`quantity`	Items sold	NUMBER
`shipping_tax`	Shipping tax	NUMBER
`shipping_total`	Shipping total	NUMBER
`total`	Total	NUMBER
`total_refunds`	Returns	NUMBER
`total_tax`	Total tax	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`date_created`	Date created	STRING
`number_id`	Number ID	STRING
`order_id`	Order ID	STRING
`siteId`	Site ID	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`year_week`	Year weekformula	STRING
`day_of_week`	Day of weekformula	STRING
`date_created_year`	Year (date created)formula	STRING
`date_created_quarter`	Quarter (date created)formula	STRING
`date_created_year_quarter`	Year quarter (date created)formula	STRING
`date_created_month`	Year month (date created)formula	STRING
`date_created_week`	Week (date created)formula	STRING
`date_created_year_week`	Year week (date created)formula	STRING
`date_created_day_of_week`	Day of week (date created)formula	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 (base)

report_type: orders_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 · 1 metric · 81 dimensions

Metrics

Field name	Label	Type
`number_of_coupons`	Number of coupons	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`billing_address_1`	Billing address 1	STRING
`billing_address_2`	Billing address 2	STRING
`billing_city`	Billing city	STRING
`billing_company`	Billing company	STRING
`billing_country`	Billing country	STRING
`billing_email`	Billing email	STRING
`billing_first_name`	Billing first name	STRING
`billing_last_name`	Billing last name	STRING
`billing_phone`	Billing phone	STRING
`billing_postcode`	Billing postal code	STRING
`billing_state`	Billing state	STRING
`coupon`	Coupon	STRING
`created_via`	Created via	STRING
`currency`	Currency	STRING
`customer_id`	Customer ID	STRING
`customer_ip_address`	Customer IP address	STRING
`customer_user_agent`	Customer user agent	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`date_actual`	Dateformula	STRING
`date_completed`	Date completed	STRING
`date_created`	Date created	STRING
`date_modified`	Date modified	STRING
`date_paid`	Date paid	STRING
`date_created_year`	Year (date created)formula	STRING
`date_created_quarter`	Quarter (date created)formula	STRING
`date_created_year_quarter`	Year quarter (date created)formula	STRING
`date_created_month`	Year month (date created)formula	STRING
`date_created_week`	Week (date created)formula	STRING
`date_created_year_week`	Year week (date created)formula	STRING
`date_created_month_only`	Month (date created)formula	STRING
`date_created_month_day`	Month day (date created)formula	STRING
`date_created_day_of_week`	Day of week (date created)formula	STRING
`date_created_day_of_month`	Day of month (date created)formula	STRING
`date_created_date_actual`	Date (date created)formula	STRING
`date_created_hour`	Hour (date created)formula	STRING
`order_attribution_campaign`	Order attribution campaign	STRING
`order_attribution_content`	Order attribution content	STRING
`order_attribution_medium`	Order attribution medium	STRING
`order_attribution_origin`	Order attribution origin	STRING
`order_attribution_source`	Order attribution source	STRING
`order_attribution_source_type`	Order attribution source type	STRING
`order_attribution_term`	Order attribution term	STRING
`order_id`	Order ID	STRING
`order_key`	Order key	STRING
`ordered_by`	Ordered by	STRING
`payment_method_title`	Payment method	STRING
`shipping_address_1`	Shipping address 1	STRING
`shipping_address_2`	Shipping address 2	STRING
`shipping_city`	Shipping city	STRING
`shipping_company`	Shipping company	STRING
`shipping_country`	Shipping country	STRING
`shipping_first_name`	Shipping first name	STRING
`shipping_last_name`	Shipping last name	STRING
`shipping_method`	Shipping method	STRING
`shipping_postcode`	Shipping postcode	STRING
`shipping_state`	Shipping state	STRING
`status`	Order status	STRING
`year`	Yearformula	STRING
`month`	Year monthformula	STRING
`year_quarter`	Year quarterformula	STRING
`year_week`	Year weekformula	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

Line items

report_type: line_items · 7 metrics · 33 dimensions

Metrics

Field name	Label	Type
`num_of_orders`	Ordersformula	NUMBER
`avg_items_per_order`	Average items per orderformula	NUMBER
`line_item_total`	Line item total	NUMBER
`line_item_total_tax`	Line item total tax	NUMBER
`quantity`	Items sold	NUMBER
`subtotal`	Subtotal	NUMBER
`subtotal_tax`	Subtotal tax	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`line_item_id`	Line item ID	STRING
`line_item_name`	Line item name	STRING
`order_id`	Order ID	STRING
`price`	Price	STRING
`product_id`	Product ID	STRING
`siteId`	Site ID	STRING
`sku`	SKU	STRING
`variation_id`	Variation 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

Customers

report_type: customers · 2 metrics · 47 dimensions

Metrics

Field name	Label	Type
`signups`	Signupsformula	NUMBER
`is_paying_customer`	Is paying customer	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`customer_full_name`	Customer full name	STRING
`customer_id`	Customer ID	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`date_created`	Date created	STRING
`date_modified`	Date modified	STRING
`email`	Email	STRING
`first_name`	First name	STRING
`last_name`	Last name	STRING
`role`	Role	STRING
`siteId`	Site ID	STRING
`username`	Username	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`year_week`	Year weekformula	STRING
`day_of_week`	Day of weekformula	STRING
`date_created_year`	Year (date created)formula	STRING
`date_created_quarter`	Quarter (date created)formula	STRING
`date_created_year_quarter`	Year quarter (date created)formula	STRING
`date_created_month`	Year month (date created)formula	STRING
`date_created_week`	Week (date created)formula	STRING
`date_created_year_week`	Year week (date created)formula	STRING
`date_created_day_of_week`	Day of week (date created)formula	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

report_type: inventory · 1 metric · 40 dimensions

Metrics

Field name	Label	Type
`stock_quantity`	Stock quantity	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account name	STRING
`categories`	Category	STRING
`dataFreshness`	Data freshness	STRING
`date_created`	Date created	STRING
`date_modified`	Date modified	STRING
`image`	Image	STRING
`permalink`	Product page URL	STRING
`price`	Price	STRING
`product_id`	Product ID	STRING
`product_name`	Product title	STRING
`product_status`	Product status	STRING
`regular_price`	Regular price	STRING
`short_description`	Short description	STRING
`siteId`	Site ID	STRING
`sku`	SKU	STRING
`slug`	Slug	STRING
`stock_status`	Stock status	STRING
`type`	Type	STRING
`dataPlatform`	Data platform	STRING
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`executionId`	Function execution ID	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`Payment`	PMA payment URL	STRING
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Orders, customers and inventory from WooCommerce stores

No native MCP

No native MCP

Every queryable field in PMA

Orders

Orders line items (base)

Orders dimensions

Line items

Customers

Inventory