Send offline events to Criteo

Criteo is a commerce media platform that helps marketers and media owners manage and scale campaigns. Send audiences to Criteo, and then advertise to customers across paid media, including connected TV (CTV), banner ads, and video ads.

You can send transactions data (offline 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.

Build a query

After the SFTP destination is configured, use a query to map a customer’s email address and offline sales reporting data to the fields that can be sent to Criteo.

Important

Review the requirements for offline sales reporting before building the query that your brand will use to send offline events to Criteo.

The following example shows what a query that sends offline sales reporting to Criteo may look like for your brand.

SELECT
  c.sha256_email AS user_key
  ,'email' AS user_key_type
  ,uit.order_id AS event_id
  ,uit.item_quantity AS product_quantity
  ,CONCAT('P', substr(prod.product_id, 1, 2, 3)) AS content_ids
  ,uit.item_revenue AS product_value
  ,CAST(uit.order_datetime AS timestamp) AS event_time
  ,uit.store_id AS store_id
FROM Customer_360 c
INNER JOIN Unified_Itemized_Transactions uit
ON c.amperity_id = uit.amperity_id
JOIN Product_Catalog_Table prod
ON uit.product_id = prod.ITEM_ID
WHERE c.email IS NOT NULL
AND uit.is_return = false
AND uit.is_cancellation = false
AND order_datetime > CURRENT_DATE - INTERVAL '1' DAY;

Use an orchestration to send transactions to Criteo using the SFTP destination.