Import your catalog

Dynamic creatives

Collective Audience™ allows you to create automatic dynamic carousels from your very own product catalog.

Our system will find the most relevant items for a given context, for instance:

  • showing the closest stores that sell your products

  • showing properties to sell closest to the user

Here, you can see an example where a real-estate dealer is showing the closest available properties to users:



As we're filtering and sorting product by relevancy to the user, we need access to your product catalog.

In order to guarantee the user-experience and speed, we need to store the catalog in our optimized databases.

We're able to import your catalog from the following formats:

  • Recommended: CSV (e.g. a database or spreadsheet export)

  • XML (e.g. your RSS feed)

Importing your catalog in the platform

Get in touch with us at [email protected].

In this email please provide:

  • your Collective Audience™ account ID (you can find it in Audience Desk™ navigation menu).

  • your XML or CSV file, as an attachment or a link (attachments are limited to 25MB)

Template

You can download our CSV template to get a starting point.

caution: This CSV use semicolon separator (;) for convenience and to avoid conflicts with columns that may contain lists

Supported columns

column

type

required

comment

vendor_uid

string

✔

The item identifier, it MUST BE UNIQUE (200 characters max)

short_text

string

✔

The item name, it MUST BE PROVIDED but do not need to be unique (250 characters max)

medium_text

string


A short item description (500 characters max)

long_text

string


A complete item description (no limit)

currency

string


The prices currency using ISO 4217 (3 characters)

price

float


The item price (in the currency, e.g. in EUR or USD)

price_start

date


The item price availability start date

price_end

date


The item price availability end date

discount_price

float


The item discount price

discount_price_start

date


The item discount price start date

discount_price_end

date


The item discount price end date

latitude

float


Location latitude of the item

longitude

float


Location longitude of the item

categories

string


Comma separated list of categories (500 characters max)

seller

string


Seller name (100 characters max)

brand

string


Brand name (100 characters max)

url

String


URL of the item (1000 characters max)

main_pic_url_small

string


Small item image URL (1000 characters max)

main_pic_url_medium

string


Medium item image URL (1000 characters max)

main_pic_url_large

string


Large item image URL (1000 characters max)

additional_pic_urls

string


list of item image URLs (no limit)

stock_count

integer


Count of actual item stock

gender

enum


Any value among male, female, other

age

integer


Item age

user_rating

string


Any value representing a user rating (20 characters max)

address

string


Item location address (500 characters max)

zipcode

string


Item location zipcode (20 characters max)

city

string


Item location city (100 characters max)

country

string


Item location country (100 characters max)

note: You may add up to 5 custom columns of type string, number, integer or boolean

Types information:

  • string: any UTF8 characters escaped between double brackets " like "some text"

  • date: a UTC readable date format like: 2021-01-15T10:00:00Z or 2021-01-15

  • number: decimal value like 1234567.89 or an integer like 1234

  • integer: integer value like 1234

  • boolean: unquoted string value true or false

  • enum: like string but restricted to certain values

Using your catalog

Once your catalog is ready, you can start creating dynamic carousels (→ dynamic-carousel) on the platform!