Integration of Ceneo with BigQuery
Connect Ceneo to Google BigQuery in WitCloud and collect click data per shop to analyze the performance of your Ceneo campaigns.
Updated
Introduction
This integration connects Ceneo with Google Cloud BigQuery. It collects your Ceneo click data (clicks, bid rates, click costs and positions) per shop, so you can analyze it next to the rest of your data in WitCloud.
Configuration guide
Follow the steps below to connect Ceneo with BigQuery. Once the setup is complete, your Ceneo data will be transferred to your BigQuery project.
Make sure you have the username and password of your Ceneo account before starting the configuration.
Module setup
Go to Integrations in the menu and click Add integration.

Select Ceneo from the list of available integrations.

Enter the Collect name, e.g. "Ceneo PL".

Authorization
If you have previously authorized the Ceneo module and do not need additional permissions, skip this step and choose the existing authorization from the Select Ceneo authorization list.
Click Authorize.

Enter your Ceneo Username and password in the Authorize form and click Create.

Select the shops you want to collect data for from the Select shops list. You can select several shops; a separate data collect is created for each of them, named after the Collect name and the shop (e.g. "Ceneo PL - Demo Store PL").

Optionally click Show advanced settings. The Tables to collect field lets you narrow down the tables you collect; all are selected by default and at least one is required. The Today's data available switch is off by default: turn it on if Ceneo already has data for today, otherwise today's data is not collected.

Click Next.
Historical data and scheduling
In the Historical Data field, enter the number of days for which you want to fetch historical data. You can enter up to 365 days.

A data synchronization schedule will be created automatically. More information on this topic can be found here.
Click Create to complete the configuration.

Done! Your Ceneo data will now be synchronized with BigQuery.
Data schema
Expand the table below to view the full data schema collected from Ceneo.
Data schema for ceneo_clicks
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATETIME |
| shop_id | NULLABLE | STRING |
| shop_name | NULLABLE | STRING |
| main_category | NULLABLE | STRING |
| second_category | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| click_rate | NULLABLE | FLOAT |
| bid_rate | NULLABLE | FLOAT |
| click_cost | NULLABLE | FLOAT |
| position | NULLABLE | INTEGER |
