Feature Pack 8

Marketing campaign input file definitions

Use a MarketingCampaign.csv input file to load information to create marketing campaigns for a store. After you load the data, business users can manage the new campaigns 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 campaign objects with the Data Extract utility to create a MarketingCampaign.csv input file that you can then load with the Data Load utility. For example, if you want to copy or move campaigns 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 DMCAMPAIGN database table.

Sample configuration files are also provided for you to use with the Data Load utility to load the campaign data. When you load the MarketingCampaign.csv file, the Data Load utility populates the DMCAMPAIGN database table.

For more information about extracting and loading marketing data, see
After you create your campaigns, you can load additional information to associate marketing activities with the campaigns. For more information about the marketing activity-related data that you can load, see:

CSV column and XML element definitions

(Mandatory, String) The campaign name.

This column or element maps to DMCAMPAIGN.NAME.

(String) The description of the marketing campaign.

This column or element maps to DMCAMPAIGN.DESCRIPTION.

(Integer) The current state of the marketing campaign. You can set the following values for this column or element:
The campaign is inactive. This value is the default value.
The campaign is active.

This column or element maps to DMCAMPAIGN.STATE.

(String) The season of the year in which the campaign is to run.

This column or element maps to DMCAMPAIGN.SEASON.

(String) The name of the member organization that owns the campaign.

This column or element maps to DMCAMPAIGN.OWNER.

(String) The objectives and goals that the marketing campaign intends to reach.

This column or element maps to DMCAMPAIGN.OBJECTIVE.

(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.