Field group | Field | Type | Data type | Description |
---|---|---|---|---|
Sales | Total sales | METRIC | FLOAT | Total sales amount. |
Sales | Net sales | METRIC | FLOAT | Order Total - Order Tax - Order Shipping |
Sales | Gross sales | METRIC | FLOAT | Net Sales + Order Discounts + Order Refunds. |
Sales | Average sales | METRIC | FLOAT | 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 | FLOAT | Total tax amount. |
Sales | Total shipping | METRIC | FLOAT | Total shipping amount. |
Sales | Total refund | METRIC | FLOAT | Total refund amount. |
Sales | Total discount | METRIC | FLOAT | Total discount amount. |
Sales | Total discount tax | METRIC | FLOAT | Total discount tax amount. |
Coupons | Order maximum amount | METRIC | FLOAT | Maximum order amount allowed when using the coupon. |
Coupons | Order minimum amount | METRIC | FLOAT | Minimum order amount that needs to be in the cart before coupon applies. |
Coupons | Coupon amount of discount | METRIC | FLOAT | Amount of discount. This will be 0 for percentage based coupons. |
Orders | Order cart tax | METRIC | FLOAT | Total cart tax charged for an order. |
Orders | Order total tax shipping | METRIC | FLOAT | The amount of shipping tax collected for the order. |
Orders | Order discount tax (deprecated) | METRIC | FLOAT | Total discount tax charged for an order. |
Line Items | Line item subtotal | METRIC | FLOAT | Line subtotal (before discounts). |
Line Items | Line item subtotal tax | METRIC | FLOAT | Line subtotal tax (before discounts). |
Line Items | Line item total | METRIC | FLOAT | Line total (after discounts). |
Line Items | Line item total tax | METRIC | FLOAT | Line total tax (after discounts). |
Line Items | Line item refund total (deprecated) | METRIC | FLOAT | 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 | FLOAT | 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 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 | FLOAT | Tax total (not including shipping taxes). |
Orders | Order tax line shipping total | DIMENSION | FLOAT | 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 | FLOAT | Line total (after discounts). |
Orders | Order shipping line total tax | DIMENSION | FLOAT | 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 | FLOAT | Fee line total (after discounts). |
Orders | Order fee line total tax | DIMENSION | FLOAT | 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 |
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 | FLOAT | 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 | FLOAT | Current product price. |
Products | Product sale price | DIMENSION | FLOAT | Sale price of the product. |
Products | Product regular price | DIMENSION | FLOAT | 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 | FLOAT | Variation current price. |
Product Variations | Product variation sale price | DIMENSION | FLOAT | Variation sale price. |
Product Variations | Product variation regular price | DIMENSION | FLOAT | 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. |