Audience snapshots provide a record of membership history over time.
After each sync of an audience, snapshotting sends the IDs of audience members to a table in your data warehouse.
The snapshots don't contain any customer data beyond audience members' IDs.
Audience snapshotting requires WRITE permissions to your data warehouse.
Because of this, Hightouch only takes snapshots of audiences built off sources
that have the Lightning sync engine enabled.
Each table row contains the audience member's ID, the timestamp of when the snapshot occurred, and either an enter or exit event type.
An audience's first snapshot records current membership in the form of enter events for every member.
Subsequent snapshots only contain changes to membership—either enter events for new members or exit events for members who aren't present in that snapshot but were in the previous one.
Snapshots for all audience members in all audiences are stored in a single table called hightouch_planner.audience_membership with the following schema:
Column
Type
Description
ht_row_id
string
The primary key of the user. This is stringified for consistency if the underlying type isn't a string.
ht_audience_id
string
The ID of the audience.
ht_timestamp
timestamp
The time at which the user entered or exited the audience.
ht_event_type
string
enter or exit depending on the type of event recorded.
ht_split_group
string
The split ID that this user is a member of. If the audience doesn't have splits, the column value is null.
To enable audience snapshots, navigate to the Sync log tab on your source's details page.
Ready to get started?
Jump right in or a book a demo. Your first destination is always free.