# 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_site.md). | 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     |