Pardot: Prospects

Description

• Each record in the table represents a prospect in Pardot.

Supported Data Sources

• Pardot

Columns

Type	Name	Description
INTEGER	prospect_id	Pardot ID for this prospect
BOOLEAN	_fivetran_deleted	Boolean representing whether the record has been deleted in the source system.
DATETIME	_fivetran_synced	The timestamp of when a record was last synced by Fivetran.
INTEGER	address_one	Prospect's address, line 1
INTEGER	address_two	Prospect's address, line 2
INTEGER	annual_revenue	Prospect's annual revenue
INTEGER	campaign_id	Pardot ID of the campaign associated with this prospect
STRING	city	Prospect's city
INTEGER	comments	Comments about this prospect
STRING	company	Prospect's company
STRING	country	Prospect's country
STRING	created_timestamp	Time prospect is created in Pardot; Time is reported in API user's preferred timezone
INTEGER	crm_account_fid	Account ID in a supported CRM system
STRING	crm_contact_fid	Prospect's contact ID in a supported CRM system
STRING	crm_last_sync	Last time this prospect was synced with a supported CRM system
INTEGER	crm_lead_fid	Prospect's lead ID in a supported CRM system
STRING	crm_owner_fid	Prospect's owner ID in a supported CRM system
STRING	crm_url	URL to view the prospect within the CRM system
INTEGER	department	Prospect's department
STRING	email	Prospect's email address
INTEGER	employees	Prospect's number of employees
INTEGER	fax	Prospect's fax number
STRING	first_name	Prospect's first name
STRING	grade	Prospect's letter grade
STRING	industry	Prospect's industry
INTEGER	is_do_not_call	If value is 1, prospect prefers not to be called
BOOLEAN	is_do_not_email	If value is 1, prospect prefers not to be emailed
BOOLEAN	is_reviewed	If value is 1, prospect has been reviewed
INTEGER	is_starred	If value is 1, prospect has been starred
STRING	job_title	Prospect's job title
INTEGER	last_activity_at	Time stamp of this prospect's latest visitor activity; Time is reported in API user's preferred timezone
STRING	last_name	Prospect's last name
INTEGER	notes	Notes about this prospect
INTEGER	opted_out	If value is 1, prospect has opted out of marketing communications
INTEGER	password	Prospect's password
STRING	phone_number	Prospect's phone number
INTEGER	prospect_account_id	Prospect's account ID
STRING	recent_interaction	Describes the prospect's most recent interaction with Pardot
INTEGER	salutation	Prospect's formal prefix
INTEGER	score	Prospect's score
STRING	prospect_source	Prospect's source
STRING	state	Prospect's US state
INTEGER	territory	Prospect's territory
STRING	updated_timestamp	Last time prospect was updated in Pardot; Time is reported in API user's preferred timezone
INTEGER	user_id	Pardot ID of the user associated with this prospect
STRING	website	Prospect's website URL
INTEGER	years_in_business	Prospect's number of years in business
INTEGER	zip	Prospect's postal code
INTEGER	count_activity_visits	Count of visit activities associated with the prospect.
INTEGER	count_activity_emails	Count of email activities associated with the prospect.
STRING	most_recent_visit_activity_timestamp	Timestamp of most recent visit activity of the prospect.
STRING	most_recent_email_activity_timestamp	Timestamp of most recent email activity of the prospect.