ccdw_aggr_visit

This table summarizes website visit activity.

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
`search_state`	VARCHAR		State of search activity during the visit (for example, "with_results", "without_results").	No
`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