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