Docs
WooCommerce Fields List
414 fields · 276 metrics · 138 dimensions
BigQuery
Looker Studio
Google Sheets
Power BI| Field Name | Label | Type | Description | Group |
|---|---|---|---|---|
| DIMENSIONS10 fields | ||||
date |
Date | Dimension | Timestamp or date value for date. Used for time-series analysis and filtering. | DIMENSIONS |
day_of_week |
Day of week (Mon – Sun) | Dimension | Day of week (Mon – Sun) metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | DIMENSIONS |
hour |
Hour of day | Dimension | Hour of day metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | DIMENSIONS |
month |
Month | Dimension | Month metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | DIMENSIONS |
quarter |
Quarter | Dimension | Quarter metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | DIMENSIONS |
week |
Week | Dimension | Week metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | DIMENSIONS |
year |
Year | Dimension | Year metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | DIMENSIONS |
year_month |
Month and year | Dimension | Month and year metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | DIMENSIONS |
year_quarter |
Quarter and year | Dimension | Quarter and year metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | DIMENSIONS |
year_week |
Week and year | Dimension | Week and year metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | DIMENSIONS |
| coupon26 fields | ||||
coupon_amount_discount |
Coupon amount of discount | Metric | The amount of discount. Should always be numeric, even if setting a percentage. | coupon |
coupon_code |
Coupon code | Metric | Computer-generated code, consisting of letters or numbers that consumers can enter into a promotional box on a site’s shopping cart (or checkout page) to obtain a discount on the current purchase. | coupon |
coupon_creation_date |
Coupon creation date | Dimension | The date the coupon was created, in the site’s timezone. | coupon |
coupon_creation_date_gmt |
Coupon creation date GMT | Metric | The date the coupon was created, as GMT. | coupon |
coupon_description |
Coupon description | Dimension | Coupon description metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | coupon |
coupon_discount_type |
Coupon discount type | Dimension | Determines the type of discount that will be applied. | coupon |
coupon_email_restriction |
Coupon email restriction | Metric | The email address that can use this coupon. | coupon |
coupon_excluded_product_categories |
Coupon excluded product categories | Metric | List of category IDs the coupon does not apply to. | coupon |
coupon_excluded_product_ids |
Coupon excluded product ids | Dimension | List of product IDs the coupon cannot be used on. | coupon |
coupon_excludes_sale_items |
Coupon excludes sale items | Metric | If true this coupon will not be applied to items that have sale prices. Default is false. | coupon |
coupon_expiration_date |
Coupon expiration date | Dimension | The date the coupon expires, in the site’s timezone. | coupon |
coupon_expiration_date_gmt |
Coupon expiration date GMT | Metric | The date the coupon expires, as GMT. | coupon |
coupon_free_shipping |
Coupon free shipping | Metric | If true and if the free shipping method requires a coupon, this coupon will enable free shipping. Default is false. | coupon |
coupon_id |
Coupon ID | Dimension | Unique identifier for the coupon object. | coupon |
coupon_individual_use |
Coupon individual use | Metric | If true the coupon can only be used individually. Other applied coupons will be removed from the cart. Default is false. | coupon |
coupon_modification_date |
Coupon modification date | Dimension | The date the coupon was last modified, in the site’s timezone. | coupon |
coupon_modification_date_gmt |
Coupon modification date GMT | Metric | The date the coupon was last modified, as GMT. | coupon |
coupon_product_categories |
Coupon product categories | Metric | List of category IDs the coupon applies to. | coupon |
coupon_product_ids |
Coupon product ids | Dimension | List of product IDs the coupon can be used on. | coupon |
coupon_usage_count |
Coupon usage count | Metric | The number of times the coupon has been used already. | coupon |
coupon_usage_limit |
Coupon usage limit | Metric | How many times the coupon can be used in total. | coupon |
coupon_usage_limit_per_user |
Coupon usage limit per user | Metric | How many times the coupon can be used per customer. | coupon |
coupon_usage_limit_to_x_items |
Coupon usage limit to x items | Metric | Max number of items in the cart the coupon can be applied to. | coupon |
coupon_user_used |
Coupon user email | Metric | The email address that can use this coupon. | coupon |
order_maximum_amount |
Order maximum amount | Metric | Maximum order amount allowed when using the coupon. | coupon |
order_minimum_amount |
Order minimum amount | Metric | Minimum order amount that needs to be in the cart before coupon applies. | coupon |
| customer39 fields | ||||
customer_avatar |
Customer avatar | Metric | Graphical representation of a user or the user’s character or persona. | customer |
customer_avatar_url |
Customer avatar URL | Dimension | Graphical representation of a user or the user’s character or persona. | customer |
customer_billing |
Customer billing | Metric | List of billing address data for a customer. | customer |
customer_billing_address_1 |
Customer billing address line 1 | Metric | Customer billing address line 1 metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_billing_address_line_2 |
Customer billing address line 2 | Metric | Customer billing address line 2 metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_billing_city |
Customer billing city | Metric | Geographic dimension showing customer billing city. Enables location-based performance analysis. | customer |
customer_billing_company |
Customer billing company | Metric | Customer billing company name. | customer |
customer_billing_country |
Customer billing country | Metric | Geographic dimension showing customer billing country. Enables location-based performance analysis. | customer |
customer_billing_email |
Customer billing email | Metric | Customer billing email metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_billing_first_name |
Customer billing first name | Dimension | The display name of the customer billing first as configured in WooCommerce. | customer |
customer_billing_last_name |
Customer billing last name | Dimension | The display name of the customer billing last as configured in WooCommerce. | customer |
customer_billing_phone |
Customer billing phone | Metric | Customer billing phone metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_billing_postal_code |
Customer billing postal code | Metric | Customer billing postal code metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_billing_state |
Customer billing state | Metric | Customer billing state metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_creation_date |
Customer creation date | Dimension | The date the customer was created, in the site’s timezone. | customer |
customer_creation_date_gmt |
Customer creation date GMT | Metric | The date the customer was created, as GMT. | customer |
customer_email |
Customer email | Metric | The email address for the customer. | customer |
customer_first_name |
Customer first name | Dimension | The display name of the customer first as configured in WooCommerce. | customer |
customer_id |
Customer ID | Dimension | Unique identifier for the customer object. | customer |
customer_last_name |
Customer last name | Dimension | The display name of the customer last as configured in WooCommerce. | customer |
customer_meta_data |
Customer meta data | Metric | Meta data. See Customer – Meta data properties. | customer |
customer_modification_date |
Customer modification date | Dimension | The date the customer was last modified, in the site’s timezone. | customer |
customer_modification_date_gmt |
Customer modification date gmt | Metric | The date the customer was last modified, as GMT. | customer |
customer_role |
Customer role | Metric | Customer role metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_shipping |
Customer shipping | Metric | List of shipping address data for a customer. | customer |
customer_shipping_address_line_1 |
Customer shipping address line 1 | Metric | Customer shipping address line 1 metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_shipping_address_line_2 |
Customer shipping address line 2 | Metric | Customer shipping address line 2 metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_shipping_city |
Customer shipping city | Metric | Geographic dimension showing customer shipping city. Enables location-based performance analysis. | customer |
customer_shipping_company |
Customer shipping company | Metric | Customer shipping company metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_shipping_country |
Customer shipping country | Metric | Geographic dimension showing customer shipping country. Enables location-based performance analysis. | customer |
customer_shipping_first_name |
Customer shipping first name | Dimension | The display name of the customer shipping first as configured in WooCommerce. | customer |
customer_shipping_last_name |
Customer shipping last name | Dimension | The display name of the customer shipping last as configured in WooCommerce. | customer |
customer_shipping_postal_code |
Customer shipping postal code | Metric | Customer shipping postal code metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_shipping_state |
Customer shipping state | Metric | Customer shipping state metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
customer_username |
Customer username | Dimension | The display name of the customer user as configured in WooCommerce. | customer |
is_paying_customer |
Is a paying customer? | Metric | Is the customer a paying customer? | customer |
meta_data_customer_id |
Customer meta data ID | Dimension | Unique identifier for the customer meta data in WooCommerce. | customer |
meta_data_customer_key |
Customer meta data key | Metric | Customer meta data key metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
meta_data_customer_value |
Customer meta data value | Metric | Customer meta data value metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | customer |
| order109 fields | ||||
order_address_1 |
Order address 1 | Metric | Order-related address 1. Represents completed purchase transactions. | order |
order_address_2 |
Order address 2 | Metric | Order-related address 2. Represents completed purchase transactions. | order |
order_billing |
Order billing | Metric | Billing address. See Order – Billing properties. | order |
order_cart_hash |
Order cart hash | Metric | MD5 hash of cart items to ensure orders are not modified. | order |
order_cart_tax |
Order cart tax | Metric | Order-related cart tax. Represents completed purchase transactions. | order |
order_city |
Order city | Metric | Geographic dimension showing order city. Enables location-based performance analysis. | order |
order_company |
Order company | Metric | Order-related company. Represents completed purchase transactions. | order |
order_completed_date |
Order completed date | Dimension | The date the order was completed, in the site’s timezone. | order |
order_completed_date_gmt |
Order completed date GMT | Metric | The date the order was completed, as GMT | order |
order_country |
Order country | Metric | Country code in ISO 3166-1 alpha-2 format. | order |
order_coupon_line_code |
Order coupon line code | Metric | Order-related coupon line code. Represents completed purchase transactions. | order |
order_coupon_line_discount |
Order coupon line discount | Metric | Order-related coupon line discount. Represents completed purchase transactions. | order |
order_coupon_line_discount_tax |
Order coupon line discount tax | Metric | Order-related coupon line discount tax. Represents completed purchase transactions. | order |
order_coupon_line_id |
Order coupon line ID | Dimension | Unique identifier for the order coupon line in WooCommerce. | order |
order_coupon_line_meta_data |
Order coupon line meta data | Metric | Meta data. See Order – Meta data properties. | order |
order_coupon_lines |
Order coupon lines | Metric | Coupons line data. See Order – Coupon lines properties. | order |
order_creation_date |
Order creation date | Dimension | The date the order was created, in the site’s timezone. | order |
order_creation_date_gmt |
Order creation date GMT | Metric | The date the order was created, as GMT. | order |
order_creation_via |
Order creation mode | Metric | Shows where the order was created. | order |
order_currency |
Order currency | Dimension | Currency the order was created with, in ISO format. | order |
order_customer_id |
Order customer ID | Dimension | User ID who owns the order. 0 for guests. Default is 0. | order |
order_customer_ip_address |
Order customer’s IP address | Metric | Order-related customer’s ip address. Represents completed purchase transactions. | order |
order_customer_note |
Order customer note | Metric | Note left by customer during checkout. | order |
order_customer_user_agent |
Order customer browser | Metric | Order-related customer browser. Represents completed purchase transactions. | order |
order_email |
Order email | Metric | Order-related email. Represents completed purchase transactions. | order |
order_fee_line_id |
Order fee line ID | Dimension | Unique identifier for the order fee line in WooCommerce. | order |
order_fee_line_meta_data |
Order fee line meta data | Metric | Meta data. See Order – Meta data properties. | order |
order_fee_line_name |
Order fee line name | Dimension | The display name of the order fee line as configured in WooCommerce. | order |
order_fee_line_tax_class |
Order fee line tax class | Metric | Order-related fee line tax class. Represents completed purchase transactions. | order |
order_fee_line_tax_status |
Order fee line tax status | Dimension | Tax status of fee. Options: taxable and none. | order |
order_fee_line_taxes |
Order fee line taxes | Metric | Line taxes. See Order – Taxes properties. | order |
order_fee_line_total |
Order fee line total | Metric | The total count of order fee line recorded during the reporting period. | order |
order_fee_line_total_tax |
Order fee line total tax | Metric | Line total tax (after discounts). | order |
order_fee_lines |
Order fee lines | Metric | Fee lines data. See Order – Fee lines properties. | order |
order_first_name |
Order first name | Dimension | The display name of the order first as configured in WooCommerce. | order |
order_grand_total |
Order grand total | Metric | The total count of order grand recorded during the reporting period. | order |
order_id |
Order ID | Dimension | Unique identifier for the order object. | order |
order_key |
Order key | Metric | Order-related key. Represents completed purchase transactions. | order |
order_last_name |
Order last name | Dimension | The display name of the order last as configured in WooCommerce. | order |
order_line_item_id |
Order line item ID | Dimension | Unique identifier for the order line item in WooCommerce. | order |
order_line_item_name |
Order line item name | Dimension | The display name of the order line item as configured in WooCommerce. | order |
order_line_item_product_id |
Order line item product ID | Dimension | Unique identifier for the order line item product in WooCommerce. | order |
order_line_item_quantity |
Order line item quantity | Metric | Order-related line item quantity. Represents completed purchase transactions. | order |
order_line_item_variation_id |
Order line item variation ID | Dimension | Variation ID, if applicable. | order |
order_line_items |
Order line items | Metric | Line items data. See Order – Line items properties. | order |
order_line_meta_data |
Order line item meta data | Metric | Meta data. See Order – Meta data properties. | order |
order_line_price |
Order line item price | Metric | Order-related line item price. Represents completed purchase transactions. | order |
order_line_sku |
Order line item sku | Metric | Order-related line item sku. Represents completed purchase transactions. | order |
order_line_subtotal |
Order line item subtotal | Metric | Line subtotal (before discounts). | order |
order_line_subtotal_tax |
Order line item subtotal tax | Metric | Line subtotal tax (before discounts). | order |
order_line_tax_class |
Order line item tax class | Metric | Slug of the tax class of product. | order |
order_line_taxes |
Order line item taxes | Metric | Line taxes. See Order – Taxes properties. | order |
order_line_total |
Order line item total | Metric | The total count of order line item recorded during the reporting period. | order |
order_line_total_tax |
Order line item total tax | Metric | Line total tax (after discounts). | order |
order_meta_data |
Order meta data | Metric | Meta data. See Order – Meta data properties. | order |
order_meta_data_id |
Order meta data ID | Dimension | Unique identifier for the order meta data in WooCommerce. | order |
order_meta_data_key |
Order meta data key | Metric | Order-related meta data key. Represents completed purchase transactions. | order |
order_meta_data_value |
Order meta data value | Metric | Order-related meta data value. Represents completed purchase transactions. | order |
order_modification_date |
Order modification date | Dimension | The date the order was last modified, in the site’s timezone. | order |
order_modification_date_gmt |
Order modification date GMT | Metric | The date the order was last modified, as GMT. | order |
order_number |
Order number | Metric | Order-related number. Represents completed purchase transactions. | order |
order_paid_date |
Order paid date | Dimension | The date the order was paid, in the site’s timezone. | order |
order_paid_date_gmt |
Order paid date GMT | Metric | The date the order was paid, as GMT. | order |
order_payment_method |
Order payment method | Metric | Order-related payment method. Represents completed purchase transactions. | order |
order_payment_method_title |
Order payment method title | Dimension | Order-related payment method title. Represents completed purchase transactions. | order |
order_phone |
Order phone | Metric | Order-related phone. Represents completed purchase transactions. | order |
order_postcode |
Order postal code | Metric | Order-related postal code. Represents completed purchase transactions. | order |
order_prices_include_taxes |
Order prices include taxes | Metric | Order-related prices include taxes. Represents completed purchase transactions. | order |
order_refunds |
Order refunds | Metric | List of refunds. See Order – Refunds properties. | order |
order_set_paid |
Order paid status | Dimension | Define if the order is paid. It will set the status to processing and reduce stock items. Default is false. | order |
order_shipping |
Order shipping | Metric | Shipping address. See Order – Shipping properties. | order |
order_shipping_address_1 |
Order shipping address 1 | Metric | Order-related shipping address 1. Represents completed purchase transactions. | order |
order_shipping_address_2 |
Order shipping address 2 | Metric | Order-related shipping address 2. Represents completed purchase transactions. | order |
order_shipping_city |
Order shipping city | Metric | Geographic dimension showing order shipping city. Enables location-based performance analysis. | order |
order_shipping_company |
Order shipping company | Metric | Order-related shipping company. Represents completed purchase transactions. | order |
order_shipping_country |
Order shipping country | Metric | Country code in ISO 3166-1 alpha-2 format. | order |
order_shipping_email |
Order shipping email | Metric | Order-related shipping email. Represents completed purchase transactions. | order |
order_shipping_first_name |
Order shipping first name | Dimension | The display name of the order shipping first as configured in WooCommerce. | order |
order_shipping_last_name |
Order shipping last name | Dimension | The display name of the order shipping last as configured in WooCommerce. | order |
order_shipping_line_id |
Order shipping line ID | Dimension | Unique identifier for the order shipping line in WooCommerce. | order |
order_shipping_line_meta_data |
Order shipping line meta data | Metric | Meta data. See Order – Meta data properties. | order |
order_shipping_line_method_id |
Order shipping line method ID | Dimension | Unique identifier for the order shipping line method in WooCommerce. | order |
order_shipping_line_method_title |
Order shipping line method title | Dimension | Order-related shipping line method title. Represents completed purchase transactions. | order |
order_shipping_line_taxes |
Order shipping line taxes | Metric | Line taxes. See Order – Taxes properties. | order |
order_shipping_line_total |
Order shipping line total | Metric | The total count of order shipping line recorded during the reporting period. | order |
order_shipping_line_total_tax |
Order shipping line total tax | Metric | Line total tax (after discounts). | order |
order_shipping_lines |
Order shipping lines | Metric | Shipping lines data. See Order – Shipping lines properties. | order |
order_shipping_phone |
Order shipping phone | Metric | Order-related shipping phone. Represents completed purchase transactions. | order |
order_shipping_postcode |
Order shipping postal code | Metric | Order-related shipping postal code. Represents completed purchase transactions. | order |
order_shipping_state |
Order shipping state | Metric | ISO code or name of the state, province or district. | order |
order_state |
Order state | Metric | ISO code or name of the state, province or district. | order |
order_status |
Order status | Dimension | Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending. | order |
order_tax_lines |
Order tax lines | Metric | Tax lines data. See Order – Tax lines properties. | order |
order_tax_lines_compound |
Order tax line compound | Metric | Show if is a compound tax rate. | order |
order_tax_lines_id |
Order tax line ID | Dimension | Unique identifier for the order tax line in WooCommerce. | order |
order_tax_lines_label |
Order tax line label | Metric | Order-related tax line label. Represents completed purchase transactions. | order |
order_tax_lines_meta_data |
Order tax line meta data | Metric | Meta data. See Order – Meta data properties. | order |
order_tax_lines_rate_code |
Order tax line rate code | Metric | Order-related tax line rate code. Represents completed purchase transactions. | order |
order_tax_lines_rate_id |
Order tax line rate ID | Dimension | Unique identifier for the order tax line rate in WooCommerce. | order |
order_tax_lines_shipping_tax_total |
Order tax line shipping total | Metric | The total count of order tax line shipping recorded during the reporting period. | order |
order_tax_lines_tax_total |
Order tax line total | Metric | Tax total (not including shipping taxes). | order |
order_total_discount |
Order total discount | Metric | Total discount amount for the order. | order |
order_total_shipping |
Order total shipping | Metric | Total shipping amount for the order. | order |
order_total_tax |
Order total tax | Metric | Order-related total tax. Represents completed purchase transactions. | order |
order_total_tax_discount |
Order total tax discount | Metric | Total discount tax amount for the order. | order |
order_total_tax_shipping |
Order total tax shipping | Metric | Total shipping tax amount for the order. | order |
order_transaction_id |
Order transaction ID | Dimension | Unique transaction ID. | order |
parent_order_id |
Parent order ID | Dimension | Unique identifier for the parent order ID. | order |
woocommerce_version |
WooCommerce version | Metric | Version of WooCommerce which last updated the order. | order |
| product73 fields | ||||
cross_sell_product_ids |
Cross-sell product ids | Dimension | List of cross-sell products IDs. | product |
grouped_products |
Grouped product IDs | Metric | List of grouped products ID. | product |
product_allows_backorders |
Product allows backorders | Metric | Shows if backorders are allowed. | product |
product_attributes |
Product attributes | Metric | List of attributes. See Product – Attributes properties. | product |
product_average_rating |
Product average rating | Metric | Product-level average rating. Used for product performance analysis. | product |
product_backordered |
Product backordered | Metric | Shows if the product is on backordered. | product |
product_backorders |
Product backorders | Metric | If managing stock, this controls if backorders are allowed. Options: no, notify and yes. Default is no. | product |
product_button_text |
Product button text | Dimension | Product external button text. Only for external products. | product |
product_catalog_visibility |
Product catalog visibility | Metric | Catalog visibility. Options: visible, catalog, search and hidden. Default is visible. | product |
product_categories |
Product categories | Metric | List of categories. See Product – Categories properties. | product |
product_creation_date |
Product creation date | Dimension | The date the product was created, in the site’s timezone. | product |
product_creation_date_gmt |
Product creation date GMT | Metric | The date the product was created, as GMT. | product |
product_cross_sell_ids |
Product cross sell ids | Dimension | List of cross-sell products IDs. | product |
product_default_attributes |
Product default attributes | Metric | Defaults variation attributes. See Product – Default attributes properties. | product |
product_description |
Product description | Dimension | Product-level description. Used for product performance analysis. | product |
product_dimensions |
Product dimensions | Metric | Product-level dimensions. Used for product performance analysis. | product |
product_download_expiry |
Product download expiry | Metric | Number of days until access to downloadable files expires. Default is -1. | product |
product_download_file_url |
Product download file URl | Dimension | Product-level download file url. Used for product performance analysis. | product |
product_download_id |
Product download ID | Dimension | Unique identifier for the product download in WooCommerce. | product |
product_download_limit |
Product download limit | Metric | Number of times downloadable files can be downloaded after purchase. Default is -1. | product |
product_download_name |
Product download name | Dimension | The display name of the product download as configured in WooCommerce. | product |
product_downloadable |
Product downloadable | Metric | If the product is downloadable. Default is false. | product |
product_downloads |
Product downloads | Metric | List of downloadable files. See Product – Downloads properties. | product |
product_end_date_on_sale |
Product end date on sale | Metric | End date of sale price, in the site’s timezone. | product |
product_end_date_on_sale_gmt |
Product end date on sale GMT | Metric | End date of sale price, in the site’s timezone. | product |
product_external_url |
Product external URL | Dimension | Product external URL. Only for external products. | product |
product_feature |
Product feature | Metric | Featured product. Default is false. | product |
product_grouped_products |
Product grouped products | Metric | List of grouped products ID. | product |
product_id |
Product ID | Dimension | Unique identifier for the resource. | product |
product_images |
Product images | Metric | List of images. See Product – Images properties. | product |
product_length |
Product length | Metric | Product-level length. Used for product performance analysis. | product |
product_menu_order |
Product menu order | Metric | Menu order, used to custom sort products. | product |
product_meta_data |
Product meta data | Metric | Meta data. See Product – Meta data properties. | product |
product_modification_date |
Product modification date | Dimension | The date the product was last modified, in the site’s timezone. | product |
product_modification_date_gmt |
Product modification date GMT | Metric | The date the product was last modified, as GMT. | product |
product_name |
Product name | Dimension | The display name of the product as configured in WooCommerce. | product |
product_on_sale |
Product on sale | Metric | Shows if the product is on sale. | product |
product_parent_id |
Product parent ID | Dimension | Unique identifier for the product parent in WooCommerce. | product |
product_permalink |
Product URL | Metric | Product-level url. Used for product performance analysis. | product |
product_price |
Product price | Metric | Product-level price. Used for product performance analysis. | product |
product_price_html |
Product price html | Metric | Product-level price html. Used for product performance analysis. | product |
product_purchasable |
Product purchasable | Metric | Shows if the product can be bought. | product |
product_purchase_note |
Product purchase note | Metric | Optional note to send the customer after purchase. | product |
product_rating_count |
Product rating count | Metric | Amount of reviews that the product have. | product |
product_regular_price |
Product regular price | Metric | Product-level regular price. Used for product performance analysis. | product |
product_related_ids |
Product related ids | Dimension | List of related products IDs. | product |
product_reviews_allowed |
Product reviews allowed | Metric | Allow reviews. Default is true. | product |
product_sale_price |
Product sale price | Metric | Product-level sale price. Used for product performance analysis. | product |
product_shipping_class |
Product shipping class | Metric | Product-level shipping class. Used for product performance analysis. | product |
product_shipping_required |
Product shipping required | Metric | Shows if the product need to be shipped. | product |
product_shipping_taxable |
Product shipping taxable | Metric | Shows if the product need to be shipped. | product |
product_short_description |
Product short description | Dimension | Product-level short description. Used for product performance analysis. | product |
product_sku |
Product SKU | Metric | Product-level sku. Used for product performance analysis. | product |
product_slug |
Product slug | Metric | Product-level slug. Used for product performance analysis. | product |
product_sold_individually |
Product sold individually | Metric | Allow one item to be bought in a single order. | product |
product_star_date_on_sale |
Product start date on sale | Metric | Start date of sale price, in the site’s timezone. | product |
product_start_date_on_sale_gmt |
Product start date on sale GMT | Metric | Start date of sale price, as GMT. | product |
product_status |
Product status | Dimension | Product status (post status). Options: draft, pending, private and publish. Default is publish. | product |
product_stock_management |
Product stock management | Metric | Stock management at product level. Default is false. | product |
product_stock_quantity |
Product stock quantity | Metric | Product-level stock quantity. Used for product performance analysis. | product |
product_stock_status |
Product stock status | Dimension | Controls the stock status of the product. Options: instock, outofstock, onbackorder. Default is instock. | product |
product_tags |
Product tags | Metric | List of tags. See Product – Tags properties. | product |
product_tax_class |
Product tax class | Metric | Product-level tax class. Used for product performance analysis. | product |
product_tax_status |
Product tax status | Dimension | Tax status. Options: taxable, shipping and none. Default is taxable. | product |
product_total_sales |
Product total sales | Metric | Product-level total sales. Used for product performance analysis. | product |
product_type |
Product type | Dimension | Product type. Options: simple, grouped, external and variable. Default is simple. | product |
product_upsell_ids |
Product upsell ids | Dimension | List of up-sell products IDs. | product |
product_variations |
Product variations | Metric | List of variations IDs. | product |
product_virtual |
Product virtual | Metric | If the product is virtual. Default is false. | product |
product_weight |
Product weight | Metric | Product-level weight. Used for product performance analysis. | product |
product_width |
Product width | Metric | Product-level width. Used for product performance analysis. | product |
related_product_ids |
Related product ids | Dimension | List of related products IDs. | product |
upsell_product_ids |
Upsell product ids | Dimension | List of up-sell products IDs. | product |
| product attributes10 fields | ||||
product_attribute_has_archives |
Product attribute archives | Metric | Enable/Disable attribute archives. Default is false. | product attributes |
product_attribute_id |
Product attribute ID | Dimension | Unique identifier for the product attribute. | product attributes |
product_attribute_name |
Product attribute name | Dimension | The display name of the product attribute as configured in WooCommerce. | product attributes |
product_attribute_options |
Product attribute options | Metric | List of available term names of the attribute. | product attributes |
product_attribute_order_by |
Product attribute sort order | Metric | Default sort order. Options: menu_order, name, name_num and id. Default is menu_order. | product attributes |
product_attribute_position |
Product attribute position | Metric | Product-level attribute position. Used for product performance analysis. | product attributes |
product_attribute_slug |
Product attribute slug | Metric | An alphanumeric identifier for the resource unique to its type. | product attributes |
product_attribute_type |
Product attribute type | Dimension | Type of attribute. By default only select is supported. | product attributes |
product_attribute_variation |
Product attribute variation | Metric | Define if the attribute can be used as variation. Default is false. | product attributes |
product_attribute_visible |
Product attribute visible | Metric | Define if the attribute is visible on the "Additional information" tab in the product’s page. Default is false. | product attributes |
| product categories17 fields | ||||
product_categories_count |
Product categories count | Metric | Number of published products for the resource. | product categories |
product_categories_display |
Product categories display | Metric | Category archive display type. Options: default, products, subcategories and both. Default is default. | product categories |
product_categories_id |
Product categories ID | Dimension | Unique identifier for the resource. | product categories |
product_categories_image_alt |
Product categories image alt | Metric | Product-level categories image alt. Used for product performance analysis. | product categories |
product_categories_image_creation_date |
Product categories image creation date | Dimension | The date the image was created, in the site’s timezone. | product categories |
product_categories_image_creation_date_gmt |
Product categories image creation date GMT | Metric | The date the image was created, as GMT. | product categories |
product_categories_image_id |
Product categories image ID | Dimension | Unique identifier for the product categories image in WooCommerce. | product categories |
product_categories_image_modification_date |
Product categories image modification date | Dimension | The date the image was created, in the site’s timezone. | product categories |
product_categories_image_modification_date_gmt |
Product categories image modification date GMT | Metric | The date the image was created, as GMT. | product categories |
product_categories_image_name |
Product categories image name | Dimension | The display name of the product categories image as configured in WooCommerce. | product categories |
product_categories_image_src |
Product categories image src | Metric | Product-level categories image src. Used for product performance analysis. | product categories |
product_categories_menu_order |
Product categories menu order | Metric | Menu order, used to custom sort the resource. | product categories |
product_categories_name |
Product categories name | Dimension | The display name of the product categories as configured in WooCommerce. | product categories |
product_categories_parent_id |
Product categories parent ID | Dimension | The ID for the parent of the resource. | product categories |
product_categories_slug |
Product categories slug | Metric | An alphanumeric identifier for the resource unique to its type. | product categories |
product_category_description |
Product categories description | Dimension | HTML description of the resource. | product categories |
product_category_image |
Product categories image | Metric | Image data. See Product category – Image properties. | product categories |
| product review10 fields | ||||
product_review_content |
Product review content | Metric | Product-level review content. Used for product performance analysis. | product review |
product_review_creation_date |
Product review creation date | Dimension | The date the review was created, in the site’s timezone. | product review |
product_review_creation_date_gmt |
Product review creation date GMT | Metric | The date the review was created, as GMT. | product review |
product_review_id |
Product review ID | Dimension | Unique identifier for the resource. | product review |
product_review_product_id |
Product review product ID | Dimension | Unique identifier for the product that the review belongs to. | product review |
product_review_rating |
Product review rating | Metric | Product-level review rating. Used for product performance analysis. | product review |
product_review_status |
Product review status | Dimension | Status of the review. Options: approved, hold, spam, unspam, trash and untrash. Defaults to approved. | product review |
product_review_verified |
Product review verified | Metric | Shows if the reviewer bought the product or not. | product review |
product_reviewer_email |
Product reviewer email | Metric | Product-level reviewer email. Used for product performance analysis. | product review |
product_reviewer_name |
Product reviewer name | Dimension | The display name of the product reviewer as configured in WooCommerce. | product review |
| product shipping class5 fields | ||||
product_shipping_class_count |
Product shipping class count | Metric | Number of published products for the resource. | product shipping class |
product_shipping_class_description |
Product shipping class description | Dimension | HTML description of the resource. | product shipping class |
product_shipping_class_id |
Product shipping class ID | Dimension | Unique identifier for the product shipping class in WooCommerce. | product shipping class |
product_shipping_class_name |
Product shipping class name | Dimension | The display name of the product shipping class as configured in WooCommerce. | product shipping class |
product_shipping_class_slug |
Product shipping class slug | Metric | An alphanumeric identifier for the resource unique to its type. | product shipping class |
| product tag5 fields | ||||
product_tag_count |
Product tag count | Metric | Number of published products for the resource. | product tag |
product_tag_description |
Product tag description | Dimension | Product-level tag description. Used for product performance analysis. | product tag |
product_tag_id |
Product tag ID | Dimension | Unique identifier for the tag resource. | product tag |
product_tag_name |
Product tag name | Dimension | The display name of the product tag as configured in WooCommerce. | product tag |
product_tag_slug |
Product tag slug | Metric | An alphanumeric identifier for the resource unique to its type. | product tag |
| product variation51 fields | ||||
product_variation_attributes |
Product variation attributes | Metric | List of attributes. See Product variation – Attributes properties. | product variation |
product_variation_backordered |
Product variation backordered | Metric | Shows if backorders are allowed. | product variation |
product_variation_backorders |
Product variation backorders | Metric | If managing stock, this controls if backorders are allowed. Options: no, notify and yes. Default is no. | product variation |
product_variation_backorders_allowed |
Product variation backorders allowed | Metric | Shows if backorders are allowed. | product variation |
product_variation_creation_date |
Product variation creation date | Dimension | The date the variation was created, in the site’s timezone. | product variation |
product_variation_creation_date_gmt |
Product variation creation date GMT | Metric | The date the variation was created, as GMT. | product variation |
product_variation_description |
Product variation description | Dimension | Product-level variation description. Used for product performance analysis. | product variation |
product_variation_dimensions |
Product variation dimensions | Metric | Variation dimensions. See Product variation – Dimensions properties. | product variation |
product_variation_download_expiry |
Product variation download expiry | Metric | Number of days until access to downloadable files expires. Default is -1. | product variation |
product_variation_downloadable |
Product variation downloadable | Metric | If the variation is downloadable. Default is false. | product variation |
product_variation_downloads |
Product variation downloads | Metric | List of downloadable files. See Product variation – Downloads properties. | product variation |
product_variation_downloads_limit |
Product variation download limit | Metric | Number of times downloadable files can be downloaded after purchase. Default is -1. | product variation |
product_variation_end_date_on_sale |
Product variation end date on sale | Metric | End date of sale price, in the site’s timezone. | product variation |
product_variation_end_date_on_sale_gmt |
Product variation end date on sale GMT | Metric | End date of sale price, as GMT. | product variation |
product_variation_height |
Product variation height | Metric | Product-level variation height. Used for product performance analysis. | product variation |
product_variation_id |
Product variation ID | Dimension | Unique identifier for the product variation resource. | product variation |
product_variation_image |
Product variation image | Metric | Product-level variation image. Used for product performance analysis. | product variation |
product_variation_image_alt |
Product variation image alternative text | Metric | Product-level variation image alternative text. Used for product performance analysis. | product variation |
product_variation_image_creation_date |
Product variation image creation date | Dimension | The date the image was created, in the site’s timezone. | product variation |
product_variation_image_creation_date_gmt |
Product variation image creation date GMT | Metric | The date the image was created, as GMT. | product variation |
product_variation_image_id |
Product variation image ID | Dimension | Unique identifier for the product variation image in WooCommerce. | product variation |
product_variation_image_modification_date |
Product variation image modification date | Dimension | The date the image was last modified, in the site’s timezone. | product variation |
product_variation_image_modification_date_gmt |
Product variation image modification date GMT | Metric | The date the image was last modified, as GMT. | product variation |
product_variation_image_name |
Product variation image name | Dimension | The display name of the product variation image as configured in WooCommerce. | product variation |
product_variation_image_url |
Product variation image URL | Dimension | Product-level variation image url. Used for product performance analysis. | product variation |
product_variation_length |
Product variation length | Metric | Product-level variation length. Used for product performance analysis. | product variation |
product_variation_menu_order |
Product variation menu order | Metric | Menu order, used to custom sort products variation. | product variation |
product_variation_meta_data |
Product variation meta data | Metric | Meta data. See Product variation – Meta data properties. | product variation |
product_variation_modification_date |
Product variation modification date | Dimension | The date the variation was last modified, in the site’s timezone. | product variation |
product_variation_modification_date_gmt |
Product variation modification date GMT | Metric | The date the variation was last modified, as GMT. | product variation |
product_variation_on_backordered |
Product variation on backordered | Metric | Shows if the variation is on backordered. | product variation |
product_variation_on_sale |
Product variation on sale | Metric | Shows if the variation is on sale. | product variation |
product_variation_permalink |
Product variation URL | Metric | Product-level variation url. Used for product performance analysis. | product variation |
product_variation_price |
Product variation price | Metric | Product-level variation price. Used for product performance analysis. | product variation |
product_variation_purchasable |
Product variation purchasable | Metric | Shows if the variation can be bought. | product variation |
product_variation_regular_price |
Product variation regular price | Metric | Product-level variation regular price. Used for product performance analysis. | product variation |
product_variation_sale_price |
Product variation sale price | Metric | Product-level variation sale price. Used for product performance analysis. | product variation |
product_variation_shipping_class |
Product variation shipping class | Metric | Product-level variation shipping class. Used for product performance analysis. | product variation |
product_variation_shipping_class_id |
Product variation shipping class ID | Dimension | Unique identifier for the product variation shipping class in WooCommerce. | product variation |
product_variation_sku |
Product variation SKU | Metric | Product-level variation sku. Used for product performance analysis. | product variation |
product_variation_start_date_on_sale |
Product variation start date on sale | Metric | Start date of sale price, in the site’s timezone. | product variation |
product_variation_start_date_on_sale_gmt |
Product variation start date on sale GMT | Metric | Start date of sale price, as GMT. | product variation |
product_variation_status |
Product variation status | Dimension | Variation status. Options: draft, pending, private and publish. Default is publish. | product variation |
product_variation_stock_management |
Product variation stock management | Metric | Stock management at variation level. Default is false. | product variation |
product_variation_stock_quantity |
Product variation stock quantity | Metric | Product-level variation stock quantity. Used for product performance analysis. | product variation |
product_variation_stock_status |
Product variation stock status | Dimension | Controls the stock status of the product. Options: instock, outofstock, onbackorder. Default is instock. | product variation |
product_variation_tax_class |
Product variation tax class | Metric | Product-level variation tax class. Used for product performance analysis. | product variation |
product_variation_tax_status |
Product variation tax status | Dimension | Tax status. Options: taxable, shipping and none. Default is taxable. | product variation |
product_variation_virtual |
Product variation virtual | Metric | If the variation is virtual. Default is false. | product variation |
product_variation_weight |
Product variation weight | Metric | Product-level variation weight. Used for product performance analysis. | product variation |
product_variation_width |
Product variation width | Metric | Product-level variation width. Used for product performance analysis. | product variation |
| refund23 fields | ||||
refund_amount |
Refund amount | Metric | Total refund amount. Optional. If this parameter is provided, it will take precedence over line item totals, even when total of line items does not matches with this amount. | refund |
refund_creation_date |
Refund creation date | Dimension | The date the order note was created, in the site’s timezone. | refund |
refund_creation_date_gmt |
Refund creation date GMT | Metric | The date the order note was created, as GMT. | refund |
refund_id |
Refund ID | Dimension | Unique identifier for the refund object. | refund |
refund_line_items |
Refund line items | Metric | Line items data. See Order refund – Line items properties. | refund |
refund_line_items_id |
Refund line item ID | Dimension | Unique identifier for the refund line item in WooCommerce. | refund |
refund_line_items_meta_data |
Refund line item meta data | Metric | Meta data. See Order refund – Meta data properties. | refund |
refund_line_items_name |
Refund line item name | Dimension | The display name of the refund line item as configured in WooCommerce. | refund |
refund_line_items_price |
Refund line item price | Metric | Refund line item price metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | refund |
refund_line_items_product_id |
Refund line item product ID | Dimension | Unique identifier for the refund line item product in WooCommerce. | refund |
refund_line_items_quantity |
Refund line item quantity | Metric | Refund line item quantity metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | refund |
refund_line_items_sku |
Refund line item sku | Metric | Refund line item sku metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | refund |
refund_line_items_subtotal |
Refund line item subtotal | Metric | Line subtotal (before discounts). | refund |
refund_line_items_subtotal_tax |
Refund line item subtotal tax | Metric | Line subtotal tax (before discounts). | refund |
refund_line_items_tax_class |
Refund line item tax class | Metric | Refund line item tax class metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | refund |
refund_line_items_taxes |
Refund line item taxes | Metric | Line taxes. See Order refund line item – Taxes properties. | refund |
refund_line_items_total |
Refund line item total | Metric | The total count of refund line item recorded during the reporting period. | refund |
refund_line_items_total_tax |
Refund line item total tax | Metric | Line total tax (after discounts). | refund |
refund_line_items_variation_id |
Refund line item variation ID | Dimension | Variation ID, if applicable. | refund |
refund_meta_data |
Refund meta data | Metric | Meta data. See Order refund – Meta data properties. | refund |
refund_reason |
Refund reason | Metric | Refund reason metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | refund |
refund_refunded_payment |
Refund refunded payment | Metric | If the payment was refunded via the API. See api_refund. | refund |
refund_user_id |
Refund user ID | Dimension | User ID of user who created the refund. | refund |
| report coupon3 fields | ||||
report_coupons_name |
Report coupons name | Dimension | The display name of the report coupons as configured in WooCommerce. | report coupon |
report_coupons_slug |
Report coupons slug | Metric | An alphanumeric identifier for the resource. | report coupon |
report_coupons_total |
Report coupons total | Metric | The total count of report coupons recorded during the reporting period. | report coupon |
| report customer3 fields | ||||
report_customer_name |
Report customer name | Dimension | The display name of the report customer as configured in WooCommerce. | report customer |
report_customer_slug |
Report customer slug | Metric | An alphanumeric identifier for the resource. | report customer |
report_customer_total |
Report customer total | Metric | The total count of report customer recorded during the reporting period. | report customer |
| report order3 fields | ||||
report_order_name |
Report order name | Dimension | The display name of the report order as configured in WooCommerce. | report order |
report_order_slug |
Report order slug | Metric | An alphanumeric identifier for the resource. | report order |
report_order_total |
Report order total | Metric | The total count of report order recorded during the reporting period. | report order |
| report product3 fields | ||||
report_product_name |
Report product name | Dimension | The display name of the report product as configured in WooCommerce. | report product |
report_product_slug |
Report product slug | Metric | An alphanumeric identifier for the resource. | report product |
report_product_total |
Report product total | Metric | The total count of report product recorded during the reporting period. | report product |
| report review3 fields | ||||
report_review_name |
Report review name | Dimension | The display name of the report review as configured in WooCommerce. | report review |
report_review_slug |
Report review slug | Metric | An alphanumeric identifier for the resource. | report review |
report_review_total |
Report review total | Metric | The total count of report review recorded during the reporting period. | report review |
| report sales18 fields | ||||
date_report_total_customers |
Period report customers | Dimension | Timestamp indicating when the period report customers occurred. Used for time-series analysis and reporting. | report sales |
date_report_total_discount |
Period report discount | Dimension | Timestamp indicating when the period report discount occurred. Used for time-series analysis and reporting. | report sales |
date_report_total_items |
Period report items | Dimension | Timestamp indicating when the period report items occurred. Used for time-series analysis and reporting. | report sales |
date_report_total_orders |
Period report orders | Dimension | Timestamp indicating when the period report orders occurred. Used for time-series analysis and reporting. | report sales |
date_report_total_sales |
Period report sales | Dimension | Timestamp indicating when the period report sales occurred. Used for time-series analysis and reporting. | report sales |
date_report_total_shipping |
Period report shipping | Dimension | Timestamp indicating when the period report shipping occurred. Used for time-series analysis and reporting. | report sales |
date_report_total_tax |
Period report shipping | Dimension | Timestamp indicating when the period report shipping occurred. Used for time-series analysis and reporting. | report sales |
report_average_sales |
Report average sales | Metric | Total revenue or sales amount generated. Reported in the account’s configured currency. | report sales |
report_net_sales |
Report net sales | Metric | Total revenue or sales amount generated. Reported in the account’s configured currency. | report sales |
report_total_discount |
Report total discount | Metric | The total count of report dis recorded during the reporting period. | report sales |
report_total_items |
Report total items | Metric | The total count of report items recorded during the reporting period. | report sales |
report_total_orders |
Report total orders | Metric | The total count of report orders recorded during the reporting period. | report sales |
report_total_refunds |
Report total refunds | Metric | The total count of report refunds recorded during the reporting period. | report sales |
report_total_sales |
Report total sales | Metric | Total revenue or sales amount generated. Reported in the account’s configured currency. | report sales |
report_total_shipping |
Report total shipping | Metric | The total count of report shipping recorded during the reporting period. | report sales |
report_total_tax |
Report total tax | Metric | The total count of report tax recorded during the reporting period. | report sales |
report_totals_grouped_by |
Report totals grouped by | Metric | The total count of report s grouped by recorded during the reporting period. | report sales |
totals |
Report totals | Metric | The total count of report s recorded during the reporting period. | report sales |
| report top sellers3 fields | ||||
report_top_sellers_product_id |
Report top sellers product ID | Dimension | Unique identifier for the report top sellers product in WooCommerce. | report top sellers |
report_top_sellers_quantity |
Report top sellers quantity | Metric | Report top sellers quantity metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | report top sellers |
report_top_sellers_title |
Report top sellers title | Dimension | Report top sellers title metric from WooCommerce. This field provides data for reporting and analysis in your marketing dashboards. | report top sellers |