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. |
Yes |
registered |
BOOLEAN | Boolean indicating if the visitor was registered. | Yes | |
device_class_code |
VARCHAR | FK | Foreign key to ccdw_dim_user_agent. |
Yes |
locale_code |
VARCHAR | FK | Foreign key to ccdw_dim_locale. |
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 |