product_primary
- Sylvain Paillard
Description
This table contains information about the performance of each product for each month.
All products (bought or not during the month) are considered.
Some columns provide information about the global values of the orders the product was included in (for example total_crncy_amt doesn’t not provide the product turnover, but the global turnover of all the orders the products was included in).
The month column is a date field always set with the first day of the month.
Granularity
one row per:
month
product
Columns
Field name | Type | Mode | Description |
product_id | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the product id |
day | DATE | NULLABLE | PRIMARY DIMENSION - first day of the month |
title_en | STRING | NULLABLE | title of the product in English |
title_de | STRING | NULLABLE | title of the product in German |
title_fr | STRING | NULLABLE | title of the product in French |
title_it | STRING | NULLABLE | title of the product in Italian |
category_1** | STRING | NULLABLE | 1st-level category id of the product |
category_2** | STRING | NULLABLE | 2nd-level category id of the product |
category_3** | STRING | NULLABLE | 3rd-level category id of the product |
category_4** | STRING | NULLABLE | 4th-level category id of the product |
category_5** | STRING | NULLABLE | 5th-level category id of the product |
exact_margin | FLOAT | NULLABLE | the product margin |
rounded_margin | FLOAT | NULLABLE | the rounded product margin (by default: 5% step) |
exact_price | FLOAT | NULLABLE | the product price (after discount) |
rounded_price | FLOAT | NULLABLE | the rounded product price (by default: 10.- step) |
product_owners | STRING | REPEATED | the product owners (not active by default, you can define filter rules to connect products to product owners (e.g.: suppliers) which you want to be able to select independently or in combination to the selection of any product or product property) |
orders | INTEGER | NULLABLE | the number of orders for this product that month |
order_products | INTEGER | NULLABLE | DEPRECATED - DO NOT USE |
order_qty* | INTEGER | NULLABLE | the quantity of any product in any orders including this product that month |
list_crncy_amt* | FLOAT | NULLABLE | the total value of the products list price (product price before discounts) in any orders including this product that month |
discount_crncy_amt* | FLOAT | NULLABLE | the total value of the products final price (product price after discounts) in any orders including this product that month |
total_crncy_amt* | FLOAT | NULLABLE | the total value of the orders (including delivery costs and reductions) in any orders including this product that month |
total_margin_crncy_amt* | FLOAT | NULLABLE | the total margin value of the orders (simple calculation summing the margin of each product and not applying any additional costs or reductions) in any orders including this product that month |
product_qty | FLOAT | NULLABLE | the total quantity of THE CURRENT PRODUCT ordered that month IMPORTANT - SPECIFIC TO THE CURRENT PRODUCT |
avg_product_list_crncy_amt | FLOAT | NULLABLE | the average value of THE CURRENT PRODUCT list price (product price before discounts) IMPORTANT - SPECIFIC TO THE CURRENT PRODUCT |
avg_product_discount_crncy_amt | FLOAT | NULLABLE | the average value of THE CURRENT PRODUCT final price (product price after discounts) IMPORTANT - SPECIFIC TO THE CURRENT PRODUCT |
display_requests | INTEGER | NULLABLE | DEPRECATED - DO NOT USE |
weighted_display_requests | FLOAT | NULLABLE | DEPRECATED - DO NOT USE |
display_total_product_order_num | INTEGER | NULLABLE | DEPRECATED - DO NOT USE |
web_orders | INTEGER | NULLABLE | the number of orders connected to web sessions where THIS PRODUCT was bought that month |
product_views | INTEGER | NULLABLE | the number of product views (visit to PDP page) on THIS PRODUCT that month |
baskets | INTEGER | NULLABLE | the number of time THIS PRODUCT was added to a basket that month |
product_revenue | FLOAT | NULLABLE | the revenue generated by THIS PRODUCT that month |
product_view_session_orders | INTEGER | NULLABLE | the number orders in session with at least one product view with this product (the order might not include this product) |
product_view_session_products | INTEGER | NULLABLE | the number of different products in session with at least one product view with this product (the order might not include this product) |
product_view_session_product_qty | INTEGER | NULLABLE | the quantity of products in session with at least one product view with this product (the order might not include this product) |
product_view_session_revenue | FLOAT | NULLABLE | the revenue generated in session with at least one product view with this product (the order might not include this product) |
first_orders | INTEGER | NULLABLE | the number of times this product was bought in the first order of a customer |
first_order_product_qty | INTEGER | NULLABLE | the quantity of THIS PRODUCT ordered when this product was bought in the first order of a customer |
first_order_revenue | FLOAT | NULLABLE | the revenue of THIS PRODUCT when this product was bought in the first order of a customer |
repeated_orders | INTEGER | NULLABLE | the number of time this product was bought not for the first time by a customer |
repeated_product_qty | INTEGER | NULLABLE | the quantity of THIS PRODUCT ordered when this product was bought not for the first time by a customer |
repeated_revenue | FLOAT | NULLABLE | the revenue of THIS PRODUCT when this product was bought not for the first time by a customer |
last_orders | INTEGER | NULLABLE | the number of time this product was in the last order of a customer (this customer has not made any purchase since) |
last_orders_short_time | INTEGER | NULLABLE | the number of time this product was in the last order of a customer and the customer didn't buy anything after for a a time (e.g. 3 month) |
last_orders_medium_time | INTEGER | NULLABLE | the number of time this product was in the last order of a customer and the customer didn't buy anything after for a a time (e.g. 6 month) |
last_orders_long_time | INTEGER | NULLABLE | the number of time this product was in the last order of a customer and the customer didn't buy anything after for a a time (e.g. 12 month) |
account | STRING | NULLABLE | the account name (typically same for all orders with the value ‘main’) |
parameters | RECORD | REPEATED | general structure of parameters and values (in this table, it will mainly contain the key order properties) |
parameters. name | STRING | NULLABLE | Name of the property |
parameters. value | STRING | NULLABLE | Value of the property |
copy from the customer_primary or order_product table, duplicated values for all the products of the same order
* arbitrary selection in case the product belongs in several categories, used the *_product_property table for multi-values on the categories