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.

We can extract the conditions for customer segment objects with the Data Extract utility to create a MemberGroupCondition.csv input file that we can then load with the Data Load utility. For example, if we 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

• Extracting marketing data with the Data Extract utility

• Loading marketing objects with the Data Load utility

When you load customer segment conditions, we might need to load additional information. For example, if the customer segments do not exist in your target store, we must first load the data to create the segments. Then, we 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 we can load, see:

• Customer segments input file

• Customer segment descriptions input file

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: To delete all of the database records that match the records in a file, we can run the Data Load utility in delete mode. For more information, see Configure the data load order.