ccdw_aggr_visit_user_agent

This table summarizes visits by user agent details.

Column AliasData TypeKeyDescriptionIndex?
visit_dateDATEDate of the visit.No
site_idSMALLINTFKForeign key to ccdw_dim_site.No
registeredBOOLEANBoolean indicating if the visitor was registered.No
device_class_codeVARCHARFKForeign key to ccdw_dim_user_agent.No
locale_codeVARCHARFKForeign key to ccdw_dim_locale.No
ua_classVARCHARUser agent classification (from ccdw_dim_user_agent).No
ua_familyVARCHARUser agent family (from ccdw_dim_user_agent).No
ua_engineVARCHARUser agent engine (from ccdw_dim_user_agent).No
ua_osVARCHAROperating system (from ccdw_dim_user_agent).No
ua_os_familyVARCHAROperating system family (from ccdw_dim_user_agent).No
device_class_codeVARCHARDevice class code (from ccdw_dim_user_agent).No
device_market_nameVARCHARDevice market name (from ccdw_dim_user_agent).No
device_brandVARCHARDevice brand (from ccdw_dim_user_agent).No
num_visitsINTEGERTotal number of visits for this user agent.No