BdAudience Meeting

Trying being to join between two tables such as states and a name

used to omit records used as a suppression doc. We need two columns the zip and the file id. Used for suppression files. Provides a bunch of files from better data

Have a column used for the suppression

Example query for this

select * from HAINES_SAMPLE INNER JOIN STATE_LOOKUP on HAINES_SAMPLE.DATAID = STATE_LOOKUP.ID AND STATE_LOOKUP.FID in {{DATA_FILE_NAME}} where {{WHERE}}

New integrations

Pushing google ads and facebooks

Requirements

From Aaron

Typical attributes sent to ad api

• Customer Id
• Campaign id
• Ad Group id
• Audience List/Segment id
• User List: usually emails, phone numbers, or hashed data that complies with google match policy
• Will add records in batches

From Raghava

Wants to know that only the difference in new users are sent to the ad api

So bettrdat would update list, and prismatic will only take the difference

From Raghava

Audience Builder would create an output list from their filters

Audience Build updates the list

Sends a webhook

Customer will set a prismatic workflow

When the list is created, prismatic will process the data, sending the data one by one

Prismatic will have the creds

From Aaron

The lists are separate

Stand Up

• Put the latest version of bdaudience on realsource
• Meet with Donny on version upgrade
• Download the split zips and uncompress for realsource
• Split up the data tickets into three separat stories
• Check with Israel on data