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.
Note: This table is constrained by IP Address Filters configured in Business Manager.
| 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 |