Criteo

Criteo is a commerce media platform for running retargeting, prospecting and retail media campaigns across the open web. With Weld you can sync your Criteo advertisers, campaigns, ad sets, ads and creatives into your data warehouse, together with daily performance statistics at campaign, ad set and ad level. Combine it with your ecommerce, analytics and other ad platform data to report on spend, revenue and return on ad spend across all your channels.

Features

Data Schema

Setup Guide - ELT

Step 1 - Create a Criteo API app

1. Sign in to the Criteo Partners Portal and open My Apps.
2. Click Create a New App and give it a clearly identifiable name, such as Weld, and an optional description.
3. Choose Client Credentials as the authentication method.
4. Under Services, select C-Growth and Marketing Solutions.
5. Under Domains, grant Read access to the analytics, campaign and creative domains. Weld does not need Manage access to anything.
6. Click Activate App.

Step 2 - Grant the app access to your advertisers

The app can only read data from advertiser accounts that have approved it.

1. On the app's page in the Partners Portal, click Generate new URL to create a consent URL, then copy it.
2. Open the URL yourself, or send it to an Admin of the advertiser account. Each consent URL can only be used once — generate a new one for every person you send it to.
3. The Admin signs in to Criteo, selects the advertiser account(s) Weld should have access to on the Access request page, and clicks Approve.

Weld syncs data from every advertiser account that has approved the app. To add another advertiser later, repeat this step — no changes are needed in Weld.

Step 3 - Create your Client ID and Client Secret

1. On the app's page in the Partners Portal, click Create new key.
2. A text file containing your Client ID and Client Secret downloads automatically. The secret is only available in this file — if you lose it, create a new key.

Step 4 - Create the connection

1. In the Weld app, navigate to Connections and click + New Connection.
2. Search for Criteo and select it.
3. Enter the destination schema name of your choice. This name is used to identify the connection in future syncs.
4. Enter your Client ID and Client Secret from the downloaded file.
5. Click Connect to validate the credentials and establish the connection.

Step 5 - Data To Sync

Select the tables you wish to include in the sync. You can view the schema, remove columns or hash sensitive information.

Account structure

• advertiser — the advertiser accounts the app has been granted access to
• campaign — campaigns, including their goal, budget automation and spend limit settings
• adset — ad sets, including their schedule, bidding, budget, attribution and targeting settings
  • adset_scheduled_budget comes along with adset and holds each ad set's scheduled budgets, linked on adset_id
• ad — ads, linking a creative to an ad set

Creatives

• creative — the creatives for each advertiser, with their format and status
  • Selecting creative also syncs the following tables, linked on creative_id and advertiser_id:
    • creative_image_set — image sets on adaptive creatives
    • creative_layout — layouts enabled on adaptive creatives
    • creative_adaptive_logo — logos on adaptive creatives
    • creative_dynamic_logo — logos on dynamic creatives
    • creative_video — videos on adaptive creatives
    • creative_html_tag_attributes_tag — HTML tags on HTML tag creatives

Performance statistics

• campaign_statistics_daily_report — one row per campaign per day
• adset_statistics_daily_report — one row per ad set and campaign per day
• ad_statistics_daily_report — one row per ad, ad set and campaign per day

Each statistics table contains:

• date and the report currency
• the ids and names of the campaign, ad set and ad it breaks down by, such as campaign_id and campaign
• the full set of Criteo metrics, including displays, clicks, cost, visits, sales and revenue across Criteo's attribution windows, conversion rates, cost per order, ROAS, app installs, viewability and video metrics

To add campaign, ad set or ad details to the statistics, join campaign_id, adset_id and ad_id to the id column of campaign, adset and ad.

Step 6 - Configure sync

1. Select how often you would like the data to sync.
2. Choose the Currency that all monetary metrics in the statistics tables are reported in. This setting is required.
3. Optionally, choose a Timezone that determines how statistics are grouped into days. If you leave it empty, days follow UTC. To match what you see in the Criteo UI, pick the same timezone as your advertiser account.
4. Choose a start date for the statistics tables. Criteo only provides statistics for the last 2 years, so if you leave it empty or pick an earlier date, Weld syncs the last 2 years of data.
5. Provide a unique destination table name.

Weld will take over from here and commence syncing data from your Criteo account.