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