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.

Integrations list with the Add integration button

Select Ceneo from the list of available integrations.

Integration catalog with Ceneo selected

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

Collect name field filled in with the example name 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.

Authorize button next to the Ceneo authorization field

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

Authorize pop-up with the Username and password fields filled with placeholder values

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").

Select shops drop-down open with two example Ceneo shops

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.

Advanced settings with Tables to collect and the Today's data available switch

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.

Historical Data field filled in with 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.

Data collection settings with the Create button

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 NameModeType
dateNULLABLEDATETIME
shop_idNULLABLESTRING
shop_nameNULLABLESTRING
main_categoryNULLABLESTRING
second_categoryNULLABLESTRING
product_idNULLABLESTRING
click_rateNULLABLEFLOAT
bid_rateNULLABLEFLOAT
click_costNULLABLEFLOAT
positionNULLABLEINTEGER