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 |