Reporting schemas for extra audience levels or partitions

You can create reporting schemas for extra audience levels or partitions by using following information.

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.