---
schema_version: "1"
id: 2951d95027f34979550c67e5385b8bed6c0dddeb431314c8fda42f5c769bf752
title: ccdw_aggr_visit
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.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_visit.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 387d05ff9be483d25cdc0eaf63e01d8dacb15ff51246b6c6b6fcb2a6c47c26d6
products:
  - Composable Storefront
  - Salesforce APIs
---
# ccdw_aggr_visit

This table summarizes website visit activity.

> **Note:** This table is 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).                                    | Yes    |
| `registered`           | BOOLEAN   |        | Boolean indicating if the visitor was registered.                                           | Yes    |
| `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).                        | Yes    |
| `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).                                | Yes    |
| `search_state`         | VARCHAR   |        | State of search activity during the visit (for example, "with_results", "without_results"). | Yes    |
| `num_visits`           | INTEGER   |        | Total number of visits.                                                                     | No     |
| `fvivisit_duration`    | NUMERIC   |        | Sum of visit durations.                                                                     | No     |
| `num_converted_visits` | INTEGER   |        | Number of visits that resulted in a conversion.                                             | No     |
| `num_orders`           | INTEGER   |        | Number of orders placed during visits.                                                      | No     |
| `num_units`            | INTEGER   |        | Number of units ordered during visits.                                                      | No     |
| `std_revenue`          | NUMERIC   |        | Gross merchandise value in standard currency during visits.                                 | No     |
| `num_baskets`          | INTEGER   |        | Number of visits where items were added to the basket.                                      | No     |
| `num_checkouts`        | INTEGER   |        | Number of visits where checkout was initiated.                                              | No     |

<!-- **Indices**: None listed -->