They provide a structured format, that allows you to organize and store various attributes associated with creative ads, such as image URLs, image files, product IDs, product descriptions, etc.

Data tables can be also used as an alternative to Google Spreadsheets for managing the dynamic data for the Feeds.

To create a new Data Table go to Data > Data Tables > click New Data Table button.

To rename your Data table click on the top menu and select Rename.

To import a CSV file, just click on Import CSV button in the top menu.

To add a new column, click on Add button and select from the dropdown menu the type of column you want to add.

To add a new row, click on Add button at the bottom left of your table.

To select a row, hover over it and click on it.

To view all the actions (like Rename, Delete, …) for a specific column, click on the drop-down arrow.

Let’s insert a new Text column on the left.

For the Text you have additional tools to fully customize it (including the Font Size).

For the image column, upload your images to your feed by clicking the Import File button or simply Drag the images directly from your PC to the Data table.

A thumbnail will be displayed for each uploaded image.

Now, let’s add a Color column.

To select a color, simply double-click inside the column, and the color picker will automatically appear.

A color thumbnail will be displayed for each added color.

Right-click to Copy/Paste/Delete color. You can also remove color by pressing Delete on your keyboard.

If you want to select more rows, select a row from the top and hold down the Shift key and select the bottom row. That selects all rows in between.

Use keyboard shortcuts to enhance productivity.

For Windows:

Undo last command – Ctrl + Z;

Redo last command – Ctrl + Shift + Z;

Cut – Ctrl + X;

Copy – Ctrl + C;

Paste – Ctrl + V.

For MacOs:

Undo last command – Cmd + Z;

Redo last command – Cmd + Shift + Z;

Cut – Cmd + X;

Copy – Cmd + C;

Paste – Cmd + V.

Item visibility mode – Always. This is a default option and refers to a selected element/item that will be always visible (HTML/Fallback/Feed).

Item visibility mode – Only For HTML meaning this element will be shown in HTML5 format only and will not be visible on the Fallback GIF/MP4.

Item visibility mode – Only For Fallback. This option is the opposite of the previous one, meaning that the element will only be visible when the banner was generated as a fallback GIF/MP4. It will be hidden in HTML5 mode.

Item visibility mode – Feed Loaded & Item Feed Data Not Empty.

This option is related to Dynamic Data Feed.

Feed wasn’t loaded at all (some network error occurred) – Item visible FALSE

Feed was loaded but the data for the item is empty – Item visible FALSE

Feed was loaded and the data is not empty – Item visible TRUE

Item visibility mode – Feed Load Success.

Feed wasn’t loaded at all (some network error occurred) – Item visible FALSE

Feed was loaded but the data for the item is empty – Item visible TRUE

Feed was loaded and the data is not empty – Item visible TRUE

Item visibility mode – Feed Load Failed.

Feed wasn’t loaded at all (some network error occurred) – Item visible TRUE

Feed was loaded but the data for the item is empty – Item visible FALSE

Feed was loaded and the data is not empty – Item visible FALSE

*The feed visibility is usually used to display a fallback text or image in case there are some issues with the feed loading (network error) or when the feed data is empty. This way user will see the fallback elements instead of a broken feed banner.

Before you can create a feeded banner, you need to create a new feed, which will be used in your bannersets.

Learn how to do this:

Go to the Data > Feeds and click on the Add a New Feed button.

From Select Data Source dialog select JSON.

Fill in all the required input fields:

1. In the “FEED NAME” input the feed’s title.
2. In the “FEED URL” input the feed’s URL (XML or JSON). You”l also be able to use a Google Spreadsheet as a feed source.
3. In the “MAX ROWS” input the limit number of max results/rows.
4. Select the “UPDATE INTERVAL” – an interval that represents how often new data is fetched.
5. Click the Proceed to fields selection, to go to the next step.

 After your feed was parsed, select the data that can be accessed from inside the banner:

• Check the required fields in the left tree panel.
• The fields that you have selected will appear in the central panel (Selected Fields).
• You can use the jsonPath formula (read the documentation) if you need to select some specific data or to convert it into a different format (you can also contact us, we will gladly assist you with this). In this tutorial, we have used the UCASE({$[*].name}) formula to convert the name fields to uppercase strings. For the price_usd field we are using the NUMBER({$[*].price_usd}, ‘$0,0.00’) formula to display the price in the right format.
• You can also create a custom field manually by clicking the +Add Custom Field button.
• For the “img” custom field we will create a formula to help us to create a URL path to the image from the feed: ‘https://bannernow.com/demo/’+{$[*].id}+’.svg‘.
• Within the right panel, you’ll view the results accessible in your banners.

Use Filters:

Click the “Add New Filter” button.

You can manipulate the feed results using the following filter types: Include, Exclude, Replace, Sort, Prioritize, Remove Duplicates, URL Fallback

Here is an example:

1. Input filter title.
2. Select the Sort filter.
3. Select the filtering to sort by price.
4. Field type (string, number, date).
5. Operator (descending price).

Click the “Update/Create Feed” to save it.

Create a new bannerset.

When creating a bannerset, input the title and select the feed source from the dropdown menu. After that, click the create button.

Create a new banner.

You can use a different feed for the translated banners within the same bannerset:

• Click the Settings button in the translation modal
• Select a different feed from the dropdown
• Click the Update button

After adding the feed to your bannerset you can create a new banner (or edit an existing one). To add a feeded source to the item inside the banner, do the following:

• Select the each item
• Click on the green Feed button

Select the field that you want to display. The fixed row slider can be used in case you need to display the data from a specific row only. Click Save  to apply the feed to the item.

It’s also possible to connect the URL from the feed to the banner hyperlinks. To do this, go to canvas settings and set the feeded hyperlink to the whole banner or select an item and enable Hyperlink for it.

Select the field that contains the URL data format and click Save to apply the changes.

Save your banner and click Preview. You will notice that on each loop, the banner is taking the new data from the next row within the feed.

Now, you’re able to publish the banner to the ad network. When the feed data is updated, your banner will always display fresh data.

Showcase Example https://bannernow.com/html5-banner-examples

Here’s how you can use it:

1. Open up Google Sheets

Tip: If your spreadsheet is stored as XLSX – convert it to Google Sheets first !

2. Make sure the first row contains a title for each column.

3. Next click the Share button in the top right menu.

4. Click “Change to anyone with the link“.

5. Next choose Anyone with the link option and press “Done”.

6. Next copy the document link.

7. Go back to BannerNow, Library -> Feeds -> New Feed.

8. Choose Google Spreadsheet.

9. Paste your google spreadsheet link, choose the page number and the desired update interval and click proceed.

Now you can select the data from your spreadsheet that you want to use in your banners.

Read more about creating feeded banners here.