WooCommerce Metrics and Breakdowns
This page provides a comprehensive reference of all supported metrics and breakdowns available for WooCommerce data extraction through Adzviser.
Compatibility
Adzviser supports WooCommerce 2.6 and newer through the WordPress REST API (/wp-json/wc/). Stores that expose only WooCommerce's legacy /wc-api/ API must upgrade WooCommerce before connecting.
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 | Revenue divided by completed orders |
| 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 | Revenue amount represented by product net sales in the reporting currency |
| 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 | Total recurring subscription amount in the order currency |
| Subscription shipping total | Subscription shipping |
| Subscription discount total | Subscription discount |
| Subscription shipping tax | Tax amount associated with subscription shipping transactions |
| Subscription discount tax | Tax amount associated with subscription discount transactions |
| Subscription cart tax | Tax amount associated with subscription cart transactions |
| Subscription total tax | Tax amount associated with subscription total transactions |
Breakdowns
Product Breakdowns
| Field Name | Description |
|---|---|
| Product ID | Unique product identifier |
| Product title | Product name |
| Product SKU | Seller-defined stock-keeping unit for the product or order item |
Order Breakdowns
| Field Name | Description |
|---|---|
| Order number | Reference number assigned to the order |
| Order ID | Unique order identifier |
| Order parent ID | Parent order ID |
| Order key | Key associated with the order |
| Order status | Current order status |
| Order currency | Currency used for the related WooCommerce amounts and budgets |
| 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 | Current 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 |
| Subscription cancelled datetime (GMT) | Calendar date associated with the subscription cancelled time (gmt) event or record |
| Subscription start datetime (GMT) | Calendar date associated with the subscription start time (gmt) event or record |
| Subscription next payment datetime (GMT) | Calendar date associated with the subscription next payment time (gmt) event or record |
| Subscription last payment datetime (GMT) | Calendar date associated with the subscription last payment time (gmt) event or record |
| Subscription billing period | Time unit used for the subscription's recurring billing cycle |
| Subscription billing interval | Number of billing periods between recurring subscription charges |
| Subscription billing first name | Name of the subscription billing first |
| Subscription billing last name | Name of the subscription billing last |
| Subscription billing company name | Name of the subscription billing company |
| Subscription billing address line 1 | Billing address line 1 stored for the subscription |
| Subscription billing address line 2 | Billing address line 2 stored for the subscription |
| Subscription billing city | Billing city associated with the subscription |
| Subscription billing state | Billing state associated with the subscription |
| Subscription billing post code | Reference billing post code assigned to the subscription |
| Subscription billing country code | Geographic billing country code associated with the subscription |
| Subscription billing email | Email address stored for the related WooCommerce record |
| Subscription billing phone | Billing phone associated with the subscription |
| Subscription shipping first name | Name of the subscription shipping first |
| Subscription shipping last name | Name of the subscription shipping last |
| Subscription shipping company name | Name of the subscription shipping company |
| Subscription shipping address line 1 | Shipping address line 1 stored for the subscription |
| Subscription shipping address line 2 | Shipping address line 2 stored for the subscription |
| Subscription shipping city | Shipping city associated with the subscription |
| Subscription shipping state | Shipping state associated with the subscription |
| Subscription shipping post code | Reference shipping post code assigned to the subscription |
| Subscription shipping country code | Geographic shipping country code associated with the subscription |
| Subscription shipping phone | Shipping phone associated with the subscription |