---
schema_version: "1"
id: 17b83e5c4250d6f626abb8d35cfa05f48ce05b04e43ad57ce2cbbbbc15d8a99a
title: ccdw_aggr_include_controller_request
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_include_controller_request.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_include_controller_request.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: c3828f87be6ca4aec049dd2b96bb18361db225b12dbfb4f4f782a38aab087b3e
products:
  - Composable Storefront
  - Salesforce APIs
---
# ccdw_aggr_include_controller_request

This table aggregates daily performance metrics for include pipeline requests.

> **Note:** This table is not constrained by IP Address Filters configured in Business Manager.

| Column Alias           | Data Type | Key    | Description                                              | Index? |
| ---------------------- | --------- | ------ | -------------------------------------------------------- | ------ |
| `request_date`         | DATE      |        | Date of the request.                                     | No     |
| `controller_name`      | VARCHAR   |        | Name of the include pipeline/controller.                 | No     |
| `main_controller_name` | VARCHAR   |        | Name of the main pipeline/controller.                    | No     |
| `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). | No     |
| `cache_behavior`       | VARCHAR   |        | Cache behavior of the request.                           | No     |
| `status_code`          | SMALLINT  |        | HTTP status code of the response.                        | No     |
| `num_requests`         | INTEGER   |        | Total number of requests.                                | No     |
| `response_time`        | NUMERIC   |        | Average response time for the requests.                  | No     |

<!-- **Indices**: None listed -->
