> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/kelkoo.md).

# Kelkoo

How to connect Kelkoo to Roivenue, what the default setup downloads, and how the figures are put together.

Kelkoo is a European comparison shopping service. The Roivenue connector downloads daily clicks, cost, sales and order value for each product category.

## Setting up the connector

Kelkoo does not appear in the self-serve connector list, so the connector is created by Roivenue rather than by you. Ask your Account Manager to set one up.

You will need a Kelkoo API token, which comes from your Kelkoo merchant account, and pass it to them.

## What the default setup downloads

One job, bringing back one row per product category and day.

### Where the values land

| Kelkoo field | Roivenue column |
| ------------ | --------------- |
| `catName`    | adCampaign      |
| `clicks`     | clicks          |
| `cost`       | cost            |
| `sales`      | conversions     |
| `orderValue` | conversionValue |
| `currency`   | currencyCode    |

Kelkoo has no campaigns, so the template puts the product category into the campaign field. Impressions are set to zero because Kelkoo does not report them.

Unlike most comparison shopping connectors, Kelkoo does return sales and their value, so return on spend works here.

The currency comes from Kelkoo rather than being fixed at setup.

## Available columns

The table above is what the recommended template downloads. Every column this connector can bring back is listed on [Kelkoo - Supported Columns](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/kelkoo/kelkoo-supported-columns.md).

Adding one means editing the connector in the Advanced Editor, which stops that connector receiving template updates.

## How far back the data goes

The connector will request up to three years of history. How much arrives depends on what the platform holds for the account.

## Troubleshooting

<details>

<summary>Impressions are zero</summary>

Kelkoo does not report impressions through this connector, so they are set to zero rather than left missing. Cost per click works; cost per thousand impressions does not.

</details>

<details>

<summary>Campaign names are product categories</summary>

That is expected. Kelkoo reports by category rather than campaign, so the category is what lands in the campaign field.

</details>