Segments: New/Edit Segment: Advanced

The Segment Advanced Settings page allows you to set special parameters for your segment.

Join Other Tables

By default, ListManager only has access to its own database tables. To access data in other tables in your database, list the table names here, separated by commas. Carriage returns are not allowed in this field, to prevent errors resulting from not separating correctly with commas. The standard members table is already included, and need not be specified. The fields in the tables specified here will be available for mail merging.

Example:

demographics.customers, demographics.phonenumbers

Note that joining other tables here will not make their fields appear in the query builder in Segments: New Segment: Essentials; only fields in your members table will appear there.

Columns to Display

This setting is only relevant for testing purposes, to see what data is returned when you test your segment. If blank, only MemberID_ and EmailAddr_ will be displayed when you test your subset. These fields will always be retrieved and need not be specified. To specify additional fields, separate them with commas. Carriage returns are not allowed in this field, to prevent errors resulting from not separating correctly with commas.

Example:

domain_, fullname_, additional_

Sorting

Using an SQL "ORDER BY" clause, specify the order in which to return results.

Example:

members_.EmailAddr_ ASC

After SELECT

This setting is useful for those using ListManager with an Oracle database to tell it to use a specific index, thus improving performance. The Oracle optimizer will not always choose to use an index, even if one has been built, so this feature allows the name of the index to be added as a hint after the SQL for the subset.

More

1. Segments

2. Segments Main Page

3. Segments: New Segment

1. Segments: New/Edit Segment: Essentials

2. Segments: New Segment: Insert Clause: Text

3. Segments: New Segment: Insert Clause: Numeric

4. Segments: New Segment: Insert Clause: Date

5. Segments: New Segment: Insert Clause: Action

6. Segments: New Segment: Insert Clause: Clickthrough

7. Segments: New Segment: Insert Clause: Clickstream

8. Segments: New Segment: Insert Clause: Purchase

9. Segments: New Segment: Insert Clause: Interest

4. Segments: New/Edit Segment: Advanced

5. Segments: New/Edit Segment: Boundaries

6. Segments: New Triggered Segment

7. Joining to Another Table

8. SQL Guidelines (for advanced users)