ccdw_aggr_search_query

This table provides details on search queries and their outcomes.

Column AliasData TypeKeyDescriptionIndex?
search_dateDATEDate of the search activity.Yes
site_idSMALLINTFKForeign key to ccdw_dim_site.Yes
registeredBOOLEANBoolean indicating if the user was registered.Yes
device_class_codeVARCHARFKDevice class code from ccdw_dim_user_agent.Yes
locale_codeVARCHARFKLocale code from ccdw_dim_locale.Yes
queryVARCHARThe actual search query entered.Yes
num_searches_with_resultsINTEGERNumber of searches for this query that yielded results.No
num_searches_without_resultsINTEGERNumber of searches for this query that yielded no results.No
num_resultsINTEGERTotal number of search results returned for this query.No
num_visits_with_search_resultsINTEGERNumber of visits that included searches with results.No
num_visits_without_search_resultsINTEGERNumber of visits that included searches without results.No