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

• COLLATERAL

• COLLDESC

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:

• COLLATERAL

• COLLDESC

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

Depending on how your marketing content is constructed, we might need to load additional information. For example, we might need to load descriptive information for the content in multiple languages or attachments. For more information about the marketing content-related data that we can extract or load, see:

• Marketing content description input file definitions

• Marketing content attachment input file definitions

• Marketing content attachment description input file definitions

• Marketing content image map input file definitions

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. We 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. We 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 used to manage the content. We 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 we 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: 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.