Tables used in Example 2

The tables in Example 2 represent tables that exist in your Campaign installation.

This example assumes that the following tables exist in the Campaign schema.

  • Customers a base record table that contains customer demographic data
  • CustTransact a dimension table that contains transaction data for current customers
  • CustPrefProd a dimension table that contains product details for products and product categories for which the customer has previously indicated a preference.

The dimension tables link to the base table through the CustID field.

The following illustration shows the different ways the personalization fields used in the script are represented.