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 项目 仅 Replication 项目。不支持数据管道项目。 无需手动生成元数据。 只支持更改列数据类型操作。 复制 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 Starter 订阅，因为它不支持 数据移动网关。如果您有另一个订阅层并且不想使用 数据移动网关，请选择无。 有关 数据移动网关 的优势和需要它的用例的信息，请参阅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 |