Criteo data source
Before you begin
Make sure that you’ve created an API user in the Criteo Management Center.
- Go to https://marketing.criteo.com/.
- Log in, click Setup ▸ Users.
- Click CREATE API USER.
- Enter an email address and select the “Business Manager” user role.
- Click Add user.
- A confirmation window will open, containing your Client ID and Client Secret, which are required to connect to the Criteo API.
Getting started
- Inside the admin panel click Add Data Source.
- Choose Criteo from the list.
- Authenticate using your API user Client ID and Client Secret.
- Enable required reports.
- Click Save.
Available reports
SegmentStream allows to import the following reports from Criteo.
Campaign performance
Table name
criteoCampaignPerformance_{ADVERTISER_ID}_{YYYYMMDD}
Table schema
Field name | Type | Mode |
---|---|---|
cost | FLOAT | REQUIRED |
impressions | INTEGER | REQUIRED |
clicks | INTEGER | REQUIRED |
campaign_id | INTEGER | REQUIRED |
campaign | STRING | REQUIRED |
Additional transformation settings
Besides default reports import, SegmentStream allows to apply additional transformations for the data and help prepare cost data reports grouped by UTM.
This might be very handy if you need to stitch cost data with website sessions or send cost data into Google Analytics.
To enable this transformation use “Import cost data grouped by UTM” setting. Once enabled, a new table with cost data grouped by UTM will appear in your data warehouse.
Table name
criteoCosts_{ADVERTISER_ID}_{YYYYMMDD}
Table schema
Field name | Type | Mode |
---|---|---|
date | DATE | NULLABLE |
cost | FLOAT | NULLABLE |
clicks | FLOAT | NULLABLE |
impressions | FLOAT | NULLABLE |
utmTerm | INTEGER | NULLABLE |
utmCampaign | STRING | NULLABLE |
utmContent | STRING | NULLABLE |
utmMedium | STRING | NULLABLE |
utmSource | STRING | NULLABLE |
currency | STRING | NULLABLE |
UTM matching for campaigns
Currently, SegmentStream does not support automatic UTM matching for Criteo campaigns. This means that you would need to match Criteo campaigns mannually inside the SegmentStream admin panel.
By default, the following matching applies for utm_source
and utm_medium
:
utm_source
▸criteo
utm_medium
▸cpc
This matching can be changed inside the admin panel by specifying appropriate values UTM source and UTM medium options.
For all your Criteo campaigns you need to define matching between the Campaign ID and UTM campaign.
For example, if you have a Criteo campaign with the Campaign ID = 123123123
with the following link to the website: http://www.site.com/?utm_source=criteo&utm_medium=retargeting&utm_campaign=upper_funnel
, the mapping should be the following:
123123123
▸upper_funnel
This is how it might look inside the admin panel:
This document was last updated on July 20, 2020. If you notice any gaps, outdated information or simply want to leave some feedback to help us improve our documentation, please let us know!