CONNECTIONS / Redshift / Redshift to Snap Custom Audience
Customer segments in Redshift, activated for Snapchat audience matching.
Grant a scoped IAM role, name the table or materialized view, and Signals matches your segments into Snapchat for targeting and customer suppression with no UNLOAD to S3 and no file to hand off.
- ● redshift → snap.audience :: live
- > read marketing.high_value_customers rows=12,766
- hash sha256(email,phone) consent=filtered
- route snap deliver
- ✓ delivered · 9,830 matched
WHAT THIS ENABLES
Redshift to Snapchat Custom Audience
Redshift to Snapchat Custom Audience: The Redshift Data API reads the customer segments in your Redshift tables, and Signals matches your segments into Snapchat for targeting and customer suppression, hashed and consent-checked as the materialized view refreshes.
- Signals matches your segments into Snapchat for targeting and customer suppression, reading your Redshift tables as the materialized view refreshes.
- Snapchat audiences that stay in step as the segment rebuilds, fed by analytics teams maintaining Redshift tables and materialized views.
WHAT FLOWS WHERE
Redshift to Custom Audience, mapped.
Signals pulls customer segments through the Redshift Data API, hashes and filters every row, and posts the match-ready audiences to Snapchat's Custom Audiences API, keeping list sizing on Snapchat in view.
Signals pulls customer segments through the Redshift Data API, hashes and filters every row, and posts the match-ready audiences to Snapchat's Custom Audiences API, keeping list sizing on Snapchat in view.
Built for the teams that own the number.
Analytics teams maintaining Redshift tables and materialized views who need Snapchat audiences that stay in step as the segment rebuilds.
From kickoff to verified events.
-
Connect
A scoped IAM role with SELECT on the schema you name to feed Snapchat's Custom Audiences API, sized for list sizing on Snapchat.
-
Map
The Redshift Data API reads your Redshift tables, and its columns map to Snapchat's Custom Audiences API in the visual mapper, hashed and checked for list sizing on Snapchat.
-
Deliver
As the materialized view refreshes, Signals matches your segments into Snapchat for targeting and customer suppression, touches only the rows changed since the last read, with list sizing on Snapchat watched in the debugger.
What ships with this use case.
Snapchat audiences that stay in step as the segment rebuilds on every run, since Signals touches only the rows changed since the last read.
Audiences that rebuild as the segment does, delivered as the materialized view refreshes without RA3 load climbing.
Each run returns a match report on list sizing on Snapchat from Snapchat's Custom Audiences API, read from your Redshift tables as the materialized view refreshes, at flat RA3 load.
What Custom Audience actually receives.
- ● signals :: audience upload
- > POST /audience_match source=redshift.marketing.high_value_customers
- schema ["EMAIL_SHA256","PHONE_SHA256"]
- external_audience_id "aud_53240"
- id_list_size 12,766 · matched 9,830
- ✓ accepted match=77%
Adjacent moves on the same stack.
from Redshift
Redshift to Meta Custom Audience
Redshift to Meta Custom Audience: The Redshift Data API reads the customer segments in your…
Learn more
from Redshift
Redshift to Google Customer Match
Redshift to Google Customer Match: The Redshift Data API reads the customer segments in…
Learn more
same use case
ActiveCampaign to Snap Custom Audience
ActiveCampaign to Snapchat Custom Audience: Signals reads your ActiveCampaign contacts and…
Learn moregeneric
Snap Custom Audience
Build and refresh Snap audiences from your CRM, warehouse, or SingleView with hashed…
Learn moreAsked on almost every call.
How often does the Redshift Snap Custom Audience sync run?
The refresh schedule drives it: when the materialized view rebuilds nightly, Snapchat gets a nightly feed, and an hourly refresh runs hourly. Each read touches only changed rows, so Snapchat audiences that stay in step as the segment rebuilds stays fresh for list sizing on Snapchat without RA3 load rising.
What match rate should a Redshift-sourced Snap Custom Audience batch expect?
The fill rate of the view matters more than Redshift itself. A clean hashed email or phone matches; a blank one never will. The first scheduled read reports quality from Snapchat's Custom Audiences API, the figure Snapchat advertisers building lookalikes and excluding current buyers weigh against list sizing on Snapchat.
NEXT STEP