Pardot

Tables in the Pardot connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	visitors	11	id	Full Refresh	updated_at
2	visits	24	id	Full Refresh	id
3	email_clicks	8	id	Full Refresh	id
4	campaigns	3	id	Full Refresh	id
5	lists	9	id	Full Refresh	updated_at
6	prospects	45	id	Full Refresh	updated_at
7	prospect_accounts	5	id	Full Refresh	updated_at
8	list_membership	6	id	Full Refresh	updated_at
9	visitor_activities	21	id	Full Refresh	id
10	opportunities	11
11	users	8	id	Full Refresh	created_at

Table: visitors

No	Column Name	Type	Notes
1	hostname	VARCHAR
2	medium_parameter	VARCHAR
3	updated_at	VARCHAR	Incremental sync key
4	source_parameter	VARCHAR
5	created_at	VARCHAR
6	page_view_count	INTEGER
7	term_parameter	VARCHAR
8	id	INTEGER	Primary Key
9	ip_address	VARCHAR
10	campaign_parameter	VARCHAR
11	content_parameter	VARCHAR

Table: visits

No	Column Name	Type	Notes
1	email_id	INTEGER
2	medium_parameter	VARCHAR
3	type_name	VARCHAR
4	first_visitor_page_view_at	VARCHAR
5	visitor_id	INTEGER
6	source_parameter	VARCHAR
7	created_at	VARCHAR
8	visitor_page_views	VARCHAR
9	type	INTEGER
10	last_visitor_page_view_at	VARCHAR
11	updated_at	VARCHAR
12	list_email_id	INTEGER
13	email_template_id	INTEGER
14	campaign	VARCHAR
15	term_parameter	VARCHAR
16	details	VARCHAR
17	id	INTEGER	Incremental sync key, Primary Key
18	visit_id	INTEGER
19	prospect_id	INTEGER
20	visitor_page_view_count	INTEGER
21	campaign_parameter	VARCHAR
22	content_parameter	VARCHAR
23	email	VARCHAR
24	duration_in_seconds	INTEGER

Table: email_clicks

No	Column Name	Type	Notes
1	list_email_id	INTEGER
2	email_template_id	INTEGER
3	drip_program_action_id	INTEGER
4	created_at	VARCHAR
5	tracker_redirect_id	INTEGER
6	id	INTEGER	Incremental sync key, Primary Key
7	prospect_id	INTEGER
8	url	VARCHAR

Table: campaigns

No	Column Name	Type	Notes
1	cost	INTEGER
2	name	VARCHAR
3	id	INTEGER	Incremental sync key, Primary Key

Table: lists

No	Column Name	Type	Notes
1	updated_at	VARCHAR	Incremental sync key
2	is_crm_visible	BOOLEAN
3	name	VARCHAR
4	is_public	BOOLEAN
5	is_dynamic	BOOLEAN
6	description	VARCHAR
7	created_at	VARCHAR
8	id	INTEGER	Primary Key
9	title	VARCHAR

Table: prospects

No	Column Name	Type	Notes
1	country	VARCHAR
2	notes	VARCHAR
3	city	VARCHAR
4	crm_contact_fid	VARCHAR
5	created_at	VARCHAR
6	industry	VARCHAR
7	source	VARCHAR
8	score	INTEGER
9	password	VARCHAR
10	updated_at	VARCHAR	Incremental sync key
11	prospect_account_id	INTEGER
12	last_activity_at	VARCHAR
13	recent_interaction	VARCHAR
14	company	VARCHAR
15	years_in_business	VARCHAR
16	id	INTEGER	Primary Key
17	state	VARCHAR
18	department	VARCHAR
19	fax	VARCHAR
20	first_name	VARCHAR
21	job_title	VARCHAR
22	campaign_id	INTEGER
23	email	VARCHAR
24	zip	VARCHAR
25	website	VARCHAR
26	crm_lead_fid	VARCHAR
27	comments	VARCHAR
28	last_name	VARCHAR
29	is_do_not_call	INTEGER
30	crm_last_sync	VARCHAR
31	opted_out	INTEGER
32	address_two	VARCHAR
33	crm_owner_fid	VARCHAR
34	crm_url	VARCHAR
35	is_reviewed	INTEGER
36	is_starred	INTEGER
37	phone	VARCHAR
38	address_one	VARCHAR
39	grade	VARCHAR
40	crm_account_fid	VARCHAR
41	salutation	VARCHAR
42	is_do_not_email	INTEGER
43	employees	VARCHAR
44	annual_revenue	VARCHAR
45	territory	VARCHAR

Table: prospect_accounts

No	Column Name	Type	Notes
1	updated_at	VARCHAR	Incremental sync key
2	name	VARCHAR
3	created_at	VARCHAR
4	id	INTEGER	Primary Key
5	assigned_to	VARCHAR

Table: list_membership

No	Column Name	Type	Notes
1	list_id	INTEGER
2	updated_at	VARCHAR	Incremental sync key
3	created_at	VARCHAR
4	id	INTEGER	Primary Key
5	opted_out	BOOLEAN
6	prospect_id	INTEGER

Table: visitor_activities

No	Column Name	Type	Notes
1	email_id	INTEGER
2	paid_search_id_id	INTEGER
3	multivariate_test_variation_id	INTEGER
4	type_name	VARCHAR
5	visitor_id	INTEGER
6	form_id	INTEGER
7	created_at	VARCHAR
8	visitor_page_view_id	INTEGER
9	type	INTEGER
10	updated_at	VARCHAR
11	email_template_id	INTEGER
12	list_email_id	INTEGER
13	file_id	INTEGER
14	landing_page_id	INTEGER
15	campaign	VARCHAR
16	details	VARCHAR
17	id	INTEGER	Incremental sync key, Primary Key
18	site_search_query_id	INTEGER
19	prospect_id	INTEGER
20	campaign_id	INTEGER
21	form_handler_id	INTEGER

Table: opportunities

No	Column Name	Type	Notes
1	closed_at	VARCHAR
2	stage	VARCHAR
3	updated_at	VARCHAR
4	probability	INTEGER
5	name	VARCHAR
6	created_at	VARCHAR
7	id	INTEGER
8	type	VARCHAR
9	value	DOUBLE
10	campaign_id	INTEGER
11	status	VARCHAR

Table: users

No	Column Name	Type	Notes
1	role	VARCHAR
2	updated_at	VARCHAR
3	last_name	VARCHAR
4	created_at	VARCHAR	Incremental sync key
5	id	INTEGER	Primary Key
6	first_name	VARCHAR
7	job_title	VARCHAR
8	email	VARCHAR

External Resources

• Salesforce Pardot

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.