Field group | Field | Type | Data type | Description |
|---|---|---|---|---|
| Sales | Total sales | METRIC | CURRENCY | Total sales amount. |
| Sales | Net sales | METRIC | CURRENCY | Order Total - Order Tax - Order Shipping |
| Sales | Gross sales | METRIC | CURRENCY | Net Sales + Order Discounts + Order Refunds. |
| Sales | Average sales | METRIC | CURRENCY | Average sales amount. |
| Sales | Orders | METRIC | INTEGER | Total orders count. |
| Sales | Customers | METRIC | INTEGER | Total customers count. |
| Sales | Items Sold | METRIC | INTEGER | Total items sold. |
| Sales | Net items sold | METRIC | INTEGER | Total items sold - refunded items. |
| Sales | Refunds | METRIC | INTEGER | Total Refunded items count. |
| Sales | Coupons (deprecated) | METRIC | INTEGER | Total coupons count. |
| Sales | Total tax | METRIC | CURRENCY | Total tax amount. |
| Sales | Total shipping | METRIC | CURRENCY | Total shipping amount. |
| Sales | Total refund | METRIC | CURRENCY | Total refund amount. |
| Sales | Total discount | METRIC | CURRENCY | Total discount amount. |
| Sales | Total discount tax | METRIC | CURRENCY | Total discount tax amount. |
| Sales (including pending) | Total sales (including pending) | METRIC | CURRENCY | Sum of all order totals, regardless of payment or completion status. Unlike the "Total sales" metric under Sales, this includes orders still awaiting payment or delivery — such as Cash on Delivery orders that haven't been marked "Completed" yet — so it won't miss revenue from orders your store hasn't updated. It also isn't refund-adjusted the way Total sales is, and it's dated by order creation date rather than Total sales' payment/completion date, so the two figures use different date ranges for the same period. |
| Sales (including pending) | Gross sales (including pending) | METRIC | CURRENCY | Gross product sales before discounts, tax, and shipping were applied, computed from every order regardless of payment or completion status. |
| Sales (including pending) | Total discount (including pending) | METRIC | CURRENCY | Total discount amount, computed from every order regardless of payment or completion status. |
| Sales (including pending) | Total shipping (including pending) | METRIC | CURRENCY | Total shipping amount, computed from every order regardless of payment or completion status. |
| Sales (including pending) | Total tax (including pending) | METRIC | CURRENCY | Total tax amount, computed from every order regardless of payment or completion status. |
| Sales (including pending) | Total discount tax (including pending) | METRIC | CURRENCY | Total discount tax amount, computed from every order regardless of payment or completion status. |
| Sales (including pending) | Order cart tax (including pending) | METRIC | CURRENCY | Total cart tax charged for an order, computed from every order regardless of payment or completion status. |
| Sales (including pending) | Order total tax shipping (including pending) | METRIC | CURRENCY | The amount of shipping tax collected for the order, computed from every order regardless of payment or completion status. |
| Coupons | Order maximum amount | METRIC | CURRENCY | Maximum order amount allowed when using the coupon. |
| Coupons | Order minimum amount | METRIC | CURRENCY | Minimum order amount that needs to be in the cart before coupon applies. |
| Coupons | Coupon amount of discount | METRIC | CURRENCY | Amount of discount. This will be 0 for percentage based coupons. |
| Orders | Order cart tax | METRIC | CURRENCY | Total cart tax charged for an order. |
| Orders | Order total tax shipping | METRIC | CURRENCY | The amount of shipping tax collected for the order. |
| Orders | Order discount tax (deprecated) | METRIC | CURRENCY | Total discount tax charged for an order. |
| Line Items | Line item subtotal | METRIC | CURRENCY | Line subtotal (before discounts). |
| Line Items | Line item subtotal tax | METRIC | CURRENCY | Line subtotal tax (before discounts). |
| Line Items | Line item total | METRIC | CURRENCY | Line total (after discounts). |
| Line Items | Line item total tax | METRIC | CURRENCY | Line total tax (after discounts). |
| Line Items | Line item refund total (deprecated) | METRIC | CURRENCY | Line Item refund amount. |
| Products | Product rating count | METRIC | FLOAT | Amount of reviews that the product have. |
| Products | Product average rating | METRIC | FLOAT | Reviews average rating. |
| Product Variations | Product variation stock quantity | METRIC | INTEGER | Variation stock quantity. |
| Product reviews | Product review rating | METRIC | FLOAT | Review rating (0 to 5). |
| Refunds | Refund amount (deprecated) | METRIC | CURRENCY | Total refund amount. |
| Time | Year | DIMENSION | YEAR | Metrics are broken down yearly in the format YYYY (e.g. 2019). |
| Time | Year month | DIMENSION | YEARMONTH | Metrics are broken down monthly in the format YYYY-MMM (e.g. 2019-Jan). |
| Time | Year month number | DIMENSION | YEAR_MONTH_NUMBER | Metrics are broken down monthly in the format YYYY-MM (e.g. 2019-01). |
| Time | Month | DIMENSION | MONTHNAME | Metrics are broken down monthly in the format MMMM (e.g. January). |
| Time | Month Number | DIMENSION | MONTH | Metrics are broken down monthly in the format MM (e.g. 01). |
| Time | Week number(sun-sat) | DIMENSION | WEEK_NUMBER | Metrics are broken down weekly in the format WW (e.g. 01). |
| Time | Week number(mon-sun) | DIMENSION | WEEK_ISO_NUMBER | Metrics are broken down ISO weekly in the format WW (e.g. 01). |
| Time | Week start date(sun - sat) | DIMENSION | WEEK_START_DATE | Start date of the week in the format YYYY-MM-DD. |
| Time | Week start date(mon - sun) | DIMENSION | WEEK_ISO_START_DATE | Start date of the ISO week in the format YYYY-MM-DD. |
| Time | Date | DIMENSION | DATE | Metrics are broken down daily in the format YYYY-MM-DD. |
| Time | Hour | DIMENSION | HOUR | Metrics are broken down hourly in the format HH (e.g. 01). |
| Store | Store name | DIMENSION | STRING | Name of the store |
| Store | Store description | DIMENSION | STRING | Description of the store |
| Store | Store URL | DIMENSION | URL | URL of the store |
| Coupons | Coupon ID | DIMENSION | INTEGER | Unique identifier of the coupon. |
| Coupons | Coupon code | DIMENSION | STRING | Computer-generated code, consisting of letters or Numbers that consumers can enter into a promotional box on a site's shopping cart (or checkout page) to obtain a discount on the current purchase. |
| Coupons | Coupon creation date | DIMENSION | DATETIME | The date the coupon was created, in the site's timezone. |
| Coupons | Coupon creation date GMT | DIMENSION | DATETIME | The date the coupon was created, as GMT. |
| Coupons | Coupon modification date | DIMENSION | DATETIME | The date the coupon was last modified, in the site's timezone. |
| Coupons | Coupon modification date GMT | DIMENSION | DATETIME | The date the coupon was last modified, as GMT. |
| Coupons | Coupon discount type | DIMENSION | STRING | Determines the type of discount that will be applied. |
| Coupons | Coupon description | DIMENSION | STRING | Description of the coupon. |
| Coupons | Coupon expiration date | DIMENSION | DATETIME | The date the coupon expires, in the site's timezone. |
| Coupons | Coupon expiration date GMT | DIMENSION | DATETIME | The date the coupon expires, as GMT. |
| Coupons | Coupon usage count | DIMENSION | INTEGER | The Number of times the coupon has been used already. |
| Coupons | Is one time use | DIMENSION | BOOLEAN | If true the coupon can only be used individually. Other applied coupons will be removed from the cart. Default is false. |
| Coupons | Coupon usage limit | DIMENSION | INTEGER | How many times the coupon can be used in total. |
| Coupons | Coupon usage limit per user | DIMENSION | INTEGER | How many times the coupon can be used per customer. |
| Coupons | Coupon usage limit to x items | DIMENSION | INTEGER | Max Number of items in the cart the coupon can be applied to. |
| Coupons | Coupon free shipping | DIMENSION | BOOLEAN | If true and if the free shipping method requires a coupon, this coupon will enable free shipping. Default is false. |
| Coupons | Coupon excludes sale items | DIMENSION | BOOLEAN | If true this coupon will not be applied to items that have sale prices. Default is false. |
| Coupons | Coupon email restriction | DIMENSION | STRING | The email address that can use this coupon. |
| Customers | Customer ID | DIMENSION | INTEGER | Unique identifier for the customer object. |
| Customers | Customer modification date | DIMENSION | DATETIME | The date the customer was last modified, in the site's timezone. |
| Customers | Customer modification date gmt | DIMENSION | DATETIME | The date the customer was last modified, as GMT. |
| Customers | Customer creation date | DIMENSION | DATETIME | The date the customer was created, in the site's timezone. |
| Customers | Customer creation date GMT | DIMENSION | DATETIME | The date the customer was created, as GMT. |
| Customers | Customer email | DIMENSION | STRING | The email address for the customer. |
| Customers | Customer full name | DIMENSION | STRING | Customer full name. |
| Customers | Customer first name | DIMENSION | STRING | Customer first name. |
| Customers | Customer last name | DIMENSION | STRING | Customer last name. |
| Customers | Customer role | DIMENSION | STRING | Customer role. |
| Customers | Customer username | DIMENSION | STRING | Customer username. |
| Customers | Is a paying customer? | DIMENSION | BOOLEAN | Is the customer a paying customer? |
| Customers | Customer avatar URL | DIMENSION | IMAGE_URL | Graphical representation of a user or the user's character or persona. |
| Customers | Customer billing first name | DIMENSION | STRING | Customer billing first name. |
| Customers | Customer billing last name | DIMENSION | STRING | Customer billing last name. |
| Customers | Customer billing company | DIMENSION | STRING | Customer billing company name. |
| Customers | Customer billing address line 1 | DIMENSION | STRING | Customer Address line 1. |
| Customers | Customer billing address line 2 | DIMENSION | STRING | Customer billing address line 2. |
| Customers | Customer billing city | DIMENSION | CITY | Customer billing city. |
| Customers | Customer billing state | DIMENSION | REGION_CODE | Customer billing state in ISO code. |
| Customers | Customer billing postal code | DIMENSION | STRING | Customer billing postal code. |
| Customers | Customer billing country | DIMENSION | COUNTRY_CODE | Customer billing country in ISO code. |
| Customers | Customer billing email | DIMENSION | STRING | Customer billing email |
| Customers | Customer billing phone | DIMENSION | STRING | Customer billing phone. |
| Customers | Customer billing | DIMENSION | STRING | List of billing address data for a customer. |
| Customers | Customer shipping first name | DIMENSION | STRING | Customer shipping first name. |
| Customers | Customer shipping last name | DIMENSION | STRING | Customer shipping last name. |
| Customers | Customer shipping company | DIMENSION | STRING | Customer shipping company |
| Customers | Customer shipping address line 1 | DIMENSION | STRING | Customer shipping address line 1. |
| Customers | Customer shipping address line 2 | DIMENSION | STRING | Customer shipping address line 2. |
| Customers | Customer shipping city | DIMENSION | CITY | Customer shipping city. |
| Customers | Customer shipping state | DIMENSION | REGION_CODE | Customer shipping state in ISO code. |
| Customers | Customer shipping postal code | DIMENSION | STRING | Customer shipping postal code. |
| Customers | Customer shipping country | DIMENSION | COUNTRY_CODE | Customer shipping country in ISO code. |
| Customers | Customer shipping phone | DIMENSION | STRING | Customer shipping phone |
| Customers | Customer shipping | DIMENSION | STRING | List of shipping address data for a customer. |
| Customers | Customer type | DIMENSION | STRING | Type of the customer. |
| Orders | Order ID | DIMENSION | INTEGER | Unique identifier for the order. |
| Orders | Order parent ID | DIMENSION | INTEGER | Order parent ID. |
| Orders | Order number | DIMENSION | STRING | Order number. |
| Orders | Order key | DIMENSION | STRING | Order key. |
| Orders | Order created via | DIMENSION | STRING | Shows how the order was created. |
| Orders | Order version | DIMENSION | STRING | Order version. |
| Orders | Order status | DIMENSION | STRING | Order status. |
| Orders | Order currency | DIMENSION | STRING | Order currency. |
| Orders | Order date created | DIMENSION | DATETIME | Order date created. |
| Orders | Order date created GMT | DIMENSION | DATETIME | Order date created GMT. |
| Orders | Order date modified | DIMENSION | DATETIME | Order date modified. |
| Orders | Order date modified GMT | DIMENSION | DATETIME | Order date modified GMT. |
| Orders | Order date completed | DIMENSION | DATETIME | Order date completed. |
| Orders | Order date completed GMT | DIMENSION | DATETIME | Order date completed GMT. |
| Orders | Order customer IP address | DIMENSION | STRING | Order customer IP address. |
| Orders | Order customer user agent | DIMENSION | STRING | Order customer user agent. |
| Orders | Order customer note | DIMENSION | STRING | Order customer note. |
| Orders | Order billing first name | DIMENSION | STRING | Order billing first name. |
| Orders | Order billing last name | DIMENSION | STRING | Order billing last name. |
| Orders | Order billing company | DIMENSION | STRING | Order billing company. |
| Orders | Order billing address 1 | DIMENSION | STRING | Order billing address 1. |
| Orders | Order billing address 2 | DIMENSION | STRING | Order billing address 2. |
| Orders | Order billing city | DIMENSION | CITY | Order billing city. |
| Orders | Order billing state | DIMENSION | REGION_CODE | Order billing ISO code or name of the state, province or district. |
| Orders | Order billing postal code | DIMENSION | STRING | Order billing postal code. |
| Orders | Order billing country | DIMENSION | COUNTRY_CODE | Order billing country code in ISO 3166-1 alpha-2 format. |
| Orders | Order billing email | DIMENSION | STRING | Order billing email. |
| Orders | Order billing phone | DIMENSION | STRING | Order billing phone. |
| Orders | Order billing | DIMENSION | STRING | Order billing. |
| Orders | Order shipping first name | DIMENSION | STRING | Order shipping first name. |
| Orders | Order shipping last name | DIMENSION | STRING | Order shipping last name. |
| Orders | Order shipping company | DIMENSION | STRING | Order shipping company. |
| Orders | Order shipping address 1 | DIMENSION | STRING | Order shipping address 1. |
| Orders | Order shipping address 2 | DIMENSION | STRING | Order shipping address 2. |
| Orders | Order shipping city | DIMENSION | CITY | Order shipping city. |
| Orders | Order shipping state | DIMENSION | REGION_CODE | Order shipping ISO code or name of the state, province or district. |
| Orders | Order shipping postal code | DIMENSION | STRING | Order shipping postal code. |
| Orders | Order shipping country | DIMENSION | COUNTRY_CODE | Order shipping country code in ISO 3166-1 alpha-2 format. |
| Orders | Order shipping phone | DIMENSION | STRING | Order shipping phone. |
| Orders | Order shipping | DIMENSION | STRING | Order shipping. |
| Orders | Order payment method | DIMENSION | STRING | Order payment method. |
| Orders | Order payment method title | DIMENSION | STRING | Order payment method title. |
| Orders | Order transaction ID | DIMENSION | STRING | Order transaction ID. |
| Orders | Order date paid | DIMENSION | DATETIME | Order date paid. |
| Orders | Order date paid GMT | DIMENSION | DATETIME | Order date paid GMT. |
| Orders | Order cart hash | DIMENSION | STRING | Order cart hash. |
| Orders | Order tax line ID | DIMENSION | INTEGER | Item ID. |
| Orders | Order tax line rate code | DIMENSION | STRING | Tax rate code. |
| Orders | Order tax line rate ID | DIMENSION | STRING | Tax rate ID. |
| Orders | Order tax line label | DIMENSION | STRING | Tax rate label. |
| Orders | Order tax line compound | DIMENSION | STRING | Show if is a compound tax rate. |
| Orders | Order tax line total | DIMENSION | CURRENCY | Tax total (not including shipping taxes). |
| Orders | Order tax line shipping total | DIMENSION | CURRENCY | Shipping tax total. |
| Orders | Order shipping line ID | DIMENSION | INTEGER | Item ID. |
| Orders | Order shipping line method title | DIMENSION | STRING | Shipping method name. |
| Orders | Order shipping line method ID | DIMENSION | STRING | Shipping method ID. |
| Orders | Order shipping line total | DIMENSION | CURRENCY | Line total (after discounts). |
| Orders | Order shipping line total tax | DIMENSION | CURRENCY | Line total tax (after discounts). |
| Orders | Order shipping line taxes | DIMENSION | STRING | Line taxes. See Order - Taxes properties. |
| Orders | Order fee line ID | DIMENSION | INTEGER | Item ID. |
| Orders | Order fee line name | DIMENSION | STRING | Fee name. |
| Orders | Order fee line tax class | DIMENSION | STRING | Tax class of fee. |
| Orders | Order fee line tax status | DIMENSION | STRING | Tax status of fee. Options: taxable and none. |
| Orders | Order fee line total | DIMENSION | CURRENCY | Fee line total (after discounts). |
| Orders | Order fee line total tax | DIMENSION | CURRENCY | Fee line total tax (after discounts). |
| Orders | Order fee line taxes | DIMENSION | STRING | Fee line taxes. See Order - Taxes properties. |
| Orders | Order coupon line ID | DIMENSION | INTEGER | Item ID. |
| Orders | Order coupon line code | DIMENSION | STRING | Coupon code. |
| Orders | Order coupon line discount | DIMENSION | FLOAT | Discount total. |
| Orders | Order coupon line discount tax | DIMENSION | FLOAT | Discount total tax. |
| Orders | Order set paid | DIMENSION | BOOLEAN | Order set paid |
| Order details (including pending) | Order date created (including pending) | DIMENSION | DATETIME | Order creation date. This is the date basis for the Sales (including pending) metrics — different from the plain Sales metrics, which use the order's paid/completed date instead. |
| Order details (including pending) | Order year (including pending) | DIMENSION | YEAR | Metrics are broken down yearly in the format YYYY (e.g. 2019), for use with the Sales (including pending) metrics. Use this instead of the plain "Year" dimension when combining with those metrics. |
| Order details (including pending) | Order year month (including pending) | DIMENSION | YEARMONTH | Metrics are broken down monthly in the format YYYY-MMM (e.g. 2019-Jan), for use with the Sales (including pending) metrics. Use this instead of the plain "Year month" dimension when combining with those metrics. |
| Order details (including pending) | Order year month number (including pending) | DIMENSION | YEAR_MONTH_NUMBER | Metrics are broken down monthly in the format YYYY-MM (e.g. 2019-01), for use with the Sales (including pending) metrics. Use this instead of the plain "Year month number" dimension when combining with those metrics. |
| Order details (including pending) | Order month (including pending) | DIMENSION | MONTHNAME | Metrics are broken down monthly in the format MMMM (e.g. January), for use with the Sales (including pending) metrics. Use this instead of the plain "Month" dimension when combining with those metrics. |
| Order details (including pending) | Order month number (including pending) | DIMENSION | MONTH | Metrics are broken down monthly in the format MM (e.g. 01), for use with the Sales (including pending) metrics. Use this instead of the plain "Month Number" dimension when combining with those metrics. |
| Order details (including pending) | Order week number(sun-sat) (including pending) | DIMENSION | WEEK_NUMBER | Metrics are broken down weekly in the format WW (e.g. 01), for use with the Sales (including pending) metrics. Use this instead of the plain "Week number(sun-sat)" dimension when combining with those metrics. |
| Order details (including pending) | Order week number(mon-sun) (including pending) | DIMENSION | WEEK_ISO_NUMBER | Metrics are broken down ISO weekly in the format WW (e.g. 01), for use with the Sales (including pending) metrics. Use this instead of the plain "Week number(mon-sun)" dimension when combining with those metrics. |
| Order details (including pending) | Order week start date(sun - sat) (including pending) | DIMENSION | WEEK_START_DATE | Start date of the week in the format YYYY-MM-DD, for use with the Sales (including pending) metrics. Use this instead of the plain "Week start date(sun - sat)" dimension when combining with those metrics. |
| Order details (including pending) | Order week start date(mon - sun) (including pending) | DIMENSION | WEEK_ISO_START_DATE | Start date of the ISO week in the format YYYY-MM-DD, for use with the Sales (including pending) metrics. Use this instead of the plain "Week start date(mon - sun)" dimension when combining with those metrics. |
| Order details (including pending) | Order date (including pending) | DIMENSION | DATE | Metrics are broken down daily in the format YYYY-MM-DD, for use with the Sales (including pending) metrics. Use this instead of the plain "Date" dimension when combining with those metrics. |
| Order details (including pending) | Order hour (including pending) | DIMENSION | HOUR | Metrics are broken down hourly in the format HH (e.g. 01), for use with the Sales (including pending) metrics. Use this instead of the plain "Hour" dimension when combining with those metrics. |
| Order details (including pending) | Order status (including pending) | DIMENSION | STRING | Order status, for use with the Sales (including pending) metrics (e.g. order_total). Use this instead of the plain "Order status" dimension when combining with those metrics. |
| Order details (including pending) | Order payment method title (including pending) | DIMENSION | STRING | Order payment method title, for use with the Sales (including pending) metrics (e.g. order_total). Use this instead of the plain "Order payment method title" dimension when combining with those metrics. |
| Order details (including pending) | Order payment method (including pending) | DIMENSION | STRING | Order payment method (gateway ID), for use with the Sales (including pending) metrics. |
| Order details (including pending) | Order date paid (including pending) | DIMENSION | DATETIME | Order date paid, for use with the Sales (including pending) metrics. Empty for orders that haven't been paid yet. |
| Order details (including pending) | Order date paid GMT (including pending) | DIMENSION | DATETIME | Order date paid (GMT), for use with the Sales (including pending) metrics. Empty for orders that haven't been paid yet. |
| Order details (including pending) | Order date completed (including pending) | DIMENSION | DATETIME | Order date completed, for use with the Sales (including pending) metrics. Empty for orders that haven't been marked Completed yet. |
| Order details (including pending) | Order date completed GMT (including pending) | DIMENSION | DATETIME | Order date completed (GMT), for use with the Sales (including pending) metrics. Empty for orders that haven't been marked Completed yet. |
| Order details (including pending) | Order currency (including pending) | DIMENSION | STRING | Order currency, for use with the Sales (including pending) metrics. |
| Order details (including pending) | Order created via (including pending) | DIMENSION | STRING | Shows how the order was created, for use with the Sales (including pending) metrics. |
| Order details (including pending) | Customer ID (including pending) | DIMENSION | INTEGER | Unique identifier for the customer object, for use with the Sales (including pending) metrics. |
| Order details (including pending) | Order billing country (including pending) | DIMENSION | COUNTRY_CODE | Order billing country code in ISO 3166-1 alpha-2 format, for use with the Sales (including pending) metrics. |
| Order details (including pending) | Order billing state (including pending) | DIMENSION | REGION_CODE | Order billing ISO code or name of the state, province or district, for use with the Sales (including pending) metrics. |
| Order details (including pending) | Order billing city (including pending) | DIMENSION | CITY | Order billing city, for use with the Sales (including pending) metrics. |
| Order details (including pending) | Order billing email (including pending) | DIMENSION | STRING | Order billing email, for use with the Sales (including pending) metrics. |
| Order details (including pending) | Order shipping country (including pending) | DIMENSION | COUNTRY_CODE | Order shipping country code in ISO 3166-1 alpha-2 format, for use with the Sales (including pending) metrics. |
| Order details (including pending) | Order shipping state (including pending) | DIMENSION | REGION_CODE | Order shipping ISO code or name of the state, province or district, for use with the Sales (including pending) metrics. |
| Order details (including pending) | Order shipping city (including pending) | DIMENSION | CITY | Order shipping city, for use with the Sales (including pending) metrics. |
| Line items | Line item name | DIMENSION | STRING | Product name. |
| Line items | Line item ID | DIMENSION | INTEGER | Item ID. |
| Line items | Line item quantity | DIMENSION | STRING | Quantity ordered. |
| Line items | Line item tax class | DIMENSION | STRING | Tax class of item. |
| Line items | Line item taxes | DIMENSION | STRING | Line taxes. See Order - Taxes properties. |
| Line items | Line item sku | DIMENSION | STRING | Product SKU. |
| Line items | Line item price | DIMENSION | CURRENCY | Product price. |
| Products | Product name | DIMENSION | STRING | Product name. |
| Products | Product ID | DIMENSION | INTEGER | Unique identifier for the resource. |
| Products | Product slug | DIMENSION | STRING | Product slug. |
| Products | Product permalink | DIMENSION | URL | Product URL. |
| Products | Product date created | DIMENSION | DATETIME | The date the product was created, in the site's timezone. |
| Products | Product date created GMT | DIMENSION | DATETIME | The date the product was created, as GMT. |
| Products | Product date modified | DIMENSION | DATETIME | The date the product was last modified, in the site's timezone. |
| Products | Product date modified GMT | DIMENSION | DATETIME | The date the product was last modified, as GMT. |
| Products | Product type | DIMENSION | STRING | Product type. Options: simple, grouped, external and variable. |
| Products | Product status | DIMENSION | STRING | Product status (post status). Options: draft, pending, private and publish. |
| Products | Product featured | DIMENSION | BOOLEAN | Featured product. |
| Products | Product catalog visibility | DIMENSION | STRING | Catalog visibility. Options: visible, catalog, search and hidden. |
| Products | Product description | DIMENSION | STRING | Product description. |
| Products | Product short description | DIMENSION | STRING | Product short description. |
| Products | Product SKU | DIMENSION | STRING | Unique identifier. |
| Products | Product price | DIMENSION | CURRENCY | Current product price. |
| Products | Product sale price | DIMENSION | CURRENCY | Sale price of the product. |
| Products | Product regular price | DIMENSION | CURRENCY | Regular price of the product. |
| Products | Product stock quantity | DIMENSION | INTEGER | Stock quantity. |
| Products | Product date on sale from | DIMENSION | DATETIME | Start date of sale price, in the site's timezone. |
| Products | Product date on sale from GMT | DIMENSION | DATETIME | Start date of sale price, as GMT. |
| Products | Product date on sale to | DIMENSION | DATETIME | End date of sale price, in the site's timezone. |
| Products | Product date on sale to GMT | DIMENSION | DATETIME | End date of sale price, as GMT. |
| Products | Product price html | DIMENSION | STRING | Price formatted in HTML. |
| Products | Product on sale | DIMENSION | BOOLEAN | Shows if the product is on sale. |
| Products | Product purchasable | DIMENSION | BOOLEAN | Shows if the product can be bought. |
| Products | Product virtual | DIMENSION | BOOLEAN | If the product is virtual. |
| Products | Product downloadable | DIMENSION | BOOLEAN | If the product is downloadable. |
| Products | Product download expiry | DIMENSION | INTEGER | Number of days until access to downloadable files expires. Default is -1. |
| Products | Product download limit | DIMENSION | INTEGER | Number of times downloadable files can be downloaded after purchase. Default is -1. |
| Products | Product external url | DIMENSION | URL | Product external URL. Only for external products. |
| Products | Product button text | DIMENSION | STRING | Product external button text. Only for external products. |
| Products | Product tax status | DIMENSION | STRING | Tax status. Options: taxable, shipping and none. |
| Products | Product tax class | DIMENSION | STRING | Tax class. |
| Products | Product manage stock | DIMENSION | BOOLEAN | Stock management at product level. |
| Products | Product stock status | DIMENSION | STRING | Controls whether or not the product is listed as 'in stock' or 'out of stock' on the frontend. Options: instock, outofstock and onbackorder. |
| Products | Product backorders | DIMENSION | STRING | If managing stock, this controls if backorders are allowed. Options: no, notify and yes. |
| Products | Product sold individually | DIMENSION | BOOLEAN | Allow one item to be bought in a single order. |
| Products | Product weight | DIMENSION | INTEGER | Product weight (kg). |
| Products | Product length | DIMENSION | INTEGER | Product length (cm). |
| Products | Product width | DIMENSION | INTEGER | Product width (cm). |
| Products | Product height | DIMENSION | INTEGER | Product height (cm). |
| Products | Product shipping required | DIMENSION | BOOLEAN | Shows if the product needs shipping. |
| Products | Product shipping taxable | DIMENSION | BOOLEAN | Shows if the product shipping is taxable. |
| Products | Product shipping class | DIMENSION | STRING | Shipping class slug. |
| Products | Product shipping class id | DIMENSION | INTEGER | Shipping class id. |
| Products | Product reviews allowed | DIMENSION | BOOLEAN | Allow reviews. |
| Products | Product related ids | DIMENSION | STRING | Related product ids. |
| Products | Product upsell ids | DIMENSION | STRING | Upsell product ids. |
| Products | Product cross sell ids | DIMENSION | STRING | Cross sell product ids. |
| Products | Product parent id | DIMENSION | INTEGER | Parent id. |
| Products | Product purchase note | DIMENSION | STRING | Purchase note. |
| Products | Product download ID | DIMENSION | INTEGER | Product downloads id. |
| Products | Product download name | DIMENSION | STRING | Product downloads name. |
| Products | Product download file | DIMENSION | STRING | Product downloads file. |
| Products | Product category id | DIMENSION | INTEGER | Category id. |
| Products | Product category name | DIMENSION | STRING | Category name. |
| Products | Product category slug | DIMENSION | STRING | Category slug. |
| Products | Product tag ID | DIMENSION | INTEGER | Tag id. |
| Products | Product tag name | DIMENSION | STRING | Tag name. |
| Products | Product tag slug | DIMENSION | STRING | Tag slug. |
| Products | Product image ID | DIMENSION | INTEGER | Image id. |
| Products | Product image URL | DIMENSION | IMAGE_URL | Image URL. |
| Products | Product image name | DIMENSION | STRING | Image name. |
| Products | Product image alt | DIMENSION | STRING | Image alt. |
| Products | Product attribute ID | DIMENSION | INTEGER | Attribute id. |
| Products | Product attribute name | DIMENSION | STRING | Attribute name. |
| Products | Product attribute position | DIMENSION | INTEGER | Attribute position. |
| Products | Product attribute visible | DIMENSION | BOOLEAN | Attribute visible. |
| Products | Product attribute variation | DIMENSION | BOOLEAN | Attribute variation. |
| Products | Product attribute options | DIMENSION | STRING | Attribute options. |
| Products | Product grouped products | DIMENSION | STRING | Grouped products. |
| Products | Product menu order | DIMENSION | INTEGER | Menu order, used to custom sort products. |
| Product Variations | Product variation id | DIMENSION | INTEGER | Product variation id. |
| Product Variations | Product variation name | DIMENSION | STRING | Product variation name. |
| Product Variations | Product variation date created | DIMENSION | DATETIME | The date the product variation was created, in the site's timezone. |
| Product Variations | Product variation date created GMT | DIMENSION | DATETIME | The date the product variation was created, as GMT. |
| Product Variations | Product variation date modified | DIMENSION | DATETIME | The date the product variation was last modified, in the site's timezone. |
| Product Variations | Product variation date modified GMT | DIMENSION | DATETIME | The date the product variation was last modified, as GMT. |
| Product Variations | Product variation description | DIMENSION | STRING | Product variation description. |
| Product Variations | Product variation permalink | DIMENSION | URL | Product variation permalink. |
| Product Variations | Product variation sku | DIMENSION | STRING | Unique identifier. |
| Product Variations | Product variation price | DIMENSION | CURRENCY | Variation current price. |
| Product Variations | Product variation sale price | DIMENSION | CURRENCY | Variation sale price. |
| Product Variations | Product variation regular price | DIMENSION | CURRENCY | Variation regular price. |
| Product Variations | Product variation date on sale from | DIMENSION | DATETIME | Start date of sale price, in the site's timezone. |
| Product Variations | Product variation date on sale from GMT | DIMENSION | DATETIME | Start date of sale price, as GMT. |
| Product Variations | Product variation date on sale to | DIMENSION | DATETIME | End data of sale price, in the site's timezone. |
| Product Variations | Product variation date on sale to GMT | DIMENSION | DATETIME | End data of sale price, as GMT. |
| Product Variations | Product variation on sale | DIMENSION | BOOLEAN | Shows if the product variation is on sale. |
| Product Variations | Product variation status | DIMENSION | STRING | Product variation status (post status). |
| Product Variations | Product variation purchasable | DIMENSION | BOOLEAN | Shows if the product variation can be bought. |
| Product Variations | Product variation virtual | DIMENSION | BOOLEAN | If the product variation is virtual. |
| Product Variations | Product variation downloadable | DIMENSION | BOOLEAN | If the product variation is downloadable. |
| Product Variations | Product variation download limit | DIMENSION | INTEGER | Amount of times the product variation can be downloaded. |
| Product Variations | Product variation download expiry | DIMENSION | INTEGER | Number of days that the customer has up to be able to download the product variation. |
| Product Variations | Product variation tax status | DIMENSION | STRING | Tax status. |
| Product Variations | Product variation tax class | DIMENSION | STRING | Tax class. |
| Product Variations | Product variation manage stock | DIMENSION | BOOLEAN | Shows if the product variation manages stock. |
| Product Variations | Product variation stock status | DIMENSION | STRING | Stock status. |
| Product Variations | Product variation backorders | DIMENSION | STRING | If managing stock, this controls if backorders are allowed. |
| Product Variations | Product variation backorders allowed | DIMENSION | BOOLEAN | Shows if backorders are allowed. |
| Product Variations | Product variation weight | DIMENSION | INTEGER | Product variation weight. |
| Product Variations | Product variation length | DIMENSION | INTEGER | Product variation length. |
| Product Variations | Product variation width | DIMENSION | INTEGER | Product variation width. |
| Product Variations | Product variation height | DIMENSION | INTEGER | Product variation height. |
| Product Variations | Product variation shipping class | DIMENSION | STRING | Shipping class slug. |
| Product Variations | Product variation shipping class id | DIMENSION | INTEGER | Shipping class id. |
| Product Variations | Product variation date created | DIMENSION | DATETIME | The date the product variation was created. |
| Product Variations | Product variation date created gmt | DIMENSION | DATETIME | The date the product variation was created. |
| Product Variations | Product variation date modified | DIMENSION | DATETIME | The date the product variation was last modified. |
| Product Variations | Product variation date modified gmt | DIMENSION | DATETIME | The date the product variation was last modified. |
| Product Variations | Product variation image id | DIMENSION | INTEGER | Product variation image id. |
| Product Variations | Product variation image URL | DIMENSION | IMAGE_URL | Product variation image URL. |
| Product Variations | Product variation image name | DIMENSION | STRING | Product variation image name. |
| Product Variations | Product variation image alt | DIMENSION | STRING | Product variation image alt. |
| Refunds | Refund ID | DIMENSION | INTEGER | Unique identifier for the resource. |
| Refunds | Refund date created | DIMENSION | DATETIME | The date the refund was created, in the site's timezone. |
| Refunds | Refund date created gmt | DIMENSION | DATETIME | The date the refund was created, as GMT. |
| Refunds | Refund reason | DIMENSION | STRING | The reason given for the refund. |
| Refunds | Refund refunded by | DIMENSION | STRING | Shows who created the refund. |
| Refunds | Refund refunded payment | DIMENSION | STRING | Shows the payment method used for the refund. |
| Refunds | Is API Refund | DIMENSION | BOOLEAN | Is refund created by API. |
| Product reviews | Product review ID | DIMENSION | INTEGER | Unique identifier for the resource. |
| Product reviews | Product review creation date | DIMENSION | DATETIME | The date the review was created, in the site's timezone. |
| Product reviews | Product review creation date GMT | DIMENSION | DATETIME | The date the review was created, as GMT. |
| Product reviews | Product review status | DIMENSION | STRING | Status of the review. Options: approved, hold, spam, unspam, trash and untrash. Defaults to approved. |
| Product reviews | Product reviewer name | DIMENSION | STRING | Reviewer name. |
| Product reviews | Product reviewer email | DIMENSION | STRING | Reviewer email. |
| Product reviews | Product review content | DIMENSION | STRING | The content of the review. |
| Product reviews | Product review verified | DIMENSION | BOOLEAN | Shows if the reviewer bought the product or not. |