Criteo
Attention! The Google BigQuery integration has to be enabled to use this feature.
Importing data from Criteo
After enabling this data source, Criteo advertising costs information will be uploaded to BigQuery once every 24 hours.
Connecting and configuring
The process of connecting data sources is described in detail in the overview.
In order to connect the data source, you must specify the Client ID (1) and Client Secret (2).
How to create an API account in Criteo
After authorization you need to set the data source parameters.
(1) The name of the data source. It is displayed in the interface in the list of sources.
(2) The currency in which you want to export the costs from the advertising accounts.
(3) Value multiplier. Multiplied by the cost in the final report.
(4) UTM source, which is used in Criteo settings.
(5) UTM medium, which is used in Criteo settings.
Because there is no possibility to get information about utm tags in the Сriteo API, you need to configure UTM campaigns manually, for this you need to input each campaign ID (6) and its corresponding UTM campaign tag (7).
Import normalized costs report (8) - enable normalized costs report import.
Import “Campaign Performance” report (9) - enable costs report import, without normalizing the values in the table.
Where to get data on advertising costs
- criteoCosts_{ADVERTISER_ID}_{YYYYMMDD} - data for normalized costs
- criteoCampaignPerformance_{ADVERTISER_ID}_{YYYYMMDD} - data for “Campaign Performance” report
Tables structure
criteoCosts
| Field name | Type | Mode |
|---|---|---|
| cost | FLOAT | REQUIRED |
| clicks | INTEGER | NULLABLE |
| impressions | INTEGER | NULLABLE |
| utmTerm | STRING | NULLABLE |
| utmCampaign | STRING | NULLABLE |
| utmContent | STRING | NULLABLE |
| utmMedium | STRING | REQUIRED |
| utmSource | STRING | REQUIRED |
| currency | STRING | NULLABLE |
criteoCampaignPerformance
| Field name | Type | Mode |
|---|---|---|
| cost | FLOAT | REQUIRED |
| impressions | INTEGER | REQUIRED |
| clicks | INTEGER | REQUIRED |
| campaign_id | INTEGER | REQUIRED |
| campaign | STRING | REQUIRED |
How to create an API account in Criteo
- Sign in to your account on https://marketing.criteo.com.
-
Click Criteo Management Center and select Account Settings:
-
Navigate to the API Users — REST API (New) section. Click Create API User:
- Enter [email protected] as a сontact email.
-
In the Select a role field, select View Only. Click Add User:
-
A window displaying your Client ID and Client Secret will appear. These are the API user credentials that you need to enter in the SegmentStream admin panel to setup the Criteo data import. Important: Make sure you have saved the Client Secret code somewhere. It’s displayed only once — on this window. After clicking Close, you won’t be able to display it in any way.
- Check the I confirm having stored my credentials box.
- Click Close.