Cc Fact Promotion Activation DMO

This DMO contains promotion activation fact data from ccdw_fact_promotion_activation. Each record represents an instance where a promotion is activated, capturing visitor, customer, and site context along with temporal dimensions.

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

• UtcActivationDayId has a FOREIGNKEY relationship with the Cc Dim Date DMO Id field.
• UtcActivationTimeId has a FOREIGNKEY relationship with the Cc Dim Time DMO Id field.
• StandardActivationDayId has a FOREIGNKEY relationship with the Cc Dim Date DMO Id field.
• StandardActivationTimeId has a FOREIGNKEY relationship with the Cc Dim Time DMO Id field.
• StandardActivationTimeZoneId has a FOREIGNKEY relationship with the Cc Dim Time Zone 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.
• ActivationSiteId has a FOREIGNKEY relationship with the Cc Dim Site DMO Id field.
• CustomerId has a FOREIGNKEY relationship with the Cc Dim Customer DMO Id field.
• LocaleId has a FOREIGNKEY relationship with the Cc Dim Locale DMO Id field.
• UserAgentId has a FOREIGNKEY relationship with the Cc Dim User Agent DMO Id field.

• ActivationSiteId
• CampaignId
• cdp_sys_record_currency
• CustomerId
• DataSourceId
• DataSourceObjectId
• Id
• InternalOrganizationId
• IsAnonymous
• LocaleId
• PromotionId
• StandardActivationDayId
• StandardActivationTimeId
• StandardActivationTimestamp
• StandardActivationTimeZoneId
• UserAgentId
• UtcActivationDayId
• UtcActivationTimeId
• UtcActivationTimestamp
• UtcUpdateTimestamp
• VisitorIdentifier

• Field API Name: std__ActivationSiteId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_site where the promotion was activated.

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

• 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__CustomerId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_customer.

• 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__Id__c
• Data Type: DOUBLE
• Description: Unique identifier for a promotion activation event.

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

• Field API Name: std__IsAnonymous__c
• Data Type: BOOLEAN
• Description: Boolean indicating if the customer is anonymous.

• Field API Name: std__LocaleId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_locale.

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

• Field API Name: std__StandardActivationDayId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_date for the standard activation day.

• Field API Name: std__StandardActivationTimeId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_time for the standard activation time.

• Field API Name: std__StandardActivationTimestamp__c
• Data Type: DATETIME
• Description: Timestamp of the promotion activation, in standard time.

• Field API Name: std__StandardActivationTimeZoneId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_timezone for the standard activation time zone.

• Field API Name: std__UserAgentId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_user_agent.

• Field API Name: std__UtcActivationDayId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_date for the UTC activation day.

• Field API Name: std__UtcActivationTimeId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_time for the UTC activation time.

• Field API Name: std__UtcActivationTimestamp__c
• Data Type: DATETIME
• Description: UTC timestamp of the promotion activation.

• Field API Name: std__UtcUpdateTimestamp__c
• Data Type: DATETIME
• Description: Last modified UTC timestamp of this record.

• Field API Name: std__VisitorIdentifier__c
• Data Type: TEXT
• Description: Anonymous visitor ID.