Send offline events to Google Enhanced Conversions

Google Enhanced Conversions improves the accuracy of conversion measurement by sending hashed first-party conversion data to Google using one-way SHA-256 hashing of first-party customer data.

When a customer purchases something from your brand’s website, you likely collect some first-party data from that customer to complete the transaction. For example, a physical address, an email address, a phone number, and a full name.

First-party customer data that is associated with transactions can be sent to Google Enhanced Conversions, after which it can be used to enhance conversion measurement in Google Ads. For example:

  • Track sales and events that happen on a website.

  • Track sales that happen from a website.

  • Match customers to their Google accounts, which were signed-in to when they engaged with one of your ads.

  • Attribute engagment with a Google Ads campaign by matching data collected on your website with the signed-in Google accounts that engaged with your ads.

Build a query

After the destination is configured, use a query to collect first-party data that is associated with transactions. Use SHA-256 hashing for all customer profile fields that are returned by the query.

For example:

SELECT
  SHA256(c.email) AS Email,
  SHA256(c.phone) AS Phone,
  SHA256(c.given_name) AS FirstName,
  SHA256(c.surname) AS LastName
FROM Customer_360 c
JOIN Unified_Transactions t ON c.amperity_id = t.amperity_id
WHERE t.order_datetime >= DATE_ADD('day', -30, CURRENT_DATE)