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 special tag? You can simply override the data in your source feed - use the same field (column) name in your Additional Product Data source and ROI Hunter will use it.

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 URL leading to your file. If it's protected by credentials, please provide them here.

You can name 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. Best format is .csv. If you have a company domain, post it there. It can be stored 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 publish it as .csv format and send us the published link.


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

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

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: Currently, pairing to specific product ID is possible only. We are working on extending the possibilities.

Q: What do I need to do when I add 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?