ccdw_aggr_visit_user_agent
This table summarizes visits by user agent details.
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. | 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 for this user agent. | No |