Subsets Overview

Let's say you'd like to send a special message to only those list members who

- joined your list a week ago

- live in France

- are celebrating their birthday today

- have made a major purchase in the last year

- have an email address at a particular domain (e.g., aol.com or hotmail.com)

ListManager allows you to send to a segment, or subset, of your list who meet the criteria you define. Instead of sending to your entire list, you can use subsets to filter exactly who should get a message based on whatever criteria you choose. Technically, a subset is a user-defined SQL 'where' clause. It will be combined with the standard member retrieval 'where' clause in order to send to just a subset of the mailing list.

For example, let's say you'd like to send a message only to those people on your list who work at Lyris Technologies, but you don't want to create a separate list for those people. By using the Create Subset (Simple) page, you can create a subset which pulls all the members of the list with "lyris.com" in their email address. Simply select Create Subset (Simple), and give your subset a name. Under "Selection Criteria," you could specify the domain to send to by using the following critrion:

Domain_ (text) = lyris.com

To send to a subset, you may either use the Send Message page to select the lists or subsets you'd like to send to, or you may send an email message to the subset address:

listname.subset@yourserver.com

The Subset Tutorial is a good way to get familiar with creating and using subsets in ListManager.

The Create Subset (Advanced) page allows you to select members using criteria in a table other than the members table. See Joining a Table for more information.

Subsets are a feature of ListManager Pro, and are unavailable for standard ListManager. Contact your account representative at sales@lyris.com if you'd like to upgrade to ListManager Pro.

1. Subsets First Page

1. Create Subset (Simple)

1. Subset Name

2. Subset Description

3. Match Any or All Criteria

4. Selection Criteria

1. Create Subset (Advanced)

1. Additional Columns to Retreive for Testing

2. Additional Tables for Joining

3. Additional SQL Where Criterion

4. Pull Only Normal Members

5. Pull Only Members Receiving Regular Email

6. Pull Only This List's Members

7. SQL ORDER BY Clause

8. Max Records

2. Subset Tutorial

3. Joining A Table