Bookshelf Home | Contents | Index | Search | PDF

Siebel Marketing Guide > Creating Measures >

Defining List Measures

---

List measures are mappings to database fields such as name, address, state, postal code, customer key, and so on.

These measures are used as columns in output file layouts for distribution lists and to help you define Campaign Load Mappings, which specify the data on each campaign contact that is recorded in the Siebel transaction database. Unlike bound measures, list measures do not support calculations, so they cannot be used in other measure definitions.

Use either the All Measures list or click the List view tab, to create list measures by mapping to a table and field in your data warehouse. For example, you might define a list measure called First Name and map it to a field called FNAME in a table called CUST_INFO. When you define your list formats and generate a campaign distribution list that uses the First Name field as part of the format, the process retrieves your customers' first names from the CUST_INFO.FNAME field.

When you create a list measure from the All Measures list, set the measure Type to List. The measure type is automatically set to list when you create the measure from the List tab view.

The List view tab displays defined list measures and output file layouts that use the measure. To view details of the output file layout, drill down on the name link. For more information, see Working With Output File Layouts.

Use the following procedure to create list measures that are used for output file layouts for distribution lists and Campaign Load Mappings for external data mapping.

To create a list measure

From the application-level menu, choose View > Site Map > Marketing Administration > Measures.
In the All Measures list, select the custom measure, and drill down on the measure name.
Click the List view tab.
In the List measures list, create a new record.
Complete the necessary fields.
Type a Name and Description for the list measure.

The name field has a maximum length of 50 characters.

Click the Table select button.
In the Pick Tables dialog box, choose the table that contains the field that will be referenced by list measure and click OK.

For example, you might choose a table called CUSTOMERS.

Click the Fields select button.
In the Pick Fields dialog box, choose the field from the list of fields in the table and click OK.

For example, you might choose the reference field TELEPHONE in the CUSTOMER table.

Repeat this procedure to create list measures for every table and field that contain information you might use in a contact list.

Typical list measures might include the following:

Customer ID
Title (Mr., Mrs., Ms., Dr., and so on)
Name
Address (including street, city, state, and ZIP or postal code)
Telephone number
Email address
Account information (balances, service level, service bundle, and so on)

NOTE:  You will need to create list measures for each unique identifier that corresponds to each targeting level (Key 1, Key 2, and so on). For more information, see About Customer Hierarchies.

Bookshelf Home | Contents | Index | Search | PDF