Feeds

Many companies use software systems, which enable them to publish product feeds. These feeds usually contain information about the offered products, such as product characteristics, URL, status or dynamic inventory. To have this information available in the Campaign Suite can be very helpful for the advertiser. Follow these steps in order to make sure the used feed is regularly automatically imported into any desired table of the Campaign Suite account.

Step 1: Add new product feed table

Add new product feed table

In the “Campaign Management” tab click “New table” and select “Product feed”.

Step 2: Enter URL

Enter URL, username and password

In this step, choose a name for the final product feed table. The Campaign Suite proposes to call it “Product feed”. After that enter the URL of your CSV table or upload a file from your computer. If necessary, provide credentials.

Step 3: Preview

Preview

This step offers a preview of your product feed. It will be imported into a new table in the Campaign Suite as it is. Click “Import now” to proceed.

Step 4: Automatic Update

If you provided a URL in the first step, you now have the option to schedule regular automatic updates of the product feed table. This will cause the CSV file to be downloaded from your server in regular intervals.

Automatic update settings

New rows in feed

Decide whether to add rows to the Campaign Suite table, which exist in the feed but not yet in the Campaign Suite table.

Missing rows in feed

“Remove from Campaign Suite” removes rows from the Campaign Suite that exist in the Campaign Suite table but not in the feed.
“Set status to Paused in Campaign Suite” keeps rows in the Campaign Suite table that do not exist in the feed. The status of such rows is set to “Paused”.
“Leave unchanged in the Campaign Suite” leaves rows in the Campaign Suite table untouched in case they do not exist in the feed.

List mode

If the Campaign Suite table contains a list and the feed contains the same list but with different entries, there are two options: Either keep the old Campaign Suite entries and add the entries from the feed (“Append new values to lists”) or empty the Campaign Suite version of the list, and replace it with the version from the feed (“Replace old lists with the new ones”).

Back in the table the icon of the button “Feed” will have turned slightly green. This indicates that a feed is connected and automatic import is scheduled.
Automatic feed update active

Step 1: Import Feed Button

Go to the desired table, where you want the feed contents to be imported. Click the button “Feed” and select “Import Feed”. The “Import Feed” dialog opens.

Feed import

Step 2: Enter URL

Insert the URL of the feed. If the feed is protected with a username and password, enter them into the respective fields. If not, leave the fields empty.

Enter URL, username and password

Step 3: Column Mapping

The Feed Import feature automatically detects the column separator and the encoding of the feed. However, they can be changed manually.

Column mapping

The Campaign Suite automatically compares the column names of the underlying table with the column names of the feed. Then it proposes which feed column to map with which table column. The “name” column of the table must always be mapped. If this is not selected in the mapping, because there is no feed column called “name”, please choose one column that should be mapped with the table column called “name” manually. The specialty of the “name” column is that it must be unique. It uniquely identifies each row of the table. Therefore, please make sure to map it to the unique column of the feed if possible. Please note that if the “name” column is mapped to a non-unique column (to a column that contains the same entry in two or more different rows), the Campaign Suite will try to keep only the first occurrence of the duplicate row and ignore all subsequent ones.

Step 4: Import Settings

The feed import wizard is concluded by choosing some settings. These settings can be changed any time by clicking on “Feed” > “Feed Settings”. First, choose if the feed shall be imported automatically on a regular basis. Usually, this is the best decision. Select either “every day” or a week day and a time. Please find out when the feed of your company is regularly updated and adapt these settings accordingly. If turned off, the feed will only be imported after the completion of the wizard or if you press the button “Feed” > “Import Feed Now”.

Note: If you press “Import Feed Now” while automatic import is turned off, the current table will be replaced by the new one.

Automatic feed import

If automatic Import is turned on, decide whether to activate “Delete table before each import”. This option will first empty the Campaign Suite table and then import all mapped columns. By clicking “no”, there will be more detailed import options.

Step 5: Advanced Import Settings

Three new options are available, when the deletion before each import is deactivated.
Feed import settings

New rows in feed

Decide whether to add rows to the Campaign Suite table, which exist in the feed but not yet in the Campaign Suite table.

Missing rows in feed

“Remove from Campaign Suite” removes rows from the Campaign Suite that exist in the Campaign Suite table but not in the feed.
“Set status to Paused in Campaign Suite” keeps rows in the Campaign Suite table that do not exist in the feed. The status of such rows is set to “Paused”.
“Leave unchanged in the Campaign Suite” leaves rows in the Campaign Suite table untouched in case they do not exist in the feed.

List mode

If the Campaign Suite table contains a list and the feed contains the same list but with different entries, there are two options: Either keep the old Campaign Suite entries and add the entries from the feed (“Append new values to lists”) or empty the Campaign Suite version of the list, and replace it with the version from the feed (“Replace old lists with the new ones”).

Back in the table the icon of the button “Feed” will have turned slightly green. This indicates that a feed is connected and automatic import is scheduled.
Automatic feed update active

Advanced Hints

With the product feed table it is possible to create tables from the columns of the imported feed. This can save a lot of time, when setting up tables.

Step 1: Extract columns

To extract columns as tables from a product feed table, click on “Settings” > “Extract columns”.
Extract columns

Step 2: Select columns, table types and prefix

The Campaign Suite will automatically detect columns with names similar to the table types available (like brand and category). If a column is not already listed in the dialogue box, add it by clicking on “Add another column to create a table”. Select the according column from the product feed table, choose a table type and set a table prefix. To proceed, click on “Create Tables”.
Select columns, table types and prefix

Step 3: Access the newly created tables

The tables, which have just been extracted from the product feed table, can be selected from the table selector in the upper left corner.
Access the newly created tables

In many cases it happens that the brand, category, … tables contain other names for equal items compared to their names in the product feed. For example, the category table might have the name value “Shoes” while the feed calls the same items just “shoe”. In such a case, it’s not possible to set up a relation between the feed column and the name column of the category table, because the Campaign Suite will not understand that these are the same items. The best solution is to create a second column in the category table, which is called e.g. “feed_names”. There write “shoe” into the “Shoes” row. Afterwards, relate the “feed_names” column with the category column inside the feed.