Pardot Field Reference

Sample
The Salesforce Pardot connector fetches data from the Pardot API
Fields
ID | Type | Name | Description |
---|---|---|---|
account_address_one | TEXT | Account Address One | Account contact address, line 1. |
account_address_two | TEXT | Account Address Two | Account contact address, line 2. |
account_admin_id | TEXT | Account Admin ID | ID of the individual who is the admin for this account. |
account_api_calls_used | TEXT | Account API Calls Used | Total daily API requests based on the timezone for this account. |
account_city | CITY | Account City | Account contact city. |
account_company | TEXT | Account Company | Account company. |
account_country | COUNTRY | Account Country | Account contact country (full string). |
account_created_at | TIMESTAMP | Account Created At | The timestamp of when this object was created. |
account_created_by_id | TEXT | Account Created By ID | ID of the individual who created this object. |
account_fax | TEXT | Account Fax | Account contact fax number. |
account_id | TEXT | Account ID | Account Engagement ID for this instance. |
account_level | TEXT | Account Level | The level of product for the account. |
account_maximum_daily_api_calls | TEXT | Account Maximum Daily API Calls | Maximum daily API requests based on the timezone for this account. |
account_phone | TEXT | Account Phone | Account contact phone number. |
account_plugin_campaign_id | TEXT | Account Plugin Campaign ID | Plugin ID for account campaign. |
account_state | TEXT | Account State | Account contact state. |
account_territory | TEXT | Account Territory | Account contact ZIP code. |
account_updated_at | TIMESTAMP | Account Updated At | The timestamp of when this object was last updated. |
account_updated_by_id | TEXT | Account Updated By ID | ID of the individual who created this object. |
account_website | TEXT | Account Website | Account website. |
account_zip | TEXT | Account Zip | Account contact territory. |
activity_campaign_id | TEXT | Activity Campaign ID | Account Engagement ID for the associated campaign. |
activity_created_at | TIMESTAMP | Activity Created At | Time that visitor activity occurred; Time is reported in API user's preferred timezone. |
activity_custom_redirect_id | TEXT | Activity Custom Redirect ID | Account Engagement ID of the custom redirect associated with this visitor activity Note: Appears only if this visitor activity has a custom redirect associated with it. |
activity_details | TEXT | Activity Details | Details about this visitor activity such as the name of the object associated with this activity, the search phrase used in a site search query, etc. |
activity_email_id | TEXT | Activity Email ID | Account Engagement ID of the email associated with this visitor activity. Appears only if this visitor activity has an email associated with it. |
activity_email_template_id | TEXT | Activity Email Template ID | Account Engagement ID of the email template associated with this visitor activity. Appears only if this visitor activity has an email associated with it. |
activity_file_id | TEXT | Activity File ID | Account Engagement ID of the file associated with this visitor activity. Appears only if this visitor activity has a file associated with it. |
activity_form_handler_id | TEXT | Activity Form Handler ID | Account Engagement ID of the form handler associated with this visitor activity. Appears only if this visitor activity has a form handler associated with it. |
activity_form_id | TEXT | Activity Form ID | Account Engagement ID of the form associated with this visitor activity. Appears only if this visitor activity has a form associated with it. |
activity_id | TEXT | Activity Account ID | Account Engagement ID for this visitor activity. |
activity_landing_page_id | TEXT | Activity Landing Page ID | Account Engagement ID of the landing page associated with this visitor activity. Appears only if this visitor activity has a landing page associated with it. |
activity_list_email_id | TEXT | Activity List Email ID | Account Engagement ID of the list email associated with this visitor activity. Appears only if this visitor activity has an email associated with it. |
activity_multivariate_test_variation_id | TEXT | Activity Multivariate Test Variation ID | Account Engagement ID of the multivariate test variation associated with this visitor activity. Appears only if this visitor activity has a multivariate test variation associated with it. |
activity_opportunity_id | TEXT | Activity Opportunity ID | Account Engagement ID for the associated opportunity. |
activity_paid_search_ad_id | TEXT | Activity Paid Search Ad ID | Account Engagement ID of the paid search ad associated with this visitor activity. Appears only if this visitor activity has a paid search ad associated with it. |
activity_prospect_id | TEXT | Activity Prospect ID | Account Engagement ID for the associated prospect. |
activity_site_search_query_id | TEXT | Activity Site Search Query ID | Account Engagement ID of the site search query associated with this visitor activity. Appears only if this visitor activity has a site search query associated with it. |
activity_type | TEXT | Activity Type | Visitor activity's type number. |
activity_type_name | TEXT | Activity Type Name | Visitor activity's type name. |
activity_updated_at | TIMESTAMP | Activity Updated At | Time that visitor activity update occurred; Time is reported in API user's preferred timezone. |
activity_visit_id | TEXT | Activity Visit ID | Account Engagement ID for the associated visit. |
activity_visitor_id | TEXT | Activity Visitor ID | Account Engagement ID for the associated visitor. |
activity_visitor_page_view_id | TEXT | Activity Visitor Page View ID | Account Engagement ID for the associated visitor page view. |
campaign | TEXT | Campaign | The Campaign Name |
campaign_cost | NUMERIC | Campaign Cost | Cost of the campaign object. |
campaign_created_at | TIMESTAMP | Campaign Created At | The timestamp of when this object was created. |
campaign_created_by_id | TEXT | Campaign Created By Id | ID of the individual who created this object. |
campaign_folder_id | TEXT | Campaign Folder Id | ID of the folder containing this object. |
campaign_id | TEXT | Campaign Id | ID of the object. |
campaign_is_deleted | BOOLEAN | Campaign Is Deleted | True if the object is in the recycle bin in Account Engagement. |
campaign_name | TEXT | Campaign Name | Name of the object for identification in Account Engagement. |
campaign_parent_campaign_id | TEXT | Campaign Parent Campaign Id | The ID of the parent campaign. |
campaign_salesforce_id | TEXT | Campaign Salesforce Id | Salesforce Id of the object. |
campaign_updated_at | TIMESTAMP | Campaign Updated At | The timestamp of when this object was last updated. |
campaign_updated_by_id | TEXT | Campaign Updated By Id | ID of the individual who last updated this object. |
date | DATE | Date | The Date |
email_campaign_id | TEXT | Email Campaign Id | ID of the campaign associated with the email. |
email_client_type | TEXT | Email Client Type | Value is 'Builder' if the email was sent via the Lightning Email Builder. Value is 'Web' if it was sent via the legacy Pardot email builder. |
email_created_by_id | TEXT | Email Created By Id | ID of the user who created this object. |
email_html_message | TEXT | Email Html Message | The HTML content of the email's message. This field isn’t queryable. |
email_id | TEXT | Email Id | ID of the email. |
email_list_email_id | TEXT | Email List Email Id | ID of the list email associated with this email. |
email_list_id | TEXT | Email List Id | Deprecated, always NULL. Reference the List Email object's reciepientLists and suppressionLists fields for all lists associated with the email. |
email_name | TEXT | Email Name | Name of the email for identification in Pardot. |
email_sent_at | TIMESTAMP | Email Sent At | Time the email was sent. |
email_subject | TEXT | Email Subject | The email subject. |
email_text_message | TEXT | Email Text Message | The text content of the email's message. This field isn’t queryable. |
opportunity_campaign_id | TEXT | Opportunity Campaign ID | Account Engagement ID of the campaign associated with this opportunity. Information about an opportunity's campaign association can be returned using the Campaign relationship. |
opportunity_closed_at | TIMESTAMP | Opportunity Closed At | The opportunity's closed date. When left blank, the Closed Date field in Account Engagement isn’t set, even when the opportunity's stage, status, or probability are set to indicate that the opportunity is closed. |
opportunity_created_at | TIMESTAMP | Opportunity Created At | Time opportunity is created in Account Engagement; Time is reported in API user's preferred timezone. |
opportunity_created_by_id | TEXT | Opportunity Created By ID | ID of the user who created this object. |
opportunity_id | TEXT | Opportunity ID | Account Engagement ID for this opportunity. |
opportunity_name | TEXT | Opportunity Name | The opportunity's name |
opportunity_probability | NUMERIC | Opportunity Probability | The opportunity's probability. Must be a positive numeric value from 0 through 100, inclusive. |
opportunity_salesforce_id | TEXT | Opportunity Salesforce ID | The ID of the associated opportunity in Salesforce. |
opportunity_stage | TEXT | Opportunity Stage Name | The opportunity's stage. |
opportunity_status | TEXT | Opportunity Status | The opportunity's status. Status must be either won, lost, or open. |
opportunity_type | TEXT | Opportunity Type | The opportunity's type. |
opportunity_updated_at | TIMESTAMP | Opportunity Updated At | Last time opportunity was updated in Account Engagement; Time is reported in API user's preferred timezone. |
opportunity_updated_by_id | TEXT | Opportunity Updated By ID | ID of the user who last updated this object. |
opportunity_value | NUMERIC | Opportunity Value | The opportunity's value. Must be a positive numeric value. |
prospect_account_annual_revenue | NUMERIC | Prospect Account Annual Revenue | Annual Revenue of the object. |
prospect_account_assigned_to | TEXT | Prospect Account Assigned To | User object representing the user who the object record is assigned to. See documentation for User for fields. |
prospect_account_assigned_to_id | TEXT | Prospect Account Assigned To Id | ID of the user who the object record is assigned to. |
prospect_account_billing_address_one | TEXT | Prospect Account Billing Address One | Billing Address of the object. |
prospect_account_billing_address_two | TEXT | Prospect Account Billing Address Two | Second Billing Address of the object. |
prospect_account_billing_city | CITY | Prospect Account Billing City | City of the object. |
prospect_account_billing_country | COUNTRY | Prospect Account Billing Country | County of the object. |
prospect_account_billing_state | TEXT | Prospect Account Billing State | State of the object. |
prospect_account_billing_zip | TEXT | Prospect Account Billing Zip | Zip of the object. |
prospect_account_created_at | TIMESTAMP | Prospect Account Created At | Creation time of the object. |
prospect_account_created_by | TEXT | Prospect Account Created By | User object representing the user who created this object. See documentation for User for fields. |
prospect_account_created_by_id | TEXT | Prospect Account Created By Id | ID of the user who created this object. |
prospect_account_description | TEXT | Prospect Account Description | Description of the object. |
prospect_account_employees | TEXT | Prospect Account Employees | Employees of the object. |
prospect_account_fax | TEXT | Prospect Account Fax | Fax of the object. |
prospect_account_id | TEXT | Prospect Account Id | ID of the object. |
prospect_account_industry | TEXT | Prospect Account Industry | Industry of the object. |
prospect_account_is_deleted | BOOLEAN | Prospect Account Is Deleted | True if the object is in the recycle bin in Account Engagement. |
prospect_account_name | TEXT | Prospect Account Name | Name of the object for identification in Account Engagement. |
prospect_account_number | TEXT | Prospect Account Number | Number of the object. |
prospect_account_ownership | TEXT | Prospect Account Ownership | Ownership of the object. |
prospect_account_phone | TEXT | Prospect Account Phone | Phone Number of the object. |
prospect_account_rating | TEXT | Prospect Account Rating | Rating of the object. |
prospect_account_shipping_address_one | TEXT | Prospect Account Shipping Address One | Shipping Address of the object. |
prospect_account_shipping_address_two | TEXT | Prospect Account Shipping Address Two | Second Shipping Address of the object. |
prospect_account_shipping_city | CITY | Prospect Account Shipping City | Shipping Address city of the object. |
prospect_account_shipping_country | COUNTRY | Prospect Account Shipping Country | Shipping Address country of the object. |
prospect_account_shipping_state | TEXT | Prospect Account Shipping State | Shipping Address state of the object. |
prospect_account_shipping_zip | TEXT | Prospect Account Shipping Zip | Shipping Address zip of the object. |
prospect_account_sic | TEXT | Prospect Account Sic | SIC of the object. |
prospect_account_site | TEXT | Prospect Account Site | Site of the object. |
prospect_account_ticker_symbol | TEXT | Prospect Account Ticker Symbol | Ticker Symbol of the object. |
prospect_account_type | TEXT | Prospect Account Type | Type of the object. |
prospect_account_updated_at | TIMESTAMP | Prospect Account Updated At | Last update time of the object. |
prospect_account_updated_by | TEXT | Prospect Account Updated By | User object representing the user who last updated this object. See documentation for User for fields. |
prospect_account_updated_by_id | TEXT | Prospect Account Updated By Id | ID of the user who last updated this object. |
prospect_account_website | TEXT | Prospect Account Website | Website of the object. |
prospect_address_one | TEXT | Prospect Address One | Prospect's address, line 1. |
prospect_address_two | TEXT | Prospect Address Two | Prospect's address, line 2. |
prospect_annual_revenue | TEXT | Prospect Annual Revenue | Prospect's annual revenue. |
prospect_assigned_to | TEXT | Prospect Assigned To | User the prospect is assigned to. |
prospect_assigned_to_id | TEXT | Prospect Assigned To Id | User the prospect is assigned to. |
prospect_campaign_id | TEXT | Prospect Campaign Id | Account Engagement campaign related to this object. |
prospect_campaign_parameter | TEXT | Prospect Campaign Parameter | Prospect's campaign parameter utm_campaign from Google Analytics. |
prospect_city | CITY | Prospect City | Prospect's city. |
prospect_comments | TEXT | Prospect Comments | Comments about this prospect. |
prospect_company | TEXT | Prospect Company | Prospect's company. |
prospect_content_parameter | TEXT | Prospect Content Parameter | Prospect's content parameter utm_content from Google Analytics. |
prospect_converted_at | TIMESTAMP | Prospect Converted At | Time when prospect was converted from visitor. |
prospect_converted_from_object_name | TEXT | Prospect Converted From Object Name | Name of object associated with visitor activity that resulted in prospect being converted from visitor. |
prospect_converted_from_object_type | TEXT | Prospect Converted From Object Type | Type of object associated with visitor activity that resulted in prospect being converted from visitor. Supported values include 'Form', 'FormHandler', 'LandingPage', 'MultivariateTestVariation', and 'Video'. |
prospect_country | COUNTRY | Prospect Country | Prospect's country. |
prospect_created_at | TIMESTAMP | Prospect Created At | Creation time of the object. |
prospect_created_by | TEXT | Prospect Created By | User who created this object. |
prospect_created_by_id | TEXT | Prospect Created By Id | ID of the user who created this object. |
prospect_department | TEXT | Prospect Department | Prospect's department. |
prospect_do_not_sell | TEXT | Prospect Do Not Sell | Indicates whether the prospect, or a visitor associated with the propect, recorded an activity with the Global Privacy Control Header enabled. |
prospect_email | TEXT | Prospect Email | Prospect's email address. |
prospect_email_bounced_at | TIMESTAMP | Prospect Email Bounced At | Time when prospect email address hard bounced. |
prospect_email_bounced_reason | TEXT | Prospect Email Bounced Reason | Reason why prospect email address hard bounced. |
prospect_employees | TEXT | Prospect Employees | Prospect's number of employees. |
prospect_fax | TEXT | Prospect Fax | Prospect's fax number. |
prospect_first_activity_at | TIMESTAMP | Prospect First Activity At | Time when first visitor activity occurred for this prospect. |
prospect_first_assigned_at | TIMESTAMP | Prospect First Assigned At | Time prospect was first assigned to a user. |
prospect_first_name | TEXT | Prospect First Name | Prospect's first name. |
prospect_first_referrer_query | TEXT | Prospect First Referrer Query | First referrer's search query. |
prospect_first_referrer_type | TEXT | Prospect First Referrer Type | First referrer's vendor and type (such as 'Google Natural Search'). |
prospect_first_referrer_url | TEXT | Prospect First Referrer URL | First referrer's URL. |
prospect_grade | TEXT | Prospect Grade | Prospect's letter grade. |
prospect_id | TEXT | Prospect ID | ID of the object. |
prospect_industry | TEXT | Prospect Industry | Prospect's industry. |
prospect_is_deleted | TEXT | Prospect Is Deleted | True if the object is in the recycle bin in Account Engagement. |
prospect_is_do_not_call | TEXT | Prospect Is Do Not Call | If true, prospect prefers not to be called. |
prospect_is_do_not_email | TEXT | Prospect Is Do Not Email | If true, prospect prefers not to be emailed. |
prospect_is_email_hard_bounced | TEXT | Prospect Is Email Hard Bounced | If true, prospect email address has hard bounced. |
prospect_is_reviewed | TEXT | Prospect Is Reviewed | If true, prospect has been reviewed. |
prospect_is_starred | TEXT | Prospect Is Starred | If true, prospect has been starred. |
prospect_job_title | TEXT | Prospect Job Title | Prospect's job title. |
prospect_last_activity_at | TIMESTAMP | Prospect Last Activity At | Time stamp of this prospect's latest visitor activity. |
prospect_last_name | TEXT | Prospect Last Name | Prospect's last name. |
prospect_lifecycle_stage_id | TEXT | Prospect Lifecycle Stage Id | Account Engagement lifecycle stage related to this object. |
prospect_medium_parameter | TEXT | Prospect Medium Parameter | Prospect's medium parameter utm_medium from Google Analytics. |
prospect_notes | TEXT | Prospect Notes | Notes about this prospect. |
prospect_opted_out | TEXT | Prospect Opted Out | If true, prospect has opted out of marketing communications. |
prospect_password | TEXT | Prospect Password | Prospect's password. |
prospect_phone | TEXT | Prospect Phone | Prospect's phone number. |
prospect_profile_id | TEXT | Prospect Profile Id | Account Engagement profile related to this object. |
prospect_prospect_account | TEXT | Prospect Prospect Account | Prospect Account related to this object. |
prospect_prospect_account_id | TEXT | Prospect Prospect Account Id | Prospect's account ID. Can be specified only if there’s no CRM connector. |
prospect_recent_interaction | TEXT | Prospect Recent Interaction | Describes the prospect's most recent interaction with Account Engagement. |
prospect_salesforce_account_id | TEXT | Prospect Salesforce Account ID | Account ID in a supported Salesforce system. |
prospect_salesforce_campaign_id | TEXT | Prospect Salesforce Campaign ID | The alpha-numeric Id of the associated campaign in the Salesforce Org. |
prospect_salesforce_contact_id | TEXT | Prospect Salesforce Contact ID | Prospect's contact ID in a supported Salesforce system. |
prospect_salesforce_id | TEXT | Prospect Salesforce Id | Salesforce Id of the object. Is unique to a single prospect, so it can't be specified for multiple prospects. |
prospect_salesforce_last_sync | TEXT | Prospect Salesforce Last Sync | Last time this prospect was synced with a supported Salesforce system. |
prospect_salesforce_lead_id | TEXT | Prospect Salesforce Lead ID | Prospect's lead ID in a supported Salesforce system. |
prospect_salesforce_owner_id | TEXT | Prospect Salesforce Owner Id | Salesforce user that the prospect record is owned by. You must have the Prospects > Prospects > Assign ability to specify this field. You can specify either userId or salesforceOwnerId in a request. |
prospect_salesforce_url | TEXT | Prospect Salesforce Url | URL to view the prospect within the Salesforce system. |
prospect_salutation | TEXT | Prospect Salutation | Prospect's formal prefix. |
prospect_score | NUMERIC | Prospect Score | Prospect's score. |
prospect_source | TEXT | Prospect Source | Prospect's source. |
prospect_source_parameter | TEXT | Prospect Source Parameter | Prospect's source parameter utm_source from Google Analytics. |
prospect_state | TEXT | Prospect State | Prospect's US state. |
prospect_term_parameter | TEXT | Prospect Term Parameter | Prospect's term parameter utm_term from Google Analytics. |
prospect_territory | TEXT | Prospect Territory | Prospect's territory. |
prospect_updated_at | TIMESTAMP | Prospect Updated At | Last update time of the object. |
prospect_updated_by | TEXT | Prospect Updated By | User who last updated this object. |
prospect_updated_by_id | TEXT | Prospect Updated By Id | ID of the user who last updated this object. |
prospect_user_id | TEXT | Prospect User Id | User the prospect is assigned to. You must have the Prospects > Prospects > Assign ability to specify this field. You can specify either userId or salesforceOwnerId in a request. |
prospect_website | TEXT | Prospect Website | Prospect's website URL. |
prospect_years_in_business | TEXT | Prospect Years In Business | Prospect's number of years in business. |
prospect_zip | TEXT | Prospect Zip | Prospect's postal code. |
visit_campaign_parameter | TEXT | Visit Campaign Parameter | Visit's campaign parameter utm_campaign from Google Analytics. |
visit_content_parameter | TEXT | Visit Content Parameter | Visit's content parameter utm_content from Google Analytics. |
visit_created_at | TIMESTAMP | Visit Created At | Creation time of this object. |
visit_duration_in_seconds | NUMERIC | Visit Duration In Seconds | Length of this visit. |
visit_first_visitor_page_view_at | TIMESTAMP | Visit First Visitor Page View At | Time of first page view for this visit; Time is reported in API user's preferred timezone. |
visit_id | TEXT | Visit ID | ID of the object. |
visit_last_visitor_page_view_at | TIMESTAMP | Visit Last Visitor Page View At | Time of last page view for this visit; Time is reported in API user's preferred timezone. |
visit_medium_parameter | TEXT | Visit Medium Parameter | Visit's medium parameter utm_medium from Google Analytics. |
visit_prospect_id | TEXT | Visit Prospect ID | Account Engagement ID for the associated prospect. |
visit_source_parameter | TEXT | Visit Source Parameter | Visit's source parameter utm_source from Google Analytics. |
visit_term_parameter | TEXT | Visit Term Parameter | Visit's term parameter utm_term from Google Analytics. |
visit_updated_at | TIMESTAMP | Visit Updated At | Last updated time for the object. |
visit_visitor_id | TEXT | Visit Visitor ID | Account Engagement ID for the associated visitor. |
visit_visitor_page_view_count | NUMERIC | Visit Visitor Page View Count | Number of page views for this visit. |
visitor_campaign_id | TEXT | Visitor Campaign ID | Campaign ID for the associated visitor. |
visitor_campaign_parameter | TEXT | Visitor Campaign Parameter | Visitor's campaign parameter utm_campaign from Google Analytics. |
visitor_content_parameter | TEXT | Visitor Content Parameter | Visitor's content parameter utm_content from Google Analytics. |
visitor_created_at | TIMESTAMP | Visitor Created At | Creation time of this object. |
visitor_do_not_sell | BOOLEAN | Visitor Do Not Sell | Indicates whether the prospect, or a visitor associated with the propect, recorded an activity with the Global Privacy Control Header enabled. |
visitor_hostname | TEXT | Visitor Hostname | Equivalent to visitor.hostname |
visitor_id | TEXT | Visitor ID | ID of the object. |
visitor_ip_address | TEXT | Visitor IP Address | Equivalent to visitor.ip_address |
visitor_is_identified | BOOLEAN | Visitor Is Identified | If True, the visitor's company is identified. |
visitor_page_view_campaign_id | TEXT | Visitor Page View Campaign ID | Account Engagement ID for the associated campaign. |
visitor_page_view_count | NUMERIC | Visitor Page View Count | Equivalent to visitor.visitor_page_view_count |
visitor_page_view_created_at | TIMESTAMP | Visitor Page View Created At | Creation time of this object. |
visitor_page_view_duration_in_seconds | NUMERIC | Visitor Page View Duration In Seconds | Length of this page view. |
visitor_page_view_id | TEXT | Visitor Page View ID | ID of the object. |
visitor_page_view_salesforce_id | TEXT | Visitor Page View Salesforce ID | Salesforce Id of the object. |
visitor_page_view_title | TEXT | Visitor Page View Title | Page title. |
visitor_page_view_url | TEXT | Visitor Page View URL | Page view URL. |
visitor_page_view_visit_id | TEXT | Visitor Page View Visit ID | Account Engagement ID for the associated visit. |
visitor_page_view_visitor_id | TEXT | Visitor Page View Visitor ID | Account Engagement ID for the associated visitor. |
visitor_prospect_id | TEXT | Visitor Prospect ID | Account Engagement ID for the associated prospect. |
visitor_source_parameter | TEXT | Visitor Source Parameter | Visitor's source parameter utm_source from Google Analytics. |
visitor_term_parameter | TEXT | Visitor Term Parameter | Visitor's term parameter utm_term from Google Analytics. |
visitor_updated_at | TIMESTAMP | Visitor Updated At | Last updated time for the object. |
today | DATE | Today | Today's date |