Treasure Data cohort import

This article describes how to import user cohorts from Treasure Data to Braze so you can send targeted campaigns based on data that may only exist in your warehouse.

Prerequisites

Data import integration

Step 1: Get your Braze data import key

In Braze, navigate to Partner Integrations > Technology Partners and select Treasure Data. Here, you will find your REST endpoint and generate your Braze data import key. After the key is generated, you can create a new key or invalidate an existing one.

Step 2: Create a data connection

Before you create your data connection within Treasure Data, you’ll need to authenticate. First, select Integrations Hub, then Catalog.

Search for the Braze Integration in the Catalog, then hover over the icon and select Create Authentication. Enter your credentials, name your authentication, then select Done.

Step 3: Define your query

1. Navigate to Data Workbench > Queries.
2. Select New Query.
3. Run the query to validate the result set.

Use case: Syncing cohorts by identifier

• syncing external ids
• syncing user aliases
• syncing device ids

1
2
3
4
SELECT
  external_id as user_ids
FROM
  example_cohort_table

1
2
3
4
SELECT
  email
FROM
  example_cohort_table

1
2
3
4
SELECT
  device_ids
FROM
  example_cohort_table

Step 4: Specify the result export target

Once the query has been built, select Export Results. You can select an existing authentication, such as the one created in the last steps, or create a new authentication to be used for output.

Follow Treasure Data’s steps for configuring your export to meet your use case.

Step 5: Execute the query

Save the query with a name and run, or just run the query. Upon successful completion of the query, the query result is automatically exported to Braze.

Step 6: Create a Braze segment from the Treasure Data Export

In Braze, navigate to Segments, create a new segment, and select Treasure Data Cohorts as your filter. From here, you can choose which Treasure Data cohort you wish to include. After your Treasure Data cohort segment is created, you can select it as an audience filter when creating a campaign or Canvas.