Actions

Difference between revisions of "Tables/bannertrack"

From Joomla! Documentation

< Tables
(class="wikitable")
(2 intermediate revisions by one user not shown)
Line 7: Line 7:
 
Tracking types include impressions and clicks.
 
Tracking types include impressions and clicks.
  
{| border="1"
+
{| class="wikitable" border="1"
|+
+
|+ '''banner_tracks Table (#__banner_tracks)'''
|'''banner_tracks Table (#__banner_tracks)'''
+
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
 
| Field || Type || Nullable || Default || Key || Extra || Comments
 
| Field || Type || Nullable || Default || Key || Extra || Comments
Line 15: Line 14:
 
| track_date || DATE            || NOT NULL || 0 || PK ||  || Tracking date.
 
| track_date || DATE            || NOT NULL || 0 || PK ||  || Tracking date.
 
|-
 
|-
| track_type || INTEGER UNSIGNED || NOT NULL ||  || PK ||  || Tracking type
+
| track_type || INTEGER UNSIGNED || NOT NULL ||  || PK ||  || Tracking type (impression or click).
(impression or click).
+
 
|-
 
|-
 
| banner_id  || INTEGER UNSIGNED || NOT NULL ||  || PK ||  || Banner ID.
 
| banner_id  || INTEGER UNSIGNED || NOT NULL ||  || PK ||  || Banner ID.
Line 25: Line 23:
 
== Notes: ==
 
== Notes: ==
  
{| border="1"
+
{| class="wikitable" border="1"
|+
+
|+ '''Indices'''
|'''Indices'''
+
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
 
| Index Name || Column(s) ||Unique?
 
| Index Name || Column(s) ||Unique?

Revision as of 22:14, 24 September 2011

Usage:

  • Since:

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