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 |