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 |