Have you ever thought about using data like margin, net price and similar for the product promotion? Do you have an internal system with valuable product data, but you can't or don't know how to connect it to the product feed?

ROI Hunter can help you out. You don't need to bother your IT department or pay expensive external service. You can do it on your own in a few minutes 💪

Use cases

Business data

When you provide data like margin, net price, competitors price comparison, amount of items in stock you will get your product promotion to the new level. Optimizing according to this data is a game-changer since you will be pushing products not just according to its revenue but according to real profitability. 📈 We know that this kind of data is sensitive, so we can anonymize it. 

Technical help

We know the situation 😉. You want to change/add data into your feed but your IT guy is overloaded so you are waiting and waiting and your request will be proceeded after month....or never 🙃 

Product list

Sometimes you have some list of products to be promoted (weekly sales, best price products, outlet, stock cleaning, etc) It can be tiring to filter them on product set level according to their IDs because you need to manually update a product set whenever there is a change in the product list. If you integrate the list directly to the catalog, changes will be proceeded automatically and no extra attention from your side is needed 🙂

Additional images

Do you have a new image collection, but it is difficult for you to add them to the feed? We can help with it too.

Override source feed

Do you have too long product titles in your automatically generated product feed? Do you need your product URL to contain a special tag? You can simply override the data in your source feed by using a field from additional data source within Feed Mapping. You can also define a Fallback function to the original field, in case the additional data source contains only a subset of products.

How it works

Open the catalog in ROI Hunter Catalog Manager, select "Data sources" from the left menu and in the section "Additional feeds", click "Connect new". You will need a URL leading to your file.

You can pair the data in your Additional Feed to various labels in your main feed. If you have data for specific products, you pair it to retailer_id. If you have data for product groups, you pair it to item_group_id and all the products from this group will get the data. You can pair the data even to category or availability label, which can be useful for Dynamic Ad Copy Schedule.

If the files is protected by credentials or encrypted, please provide security details.

You need to set the name for your additional source for better overview, as you can connect multiple sources to the same catalog. The source name will be then visible in Product insights.

How to create a data file

You should create some file with desired product info and post it somewhere, so it will be accessible from the URL. The only supported format is .csv. If you have a company domain, post it there. It can be stored the same way as your current product data feed file.

Another simple option is to use Google sheets (no need to have domain). When you create a data sheet, don't forget to share it for everybody with link and publish it as .csv format and send us the published link.

Watch our step-by-step tutorial on how to prepare the file:

Note: Please be aware that the Google Sheets additional source cannot be secured.

How the data file should look like

Example file: https://docs.google.com/spreadsheets/d/1EcxLi7izyqBfBJKqd5PQwxFtvQy4RlxHI192kjiwEY4/edit#gid=98860218

Example file in published format (send us this one):
https://docs.google.com/spreadsheets/d/e/2PACX-1vRkwxrwbDQPE0mIBbT9RMhy79CUnk8OyimRfxlrrS5Sw7bTZUxQI9e6Qc2bj-wGBAtmNWoO1I47uEbQ/pub?output=csv

  • We need to pair your data with products so the first column must contain the id of the product - retailer_id from your catalog. 

Example of CRM data:

Example for Product list:

  • Other columns are dedicated to your data. You will see this data in ROI Hunter in Product Insights and Product Picker. You can use it in your filter when creating product set. ROI Hunter will encode your filter into ROI Hunter Custom Label. So, your custom data won't be sent to Facebook. You also don't need extra tags for custom data in your feed. You need only one for the ROI Hunter Custom Label.

Additional sources containing sensitive data

If you don't like the idea of publishing sensitive data for your business, there are few ways you can secure them.

Use Basic Authentication

Basic authentication is the prompt for username and password you can sometimes see when you open a link in your browser. We would need a username and password on our side to be able to download the data to our system. 

AES encryption

The whole custom source is encrypted, and we only need an encryption key. It can be encoded in Base64 and shared with us.
Specifics:

  • AES-256 in CBC mode

  • 16B blocks

  • 32B key

  • 16B initialization vector preceeding the cipher text

  • padding PKCS#7

Example:

  • Key (Base64): FkEPqX8/1AV6qekr6ewSXJCLwUfjpEZWPqZENvLmIyI=

  • Plain text: Hello world

  • Cipher text (Base64): zOQHE5EYo/Fy3fmiRI7WIkBL/TPYRAAoCOwk6Ksk0QE=

FAQ

Q: I have fresh data in my custom file every day. How often you are syncing custom file with product feed?
A: Data is refreshed independently of your main feed. Any update from the custom source gets synchronized to your catalog. By default, we check your custom source every two hours.

Q: Is there any limitation of using Additional Product Data Source for API integrated catalogs

A: No, everything works exactly the same way as for catalog with product feed.

Q: Where I can see that the Additional Product Data Source is connected to my Product Catalog?

A: You can see this information in Catalog Manager - on Data sources page. Here you can also manage all your connected sources.

Q: Is it possible to pair data to categories, brands or product groups?

A: Yes, the data can be paired to any label in your main feed - even custom labels or availability.

Q: What do I need to do when I add a new column to my Additional Product Data Source (i.e. I already have margin and I add stock level info)?

A: Nothing. The data will be automatically added, and you can use it in product set.

Q: Can I connect only one Additional Product Data Sources to my Product Catalog?

A: You can connect multiple different sources.

Q: Can I use only CSV format, or is XML also possible?

A: CSV format is the only supported currently.

If you have any other questions or use cases, let us know via the chat button, and we'll find a tailored solution together 🤗

Did this answer your question?