Pardot Connector Reference

26 metrics231 dimensions

Fields

The Salesforce Pardot connector fetches data from the Pardot API.

Note: Fields starting with email_stats_ are more resource-intensive and may increase your Pardot API usage quota consumption. Use them only when necessary.

The Pardot connector exposes 257 fields (26 metrics, 231 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Pardot Fields

Pardot Account fields

The Account report of the Pardot connector includes 21 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.

Pardot Activity fields

The Activity report of the Pardot connector includes 23 fields.

ID	Type	Name	Description
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.

Pardot Campaign fields

The Campaign report of the Pardot connector includes 13 fields.

ID	Type	Name	Description
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 (Pardot)	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

Pardot Email fields

The Email report of the Pardot connector includes 9 fields.

ID	Type	Name	Description
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_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.

Pardot Email Statistics fields

The Email Statistics report of the Pardot connector includes 17 fields.

ID	Type	Name	Description
email_stats_click_open_ratio	PERCENT	Email Stats Click Open Ratio	The ratio between email clicks and opens.
email_stats_click_through_rate	PERCENT	Email Stats Click Through Rate	The click-through rate based on the number of emails delivered.
email_stats_delivered	NUMERIC	Email Stats Delivered	The number of emails delivered.
email_stats_delivery_rate	PERCENT	Email Stats Delivery Rate	The delivery rate based on the number of emails sent.
email_stats_hard_bounced	NUMERIC	Email Stats Hard Bounced	The number of hard bounces for the email.
email_stats_opens	NUMERIC	Email Stats Opens	The number of opens for the email.
email_stats_opens_rate	PERCENT	Email Stats Opens Rate	The open rate based on the number of emails delivered.
email_stats_opt_out_rate	PERCENT	Email Stats Opt Out Rate	The opt-out rate based on the number of emails delivered.
email_stats_opt_outs	NUMERIC	Email Stats Opt Outs	The number of opt outs for the email
email_stats_sent	NUMERIC	Email Stats Sent	The number of emails sent.
email_stats_soft_bounced	NUMERIC	Email Stats Soft Bounced	The number of soft bounces for the email.
email_stats_spam_complaint_rate	PERCENT	Email Stats Spam Complaint Rate	The spam complaint rate based on the number of emails delivered.
email_stats_spam_complaints	NUMERIC	Email Stats Spam Complaints	The number of spam complaints for the email.
email_stats_total_clicks	NUMERIC	Email Stats Total Clicks	The total number of clicks for the email.
email_stats_unique_click_through_rate	PERCENT	Email Stats Unique Click Through Rate	The unique click-through rate based on the number of emails delivered.
email_stats_unique_clicks	NUMERIC	Email Stats Unique Clicks	The number of unique clicks for the email.
email_stats_unique_opens	NUMERIC	Email Stats Unique Opens	The number of unique opens for the email.

Pardot Opportunity fields

The Opportunity report of the Pardot connector includes 14 fields.

ID	Type	Name	Description
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.

Pardot Prospect fields

The Prospect report of the Pardot connector includes 71 fields.

Pardot Prospect fields (prospect_address_one to prospect_last_activity_at)

ID	Type	Name	Description
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_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_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.

Pardot Prospect fields (prospect_last_name to prospect_zip)

ID	Type	Name	Description
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_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_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.

Pardot Prospect Accounts fields

The Prospect Accounts report of the Pardot connector includes 34 fields.

ID	Type	Name	Description
prospect_account_annual_revenue	NUMERIC	Prospect Account Annual Revenue	Annual Revenue of the object.
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_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_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.

Pardot Visit fields

The Visit report of the Pardot connector includes 14 fields.

ID	Type	Name	Description
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.

Pardot Visitor fields

The Visitor report of the Pardot connector includes 15 fields.

ID	Type	Name	Description
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_count	NUMERIC	Visitor Page View Count	Equivalent to visitor.visitor_page_view_count
visitor_page_view_visit_id	TEXT	Visitor Page View Visit ID	Account Engagement ID for the associated visit.
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.

Pardot Visitor Page View fields

The Visitor Page View report of the Pardot connector includes 8 fields.

ID	Type	Name	Description
visitor_page_view_campaign_id	TEXT	Visitor Page View Campaign ID	Account Engagement ID for the associated campaign.
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_visitor_id	TEXT	Visitor Page View Visitor ID	Account Engagement ID for the associated visitor.

Pardot other fields

The Pardot connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors