Send offline conversions to Pinterest

Pinterest is a visual discovery engine on which your brand can engage with your customers. Send a list of products that are in your product catalog to Pinterest to enable pins, and then send a list of customers with whom your brand wants to engage.

Upload a CSV file that contains offline conversions to Pinterest Ads Manager, after which Pinterest Ads Manager will match campaigns to these conversions so your brand can review total conversions in Pinterest Ads Manager as they relate to all active campaigns.

Tip

Upload this CSV file at least once a month and send conversion data within 30 days of each conversion occurrence to Pinterest Ads Manager. Keep the size of the CSV file under 5 GB with fewer than 10 million rows.

Build a query

Use a query to return the fields that align to the customer and event data fields supported by Pinterest Ads Manager for use with offline conversions.

For example:

SELECT
  mc.TO_HEX(SHA256(TO_UTF8(LOWER(TRIM(email))))) AS EMAIL
  TO_HEX(SHA256(TO_UTF8(LOWER(TRIM(mc.email))))) AS email
  ,ut.order_datetime AS event_time
  ,'checkout' AS event_type
  ,'offline' AS event_source
  ,ut.order_revenue AS value
  ,ut.order_id AS order_id
  ,ut.order_quantity AS quantity
FROM Merged_Customers mc
INNER JOIN Unified_Transactions ut
ON mc.amperity_id = ut.amperity_id
WHERE mc.email IS NOT NULL

You can download the results of this query directly from the Query Editor in Amperity or you can use an orchestration to send the CSV file to cloud storage or an SFTP bucket.