Tables used in Example 1

The tables in Example 1 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

The dimension table in this example links to the base table through the CustID field.

The field names appear differently, depending on where you view or reference them. The following illustration shows the different ways the personalization fields used in the script are represented. Notice that email scripts refer to personalization fields using their display name.