ccdw_aggr_product_recommendation
This table aggregates overall product recommendation performance.
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 |
num_recommender_views | INTEGER | Total number of times recommenders were viewed. | No | |
num_product_views | INTEGER | Total number of product views from recommenders. | No | |
num_clicks | INTEGER | Total number of clicks on recommended products. | No | |
num_cart_adds | INTEGER | Total number of products added to cart from recommenders. | No | |
num_products_purchased | INTEGER | Total number of products purchased from recommenders. | No | |
num_orders | INTEGER | Total number of orders resulting from recommenders. | No | |
std_attributed_revenue | NUMERIC | Total attributed revenue in standard currency from recommenders. | No |