Aggregate Tables
Aggregate tables store pre-calculated summarized data, optimized for reporting and analysis.
| Aggregate Table Name | Description | Indices |
|---|---|---|
| ccdw_aggr_controller_request | Aggregates daily performance metrics for pipeline requests. | None listed |
| ccdw_aggr_daily_detail_product_recommendation_recommender | Provides detailed daily product recommendation performance by product. | None listed |
| ccdw_aggr_include_controller_request | Aggregates daily performance metrics for include pipeline requests. | 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_couse | Identifies promotions that are frequently used together. | submit_date, promotion_one_id, promotion_two_id, registered, nsite_id, first_time_buyer,device_class_code,locale_code |
| 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. | 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. | 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 |