ccdw_aggr_product_recommendation_recommender
This table aggregates product recommendation performance broken down by individual recommender.
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 | |
num_recommender_views | INTEGER | Total number of times this recommender was viewed. | No | |
num_product_views | INTEGER | Total number of product views from this recommender. | No | |
num_clicks | INTEGER | Total number of clicks on recommended products from this recommender. | No | |
num_cart_adds | INTEGER | Total number of products added to cart from this recommender. | No | |
num_products_purchased | INTEGER | Total number of products purchased from this recommender. | No | |
num_orders | INTEGER | Total number of orders resulting from this recommender. | No | |
std_attributed_revenue | NUMERIC | Total attributed revenue in standard currency from this recommender. | No |