Run better email, push, and SMS campaigns on Iterable with up-to-date customer data from your data warehouse
Setup
Navigate to Integrations > API Keys and create a new API key with Server-Side permissions.
Use the API key generated to create a new Iterable destination in the Destinations tab of Hightouch.
Now that you have a new Iterable destination, you can start piping data!
Syncing
This integration supports syncing the following objects:
UsersEventsCatalog ItemsSegments
Sync Modes
There are two possible modes for how to alter Iterable objects:
- Upsert - pushes new objects to Iterable and keeps them updated with data from your warehouse
- Update - updates particular fields on existing objects in Iterable. No new objects are inserted.
User Upsert
Upsert has three configuration parameters:
| Name | Details |
|---|---|
| Hightouch Column Containing Iterable Email | The name of the column on the Hightouch query that will map to the email field for users in Iterable. This is used as the primary key in Iterable. |
| Hightouch Column Containing Iterable User ID | The name of the column (id, created_at, first_name, etc..) that will map to the userId field for users in Iterable. |
| Hightouch to Iterable Field Mappings | A list of fields that will be pushed to new users in Iterable. Each time a sync occurs in Hightouch these users will be updated. |
Here is an example:
Only the email column is required, all other mappings are completely optional.
Events
Custom events are currently the only events that can be synced to Iterable.
Event Upsert
In this mode, new events will be inserted into Iterable, and those events will be kept up-to-date within Iterable using the event ID. Upsert is currently the only mode available for use with Iterable events.
These fields are required for events:
- Event name (in the text field or as a mapped column)
- Either user email or user id (email takes precedence)
These fields can be modified on an existing event:
- Event name
- Campaign ID
- Template ID
- Timestamp
- Custom fields
Any custom destination fields are provided to Iterable in the dataFields
property of the request.
Catalogs
Iterable catalogs can be synced to using Upsert mode.
Iterable Catalog Item Upsert
These fields are reuired for catalog items:
- Catalog Name
- Product ID
Existing Iterable catalogs will be automatically populated within Hightouch.
Once a catalog is selected, Hightouch will automatically pull existing field types from your Iterable catalog.
Segment
Sync audiences into your Iterable static lists.
External ID mapping
You can either use email or Iterable user ID.
Static list
Create a new list or select an existing one.
