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 Properties

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

Relationships

• 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.

Fields

• ActivationSiteId
• CampaignId
• cdp_sys_record_currency
• CustomerId
• DataSourceId
• DataSourceObjectId
• Id
• InternalOrganizationId
• IsAnonymous
• KQ_ActivationSiteId
• KQ_CampaignId
• KQ_CustomerId
• KQ_Id
• KQ_LocaleId
• KQ_PromotionId
• KQ_StandardActivationDayId
• KQ_StandardActivationTimeId
• KQ_StandardActivationTimeZoneId
• KQ_UserAgentId
• KQ_UtcActivationDayId
• KQ_UtcActivationTimeId
• LocaleId
• PromotionId
• StandardActivationDayId
• StandardActivationTimeId
• StandardActivationTimestamp
• StandardActivationTimeZoneId
• UserAgentId
• UtcActivationDayId
• UtcActivationTimeId
• UtcActivationTimestamp
• UtcUpdateTimestamp
• VisitorIdentifier

ActivationSiteId

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

CampaignId

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

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.

CustomerId

• Field API Name: CustomerId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_customer.

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.

Id

• Field API Name: Id__c
• Data Type: DOUBLE
• Description: Unique identifier for a promotion activation event.

InternalOrganizationId

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

IsAnonymous

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

KQ_ActivationSiteId

• Field API Name: KQ_ActivationSiteId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ActivationSiteId

KQ_CampaignId

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

KQ_CustomerId

• Field API Name: KQ_CustomerId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CustomerId

KQ_Id

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

KQ_LocaleId

• Field API Name: KQ_LocaleId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LocaleId

KQ_PromotionId

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

KQ_StandardActivationDayId

• Field API Name: KQ_StandardActivationDayId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardActivationDayId

KQ_StandardActivationTimeId

• Field API Name: KQ_StandardActivationTimeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardActivationTimeId

KQ_StandardActivationTimeZoneId

• Field API Name: KQ_StandardActivationTimeZoneId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardActivationTimeZoneId

KQ_UserAgentId

• Field API Name: KQ_UserAgentId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UserAgentId

KQ_UtcActivationDayId

• Field API Name: KQ_UtcActivationDayId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UtcActivationDayId

KQ_UtcActivationTimeId

• Field API Name: KQ_UtcActivationTimeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UtcActivationTimeId

LocaleId

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

PromotionId

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

StandardActivationDayId

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

StandardActivationTimeId

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

StandardActivationTimestamp

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

StandardActivationTimeZoneId

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

UserAgentId

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

UtcActivationDayId

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

UtcActivationTimeId

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

UtcActivationTimestamp

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

UtcUpdateTimestamp

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

VisitorIdentifier

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