Oracle Marketing Segmentation Guide > Designing Marketing List Formats >

About Designing Marketing List Formats

List Formats define the layout of files that you can use for a variety of purposes. Use the List Format Designer to select content from a subject area (list catalog), using filters that you add to the list format definition.

The List Format Designer can generate list formats for several purposes. These formats are listed in the left selection pane:

• List Export Formats. Typically used for campaign distribution lists, such as direct mail, exports to external vendors, exports to other IT applications, and other channels. Typically, list formats contain the name, customer profile, address, email address, and other information for the members of a segment or segment tree cell.
• Email Server Formats. Used to export the relevant data for each member of an email campaign to the Siebel Email Marketing Server.
• Campaign Load Formats. Used to load the members of a segment or a segment tree cell into the campaign history table in the Siebel transactional database through EAI.
• Data Load Formats. Used to import any type of data into the Siebel transactional database through EAI.
• Saved Result Set Formats. Used to save result sets from segments and segment trees.

In the list formats page you can either open an existing, saved list format or create a new list format. To create a new list format, select a subject area in the list on the right. You specify the type of list later on using a control in the Options tab.

Existing list formats are in the List Format pane to the left. The formats are in folders, and the formats are organized first by format (List Export, Email Server, Campaign Load, and so on) and then by personal and shared formats. Examples: My List Export Formats, Shared List Export Formats.

You can combine data from more than one subject area by using the set operation capability in the List Format designer. You can combine data from more than one data source into a single file. For example, you can combine the list of segment members from your data mart with some additional customers that may only exist in your Siebel transactional database. To obtain descriptions for commonly used terms, see Frequently Used Terms for Marketing List Formats.

The List Format Designer supports a variety of options to format the content including column sorting and casing for each column. For a list of formatting options, see Column Properties Formatting Options.

Navigating to the List Format Designer

Access to the List Format Designer start page depends on your product license key and privileges. You open List Format Designer in one of the following ways:

• In the Siebel Marketing application, navigate to Administration - Marketing screen > List Formats.
• If you log in to the Marketing module directly, click the Marketing screen tab and then click Create a List Format.

Frequently Used Terms for Marketing List Formats

Table 3 defines frequently used terms for list formats.