Creating the list tables

Procedure

  1. Add any additional columns for your audience levels in the listmanager.sql table creation script.

    The listmanager.sql file is in the tools\admin\db\db_type directory under your Collaborate installation, where db_type is the database you are using, sqlserver, oracle, db2, Netezza, or Teradata.

  2. Run the listmanager.sql script to create the required tables.

    Note the following.

    • The script creates the tables in the customer database.
    • You can also add columns to the tables based on your particular requirements for data filtering. For example, you can add a column to filter by region.