PRODUCTS: DATA FEEDS

DATA FEEDS

A data or product feed is a file that contains information about your products or services which can be used in your ads. When your data feed is updated with new info, your ads will also be updated. A data feed might only contain a few products or it could contain thousands.

If you’re ready to get started then continue reading to find out more about how to use data feeds to create dynamic ads in Adacado!

Examples of Data Feeds by Business Type

Check out the following examples to get a sense of what a CSV spreadsheet data feed could look like:

Requirements

Supported Feed Types

Adacado supports the following data feed file types:

  1. CSV
  2. Google Sheet URL (CSV)
  3. Google Product Feed (XML)
  4. TXT

Feed Hosting

Adacado allows feeds to be hosted from both URLs and FTP servers. Unfortunately, we currently do not support SFTP. 

Where to Get a Data Feed

There are a number of options when it comes to using data feeds. Wherever your feed comes from, be sure to check that the provided file type is compatible with the Adacado platform.

Feed Provider

There are many services which can create product feeds based on your website’s content. Searching the web for “product data feed service” will be sure to give you plenty of options to choose from. The benefits of using a feed provider are increased flexibility and ease of use, making this a great option, particularly for websites with many products or services with frequently changing information.

Export From Ecommerce Platform

Many ecommerce platforms, such as Shopify, WooCommerce, Wix, and Squarespace, provide ways to export product data as files which can be used as Adacado data feeds. Some platforms also have plugins which automate the process for you so that when you update products on your site, the feed is automatically updated! 

Make Your Own

Another common option is to create your own feed using a spreadsheet. This option works best when you only have a few products or services you want to advertise.

Still No Feed?

You can create a simple ad with one set of text and/or images, these types of ads don’t require a data feed. Check out our guide on creating static ads.

Adding a Data Feed

Within your campaign, click the Product Data button on the bottom of the screen.

Data Feed Settings

The platform will prompt you to choose a protocol in the dropdown menu, HTTP/HTTPs or FTP. Currently, we do not support SFTP.

Feed URLs With HTTP/HTTPs

Choose this method if your data feed can be accessed as a URL beginning with the letters “HTTP” or “HTTPS”. If you are using a Google Sheet this is the method to choose. 

Enter your URL into the field to the right of the protocol selection.

Click “Fetch Sample”.

Feed Hosting on FTP

If your feed is being stored on an FTP server then this is the option to choose. 

Enter your FTP credentials. You will need the Host Address, Username, Password and File Path. See the image below for an example of what the FTP credentials might look like.

If your data feed file is in the root directory of the FTP then simply enter the filename and extension into the File Path field. If your file is located within a sub-directory of the FTP, enter the path to your file as in the example below.

Click “Fetch Sample” after entering the FTP credentials.

Campaign-Only Product Data

If you are creating multiple campaigns for an advertiser, and you want to use entirely different data for a campaign, you can choose to use a separate feed for a particular campaign. In the Product Data settings, choose “Add and use products only for this campaign”.

Mapping a Data Feed

In order to bring your product information into Adacado you will need to map Adacado’s pre-defined data fields to the columns/headers in your feed. This is an important process as the data fields you use will determine the product data available to use in your ads both visually and in terms of campaign objectives like retargeting.

If you are using a Google XML feed, then the system will automatically map your data and you can skip this step.

Data Fields

Data Fields in Adacado are predefined labels which you can associate to the columns/headers in your feed. The available Data Fields will vary depending on the advertiser’s business type.

The following table shows examples of how a data feed might be mapped to Adacado Data Fields. 

Mapping Data Fields

1. Choose the Delimiter

Select a data delimiter after fetching the sample feed.

  

A delimiter is a sequence of one or more characters and it specifies where the boundary between separate regions should be. For example, a comma or a tab to separate these distinct values. If your file format is a CSV(comma-separated values), choose “By comma”. You can also enter the delimiter manually by selecting “Custom”.

2. Map Relevant Fields

After selecting the delimiter, Adacado will attempt to automatically map the relevant data fields to the headers of your data feed.

  

Data fields can be added, moved or removed from the column headers. Drag the data fields around until all the important data in your feed has been mapped. Make sure to map your Product Link, as this is a mandatory field!

The actual information that will be shown in your ads depends on the theme and templates you use. Having a column header mapped doesn’t mean that the information from that column will be shown in your ads, instead it means that it is available to be shown or used, depending on the creative and campaign objective you choose. It is always better to map more fields than less, as this gives you more options later on.

Important: 

The data fields mapped to your feed are each connected to a specific position in the spreadsheet, not to the column name. If you modify your data feed by moving, adding or removing columns then your product data may be negatively affected. If it is necessary to make such changes to your data feed, be sure to return to the product settings page and remap the data fields to the new feed structure.

3. Save Your Settings

Once the mapping is done, click on the “Save and Continue” button in the top right corner to run your feed and add product data to the Adacado system.

  

Filtering Products

Optionally, you are able to set up product filtering for your campaigns. This is helpful if you only want to use some of the product data in your feed for the ads in your campaign.

Updating a Data Feed

To ensure that your ads display the right content and that your campaign goals are working as expected, it is important to keep your data feed up-to-date with the latest product information.

Adacado will automatically import product data from your feed on a daily basis. If you want more control over when and how frequently your data is updated you can adjust the schedule settings. It is also possible to manually force an update.

  

Scheduling Data Feed Update

Scheduling is especially important for advertisers with large volumes of inventory and stocks that are constantly changing. Feed update times are based on the time zone set for each advertiser. 

Check with the advertiser or feed provider to find out how often the feed is updated and when updates are expected to be complete. Then, schedule Adacado to process the feed after the update is finished.

For example, if your feed provider finishes updating your data feed at 9am daily, then a 9:10am schedule in Adacado would be a good choice.

Forcing Data Feed Update

If you need to display updated product information immediately in your ads, you can force a feed run with this simple trick.  

When Product Setting changes are made and saved, your data feed will automatically run and update your product information.

The easiest way to do this is to make a small change to the time for the data feed schedule. Changing the time by 5 minutes is enough to trigger the save button to activate. You can always change it back afterwards if you want.

Click on the “Save” button in the top right corner to run your feed and update your product data in the Adacado system.

Checking Data Feed Runs

Check the bell icon next to your account name in the header to see if and when data feeds have been processed.

Checking Products

After setting up your data feed, you can check the product data by clicking the Product Data button on the bottom of your campaign. Keep in mind that if there are many items in the feed, it may take some time to complete the feed run and import all information.

The products page will show you the products available to use in your ads.

FAQs

If you’re not sure where to start, we recommend using Google Sheets to create your CSV data feed. Check out our guide here!

If you need to create image URLs for your products or services, there are many options to choose from. Check out our guide here to get more information.

CSV files can only have one tab. If you are using Google Sheets, check out our guide here on how to use multiple tabs in a Google Sheet.

Sometimes image processing takes a bit of time to complete. Please allow a bit of time for the system to process your data.

Please double check that your data fields are mapped properly. If everything looks good, you can force a data feed update as described here.

Please double check to make sure your share settings are set to “anyone with the link”.

Please double check that your data fields are mapped correctly on the product settings page. If you have changed the position or number of columns used in your spreadsheet, then the mapping will need to be updated as this can cause the wrong information to be used. Use the “Clear Mapping” button on the product settings page and then remap your data fields.

If you’re still having trouble or have questions, feel free to reach out to us anytime at support@adacado.com