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

The clickstreamdata_ table is used by Aurea List Manager 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 Aurea List Manager 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 Aurea List Manager and the Aurea List Manager web server for your changes to be visible in the Aurea List Manager web interface. The change has already taken place in the database, but Aurea List Manager must be restarted to recognize it.