# 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_product.md) 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_site.md).                       | No     |
| `registered`        | BOOLEAN   |        | Boolean indicating if the user was registered.                                                                   | No     |
| `device_class_code` | VARCHAR   | **FK** | Device class code from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md).   | No     |
| `locale_code`       | VARCHAR   | **FK** | Locale code from [`ccdw_dim_locale`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_locale.md).                 | No     |
| `num_impressions`   | INTEGER   |        | Total number of product impressions.                                                                             | No     |
| `num_clicks`        | INTEGER   |        | Total number of clicks on this product.                                                                          | No     |