Cc Aggr Detail Product Rcmd Rcmdr DMO

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

Object API Name: CcAggrDetailProductRcmdRcmdr_std__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
• KQ_ProductId
• KQ_SiteId
• NumberOfCartAdds
• NumberOfClicks
• NumberOfOrders
• NumberOfProductsPurchased
• NumberOfProductViews
• NumberOfRecommenderViews
• ProductId
• RecommendationDate
• RecommenderName
• SiteId
• StandardAttributedRevenue

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

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

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

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

• Field API Name: KQ_ProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductId

• Field API Name: KQ_SiteId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SiteId

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

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

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

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

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

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

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

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

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

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

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