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.

Note: You must apply the interim fixes for APAR JR53438.fep and APAR JR53438.fp to add support to the Data Extract utility and Data Load utility for extracting and loading marketing data.

You can extract customer segment objects with the Data Extract utility to create a MemberGroup.csv input file that you can then load with the Data Load utility. For example, if you 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. You 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 your customer segments are constructed, you might need to load additional information. For example, you might need to load descriptive information in multiple languages or conditions for the segments. For more information about the customer segment-related data that you can load, see:

Definitions

memberGroupName: (Mandatory, String) The administrative name of the customer segment
Maps to MBRGRP.MBRGRPNAME.
usage: (Mandatory, String) The type of member group. Customer segments must have a usage value of "GeneralPurpose". This value is converted to the correct value to store in the MBRGRPTYPE_ID database column during the data load process.
Note: If you use the Data Extract utility to generate the MemberGroup.csv file, the extracted value is always "GeneralPurpose".
Maps to MBRGRPUSG.MBRGRPTYPE_ID.
shortDescription: (String) The display name of the customer segment.
Maps to MBRGRPDESC.DISPLAYNAME.
longDescription: (String) The description of the customer segment.
Maps to MBRGRPDESC.DESCRIPTION.
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.