Pardot: Lists

Description

• Each record represents a list in Pardot.

Supported Data Sources

• Pardot

Columns

Type	Name	Description
INTEGER	list_id	Pardot ID of this list
STRING	name	List's name (internal to Pardot)
STRING	description	List's description
STRING	title	List's title (visible to subscribers)
BOOLEAN	is_crm_visible	If true, list is visible in CRM to add or remove from
BOOLEAN	is_public	If true, list will show on EPC pages to prospects
BOOLEAN	is_dynamic	If true, list has prospects dynamically added to it via a set of chosen rules
STRING	created_timestamp	Time list is created in Pardot.
STRING	updated_timestamp	Last time list was updated
DATETIME	_fivetran_synced	The timestamp of when a record was last synced by Fivetran.
INTEGER	count_activity_emails	Count of email activities associated with the members of the list.
INTEGER	count_activity_visits	Count of visit activities associated with the members of the list.
STRING	most_recent_email_activity_timestamp	Timestamp of most recent email activity of a list member
STRING	most_recent_visit_activity_timestamp	Timestamp of most recent visit activity of a list member