--- schema_version: "1" id: 95722e5b7c34f26ac71220ca07747e9b5967e1ec6368d039df0065d185ac07a1 title: ccdw_aggr_visit_robot 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_visit_robot.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_visit_robot.html source_site: developer.salesforce.com content_type: documentation content_hash: 4683b1970ef37b8cdb100952449781b9c305188154b8208995d9eab231132c09 products: - Composable Storefront - Salesforce APIs --- # ccdw_aggr_visit_robot This table summarizes visits identified as coming from robots/crawlers. > **Note:** This table contains robot traffic and is not constrained by IP Address Filters configured in Business Manager. | Column Alias | Data Type | Key | Description | Index? | | -------------------- | --------- | ------ | -------------------------------------------------------------------------------------- | ------ | | `visit_date` | DATE | | Date of the visit. | 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 | | `registered` | BOOLEAN | | Boolean indicating if the visitor was registered (likely false for robots). | No | | `device_class_code` | VARCHAR | **FK** | Foreign key to [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md). | No | | `locale_code` | VARCHAR | **FK** | Foreign key to [`ccdw_dim_locale`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_locale.md). | No | | `ua_class` | VARCHAR | | User agent classification (from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md)). | No | | `ua_family` | VARCHAR | | User agent family (from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md)). | No | | `ua_engine` | VARCHAR | | User agent engine (from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md)). | No | | `ua_os` | VARCHAR | | Operating system (from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md)). | No | | `ua_os_family` | VARCHAR | | Operating system family (from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md)). | No | | `device_class_code` | VARCHAR | | 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)). | No | | `device_market_name` | VARCHAR | | Device market name (from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md)). | No | | `device_brand` | VARCHAR | | Device brand (from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md)). | No | | `num_visits` | INTEGER | | Total number of visits from this robot. | No |