Uploading Banners

Banner Integration

You must comply with the following rules to successfully load your Banners in batches:

The file must be accessible through HTTP, HTTPS, FTP or SFTP.
The file may be zip compressed.
The file must be updated at least once a day
There must be a header in the first line and the header titles must be the same with the ones written beside the column definition below.
The file must be UTF-8 encoded.
Use ‘;’ (semicolon) to separate columns.

Example Banner Data File

Click here to download and view a sample CSV file.

Columns must be ordered in the following way:

All columns must be defined with a value. If a column does not have a value, it must be defined with a blank value.

	Column	Type	Header Title
1.	Banner Code	TEXT, MAX CHAR: 100	CODE	MANDATORY
2.	Title		TITLE	OPTIONAL
3.	Banner File URL	TEXT, MAX CHAR: 500	FILE_NAME (URL of the banner image file)	MANDATORY
4.	Target URL	TEXT, MAX CHAR: 500	TARGET_URL	OPTIONAL
5.	Target Type	TEXT, MAX CHAR: 6	TARGET_TYPE	OPTIONAL
6.	Banner Text	TEXT, MAX CHAR: 500	BANNER_TEXT	OPTIONAL
7.	Group Code	TEXT, MAX CHAR: 50	GROUP_CODE	OPTIONAL
8.	Thumbnail File URL	TEXT, MAX CHAR: 500	THUMBFILE_NAME	OPTIONAL
9.	Category	TEXT	CATEGORY (separate multiple categories using pipe. Ex: 323\|343\|4543)	OPTIONAL
10.	Zone ID	INTEGER	ZONE_ID	MANDATORY
11.	Width	INTEGER	WIDTH	OPTIONAL
12.	Height	INTEGER	HEIGHT	OPTIONAL
13.	Valid From	DATE/TIME, 2016-05-05 13:10:00	VALID_FROM	MANDATORY
14.	Valid Through	DATE/TIME, 2016-05-05 13:10:00	VALID_THROUGH	MANDATORY
15.	Priority	INTEGER	PRIORITY	MANDATORY
16.	Active	1 or 0	IS_ACTIVE	MANDATORY

If you have additional attributes just add them as new columns to the file. If there are more than 1 value for a given attribute, separate values using a comma.

Once you have prepared the required file based on the rules and standards mentioned above, follow the following steps to validate it and schedule your automatic upload:

Go to Personalize > Settings > Banner Integration.
Enter the URL for the CSV file you have created.
Click “Test URL” to validate the URL and file.
If you have no error in your Test Detail, click “Save URL”.
Click “Add Trigger” to schedule product data uploads. We recommend that you synchronize the campaign banner data generation and upload frequency.

Parent Topic: Sending Data to RMC