Cc Aggr Product Rcmd Rcmdr DMO

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

Object Properties

Object API Name: CcAggrProductRcmdRcmdr_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 Id field.

Fields

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• InternalOrganizationId
• KQ_SiteId
• NumberOfCartAdds
• NumberOfClicks
• NumberOfOrders
• NumberOfProductsPurchased
• NumberOfProductViews
• NumberOfRecommenderViews
• RecommendationDate
• RecommenderName
• SiteId
• 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_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 products added to cart from this recommender.

NumberOfClicks

• Field API Name: NumberOfClicks__c
• Data Type: DOUBLE
• Description: Total number of clicks on recommended products from this recommender.

NumberOfOrders

• Field API Name: NumberOfOrders__c
• Data Type: DOUBLE
• Description: Total number of orders resulting from this recommender.

NumberOfProductsPurchased

• Field API Name: NumberOfProductsPurchased__c
• Data Type: DOUBLE
• Description: Total number of products purchased from this recommender.

NumberOfProductViews

• Field API Name: NumberOfProductViews__c
• Data Type: DOUBLE
• Description: Total number of product views from this recommender.

NumberOfRecommenderViews

• Field API Name: NumberOfRecommenderViews__c
• Data Type: DOUBLE
• Description: Total number of times this recommender was viewed.

RecommendationDate

• Field API Name: RecommendationDate__c
• Data Type: DATEONLY
• Description: Date of the recommendation event.

RecommenderName

• Field API Name: RecommenderName__c
• Data Type: TEXT
• Description: Name of the specific recommender.

SiteId

• Field API Name: SiteId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_site.

StandardAttributedRevenue

• Field API Name: StandardAttributedRevenue__c
• Data Type: DOUBLE
• Description: Total attributed revenue in standard currency from this recommender.