ccdw_aggr_visit_robot

This table summarizes visits identified as coming from robots/crawlers.

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