ccdw_fact_promotion_activation

This table records instances where promotions are activated.

Column AliasData TypeKeyDescriptionIndex?
promotion_activation_idBIGINTPKUnique identifier for a promotion activation event.Yes
utc_activation_timestampTIMESTAMPUTC timestamp of the promotion activation.Yes
utc_activation_day_idSMALLINTFKForeign key to ccdw_dim_date for the UTC activation day.Yes
utc_activation_time_idSMALLINTFKForeign key to ccdw_dim_time for the UTC activation time.No
utc_update_timestampTIMESTAMPLast modified UTC timestamp of this record.Yes
std_activation_timestampTIMESTAMPTimestamp of the promotion activation, in standard time.No
std_activation_day_idSMALLINTFKForeign key to ccdw_dim_date for the standard activation day.Yes
std_activation_time_idSMALLINTFKForeign key to ccdw_dim_time for the standard activation time.No
std_activation_timezone_idSMALLINTFKForeign key to ccdw_dim_timezone for the standard activation time zone.No
promotion_idINTEGERFKForeign key to ccdw_dim_promotion.Yes
campaign_idINTEGERFKForeign key to ccdw_dim_campaign.Yes
activation_site_idSMALLINTFKForeign key to ccdw_dim_site where the promotion was activated.Yes
visitor_idVARCHAR(100)Anonymous visitor ID.No
customer_idBIGINTFKForeign key to ccdw_dim_customer.Yes
locale_idSMALLINTFKForeign key to ccdw_dim_locale.Yes
user_agent_idINTEGERFKForeign key to ccdw_dim_user_agent.Yes