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. |
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. |
No |
locale_code |
VARCHAR | FK | Foreign key to ccdw_dim_locale. |
No |
ua_class |
VARCHAR | User agent classification (from ccdw_dim_user_agent). |
No | |
ua_family |
VARCHAR | User agent family (from ccdw_dim_user_agent). |
No | |
ua_engine |
VARCHAR | User agent engine (from ccdw_dim_user_agent). |
No | |
ua_os |
VARCHAR | Operating system (from ccdw_dim_user_agent). |
No | |
ua_os_family |
VARCHAR | Operating system family (from ccdw_dim_user_agent). |
No | |
device_class_code |
VARCHAR | Device class code (from ccdw_dim_user_agent). |
No | |
device_market_name |
VARCHAR | Device market name (from ccdw_dim_user_agent). |
No | |
device_brand |
VARCHAR | Device brand (from ccdw_dim_user_agent). |
No | |
num_visits |
INTEGER | Total number of visits from this robot. | No |