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_addressccdw_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_addressccdw_aggr_visit_robotccdw_aggr_controller_requestccdw_aggr_include_controller_requestccdw_aggr_ocapi_requestccdw_aggr_scapi_request
The following tables are constrained by IP Address Filters:
ccdw_aggr_search_conversionccdw_aggr_search_queryccdw_aggr_visit_referrerccdw_aggr_visit_checkoutccdw_aggr_visitccdw_aggr_visit_user_agent
| Aggregate Table Name | Description | Indices |
|---|---|---|
| ccdw_aggr_controller_request | Aggregates daily performance metrics for pipeline requests. | None listed |
| ccdw_aggr_include_controller_request | Aggregates daily performance metrics for include pipeline requests. | None listed |
| ccdw_aggr_impression | Aggregates product impression and click metrics. | None listed |
| ccdw_aggr_inventory_by_location | Aggregates daily inventory levels by individual location. | None listed |
| ccdw_aggr_inventory_by_location_group | Aggregates daily inventory levels by location group. | None listed |
| ccdw_aggr_ocapi_request | Aggregates daily performance metrics for OCAPI requests. | None listed |
| ccdw_aggr_payment_sales_summary | 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 | 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 | Aggregates overall product recommendation performance. | None listed |
| ccdw_aggr_product_recommendation_recommender | Aggregates product recommendation performance broken down by individual recommender. | None listed |
| ccdw_aggr_product_sales_summary | 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 | Summarizes promotion activation metrics. | None listed |
| ccdw_aggr_promotion_sales_summary | 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 | Summarizes customer registration activity. | registration_date, site_id,locale_code, device_class_code |
| ccdw_aggr_sales_summary | 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 | Aggregates daily performance metrics for SCAPI requests. | None listed |
| ccdw_aggr_search | Summarizes general search activity. <br><p>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.</p> |
search_date, registered, site_id,device_class_code,locale_code |
| ccdw_aggr_search_conversion | Tracks conversion rates related to search queries. | search_date,registered,site_id,device_class_code,locale_code,query |
| ccdw_aggr_search_query | Provides details on search queries and their outcomes. <br><p>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.</p> |
search_date,registered,site_id,device_class_code,locale_code,query |
| ccdw_aggr_source_code_activation | Summarizes the activation of source codes. | None listed |
| ccdw_aggr_source_code_sales | Summarizes sales attributed to source codes. | None listed |
| ccdw_aggr_visit | Summarizes website visit activity. | None listed |
| ccdw_aggr_visit_checkout | Summarizes visitor progression through checkout steps. | None listed |
| ccdw_aggr_visit_ip_address | Summarizes visits by IP address. | None listed |
| ccdw_aggr_visit_referrer | Summarizes visits by referrer information. | None listed |
| ccdw_aggr_visit_robot | Summarizes visits identified as coming from robots/crawlers. | None listed |
| ccdw_aggr_visit_user_agent | Summarizes visits by user agent details. | None listed |