ccdw_fact_customer_list_snapshot

This table provides snapshots of customer list metrics over time.

Column Alias	Data Type	Key	Description	Index?
`customer_list_record_id (PK)`	BIGINT	PK	Unique identifier for a customer list snapshot record.	No
`ncustomer_list_id`	VARCHAR		Normalized customer list identifier.	No
`utc_record_timestamp`	TIMESTAMP		UTC timestamp of the snapshot.	No
`utc_record_day_id`	SMALLINT	FK	Foreign key to `ccdw_dim_date` for the UTC record day.	No
`utc_record_time_id`	SMALLINT	FK	Foreign key to `ccdw_dim_time` for the UTC record time.	No
`utc_update_timestamp`	TIMESTAMP		Last modified UTC timestamp of this record.	Yes
`std_record_timestamp`	TIMESTAMP		Timestamp of the snapshot, in standard time.	No
`std_record_day_id`	SMALLINT	FK	Foreign key to `ccdw_dim_date` for the standard record day.	No
`std_record_time_id`	SMALLINT	FK	Foreign key to `ccdw_dim_time` for the standard record time.	No
`std_record_timezone_id`	SMALLINT	FK	Foreign key to `ccdw_dim_timezone` for the standard record time zone.	No
`site_id`	SMALLINT	FK	Foreign key to `ccdw_dim_site`.	No
`num_customers`	INTEGER		Total number of registered customers at the time of snapshot.	No