User Lists and Mailing Lists

User lists and mailing lists contain user profile properties. You use user lists to search and update user profile properties; you use mailing lists to send direct mail campaigns.

Using Lists in Web Site Management

Mailing Lists

User Lists

Generic Lists

Dynamic and Static Lists

Using Lists in Web Site Management

You use the List Manager module in Commerce Server Business Desk to import and export users lists and mailing lists in Business Desk.

• Adding Lists to List Manager. You can export a Commerce Server Analysis report as a list to List Manager. You can import a list that you created using another application, such as SQL Server (to create a SQL table), Notepad (to create an ASCII text file), Microsoft Excel (to create a spreadsheet), or Microsoft Outlook (to export a .pst file which contains a list of addresses) into List Manager.

  For example, if you have a list of addresses in a Microsoft Excel spreadsheet, you can use List Manager to import it into Business Desk, and then use the list in a direct mail campaign. If you identify a list of users in an Analysis report, you can export the report results as a list to List Manager, and then use the list in a direct mail campaign.

  For information about importing a list into List Manager, see Importing and Exporting Lists. For information about exporting a Commerce Server Analysis report to List Manager, see Exporting a Static Report.

• Using Lists from List Manager. You can import a user list from the List Manager module to the Users module, and then update the user profiles in the list. For example, you run the Commerce Server Customer Sales report to identify users who buy the most products, and then export the report as a list to the List Manager. You import the user list from List Manager into the Users module, and then update the user profiles in the list by assigning a special value a profile property in the user profiles. You use that value to target specific ads or discount campaigns to the users whose profiles you have modified. For information about importing a list into the Users module, see Importing a List of User Profiles. For information about modifying multiple user profiles, see Editing Multiple Users.

  You can also export the list to another application. For example, you can export a list generated from an Analysis report to a Microsoft Excel spreadsheet. For information about exporting a list to a file, see Importing and Exporting Lists.

Mailing Lists

Mailing lists contain rows of e-mail addresses for a direct mail campaign. Each row in the list contains a single recipient and is comprised of the following elements in a comma-delimited format.

You can create a list using any text editor, such as Notepad. You can add a mailing list to Business Desk by using the List Manager module to import ASCII text files, files from Microsoft Excel or Microsoft Outlook, or tables from SQL Server databases. To create a mailing list by using information in a .pst file from Microsoft Outlook, see the topic "Export items to a file or to a personal folder file" in Microsoft Outlook Online Help.

For information about importing mailing lists for a direct mail campaign, see Importing a Mailing List.

User Lists

User lists contain rows of user IDs and optionally, other user profile properties. You can import user lists from the List Manager module into the Users module, and then perform bulk updates on the properties for specific users.

For example, you can import a list from the Segment Viewer module into List Manager. If the list contains user profile data, you can use the Users module to set a property in the user profile for each user in the list to indicate their membership in a particular segment. You can then use this information to target ads and discounts to that specified user segment.

Generic Lists

Generic lists can contain anything, and they can include headers, as in the following example:

Generic lists do not have content requirements, unlike user lists and mailing lists. To use generic lists, a site developer must customize your application.

As an example, you may want to use generic lists to set product properties. For example, you run the Commerce Server Product Sales report to identify the most popular products (in terms of sales) on your Web site. You can use the List Manager module to import the result of this report as a list of products, and then use the Catalog Editor module to set a property on these products to identify that they sell especially well. You can then use this property to create target expressions, or to increase the price of these products by five percent.

Another way you can use generic lists is to mail coupons to your frequent online customers for use in your store. You can do this by running a report to analyze user purchases, exporting the results of the report as a list which includes the mailing addresses, and then using List Manager to export this list for use in a labeling application.

Dynamic Lists and Static Lists

User lists, mailing lists, and generic lists can be either dynamic or static:

• Dynamic lists are created at run time, such as when the list is being exported from List Manager for use in a direct mail campaign. Each time the list is requested, List Manager gathers the most recent data from the data source, such as the Data Warehouse. Only the information needed to create the list is stored in the Commerce Server database. Use dynamic lists for direct mail campaigns that you will run frequently, or if the list of recipients is updated frequently.
  
  
• Static lists are created immediately upon request, and then stored in the Commerce Server database. Use static lists, for example, for direct mail campaigns that you run infrequently, or if the list of recipients does not change often.

See Also

Importing a Mailing List

Importing a List of User Profiles

Editing Multiple Users

Importing and Exporting Lists