ccdw_aggr_detail_product_recommendation_recommender
Product-level recommendation performance by recommender algorithm for detailed analysis of which products perform best with specific recommendation engines.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
recommendation_date | DATE | PK | The date the product recommendations were shown. | Yes |
site_id | SMALLINT | FK | Foreign key to ccdw_dim_site for site-specific analysis. | Yes |
recommender_name | VARCHAR | PK | Name of the recommendation algorithm for algorithm-specific analysis. | Yes |
product_id | INTEGER | FK | Foreign key to ccdw_dim_product for product-specific analysis. | Yes |
num_recommender_views | INTEGER | Total number of recommendation widget impressions for this product and algorithm. | No | |
num_product_views | INTEGER | Total number of views of this specific product within recommendations. | No | |
num_clicks | INTEGER | Total number of clicks on this product from this recommendation algorithm. | No | |
num_cart_adds | INTEGER | Total number of add-to-cart actions for this product from recommendations. | No | |
num_products_purchased | INTEGER | Total number of times this product was purchased from recommendations. | No | |
num_orders | INTEGER | Total number of orders containing this product from recommendations. | No | |
std_attributed_revenue | NUMERIC | Total revenue attributed to this product and recommendation algorithm in standard currency. | No |