Creating reporting schemas for additional audience levels or partitions

You are likely to create additional reporting schemas for the following reasons:

You want to report on more than one audience level. Perhaps you plan to create reports that present data for more than one audience level, or add filters that prompt users to specify one of several audience levels. Therefore, you need schemas that point to an additional set of contact and response history table.

You are configuring reporting for multiple partitions and you need to implement different schema customizations for each set of partition system tables

Before you begin, determine the following information:

Which reporting schemas to create.

For Campaign: Campaign Offer Response Breakout, Offer Performance, Campaign Performance, Offer Contact Status Breakout, and Campaign Custom Attributes

For Interact: Interact Performance

The names of the following tables for this audience level.

For Campaign: contact history, detailed contact history, and response history tables

For Interact: detailed contact history and response history tables

The name of the audience key column (or columns) for this audience level

Pick a short 2 or 3 letter code to represent the name of the audience level. You use this code when you specify the table or view names for the new reporting schema.

Complete the steps in the following procedures as appropriate for your reporting goals.