Banner Integration

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

  1. The file must be accessible through HTTP, HTTPS, FTP or SFTP.
  2. The file may be zip compressed.
  3. The file must be updated at least once a day
  4. 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.
  5. The file must be UTF-8 encoded.
  6. Use ‘;’ (semicolon) to separate columns.

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.


ColumnTypeHeader Title
1.Banner CodeTEXT, MAX CHAR: 100CODE

2.Title
TITLE

3.Banner File URLTEXT, MAX CHAR: 500FILE_NAME (URL of the banner image file)

4.Target URLTEXT, MAX CHAR: 500TARGET_URL

5.Target TypeTEXT, MAX CHAR: 6TARGET_TYPE

6.Banner TextTEXT, MAX CHAR: 500BANNER_TEXT

7.Group CodeTEXT, MAX CHAR: 50GROUP_CODE

8.Thumbnail File URLTEXT, MAX CHAR: 500THUMBFILE_NAME

9.CategoryTEXTCATEGORY (separate multiple categories using pipe. Ex: 323|343|4543)

10.Zone IDINTEGERZONE_ID

11.WidthINTEGERWIDTH

12.HeightINTEGERHEIGHT

13.Valid FromDATE/TIME, 2016-05-05 13:10:00VALID_FROM

14.Valid ThroughDATE/TIME, 2016-05-05 13:10:00VALID_THROUGH

15.PriorityINTEGERPRIORITY

16.Active1 or 0IS_ACTIVE


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:

  1. Go to Personalize > Settings > Banner Integration.

  2. Enter the URL for the CSV file you have created. 

  3. Click “Test URL” to validate the URL and file.

  4. If you have no error in your Test Detail, click “Save URL”.

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