---
schema_version: "1"
id: 9deae00e849dd79716c40526dd69b095228ae8faa791129d4e56c49b2462e065
title: ccdw_aggr_search
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_aggr_search.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_search.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 9e15315b81fe57bb6e91e9e6bb0e6884f922dc7c40b59e3312d848dd66950ed6
products:
  - Composable Storefront
  - Salesforce APIs
---
# ccdw_aggr_search

This table summarizes general search activity.

**note:** `ccdw_aggr_search` aggregates data directly from visits, while `ccdw_aggr_search_query` aggregates data specifically from search events. Because these tables track different events and methods, aggregating the `ccdw_aggr_search_query` table doesn't reproduce the same numerical results found in `ccdw_aggr_search`.

| Column Alias                   | Data Type | Key    | Description                                                                  | Index? |
| ------------------------------ | --------- | ------ | ---------------------------------------------------------------------------- | ------ |
| `search_date`                  | DATE      |        | Date of the search activity.                                                 | Yes    |
| `site_id`                      | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_site`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_site.md).                     | Yes    |
| `registered`                   | BOOLEAN   |        | Boolean indicating if the user was registered.                               | Yes    |
| `device_class_code`            | VARCHAR   | **FK** | Device class code from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md). | Yes    |
| `locale_code`                  | VARCHAR   | **FK** | Locale code from [`ccdw_dim_locale`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_locale.md).               | Yes    |
| `num_searches_with_results`    | INTEGER   |        | Number of searches that yielded results.                                     | No     |
| `num_searches_without_results` | INTEGER   |        | Number of searches that yielded no results.                                  | No     |
| `num_results`                  | INTEGER   |        | Total number of search results returned.                                     | No     |
| `num_clicks`                   | INTEGER   |        | Total number of clicks on search results.                                    | No     |

<!-- **Indices**: `search_date, registered, site_id,device_class_code,locale_code` -->