Cc Aggr Product Co Buy DMO

This DMO identifies products that are frequently bought together.

Object API Name: CcAggrProductCoBuy_std__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
• KQ_NaturalSiteIdentifier
• KQ_ProductOneId
• KQ_ProductTwoId
• LocaleCode
• NaturalSiteIdentifier
• OrderChannel
• ProductOneId
• ProductTwoId
• StandardCoBuyRevenue
• SubmitDate

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

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

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

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

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

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

• Field API Name: KQ_NaturalSiteIdentifier__c
• Data Type: TEXT
• Description: Key Qualifier system field for NaturalSiteIdentifier

• Field API Name: KQ_ProductOneId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductOneId

• Field API Name: KQ_ProductTwoId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductTwoId

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

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

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

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

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

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

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