# 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:

 ![](https://s3.eu-west-1.amazonaws.com/outline-assets.collectiveaudience.co/uploads/a579229e-61bc-476b-887f-f4ebec869d46/29fe20a6-368c-4526-a69e-02ba1d41aff6/dco.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIA4G6VWWYWENBOMIQL%2F20261016%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Date=20261016T230000Z&X-Amz-Expires=86400&X-Amz-Security-Token=IQoJb3JpZ2luX2VjECYaCWV1LXdlc3QtMSJGMEQCIFIVLlTsgTg96wh%2B13hbcBBtTjtouLzGHYFUQwAMyGCgAiBZQvQLCUm0fJPROIy9UX0zelwKaJXHduvgCeOJjz9zHirGBQjv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAIaDDgzOTU3NzQxNzI2MCIM0yab%2Fsb9UPYpqt2CKpoFuB%2BEa5MwONKzFCbtf5wiVAAVRaYR9GmGt6NdMSaKWAK2%2BOb%2BLlpx%2F7ratzmo5gOwnpVXaX%2FyyDJmygkNiMOc%2BgpZ%2FhbNJEfn8TloAI3BYdgaAX5xIMxfElG1K1uLvqeo%2F6U%2FmVj2%2BFlCBT9JxUJDO19Xuaen5xUsRewtRqOWeD9x47bV4x5%2BB3O9QDZOk2LC%2Bu7J1NSYWN3qnLJDOWv5tNMbN%2FKBj0FHzZDzZH7Wx80eg81oATJXexfevFkg0pXRaTrdloHnNhzBft1Jrn9Etddl5rA754DWiTULdpjC%2BCcYhEZNmJcWNnzvkFAZZIleU5QyGSJvlUlWAVzPswAhXPHyvnSu27cxmTKXgphDOHTN3Voxp%2FxYNTJk83LqQzjoTrOdS4q4phhD3Hz5eJm9nJkc2ImiYxz2UBGhRx8Zeb4j%2Fi1ml%2BrnZbxzsNegZdlIYVLCr9vbTpCNpOXisVtb%2FBOzaF7YL6fnhiEzCuuHVDISjdVDV46UnRfpFlvSjO15nPzRHDGbfLfADew7iMYlQVec4B3GZp0QCpnqFDXYPKAxUHbIot%2BjO9NK0qaQOMNqkI3fL6IOXYGz0GMTXqL4mPhd3ET5Jb9SwWRUbnOfY1rrkt7JD6Zu%2BgmijASDdnpvxeMND7EvJ9hBwn7eEWbX9VkBVpSM0T7pUbFtsKzecam6yDn6EwCFw2QO1AfSnYyeG%2FFxsQUzj0cXEMuCk%2FryoSOxY2MVnEkK2dQn9cM74B8SQfCRq%2B0c8TK6Mch3CQ29OkUEeGtIh9j%2F4JF3NcqkBAntcbbvH%2BJDXMakkwybgisr7GwsMoidrDxI%2FAwyPpDADt9e8%2BQweALbpQY0mo4GZNaEu0Rc5nAqH1J5OjBbEydoiIMSQHah2UgHMOu0ytYGOrIBA7%2BJIQPrc8lI3Xk%2FuX9wOXXeLdPxQv0gQ5r10iRjh1hC9aT3%2BK%2BLKUDZo0SxrxFWA7bcxdNYA9kBsmm%2F9gA25vfZ4quNROTqd17T3k3NJT7JJGWCTIt3KxpyePhbKVJEXcfWhVOEL2EwBC7cBAcqe5PlBwWAgwnqhyVopkionYKI49pKBD4BxaU0zkBWmMjB0UdxMqY8L8%2Bc0CC3wpqY75IKUc7Y6yqARbgBVuNlQyiHzA%3D%3D&X-Amz-Signature=7aff46a36592cd1bca6d950b7e9848a53dd66b2945f764c1a414eef21f544d3e&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =693x557")


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 [support@collectiveaudience.co](mailto:support@collectiveaudience.co).

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](../static/dl/dco/beop_dco_feed_template.csv) 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](https://en.wikipedia.org/wiki/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!