Cc Aggr Promotion Activation DMO

This DMO provides aggregate promotion activation metrics by site, promotion, campaign, and visitor attributes.

Object API Name: CcAggrPromotionActivation_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.
• PromotionId has a FOREIGNKEY relationship with the Cc Dim Promotion DMO Id field.
• CampaignId has a FOREIGNKEY relationship with the Cc Dim Campaign DMO Id field.

• ActivationDate
• CampaignId
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DeviceClassCode
• InternalOrganizationId
• IsRegistered
• KQ_CampaignId
• KQ_PromotionId
• KQ_SiteId
• LocaleCode
• NumberOfActivations
• NumberOfVisits
• PromotionId
• SiteId

• Field API Name: ActivationDate__c
• Data Type: DATEONLY
• Description: Date of promotion activation.

• Field API Name: CampaignId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_campaign.

• 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: InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

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

• Field API Name: KQ_CampaignId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CampaignId

• Field API Name: KQ_PromotionId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PromotionId

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

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

• Field API Name: NumberOfActivations__c
• Data Type: DOUBLE
• Description: Total number of promotion activations.

• Field API Name: NumberOfVisits__c
• Data Type: DOUBLE
• Description: Number of visits associated with the promotion activation.

• Field API Name: PromotionId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_promotion.

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