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.

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.

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

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.

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.

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.

Available columns

The tables above are what the recommended template downloads. Every column this connector can bring back is listed on Sklik - Supported Columns.

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.