> 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/gemius.md).

# Gemius

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

Gemius is a European ad serving and audience measurement platform. The Roivenue connector downloads daily impressions, clicks, cost and reach down to creative level.

## Setting up the connector

Add a Gemius connector in Roivenue and sign in with your Gemius username and password.

### Setup options

| Option                   | Default    | What it does                                                                                                                                               |
| ------------------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Client Name REGEX filter | everything | Limits the connector to clients matching a pattern. Useful for an agency account holding several clients, where only one belongs in this Roivenue account. |

## What the default setup downloads

One job, bringing back one row per creative, placement and day.

### Where the values land

| Gemius field    | Roivenue column |
| --------------- | --------------- |
| `CampaignName`  | adCampaign      |
| `CreativeName`  | adName          |
| `PlacementTag1` | adPlacement     |
| `CreativeTag2`  | categoryName    |
| `ClientName`    | accountName     |
| `Impressions`   | impressions     |
| `Clicks`        | clicks          |
| `Cost`          | cost            |
| `uniqueCookies` | dailyReach      |

Gemius reports reach as well as volume. The `dailyReach` column holds the number of unique cookies that saw the campaign that day, which is not something most ad platforms expose.

{% hint style="warning" %}
Conversions and conversion value are set to zero, because this report carries delivery rather than outcomes. Gemius therefore supports spend, reach and traffic reporting, but not return on spend. Take conversions from your own order data.
{% endhint %}

Every row is stamped with EUR as the currency, whatever the account actually bills in.

The job reprocesses the last 45 days on every run, which is unusually long, so Gemius figures should be treated as provisional for about six weeks.

## Available columns

The table above is what the recommended template downloads. Every column this connector can bring back is listed on [Gemius - Supported Columns](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/gemius/gemius-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>Conversions and revenue are zero</summary>

The report the template reads carries delivery data only. Attribute Gemius on spend, impressions and reach, and take conversions from your order data.

</details>

<details>

<summary>Costs are labelled EUR but the account bills in another currency</summary>

The currency is hardcoded to EUR in the template rather than read from Gemius. The figures are whatever Gemius returned; only the label is fixed. Your Account Manager can correct it.

</details>

<details>

<summary>Another client's campaigns are showing up</summary>

Gemius accounts can hold several clients. Set the Client Name filter on the connector so it reads only the one belonging to this Roivenue account.

</details>

<details>

<summary>Numbers for last month changed</summary>

That is expected. The job reprocesses 45 days on every run, so Gemius figures keep settling for about six weeks.

</details>