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 | 如您的使用情況有需要，選取 資料移動閘道。 資訊備註 此欄位無法用於 Qlik Talend Cloud 啟動器 訂閱，因為不支援 資料移動閘道。若您有另一個訂閱層級且不想使用 資料移動閘道，選取無。 如需關於 資料移動閘道 福利的資訊以及需要此項的使用案例，請參閱 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 |