Overview

When you are testing the output of a Segment you've created in ListManager and you export the data, the CSV file only includes the MemberID_ and EmailAddr_ fields and you would like to see the Demographic columns that are associated.

Solution

1. Click Segments from the left-hand side navigation
   
   
2. Click on your segment to edit it
   
   
3. Click on the Advanced tab
   
   1. 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.
      e.g. demographics.customers, demographics.info
   2. 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.
      e.g. domain_, fullname_

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

   4. 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.
      
      

4. Click on Save

After specifying additional tables and/or columns to display, the selected demographics information appears with the MemberID_ and EmailAddr_.