ccdw_aggr_impression

This table aggregates product impression and click metrics.

Column Alias	Data Type	Key	Description	Index?
`impression_date`	DATE		Date of the impression activity.	No
`product_id`	INTEGER	FK	Foreign key to `ccdw_dim_product` for the product.	No
`nproduct_id`	VARCHAR		Natural key of the product in the source system.	No
`impression_type`	VARCHAR		Type of product impression.	No
`site_id`	SMALLINT	FK	Foreign key to `ccdw_dim_site`.	No
`registered`	BOOLEAN		Boolean indicating if the user was registered.	No
`device_class_code`	VARCHAR	FK	Device class code from `ccdw_dim_user_agent`.	No
`locale_code`	VARCHAR	FK	Locale code from `ccdw_dim_locale`.	No
`num_impressions`	INTEGER		Total number of product impressions.	No
`num_clicks`	INTEGER		Total number of clicks on this product.	No