---
schema_version: "1"
id: 7466b493b652cf5ce052dacdff7627ebc23e3c3ca483477051ca1935d91140c7
title: Cc Aggr Detail Product Rcmd Rcmdr DMO
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-ccaggrdetailproductrcmdrcmdrdmo-dmo.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccaggrdetailproductrcmdrcmdrdmo-dmo.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 98224f412f93070b3a3d43052accd7320d543cab977aa42cf6b2d63d843d54e5
products:
  - Data 360 DMO and Mapping Guide
  - Data 360 Developer Documentation
---
# Cc Aggr Detail Product Rcmd Rcmdr DMO

This DMO aggregates detailed product recommendation performance metrics by date, site, recommender, and product.

## Object Properties

**Object API Name:** `CcAggrDetailProductRcmdRcmdr_std__dlm`  
**Category:** Unassigned  
**Availability:** Available in 260 and later versions  
**Primary Key Field:** SiteId  

## Relationships

- **SiteId** has a FOREIGNKEY relationship with the [Cc Dim Site DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimsitedmo-dmo.md) `Id` field.
- **ProductId** has a FOREIGNKEY relationship with the [Cc Dim Product DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimproductdmo-dmo.md) `Id` field.


## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_ProductId](#kq_productid)
- [KQ_SiteId](#kq_siteid)
- [NumberOfCartAdds](#numberofcartadds)
- [NumberOfClicks](#numberofclicks)
- [NumberOfOrders](#numberoforders)
- [NumberOfProductsPurchased](#numberofproductspurchased)
- [NumberOfProductViews](#numberofproductviews)
- [NumberOfRecommenderViews](#numberofrecommenderviews)
- [ProductId](#productid)
- [RecommendationDate](#recommendationdate)
- [RecommenderName](#recommendername)
- [SiteId](#siteid)
- [StandardAttributedRevenue](#standardattributedrevenue)

### cdp_sys_record_currency

- **Field API Name:** `cdp_sys_record_currency__c`
- **Data Type:** TEXT
- **Description:** System-generated metadata field that stores a 3-letter ISO currency code.

### DataSourceId

- **Field API Name:** `DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### InternalOrganizationId

- **Field API Name:** `InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### KQ_ProductId

- **Field API Name:** `KQ_ProductId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ProductId

### KQ_SiteId

- **Field API Name:** `KQ_SiteId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for SiteId

### NumberOfCartAdds

- **Field API Name:** `NumberOfCartAdds__c`
- **Data Type:** DOUBLE
- **Description:** Total number of add-to-cart actions for this product from recommendations.

### NumberOfClicks

- **Field API Name:** `NumberOfClicks__c`
- **Data Type:** DOUBLE
- **Description:** Total number of clicks on this product from this recommendation algorithm.

### NumberOfOrders

- **Field API Name:** `NumberOfOrders__c`
- **Data Type:** DOUBLE
- **Description:** Total number of orders containing this product from recommendations.

### NumberOfProductsPurchased

- **Field API Name:** `NumberOfProductsPurchased__c`
- **Data Type:** DOUBLE
- **Description:** Total number of times this product was purchased from recommendations.

### NumberOfProductViews

- **Field API Name:** `NumberOfProductViews__c`
- **Data Type:** DOUBLE
- **Description:** Total number of views of this specific product within recommendations.

### NumberOfRecommenderViews

- **Field API Name:** `NumberOfRecommenderViews__c`
- **Data Type:** DOUBLE
- **Description:** Total number of recommendation widget impressions for this product and algorithm.

### ProductId

- **Field API Name:** `ProductId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_product for product-specific analysis.

### RecommendationDate

- **Field API Name:** `RecommendationDate__c`
- **Data Type:** DATEONLY
- **Description:** The date the product recommendations were shown.

### RecommenderName

- **Field API Name:** `RecommenderName__c`
- **Data Type:** TEXT
- **Description:** Name of the recommendation algorithm for algorithm-specific analysis.

### SiteId

- **Field API Name:** `SiteId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_site for site-specific analysis.

### StandardAttributedRevenue

- **Field API Name:** `StandardAttributedRevenue__c`
- **Data Type:** DOUBLE
- **Description:** Total revenue attributed to this product and recommendation algorithm in standard currency.
