- Getting started
- Account management
- Security
- Destinations
- Integrations
- SaaS
- Overview
- 3PL Central
- ActiveCampaign
- AdRoll
- Amplitude
- AppsFlyer
- Asana
- Autopilot
- BigCommerce
- Braintree
- Bronto
- Campaign Manager
- Campaign Monitor
- Chargebee
- Chargify
- CircleCI
- Close.io
- Club Speed
- Codat
- COVID-19 Public Data
- Crossbeam
- Darksky
- Deputy
- Desk
- Dixa
- Doorbell.io
- eBay
- Eloqua
- Facebook Ads
- Freshdesk
- Front
- FullStory
- GitHub
- GitLab
- Google Ads
- Google Ads (AdWords)
- Google Analytics
- Google Analytics (AdWords)
- Google Analytics 360
- Google Analytics 4
- Google ECommerce
- Google Search Console
- Google Sheets
- Harvest
- Harvest Forecast
- Heap
- Help Scout
- HubSpot
- iLEVEL
- Impact
- Intacct
- Intercom
- Invoiced
- Iterable
- JIRA
- Klaviyo
- Kustomer
- Lever
- LinkedIn Ads
- Listrak
- LivePerson
- Looker
- LookML
- MailChimp
- Mailshake
- Mambu
- Marketo
- Microsoft Advertising
- Microsoft Teams
- Mixpanel
- NetSuite
- NetSuite Suite Analytics
- Onfleet
- Outbrain
- Outreach
- Pardot
- Pendo
- Pepperjam
- Pipedrive
- Quick Base
- QuickBooks
- Recharge
- Recurly
- Referral SaaSquatch
- Revinate
- RingCentral
- SaaSOptics
- Sailthru
- Salesforce
- Salesforce Marketing Cloud
- Selligent
- SendGrid Core
- ShipHero
- Shippo
- Shopify
- Slack
- Snapchat Ads
- Square
- Stripe
- SurveyMonkey
- Taboola
- TikTok Ads
- Toggl
- Trello
- Twilio
- Twitter Ads
- Typeform
- UJET
- Urban Airship
- UserVoice
- Wootric
- Workday RaaS
- Xero
- Yotpo
- Zendesk Chat
- Zendesk Support
- Zoom
- Zuora
- Databases
- Overview
- Amazon Aurora MySQL RDS
- Amazon Aurora PostgreSQL RDS
- Amazon DynamoDB
- Amazon Microsoft SQL Server RDS
- Amazon MySQL RDS
- Amazon Oracle RDS
- Amazon PostgreSQL RDS
- Amazon S3 CSV
- Google CloudSQL MySQL
- Google CloudSQL PostgreSQL
- Heroku
- Magento
- MariaDB
- Microsoft Azure MySQL
- Microsoft Azure SQL Database
- Microsoft SQL Server
- MongoDB
- MongoDB Atlas
- MySQL
- Oracle
- PostgreSQL
- Responsys
- SFTP
- Webhooks
- All integrations
- Connection cloning
- Connect other data sources
- SaaS
- Extracting data
- Loading data
- Analysis tools
- Troubleshooting
- Developers
- Changelog
Get started with a free trial today
Already have an account? Sign in
Iterable Core (v1)
Iterable is currently in beta. The info in this guide is subject to change.
This integration is powered bySinger's Iterable tap and certified by Stitch.Check out and contribute to the repo on GitHub.
For support, contactSupport.
Iterable integration summary
Stitch’s Iterable integration replicates data using theIterable API 1.8. Refer to theSchema section for a list of objects available for replication.
Iterable feature snapshot
A high-level look at Stitch's Iterable (v1) integration, including release status, useful links, and the features supported in Stitch.
| STITCH | |||
| Release status | Beta | Supported by | |
| Stitch plan | Standard | API availability | Available |
| Singer GitHub repository | |||
| REPLICATION SETTINGS | |||
| Anchor Scheduling | Supported | Advanced Scheduling | Supported |
| Table-level reset | Unsupported | Configurable Replication Methods | Unsupported |
| DATA SELECTION | |||
| Table selection | Supported | Column selection | Supported |
| Select all | Supported | ||
| TRANSPARENCY | |||
| Extraction Logs | Supported | Loading Reports | Supported |
Connecting Iterable
Iterable setup requirements
To set up Iterable in Stitch, you need:
You must be anorg admin or a user withAPI and Webhook configuration permissions in your Iterable account.
Step 1: Generate an Iterable API key
- Sign into you Iterable account.
- Navigate toIntegrations>API Keys.
- ClickNew API Key.
- In theCreate a new API key window, name your API key and selectread-only.
- ClickCreate.
- Copy your new API key and have it ready for the next step.
Step 2: Add Iterable as a Stitch data source
- Sign into your Stitch account.
On the Stitch Dashboard page, click theAdd Integration button.
Click theIterable icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch Iterable” would create a schema called
stitch_iterablein the destination.Note: Schema names cannot be changed after you save the integration.- In theIterable API Key field, paste the API key you copied instep 1.
- In theAPI Window in Days field, enter a value. This parameter should be set to an optimum value to improve historical sync performance. Setting this value too low will take longer to complete historical sync and setting it larger may result in request timeouts or memory overflow issues.
Step 3: Define the historical replication start date
The Sync Historical Data setting defines the starting date for your Iterable integration. This means that dataequal to or newer than this date will be replicated to your data warehouse.
Change this setting if you want to replicate data beyond Iterable’s default setting of1 year. For a detailed look at historical replication jobs, check out theSyncing Historical SaaS Data guide.
Step 4: Create a replication schedule
In theReplication Frequency section, you’ll create the integration’sreplication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.
Iterable integrations support the following replication scheduling methods:
Advanced Scheduling using Cron (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See theUnderstanding and Reducing Your Row Usage guide for tips on reducing your usage.
Step 5: Set objects to replicate
The last step is to select the tables and columns you want to replicate.Learn about the available tables for this integration.
Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.
For Iterable integrations, you can select:
Individual tables and columns
All tables and columns
Click the tabs to view instructions for each selection method.
- In the integration’sTables to Replicate tab, locate a table you want to replicate.
To track a table, click thecheckbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click thecheckbox next to the column’s name. A blue checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click theFinalize Your Selections button at the bottom of the screen to save your selections.
- Click into the integration from the Stitch Dashboard page.
Click theTables to Replicate tab.
- In the list of tables, click the box next to theTable Names column.
In the menu that displays, clickTrack all Tables and Fields:
- Click theFinalize Your Selections button at the bottom of the page to save your data selections.
Initial and historical replication jobs
After you finish setting up Iterable, itsSync Status may show asPending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, aPending status indicates that Stitch is in the process of scheduling the initial replication job for the integration.This may take some time to complete.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to theAnchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
Iterable table reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is forversion 1 of this integration.
This is the latest version of the Iterable integration.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs >customers), while case is maintained in PostgreSQL destinations (CusTomERs >CusTomERs). Refer to theLoading Guide for your destination for more info.
campaigns
Thecampaigns table contains information about campaigns in your Iterable projcect.
Key-based Incremental | |
Primary Key | id |
Replication Key | updatedAt |
| Useful links |
| Join campaigns with | on |
|---|---|
| email_bounce | campaigns.id = email_bounce.campaignId campaigns.templateId = email_bounce.templateId |
| email_click | campaigns.id = email_click.campaignId campaigns.templateId = email_click.templateId |
| email_complaint | campaigns.id = email_complaint.campaignId campaigns.templateId = email_complaint.templateId |
| email_open | campaigns.id = email_open.campaignId campaigns.templateId = email_open.templateId |
| email_send | campaigns.id = email_send.campaignId campaigns.templateId = email_send.templateId |
| email_send_skip | campaigns.id = email_send_skip.campaignId campaigns.templateId = email_send_skip.templateId |
| email_subscribe | campaigns.id = email_subscribe.campaignId campaigns.templateId = email_subscribe.templateId |
| email_unsubscribe | campaigns.id = email_unsubscribe.campaignId campaigns.templateId = email_unsubscribe.templateId |
| templates | campaigns.id = templates.campaignId campaigns.templateId = templates.templateId |
campaignState STRING |
createdAt DATE-TIME |
createdByUserId STRING |
endedAt DATE-TIME |
id INTEGER |
labels ARRAY |
listIds ARRAY |
messageMedium STRING |
name STRING |
recurringCampaignId INTEGER |
sendSize NUMBER |
startAt DATE-TIME |
suppressionListIds ARRAY |
templateId INTEGER |
type STRING |
updatedAt DATE-TIME |
updatedByUserId STRING |
workflowId INTEGER |
channels
Thechannels table contains information about all channels within your Iterable project.
Full Table | |
Primary Key | id |
| Useful links |
| Join channels with | on |
|---|---|
| email_send | channels.id = email_send.channelId |
| email_send_skip | channels.id = email_send_skip.channelId |
| email_subscribe | channels.id = email_subscribe.channelIds.items |
| email_unsubscribe | channels.id = email_unsubscribe.channelIds.items channels.id = email_unsubscribe.channelId |
| message_types | channels.id = message_types.channelId |
channelType STRING |
id INTEGER |
messageMedium STRING |
name STRING |
email_bounce
Theemail_bounce table contains information about bounced emails within your Iterable campaign.
Key-based Incremental | |
Primary Key | |
Replication Key | createdAt |
| Useful links |
| Join email_bounce with | on |
|---|---|
| campaigns | email_bounce.campaignId = campaigns.id email_bounce.templateId = campaigns.templateId |
| email_click | email_bounce.campaignId = email_click.campaignId email_bounce.email = email_click.email email_bounce.templateId = email_click.templateId |
| email_complaint | email_bounce.campaignId = email_complaint.campaignId email_bounce.email = email_complaint.email email_bounce.templateId = email_complaint.templateId |
| email_open | email_bounce.campaignId = email_open.campaignId email_bounce.email = email_open.email email_bounce.templateId = email_open.templateId |
| email_send | email_bounce.campaignId = email_send.campaignId email_bounce.email = email_send.email email_bounce.templateId = email_send.templateId |
| email_send_skip | email_bounce.campaignId = email_send_skip.campaignId email_bounce.email = email_send_skip.email email_bounce.templateId = email_send_skip.templateId |
| email_subscribe | email_bounce.campaignId = email_subscribe.campaignId email_bounce.email = email_subscribe.email email_bounce.templateId = email_subscribe.templateId |
| email_unsubscribe | email_bounce.campaignId = email_unsubscribe.campaignId email_bounce.email = email_unsubscribe.email email_bounce.templateId = email_unsubscribe.templateId |
| templates | email_bounce.campaignId = templates.campaignId email_bounce.templateId = templates.templateId |
| users | email_bounce.email = users.email |
| list_users | email_bounce.email = list_users.email |
campaignId INTEGER | ||
createdAt DATE-TIME | ||
email STRING | ||
eventName STRING | ||
itblInternal OBJECT
| ||
messageId STRING | ||
recipientState STRING | ||
status STRING | ||
templateId INTEGER |
email_click
Theemail_click table contains information about clicks on your Iterable email campaign.
Key-based Incremental | |
Primary Key | |
Replication Key | createdAt |
| Useful links |
| Join email_click with | on |
|---|---|
| campaigns | email_click.campaignId = campaigns.id email_click.templateId = campaigns.templateId |
| email_bounce | email_click.campaignId = email_bounce.campaignId email_click.email = email_bounce.email email_click.templateId = email_bounce.templateId |
| email_complaint | email_click.campaignId = email_complaint.campaignId email_click.email = email_complaint.email email_click.templateId = email_complaint.templateId |
| email_open | email_click.campaignId = email_open.campaignId email_click.email = email_open.email email_click.templateId = email_open.templateId |
| email_send | email_click.campaignId = email_send.campaignId email_click.email = email_send.email email_click.templateId = email_send.templateId |
| email_send_skip | email_click.campaignId = email_send_skip.campaignId email_click.email = email_send_skip.email email_click.templateId = email_send_skip.templateId |
| email_subscribe | email_click.campaignId = email_subscribe.campaignId email_click.email = email_subscribe.email email_click.templateId = email_subscribe.templateId |
| email_unsubscribe | email_click.campaignId = email_unsubscribe.campaignId email_click.email = email_unsubscribe.email email_click.templateId = email_unsubscribe.templateId |
| templates | email_click.campaignId = templates.campaignId email_click.templateId = templates.templateId |
| users | email_click.email = users.email |
| list_users | email_click.email = list_users.email |
campaignId INTEGER | ||
city STRING | ||
contentId INTEGER | ||
country STRING | ||
createdAt DATE-TIME | ||
email STRING | ||
eventName STRING | ||
hrefIndex INTEGER | ||
ip STRING | ||
itblInternal OBJECT
| ||
messageId STRING | ||
region STRING | ||
templateId INTEGER | ||
url STRING | ||
userAgent STRING | ||
userAgentDevice STRING |
email_complaint
Theemail_complaint table contains information about email recipients that sent complaints for your Iterable campain.
Key-based Incremental | |
Primary Key | |
Replication Key | createdAt |
| Useful links |
| Join email_complaint with | on |
|---|---|
| campaigns | email_complaint.campaignId = campaigns.id email_complaint.templateId = campaigns.templateId |
| email_bounce | email_complaint.campaignId = email_bounce.campaignId email_complaint.email = email_bounce.email email_complaint.templateId = email_bounce.templateId |
| email_click | email_complaint.campaignId = email_click.campaignId email_complaint.email = email_click.email email_complaint.templateId = email_click.templateId |
| email_open | email_complaint.campaignId = email_open.campaignId email_complaint.email = email_open.email email_complaint.templateId = email_open.templateId |
| email_send | email_complaint.campaignId = email_send.campaignId email_complaint.email = email_send.email email_complaint.templateId = email_send.templateId |
| email_send_skip | email_complaint.campaignId = email_send_skip.campaignId email_complaint.email = email_send_skip.email email_complaint.templateId = email_send_skip.templateId |
| email_subscribe | email_complaint.campaignId = email_subscribe.campaignId email_complaint.email = email_subscribe.email email_complaint.templateId = email_subscribe.templateId |
| email_unsubscribe | email_complaint.campaignId = email_unsubscribe.campaignId email_complaint.email = email_unsubscribe.email email_complaint.templateId = email_unsubscribe.templateId |
| templates | email_complaint.campaignId = templates.campaignId email_complaint.templateId = templates.templateId |
| users | email_complaint.email = users.email |
| list_users | email_complaint.email = list_users.email |
campaignId INTEGER | ||
createdAt DATE-TIME | ||
email STRING | ||
eventName STRING | ||
itblInternal OBJECT
| ||
messageId STRING | ||
recipientState STRING | ||
templateId INTEGER |
email_open
Theemail_open table contains information about email recipients that opened your Iterable campaign.
Key-based Incremental | |
Primary Key | |
Replication Key | createdAt |
| Useful links |
| Join email_open with | on |
|---|---|
| campaigns | email_open.campaignId = campaigns.id email_open.templateId = campaigns.templateId |
| email_bounce | email_open.campaignId = email_bounce.campaignId email_open.email = email_bounce.email email_open.templateId = email_bounce.templateId |
| email_click | email_open.campaignId = email_click.campaignId email_open.email = email_click.email email_open.templateId = email_click.templateId |
| email_complaint | email_open.campaignId = email_complaint.campaignId email_open.email = email_complaint.email email_open.templateId = email_complaint.templateId |
| email_send | email_open.campaignId = email_send.campaignId email_open.email = email_send.email email_open.templateId = email_send.templateId |
| email_send_skip | email_open.campaignId = email_send_skip.campaignId email_open.email = email_send_skip.email email_open.templateId = email_send_skip.templateId |
| email_subscribe | email_open.campaignId = email_subscribe.campaignId email_open.email = email_subscribe.email email_open.templateId = email_subscribe.templateId |
| email_unsubscribe | email_open.campaignId = email_unsubscribe.campaignId email_open.email = email_unsubscribe.email email_open.templateId = email_unsubscribe.templateId |
| templates | email_open.campaignId = templates.campaignId email_open.templateId = templates.templateId |
| users | email_open.email = users.email |
| list_users | email_open.email = list_users.email |
campaignId INTEGER | ||
city STRING | ||
contentId INTEGER | ||
country STRING | ||
createdAt DATE-TIME | ||
email STRING | ||
eventName STRING | ||
ip STRING | ||
itblInternal OBJECT
| ||
messageId STRING | ||
proxySource STRING | ||
region STRING | ||
templateId INTEGER | ||
userAgent STRING | ||
userAgentDevice STRING |
email_send
Theemail_send table contains information about campaign emails you sent in your Iterable account.
Key-based Incremental | |
Primary Key | |
Replication Key | createdAt |
| Useful links |
| Join email_send with | on |
|---|---|
| campaigns | email_send.campaignId = campaigns.id email_send.templateId = campaigns.templateId |
| email_bounce | email_send.campaignId = email_bounce.campaignId email_send.email = email_bounce.email email_send.templateId = email_bounce.templateId |
| email_click | email_send.campaignId = email_click.campaignId email_send.email = email_click.email email_send.templateId = email_click.templateId |
| email_complaint | email_send.campaignId = email_complaint.campaignId email_send.email = email_complaint.email email_send.templateId = email_complaint.templateId |
| email_open | email_send.campaignId = email_open.campaignId email_send.email = email_open.email email_send.templateId = email_open.templateId |
| email_send_skip | email_send.campaignId = email_send_skip.campaignId email_send.channelId = email_send_skip.channelId email_send.email = email_send_skip.email email_send.templateId = email_send_skip.templateId |
| email_subscribe | email_send.campaignId = email_subscribe.campaignId email_send.channelId = email_subscribe.channelIds.items email_send.email = email_subscribe.email email_send.templateId = email_subscribe.templateId |
| email_unsubscribe | email_send.campaignId = email_unsubscribe.campaignId email_send.channelId = email_unsubscribe.channelIds.items email_send.channelId = email_unsubscribe.channelId email_send.email = email_unsubscribe.email email_send.templateId = email_unsubscribe.templateId |
| templates | email_send.campaignId = templates.campaignId email_send.templateId = templates.templateId |
| channels | email_send.channelId = channels.id |
| message_types | email_send.channelId = message_types.channelId |
| users | email_send.email = users.email |
| list_users | email_send.email = list_users.email |
campaignId INTEGER | ||||||||||||||||||||||||
catalogCollectionCount INTEGER | ||||||||||||||||||||||||
catalogLookupCount INTEGER | ||||||||||||||||||||||||
channelId INTEGER | ||||||||||||||||||||||||
contentId INTEGER | ||||||||||||||||||||||||
createdAt DATE-TIME | ||||||||||||||||||||||||
email STRING | ||||||||||||||||||||||||
espName STRING | ||||||||||||||||||||||||
itblInternal OBJECT
| ||||||||||||||||||||||||
messageBusId STRING | ||||||||||||||||||||||||
messageId STRING | ||||||||||||||||||||||||
messageTypeId INTEGER | ||||||||||||||||||||||||
productRecommendationCount INTEGER | ||||||||||||||||||||||||
templateId INTEGER | ||||||||||||||||||||||||
transactionalData OBJECT
|
email_send_skip
Theemail_send_skip table contains information about campaign email recipients that were skipped in your Iterable account.
Key-based Incremental | |
Primary Key | |
Replication Key | createdAt |
| Useful links |
| Join email_send_skip with | on |
|---|---|
| campaigns | email_send_skip.campaignId = campaigns.id email_send_skip.templateId = campaigns.templateId |
| email_bounce | email_send_skip.campaignId = email_bounce.campaignId email_send_skip.email = email_bounce.email email_send_skip.templateId = email_bounce.templateId |
| email_click | email_send_skip.campaignId = email_click.campaignId email_send_skip.email = email_click.email email_send_skip.templateId = email_click.templateId |
| email_complaint | email_send_skip.campaignId = email_complaint.campaignId email_send_skip.email = email_complaint.email email_send_skip.templateId = email_complaint.templateId |
| email_open | email_send_skip.campaignId = email_open.campaignId email_send_skip.email = email_open.email email_send_skip.templateId = email_open.templateId |
| email_send | email_send_skip.campaignId = email_send.campaignId email_send_skip.channelId = email_send.channelId email_send_skip.email = email_send.email email_send_skip.templateId = email_send.templateId |
| email_subscribe | email_send_skip.campaignId = email_subscribe.campaignId email_send_skip.channelId = email_subscribe.channelIds.items email_send_skip.email = email_subscribe.email email_send_skip.templateId = email_subscribe.templateId |
| email_unsubscribe | email_send_skip.campaignId = email_unsubscribe.campaignId email_send_skip.channelId = email_unsubscribe.channelIds.items email_send_skip.channelId = email_unsubscribe.channelId email_send_skip.email = email_unsubscribe.email email_send_skip.templateId = email_unsubscribe.templateId |
| templates | email_send_skip.campaignId = templates.campaignId email_send_skip.templateId = templates.templateId |
| channels | email_send_skip.channelId = channels.id |
| message_types | email_send_skip.channelId = message_types.channelId |
| users | email_send_skip.email = users.email |
| list_users | email_send_skip.email = list_users.email |
campaignId INTEGER | ||||||||||||||||||||||||
channelId INTEGER | ||||||||||||||||||||||||
contentId INTEGER | ||||||||||||||||||||||||
createdAt DATE-TIME | ||||||||||||||||||||||||
email STRING | ||||||||||||||||||||||||
itblInternal OBJECT
| ||||||||||||||||||||||||
messageId STRING | ||||||||||||||||||||||||
messageTypeId INTEGER | ||||||||||||||||||||||||
reason STRING | ||||||||||||||||||||||||
templateId INTEGER | ||||||||||||||||||||||||
transactionalData OBJECT
|
email_subscribe
Theemail_subscribe table contains information about emails subscribed to your Iterable campaign.
Key-based Incremental | |
Primary Key | |
Replication Key | createdAt |
| Useful links |
| Join email_subscribe with | on |
|---|---|
| campaigns | email_subscribe.campaignId = campaigns.id email_subscribe.templateId = campaigns.templateId |
| email_bounce | email_subscribe.campaignId = email_bounce.campaignId email_subscribe.email = email_bounce.email email_subscribe.templateId = email_bounce.templateId |
| email_click | email_subscribe.campaignId = email_click.campaignId email_subscribe.email = email_click.email email_subscribe.templateId = email_click.templateId |
| email_complaint | email_subscribe.campaignId = email_complaint.campaignId email_subscribe.email = email_complaint.email email_subscribe.templateId = email_complaint.templateId |
| email_open | email_subscribe.campaignId = email_open.campaignId email_subscribe.email = email_open.email email_subscribe.templateId = email_open.templateId |
| email_send | email_subscribe.campaignId = email_send.campaignId email_subscribe.channelIds.items = email_send.channelId email_subscribe.email = email_send.email email_subscribe.templateId = email_send.templateId |
| email_send_skip | email_subscribe.campaignId = email_send_skip.campaignId email_subscribe.channelIds.items = email_send_skip.channelId email_subscribe.email = email_send_skip.email email_subscribe.templateId = email_send_skip.templateId |
| email_unsubscribe | email_subscribe.campaignId = email_unsubscribe.campaignId email_subscribe.channelIds.items = email_unsubscribe.channelIds.items email_subscribe.channelIds.items = email_unsubscribe.channelId email_subscribe.email = email_unsubscribe.email email_subscribe.templateId = email_unsubscribe.templateId |
| templates | email_subscribe.campaignId = templates.campaignId email_subscribe.templateId = templates.templateId |
| channels | email_subscribe.channelIds.items = channels.id |
| message_types | email_subscribe.channelIds.items = message_types.channelId |
| users | email_subscribe.email = users.email |
| list_users | email_subscribe.email = list_users.email |
campaignId INTEGER | ||
channelIds ARRAY | ||
createdAt DATE-TIME | ||
email STRING | ||
emailListId INTEGER | ||
emailListIds ARRAY | ||
eventName STRING | ||
itblInternal OBJECT
| ||
profileUpdatedAt DATE-TIME | ||
signupSource STRING | ||
templateId INTEGER | ||
userId STRING | ||
workflowId INTEGER |
email_unsubscribe
Theemail_unsubscribe table contains information about emails unsubscribed from your Iterable campaign.
Key-based Incremental | |
Primary Key | |
Replication Key | createdAt |
| Useful links |
| Join email_unsubscribe with | on |
|---|---|
| campaigns | email_unsubscribe.campaignId = campaigns.id email_unsubscribe.templateId = campaigns.templateId |
| email_bounce | email_unsubscribe.campaignId = email_bounce.campaignId email_unsubscribe.email = email_bounce.email email_unsubscribe.templateId = email_bounce.templateId |
| email_click | email_unsubscribe.campaignId = email_click.campaignId email_unsubscribe.email = email_click.email email_unsubscribe.templateId = email_click.templateId |
| email_complaint | email_unsubscribe.campaignId = email_complaint.campaignId email_unsubscribe.email = email_complaint.email email_unsubscribe.templateId = email_complaint.templateId |
| email_open | email_unsubscribe.campaignId = email_open.campaignId email_unsubscribe.email = email_open.email email_unsubscribe.templateId = email_open.templateId |
| email_send | email_unsubscribe.campaignId = email_send.campaignId email_unsubscribe.channelIds.items = email_send.channelId email_unsubscribe.channelId = email_send.channelId email_unsubscribe.email = email_send.email email_unsubscribe.templateId = email_send.templateId |
| email_send_skip | email_unsubscribe.campaignId = email_send_skip.campaignId email_unsubscribe.channelIds.items = email_send_skip.channelId email_unsubscribe.channelId = email_send_skip.channelId email_unsubscribe.email = email_send_skip.email email_unsubscribe.templateId = email_send_skip.templateId |
| email_subscribe | email_unsubscribe.campaignId = email_subscribe.campaignId email_unsubscribe.channelIds.items = email_subscribe.channelIds.items email_unsubscribe.channelId = email_subscribe.channelIds.items email_unsubscribe.email = email_subscribe.email email_unsubscribe.templateId = email_subscribe.templateId |
| templates | email_unsubscribe.campaignId = templates.campaignId email_unsubscribe.templateId = templates.templateId |
| channels | email_unsubscribe.channelIds.items = channels.id email_unsubscribe.channelId = channels.id |
| message_types | email_unsubscribe.channelIds.items = message_types.channelId email_unsubscribe.channelId = message_types.channelId |
| users | email_unsubscribe.email = users.email |
| list_users | email_unsubscribe.email = list_users.email |
bounceMessage STRING | ||
campaignId INTEGER | ||
channelId INTEGER | ||
channelIds ARRAY | ||
createdAt DATE-TIME | ||
email STRING | ||
emailListId INTEGER | ||
emailListIds ARRAY | ||
eventName STRING | ||
itblInternal OBJECT
| ||
messageId STRING | ||
recipientState STRING | ||
status STRING | ||
templateId INTEGER | ||
unsubSource STRING | ||
workflowId INTEGER |
list_users
Thelist_users table contains information about users in a list in your Iterable account.
Full Table | |
Primary Keys | listId |
| Useful links |
| Join list_users with | on |
|---|---|
| users | list_users.email = users.email |
| email_bounce | list_users.email = email_bounce.email |
| email_click | list_users.email = email_click.email |
| email_complaint | list_users.email = email_complaint.email |
| email_open | list_users.email = email_open.email |
| email_send | list_users.email = email_send.email |
| email_send_skip | list_users.email = email_send_skip.email |
| email_subscribe | list_users.email = email_subscribe.email |
| email_unsubscribe | list_users.email = email_unsubscribe.email |
| lists | list_users.listId = lists.id |
email STRING |
listId INTEGER |
updatedAt DATE-TIME |
lists
Thelists tablecontains information about lists within your Iterable project.
Full Table | |
Primary Key | id |
| Useful links |
| Join lists with | on |
|---|---|
| list_users | lists.id = list_users.listId |
createdAt DATE-TIME |
description STRING |
id INTEGER |
listType STRING |
name STRING |
message_types
Themessage_types table contains information about all message types within your Iterable project.
Full Table | |
Primary Key | id |
| Useful links |
| Join message_types with | on |
|---|---|
| channels | message_types.channelId = channels.id |
| email_send | message_types.channelId = email_send.channelId |
| email_send_skip | message_types.channelId = email_send_skip.channelId |
| email_subscribe | message_types.channelId = email_subscribe.channelIds.items |
| email_unsubscribe | message_types.channelId = email_unsubscribe.channelIds.items message_types.channelId = email_unsubscribe.channelId |
| templates | message_types.id = templates.messageTypeId |
channelId INTEGER |
createdAt DATE-TIME |
id INTEGER |
name STRING |
subscriptionPolicy STRING |
updatedAt DATE-TIME |
metadata
Themetadata table contains the metadata for a single key in your Iterable account.
Full Table | |
Primary Key | key |
| Useful links |
key STRING | |||||||||||||||
lastModified DATE-TIME | |||||||||||||||
size INTEGER | |||||||||||||||
table STRING | |||||||||||||||
value OBJECT
|
templates
Thetemplates table contains information about project templates in you Iterable account.
Key-based Incremental | |
Primary Key | templateId |
Replication Key | updatedAt |
| Useful links |
| Join templates with | on |
|---|---|
| campaigns | templates.campaignId = campaigns.id templates.templateId = campaigns.templateId |
| email_bounce | templates.campaignId = email_bounce.campaignId templates.templateId = email_bounce.templateId |
| email_click | templates.campaignId = email_click.campaignId templates.templateId = email_click.templateId |
| email_complaint | templates.campaignId = email_complaint.campaignId templates.templateId = email_complaint.templateId |
| email_open | templates.campaignId = email_open.campaignId templates.templateId = email_open.templateId |
| email_send | templates.campaignId = email_send.campaignId templates.templateId = email_send.templateId |
| email_send_skip | templates.campaignId = email_send_skip.campaignId templates.templateId = email_send_skip.templateId |
| email_subscribe | templates.campaignId = email_subscribe.campaignId templates.templateId = email_subscribe.templateId |
| email_unsubscribe | templates.campaignId = email_unsubscribe.campaignId templates.templateId = email_unsubscribe.templateId |
| message_types | templates.messageTypeId = message_types.id |
campaignId INTEGER |
clientTemplateId STRING |
createdAt DATE-TIME |
creatorUserId STRING |
messageTypeId INTEGER |
name STRING |
templateId INTEGER |
updatedAt DATE-TIME |
users
Theusers table contains information about all users in your Iterable account.
Key-based Incremental | |
Primary Key | |
Replication Key | profileUpdatedAt |
| Useful links |
| Join users with | on |
|---|---|
| email_bounce | users.email = email_bounce.email |
| email_click | users.email = email_click.email |
| email_complaint | users.email = email_complaint.email |
| email_open | users.email = email_open.email |
| email_send | users.email = email_send.email |
| email_send_skip | users.email = email_send_skip.email |
| email_subscribe | users.email = email_subscribe.email |
| email_unsubscribe | users.email = email_unsubscribe.email |
| list_users | users.email = list_users.email |
CCProvider STRING |
Industry STRING |
accessIp STRING |
acquisition_source STRING |
actively_seeking BOOLEAN |
age INTEGER |
auctionDigest OBJECT ARRAY |
auctionDigest.auctionDateLocation ARRAY |
auctionDigest.auctionHouse ARRAY |
auctionDigest.auctionImageUrl ARRAY |
auctionDigest.auctionInfo ARRAY |
auctionDigest.name ARRAY |
averageOrderValue NUMBER |
badgeCount INTEGER |
bestFriend STRING |
booked_activity_before BOOLEAN |
booked_package_before BOOLEAN |
browserTokens STRING |
city STRING |
congressional Districts STRING |
counties STRING |
current_employer STRING |
current_employer_id STRING |
date_last_booked_package DATE-TIME |
daysSinceLastOrder INTEGER |
designation STRING |
devices OBJECT ARRAY |
devices.applicationName ARRAY |
devices.endpointEnabled ARRAY |
devices.platform ARRAY |
devices.platformEndpoint ARRAY |
devices.token ARRAY |
email STRING |
emailListIds ARRAY |
estimatedSizing STRING |
experience STRING |
favoriteAnimal STRING |
favoriteCategories OBJECT ARRAY |
favoriteCategories.category ARRAY |
favoriteCategory STRING |
favoriteCuisine STRING |
favoriteItem STRING |
favoriteProduct STRING |
favoriteRestaurant STRING |
favoriteShowCategories STRING |
favorite_category STRING |
favoritedShows STRING |
fb_follow BOOLEAN |
featuredDeal STRING |
firstName STRING |
gender STRING |
hasMobileApp BOOLEAN |
highestBidPrice STRING |
house Districts STRING |
industry STRING |
installedDropbox BOOLEAN |
installed_sync BOOLEAN |
interested_in_detergent BOOLEAN |
interested_in_soap BOOLEAN |
interested_in_toilet_paper BOOLEAN |
invoice OBJECT ARRAY |
invoice.customAmount ARRAY |
invoice.customSubTotal ARRAY |
invoice.customerEmail ARRAY |
invoice.customerName ARRAY |
invoice.invoiceDate ARRAY |
invoice.invoiceNumber ARRAY |
invoice.merchantName ARRAY |
invoice.totalDue ARRAY |
is_active BOOLEAN |
is_available BOOLEAN |
itblInternal.emailDomain STRING |
jobRecommendations OBJECT ARRAY |
jobRecommendations.applicationURL ARRAY |
jobRecommendations.description ARRAY |
jobRecommendations.id ARRAY |
jobRecommendations.imageUrl ARRAY |
jobRecommendations.name ARRAY |
job_categories_interested STRING |
job_title STRING |
lastAccessedAgent STRING |
lastKnownLatitude NUMBER |
lastKnownLongitude NUMBER |
lastName STRING |
lastOrderlocation STRING |
lastOrderrestaurant STRING |
last_game_played STRING |
last_purchased STRING |
last_purchased_category STRING |
last_session_date DATE-TIME |
level INTEGER |
lifetime Dontation STRING |
lifetime_Spent STRING |
locale STRING |
location STRING |
loyalty_member BOOLEAN |
loyalty_points INTEGER |
loyalty_program BOOLEAN |
major STRING |
marketSmith_subscription BOOLEAN |
merchantId INTEGER |
name STRING |
newListedVehicles OBJECT ARRAY |
newListedVehicles.category ARRAY |
newListedVehicles.imageUrl ARRAY |
newListedVehicles.miles ARRAY |
newListedVehicles.name ARRAY |
newListedVehicles.noHagglePrice ARRAY |
newListedVehicles.price ARRAY |
newListedVehicles.sku ARRAY |
offers OBJECT ARRAY |
offers.Intro APR ARRAY |
offers.categories ARRAY |
offers.description ARRAY |
offers.id ARRAY |
offers.imageUrl ARRAY |
offers.intro APR ARRAY |
offers.name ARRAY |
offers.quantity ARRAY |
offers.sku ARRAY |
offers.url ARRAY |
onboardingCohort STRING |
paid_user BOOLEAN |
passively_seeking BOOLEAN |
phoneNumber STRING |
phoneNumberDetails OBJECT ARRAY |
phoneNumberDetails.carrier ARRAY |
phoneNumberDetails.countryCodeISO ARRAY |
phoneNumberDetails.lineType ARRAY |
phoneNumberDetails.updatedAt ARRAY |
profileUpdatedAt DATE-TIME |
promoCode STRING |
readingList OBJECT ARRAY |
readingList.avgRating ARRAY |
readingList.bookAuthor ARRAY |
readingList.bookName ARRAY |
readingList.imageUrl ARRAY |
recommendedVehicles OBJECT ARRAY |
recommendedVehicles.TrueCar Estimate ARRAY |
recommendedVehicles.category ARRAY |
recommendedVehicles.estimateDescription ARRAY |
recommendedVehicles.imageUrl ARRAY |
recommendedVehicles.name ARRAY |
recommendedVehicles.sku ARRAY |
region STRING |
sat STRING |
scheduled_ride DATE-TIME |
selected_games STRING |
senate Districts STRING |
shoppingCartItems OBJECT ARRAY |
shoppingCartItems.categories ARRAY |
shoppingCartItems.description ARRAY |
shoppingCartItems.id ARRAY |
shoppingCartItems.imageUrl ARRAY |
shoppingCartItems.name ARRAY |
shoppingCartItems.price ARRAY |
shoppingCartItems.quantity ARRAY |
shoppingCartItems.sku ARRAY |
shoppingCartItems.url ARRAY |
shopppingCartTotal INTEGER |
should_receive_recommendation BOOLEAN |
signupDate DATE-TIME |
signupSource STRING |
state STRING |
streetAddress STRING |
swingTrader_subscription BOOLEAN |
tagline STRING |
timeZone STRING |
times donated STRING |
times_purchased STRING |
totalOrderCount INTEGER |
totalOrders STRING |
totalPurchases INTEGER |
totalSpent NUMBER |
total_playtime INTEGER |
type STRING |
university_interest STRING |
unsubscribedChannelIds ARRAY |
unsubscribedMessageTypeIds ARRAY |
uploaded_resume BOOLEAN |
userId STRING |
user_type STRING |
vegetarian_menu OBJECT ARRAY |
vegetarian_menu.featured_item_availability ARRAY |
vegetarian_menu.featured_item_description ARRAY |
vegetarian_menu.featured_item_id ARRAY |
vegetarian_menu.featured_item_image_url ARRAY |
vegetarian_menu.featured_item_menu_availability ARRAY |
vegetarian_menu.featured_item_menu_date ARRAY |
vip BOOLEAN |
wishList OBJECT ARRAY |
wishList.name ARRAY |
wishList.price ARRAY |
zip STRING |
| Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.