ccdw_fact_promotion_activation

This table records instances where promotions are activated.

Column Alias	Data Type	Key	Description	Index?
`promotion_activation_id`	BIGINT	PK	Unique identifier for a promotion activation event.	Yes
`utc_activation_timestamp`	TIMESTAMP		UTC timestamp of the promotion activation.	Yes
`utc_activation_day_id`	SMALLINT	FK	Foreign key to `ccdw_dim_date` for the UTC activation day.	Yes
`utc_activation_time_id`	SMALLINT	FK	Foreign key to `ccdw_dim_time` for the UTC activation time.	No
`utc_update_timestamp`	TIMESTAMP		Last modified UTC timestamp of this record.	Yes
`std_activation_timestamp`	TIMESTAMP		Timestamp of the promotion activation, in standard time.	No
`std_activation_day_id`	SMALLINT	FK	Foreign key to `ccdw_dim_date` for the standard activation day.	Yes
`std_activation_time_id`	SMALLINT	FK	Foreign key to `ccdw_dim_time` for the standard activation time.	No
`std_activation_timezone_id`	SMALLINT	FK	Foreign key to `ccdw_dim_timezone` for the standard activation time zone.	No
`promotion_id`	INTEGER	FK	Foreign key to `ccdw_dim_promotion`.	Yes
`campaign_id`	INTEGER	FK	Foreign key to `ccdw_dim_campaign`.	Yes
`activation_site_id`	SMALLINT	FK	Foreign key to `ccdw_dim_site` where the promotion was activated.	Yes
`visitor_id`	VARCHAR(100)		Unique identifier for a visitor session. This ID persists across sessions and is associated with an anonymous tracking cookie (for example, dwanonymous).	No
`customer_id`	BIGINT	FK	Foreign key to `ccdw_dim_customer`. For unregistered buyers, this value is `1` and can't distinguish one unregistered buyer from another.	Yes
`is_anonymous`	BOOLEAN		Indicates whether customer is anonymous or registered.	No
`locale_id`	SMALLINT	FK	Foreign key to `ccdw_dim_locale`.	Yes
`user_agent_id`	INTEGER	FK	Foreign key to `ccdw_dim_user_agent`.	Yes