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.
Caution
This destination is available for sending offline events to Pinterest Ads Manager after it is configured by a Datagrid Operator or your Amperity representative.
If this destintion cannot be selected from the campaigns editor or activations canvas ask your Datagrid Operator or Amperity representative to configure a destination for sending sending offline events to Pinterest Ads Manager.
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:
1SELECT
2 mc.TO_HEX(SHA256(TO_UTF8(LOWER(TRIM(email))))) AS EMAIL
3 TO_HEX(SHA256(TO_UTF8(LOWER(TRIM(mc.email))))) AS email
4 ,ut.order_datetime AS event_time
5 ,'checkout' AS event_type
6 ,'offline' AS event_source
7 ,ut.order_revenue AS value
8 ,ut.order_id AS order_id
9 ,ut.order_quantity AS quantity
10FROM Merged_Customers mc
11INNER JOIN Unified_Transactions ut
12ON mc.amperity_id = ut.amperity_id
13WHERE 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.