Dataslayer Dimensions | Hub Account | hub_account |
|
| Dimension | |
Dataslayer Dimensions | Connector name | connector_name |
|
| Dimension | |
Time | Day | day |
|
| Dimension | |
Time | Datetime | datetime |
|
| Dimension | |
Time | Day of week(Sun-Sat) | day_of_week |
|
| Dimension | |
Time | Week(Sun-Sat) | week |
|
| Dimension | |
Time | Week(Mon-Sun) | week_iso |
|
| Dimension | |
Time | Month | month |
|
| Dimension | |
Time | Day of month | day_of_month |
|
| Dimension | |
Time | Year | year |
|
| Dimension | |
Time | Year-Week | year_week |
|
| Dimension | |
Time | Year & week(Mon-Sun) | year_week_iso |
|
| Dimension | |
Time | Year-Month | year_month |
|
| Dimension | |
Time | Year of week(Mon-Sun) | year_of_week_iso |
|
| Dimension | |
Website | Website URL | webiste_url |
|
| Dimension | |
Website | Website Name | webiste_name |
|
| Dimension | |
Customers | Customers id | customers_id |
|
| Dimension | |
Customers | Customers username | customers_username |
|
| Dimension | |
Customers | Customers first name | customers_first_name |
|
| Dimension | |
Customers | Customers last name | customers_last_name |
|
| Dimension | |
Customers | Customers date created | customer_date_created |
|
| Dimension | |
Customers | Customers date modified | customer_date_modified |
|
| Dimension | |
Customers | Customers email | customers_email |
|
| Dimension | |
Customers | Customers role | customers_role |
|
| Dimension | |
Customers | Customers is paying customer | customers_is_paying_customer |
|
| Dimension | |
Customers | Customers first name | customers_billing_first_name |
|
| Dimension | |
Customers | Customers last name | customers_billing_last_name |
|
| Dimension | |
Customers | Customers company | customers_billing_company |
|
| Dimension | |
Customers | Customers billing address_1 | customers_billing_address_1 |
|
| Dimension | |
Customers | Customers billing address_2 | customers_billing_address_2 |
|
| Dimension | |
Customers | Customers billing city | customers_billing_city |
|
| Dimension | |
Customers | Customers billing state | customers_billing_state |
|
| Dimension | |
Customers | Customers billing postcode | customers_billing_postcode |
|
| Dimension | |
Customers | Customers billing country | customers_billing_country |
|
| Dimension | |
Customers | Customers billing email | customers_billing_email |
|
| Dimension | |
Customers | Customers billing phone | customers_billing_phone |
|
| Dimension | |
Customers | Customers shipping first name | customers_shipping_first_name |
|
| Dimension | |
Customers | Customers shipping last name | customers_shipping_last_name |
|
| Dimension | |
Customers | Customers shipping company | customers_shipping_company |
|
| Dimension | |
Customers | Customers shipping address_1 | customers_shipping_address_1 |
|
| Dimension | |
Customers | Customers shipping address_2 | customers_shipping_address_2 |
|
| Dimension | |
Customers | Customers shipping city | customers_shipping_city |
|
| Dimension | |
Customers | Customers shipping state | customers_shipping_state |
|
| Dimension | |
Customers | Customers shipping postcode | customers_shipping_postcode |
|
| Dimension | |
Customers | Customers shipping country | customers_shipping_country |
|
| Dimension | |
Orders | Orders name | orders_id |
|
| Dimension | |
Orders | Orders key | orders_key |
|
| Dimension | |
Orders | Orders parent id | orders_parent_id |
|
| Dimension | |
Orders | Orders number | orders_number |
|
| Dimension | |
Orders | Orders created via | orders_created_via |
|
| Dimension | |
Orders | Orders status | orders_status |
|
| Dimension | |
Orders | Orders version | orders_version |
|
| Dimension | |
Orders | Orders currency | orders_currency |
|
| Dimension | |
Orders | Orders date created | orders_date_created |
|
| Dimension | |
Orders | Orders date date modified | orders_date_modified |
|
| Dimension | |
Orders | Orders discount total | orders_discount_total |
|
| Dimension | |
Orders | Orders discount tax | orders_discount_tax |
|
| Dimension | |
Orders | Orders shipping total | orders_shipping_total |
|
| Dimension | |
Orders | Orders shipping tax | orders_shipping_tax |
|
| Dimension | |
Orders | Orders cart tax | orders_cart_tax |
|
| Dimension | |
Orders | Orders total | orders_total |
|
| Dimension | |
Orders | Orders total tax | orders_total_tax |
|
| Dimension | |
Orders | Orders prices include tax | orders_prices_include_tax |
|
| Dimension | |
Orders | Orders payment method | orders_payment_method |
|
| Dimension | |
Orders | Orders payment method title | orders_payment_method_title |
|
| Dimension | |
Orders | Orders transaction id | orders_transaction_id |
|
| Dimension | |
Orders | Orders date paid | orders_date_paid |
|
| Dimension | |
Orders | Orders date completed | orders_date_completed |
|
| Dimension | |
Orders | Orders first name | orders_billing_first_name |
|
| Dimension | |
Orders | Orders last name | orders_billing_last_name |
|
| Dimension | |
Orders | Orders company | orders_billing_company |
|
| Dimension | |
Orders | Orders billing address_1 | orders_billing_address_1 |
|
| Dimension | |
Orders | Orders billing address_2 | orders_billing_address_2 |
|
| Dimension | |
Orders | Orders billing city | orders_billing_city |
|
| Dimension | |
Orders | Orders billing state | orders_billing_state |
|
| Dimension | |
Orders | Orders billing postcode | orders_billing_postcode |
|
| Dimension | |
Orders | Orders billing country | orders_billing_country |
|
| Dimension | |
Orders | Orders billing email | orders_billing_email |
|
| Dimension | |
Orders | Orders billing phone | orders_billing_phone |
|
| Dimension | |
Orders | Orders shipping first name | orders_shipping_first_name |
|
| Dimension | |
Orders | Orders shipping last name | orders_shipping_last_name |
|
| Dimension | |
Orders | Orders shipping company | orders_shipping_company |
|
| Dimension | |
Orders | Orders shipping address_1 | orders_shipping_address_1 |
|
| Dimension | |
Orders | Orders shipping address_2 | orders_shipping_address_2 |
|
| Dimension | |
Orders | Orders shipping city | orders_shipping_city |
|
| Dimension | |
Orders | Orders shipping state | orders_shipping_state |
|
| Dimension | |
Orders | Orders shipping postcode | orders_shipping_postcode |
|
| Dimension | |
Orders | Orders shipping country | orders_shipping_country |
|
| Dimension | |
Orders | Coupon Code | orders_coupon_code |
|
| Dimension | |
Orders | Coupon Description | orders_coupon_description |
|
| Dimension | |
Orders | Coupon Amount | orders_coupon_amount |
|
| Dimension | |
Products | Products id | products_id |
|
| Dimension | |
Products | Products name | products_name |
|
| Dimension | |
Products | Products slug | products_slug |
|
| Dimension | |
Products | Products permalink | products_permalink |
|
| Dimension | |
Products | Products date created | products_date_created |
|
| Dimension | |
Products | Products date date modified | products_date_modified |
|
| Dimension | |
Products | Products type | products_type |
|
| Dimension | |
Products | Products status | products_status |
|
| Dimension | |
Products | Products featured | products_featured |
|
| Dimension | |
Products | Products catalog visibility | products_catalog_visibility |
|
| Dimension | |
Products | Products description | products_description |
|
| Dimension | |
Products | Products short description | products_short_description |
|
| Dimension | |
Products | Products SKU | products_sku |
|
| Dimension | |
Products | Products regular price | products_regular_price |
|
| Dimension | |
Products | Products sale price | products_sale_price |
|
| Dimension | |
Products | Products date on sale from | products_date_on_sale_from |
|
| Dimension | |
Products | Products is on sale | products_on_sale |
|
| Dimension | |
Products | Products is purchasable | products_purchasable |
|
| Dimension | |
Products | Products total sales | products_total_sales |
|
| Dimension | |
Products | Products is virtual | products_virtual |
|
| Dimension | |
Products | Products is downloadable | products_downloadable |
|
| Dimension | |
Products | Products stock quantity | products_stock_quantity |
|
| Dimension | |
Products | Products stock status | products_stock_status |
|
| Dimension | |
Products | Products backorders | products_backorders |
|
| Dimension | |
Products | Products dimensions length | products_dimensions_length |
|
| Dimension | |
Products | Products dimensions width | products_dimensions_width |
|
| Dimension | |
Products | Products dimensions height | products_dimensions_height |
|
| Dimension | |
Products | Products tax class | products_tax_class |
|
| Dimension | |
Orders | Order total sales | order_total_price |
|
| Metric | The total price of an order. |
Orders | Order gross sales | order_gross_price |
|
| Metric | The total price of a order. |
Orders | Order net sales | order_net_price |
|
| Metric | |
Orders | Average order value (net) | avg_order_net_sale |
|
| Metric | |
Orders | Discounts | discounts |
|
| Metric | |
Orders | Order shipping | shipping |
|
| Metric | |
Orders | Order refunds | refunds |
|
| Metric | |
Orders | Coupon Amount | coupon_amount |
|
| Metric | |
Orders | Order total tax | total_tax |
|
| Metric | |
Orders | Customer total spent | customer_total_spent |
|
| Metric | Total amount spent by a consumer. |
Orders | Customer total count | customer_total_count |
|
| Metric | Number of orders by consumer. |
Orders | Number of orders | orders_count |
|
| Metric | |
Products | Product price | products_price |
|
| Metric | The price of a product. |
Products | Product order quantity | products_order_quantity |
|
| Metric | The quantity of product in a order. |
Products | Item total | line_item_total |
|
| Metric | The line total of product in a order. |