Send offline conversions to Snapchat¶
Snapchat is a social media platform for accessing pictures and messages for a short time. Snapchat offers a self-serve platform from which brands can manage ads and advertising campaigns.
Upload a CSV file that contains offline conversions and meets events file requirements to Snapchat.
Caution
This destination is available for sending offline events to Snapchat 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 Snapchat.
Build a query¶
Use a query to return the fields that align to the events file requirements that are supported by Snapchat for use with offline conversions .
For example:
1SELECT
2 TO_HEX(SHA256(TO_UTF8(LOWER(TRIM(mc.email))))) AS email
3 ,uit.order_datetime AS timestamp
4 ,'purchase' AS event_type
5 ,uit.item_quantity AS number_items
6 ,uit.item_revenue AS price
7 ,uit.order_id AS transaction_id
8 ,uit.item_quantity AS quantity
9FROM Merged_Customers mc
10INNER JOIN Unified_Itemized_Transactions uit
11ON mc.amperity_id = uit.amperity_id
12WHERE mc.email IS NOT NULL
You can download the results of this query directly from the Query Editor in Amperity, and then upload the file directly to Snapchat. Or you can use an orchestration to send the CSV file to cloud storage or an SFTP bucket.