🧮
Data Sources
📈
Segments
🛫
Destinations (app)
Criteo
🏃♀️ Getting Started
This guide shows you how to use Census to connect your Criteo account to your data warehouse and create your first sync.
Prerequisites
- Have your Criteo account ready.
- Have the proper credentials to access to your data source. See our docs for each supported data source for further information:
Step 1: Connect Criteo
Criteo can only be authorized once to any Census instance. In order to create a second connection, you'll need to deauthorize Census first inside the Criteo UI.
- 1.
- 2.Click Add Service.
- 3.Select Criteo from the menu
- 4.Follow the Criteo OAuth authentication flow, which will ask you to log in with your Criteo username and password.
- 5.Once logged in, select the Portfolio's you want Census to have access to and Approve
- 6.Finally once back in Census you'll select the Audience
Once complete, you'll see your new connection in the Service Connections list. 👇
Connections page with Criteo
Step 2: Create your model
When defining models, you'll write SQL queries to select the data you want to see in Criteo. This can be as simple as selecting everything in a specific database table or as complex as creating new calculated values.
- 1.From inside your Census account, navigate to the Models page.
- 2.Click Add Model.
- 3.Enter a name for your model. You'll use this to select the model later.
- 4.Enter your SQL query. If you want to test the query, use the Preview button.
- 5.Click Save Model.
Basic SQL query for a new model
Step 3: Create your first sync
The sync will move data from your warehouse to Criteo. In this step, you'll define how that will work.
- 1.
- 2.Under What data do you want to sync?, choose your data warehouse as the Connection and your model as the Source.
- 3.Under Where do you want to sync data to?, choose Criteo as the Connection and "Static List Membership" as the Object. (See Supported objects for options.)
- 4.Under How should changes to the source be synced?, choose Update or Create. (See Supported sync behaviors for options.)
- 5.Under How are source and destination records matched?, select an Identifier for the model and for Criteo. We recommend using an internal ID when possible. (See Supported objects.)
- 6.Under Which properties should be updated?, choose to update Specific Properties or Sync All Properties.
- 7.Set up the lookup mapping for the Static List and any other properties you want to update by mapping a column in your model to a property in Criteo.
- 8.Click Next. This will open the Confirm Details page where you can see a recap of your setup.
- 9.If you want to start a sync immediately, set the Run a sync now? checkbox.
- 10.Click Create Sync.
When configuring your sync, the page should look something like this: 👇
Sync setup for Criteo
Step 5: Confirm the synced data is in Criteo
Once your sync is complete, it's time to check your data. Open Criteo and check that the Static List Memberships updated correctly.
🗄 Supported objects
Object Name
Supported
Identifiers
Static List Membership
✅
GUM Cookie ID, Mobile Ad ID, Email, LiveRamp Identity Link
🔄 Supported sync behaviors
Behavior
Supported
Objects
Update or Create
✅
Static List Membership
Mirror
✅
Static List Membership
🚑 Need help connecting to Criteo?
You can send our support team an email at [email protected] or start a conversation from the in-app chat.
Last modified 2mo ago