Skip to main content
Last updated: January 27, 2026
63 dimensions
18 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.

​
Store

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

​
Order Attribution

UTM Source
UTM source parameter (e.g., google, facebook). Requires WooCommerce 8.5+ with Order Attribution enabled.

Field Name: attribution_utm_source
Type: dimension
UTM Medium
UTM medium parameter (e.g., cpc, email, social). Requires WooCommerce 8.5+ with Order Attribution enabled.

Field Name: attribution_utm_medium
Type: dimension
UTM Campaign
UTM campaign name. Requires WooCommerce 8.5+ with Order Attribution enabled.

Field Name: attribution_utm_campaign
Type: dimension
UTM Content
UTM content parameter for ad content/variant. Requires WooCommerce 8.5+ with Order Attribution enabled.

Field Name: attribution_utm_content
Type: dimension
UTM Term
UTM term parameter for search keywords. Requires WooCommerce 8.5+ with Order Attribution enabled.

Field Name: attribution_utm_term
Type: dimension
Attribution Source Type
How the customer found your store: utm, organic, direct, referral, typein, admin, or mobile_app. Requires WooCommerce 8.5+.

Field Name: attribution_source_type
Type: dimension
Attribution Referrer
Full referrer URL of where the customer came from. Requires WooCommerce 8.5+ with Order Attribution enabled.

Field Name: attribution_referrer
Type: dimension
Attribution Device Type
Device type: Mobile, Tablet, Desktop, or Unknown. Requires WooCommerce 8.5+ with Order Attribution enabled.

Field Name: attribution_device_type
Type: dimension
Session Landing Page
The first page the customer landed on. Requires WooCommerce 8.5+ with Order Attribution enabled.

Field Name: attribution_session_entry
Type: dimension
Session Page Views
Number of pages viewed before purchase. Requires WooCommerce 8.5+ with Order Attribution enabled.

Field Name: attribution_session_pages
Type: dimension

​
Metrics

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

​
Store 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
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