> 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/sklik.md).
# Sklik
How to connect Sklik to Roivenue, what the connector downloads by default, how the data is shaped once it arrives, and every column it can bring in.
Sklik is Seznam's advertising platform, covering its search and content networks. The Roivenue connector downloads daily performance data from it using a Sklik API token.
This page covers connecting the two, what the default setup brings back, and which columns are available.
## Setting up the connector
### 1. Generate an API token in Sklik
Open your Sklik account settings.
Generate the API key, then copy it.
{% hint style="warning" %}
If an API key already exists, use that one. Generating a new key invalidates the old one, which breaks any automatic reports you or your agency already run against it.
{% endhint %}
### 2. Paste the token into Roivenue
Add a Sklik connector in Roivenue and paste the token into the API token field.
### 3. Choose the Sklik account
One token can reach several Sklik accounts, so Roivenue asks which one this connector should read. Pick the account, then finish the rest of the setup.
## What the default setup downloads
Creating a Sklik connector from the recommended template gives you two jobs. Both read ad group level statistics across search and display together.
| Job | What it brings back |
| --------------------------- | ------------------------------------------------------ |
| Sklik Ad Groups | Impressions, clicks and cost, per ad group and day |
| Sklik Ad Groups Conversions | Conversions and conversion value, per ad group and day |
Conversions sit in their own job because Roivenue records them against a single conversion type, which you pick when setting the connector up and which then applies to every row that job produces. Tracking a second conversion type means a second connector.
### Where the values land
| Sklik column | Roivenue column |
| ----------------- | --------------- |
| `Date` | date |
| `CampaignName` | adCampaign |
| `GroupName` | adGroup |
| `Impressions` | impressions |
| `Clicks` | clicks |
| `Price` | cost |
| `Conversions` | conversions |
| `ConversionValue` | conversionValue |
Every row is also stamped with Sklik as the platform and CZK as the currency.
### Zboží.cz campaigns are left out
The separate Zboží.cz connector already covers those campaigns, so both default jobs filter out any campaign whose name contains Zboží.cz. Leaving them in here would count the same spend twice.
### When the data refreshes
The jobs run every day at 04:00 in the account's timezone. Each run reprocesses the last three days rather than yesterday alone, so figures for recent days can still change for a couple of days after they first appear.
When a connector is first set up, Roivenue backfills history as well, asking Sklik for up to three years. How much actually comes back depends on what the Sklik API still holds for the account.
## How the data arrives
* Roivenue downloads one day at a time and keeps only the rows dated to the day being processed.
* Days with no activity produce no row. Roivenue asks Sklik to leave out empty statistics, then drops any row with no impressions, no clicks and no spend. An entity that did not run on a given day is absent for that day rather than present with zeros.
* Money arrives in whole crowns. Sklik reports money in hellers, and Roivenue divides by 100 on the way in, so `Price`, `Cpc`, `ImpressionMoney`, `ClickMoney` and the budget columns are all in CZK.
* Campaign, ad group, ad and keyword identifiers come through alongside the names, so renaming an entity in Sklik does not split its history in Roivenue.
## Changing what you download
A connector downloads one report level for one network selection. Covering several levels means setting up several connectors, one per level.
### Report level
The level decides what a row represents and which columns exist. The default template uses Groups.
| Report level | One row per | Columns available |
| ------------ | ---------------- | ----------------- |
| Campaigns | campaign and day | 43 |
| Groups | ad group and day | 47 |
| Ads | ad and day | 35 |
| Keywords | keyword and day | 32 |
### Network
| Network | What it covers |
| ------------------ | ------------------------------------ |
| Search | The Sklik search network on its own |
| Display | The Sklik content network on its own |
| Search and Display | Both networks, combined into one row |
{% hint style="warning" %}
The Groups level works only with Search and Display. The Sklik API cannot split ad group statistics by network, so a Groups connector set to Search or Display stops with a configuration error instead of returning partial data. This is why the default template combines both networks.
{% endhint %}
### Columns
By default a connector brings back every column available at its report level. To narrow that down, list the ones you want in the `fields` section of the connector query using the Advanced Editor. Naming a column that does not exist at the chosen level stops the connector with an unknown column error, so the tables below are worth checking first.
{% hint style="danger" %}
A connector edited in the Advanced Editor stops receiving template updates.
Roivenue ships improvements to connectors by updating the shared template a connector is built from, and only connectors still configured by that template pick those updates up. Once a connector is switched to advanced mode, its fields and transformations belong to you: new columns, corrected mappings and changes to the default transformations will not reach it.
Use the standard settings where they cover what you need, and the Advanced Editor where they do not.
{% endhint %}
## Available columns
The tables above are what the recommended template downloads. Every column this connector can bring back is listed on [Sklik - Supported Columns](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/sklik/sklik-supported-columns.md).
Adding one means editing the connector in the Advanced Editor, which stops that connector receiving template updates.
## Troubleshooting
The connector reports an invalid API token
Sklik tokens are tied to the user who generated them, and generating a new token in Sklik invalidates the previous one. If someone has regenerated the token, any Roivenue connector using the old one stops working, as do any other automatic reports that relied on it.
Generate a token once, then reuse it. If you do need a new one, update every connector that uses it.
The connector stops with a configuration error about report level and network
This is the Groups restriction described above. Set the network to Search and Display, or change the report level to Campaigns, Ads or Keywords.
A campaign or keyword is missing from the data
Three ordinary explanations come first. The entity may have had no impressions, clicks or spend that day, in which case there is deliberately no row. It may not exist at the report level you chose, since a keyword never appears in a Campaigns report. Or it may be a Zboží.cz campaign, which the default jobs filter out.
Beyond those, Sklik occasionally rejects individual items with a request-too-large error, even when they are requested one at a time. Roivenue retries the batch item by item and skips the ones that keep failing, so the download completes rather than failing outright. Those skips are recorded in the job log.
The numbers do not match what I see in Sklik
Check these in order:
1. Zboží.cz campaigns, which the default jobs exclude and the Sklik interface includes.
2. The network. A connector set to Search excludes the content network entirely, and the Sklik interface usually shows both.
3. The report level. Statistics differ between levels, because a campaign total is not the sum of its keywords.
4. Recent days, which are still being reprocessed for up to three days after the fact.
5. Rows with no activity, which Roivenue leaves out and the Sklik interface may show as zeros.
If none of these explains the difference, your Account Manager can compare the downloaded data against the Sklik report with you.