Using Lists in Web Site Management

You use the List Manager module in Commerce Server Business Desk to import and export user 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 by 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 that contains a list of addresses), to List Manager.

    For example, if you have a list of addresses in a Microsoft Excel spreadsheet, you can use List Manager to import it to 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 to 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 to the Users module, and then update the user profiles in the list by assigning a special value to 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 to the Users module, see Finding User Profiles in a Mailing List. For information about modifying multiple user profiles, see Editing Multiple User Profiles.

    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.

The following figure shows how you can import data from a variety of sources to the List Manager, use the lists with campaigns and to update profiles, and then update information in your databases or target personalized content to users.

A figure that shows the components

See Also

Mailing Lists

User Lists

Generic Lists

Dynamic Lists and Static Lists

Copyright © 2005 Microsoft Corporation.
All rights reserved.