spreadsheet – Bannernow Tutorials https://bannernow.com/tutorials Bannernow Tutorials Wed, 19 Feb 2025 23:44:01 +0000 en-US hourly 1 https://wordpress.org/?v=6.7.2 https://bannernow.com/tutorials/wp-content/uploads/favicon-bn-32x32.png spreadsheet – Bannernow Tutorials https://bannernow.com/tutorials 32 32 Feed Data table https://bannernow.com/tutorials/html5-banner-ads-data-table-feed/ Wed, 14 Aug 2024 11:08:27 +0000 http://help.bannernow.com.www629.your-server.de/?p=3268 Data tables are fundamental when it comes to managing feeds.

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.

]]>
spreadsheet - Bannernow Tutorials nonadult
Google Spreadsheet as a Feed Source https://bannernow.com/tutorials/using-google-sheets-as-feed-source/ Tue, 06 Mar 2018 18:25:01 +0000 http://help.bannernow.com.www629.your-server.de/?p=516 BannerNow provides a way to use Google Sheets as a feed source for your banners.

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.

]]>