Customer segment conditions input file

Use a MemberGroupCondition.csv input file to load information to create the conditions for the customer segments that belong to a store. After you load the data, business users can manage the new customer segment conditions with the Marketing tool.

You can extract the conditions for customer segment objects with the Data Extract utility to create a MemberGroupCondition.csv input file that you can then load with the Data Load utility. For example, if you want to copy or move the 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 the customer segment condition data from the MBRGRPCOND database table.

Sample configuration files are also provided for you to use with the Data Load utility to load the customer segment condition data. When you load the MemberGroupCondition.csv file, the Data Load utility populates the MBRGRPCOND database table.

For more information about extracting and loading marketing data, see

When you load customer segment conditions, you might need to load additional information. For example, if the customer segments do not exist in your target store, you must first load the data to create the segments. Then, you can load customer segment conditions and load descriptive information in multiple languages for the segments. For more information about the customer segment-related data that you can load, see:

Definitions

memberGroupName: (Required, String) The administrative name of the customer segment
Maps to MBRGRP.MBRGRPNAME.
conditions: (String) Criteria that defines the customers that qualify to be members of the customer segment.
Note: If you use the Data Extract utility to generate the MemberGroupCondition.csv file, the value for this column is an XML formatted string. If the string includes any new line characters, the CSV data writer for the Data Extract utility converts the characters into whitespace characters. When you load the file with the Data Load utility, the utility converts the whitespace characters back to new line characters.
Maps to MBRGRP.CONDITIONS.
field1: (String) A custom description field for you to use for customer segment condition information.
Maps to MBRGRPCOND.FIELD1.
field2: (String) A custom description field for you to use for customer segment condition information.
Maps to MBRGRPCOND.FIELD2.
delete: (String) Indicates whether to delete the record. Specify 1 to delete the record.
Note: If you want to delete all of the database records that match the records in a file, you can run the Data Load utility in delete mode. For more information, see Configuring the data load order.