WooCommerce Fields
This page provides a comprehensive reference of all supported metrics and breakdowns available for WooCommerce data extraction through Adzviser.
Metrics
Sales Metrics
| Field Name | Description |
|---|---|
| Gross sales | Total gross sales |
| Returns | Return amount |
| Coupons | Coupon discount total |
| Net sales | Net sales after discounts |
| Taxes | Total tax amount |
| Shipping | Shipping total |
| Total sales | Total sales amount |
| Orders | Order count |
| Average order value | Average order value |
| Items sold | Total items sold |
| Average items per order | Avg items per order |
| Customers | Unique customer count |
Product Metrics
| Field Name | Description |
|---|---|
| Product net sales | Product net sales |
| Product orders | Product order count |
| Product items sold | Product units sold |
Order Level Metrics
| Field Name | Description |
|---|---|
| Order total | Order total amount |
| Order shipping total | Order shipping |
| Order discount total | Order discount |
| Order shipping tax | Shipping tax |
| Order discount tax | Discount tax |
| Order cart tax | Cart tax |
| Order total tax | Total order tax |
Subscription Metrics
| Field Name | Description |
|---|---|
| Subscription total | Subscription total |
| Subscription shipping total | Subscription shipping |
| Subscription discount total | Subscription discount |
| Subscription shipping tax | Subscription shipping tax |
| Subscription discount tax | Subscription discount tax |
| Subscription cart tax | Subscription cart tax |
| Subscription total tax | Subscription total tax |
Breakdowns
Product Breakdowns
| Field Name | Description |
|---|---|
| Product ID | Unique product identifier |
| Product title | Product name |
| Product SKU | Product SKU |
Order Breakdowns
| Field Name | Description |
|---|---|
| Order number | Order number |
| Order ID | Unique order identifier |
| Order parent ID | Parent order ID |
| Order key | Order key |
| Order status | Order status |
| Order currency | Order currency |
| Order created via | Creation source |
| Order created datetime | Creation datetime |
| Order modified datetime | Modification datetime |
| Order paid datetime | Payment datetime |
| Order completed datetime | Completion datetime |
| Order created datetime (GMT) | Creation datetime (GMT) |
| Order modified datetime (GMT) | Modification datetime (GMT) |
| Order paid datetime (GMT) | Payment datetime (GMT) |
| Order completed datetime (GMT) | Completion datetime (GMT) |
Order Billing
| Field Name | Description |
|---|---|
| Order billing first name | First name |
| Order billing last name | Last name |
| Order billing company name | Company |
| Order billing address line 1 | Address line 1 |
| Order billing address line 2 | Address line 2 |
| Order billing city | City |
| Order billing state | State |
| Order billing post code | Postal code |
| Order billing country code | Country code |
| Order billing email | |
| Order billing phone | Phone |
Order Shipping
| Field Name | Description |
|---|---|
| Order shipping first name | First name |
| Order shipping last name | Last name |
| Order shipping company name | Company |
| Order shipping address line 1 | Address line 1 |
| Order shipping address line 2 | Address line 2 |
| Order shipping city | City |
| Order shipping state | State |
| Order shipping post code | Postal code |
| Order shipping country code | Country code |
| Order shipping phone | Phone |
Order Details
| Field Name | Description |
|---|---|
| Order needs payment | Payment needed flag |
| Order payment method ID | Payment method ID |
| Order payment method title | Payment method name |
| Order unique transaction ID | Transaction ID |
| Order prices include tax | Tax included flag |
| Order customer ID | Customer ID |
| Order customer IP address | Customer IP |
| Order customer user agent | User agent |
| Order customer note | Customer note |
Subscription Breakdowns
| Field Name | Description |
|---|---|
| Subscription ID | Subscription identifier |
| Subscription status | Subscription status |
| Subscription currency | Currency |
| Subscription created datetime | Creation datetime |
| Subscription modified datetime | Modification datetime |
| Subscription completed datetime | Completion datetime |
| Subscription paid datetime | Payment datetime |
| Subscription trial end datetime (GMT) | Trial end (GMT) |
| Subscription end datetime (GMT) | End datetime (GMT) |
| Subscription customer ID | Customer ID |
| Subscription customer IP address | Customer IP |
| Subscription customer user agent | User agent |
| Subscription customer note | Customer note |