--- schema_version: "1" id: a239cdebe14dcc5f6d9283c2642ec33c358a9999acc10cc0a7430b9da8681cf4 title: ccdw_aggr_product_recommendation collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_aggr_product_recommendation.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_product_recommendation.html source_site: developer.salesforce.com content_type: documentation content_hash: 59bd0d85f10355a5308365c5b1f05ce8d290789914847b16d8509a141379661b products: - Composable Storefront - Salesforce APIs --- # 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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/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 |