Snowflake to Meta
Prepare Meta Custom Audiences from Snowflake customer history through Amperity, using Snowflake Secure Data Sharing inbound, identity resolution and audience selection in Amperity, and the Facebook Marketing API outbound to Meta Ads Manager.
Meta Ads Manager docsSnowflake Bridge docs
How to send Snowflake data to Meta
Share selected Snowflake history. Configure secure views and an inbound Amperity Bridge using Snowflake Secure Data Sharing.
Define customer audiences. Resolve identity in Amperity and select eligible customers using available loyalty, purchase and permission data.
Replace Meta audience membership. Send mapped identifiers to a named Custom Audience, then configure targeting and advertising in Meta Ads Manager.
Build Meta Custom Audiences from Snowflake customer history
Prepare store-buyer Custom Audiences for Facebook targeting.
Create loyalty-tier Custom Audiences for relevant Meta campaigns.
Refresh existing-customer audiences for configured ad-set exclusions.
Supply customer-list Custom Audiences with resolved identity fields.
What the Snowflake to Meta connection supports
Audience or field | Mapping and behavior | Documentation |
|---|---|---|
Named Custom Audience | Set account ID and audience name; Amperity creates the audience if absent. | |
External customer ID | Map amperity_id to EXTERN_ID using the documented query or campaign mapping. | |
Contact identifiers | Examples: email → EMAIL and phone → PHONE. Check the full required mapping; Amperity normalizes and hashes documented fields. | |
Membership replacement | Replace Users replaces existing members with the customer list sent from Amperity. | |
Customer file source | Declare user-provided, partner-provided, or both sources in destination settings. |
Make Snowflake customer context useful in Meta
Reach store buyers on Facebook
Use store-purchase history shared from Snowflake to identify customers for a relevant follow-up. Prepare their mapped identifiers in Amperity and deliver the audience to Meta. The media team selects the audience and configures the offer, creative, and placements.
Keep loyalty messaging relevant
Build separate audiences for loyalty tiers using data available in Amperity. Send each to a clearly named Meta Custom Audience so the team can apply appropriate targeting or exclusions. Review the replacement behavior when updating an audience already used in active ad sets.
Set up the Snowflake to Meta workflow
Create a Snowflake share with secure views and the correct Amperity account locator for your stack and region. Check supported types before configuring the inbound bridge. Follow the Snowflake Bridge setup.
Authorize Meta through OAuth, accept its Custom Audience terms, and configure account ID, audience name and customer file source. Validate identifier mappings and a sandbox sample; hashing does not establish advertising permission. Follow the Meta Ads Manager setup.