Shopware 5.6.6 s_statistics_search
Search term statistics — tracks what customers search for and how often.
Columns
| Column | Type | Nullable | Additional |
|---|---|---|---|
| id | int(11) | NO | Primary Key, auto_increment |
| datum | datetime | NO | |
| searchterm | varchar(255) | NO | Index |
| results | int(11) | NO | |
| shop_id | int(11) | YES |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| PRIMARY | id | Yes |
| searchterm | searchterm | No |