Cc Aggr Promotion Co Use DMO

This DMO identifies promotions that are frequently used together.

Object Properties

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

Relationships

• PromotionOneId has a FOREIGNKEY relationship with the Cc Dim Promotion DMO Id field.
• PromotionTwoId has a FOREIGNKEY relationship with the Cc Dim Promotion DMO Id field.

Fields

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DeviceClassCode
• FrequencyCount
• InternalOrganizationId
• IsFirstTimeBuyer
• IsRegistered
• IsShopperAgent
• KQ_NaturalSiteIdentifier
• KQ_PromotionOneId
• KQ_PromotionTwoId
• LocaleCode
• NaturalSiteIdentifier
• OrderChannel
• PromotionOneClass
• PromotionOneId
• PromotionTwoClass
• PromotionTwoId
• SubmitDate

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.

DeviceClassCode

• Field API Name: DeviceClassCode__c
• Data Type: TEXT
• Description: Code for the device classification.

FrequencyCount

• Field API Name: FrequencyCount__c
• Data Type: DOUBLE
• Description: Number of times these two promotions were used together.

InternalOrganizationId

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

IsFirstTimeBuyer

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

IsRegistered

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

IsShopperAgent

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

KQ_NaturalSiteIdentifier

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

KQ_PromotionOneId

• Field API Name: KQ_PromotionOneId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PromotionOneId

KQ_PromotionTwoId

• Field API Name: KQ_PromotionTwoId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PromotionTwoId

LocaleCode

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

NaturalSiteIdentifier

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

OrderChannel

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

PromotionOneClass

• Field API Name: PromotionOneClass__c
• Data Type: TEXT
• Description: Class of the first promotion.

PromotionOneId

• Field API Name: PromotionOneId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_promotion for the first promotion.

PromotionTwoClass

• Field API Name: PromotionTwoClass__c
• Data Type: TEXT
• Description: Class of the second promotion.

PromotionTwoId

• Field API Name: PromotionTwoId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_promotion for the second promotion.

SubmitDate

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