Last updated: August 5, 2025
53 dimensions
19 metrics
This reference covers all available dimensions and metrics for WooCommerce data through Detrics. Use this guide to understand what data you can extract and how to structure your queries.
Supported destinations:
Google Sheets

​
Dimensions

Dimensions are the attributes you can use to segment and group your WooCommerce data.

​
Most Used

Store URL


Field Name: store_url
Type: dimension

​
Order

Order Number


Field Name: order_number
Type: dimension
Order ID


Field Name: order_id
Type: dimension
Order Parent ID


Field Name: order_parent_id
Type: dimension
Order Key


Field Name: order_key
Type: dimension
Order Status


Field Name: order_status
Type: dimension
Order Currency


Field Name: order_currency
Type: dimension
Order Created Via


Field Name: order_created_via
Type: dimension

​
Order Timestamp

Order Created Date


Field Name: order_created_date
Type: dimension
Order Created Datetime


Field Name: order_created_datetime
Type: dimension
Order Modified Date


Field Name: order_modified_date
Type: dimension
Order Modified Datetime


Field Name: order_modified_datetime
Type: dimension
Order Paid Date


Field Name: order_paid_date
Type: dimension
Order Paid Datetime


Field Name: order_paid_datetime
Type: dimension
Order Completed Date


Field Name: order_completed_date
Type: dimension
Order Completed Datetime


Field Name: order_completed_datetime
Type: dimension
Order Created Date GMT


Field Name: order_created_date_gmt
Type: dimension
Order Created Datetime GMT


Field Name: order_created_datetime_gmt
Type: dimension
Order Modified Date GMT


Field Name: order_modified_date_gmt
Type: dimension
Order Modified Datetime GMT


Field Name: order_modified_datetime_gmt
Type: dimension
Order Paid Date GMT


Field Name: order_paid_date_gmt
Type: dimension
Order Paid Datetime GMT


Field Name: order_paid_datetime_gmt
Type: dimension
Order Completed Date GMT


Field Name: order_completed_date_gmt
Type: dimension
Order Completed Datetime GMT


Field Name: order_completed_datetime_gmt
Type: dimension

​
Billing

Billing First Name


Field Name: billing_first_name
Type: dimension
Billing Last Name


Field Name: billing_last_name
Type: dimension
Billing Company Name


Field Name: billing_company_name
Type: dimension
Billing Address Line 1


Field Name: billing_address_line_1
Type: dimension
Billing Address Line 2


Field Name: billing_address_line_2
Type: dimension
Billing City


Field Name: billing_city
Type: dimension
Billing State


Field Name: billing_state
Type: dimension
Billing Postcode


Field Name: billing_postcode
Type: dimension
Billing Country Code


Field Name: billing_country_code
Type: dimension
Billing Email


Field Name: billing_email
Type: dimension
Billing Phone


Field Name: billing_phone
Type: dimension

​
Shipping

Shipping First Name


Field Name: shipping_first_name
Type: dimension
Shipping Last Name


Field Name: shipping_last_name
Type: dimension
Shipping Company Name


Field Name: shipping_company_name
Type: dimension
Shipping Address Line 1


Field Name: shipping_address_line_1
Type: dimension
Shipping Address Line 2


Field Name: shipping_address_line_2
Type: dimension
Shipping City


Field Name: shipping_city
Type: dimension
Shipping State


Field Name: shipping_state
Type: dimension
Shipping Postcode


Field Name: shipping_postcode
Type: dimension
Shipping Country Code


Field Name: shipping_country_code
Type: dimension

​
Payment

Order is Paid


Field Name: order_is_paid
Type: dimension
Payment Method ID


Field Name: payment_method_id
Type: dimension
Payment Method Title


Field Name: payment_method_title
Type: dimension
Unique Transaction ID


Field Name: unique_transaction_id
Type: dimension
Prices Include Tax


Field Name: prices_include_tax
Type: dimension

​
Customer

Customer ID


Field Name: customer_id
Type: dimension
Customer IP Address


Field Name: customer_ip_address
Type: dimension
Customer User Agent


Field Name: customer_user_agent
Type: dimension
Customer Note


Field Name: customer_note
Type: dimension

​
Metrics

Metrics are the numerical values you can measure and analyze from your WooCommerce campaigns.

​
Sales Report

Gross Sales


Field Name: gross_sales
Type: metric
Net Sales


Field Name: net_sales
Type: metric
Total Sales


Field Name: total_sales
Type: metric
Returns


Field Name: returns
Type: metric
Taxes


Field Name: taxes
Type: metric
Coupons
Total Discounts

Field Name: coupons
Type: metric
Shipping


Field Name: shipping
Type: metric
Items Sold


Field Name: items_sold
Type: metric
Customers


Field Name: customers
Type: metric
Orders


Field Name: orders
Type: metric
Average Order Value


Field Name: average_order_value
Type: metric
Average Items Per Order


Field Name: average_items_per_order
Type: metric

​
Orders

Order Total


Field Name: order_total
Type: metric
Order Shipping Total


Field Name: order_shipping_total
Type: metric
Order Discount Total


Field Name: order_discount_total
Type: metric
Order Shipping Tax


Field Name: order_shipping_tax
Type: metric
Order Discount Tax


Field Name: order_discount_tax
Type: metric
Order Cart Tax


Field Name: order_cart_tax
Type: metric
Order Total Tax


Field Name: order_total_tax
Type: metric