Docs

Criteo Ads Data Export

What is Criteo Ads?

Criteo is a commerce media platform providing displays interactive banner advertisements. These ads are generated based on the browsing preferences and behavior of customers. Criteo ads can be deployed across websites, social media, and apps providing an ideal way to deliver a seamless, cross-channel experience.

How to add a Criteo Ads Source in Electrik.AI?

Follow these steps to connect your Criteo account to Electrik.AI

Step 1: Ensure you have the following prerequisites to create a Criteo Ads Connection in Electrik.AI

a. Criteo Account Client Id & Client Secret.

Step 2: Sign-in into your Electrik.AI account.

Step 3: Select IO in Electrik.AI dashboard.

Select IO in Electrik.AI dashboard

Step 4: Select the Connections Icon in the left most panel and click on “Add” button the top.

Select the Connections tab in the left most navigation bar & click on “Add” action button

Step 5: The Source default tab is selected just click on “Criteo Ads” connection.

Conn Step 5 The Source default tab is selected just click on Criteo Ads connection - ElectrikAI

Step 6: Enter Client Id and Client Secret of your Criteo Ads account.

Conn Step6 Enter Criteo Ads Id and Password - ElectrikAI

Step 7: Click on Choose Advertising Profile and select your profile from dropdown.

Conn Step7 allow access your Criteo Ads - Electrik AI

Step 8: Click on the Save button on the top.

Conn Step8 Criteo Ads Account from the dropdown - ElectrikAI

Congratulations, you have now successfully created a Criteo Ads Connection in Electrik.AI

Conn-Congratulations, you have now successfully created a Criteo Ads Connection in - ElectrikAI

What are the supported Data Destinations?

Electrik.AI supports the following destination to export Criteo Ads Data.

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI
EletrikAI

How to export Criteo Ads Data?

Electrik.AI creates a data flow (or ETL process) that exports Criteo Ads performance reports of your choice to a target database or data warehouse. This process runs daily at scheduled time and exports data for the previous day.

Follow these steps to create a Data Flow from Criteo Ads to any Destination

Step 1: Ensure you have the following prerequisites.

  1. Access to Criteo Ads account.
  2. Criteo Account Client Id and Client Secret.
  3. Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery.)
  4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password.

Step 2: Sign-in into your Electrik.AI account.
Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 4: Click on the Add button to create a Criteo Ads Performance Data Extractor Flow.

Click on Add button to create a Flow

Step 5: Select Criteo Ads Connection present in the list of available sources.

Select Criteo Ads Connection - ElectrikAI

Step 6: Select your existing Criteo Ads connection in Electrik.AI.

Select your existing Criteo Ads - ElectrikAI

To Configure a new connection, refer to this link.

Step 7: Click on a destination of your choice from list of available destinations.
In this example we are choosing BigQuery.

Flow Step 7 Click on a destination of your choice from list of available destinations ElectrikAI

Step 8: Select your existing BigQuery connection in Electrik.AI.
To Configure a new connection, refer to this link.

Flow Step 8 Select your existing BigQuery connection in ElectrikAI

Step 9:

a. Choose the desired report to get the appropriate data. In this example we are choosing all.

Choose the desired report to get the appropriate data of Criteo Ads - ElectrikAI

b. Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.
Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By Default, Electrik.AI uses the signed-in user’s Email Id.

Review the Data of Criteo Ads - ElectrikAI

Note: By Default, Electrik.AI chooses an existing Data Set to load your Criteo Report. You can create a new Dataset in your bucket by selecting the “Create Data Set” radio button.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

Congratulations Flow is created for Criteo Ads - ElectrikAI

You have now successfully setup Criteo to BigQuery Data Warehouse flow in Electrik.AI

You have now successfully setup Criteo to BigQuery Data Warehouse flow in Electrik.AI

Your Criteo data will start loading after 24 hours in your Data Set.

Your Criteo data will start loading after 24 hours in your Data Set - ElectrikAI