WooCommerce fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your WooCommerce data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

28 metrics92 dimensions

BILLING

billing_first_name
Field label Billing first name
Description Billing first name
Field type dimension
Data type string.text.value
billing_last_name
Field label Billing last name
Description Billing last name
Field type dimension
Data type string.text.value
billing_company_name
Field label Billing company name
Description Company name
Field type dimension
Data type string.text.value
billing_address_line_1
Field label Billing address line 1
Description Address line 1
Field type dimension
Data type string.text.value
billing_address_line_2
Field label Billing address line 2
Description Address line 2
Field type dimension
Data type string.text.value
billing_city
Field label Billing city
Description City name
Field type dimension
Data type string.geo.city
billing_state
Field label Billing state
Description Shipping state. ISO code or name of the state, province or district
Field type dimension
Data type string.text.value
billing_postcode
Field label Billing post code
Description Postal code
Field type dimension
Data type string.text.value
billing_country
Field label Billing country code
Description Shipping country. Country code in ISO 3166-1 alpha-2 format
Field type dimension
Data type string.geo.country.twolettercode
billing_email
Field label Billing email
Description Email address
Field type dimension
Data type string.text.email
billing_phone
Field label Billing phone
Description Phone number
Field type dimension
Data type string.text.phone

CUSTOMER

customer_id
Field label Customer ID
Description User ID who owns the order. 0 for guests. Default is 0
Field type dimension
Data type string.text.value
customer_ip_address
Field label Customer IP address
Description Customer's IP address
Field type dimension
Data type string.text.value
customer_user_agent
Field label Customer user agent
Description User agent of the customer
Field type dimension
Data type string.text.value
customer_note
Field label Customer note
Description Note left by customer during checkout
Field type dimension
Data type string.text.value

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

LINE ITEM

line_item_parent_name
Field label Product parent name
Description Product parent name
Field type dimension
Data type string.text.value
line_item_name
Field label Product name
Description Product name
Field type dimension
Data type string.text.value
line_item_product_id
Field label Product ID
Description Product ID
Field type dimension
Data type string.text.value
line_item_variation_id
Field label Product variation ID
Description Variation ID, if applicable
Field type dimension
Data type string.text.value
line_item_id
Field label Line item ID
Description Item ID
Field type dimension
Data type string.text.value
line_item_tax_class
Field label Line item tax class
Description Slug of the tax class of product
Field type dimension
Data type string.text.value
line_item_sku
Field label Line item SKU
Description Product SKU
Field type dimension
Data type string.text.value
line_item_image_id
Field label Line item image ID
Description Line item image ID
Field type dimension
Data type string.text.value
line_item_image_url
Field label Line item image URL
Description Line item image URL
Field type dimension
Data type string.text.url
line_item_price
Field label Item price
Description Cost per line item unit
Field type metric
Data type float.currency.value
Aggregation Non-aggregatable metric
quantity
Field label Item quantity
Description Number of line item units
Field type metric
Data type int.number.value
line_item_subtotal
Field label Item subtotal
Description Line item subtotal (before discounts)
Field type metric
Data type float.currency.value
line_item_discount
Field label Item discount
Description Discount applied for the line-item. (Item discount = Item subtotal - Item total)
Field type metric
Data type float.currency.value
line_item_total
Field label Item total
Description Line total (after discounts)
Field type metric
Data type float.currency.value
line_item_total_tax
Field label Item tax
Description Tax for the line item
Field type metric
Data type float.currency.value

ORDER

order_number
Field label Order number
Description Number of the order
Field type dimension
Data type string.text.value
order_id
Field label Order ID
Description Unique identifier for the order
Field type dimension
Data type string.text.value
parent_id
Field label Order parent ID
Description Parent ID of the order
Field type dimension
Data type string.text.value
order_key
Field label Order key
Description Key of the order
Field type dimension
Data type string.text.value
order_status
Field label Order status
Description Order status. Options: pending, processing, on-hold, completed, cancelled, refunded, failed and trash. Default is pending
Field type dimension
Data type string.text.value
order_currency
Field label Order currency
Description Currency the order was created with, in ISO format
Field type dimension
Data type string.currency.code
created_via
Field label Order created via
Description Shows where the order was created
Field type dimension
Data type string.text.value
order_count
Field label Orders
Description The number of new orders placed for a selected date range
Field type metric
Data type int.number.value
avg_order_value
Field label Average order value
Description The average value of orders placed for a selected date range. (Average order value = Net Sales / Orders)
Field type metric
Data type float.currency.value
num_items_sold
Field label Items sold
Description The discrete number of items sold
Field type metric
Data type int.number.value
avg_items_per_order
Field label Average items per order
Description The average number of items placed for a selected date range. (Average items per order = Items sold / Orders)
Field type metric
Data type float.number.value
total_customers
Field label Customers
Description The unique count of customers in the period
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
order_total
Field label Order total
Description Grand total
Field type metric
Data type float.currency.value
order_shipping_total
Field label Order shipping total
Description Total shipping amount for the order
Field type metric
Data type float.currency.value
order_discount_total
Field label Order discount total
Description Total discount amount for the order
Field type metric
Data type float.currency.value
order_shipping_tax
Field label Order shipping tax
Description Total shipping tax amount for the order
Field type metric
Data type float.currency.value
order_discount_tax
Field label Order discount tax
Description Total discount tax amount for the order
Field type metric
Data type float.currency.value
order_cart_tax
Field label Order cart tax
Description Sum of line item taxes only
Field type metric
Data type float.currency.value
order_total_tax
Field label Order total tax
Description Sum of all taxes
Field type metric
Data type float.currency.value

ORDER TIMESTAMP

order_created_date
Field label Order created date
Description The date the order was created, in the site's timezone
Field type dimension
Data type string.time.date
order_created_datetime
Field label Order created datetime
Description The datetime the order was created, in the site's timezone
Field type dimension
Data type string.time.datetime
order_modified_date
Field label Order modified date
Description The date the order was last modified, in the site's timezone
Field type dimension
Data type string.time.date
order_modified_datetime
Field label Order modified datetime
Description The datetime the order was last modified, in the site's timezone
Field type dimension
Data type string.time.datetime
order_paid_date
Field label Order paid date
Description The date the order was paid, in the site's timezone
Field type dimension
Data type string.time.date
order_paid_datetime
Field label Order paid datetime
Description The datetime the order was paid, in the site's timezone
Field type dimension
Data type string.time.datetime
order_completed_date
Field label Order completed date
Description The date the order was completed, in the site's timezone
Field type dimension
Data type string.time.date
order_completed_datetime
Field label Order completed datetime
Description The datetime the order was completed, in the site's timezone
Field type dimension
Data type string.time.datetime
order_created_gmt
Field label Order created date (GMT)
Description The datetime the order was created, in the GMT timezone
Field type dimension
Data type string.time.date
order_created_datetime_gmt
Field label Order created datetime (GMT)
Description The datetime the order was created, in the GMT timezone
Field type dimension
Data type string.time.datetime
order_modified_gmt
Field label Order modified date (GMT)
Description The datetime the order was last modified, in the GMT timezone
Field type dimension
Data type string.time.date
order_modified_datetime_gmt
Field label Order modified datetime (GMT)
Description The datetime the order was last modified, in the GMT timezone
Field type dimension
Data type string.time.datetime
order_paid_date_gmt
Field label Order paid date (GMT)
Description The date the order was paid, in the GMT timezone
Field type dimension
Data type string.time.date
order_paid_datetime_gmt
Field label Order paid datetime (GMT)
Description The datetime the order was paid, in the GMT timezone
Field type dimension
Data type string.time.datetime
order_completed_date_gmt
Field label Order completed date (GMT)
Description The date the order was completed, in the GMT timezone
Field type dimension
Data type string.time.date
order_completed_datetime_gmt
Field label Order completed datetime (GMT)
Description The datetime the order was completed, in the GMT timezone
Field type dimension
Data type string.time.datetime

PAYMENT

needs_payment
Field label Order is paid
Description Define if the order is paid. It will set the status to processing and reduce stock items
Field type dimension
Data type bool
payment_method
Field label Payment method ID
Description Payment method ID
Field type dimension
Data type string.text.value
payment_method_title
Field label Payment method title
Description Payment method title
Field type dimension
Data type string.text.value
transaction_id
Field label Unique transaction ID
Description Unique transaction ID
Field type dimension
Data type string.text.value
prices_include_tax
Field label Prices include tax
Description True the prices included tax during checkout
Field type dimension
Data type bool

PRODUCT

product_id
Field label Product ID
Description ID of the product
Field type dimension
Data type string.text.value
product_title
Field label Product title
Description Name of the product
Field type dimension
Data type string.text.value
sku
Field label SKU
Description Stock keeping unit
Field type dimension
Data type string.text.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

REVENUE

gross_sales
Field label Gross sales
Description Sale price of product(s) multiplied by quantity ordered. Does not include refunds, coupons, taxes, or shipping
Field type metric
Data type float.currency.value
refunds
Field label Returns
Description Money returned to the customer via a refund
Field type metric
Data type float.currency.value
coupons
Field label Coupons
Description Total sum of discounts from coupons
Field type metric
Data type float.currency.value
net_revenue
Field label Net sales
Description Net sale in the period. (Net sales = Gross Sales – Returns – Coupons (referred to as “Sales” in the legacy WooCommerce Reports))
Field type metric
Data type float.currency.value
taxes
Field label Taxes
Description The total tax applied to items in an order
Field type metric
Data type float.currency.value
shipping
Field label Shipping
Description The shipping charges associated with an order or refund
Field type metric
Data type float.currency.value
total_sales
Field label Total sales
Description Total sale in the period. (Total sales = Gross Sales – Returns – Coupons + Taxes + Shipping)
Field type metric
Data type float.currency.value

SALES

product_net_sales
Field label Net sales
Description Product net sales
Field type metric
Data type float.currency.value
product_items_sold
Field label Items sold
Description Number of items sold
Field type metric
Data type int.number.value
product_orders_count
Field label Orders
Description Number of order
Field type metric
Data type int.number.value

SHIPPING

shipping_first_name
Field label Shipping first name
Description Shipping first name
Field type dimension
Data type string.text.value
shipping_last_name
Field label Shipping last name
Description Shipping last name
Field type dimension
Data type string.text.value
shipping_company_name
Field label Shipping company name
Description Shipping company name
Field type dimension
Data type string.text.value
shipping_address_line_1
Field label Shipping address line 1
Description Shipping address line 1
Field type dimension
Data type string.text.value
shipping_address_line_2
Field label Shipping address line 2
Description Shipping address line 2
Field type dimension
Data type string.text.value
shipping_city
Field label Shipping city
Description Shipping city name
Field type dimension
Data type string.geo.city
shipping_state
Field label Shipping state
Description Shipping state. ISO code or name of the state, province or district
Field type dimension
Data type string.text.value
shipping_postcode
Field label Shipping post code
Description Shipping postal code
Field type dimension
Data type string.text.value
shipping_country
Field label Shipping country code
Description Shipping country. Country code in ISO 3166-1 alpha-2 format
Field type dimension
Data type string.geo.country.twolettercode
shipping_phone
Field label Shipping phone
Description Shipping phone number
Field type dimension
Data type string.text.phone

STORE

account_name
Field label Store URL
Description The URL of the store
Field type dimension
Data type string.text.url

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime