ccdw_aggr_daily_detail_product_recommendation_recommender
This table provides detailed daily product recommendation performance by product.
Column Alias | Data Type | Key | Description | Index? |
---|---|---|---|---|
recommendation_date | DATE | Date of the recommendation event. | No | |
site_id | SMALLINT | FK | Foreign key to ccdw_dim_site . | No |
recommender_name | VARCHAR | Name of the specific recommender. | No | |
product_id | INTEGER | FK | Foreign key to ccdw_dim_product for the recommended product. | No |
num_recommender_views | INTEGER | Total number of times this recommender was viewed for this product. | No | |
num_product_views | INTEGER | Total number of product views for this product from this recommender. | No | |
num_clicks | INTEGER | Total number of clicks on this recommended product. | No | |
num_cart_adds | INTEGER | Total number of times this product was added to cart from this recommender. | No | |
num_products_purchased | INTEGER | Total number of times this product was purchased from this recommender. | No | |
num_orders | INTEGER | Total number of orders for this product from this recommender. | No | |
std_attributed_revenue | NUMERIC | Total attributed revenue in standard currency for this product from this recommender. | No |