ccdw_aggr_search_query
This table provides details on search queries and their outcomes.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
search_date | DATE | Date of the search activity. | Yes | |
site_id | SMALLINT | FK | Foreign key to ccdw_dim_site. | Yes |
registered | BOOLEAN | Boolean indicating if the user was registered. | Yes | |
device_class_code | VARCHAR | FK | Device class code from ccdw_dim_user_agent. | Yes |
locale_code | VARCHAR | FK | Locale code from ccdw_dim_locale. | Yes |
query | VARCHAR | The actual search query entered. | Yes | |
num_searches_with_results | INTEGER | Number of searches for this query that yielded results. | No | |
num_searches_without_results | INTEGER | Number of searches for this query that yielded no results. | No | |
num_results | INTEGER | Total number of search results returned for this query. | No | |
num_visits_with_search_results | INTEGER | Number of visits that included searches with results. | No | |
num_visits_without_search_results | INTEGER | Number of visits that included searches without results. | No |