Here is a quick overview of how this feature works:

1. The user opens a website with the banner. The website (or the DSP/SSP platform on the website) loads the BannerNow Ad Tag and passes the segment this user belongs to.
   For example, &segment=age18-20 (where the segment value will be different for each website user).
   Basically, the website or DSP/SSP should know the segment the user belongs to before the banner starts rendering
2. Once banner is rendered using the additional Ad Tag parameter, it tries to search for the segment value match in the Feed connected to the banner.
3. If a match is found, it will display the data from the same feed/table row where the match was found.

Let’s create a Google Spreadsheet and use it as a data source for this tutorial.
The Age column will represent the Segment values

Next, click the Share button located in the top right corner.
Choose the Anyone with the link option to make your feed public, then click Done.
Now, this spreadsheet can be used as a feed data source in BannerNow.

Let’s return to BannerNow -> Data -> Feeds tab. Click Create new feed button.

Select the Google Spreadsheet option.

Next, copy/paste the spreadsheet URL (the link from Google Sheets), and enable the targeting option.

Choose the columns from the feed that you want to display in your ad.

In the Targeting tab, click Add New Rule.
Rule Type: INCLUDE
Rule match type: SEGMENT ( string, = )
Column from our table to match: age

Now it’s time to build a creative.

Select the Bannerset format.

In the pop-up modal, select the feed that we have just created and click Create.

After creating your design, you need to bind the feed data to the element values (images, texts, landing URLs).

To do this, select the text element and click on the feed icon to bind the text value to the feed data.

Select the column you want to display for a specific text element.
Also, select the Fixed Line option and set the Row Number = 1
This will ensure that if no match is found, it will take only the first row from our feed (which in our case is the default one).

Perform the same action for each dynamic element in the design.

Don’t forget to bind the Landing Page URL (Global settings) to the Landing URL from the Feed

Save your creative and click Publish.

Select the sizes you want to publish and click Next

Pick the Ad Network where the banner should be published.
If you just plan to use it on your website (without SSP/DSP), then select the BannerNow Ad Network

The Ad Tag is now generated for your banner.
Next, we need to add the &segment= to our Ad Tag:

Because the segment will be dynamically replaced for each end-user, we suggest you to use the Macros.
A Macro is a special string that can be easily replaced in the code with the real value.
For example, &segment=%%segment%% (where the %%segment%% is the string macro that will be replaced by the SSP/DSP or your website).
Each Ad Network has its own format for the segment macros, so please check the Ad Network documentation to find the right macros format.

If you plan to replace it with the code on your website, then just use the default %%segment%%

For example, the BannerNow Ad Tag will look like:

<script src="https://storage.bannernow.com/MVDq2PxpdlGOk5Axgea8ryZeQb7LWBwKgMqbFFb2Gk/embed.js?responsive=0&bnTag=&segment=%%segment%%" async></script>

And on your website, once the %%segment%% is replaced with the real value, it should look like this:

<script src="https://storage.bannernow.com/MVDq2PxpdlGOk5Axgea8ryZeQb7LWBwKgMqbFFb2Gk/embed.js?responsive=0&bnTag=&segment=age18-22" async></script>

or like this for another website end-user:

<script src="https://storage.bannernow.com/MVDq2PxpdlGOk5Axgea8ryZeQb7LWBwKgMqbFFb2Gk/embed.js?responsive=0&bnTag=&segment=age55-60" async></script>

In this guide, we’ll walk you through the steps to protect your Google Sheets, ensuring your data remains private and secure.

Let’s begin by setting up access permissions for your Google Sheets. In the top-right corner click Share button.

Enter the email address provided by BannnerNow:

private-spreadsheets@bannernow-gcloud.iam.gserviceaccount.com

Click the Share button to share the spreadsheet. Viewer permission is sufficient. The platform will now have access to your Google Sheet based on the permissions you have set.

Let’s return to BannerNow and set up a new feed. Navigate to the Data menu, open the Feeds tab, and click on New feed.

Next, from the Data Source options select Google Spreadsheet.

In the modal:

1. input the name of your feed;

2. copy the link of your google spreadsheet and insert it in the Spreadsheet ID field;

3. check the Private Spreadsheet option.

And there you have it! Now your private Google Spreadsheet is serving as a dynamic feed source and you can easily manage and update the content displayed on your ads in real-time. Happy advertising!

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.