Marketing content input file definitions

Use a MarketingContent.csv input file to load information to create marketing content for a store. After you load the data, business users can manage the new marketing content with the Marketing tool.

You can extract marketing content objects with the Data Extract utility to create a MarketingContent.csv input file that you can then load with the Data Load utility. For example, if you want to copy or move the content 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 marketing content data from the following database tables:

Sample configuration files are also provided for you to use with the Data Load utility to load marketing content data. When you load the MarketingContent.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 marketing content is constructed, you might need to load additional information. For example, you might need to load descriptive information for the content in multiple languages or attachments. For more information about the marketing content-related data that you can extract or load, see:

Definitions

contentName

(Required, String) The name of the marketing content.

This column or element maps to COLLATERAL.NAME.

contentType

(Required, String) The type of the marketing content. The supported default types are Image, Flash, and Text.

This column or element maps to COLLTYPE.NAME.

url

(String) The click action to be invoked when a customer clicks the content.

This column or element maps to COLLATERAL.URL.

behavior

(Integer) Indicates whether the content displays the same results to all customers. The associated e-Marketing Spot can use this setting to determine how to cache the e-Marketing Spot results. You can set the following values for this column or element:

0: The content displays the same results to all customers.
1: The content is dynamic and can display different results.

This column or element maps to COLLATERAL.BEHAVIOR.

uiDisplayable

(Integer) Indicates whether the activity displays in Management Center. You can set one of the following values for this column or element:

1 or null: The activity displays in Management Center.
0: The activity does not display in Management Center.

This column or element maps to COLLATERAL.UIDISPLAYABLE .

managingTool

(Integer) Indicates the Management Center tool that is used to manage the content. You can set one of the following values for this column or element:

0 or null: The content is managed with the Marketing tool.
1: The content is managed with the Commerce Composer tool.

This column or element maps to COLLATERAL.MANAGINGTOOL.

location

(String) The full image path to the content.

This column or element maps to COLLDESC.LOCATION.

marketingText

(String) The marketing text of the content. This text describes the marketing objective that is intended to be achieved by the marketing campaign.

When you are extracting marketing content data, the Data Extract utility extracts the value for this column or element from the LONGMKTGTEXT column. If the value in that column is null or empty, the value for this column or element is extracted from the MARKETINGTEXT column.

When you load marketing content data, the Data Load utility loads the data into the MARKETINGTEXT column by default. If the value is more than 4000 characters, the utility loads the value into the LONGMKTGTEXT column.

Maps to COLLDESC.MARKETINGTEXT or COLLDESC.LONGMKTGTEXT

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.