Google Ads can read your Foureyes audiences directly from Snowflake. You connect once, and Google builds a Customer Match list from each audience. No one has to export or upload files.
This article is for the dealership or the agency that runs the Google Ads account.
How it works
Foureyes keeps your audiences up to date in a Snowflake database for your dealership or group.
Google Ads connects to Snowflake with a read-only Foureyes user.
Each audience becomes a Customer Match list in Google Ads.
Foureyes takes care of the data. Your agency takes care of the campaigns.
Which audiences are available
Each account comes with a standard set of audiences. They fall into three groups:
Targeting: people to reach with offers. Examples: unsold opportunities from 60–180 days ago, customers with an aging vehicle.
Signal: good customers to use as a seed for Performance Max and Vehicle Listing Ads. Examples: purchasers in the last 24 months, high-gross purchasers.
Exclusion: people to leave out of sales campaigns. Examples: recent purchasers, customers with an active sales opportunity.
Ask your Foureyes contact for the list of audiences in your account.
Before you start
Your Foureyes contact creates these and sends to you through a secure channel:
Snowflake account identifier
Username
Programmatic Access Token (PAT). Google uses this in place of a password.
The database, schema and view names for each audience
Do not share these credentials by email or chat.
Connect Google Ads to Snowflake
These steps follow Google's help article. Google can change its menus, so check Google's Snowflake instructions if a step looks different.
In Google Ads, go to Tools > Shared library > Audience manager.
Click + Create remarketing list > + Customer list.
Under Data source, select Connect a new data source.
Select Snowflake, then Direct connection. Click Continue.
Enter the account identifier, username and PAT. Click Connect.
Enter the database, schema and view for the audience. Click Next.
Map the fields: email, phone, first name, last name, ZIP code and country.
Name the connection and click Finish.
Name the segment, confirm the policy, and click Save and continue.
Repeat these steps for each audience. Google asks for the credentials again for each new list.
Hashed or unhashed views
Each audience has two versions in Snowflake:
Unhashed: Google cleans the data and hashes it with SHA-256 before it uses it. This gives the best match rate. We recommend this option.
Hashed (view names start with
HASHED_): the data is already hashed. Map the fields as hashed in Google.
In both cases, Google only uses the data to match your customers to Google accounts. See Google's data format rules.
How often the lists update
Foureyes refreshes the audiences in Snowflake every day. Set the Google connection to run on a schedule so the lists stay current.
Troubleshooting
Connection fails or times out: Snowflake may block Google's IP addresses. Ask your Foureyes contact to check the network settings. Google lists its IP ranges in its Snowflake help article.
List is empty or small: check that you selected the correct view. Some audiences are small for some stores, for example expiring leases at a store with few leases.
Low match rate: use the unhashed view so Google can clean the data itself.
Need help?
Contact your Foureyes Performance Manager or Solutions Engineer.