Cc Aggr Product Co Buy DMO

This DMO identifies products that are frequently bought together.

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

• ProductOneId has a FOREIGNKEY relationship with the Cc Dim Product DMO Id field.
• ProductTwoId has a FOREIGNKEY relationship with the Cc Dim Product DMO Id field.

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DeviceClassCode
• FrequencyCount
• InternalOrganizationId
• IsFirstTimeBuyer
• IsRegistered
• IsShopperAgent
• LocaleCode
• NaturalSiteIdentifier
• OrderChannel
• ProductOneId
• ProductTwoId
• StandardCoBuyRevenue
• SubmitDate

• 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__DeviceClassCode__c
• Data Type: TEXT
• Description: Code for the device classification.

• Field API Name: std__FrequencyCount__c
• Data Type: DOUBLE
• Description: Number of times these two products were co-bought.

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

• Field API Name: std__IsFirstTimeBuyer__c
• Data Type: BOOLEAN
• Description: Boolean indicating if the customer was a first-time buyer.

• Field API Name: std__IsRegistered__c
• Data Type: BOOLEAN
• Description: Boolean indicating if the customer was registered.

• Field API Name: std__IsShopperAgent__c
• Data Type: BOOLEAN
• Description: Boolean indicating whether the activity was generated by a Shopper Agent.

• Field API Name: std__LocaleCode__c
• Data Type: TEXT
• Description: Abbreviated locale code.

• Field API Name: std__NaturalSiteIdentifier__c
• Data Type: TEXT
• Description: Normalized site ID (from ccdw_dim_site).

• Field API Name: std__OrderChannel__c
• Data Type: TEXT
• Description: Order channel (from ccdw_dim_business_channel).

• Field API Name: std__ProductOneId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_product for the first product.

• Field API Name: std__ProductTwoId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_product for the second product.

• Field API Name: std__StandardCoBuyRevenue__c
• Data Type: DOUBLE
• Description: Total revenue generated from co-bought products in standard currency.

• Field API Name: std__SubmitDate__c
• Data Type: DATETIME
• Description: Date of the co-buy event.