Usage:
Description:
The banner_tracks table contains tracking information for banner
advertisements summarized by tracking types for any given date.
Tracking types include impressions and clicks.
banner_tracks Table (#__banner_tracks)
| Field |
Type |
Nullable |
Default |
Key |
Extra |
Comments
|
| track_date |
DATE |
NOT NULL |
0 |
PK |
|
Tracking date.
|
| track_type |
INTEGER UNSIGNED |
NOT NULL |
|
PK |
|
Tracking type (impression or click).
|
| banner_id |
INTEGER UNSIGNED |
NOT NULL |
|
PK |
|
Banner ID.
|
| count |
INTEGER UNSIGNED |
NOT NULL |
|
|
|
Value for the tracking type.
|
Notes:
Indices
| Index Name |
Column(s) |
Unique?
|
| idx_track_date |
track_date |
No
|
| idx_track_type |
track_type |
No
|
| idx_banner_id |
banner_id |
No
|
- Default character set: utf8