# 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`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md). | Yes    |
| `locale_code`          | VARCHAR   | **FK** | Foreign key to [`ccdw_dim_locale`](/docs/commerce/b2c-commerce/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     |