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.

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

• Extracting marketing data with the Data Extract utility

• Loading marketing objects with the Data Load utility

After creating your campaigns, we can load additional information to associate marketing activities with the campaigns. For more information about the marketing activity-related data that we can load, see:

• Marketing activity input file definitions

• Marketing element input file definitions

• Marketing element NVP input file definitions

CSV column and XML element definitions

name

(Required, String) The campaign name.

This column or element maps to DMCAMPAIGN.NAME.

description

(String) The description of the marketing campaign.

This column or element maps to DMCAMPAIGN.DESCRIPTION.

state

(Integer) The current state of the marketing campaign. We can set the following values for this column or element:

0

The campaign is inactive. This value is the default value.

1

The campaign is active.

This column or element maps to DMCAMPAIGN.STATE.

season

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

This column or element maps to DMCAMPAIGN.SEASON.

owner

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

This column or element maps to DMCAMPAIGN.OWNER.

objective

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

This column or element maps to DMCAMPAIGN.OBJECTIVE.

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. See Configure the data load order.