Iterable

Prerequisites

To set up the Iterable source connector, you'll need the Iterable Server-side API Key with standard permissions.

Setting up the Iterable connector

No	Item	Required	Example	Notes
1	API Key	Yes		Iterable API Key. See the docs for more information on how to obtain this key.
2	Start Date	Yes	2021-04-01T00:00:00Z	The date from which you'd like to replicate data for Iterable, in the format YYYY-MM-DDT00:00:00Z. All data generated after this date will be replicated.

Tables in the Iterable connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	metadata	1		Full Refresh		API Reference
2	campaigns_metrics	1		Full Refresh
3	email_send_skip	11		Full Refresh, Incremental	createdAt
4	templates	8		Full Refresh, Incremental	createdAt	API Reference
5	email_click	15		Full Refresh, Incremental	createdAt
6	email_subscribe	8		Full Refresh, Incremental	createdAt
7	list_users	2		Full Refresh
8	users	64		Full Refresh, Incremental	profileUpdatedAt	API Reference
9	message_types	3		Full Refresh
10	email_send	11		Full Refresh, Incremental	createdAt
11	email_bounce	7		Full Refresh, Incremental	createdAt
12	channels	4		Full Refresh		API Reference
13	campaigns	18		Full Refresh		API Reference
14	email_complaint	7		Full Refresh, Incremental	createdAt
15	lists	4		Full Refresh		API Reference
16	email_open	12		Full Refresh, Incremental	createdAt
17	email_unsubscribe	12		Full Refresh, Incremental	createdAt
18	events	5		Full Refresh		API Reference

Table: metadata

No	Column Name	Type	Notes
1	name	VARCHAR

Table: campaigns_metrics

No	Column Name	Type	Notes
1	data	VARCHAR

Table: email_send_skip

No	Column Name	Type	Notes
1	reason	VARCHAR
2	createdAt	VARCHAR	Incremental sync key
3	campaignId	INTEGER
4	itblInternal	VARCHAR
5	messageTypeId	INTEGER
6	transactionalData	VARCHAR
7	contentId	INTEGER
8	messageId	VARCHAR
9	templateId	INTEGER
10	email	VARCHAR
11	channelId	INTEGER

Table: templates

No	Column Name	Type	Notes
1	createdAt	VARCHAR	Incremental sync key
2	creatorUserId	VARCHAR
3	clientTemplateId	VARCHAR
4	campaignId	DOUBLE
5	messageTypeId	DOUBLE
6	name	VARCHAR
7	templateId	DOUBLE
8	updatedAt	INTEGER

Table: email_click

No	Column Name	Type	Notes
1	country	VARCHAR
2	city	VARCHAR
3	campaignId	INTEGER
4	itblInternal	VARCHAR
5	ip	VARCHAR
6	contentId	INTEGER
7	userAgentDevice	VARCHAR
8	messageId	VARCHAR
9	hrefIndex	INTEGER
10	userAgent	VARCHAR
11	templateId	INTEGER
12	url	VARCHAR
13	createdAt	VARCHAR	Incremental sync key
14	region	VARCHAR
15	email	VARCHAR

Table: email_subscribe

No	Column Name	Type	Notes
1	createdAt	VARCHAR	Incremental sync key
2	signupSource	VARCHAR
3	emailListIds	VARCHAR
4	itblInternal	VARCHAR
5	emailListId	INTEGER
6	email	VARCHAR
7	profileUpdatedAt	VARCHAR
8	workflowId	INTEGER

Table: list_users

No	Column Name	Type	Notes
1	listId	INTEGER
2	email	VARCHAR

Table: users

No	Column Name	Type	Notes
1	country	VARCHAR
2	firstOrderDate	VARCHAR
3	addresses	VARCHAR
4	aov	DOUBLE
5	firstCampaign	VARCHAR
6	thirdMostRecentOrderDate	VARCHAR
7	firstPurchaseDate	VARCHAR
8	firstMedium	VARCHAR
9	default_address	VARCHAR
10	emailListIds	VARCHAR
11	accepts_marketing	BOOLEAN
12	secondMostRecentOrderDate	VARCHAR
13	id	VARCHAR
14	state	VARCHAR
15	mostRecentCampaign	VARCHAR
16	emailSegmentStatus	VARCHAR
17	zip	VARCHAR
18	total_spent	DOUBLE
19	mostRecentOrderDate	VARCHAR
20	last_order_id	VARCHAR
21	tax_exempt	BOOLEAN
22	mostRecentEmailList	VARCHAR
23	mostRecentSource	VARCHAR
24	twelveMonthLtr	INTEGER
25	verified_email	BOOLEAN
26	mostRecentMedium	VARCHAR
27	orders_count	INTEGER
28	firstName	VARCHAR
29	lastInteractionTs	VARCHAR
30	boughtSas	BOOLEAN
31	secondMostRecentOrderCards	VARCHAR
32	unsubscribedChannelIds	VARCHAR
33	lastName	VARCHAR
34	last_order_name	VARCHAR
35	emailAcquiredDate	VARCHAR
36	secondOrderDate	VARCHAR
37	hasAccount	BOOLEAN
38	city	VARCHAR
39	mostRecentOrderCards	VARCHAR
40	itblInternal	VARCHAR
41	mostRecentEmailSegment	VARCHAR
42	hasReminder	BOOLEAN
43	thirdOrderDate	VARCHAR
44	subscribedMessageTypeIds	VARCHAR
45	firstSource	VARCHAR
46	unsubscribedMessageTypeIds	VARCHAR
47	first_name	VARCHAR
48	email	VARCHAR
49	thirdMostRecentOrderCards	VARCHAR
50	profileUpdatedAt	VARCHAR	Incremental sync key
51	signupDate	VARCHAR
52	businessLines	VARCHAR
53	secondOrderCards	VARCHAR
54	address1	VARCHAR
55	last_name	VARCHAR
56	ltr	INTEGER
57	userId	VARCHAR
58	shopify_created_at	VARCHAR
59	signupSource	VARCHAR
60	thirdOrderCards	VARCHAR
61	admin_graphql_api_id	VARCHAR
62	firstOrderCards	VARCHAR
63	totalOrders	INTEGER
64	shopify_updated_at	VARCHAR

Table: message_types

No	Column Name	Type	Notes
1	name	VARCHAR
2	id	DOUBLE
3	channelId	DOUBLE

Table: email_send

No	Column Name	Type	Notes
1	createdAt	VARCHAR	Incremental sync key
2	campaignId	INTEGER
3	itblInternal	VARCHAR
4	messageTypeId	INTEGER
5	transactionalData	VARCHAR
6	contentId	INTEGER
7	messageId	VARCHAR
8	messageBusId	VARCHAR
9	templateId	INTEGER
10	email	VARCHAR
11	channelId	INTEGER

Table: email_bounce

No	Column Name	Type	Notes
1	createdAt	VARCHAR	Incremental sync key
2	campaignId	INTEGER
3	itblInternal	VARCHAR
4	messageId	VARCHAR
5	templateId	INTEGER
6	email	VARCHAR
7	recipientState	VARCHAR

Table: channels

No	Column Name	Type	Notes
1	messageMedium	VARCHAR
2	name	VARCHAR
3	channelType	VARCHAR
4	id	DOUBLE

Table: campaigns

No	Column Name	Type	Notes
1	createdByUserId	VARCHAR
2	listIds	VARCHAR
3	campaignState	VARCHAR
4	messageMedium	VARCHAR
5	updatedByUserId	VARCHAR
6	templateId	INTEGER
7	type	VARCHAR
8	labels	VARCHAR
9	suppressionListIds	VARCHAR
10	createdAt	INTEGER
11	sendSize	DOUBLE
12	endedAt	INTEGER
13	name	VARCHAR
14	id	INTEGER
15	startAt	INTEGER
16	workflowId	DOUBLE
17	updatedAt	INTEGER
18	recurringCampaignId	DOUBLE

Table: email_complaint

No	Column Name	Type	Notes
1	createdAt	VARCHAR	Incremental sync key
2	campaignId	INTEGER
3	itblInternal	VARCHAR
4	messageId	VARCHAR
5	templateId	INTEGER
6	email	VARCHAR
7	recipientState	VARCHAR

Table: lists

No	Column Name	Type	Notes
1	createdAt	INTEGER
2	name	VARCHAR
3	id	INTEGER
4	listType	VARCHAR

Table: email_open

No	Column Name	Type	Notes
1	country	VARCHAR
2	createdAt	VARCHAR	Incremental sync key
3	city	VARCHAR
4	campaignId	INTEGER
5	itblInternal	VARCHAR
6	ip	VARCHAR
7	userAgentDevice	VARCHAR
8	messageId	VARCHAR
9	userAgent	VARCHAR
10	templateId	INTEGER
11	region	VARCHAR
12	email	VARCHAR

Table: email_unsubscribe

No	Column Name	Type	Notes
1	unsubSource	VARCHAR
2	createdAt	VARCHAR	Incremental sync key
3	emailListIds	VARCHAR
4	campaignId	INTEGER
5	itblInternal	VARCHAR
6	messageId	VARCHAR
7	templateId	INTEGER
8	channelIds	VARCHAR
9	emailListId	INTEGER
10	workflowId	INTEGER
11	email	VARCHAR
12	channelId	INTEGER

Table: events

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	data	VARCHAR
3	itblInternal	VARCHAR
4	_type	VARCHAR
5	email	VARCHAR

External Resources

• server-side Api Key With standard Permissions
• Iterable Api Key
• Campaign Metrics
• Email Bounce
• Email Click
• Email Complaint
• Email Open
• Email Send
• Email Send Skip
• Email Subscribe
• Email Unsubscribe
• List Users
• Message Types
• Pushsend
• Pushsendskip
• Pushopen
• Pushuninstall
• Pushbounce
• Webpushsend
• Webpushclick
• Webpushsendskip
• Inappsend
• Inappopen
• Inappclick
• Inappclose
• Inappdelete
• Inappdelivery
• Inappsendskip
• Inboxsession
• Inboxmessageimpression
• Smssend
• Smsbounce
• Smsclick
• Smsreceived
• Smssendskip
• Smsusageinfo
• Purchase
• Customevent
• Hostedunsubscribeclick

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.