Exposure Log Matching is available to Match Booster customers and must be enabled by Hightouch. to turn it on.
Before you begin
Make sure you have:- An account with a supported ad platform.
- A Snowflake, Databricks, Trino, or PostgreSQL source connected to Hightouch with the Lightning sync engine enabled.
- A model whose primary key is the ID you want to match logs to, such as a customer ID or household ID. In Customer Studio, this is typically your parent model.
- Match Booster set up on that model in the US region, with at least one Email, Email SHA256, Phone, Phone SHA256, or Mobile ID column mapped.
- A live campaign on your ad platform, so there are logs to receive.
Setup steps
1
Set up Match Booster on your model
Who: data teams or platform adminsHightouch matches logs using the identifiers mapped in your model’s Match Booster configuration, then uses the Match Booster identity graph to match the rest. Map the identifiers you want to match on. See Identifiers Hightouch uses for accepted formats, and Configure Match Booster on a model for how to map them.If you haven’t set up Match Booster on the model yet, follow Get started with Match Booster first. Your platform’s page lists the Match Booster regions it supports.
2
Request a log feed from your ad platform
Who: you
- Contact your ad platform representative and ask them to send your exposure logs to Hightouch. Most platforms require you to make this request yourself. Hightouch can’t make it for you.
- Provide the account IDs and feed choices listed on your platform’s page:
3
Your ad platform sets up the feed
Who: your ad platformYour ad platform representative sets up the feed and confirms when logs are reaching Hightouch. You don’t need to do anything in this step.
4
Send setup details to Hightouch
Who: data teams or platform adminsSend Hightouch:
- Your ad platform and the account IDs from step 2.
- The model you want to match logs to.
- The date history should start from. By default, this is the day Exposure Log Matching is enabled. Hightouch doesn’t backfill logs from before this date.
5
Hightouch configures and tests matching
Who: HightouchHightouch configures matching and runs a one-day test. Hightouch reviews the results and match rates with you, then starts delivery to your warehouse.Each delivery covers one finished UTC day and usually arrives the following UTC day. Each daily run queries your full model, so expect one large query on your warehouse each day.
6
Add exposure logs to your schema
Who: data teamsAfter the first delivery, add the matched logs to your Customer Studio schema so marketers can use them in audiences. The
ID column in each view holds the SHA-256 hex digest of your model’s primary key, not the key itself, so you join on a hashed column.- Add a hashed primary key column to your parent model.
- Go to Customer Studio > Schema.
- Create an event model for each feed’s view, such as impressions and clicks.
- Relate each event model to your parent model with a one-to-many relationship.
- In each relationship, join the hashed primary key column to the
IDcolumn. - Name each event model by platform and feed, such as “The Trade Desk impressions,” so models for other platforms sit beside it.
7
Use the data
Who: marketers or analysts
- Build audiences that filter on impressions, clicks, or campaign details. See Audience filters.
- Ask an agent to report reach and frequency by customer segment.
Add a hashed primary key column
To join the matched logs to your parent model, add the hash of its primary key as a computed column in the model’s query. Your warehouse computes the hash each time Hightouch queries the model, so nothing is stored or hard-coded. The hash must match theID column exactly. To match it, the hash must:
- Use SHA-256.
- Hash the primary key cast to text.
- Return a lowercase hexadecimal string of 64 characters.
- Open your parent model and click Edit on its query. If the query type is Table selector, change it to SQL query first.
-
Edit the query to add the hashed column. For example, in Snowflake:
- Save the query, then refresh the model’s columns.
<primary_key> with your primary key column:
For example, the primary key
10482 produces 220c2ca81adf216ca1ef65bcc369ab19e7dc3e3b2610703e3b61054d358d1a6c.
Add another platform
Repeat steps 2 through 6 for each ad platform. Your existing event models don’t change.Check your results
After each delivery, check the matched logs in your warehouse:- Tables and views — Find them in the schema listed in Where Hightouch writes logs.
- Match rate — Count the share of rows with an
ID. The output reference includes a sample query. - Columns — See Columns Hightouch adds, and your platform’s page for the platform’s own columns.
Next steps
- Exposure Log Matching output reference to learn which view to query and how each row was matched.
- Audience filters to build audiences from impressions and clicks.