Send events to Criteo

Send first-party audiences to your Commerce Growth seat at Criteo. Connect with relevant audiences actively in-market for products and services, retain customers with personalized ads and seamless omnichannel experiences that drive repeat purchases and long-term value, and personalize advertising to visitors who leave your website without making a purchase.

A large percentage of retail sales take place in stores. By providing transactions data for sales that occurred in stores to Criteo your brand can use the Criteo identity graph to deterministically match online shoppers to events that led to a purchase. You can send events to Criteo as a CSV or TSV file using SFTP.

Review the requirements for using SFTP to send transactions data to Criteo , and then configure Amperity to connect to Criteo using the SFTP destination.

Caution

This destination is available for sending events to Criteo after it is configured by a Datagrid Operator or your Amperity representative.

If this destination cannot be selected from the campaigns editor or activations canvas ask your Datagrid Operator or Amperity representative to configure a destination for sending events to Criteo.

Build a query

After the SFTP destination is configured, use a query to map a customer’s email address and transactions data to the fields that can be sent to Criteo. For example, send only events from the previous day to Criteo:

WITH cte_last_version AS (
  SELECT VERSION
  FROM amperity_table_versions
  ORDER BY created_at DESC
)

SELECT
  user_key_1
  ,user_key_type_1
  ,user_key_2
  ,user_key_type_2
  ,event_id
  ,DATE_FORMAT(event_time,'%Y-%m-%dT%H:%i:%sZ') as event_time
  ,content_ids
  ,product_value
  ,product_quantity
  ,store_id
  ,currency
FROM Criteo_Offline
WHERE brand = 'Socktown'
AND event_time >= DATE_ADD('day',-2,CURRENT_DATE)

EXCEPT

SELECT
  user_key_1
  ,user_key_type_1
  ,user_key_2
  ,user_key_type_2
  ,event_id
  ,DATE_FORMAT(event_time,'%Y-%m-%dT%H:%i:%sZ') AS event_time
  ,content_ids
  ,product_value
  ,product_quantity
  ,store_id
  ,currency
FROM Criteo_Offline_versioned
WHERE amperity_version = (
  SELECT DISTINCT version
  FROM amperity_table_versions
  WHERE offset = 1
  AND table_name = 'Criteo_Offline'
)
AND brand = 'Socktown'

Use an orchestration to send the events data to Criteo using the SFTP destination.

Important

Validate the audience with Criteo by using a sample audience with a very small membership. For example: 10 or 100 members or the minimum audience size recommended by Criteo. Send the sample audience to Criteo and verify the sample audience is correct in Criteo. Make adjustments if necessary. Only send full audiences after validation is complete.