Customer segments input file

Use a MemberGroup.csv input file to load information to create customer segments in a store. After you load the data, business users can manage the new customer segments with the Marketing tool. We can extract customer segment objects with the Data Extract utility to create a MemberGroup.csv input file that we can then load with the Data Load utility. For example, if we want to copy or move customer segments between stores or instances, such as for creating one or more test environments. Sample configuration files are provided for you to use with the Data Extract utility to extract customer segment data from the following database tables:

The SQL that the Data Extract utility uses to extract customer segments extracts data for only the member groups that have the type ID value of -1. This ID value indicates that the group is a customer segment. The utility extracts the customer segment name and description for only the default language. The default language is defined in the business context configuration of the environment configuration file. We can use other sample configuration files to configure the utility to extract descriptive information in multiple languages into a separate output file. Sample configuration files are also provided for you to use with the Data Load utility to load the customer segment data. When you load the MemberGroup.csv file, the Data Load utility populates the following database tables:

For more information about extracting and loading marketing data, see

Depending on how our customer segments are constructed, we might need to load additional information. For example, we might need to load descriptive information in multiple languages or conditions for the segments. For more information about the customer segment-related data that we can load, see:


Definitions