Current Query and List Details

General Information

This screen is the main "desktop" workplace in the Mail Order Manager List Management Module. It is divided into two major sections. The top contains the information about the current active query that you are working on. The bottom contains the information about the current active list for the current active query.

See Also

List Management Queries - Creating and Modifying

List Management Module Main Tool Bar and Action Bar Menu

Saving and Using Lists

Current Query Information

This top area of the screen contains the Include and Exclude SELECTION STATEMENTS. If the query is a new query, no statements are displayed.

NAMES ADDED - this column contains the results counts for that Selection Statement line in the query. This number can be positive or negative (-) depending on whether that particular statement in the query added names or removed names. If the statement has not been compiled, no number is displayed in this column.

TOTAL COUNT - this column displays the total size of the list as a result of the names added count for that Selection Statement.

STATUS - can be "Compiled" or "Need to Compile" depending on whether that Selection Statement has been compiled in the query yet.

SOURCE KEY - if a source key has been added to a Selection Statement using the ADD SOURCE KEY button, it is displayed in this column.

List Details Information

The bottom area of the screen contains the information about the list(s) associated with the Current Query. All of the information displayed in this area pertains to the CURRENT LIST.

CURRENT LIST - if there is more than one list associated with the Current Query, you can select any list in this pop-up list box. When a new list is being created from the Query, "Untitled List" is displayed.

COMMENTS - this scrollable area enables you to write some specific information about the CURRENT LIST.

BY - the user ID for the M.O.M. user who created the list.

COMPILE DATE - the last compile date for the list.

SOURCE KEY FOR LIST - an advertising source key for the entire list. Typically this field identifies the list for response purposes. Lookup/List [F2] is available for this field. This field is dimmed if Source Keys have been applied to any/all individual Selection Statements in a query.

RENTAL RATE - the rate paid when the list is rented.

MAIL DATE - the mail date or use date for the list when labels are created and the list is mailed or used for some other purpose.

List Counts

On the right side of the screen are counts of the total list.

TOTAL COUNT - the total count of names on the list

EXPIRED - the number of names on the list set to "Expired." To include these names in the list, check the checkbox to the right of the count.

NO MAIL - the number of names on the list set to "Do Not Mail." To include these names in the list, check the checkbox to the right of the count.

NO E-MAIL - the number of names on the list set to "Do Not E-Mail." To include these names in the list, check the checkbox to the right of the count.

NO RENT - the number of names on the list set to "Do Not Rent." To include these names in the list, check the checkbox to the right of the count.

NO CALL - the number of names on the list set to "Do Not Call." To include these names in the list, check the checkbox to the right of the count.

NO FAX - the number of names on the list set to "Do Not Fax." To include these names in the list, check the checkbox to the right of the count.

Note: A customer name is manually set to these restrictions in Customer Information - General screen of the Main M.O.M. System.

NON-VALID ADDR - the number of names whose addresses were considered invalid by the United States Postal Service Database or who have been validated but have exceeded the Validation Expiration Date using the Address Correction and Validation Module.

NOT VERIFIED - the number of names whose addresses were not validated against the USPS Database

NET COUNT - the total number of "mailable" names on the list. If you do not check the boxes to include the names removed from the list, this number is generally smaller than the TOTAL COUNT.

Viewing Names on the List

Press the SHOW NAMES button to view the customer names on your list on your screen in a report format.