The Products data source contains information about all of your products.

Dimensions

1. Type – Product type. Options: simple, grouped, external, variable
2. Name – Product name
3. Category – Categories of the product
4. SKU – Unique identifier
5. Visible – Catalog visibility. Default is visible. Options: visible (Catalog and search), catalog (Only in catalog), search (Only in search) and hidden (Hidden from all)
6. Status – Product status. Options: draft, pending, private and publish
7. Featured – Featured product. Default is false
8. Created – The date the product was created, as GMT
9. Backorders – If managing stock, this controls if backorders are allowed. If enabled, stock quantity can go below 0. Default is no. Options are: no (Do not allow), notify (Allow, but notify customer), and yes (Allow)
10. Backordered – Shows if a product is on backorder (if the product have the stock_quantity negative)
11. Backorders Allowed – Shows if backorders are allowed
12. Updated – The date the product was last modified, as GMT
13. Virtual – If the product is virtual. Virtual products are intangible and aren’t shipped. Default is false
14. Tax Class – Tax class
15. Sold Individually – Allow one item to be bought in a single order. Default is false
16. Manage Stock – Stock management at product level. Default is false
17. In Stock – Controls whether or not the product is listed as “in stock” or “out of stock” on the frontend. Default is true
18. Sale – Shows if the product is on sale
19. Shipping Class – Shipping class slug. Shipping classes are used by certain shipping methods to group similar products
20. Shipping Taxable – Shows whether or not the product shipping is taxable
21. Shipping Required – Shows if the product need to be shipped
22. Download Type – Download type. Options: ‘standard’ (Standard Product), application (Application/Software) and music (Music)
23. Purchasable – Shows if the product can be bought
24. Downloadable – If the product is downloadable. Downloadable products give access to a file upon purchase. Default is false
25. Tax Status – Tax status. Default is taxable. Options: taxable, shipping (Shipping only) and none
26. Reviews Allowed – Allow reviews. Default is true

Measures

1. Price – Current product price. This is setted from regular_price and sale_price
2. Total Sales – Amount of sales
3. Total Amount – The total amount in orders
4. Regular Price – Product regular price
5. Sale Price – Product sale price
6. Variations Count – Number of variations
7. Average Rating – Reviews average rating
8. Ratings Count – Amount of reviews that the product have
9. Stock Quantity – Stock quantity. If is a variable product this value will be used to control stock for all variations, unless you define stock at variation level
10. Products Count – Products Count

Templates

• Average Rating by Products (last 30 days)
• Sales by Product Category
• Top 10 Products by Total Sales

The Orders data source contains information about all of your orders.

Dimensions

1. Number – Order number
2. Status – Order status. Options: pending, processing, on-hold, completed, cancelled, refunded and failed
3. Customer – User First Name, Last Name and Email  who owns the order
4. Currency – Currency the order was created with, in ISO format, e.g USD. Default is the current store currency
5. Created – The date the order was created, as GMT
6. Updated – The date the order was last modified, as GMT
7. Completed – The date the order was completed, as GMT
8. Payment Methods – Payment method
9. Shipping Country – Name of the shipping country
10. Billing Country – Name of the billing country
11. Paid – The date the order has been paid, as GMT
12. Version – Version of WooCommerce when the order was made
13. Prices Include Tax – Shows if the prices included tax during checkout

Measures

1. Amount – Grand total
2. Shipping Amount – Total shipping amount for the order
3. Tax Amount – Sum of all taxes
4. Shipping Tax – Total shipping tax amount for the order
5. Cart Tax – Sum of line item taxes only
6. Subtotal – Line subtotal (before discounts)
7. Subtotal Tax – Line subtotal tax (before discounts)
8. Discount Amount – Total discount amount for the order
9. Discount Tax – Total discount tax amount for the order
10. Quantity – Quantity ordered
11. Coupons Count – Number of coupons applied to the order
12. Refunds Count – Number of returns
13. Refund Items Count – Number of products returned
14. Refund Amount – Total amount refunded for the order
15. Orders Count – Orders Count

Templates

• Cumulative Gross Revenue over the last 30 days
• Number of Orders by Customer (last 30 days)
• Total Order Value by Status (last 30 days)

The Customers data source contains information about all of your customers.

Dimensions

1. Name – User First Name, Last Name and Email
2. Created – The date the customer was created, as GMT
3. Shipping Country – Name of the shipping country
4. Billing Country – Name of the billing country

Measures

1. Orders Count – Quantity of orders made by the customer
2. Total Spent – Total amount spent
3. Customers Count – Customers Count

Templates

• Number of Customers Created over the last 30 days
• Number of Orders by Country (last 30 days)
• Top 10 Customers by Total Amount Spent
• Total Sales by Country (last 30 days)

The Coupons data source contains information about all of your coupons.

Dimensions

1. Code – Coupon code
2. Type – Determines the type of discount that will be applied. Options: fixed_cart, percent, fixed_product and percent_product. Default: fixed_cart
3. Created – The date the coupon was created, as GMT
4. Updated – The date the coupon was last modified, as GMT
5. Individual Use – Whether coupon can only be used individually
6. Usage Limit – How many times the coupon can be used
7. Expired – UTC DateTime when the coupon expires
8. Free Shipping – Define if can be applied for free shipping
9. Exclude Sale Items – Define if should not apply when have sale items

Measures

1. Amount – The amount of discount
2. Products Count – Number of products the coupon can be used on
3. Exclude Products Count – Number of products the coupon cannot be used on
4. Limit Usage To Items – Max number of items in the cart the coupon can be applied to
5. Usage Count – Number of times the coupon has been used already
6. Coupons Count – Coupons Count

The Sales data source contains information about all of your orders and their composition.

Dimensions

1. Order Number – Order number
2. Order Status – Order status. Options: pending, processing, on-hold, completed, cancelled, refunded and failed
3. Customer – User First Name, Last Name and Email who owns the order
4. Shipping City – Name of the shipping city
5. Billing City – Name of the billing city
6. Billing State – Name of the billing state
7. Shipping State – Name of the shipping state
8. Billing Company – Name of the billing company
9. Shipping Company – Name of the shipping company
10. Customer Username – The user name of the customer
11. Customer Created At – The date the customer was created, as GMT
12. Customer Updated At – The date the customer was last modified, as GMT
13. Paying Customer – Is the customer a paying customer
14. Currency – Currency the order was created with, in ISO format, e.g USD. Default is the current store currency
15. Order Created At – The date the order was created, as GMT
16. Order Updated At – The date the order was last modified, as GMT
17. Order Completed – The date the order was completed, as GMT
18. Payment Methods – Payment method
19. Shipping Country – Name of the shipping country
20. Billing Country – Name of the billing country
21. Order Paid At – The date the order has been paid, as GMT
22. Order Paid – Define if the order is paid. Default is false
23. Order Version – Version of WooCommerce when the order was made
24. Prices Include Tax – Shows if the prices included tax during checkout
25. Product Type – Product type. Options: simple, grouped, external, variable
26. Product Name – Product name
27. Product Category – Categories of the product
28. Product SKU – Unique identifier
29. Product Visible – Catalog visibility. Default is visible. Options: visible (Catalog and search), catalog (Only in catalog), search (Only in search) and hidden (Hidden from all)
30. Product Status – Product status. Options: draft, pending, private and publish
31. Product Featured – Featured product. Default is false
32. Product Created At – The date the product was created, as GMT
33. Product Updated At – The date the product was last modified, as GMT
34. Product Backorders – If managing stock, this controls if backorders are allowed. If enabled, stock quantity can go below 0. Default is no. Options are: no (Do not allow), notify (Allow, but notify customer), and yes (Allow)
35. Product Backordered – Shows if a product is on backorder (if the product have the stock_quantity negative)
36. Product Backorders Allowed – Shows if backorders are allowed
37. Product Updated At – The date the product was last modified, as GMT
38. Product Virtual – If the product is virtual. Virtual products are intangible and aren’t shipped. Default is false
39. Product Tax Class – Tax class
40. Product Sold Individually – Allow one item to be bought in a single order. Default is false
41. Product Manage Stock – Stock management at product level. Default is false
42. Product In Stock – Controls whether or not the product is listed as “in stock” or “out of stock” on the frontend. Default is true
43. Product On Sale – Shows if the product is on sale
44. Product Shipping Class – Shipping class slug. Shipping classes are used by certain shipping methods to group similar products
45. Product Shipping Taxable – Shows whether or not the product shipping is taxable
46. Product Shipping Required – Shows if the product need to be shipped
47. Product Download Type – Download type. Options: ‘standard’ (Standard Product), application (Application/Software) and music (Music)
48. Product Purchasable – Shows if the product can be bought
49. Product Downloadable – If the product is downloadable. Downloadable products give access to a file upon purchase. Default is false
50. Product Tax Status – Tax status. Default is taxable. Options: taxable, shipping (Shipping only) and none
51. Product Reviews Allowed – Allow reviews. Default is true
52. Product Tags – The list of tags associated with this product

Measures

1. Quantity – Quantity ordered
2. Subtotal – Line subtotal (before discounts)
3. Subtotal Tax – Line subtotal tax (before discounts)
4. Total – Line total (after discounts)
5. Price – Product price
6. Variations Count – Number of variations
7. Average Rating – Reviews average rating
8. Ratings Count – Amount of reviews that the product have
9. Stock Quantity – Stock quantity. If is a variable product this value will be used to control stock for all variations, unless you define stock at variation level
10. Average Rating – Reviews average rating
11. Ratings Count – Amount of reviews that the product have
12. Regular Price – Product regular price
13. Sale Price – Product sale price
14. Product Count – Product Count