Criteo

Criteo is a re-marketing tool that allows the customer to track user movement and interaction on websites and analyze this data. Criteo uses a transparent cost-per-click model and measures value on post-click sales. This demanding model is supported by ongoing, automated learning of each shopper wherever they are in mobile apps or online, along with your campaign’s performance against thousands of variations of dynamically-created ads. For further information have a look at the Criteo website.

How to Connect

There are two ways to connect to Microsoft Advertising: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.

1. Go to the Sources tab and click + New Source:

2. Find the Criteo button in the list of connectors or type ‘criteo’ in the search field and select it:

3. Enter the data source name, Client ID, and Client secret, and click Connect:

Usage 

The Criteo REST API connector introduces a new virtual schema criteo that contains the following stored procedures:

In addition to these public API procedures, there is the criteo_examples virtual schema that shows an exemplary usage of the public API:

If not needed, you can delete all the example views directly by dropping criteo_examples.