Marketo

Setting up the Marketo connector

No	Item	Required	Example	Notes
1	Client ID	Yes		The Client ID of your Marketo developer application. See the docs for info on how to obtain this.
2	Client Secret	Yes		The Client Secret of your Marketo developer application. See the docs for info on how to obtain this.
3	Start Date	Yes	2020-09-25T00:00:00Z	UTC date and time in the format 2017-01-25T00:00:00Z. Any data before this date will not be replicated.
4	Domain URL	Yes	https://000-AAA-000.mktorest.com	Your Marketo Base URL. See the docs for info on how to obtain this.

Tables in the Marketo connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	campaigns	10	id	Full Refresh, Incremental	createdAt
2	lists	8	id	Full Refresh, Incremental	createdAt
3	leads	90	id	Full Refresh, Incremental	updatedAt
4	activity_types	5	id	Full Refresh
5	programs	12	id	Full Refresh, Incremental	updatedAt

Table: campaigns

No	Column Name	Type	Notes
1	createdAt	VARCHAR	Incremental sync key
2	programName	VARCHAR
3	name	VARCHAR
4	active	BOOLEAN
5	description	VARCHAR
6	workspaceName	VARCHAR
7	id	INTEGER	Primary Key
8	type	VARCHAR
9	programId	INTEGER
10	updatedAt	VARCHAR

Table: lists

No	Column Name	Type	Notes
1	createdAt	VARCHAR	Incremental sync key
2	programName	VARCHAR
3	name	VARCHAR
4	description	VARCHAR
5	workspaceName	VARCHAR
6	id	INTEGER	Primary Key
7	updatedAt	VARCHAR
8	workspaceId	INTEGER

Table: leads

No	Column Name	Type	Notes
1	contactCompany	VARCHAR
2	country	VARCHAR
3	leadStatus	VARCHAR
4	isLead	BOOLEAN
5	originalSourceInfo	VARCHAR
6	mainPhone	VARCHAR
7	originalSourceType	VARCHAR
8	mktoIsPartner	BOOLEAN
9	postalCode	VARCHAR
10	inferredPostalCode	VARCHAR
11	rating	VARCHAR
12	mktoName	VARCHAR
13	mktoPersonNotes	VARCHAR
14	inferredCompany	VARCHAR
15	createdAt	VARCHAR
16	mktoDoNotCallCause	VARCHAR
17	registrationSourceInfo	VARCHAR
18	registrationSourceType	VARCHAR
19	inferredMetropolitanArea	VARCHAR
20	billingCountry	VARCHAR
21	id	INTEGER	Primary Key
22	state	VARCHAR
23	fax	VARCHAR
24	anonymousIP	VARCHAR
25	relativeUrgency	INTEGER
26	updatedAt	VARCHAR	Incremental sync key
27	inferredStateRegion	VARCHAR
28	originalSearchEngine	VARCHAR
29	leadRevenueCycleModelId	VARCHAR
30	inferredCity	VARCHAR
31	originalSearchPhrase	VARCHAR
32	leadSource	VARCHAR
33	mktoIsCustomer	BOOLEAN
34	mktoAcquisitionDate	VARCHAR
35	billingState	VARCHAR
36	priority	INTEGER
37	numberOfEmployees	INTEGER
38	firstName	VARCHAR
39	externalSalesPersonId	VARCHAR
40	isAnonymous	BOOLEAN
41	externalCompanyId	VARCHAR
42	mobilePhone	VARCHAR
43	phone	VARCHAR
44	doNotCall	BOOLEAN
45	inferredPhoneAreaCode	VARCHAR
46	salutation	VARCHAR
47	annualRevenue	DOUBLE
48	marketingSuspendedCause	VARCHAR
49	leadScore	INTEGER
50	lastName	VARCHAR
51	personPrimaryLeadInterest	VARCHAR
52	city	VARCHAR
53	emailInvalidCause	VARCHAR
54	industry	VARCHAR
55	mktoCompanyNotes	VARCHAR
56	title	VARCHAR
57	marketingSuspended	BOOLEAN
58	doNotCallReason	VARCHAR
59	cookies	VARCHAR
60	unsubscribedReason	VARCHAR
61	originalReferrer	VARCHAR
62	personTimeZone	VARCHAR
63	blackListedCause	VARCHAR
64	leadPerson	VARCHAR
65	emailSuspended	BOOLEAN
66	urgency	DOUBLE
67	emailSuspendedAt	VARCHAR
68	leadRevenueStageId	VARCHAR
69	emailInvalid	BOOLEAN
70	company	VARCHAR
71	personType	VARCHAR
72	department	VARCHAR
73	email	VARCHAR
74	website	VARCHAR
75	address	VARCHAR
76	emailSuspendedCause	VARCHAR
77	dateOfBirth	VARCHAR
78	leadPartitionId	VARCHAR
79	blackListed	BOOLEAN
80	leadRole	VARCHAR
81	site	VARCHAR
82	unsubscribed	BOOLEAN
83	relativeScore	INTEGER
84	acquisitionProgramId	VARCHAR
85	inferredCountry	VARCHAR
86	billingStreet	VARCHAR
87	billingPostalCode	VARCHAR
88	sicCode	VARCHAR
89	middleName	VARCHAR
90	billingCity	VARCHAR

Table: activity_types

No	Column Name	Type	Notes
1	primaryAttribute	VARCHAR
2	name	VARCHAR
3	description	VARCHAR
4	attributes	VARCHAR
5	id	INTEGER	Primary Key

Table: programs

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	workspace	VARCHAR
3	folder	VARCHAR
4	name	VARCHAR
5	channel	VARCHAR
6	description	VARCHAR
7	id	INTEGER	Primary Key
8	type	VARCHAR
9	url	VARCHAR
10	headStart	BOOLEAN
11	updatedAt	VARCHAR	Incremental sync key
12	status	VARCHAR

External Resources

• Allowlisting Ip Addresses
• Marketo Documentation For Creating An Api-only Marketo User Role
• Marketo Documentation To Create An Api Only User
• Marketo Documentation For Creating A Custom Service For Use With A Rest Api
• Marketo Documentation For Obtaining Your Base Url
• Marketo Docs

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.