Shopware 5.6.5 s_emarketing_banners_statistics
Click/view statistics for advertising banners.
Columns
| Column | Type | Nullable | Additional |
|---|---|---|---|
| id | int(11) | NO | Primary Key, auto_increment |
| bannerID | int(11) | NO | Index |
| display_date | date | NO | |
| clicks | int(11) | NO | |
| views | int(11) | NO |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| bannerID | bannerID | No |
| display_date | bannerID,display_date | Yes |
| PRIMARY | id | Yes |