Windsor brings all your Pardot data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL
Pardot Field Reference

Sample
The Salesforce Pardot connector fetches data from the Pardot API
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
account_address_one | TEXT | Account Address One | Account contact address, line 1. | Account |
account_address_two | TEXT | Account Address Two | Account contact address, line 2. | Account |
account_admin_id | TEXT | Account Admin ID | ID of the individual who is the admin for this account. | Account |
account_api_calls_used | TEXT | Account API Calls Used | Total daily API requests based on the timezone for this account. | Account |
account_city | CITY | Account City | Account contact city. | Account |
account_company | TEXT | Account Company | Account company. | Account |
account_country | COUNTRY | Account Country | Account contact country (full string). | Account |
account_created_at | TIMESTAMP | Account Created At | The timestamp of when this object was created. | Account |
account_created_by_id | TEXT | Account Created By ID | ID of the individual who created this object. | Account |
account_fax | TEXT | Account Fax | Account contact fax number. | Account |
account_id | TEXT | Account ID | Account Engagement ID for this instance. | Account |
account_level | TEXT | Account Level | The level of product for the account. | Account |
account_maximum_daily_api_calls | TEXT | Account Maximum Daily API Calls | Maximum daily API requests based on the timezone for this account. | Account |
account_phone | TEXT | Account Phone | Account contact phone number. | Account |
account_plugin_campaign_id | TEXT | Account Plugin Campaign ID | Plugin ID for account campaign. | Account |
account_state | TEXT | Account State | Account contact state. | Account |
account_territory | TEXT | Account Territory | Account contact ZIP code. | Account |
account_updated_at | TIMESTAMP | Account Updated At | The timestamp of when this object was last updated. | Account |
account_updated_by_id | TEXT | Account Updated By ID | ID of the individual who created this object. | Account |
account_website | TEXT | Account Website | Account website. | Account |
account_zip | TEXT | Account Zip | Account contact territory. | Account |
activity_campaign_id | TEXT | Activity Campaign ID | Account Engagement ID for the associated campaign. | Activity |
activity_created_at | TIMESTAMP | Activity Created At | Time that visitor activity occurred; Time is reported in API user's preferred timezone. | Activity |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
activity_id | TEXT | Activity Account ID | Account Engagement ID for this visitor activity. | 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 |
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 |
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 |
activity_opportunity_id | TEXT | Activity Opportunity ID | Account Engagement ID for the associated opportunity. | Activity |
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 |
activity_prospect_id | TEXT | Activity Prospect ID | Account Engagement ID for the associated prospect. | Activity |
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 |
activity_type | TEXT | Activity Type | Visitor activity's type number. | Activity |
activity_type_name | TEXT | Activity Type Name | Visitor activity's type name. | Activity |
activity_updated_at | TIMESTAMP | Activity Updated At | Time that visitor activity update occurred; Time is reported in API user's preferred timezone. | Activity |
activity_visit_id | TEXT | Activity Visit ID | Account Engagement ID for the associated visit. | Activity |
activity_visitor_id | TEXT | Activity Visitor ID | Account Engagement ID for the associated visitor. | Activity |
activity_visitor_page_view_id | TEXT | Activity Visitor Page View ID | Account Engagement ID for the associated visitor page view. | Activity |
campaign | TEXT | Campaign | The Campaign Name | Campaign |
campaign_cost | NUMERIC | Campaign Cost | Cost of the campaign object. | Campaign |
campaign_created_at | TIMESTAMP | Campaign Created At | The timestamp of when this object was created. | Campaign |
campaign_created_by_id | TEXT | Campaign Created By ID | ID of the individual who created this object. | Campaign |
campaign_folder_id | TEXT | Campaign Folder ID | ID of the folder containing this object. | Campaign |
campaign_id | TEXT | Campaign ID | ID of the object. | Campaign |
campaign_is_deleted | BOOLEAN | Campaign Is Deleted | True if the object is in the recycle bin in Account Engagement. | Campaign |
campaign_name | TEXT | Campaign Name | Name of the object for identification in Account Engagement. | Campaign |
campaign_parent_campaign_id | TEXT | Campaign Parent Campaign ID (Pardot) | The ID of the parent campaign. | Campaign |
campaign_salesforce_id | TEXT | Campaign Salesforce ID | Salesforce Id of the object. | Campaign |
campaign_updated_at | TIMESTAMP | Campaign Updated At | The timestamp of when this object was last updated. | Campaign |
campaign_updated_by_id | TEXT | Campaign Updated By ID | ID of the individual who last updated this object. | Campaign |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
date | DATE | Date | The Date | Campaign |
day_of_month | TEXT | Day of month | Day of the month | |
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_stats_click_open_ratio | PERCENT | Email Stats Click Open Ratio | The ratio between email clicks and opens. | Email Statistics |
email_stats_click_through_rate | PERCENT | Email Stats Click Through Rate | The click-through rate based on the number of emails delivered. | Email Statistics |
email_stats_delivered | NUMERIC | Email Stats Delivered | The number of emails delivered. | Email Statistics |
email_stats_delivery_rate | PERCENT | Email Stats Delivery Rate | The delivery rate based on the number of emails sent. | Email Statistics |
email_stats_hard_bounced | NUMERIC | Email Stats Hard Bounced | The number of hard bounces for the email. | Email Statistics |
email_stats_opens | NUMERIC | Email Stats Opens | The number of opens for the email. | Email Statistics |
email_stats_opens_rate | PERCENT | Email Stats Opens Rate | The open rate based on the number of emails delivered. | Email Statistics |
email_stats_opt_out_rate | PERCENT | Email Stats Opt Out Rate | The opt-out rate based on the number of emails delivered. | Email Statistics |
email_stats_opt_outs | NUMERIC | Email Stats Opt Outs | The number of opt outs for the email | Email Statistics |
email_stats_sent | NUMERIC | Email Stats Sent | The number of emails sent. | Email Statistics |
email_stats_soft_bounced | NUMERIC | Email Stats Soft Bounced | The number of soft bounces for the email. | Email Statistics |
email_stats_spam_complaint_rate | PERCENT | Email Stats Spam Complaint Rate | The spam complaint rate based on the number of emails delivered. | Email Statistics |
email_stats_spam_complaints | NUMERIC | Email Stats Spam Complaints | The number of spam complaints for the email. | Email Statistics |
email_stats_total_clicks | NUMERIC | Email Stats Total Clicks | The total number of clicks for the email. | Email Statistics |
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 Statistics |
email_stats_unique_clicks | NUMERIC | Email Stats Unique Clicks | The number of unique clicks for the email. | Email Statistics |
email_stats_unique_opens | NUMERIC | Email Stats Unique Opens | The number of unique opens for the email. | Email Statistics |
email_subject | TEXT | Email Subject | The email subject. | |
month | TEXT | Month | Number of the month | |
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 |
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 |
opportunity_created_at | TIMESTAMP | Opportunity Created At | Time opportunity is created in Account Engagement; Time is reported in API user's preferred timezone. | Opportunity |
opportunity_created_by_id | TEXT | Opportunity Created By ID | ID of the user who created this object. | Opportunity |
opportunity_id | TEXT | Opportunity ID | Account Engagement ID for this opportunity. | Opportunity |
opportunity_name | TEXT | Opportunity Name | The opportunity's name | Opportunity |
opportunity_probability | NUMERIC | Opportunity Probability | The opportunity's probability. Must be a positive numeric value from 0 through 100, inclusive. | Opportunity |
opportunity_salesforce_id | TEXT | Opportunity Salesforce ID | The ID of the associated opportunity in Salesforce. | Opportunity |
opportunity_stage | TEXT | Opportunity Stage Name | The opportunity's stage. | Opportunity |
opportunity_status | TEXT | Opportunity Status | The opportunity's status. Status must be either won, lost, or open. | Opportunity |
opportunity_type | TEXT | Opportunity Type | The opportunity's type. | Opportunity |
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 |
opportunity_updated_by_id | TEXT | Opportunity Updated By ID | ID of the user who last updated this object. | Opportunity |
opportunity_value | NUMERIC | Opportunity Value | The opportunity's value. Must be a positive numeric value. | Opportunity |
prospect_account_annual_revenue | NUMERIC | Prospect Account Annual Revenue | Annual Revenue of the object. | Prospect Accounts |
prospect_account_assigned_to_id | TEXT | Prospect Account Assigned To ID | ID of the user who the object record is assigned to. | Prospect Accounts |
prospect_account_billing_address_one | TEXT | Prospect Account Billing Address One | Billing Address of the object. | Prospect Accounts |
prospect_account_billing_address_two | TEXT | Prospect Account Billing Address Two | Second Billing Address of the object. | Prospect Accounts |
prospect_account_billing_city | CITY | Prospect Account Billing City | City of the object. | Prospect Accounts |
prospect_account_billing_country | COUNTRY | Prospect Account Billing Country | County of the object. | Prospect Accounts |
prospect_account_billing_state | TEXT | Prospect Account Billing State | State of the object. | Prospect Accounts |
prospect_account_billing_zip | TEXT | Prospect Account Billing Zip | Zip of the object. | Prospect Accounts |
prospect_account_created_at | TIMESTAMP | Prospect Account Created At | Creation time of the object. | Prospect Accounts |
prospect_account_created_by_id | TEXT | Prospect Account Created By ID | ID of the user who created this object. | Prospect Accounts |
prospect_account_description | TEXT | Prospect Account Description | Description of the object. | Prospect Accounts |
prospect_account_employees | TEXT | Prospect Account Employees | Employees of the object. | Prospect Accounts |
prospect_account_fax | TEXT | Prospect Account Fax | Fax of the object. | Prospect Accounts |
prospect_account_id | TEXT | Prospect Account ID | ID of the object. | Prospect Accounts |
prospect_account_industry | TEXT | Prospect Account Industry | Industry of the object. | Prospect Accounts |
prospect_account_is_deleted | BOOLEAN | Prospect Account Is Deleted | True if the object is in the recycle bin in Account Engagement. | Prospect Accounts |
prospect_account_name | TEXT | Prospect Account Name | Name of the object for identification in Account Engagement. | Prospect Accounts |
prospect_account_number | TEXT | Prospect Account Number | Number of the object. | Prospect Accounts |
prospect_account_ownership | TEXT | Prospect Account Ownership | Ownership of the object. | Prospect Accounts |
prospect_account_phone | TEXT | Prospect Account Phone | Phone Number of the object. | Prospect Accounts |
prospect_account_rating | TEXT | Prospect Account Rating | Rating of the object. | Prospect Accounts |
prospect_account_shipping_address_one | TEXT | Prospect Account Shipping Address One | Shipping Address of the object. | Prospect Accounts |
prospect_account_shipping_address_two | TEXT | Prospect Account Shipping Address Two | Second Shipping Address of the object. | Prospect Accounts |
prospect_account_shipping_city | CITY | Prospect Account Shipping City | Shipping Address city of the object. | Prospect Accounts |
prospect_account_shipping_country | COUNTRY | Prospect Account Shipping Country | Shipping Address country of the object. | Prospect Accounts |
prospect_account_shipping_state | TEXT | Prospect Account Shipping State | Shipping Address state of the object. | Prospect Accounts |
prospect_account_shipping_zip | TEXT | Prospect Account Shipping Zip | Shipping Address zip of the object. | Prospect Accounts |
prospect_account_sic | TEXT | Prospect Account Sic | SIC of the object. | Prospect Accounts |
prospect_account_site | TEXT | Prospect Account Site | Site of the object. | Prospect Accounts |
prospect_account_ticker_symbol | TEXT | Prospect Account Ticker Symbol | Ticker Symbol of the object. | Prospect Accounts |
prospect_account_type | TEXT | Prospect Account Type | Type of the object. | Prospect Accounts |
prospect_account_updated_at | TIMESTAMP | Prospect Account Updated At | Last update time of the object. | Prospect Accounts |
prospect_account_updated_by_id | TEXT | Prospect Account Updated By ID | ID of the user who last updated this object. | Prospect Accounts |
prospect_account_website | TEXT | Prospect Account Website | Website of the object. | Prospect Accounts |
prospect_address_one | TEXT | Prospect Address One | Prospect's address, line 1. | Prospect |
prospect_address_two | TEXT | Prospect Address Two | Prospect's address, line 2. | Prospect |
prospect_annual_revenue | TEXT | Prospect Annual Revenue | Prospect's annual revenue. | Prospect |
prospect_assigned_to_id | TEXT | Prospect Assigned To ID | User the prospect is assigned to. | Prospect |
prospect_campaign_id | TEXT | Prospect Campaign ID | Account Engagement campaign related to this object. | Prospect |
prospect_campaign_parameter | TEXT | Prospect Campaign Parameter | Prospect's campaign parameter utm_campaign from Google Analytics. | Prospect |
prospect_city | CITY | Prospect City | Prospect's city. | Prospect |
prospect_comments | TEXT | Prospect Comments | Comments about this prospect. | Prospect |
prospect_company | TEXT | Prospect Company | Prospect's company. | Prospect |
prospect_content_parameter | TEXT | Prospect Content Parameter | Prospect's content parameter utm_content from Google Analytics. | Prospect |
prospect_converted_at | TIMESTAMP | Prospect Converted At | Time when prospect was converted from visitor. | Prospect |
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 |
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 |
prospect_country | COUNTRY | Prospect Country | Prospect's country. | Prospect |
prospect_created_at | TIMESTAMP | Prospect Created At | Creation time of the object. | Prospect |
prospect_created_by_id | TEXT | Prospect Created By ID | ID of the user who created this object. | Prospect |
prospect_department | TEXT | Prospect Department | Prospect's department. | Prospect |
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 |
prospect_email | TEXT | Prospect Email | Prospect's email address. | Prospect |
prospect_email_bounced_at | TIMESTAMP | Prospect Email Bounced At | Time when prospect email address hard bounced. | Prospect |
prospect_email_bounced_reason | TEXT | Prospect Email Bounced Reason | Reason why prospect email address hard bounced. | Prospect |
prospect_employees | TEXT | Prospect Employees | Prospect's number of employees. | Prospect |
prospect_fax | TEXT | Prospect Fax | Prospect's fax number. | Prospect |
prospect_first_activity_at | TIMESTAMP | Prospect First Activity At | Time when first visitor activity occurred for this prospect. | Prospect |
prospect_first_assigned_at | TIMESTAMP | Prospect First Assigned At | Time prospect was first assigned to a user. | Prospect |
prospect_first_name | TEXT | Prospect First Name | Prospect's first name. | Prospect |
prospect_first_referrer_query | TEXT | Prospect First Referrer Query | First referrer's search query. | Prospect |
prospect_first_referrer_type | TEXT | Prospect First Referrer Type | First referrer's vendor and type (such as 'Google Natural Search'). | Prospect |
prospect_first_referrer_url | TEXT | Prospect First Referrer URL | First referrer's URL. | Prospect |
prospect_grade | TEXT | Prospect Grade | Prospect's letter grade. | Prospect |
prospect_id | TEXT | Prospect ID | ID of the object. | Prospect |
prospect_industry | TEXT | Prospect Industry | Prospect's industry. | Prospect |
prospect_is_deleted | TEXT | Prospect Is Deleted | True if the object is in the recycle bin in Account Engagement. | Prospect |
prospect_is_do_not_call | TEXT | Prospect Is Do Not Call | If true, prospect prefers not to be called. | Prospect |
prospect_is_do_not_email | TEXT | Prospect Is Do Not Email | If true, prospect prefers not to be emailed. | Prospect |
prospect_is_email_hard_bounced | TEXT | Prospect Is Email Hard Bounced | If true, prospect email address has hard bounced. | Prospect |
prospect_is_reviewed | TEXT | Prospect Is Reviewed | If true, prospect has been reviewed. | Prospect |
prospect_is_starred | TEXT | Prospect Is Starred | If true, prospect has been starred. | Prospect |
prospect_job_title | TEXT | Prospect Job Title | Prospect's job title. | Prospect |
prospect_last_activity_at | TIMESTAMP | Prospect Last Activity At | Time stamp of this prospect's latest visitor activity. | Prospect |
prospect_last_name | TEXT | Prospect Last Name | Prospect's last name. | Prospect |
prospect_lifecycle_stage_id | TEXT | Prospect Lifecycle Stage ID | Account Engagement lifecycle stage related to this object. | Prospect |
prospect_medium_parameter | TEXT | Prospect Medium Parameter | Prospect's medium parameter utm_medium from Google Analytics. | Prospect |
prospect_notes | TEXT | Prospect Notes | Notes about this prospect. | Prospect |
prospect_opted_out | TEXT | Prospect Opted Out | If true, prospect has opted out of marketing communications. | Prospect |
prospect_password | TEXT | Prospect Password | Prospect's password. | Prospect |
prospect_phone | TEXT | Prospect Phone | Prospect's phone number. | Prospect |
prospect_profile_id | TEXT | Prospect Profile ID | Account Engagement profile related to this object. | Prospect |
prospect_prospect_account_id | TEXT | Prospect Prospect Account ID | Prospect's account ID. Can be specified only if there’s no CRM connector. | Prospect |
prospect_recent_interaction | TEXT | Prospect Recent Interaction | Describes the prospect's most recent interaction with Account Engagement. | Prospect |
prospect_salesforce_account_id | TEXT | Prospect Salesforce Account ID | Account ID in a supported Salesforce system. | Prospect |
prospect_salesforce_campaign_id | TEXT | Prospect Salesforce Campaign ID | The alpha-numeric Id of the associated campaign in the Salesforce Org. | Prospect |
prospect_salesforce_contact_id | TEXT | Prospect Salesforce Contact ID | Prospect's contact ID in a supported Salesforce system. | Prospect |
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 |
prospect_salesforce_last_sync | TEXT | Prospect Salesforce Last Sync | Last time this prospect was synced with a supported Salesforce system. | Prospect |
prospect_salesforce_lead_id | TEXT | Prospect Salesforce Lead ID | Prospect's lead ID in a supported Salesforce system. | Prospect |
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 |
prospect_salesforce_url | TEXT | Prospect Salesforce URL | URL to view the prospect within the Salesforce system. | Prospect |
prospect_salutation | TEXT | Prospect Salutation | Prospect's formal prefix. | Prospect |
prospect_score | NUMERIC | Prospect Score | Prospect's score. | Prospect |
prospect_source | TEXT | Prospect Source | Prospect's source. | Prospect |
prospect_source_parameter | TEXT | Prospect Source Parameter | Prospect's source parameter utm_source from Google Analytics. | Prospect |
prospect_state | TEXT | Prospect State | Prospect's US state. | Prospect |
prospect_term_parameter | TEXT | Prospect Term Parameter | Prospect's term parameter utm_term from Google Analytics. | Prospect |
prospect_territory | TEXT | Prospect Territory | Prospect's territory. | Prospect |
prospect_updated_at | TIMESTAMP | Prospect Updated At | Last update time of the object. | Prospect |
prospect_updated_by_id | TEXT | Prospect Updated By ID | ID of the user who last updated this object. | Prospect |
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 |
prospect_website | TEXT | Prospect Website | Prospect's website URL. | Prospect |
prospect_years_in_business | TEXT | Prospect Years In Business | Prospect's number of years in business. | Prospect |
prospect_zip | TEXT | Prospect ZIP | Prospect's postal code. | Prospect |
source | TEXT | Source | The name of the Windsor connector returning the row | |
today | DATE | Today | Today's date | |
visit_campaign_parameter | TEXT | Visit Campaign Parameter | Visit's campaign parameter utm_campaign from Google Analytics. | Visit |
visit_content_parameter | TEXT | Visit Content Parameter | Visit's content parameter utm_content from Google Analytics. | Visit |
visit_created_at | TIMESTAMP | Visit Created At | Creation time of this object. | Visit |
visit_duration_in_seconds | NUMERIC | Visit Duration In Seconds | Length of this visit. | 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 |
visit_id | TEXT | Visit ID | ID of the object. | Visit |
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 |
visit_medium_parameter | TEXT | Visit Medium Parameter | Visit's medium parameter utm_medium from Google Analytics. | Visit |
visit_prospect_id | TEXT | Visit Prospect ID | Account Engagement ID for the associated prospect. | Visit |
visit_source_parameter | TEXT | Visit Source Parameter | Visit's source parameter utm_source from Google Analytics. | Visit |
visit_term_parameter | TEXT | Visit Term Parameter | Visit's term parameter utm_term from Google Analytics. | Visit |
visit_updated_at | TIMESTAMP | Visit Updated At | Last updated time for the object. | Visit |
visit_visitor_id | TEXT | Visit Visitor ID | Account Engagement ID for the associated visitor. | Visit |
visit_visitor_page_view_count | NUMERIC | Visit Visitor Page View Count | Number of page views for this visit. | Visit |
visitor_campaign_id | TEXT | Visitor Campaign ID | Campaign ID for the associated visitor. | Visitor |
visitor_campaign_parameter | TEXT | Visitor Campaign Parameter | Visitor's campaign parameter utm_campaign from Google Analytics. | Visitor |
visitor_content_parameter | TEXT | Visitor Content Parameter | Visitor's content parameter utm_content from Google Analytics. | Visitor |
visitor_created_at | TIMESTAMP | Visitor Created At | Creation time of this object. | Visitor |
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 |
visitor_hostname | TEXT | Visitor Hostname | Equivalent to visitor.hostname | Visitor |
visitor_id | TEXT | Visitor ID | ID of the object. | Visitor |
visitor_ip_address | TEXT | Visitor IP Address | Equivalent to visitor.ip_address | Visitor |
visitor_is_identified | BOOLEAN | Visitor Is Identified | If True, the visitor's company is identified. | Visitor |
visitor_page_view_campaign_id | TEXT | Visitor Page View Campaign ID | Account Engagement ID for the associated campaign. | Visitor Page View |
visitor_page_view_count | NUMERIC | Visitor Page View Count | Equivalent to visitor.visitor_page_view_count | Visitor |
visitor_page_view_created_at | TIMESTAMP | Visitor Page View Created At | Creation time of this object. | Visitor Page View |
visitor_page_view_duration_in_seconds | NUMERIC | Visitor Page View Duration In Seconds | Length of this page view. | Visitor Page View |
visitor_page_view_id | TEXT | Visitor Page View ID | ID of the object. | Visitor Page View |
visitor_page_view_salesforce_id | TEXT | Visitor Page View Salesforce ID | Salesforce Id of the object. | Visitor Page View |
visitor_page_view_title | TEXT | Visitor Page View Title | Page title. | Visitor Page View |
visitor_page_view_url | TEXT | Visitor Page View URL | Page view URL. | Visitor Page View |
visitor_page_view_visit_id | TEXT | Visitor Page View Visit ID | Account Engagement ID for the associated visit. | Visitor |
visitor_page_view_visitor_id | TEXT | Visitor Page View Visitor ID | Account Engagement ID for the associated visitor. | Visitor Page View |
visitor_prospect_id | TEXT | Visitor Prospect ID | Account Engagement ID for the associated prospect. | Visitor |
visitor_source_parameter | TEXT | Visitor Source Parameter | Visitor's source parameter utm_source from Google Analytics. | Visitor |
visitor_term_parameter | TEXT | Visitor Term Parameter | Visitor's term parameter utm_term from Google Analytics. | Visitor |
visitor_updated_at | TIMESTAMP | Visitor Updated At | Last updated time for the object. | Visitor |
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_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 |