WooCommerce — data fields
Orders and revenue from a WordPress + WooCommerce store. Every field id you can pass to fields= in the API, Looker Studio, exports and AI chats. Shared ids line up across sources so they blend.
All sources
Meta Ads (Facebook & Instagram)Google AdsTikTok AdsLinkedIn AdsGoogle Analytics 4Google Search ConsoleFacebook Pages (organic)Instagram (organic)YouTube AnalyticsShopifyWooCommerceKlaviyo
| Field id | Name | Section | Kind | Type | Description |
|---|---|---|---|---|---|
account_id |
Account ID | dimension | string | ||
account_name |
Account name | dimension | string | ||
conversions |
Orders (as conversions) | metric | integer | ||
currency |
Currency | dimension | string | ||
customer_id |
Customer ID | dimension | string | ||
datasource |
Data source | dimension | string | Connector the row came from | |
date |
Order date | dimension | date | ||
discounts |
Discounts | metric | currency | ||
items_sold |
Items sold | metric | integer | ||
net_revenue |
Net (total - refunded) | metric | currency | ||
order_id |
Order ID | dimension | string | ||
order_status |
Order status | dimension | string | ||
orders |
Orders | metric | integer | ||
payment_method |
Payment method | dimension | string | ||
refunds |
Refunded | metric | currency | ||
revenue |
Order total | metric | currency | ||
shipping |
Shipping | metric | currency | ||
tax |
Tax | metric | currency |
Date parts
Available on any source with date. Metrics are re-aggregated to the period.
weekWeek (starting Monday)year_weekYear-week (2026-W42)monthMonth (2026-10)quarterQuarter (2026-Q4)yearYearday_of_weekDay of week (Mon..Sun)Calculated metrics
Computed after aggregation wherever the inputs exist.
roasrevenue / nullif(spend, 0)cpaspend / nullif(conversions, 0)conversion_rateconversions / nullif(clicks, 0) * 100aovrevenue / nullif(orders, 0)Filters
Pass JSON in filters=:
[["spend","gt",100],"and", ["campaign","contains","brand"]]
Operators: eq, neq, gt, gte, lt, lte, contains, ncontains, null, notnull, in.