ccdw_aggr_search_conversion
This table tracks conversion rates related to search queries. Records are included only when one or more orders resulted from the search query. To calculate the search conversion rate for a query, divide the num_orders from this table by the total number of searches for that query from ccdw_aggr_search.
| 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 | |
has_results | BOOLEAN | Boolean indicating if the search query yielded results. | No | |
num_searches | INTEGER | Total number of searches for this query. | No | |
num_visits | INTEGER | Total number of visits associated with this query. | No | |
num_orders | INTEGER | Total number of orders resulting from this query. | No | |
num_units | INTEGER | Total number of units sold resulting from this query. | No | |
std_revenue | NUMERIC | Total revenue in standard currency resulting from this query. | No |