Pardot

Explore the interactive ERD

Table & Field Reference

tag_object

Column	Type	Keys
`object_id`	Long	PK
`tag_id`	Long	PKFK

list_email_list

Column	Type	Keys
`role`	String	PK
`list_email_id`	Long	PKFK
`list_id`	Long	PKFK

opportunity_prospect

Column	Type	Keys
`opportunity_id`	Long	PKFK
`prospect_id`	Long	PKFK
`updated_at`	Instant

email_template

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`created_by_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`folder_id`	Long
`html_message`	String
`is_auto_responder_email`	Boolean
`is_drip_email`	Boolean
`is_list_email`	Boolean
`is_one_to_one_email`	Boolean
`name`	String
`subject`	String
`tag_replacement_language`	String
`text_message`	String
`tracker_domain_id`	Long
`type`	String
`updated_at`	Instant

visitor_activity

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`email_id`	Long	FK
`email_template_id`	Long	FK
`list_email_id`	Long	FK
`opportunity_id`	String	FK
`prospect_id`	Long	FK
`visit_id`	Long	FK
`visitor_id`	Long	FK
`created_at`	Instant
`custom_redirect_id`	Long
`details`	String
`file_id`	Long
`form_handler_id`	Long
`form_id`	Long
`landing_page_id`	Long
`multivariate_test_variation_id`	Long
`paid_search_ad_id`	Long
`site_search_query_id`	Long
`type`	Long
`type_name`	String
`updated_at`	Instant
`visitor_page_view_id`	Long

reply_to_option

Column	Type	Keys
`_fivetran_id`	String	PK
`account_custom_field_id`	Long	FK
`email_template_id`	Long	FK
`prospect_custom_field_id`	Long	FK
`user_id`	Long	FK
`address`	String
`type`	String

lifecycle_stage

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`is_locked`	Boolean
`match_type`	String
`name`	String
`position`	Int
`updated_at`	Instant

form_handler

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`created_by_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`embed_code`	String
`error_location`	String
`folder_id`	Long
`is_always_email`	Boolean
`is_cookieless`	Boolean
`is_data_forwarded`	Boolean
`is_deleted`	Boolean
`name`	String
`salesforce_id`	String
`success_location`	String
`tracker_domain_id`	Long
`updated_at`	Instant

prospect

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`prospect_account_id`	Long	FK
`user_id`	Long	FK
`address_one`	String
`address_two`	String
`annual_revenue`	String
`city`	String
`comments`	String
`company`	String
`country`	String
`created_at`	Instant
`crm_account_fid`	String
`crm_contact_fid`	String
`crm_last_sync`	Instant
`crm_lead_fid`	String
`crm_owner_fid`	String
`crm_url`	String
`department`	String
`email`	String
`employees`	String
`fax`	String
`first_name`	String
`grade`	String
`industry`	String
`is_do_not_call`	Boolean
`is_do_not_email`	Boolean
`is_permanently_deleted`	Boolean
`is_reviewed`	Boolean
`is_starred`	Boolean
`job_title`	String
`last_activity_at`	Instant
`last_name`	String
`notes`	String
`opted_out`	Boolean
`password`	String
`phone`	String
`recent_interaction`	String
`salutation`	String
`score`	Long
`source`	String
`state`	String
`territory`	String
`updated_at`	Instant
`website`	String
`years_in_business`	String
`zip`	String

form_field_progressive

Column	Type	Keys
`prospect_api_field_id`	String	PK
`form_field_id`	Long	PKFK

form_field

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`form_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`css_classes`	String
`data_format`	String
`error_message`	String
`has_dependents`	Boolean
`has_progressives`	Boolean
`has_values`	Boolean
`is_always_display`	Boolean
`is_do_not_prefill`	Boolean
`is_maintain_initial_value`	Boolean
`is_required`	Boolean
`label`	String
`prospect_api_field_id`	String
`sort_order`	Int
`type`	String
`updated_at`	Instant

email

Column	Type	Keys
`id`	Long	PK
`list_email_id`	Long	FK
`campaign_id`	Long
`client_type`	String
`created_at`	Instant
`created_by_id`	Long
`list_id`	Long
`name`	String
`prospect_id`	Long
`subject`	String

visitor_page_view

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`visit_id`	Long	FK
`visitor_id`	Long	FK
`created_at`	Instant
`duration_in_seconds`	Long
`salesforce_id`	String
`title`	String
`url`	String

engagement_studio_program

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`schedule_created_by_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`description`	String
`folder_id`	Long
`name`	String
`prospects_multiple_entry_maximum_entries`	Int
`prospects_multiple_entry_minimum_duration_in_days`	Int
`recipient_list_ids`	String
`salesforce_id`	String
`schedule_created_at`	Instant
`schedule_start_on`	Instant
`schedule_stop_on`	Instant
`status`	String
`suppression_list_ids`	String
`updated_at`	Instant
`business_hours_`

form_field_dependent

Column	Type	Keys
`dependent_form_field_id`	Long	PKFK
`form_field_id`	Long	PKFK
`value`	String

landing_page

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`created_by_id`	Long	FK
`form_id`	Long	FK
`updated_by_id`	Long	FK
`archive_date`	LocalDate
`bitly_is_personalized`	Boolean
`bitly_short_url`	String
`created_at`	Instant
`description`	String
`folder_id`	Long
`is_do_not_index`	Boolean
`is_use_redirect_location`	Boolean
`layout_table_border`	Int
`layout_template_id`	Long
`layout_type`	String
`name`	String
`redirect_location`	String
`salesforce_id`	String
`title`	String
`tracker_domain_id`	Long
`updated_at`	Instant
`url`	String
`vanity_url`	String
`vanity_url_path`	String

opportunity

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`closed_at`	Instant
`created_at`	Instant
`name`	String
`probability`	Long
`stage`	String
`status`	String
`type`	String
`updated_at`	Instant
`value`	Double

external_activity

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`prospect_id`	Long	FK
`activity_date`	Instant
`created_at`	Instant
`extension`	String
`extension_salesforce_id`	String
`type`	String
`type_salesforce_id`	String
`value`	String

visit

Column	Type	Keys
`id`	Long	PK
`prospect_id`	Long	FK
`visitor_id`	Long	FK
`campaign_parameter`	String
`content_parameter`	String
`created_at`	Instant
`duration_in_seconds`	Long
`first_visitor_page_view_at`	Instant
`last_visitor_page_view_at`	Instant
`medium_parameter`	String
`source_parameter`	String
`term_parameter`	String
`updated_at`	Instant
`visitor_page_view_count`	Long

custom_field

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`field_id`	String
`is_analytics_synced`	Boolean
`is_record_multiple_responses`	Boolean
`is_required`	Boolean
`is_use_values`	Boolean
`name`	String
`salesforce_id`	String
`type`	String
`updated_at`	Instant

lifecycle_history

Column	Type	Keys
`id`	Long	PK
`next_stage_id`	Long	FK
`previous_stage_id`	Long	FK
`prospect_id`	Long	FK
`created_at`	Instant
`seconds_elapsed`	Int

custom_redirect

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`created_by_id`	Long	FK
`updated_by_id`	Long	FK
`bitly_is_personalized`	Boolean
`bitly_short_url`	String
`created_at`	Instant
`destination_url`	String
`folder_id`	Long
`ga_campaign`	String
`ga_content`	String
`ga_medium`	String
`ga_source`	String
`ga_term`	String
`name`	String
`salesforce_id`	String
`tracked_url`	String
`tracker_domain_id`	Long
`updated_at`	Instant
`url`	String
`vanity_url`	String
`vanity_url_path`	String

campaign

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`parent_campaign_id`	String	FK
`updated_by_id`	Long	FK
`cost`	Long
`created_at`	Instant
`folder_id`	Long
`name`	String
`salesforce_id`	String
`updated_at`	Instant

prospect_account

Column	Type	Keys
`id`	Long	PK
`name`	String

sender_option

Column	Type	Keys
`_fivetran_id`	String	PK
`account_custom_field_id`	Long	FK
`email_template_id`	Long	FK
`prospect_custom_field_id`	Long	FK
`user_id`	Long	FK
`address`	String
`name`	String
`type`	String

list

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`created_by_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`description`	String
`folder_id`	Long
`is_dynamic`	Boolean
`is_public`	Boolean
`name`	String
`title`	String
`updated_at`	Instant

list_email

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`email_template_id`	Long	FK
`client_type`	String
`created_at`	Instant
`created_by_id`	Long
`html_message`	String
`is_deleted`	Boolean
`is_paused`	Boolean
`is_sent`	Boolean
`name`	String
`operational_email`	Boolean
`sent_at`	Instant
`subject`	String
`text_message`	String
`tracker_domain_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

form_handler_field

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`form_handler_id`	Long	FK
`created_at`	Instant
`data_format`	String
`error_message`	String
`is_maintain_initial_value`	Boolean
`is_required`	Boolean
`name`	String
`prospect_api_field_id`	String

user

Column	Type	Keys
`id`	Long	PK
`account`	Int
`created_at`	Instant
`email`	String
`first_name`	String
`job_title`	String
`last_name`	String
`role`	String
`updated_at`	Instant

tag

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`updated_at`	Instant

list_membership

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`list_id`	Long	FK
`prospect_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`opted_out`	Boolean
`updated_at`	Instant

visitor

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`prospect_id`	Long	FK
`campaign_parameter`	String
`content_parameter`	String
`created_at`	Instant
`do_not_sell`	Boolean
`hostname`	String
`ip_address`	String
`is_identified`	Boolean
`medium_parameter`	String
`page_view_count`	Long
`source_parameter`	String
`term_parameter`	String
`updated_at`	Instant

form_field_value

Column	Type	Keys
`sort_order`	Long	PK
`form_field_id`	Long	PKFK
`list_id`	Long	FK
`label`	String
`profile_id`	Long
`value`	String

form

Column	Type	Keys
`id`	Long	PK
`campaign_id`	Long	FK
`created_by_id`	Long	FK
`updated_by_id`	Long	FK
`after_form_content`	String
`before_form_content`	String
`checkbox_alignment`	String
`created_at`	Instant
`embed_code`	String
`folder_id`	Long
`font_color`	String
`font_family`	String
`font_size`	String
`is_always_display`	Boolean
`is_captcha_enabled`	Boolean
`is_cookieless`	Boolean
`is_use_redirect_location`	Boolean
`label_alignment`	String
`layout_template_id`	String
`name`	String
`radio_alignment`	String
`redirect_location`	String
`required_character`	String
`salesforce_id`	String
`show_not_prospect`	Boolean
`submit_button_text`	String
`thank_you_code`	String
`thank_you_content`	String
`tracker_domain_id`	Long
`updated_at`	Instant