Exporting customer segment information

In authoring environments you can export customer information for a customer segment to help you analyze your customer segments, or to create and manage marketing campaigns outside of Management Center. For example, you can export email addresses for the customers in a customer segment and then use another application to send a marketing email to the customers.

By analyzing your customer segment information, you can identify common attributes among customers and regroup customers into new segments. You can then create CSV files for each new segment that includes the appropriate customer information for the customers in that segment. A site administrator can then use the Data Load utility to load the CSV file into the database to populate the customer segment with the customer information.

You can export customer information from within an authoring instance, or from a staging instance where the quick publish connection has been manually created. For more information, see Manually creating a quick publishing target on a staging server.

Before you begin

About this task

WebSphere Commerce EnterpriseIf you are working in an extended site store, you are recommended to export customer information for only the customer segments that belong to your extended site store.

Note: If you are working in a workspace and run a customer segment export, the export process does not use the workspace segment information to create the query that retrieves customer information. The export process uses the approved content data in your environment database to create the query. For example, if you change a segment for male customers over age 40 in a workspace to be for female customers under age 35. When you run the customer segment export, the export process retrieves information for male customers over age 40.


Export the customer segment information
  1. Open the Marketing tool.
  2. In the Explorer view, click Customer Segments. The list of all customer segments for your store displays.
  3. Right-click a customer segment. Click Export Customer Segment.
  4. In the Export Customer Segment tab, enter the name for the export CSV file.
  5. Optional: Select the customer information that you want to include in the file.
    By default, the file contains only the list of email addresses for all registered customers in a customer segment that opted in to receive email messages. The customer segment export file does not include information for guest or unregistered customers.
    You can select to include information for more customer segment attributes in the export file. By default, you can configure the export to include the following information:
    • Customer first and last names, and their preferred title
    • Customer logon ID
    • Registered customers that did not opt in to receive email.
    If you want to include more information in the file, you can request that an IT developer customize the export feature.
  6. Click Save to begin the export process.
    Since customer segments can include many customers, the customer segment export process can take time. You can work on other tasks while the export process completes. The export process stores the export file in the staging(authoring) environment database.
Download the customer segment export file.

  1. Optional: If you are not working in Management Center as a Marketing Director, log out of Management Center. Log on to Management Center as a user with the Marketing Director role and open the Marketing tool.
  2. In the Explorer view, click Customer Segment Exports.
  3. Right-click the customer segment export. Click Download Customer Segment. Save the file to your local file system.
    Note: For security and auditing purposes, When you download a customer segment export file, your user ID and the date and time of the download are recorded. You can view the download history of an export file in the Download History tab in the properties view for the customer segment export. WebSphere Commerce also records the audit trail for downloads in the appropriate business audit database table.