Iterable is a growth marketing and customer engagement platform. It enables brands to create, execute and optimize campaigns across email, push, SMS, in-app and more with unparalleled data flexibility.
|dbt Package||check||Get the package: source / transform|
Follow our step-by-step Iterable setup guide to connect Iterable with your destination using Fivetran connectors.
This schema applies to all Iterable connections.
EVENT table is the main table that contains all the fields we receive from the Events API. The
EVENT_EXTENSION table serves as an extension to the
EVENT table. We store any additional fields we receive from the webhooks in the
EVENT table contains information of following events:
- Custom Event
- Email Send
- Email Open
- Email Click
- Email UnSubscribe
- Email Subscribe
- Email Bounce
- Email Complaint
- Hosted Unsubscribe Click
- InApp Open
- InApp Click
- Push Send
- Push Bounce
- Push Open
- SMS Send
- SMS Bounce
- SMS Received
- Web Push Send
LIST_USER_HISTORY table is the only way to join the
Excluding the table from the sync may lead to data discrepancy.