Utilities: Administration: Server: Database: Add/remove Action Tag Columns: Add Column to Action Tag Table

The clickstreamdata_ table is used by ListManager to store all information about action events, such as purchases. It contains the fields it requires to track member movement on your Web site. It also has six fields, UnitPrice_, Quantity_, Points_, Stage_, ProductSku_ and OrderID_ that it does not require and that you may populate with the data you choose when you create Interest Tags or Purchase Tags.

If you add additional fields to the ListManager clickstreamdata_ table, you may track more information about members when you create tags.

Adding an Action Tag Column

1. Enter the Field Name. Valid field names should not have spaces.

2. Enter the Field Type. Field Type options are:

Number (Integer)

Numeric data only (no characters).

Date

A date field.

One, Two or Three Character String

A field that must contain one, two or three characters; the length is not variable.

Variable Length String

A field that may contain characters or numbers, and may vary in length up to the max specified.

3. Click Add.

4. Restart ListManager and the ListManager web server for your changes to be visible in the ListManager web interface. The change has already taken place in the database, but ListManager must be restarted to recognize it.

More

1. Utilities: Administration: Server: Database:Add/Remove Action Tag Columns

1. Utilities: Administration: Server: Database: Add Action Tag Columns

2. Utilities: Administration: Server: Database: Remove Action Tag Columns