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/disable to import normalized costs report.

Import “Campaign Performance” report (9) - enable/disable to import statistics on costs, without normalizing the values ​​in the table.

Where to get data on advertising costs

The data for the normalized costs report will be written to a table named criteoCosts_{ADVERTISER_ID}_{YYYYMMDD}

The data for the “Campaign Performance” report will be written to a table named criteoCampaignPerformance_{ADVERTISER_ID}_{YYYYMMDD}

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

  1. Sign in to your account on https://marketing.criteo.com.
  2. Click Criteo Management Center and select Account Settings:

  3. Navigate to the API Users — REST API (New) section. Click Create API User:

  4. Enter [email protected] as a сontact email.  
  5. In the Select a role field, select View Only. Click Add User:

  6. 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.

  7. Check the I confirm having stored my credentials box.
  8. Click Close.