Criteo Setup Guide
Follow our setup guide to connect Criteo to Fivetran.
Prerequisites
To connect Criteo to Fivetran, you need a Criteo account (Partner Login is not supported).
Setup instructions
Find Client ID and Client Secret
Log in to the Criteo Partner Portal.
On the My apps page, click Create a new app.
Enter an app Name and, optionally, a Description. Click Next.
Select Client Credentials as the authentication method. Click Create.
Select Commerce Growth as the service.
The Commerce Growth and Client Credentials authentication method selections cannot be changed once you submit the configuration.
In the Authorizations section, set every domain to Read access level or above. Click Activate app.
Each domain requires at least Read access for the connection to work. Once you activate the app, you can no longer edit its name, description, or authorizations.
In the confirmation modal, click Activate.
Go to the App settings tab and click Create new key under App credentials. Criteo creates a
.txtfile containing your Client ID and Client Secret. Your browser should automatically download the file. You will need the Client ID and Client Secret to configure Fivetran.
(Optional) Add Custom report
Click + Custom report.
Enter a Report name. The name must be unique within this connection and must comply with Fivetran's naming conventions.
Give the table a name you can easily identify with the report in the future. If you want to enable or disable the sync for a particular report once it is set up, you can do so by selecting its table in the connector's Schema tab.
Select the Report Level you'd like to sync.
Select the Dimensions you'd like to sync.
Select the Time dimensions (aggregations) you'd like to use.
Click Next.
Select the metrics you'd like to sync.
Click Save to add the report.
Finish Fivetran configuration
In the connection setup form, enter the Destination schema name of your choice.
Enter the Client ID and Client Secret you found in Step 1.
Select the currency code using the Currency drop-down menu.
Select the Report Timezone.
Select the Metrics. By default, the basic metric set is selected and displayed in the setup form. You can deselect a metric by clicking the white X icon beside the relevant metric's name. To display the full metric list and select a metric, click anywhere inside the Metrics field.
Select how many months' worth of reporting data you'd like to include in your initial sync.
Click Save & Test. Fivetran will take it from here and sync your Criteo data.