Bookshelf Home | Contents | Index | Search | PDF

Siebel Marketing Guide > External Data Mapping > Setting Up Target Group Segment Tables and Joins >

Mapping the Analytic Adapter Tables to the Marketing Repository Server

---

The following two Analytic Adapter tables are used by Siebel Marketing when creating, loading, and using target group segments. The Analytic Adapter tables are system tables that reside in the Siebel transaction database and store the target group lists that result from the creation of a segment through Siebel Analytics.

S_DD_TRGT_GRP. Contains the name of the target group after you create it.
X_DD_TRGTGRPMBR. Contains the list of contacts and account ids obtained from Siebel Analytics and stored in the Marketing Repository after performing a load.

Each targeting level of your customer hierarchy requires separate references to the X_DD_TRGTGRPMBR and S_DD_TRGTGRP tables so that lists of Accounts, Households, Contacts, etc. are kept separate. During the load process, the application makes sure that each X_DD_TRGTGRPMBR reference is automatically given a search specification that includes only rows for that customer targeting level.

For additional information about mapping tables and creating table joins, see the related topics in this chapter.

You must perform all the steps in the following procedure (unless a step is specifically stated to be optional) for successful data retrieval:

To map the Analytic Adapter tables to the Marketing Repository

From the application-level menu, choose View > Site Map > Marketing Administration > External Data Mapping.
In the Servers list, select Marketing Repository and scroll down to the Tables list.
In the Tables list, locate each alias of the S_DD_TRGT_GRP and X_DD_TRGTGRPMBR analytic adapter tables.
In the Tables list, create a new record for each alias and map the alias using guidelines in Table 22.
Map the X_DD_TRGTGRPMBR table for each customer hierarchy level that will be used for target group segments.

For example, if you are using an Account - Contact hierarchy, you will have two levels, Account and Contact. You would map two aliases of the X_DD_TRGTGRPMBR table and assign easily identifiable reference names such as, Target Group Accounts and Target Group Consumers.

Map the S_DD_TRGT_GRP table once for each alias of the X_DD_TRGTGRPMBR table (for each customer hierarchy level).

This mapping allows you to create different branches on the Target Group attribute family for each customer hierarchy. It also makes sure that the extract process uses the correct join path.

Give each alias of S_DD_TRGT_GRP an easily identifiable reference name such as Account Group, Household Group, and Consumer Group.

Click the Tables view tab, scroll down to the Fields list.
In the Fields list, in the Reference Name column, edit the NAME field for each alias of the S_DD_TRGT_GRP table.
In the Reference Name field, change NAME to include the table reference name using the syntax "[table reference name]"."NAME".

In our example, this would be "Account Group"."NAME". The double quotes around the table reference name and field name are required.

NOTE:  The field width for each name field can be a maximum of 50 characters or data retrieval will fail.

Select the check box in the Data Retrieval Enabled field to enable this column for data retrieval.
Create a start point join (a join with no parent table) to each alias of the S_DD_TRGT_GRP table.
Perform data retrieval for NAME fields in each alias of the S_DD_TRGT_GRP table.
In the Fields list, select the NAME field.
Click Enable Data Retrieval to make sure that the attribute joins are created by the Marketing Server.

Bookshelf Home | Contents | Index | Search | PDF