Iterable
Iterable is a customer engagement platform that enables brands to create, execute, and optimize cross-channel campaigns.
Iterable integration replicates data using the Iterable API 1.8.
See the Schema section for a list of objects available for replication.レプリケーション タスク: 変更を適用 変更の保存 データ レイク タスクにデータをランディング: 変更データキャプチャ (CDC) 必須。これにより、ソースの変更に応じてターゲットが最新の状態に保たれます。 レプリケーション タスクについては、「タスクのスケジューリング 」を参照してください。 レイク ランディング タスクについては、「レイク ランディング タスクの CDC のスケジュール設定」を参照してください。 部分的にサポート このコネクタではフル ロードは関係ないため、CDC のみ。機能/性能 サポートの詳細 サポートされている Qlik Talend Data Integration プロジェクト レプリケーション プロジェクトのみ。データ パイプライン プロジェクトはサポートされていません。 手動でのメタデータ生成は必要ありません。 [列のデータ型を変更] 操作のみサポートされています。 LOB 列 (NCLOB、CLOB、BLOB) のレプリケーション サポートされていません。 スケジュールされた CDC 通知 監視 JSON 列ペイロードの自動ネスト解除 サポートされていません。ソース データセット内の JSON 列ペイロードは、ターゲット上で自動的にネスト解除されません。
Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
You must be an org admin or a user with API and Webhook configuration permissions in your Iterable account.
To generate the API key:
- Log into your Iterable account.
- Navigate to Integrations > API Keys.
- Click New API Key.
- In the Create a new API key window, name your API key and select read-only.
- Click Create.
- Copy the key.
Creating the connection
詳細については、「SaaSアプリケーションへの接続」を参照してください。
- 必要な接続プロパティを入力します。
接続名に接続の名前を入力します。
接続メタデータを開くを選択して、作成時の接続のメタデータを定義します。
[作成] をクリックします。
| Setting | Description |
|---|---|
| Data gateway | ユース ケースに応じて Data Movement gateway を選択します。 情報メモ Qlik Talend Cloud スターター サブスクリプションでは Data Movement gateway をサポートしていないため、この項目は使用できません。別のサブスクリプション ティアを利用しており、Data Movement gateway を使用しない場合は、 [None] (なし) を選択します。 Data Movement gateway の利点とそれを必要とするユース ケースの詳細については、「Qlik データ ゲートウェイ - データ移動」を参照してください。 |
| Start Date | ソースからターゲットにデータをレプリケートする必要がある日付を |
| Iterable API Key | Iterable API key. |
| Window in Days | Window in days. 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. |
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 1.
Depending on your destination, table and column names may not appear as they are outlined below.
campaigns
The campaigns table contains information about campaigns in your Iterable projcect.
Replication Method | CDC |
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 This is a nested data structure. |
listIds ARRAY This is a nested data structure. |
messageMedium STRING |
name STRING |
recurringCampaignId INTEGER |
sendSize NUMBER |
startAt DATE-TIME |
suppressionListIds ARRAY This is a nested data structure. |
templateId INTEGER |
type STRING |
updatedAt DATE-TIME |
updatedByUserId STRING |
workflowId INTEGER |
channels
The channels table contains information about all channels within your Iterable project.
Replication Method | 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
The email_bounce table contains information about bounced emails within your Iterable campaign.
Replication Method | CDC |
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 |
STRING |
eventName STRING |
itblInternal OBJECT This is a nested data structure:
|
messageId STRING |
recipientState STRING |
status STRING |
templateId INTEGER |
email_click
The email_click table contains information about clicks on your Iterable email campaign.
Replication Method | CDC |
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 |
STRING |
eventName STRING |
hrefIndex INTEGER |
ip STRING |
itblInternal OBJECT This is a nested data structure:
|
messageId STRING |
region STRING |
templateId INTEGER |
url STRING |
userAgent STRING |
userAgentDevice STRING |
email_complaint
The email_complaint table contains information about email recipients that sent complaints for your Iterable campain.
Replication Method | CDC |
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 |
STRING |
eventName STRING |
itblInternal OBJECT This is a nested data structure:
|
messageId STRING |
recipientState STRING |
templateId INTEGER |
email_open
The email_open table contains information about email recipients that opened your Iterable campaign.
Replication Method | CDC |
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 |
STRING |
eventName STRING |
ip STRING |
itblInternal OBJECT This is a nested data structure:
|
messageId STRING |
proxySource STRING |
region STRING |
templateId INTEGER |
userAgent STRING |
userAgentDevice STRING |
email_send
The email_send table contains information about campaign emails you sent in your Iterable account.
Replication Method | CDC |
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 |
STRING |
espName STRING |
itblInternal OBJECT This is a nested data structure:
|
messageBusId STRING |
messageId STRING |
messageTypeId INTEGER |
productRecommendationCount INTEGER |
templateId INTEGER |
transactionalData OBJECT This is a nested data structure:
|
email_send_skip
The email_send_skip table contains information about campaign email recipients that were skipped in your Iterable account.
Replication Method | CDC |
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 |
STRING |
itblInternal OBJECT This is a nested data structure:
|
messageId STRING |
messageTypeId INTEGER |
reason STRING |
templateId INTEGER |
transactionalData OBJECT This is a nested data structure:
|
email_subscribe
The email_subscribe table contains information about emails subscribed to your Iterable campaign.
Replication Method | CDC |
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 This is a nested data structure. |
createdAt DATE-TIME |
STRING |
emailListId INTEGER |
emailListIds ARRAY This is a nested data structure. |
eventName STRING |
itblInternal OBJECT This is a nested data structure:
|
profileUpdatedAt DATE-TIME |
signupSource STRING |
templateId INTEGER |
userId STRING |
workflowId INTEGER |
email_unsubscribe
The email_unsubscribe table contains information about emails unsubscribed from your Iterable campaign.
Replication Method | CDC |
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 This is a nested data structure. |
createdAt DATE-TIME |
STRING |
emailListId INTEGER |
emailListIds ARRAY This is a nested data structure. |
eventName STRING |
itblInternal OBJECT This is a nested data structure:
|
messageId STRING |
recipientState STRING |
status STRING |
templateId INTEGER |
unsubSource STRING |
workflowId INTEGER |
list_users
The list_users table contains information about users in a list in your Iterable account.
Replication Method | 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 |
STRING |
listId INTEGER |
updatedAt DATE-TIME |
lists
The lists tablecontains information about lists within your Iterable project.
Replication Method | 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
The message_types table contains information about all message types within your Iterable project.
Replication Method | 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
The metadata table contains the metadata for a single key in your Iterable account.
Replication Method | Full Table |
Primary Key | key |
| Useful links |
key STRING |
lastModified DATE-TIME |
size INTEGER |
table STRING |
value OBJECT This is a nested data structure:
|
templates
The templates table contains information about project templates in you Iterable account.
Replication Method | CDC |
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
The users table contains information about all users in your Iterable account.
Replication Method | CDC |
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 This is a nested data structure. ARRAY This is a nested data structure. |
auctionDigest.auctionDateLocation ARRAY This is a nested data structure. |
auctionDigest.auctionHouse ARRAY This is a nested data structure. |
auctionDigest.auctionImageUrl ARRAY This is a nested data structure. |
auctionDigest.auctionInfo ARRAY This is a nested data structure. |
auctionDigest.name ARRAY This is a nested data structure. |
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 This is a nested data structure. ARRAY This is a nested data structure. |
devices.applicationName ARRAY This is a nested data structure. |
devices.endpointEnabled ARRAY This is a nested data structure. |
devices.platform ARRAY This is a nested data structure. |
devices.platformEndpoint ARRAY This is a nested data structure. |
devices.token ARRAY This is a nested data structure. |
STRING |
emailListIds ARRAY This is a nested data structure. |
estimatedSizing STRING |
experience STRING |
favoriteAnimal STRING |
favoriteCategories OBJECT This is a nested data structure. ARRAY This is a nested data structure. |
favoriteCategories.category ARRAY This is a nested data structure. |
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 This is a nested data structure. ARRAY This is a nested data structure. |
invoice.customAmount ARRAY This is a nested data structure. |
invoice.customSubTotal ARRAY This is a nested data structure. |
invoice.customerEmail ARRAY This is a nested data structure. |
invoice.customerName ARRAY This is a nested data structure. |
invoice.invoiceDate ARRAY This is a nested data structure. |
invoice.invoiceNumber ARRAY This is a nested data structure. |
invoice.merchantName ARRAY This is a nested data structure. |
invoice.totalDue ARRAY This is a nested data structure. |
is_active BOOLEAN |
is_available BOOLEAN |
itblInternal.emailDomain STRING |
jobRecommendations OBJECT This is a nested data structure. ARRAY This is a nested data structure. |
jobRecommendations.applicationURL ARRAY This is a nested data structure. |
jobRecommendations.description ARRAY This is a nested data structure. |
jobRecommendations.id ARRAY This is a nested data structure. |
jobRecommendations.imageUrl ARRAY This is a nested data structure. |
jobRecommendations.name ARRAY This is a nested data structure. |
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 This is a nested data structure. ARRAY This is a nested data structure. |
newListedVehicles.category ARRAY This is a nested data structure. |
newListedVehicles.imageUrl ARRAY This is a nested data structure. |
newListedVehicles.miles ARRAY This is a nested data structure. |
newListedVehicles.name ARRAY This is a nested data structure. |
newListedVehicles.noHagglePrice ARRAY This is a nested data structure. |
newListedVehicles.price ARRAY This is a nested data structure. |
newListedVehicles.sku ARRAY This is a nested data structure. |
offers OBJECT This is a nested data structure. ARRAY This is a nested data structure. |
offers.Intro APR ARRAY This is a nested data structure. |
offers.categories ARRAY This is a nested data structure. |
offers.description ARRAY This is a nested data structure. |
offers.id ARRAY This is a nested data structure. |
offers.imageUrl ARRAY This is a nested data structure. |
offers.intro APR ARRAY This is a nested data structure. |
offers.name ARRAY This is a nested data structure. |
offers.quantity ARRAY This is a nested data structure. |
offers.sku ARRAY This is a nested data structure. |
offers.url ARRAY This is a nested data structure. |
onboardingCohort STRING |
paid_user BOOLEAN |
passively_seeking BOOLEAN |
phoneNumber STRING |
phoneNumberDetails OBJECT This is a nested data structure. ARRAY This is a nested data structure. |
phoneNumberDetails.carrier ARRAY This is a nested data structure. |
phoneNumberDetails.countryCodeISO ARRAY This is a nested data structure. |
phoneNumberDetails.lineType ARRAY This is a nested data structure. |
phoneNumberDetails.updatedAt ARRAY This is a nested data structure. |
profileUpdatedAt DATE-TIME |
promoCode STRING |
readingList OBJECT This is a nested data structure. ARRAY This is a nested data structure. |
readingList.avgRating ARRAY This is a nested data structure. |
readingList.bookAuthor ARRAY This is a nested data structure. |
readingList.bookName ARRAY This is a nested data structure. |
readingList.imageUrl ARRAY This is a nested data structure. |
recommendedVehicles OBJECT This is a nested data structure. ARRAY This is a nested data structure. |
recommendedVehicles.TrueCar Estimate ARRAY This is a nested data structure. |
recommendedVehicles.category ARRAY This is a nested data structure. |
recommendedVehicles.estimateDescription ARRAY This is a nested data structure. |
recommendedVehicles.imageUrl ARRAY This is a nested data structure. |
recommendedVehicles.name ARRAY This is a nested data structure. |
recommendedVehicles.sku ARRAY This is a nested data structure. |
region STRING |
sat STRING |
scheduled_ride DATE-TIME |
selected_games STRING |
senate Districts STRING |
shoppingCartItems OBJECT This is a nested data structure. ARRAY This is a nested data structure. |
shoppingCartItems.categories ARRAY This is a nested data structure. |
shoppingCartItems.description ARRAY This is a nested data structure. |
shoppingCartItems.id ARRAY This is a nested data structure. |
shoppingCartItems.imageUrl ARRAY This is a nested data structure. |
shoppingCartItems.name ARRAY This is a nested data structure. |
shoppingCartItems.price ARRAY This is a nested data structure. |
shoppingCartItems.quantity ARRAY This is a nested data structure. |
shoppingCartItems.sku ARRAY This is a nested data structure. |
shoppingCartItems.url ARRAY This is a nested data structure. |
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 This is a nested data structure. |
unsubscribedMessageTypeIds ARRAY This is a nested data structure. |
uploaded_resume BOOLEAN |
userId STRING |
user_type STRING |
vegetarian_menu OBJECT This is a nested data structure. ARRAY This is a nested data structure. |
vegetarian_menu.featured_item_availability ARRAY This is a nested data structure. |
vegetarian_menu.featured_item_description ARRAY This is a nested data structure. |
vegetarian_menu.featured_item_id ARRAY This is a nested data structure. |
vegetarian_menu.featured_item_image_url ARRAY This is a nested data structure. |
vegetarian_menu.featured_item_menu_availability ARRAY This is a nested data structure. |
vegetarian_menu.featured_item_menu_date ARRAY This is a nested data structure. |
vip BOOLEAN |
wishList OBJECT This is a nested data structure. ARRAY This is a nested data structure. |
wishList.name ARRAY This is a nested data structure. |
wishList.price ARRAY This is a nested data structure. |
zip STRING |