# Aggregate Tables
Aggregate tables store pre-calculated summarized data, optimized for reporting and analysis.
## Robot Traffic and IP Address Filtering
### Tables Containing Robot Traffic
The following tables include robot traffic:
- `ccdw_aggr_visit_ip_address`
- `ccdw_aggr_visit_robot`
All other aggregate tables don't include robot traffic.
### IP Address Filter Impact
When you configure IP Address Filters in Business Manager, the filter applies only to customer-focused analytics tables. The following tables are **not** constrained by IP Address Filters:
- `ccdw_aggr_visit_ip_address`
- `ccdw_aggr_visit_robot`
- `ccdw_aggr_controller_request`
- `ccdw_aggr_include_controller_request`
- `ccdw_aggr_ocapi_request`
- `ccdw_aggr_scapi_request`
The following tables **are** constrained by IP Address Filters:
- `ccdw_aggr_search_conversion`
- `ccdw_aggr_search_query`
- `ccdw_aggr_visit_referrer`
- `ccdw_aggr_visit_checkout`
- `ccdw_aggr_visit`
- `ccdw_aggr_visit_user_agent`
| Aggregate Table Name | Description | Indices |
| -------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| [ccdw_aggr_controller_request](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_controller_request.md) | Aggregates daily performance metrics for pipeline requests. | None listed |
| [ccdw_aggr_include_controller_request](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_include_controller_request.md) | Aggregates daily performance metrics for include pipeline requests. | None listed |
| [ccdw_aggr_impression](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_impression.md) | Aggregates product impression and click metrics. | None listed |
| [ccdw_aggr_inventory_by_location](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_inventory_by_location.md) | Aggregates daily inventory levels by individual location. | None listed |
| [ccdw_aggr_inventory_by_location_group](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_inventory_by_location_group.md) | Aggregates daily inventory levels by location group. | None listed |
| [ccdw_aggr_ocapi_request](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_ocapi_request.md) | Aggregates daily performance metrics for OCAPI requests. | None listed |
| [ccdw_aggr_payment_sales_summary](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_payment_sales_summary.md) | Summarizes payment-related sales metrics by various dimensions. | `submit_date,business_channel_id,registered,site_id,first_time_buyer,device_class_code, locale_code,payment_method_id` |
| [ccdw_aggr_product_cobuy](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_product_cobuy.md) | Identifies products that are frequently bought together. | `submit_date, product_one_id, product_two_id,registered, nsite_id,first_time_buyer,device_class_code,locale_code` |
| [ccdw_aggr_product_recommendation](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_product_recommendation.md) | Aggregates overall product recommendation performance. | None listed |
| [ccdw_aggr_product_recommendation_recommender](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_product_recommendation_recommender.md) | Aggregates product recommendation performance broken down by individual recommender. | None listed |
| [ccdw_aggr_product_sales_summary](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_product_sales_summary.md) | Summarizes product sales metrics by various dimensions. | `submit_date, business_channel_id,registered,site_id,first_time_buyer,sku_id, product_id, device_class_code,locale_code` |
| [ccdw_aggr_promotion_activation](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_promotion_activation.md) | Summarizes promotion activation metrics. | None listed |
| [ccdw_aggr_promotion_sales_summary](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_promotion_sales_summary.md) | Summarizes sales attributed to promotions by various dimensions. | `submit_date, business_channel_id,registered,site_id,first_time_buyer,promotion_id,campaign_id,coupon_id, device_class_code, locale_code` |
| [ccdw_aggr_registration](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_registration.md) | Summarizes customer registration activity. | `registration_date, site_id,locale_code, device_class_code` |
| [ccdw_aggr_sales_summary](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_sales_summary.md) | Provides a daily summary of sales metrics aggregated by various dimensions. | `submit_date, business_channel_id,registered,site_id,first_time_buyer,device_class_code, locale_code` |
| [ccdw_aggr_scapi_request](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_scapi_request.md) | Aggregates daily performance metrics for SCAPI requests. | None listed |
| [ccdw_aggr_search](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_search.md) | 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 does not reproduce the same numerical results found in `ccdw_aggr_search`.
| `search_date, registered, site_id,device_class_code,locale_code` |
| [ccdw_aggr_search_conversion](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_search_conversion.md) | Tracks conversion rates related to search queries. | `search_date,registered,site_id,device_class_code,locale_code,query` |
| [ccdw_aggr_search_query](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_search_query.md) | Provides details on search queries and their outcomes.
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 does not reproduce the same numerical results found in `ccdw_aggr_search`.
| `search_date,registered,site_id,device_class_code,locale_code,query` |
| [ccdw_aggr_source_code_activation](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_source_code_activation.md) | Summarizes the activation of source codes. | None listed |
| [ccdw_aggr_source_code_sales](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_source_code_sales.md) | Summarizes sales attributed to source codes. | None listed |
| [ccdw_aggr_visit](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_visit.md) | Summarizes website visit activity. | None listed |
| [ccdw_aggr_visit_checkout](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_visit_checkout.md) | Summarizes visitor progression through checkout steps. | None listed |
| [ccdw_aggr_visit_ip_address](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_visit_ip_address.md) | Summarizes visits by IP address. | None listed |
| [ccdw_aggr_visit_referrer](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_visit_referrer.md) | Summarizes visits by referrer information. | None listed |
| [ccdw_aggr_visit_robot](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_visit_robot.md) | Summarizes visits identified as coming from robots/crawlers. | None listed |
| [ccdw_aggr_visit_user_agent](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_aggr_visit_user_agent.md) | Summarizes visits by user agent details. | None listed |