Cc Aggr Detail Product Rcmd Rcmdr DMO

This DMO aggregates detailed product recommendation performance metrics by date, site, recommender, and product.

Object API Name: std__CcAggrDetailProductRcmdRcmdrDmo__dlm
Category: Unassigned
Availability: Available in 260 and later versions
Primary Key Field: SiteId

• SiteId has a FOREIGNKEY relationship with the Cc Dim Site DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Cc Dim Product DMO Id field.

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• InternalOrganizationId
• NumberOfCartAdds
• NumberOfClicks
• NumberOfOrders
• NumberOfProductsPurchased
• NumberOfProductViews
• NumberOfRecommenderViews
• ProductId
• RecommendationDate
• RecommenderName
• SiteId
• StandardAttributedRevenue

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: std__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__NumberOfCartAdds__c
• Data Type: DOUBLE
• Description: Total number of add-to-cart actions for this product from recommendations.

• Field API Name: std__NumberOfClicks__c
• Data Type: DOUBLE
• Description: Total number of clicks on this product from this recommendation algorithm.

• Field API Name: std__NumberOfOrders__c
• Data Type: DOUBLE
• Description: Total number of orders containing this product from recommendations.

• Field API Name: std__NumberOfProductsPurchased__c
• Data Type: DOUBLE
• Description: Total number of times this product was purchased from recommendations.

• Field API Name: std__NumberOfProductViews__c
• Data Type: DOUBLE
• Description: Total number of views of this specific product within recommendations.

• Field API Name: std__NumberOfRecommenderViews__c
• Data Type: DOUBLE
• Description: Total number of recommendation widget impressions for this product and algorithm.

• Field API Name: std__ProductId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_product for product-specific analysis.

• Field API Name: std__RecommendationDate__c
• Data Type: DATEONLY
• Description: The date the product recommendations were shown.

• Field API Name: std__RecommenderName__c
• Data Type: TEXT
• Description: Name of the recommendation algorithm for algorithm-specific analysis.

• Field API Name: std__SiteId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_site for site-specific analysis.

• Field API Name: std__StandardAttributedRevenue__c
• Data Type: DOUBLE
• Description: Total revenue attributed to this product and recommendation algorithm in standard currency.