Salesforce Account Engagement (Pardot) fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Salesforce Account Engagement (Pardot) data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

Early Access32 metrics169 dimensionsCustom fields

ACCOUNT

account_id
Field label Account ID
Description Account ID
Field type dimension
Data type string.text.value
account_created_at_time
Field label Created at time
Description Account created at time
Field type dimension
Data type string.time.datetime
account_level
Field label Account level
Description Account level
Field type dimension
Data type string.text.value
account_website
Field label Account website
Description Account website
Field type dimension
Data type string.text.url
account_plugin_campaign_id
Field label Account plugin campaign ID
Description Account plugin campaign ID
Field type dimension
Data type string.text.value
account_address1
Field label Account address 1
Description Account address 1
Field type dimension
Data type string.text.value
account_address2
Field label Account address 2
Description Account address 2
Field type dimension
Data type string.text.value
account_city
Field label Account city
Description Account city
Field type dimension
Data type string.geo.city
account_state
Field label Account state
Description Account state
Field type dimension
Data type string.geo.region
account_territory
Field label Account territory
Description Account territory
Field type dimension
Data type string.text.value
account_zip
Field label Account zip
Description Account zip
Field type dimension
Data type string.geo.zip
account_country
Field label Account country
Description Account country
Field type dimension
Data type string.geo.country
account_phone
Field label Account phone
Description Account phone
Field type dimension
Data type string.text.phone
account_fax
Field label Account fax
Description Account fax
Field type dimension
Data type string.text.phone

ACTIVITY

activity_id
Field label Activity ID
Description ID for this visitor activity
Field type dimension
Data type string.text.value
activity_visitor_page_view_id
Field label Visitor page view ID
Description ID for the associated visitor page view
Field type dimension
Data type string.text.value
activity_visit_id
Field label Visit ID
Description ID for the associated visit
Field type dimension
Data type string.text.value
activity_visitor_id
Field label Visitor ID
Description ID for the associated visitor
Field type dimension
Data type string.text.value
activity_prospect_id
Field label Prospect ID
Description ID for the associated prospect
Field type dimension
Data type string.text.value
activity_opportunity_id
Field label Opportunity ID
Description ID for the associated opportunity
Field type dimension
Data type string.text.value
activity_email_id
Field label Email ID
Description ID for the associated email
Field type dimension
Data type string.text.value
activity_campaign_id
Field label Campaign ID
Description ID for the associated campaign
Field type dimension
Data type string.text.value
activity_type
Field label Type
Description Visitor activity's type number
Field type dimension
Data type string.text.value
activity_type_name
Field label Type name
Description Visitor activity's type name
Field type dimension
Data type string.text.value
activity_details
Field label Details
Description 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
Field type dimension
Data type string.text.value
activity_created_at_date
Field label Created date
Description Date that visitor activity occurred
Field type dimension
Data type string.time.date
activity_created_at_time
Field label Created time
Description Time that visitor activity occurred
Field type dimension
Data type string.time.datetime
activity_updated_at_date
Field label Updated date
Description Date that visitor activity update occurred
Field type dimension
Data type string.time.date
activity_updated_at_time
Field label Updated time
Description Time that visitor activity update occurred
Field type dimension
Data type string.time.datetime
activity_form_id
Field label Form ID
Description ID of the form
Field type dimension
Data type string.text.value
activity_form_handler_id
Field label Form handler ID
Description ID of the form handler
Field type dimension
Data type string.text.value
activity_site_search_query_Id
Field label Site search query ID
Description ID of the site search query
Field type dimension
Data type string.text.value
activity_landing_page_id
Field label Landing page ID
Description ID of the landing page
Field type dimension
Data type string.text.value
activity_paid_search_ad_id
Field label Paid search ad ID
Description ID of the paid search ad
Field type dimension
Data type string.text.value
activity_multivariate_test_variation_id
Field label Test variation ID
Description ID of the multivariate test variation
Field type dimension
Data type string.text.value
activity_file_id
Field label File ID
Description ID of the file
Field type dimension
Data type string.text.value
activity_activities
Field label Activities
Description Activities
Field type metric
Data type int.number.value

CAMPAIGN

campaign_id
Field label Campaign ID
Description Campaign ID
Field type dimension
Data type string.text.value
campaign_created_at_time
Field label Created at time
Description Campaign created at time
Field type dimension
Data type string.time.datetime
campaign_name
Field label Campaign name
Description Campaign name
Field type dimension
Data type string.text.value
campaign_cost
Field label Campaign cost
Description Campaign cost
Field type dimension
Data type float.currency.value
campaign_updated_at_time
Field label Updated at time
Description Time that campaign update occurred
Field type dimension
Data type string.time.datetime
campaign_deleted_at_time
Field label Deleted at time
Description Time that campaign delete occurred
Field type dimension
Data type string.time.datetime

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

EMAIL

email_id
Field label Email ID
Description Email ID
Field type dimension
Data type string.text.value
email_campaign_id
Field label Email campaign ID
Description Email campaign ID
Field type dimension
Data type string.text.value
email_sent_at_time
Field label Email sent at time
Description Time that visitor activity update occurred
Field type dimension
Data type string.time.datetime
email_name
Field label Email name
Description Email name
Field type dimension
Data type string.text.value
email_sent
Field label Emails sent
Description Emails sent
Field type metric
Data type int.number.value
email_opened
Field label Emails opened
Description Emails opened
Field type metric
Data type int.number.value
email_opens_unique
Field label Emails opened (unique)
Description Number of unique recipients who opened the email
Field type metric
Data type int.number.value
email_open_rate
Field label Email open rate
Description Emails opened / emails sent
Field type metric
Data type float.number.ratio
email_clicked
Field label Emails clicked
Description Emails clicked
Field type metric
Data type int.number.value
email_clicks_unique
Field label Emails clicked (unique)
Description Number of unique recipients who clicked the email
Field type metric
Data type int.number.value
email_click_rate
Field label Email click rate
Description Emails clicked / emails sent
Field type metric
Data type float.number.ratio
email_bounced
Field label Emails bounced
Description Emails bounced
Field type metric
Data type int.number.value
email_bounce_rate
Field label Email bounce rate
Description Emails bounced / emails sent
Field type metric
Data type float.number.ratio

OPPORTUNITY

opportunity_id
Field label Opportunity ID
Description Opportunity ID
Field type dimension
Data type string.text.value
opportunity_name
Field label Name
Description Opportunity name
Field type dimension
Data type string.text.value
opportunity_campaign_id
Field label Campaign ID
Description Opportunity campaign ID
Field type dimension
Data type string.text.value
opportunity_probability
Field label Probability
Description Opportunity probability
Field type dimension
Data type string.text.value
opportunity_type
Field label Type
Description Opportunity type
Field type dimension
Data type string.text.value
opportunity_stage
Field label Stage
Description Opportunity stage
Field type dimension
Data type string.text.value
opportunity_status
Field label Status
Description Opportunity status
Field type dimension
Data type string.text.value
opportunity_closed_at_date
Field label Closed at date
Description Opportunity closed at date
Field type dimension
Data type string.time.date
opportunity_closed_at_time
Field label Closed at time
Description Opportunity closed at time
Field type dimension
Data type string.time.datetime
opportunity_created_at_date
Field label Created at date
Description Opportunity created at date
Field type dimension
Data type string.time.date
opportunity_created_at_time
Field label Created at time
Description Opportunity created at time
Field type dimension
Data type string.time.datetime
opportunity_updated_at_date
Field label Updated at date
Description Opportunity updated at date
Field type dimension
Data type string.time.date
opportunity_updated_at_time
Field label Updated at time
Description Opportunity updated at time
Field type dimension
Data type string.time.datetime
opportunity_count
Field label Opportunities
Description The number of opportunities
Field type metric
Data type int.number.value
opportunity_value
Field label Value
Description Opportunity's value
Field type metric
Data type float.number.value
opportunity_value_won
Field label Value won
Description Value of won opportunities
Field type metric
Data type float.number.value
opportunity_value_lost
Field label Value lost
Description Value of lost opportunities
Field type metric
Data type float.number.value
opportunity_value_open
Field label Value open
Description Value of open opportunities
Field type metric
Data type float.number.value
opportunity_value_open_70
Field label Value open >70%
Description Value of open opportunities with probability over 70%
Field type metric
Data type float.number.value
opportunity_avg_value
Field label Avg. value
Description Average value of opportunity
Field type metric
Data type float.number.value
opportunity_deal_count
Field label Deals
Description The number of won and closed opportunities
Field type metric
Data type int.number.value
opportunity_win_rate
Field label Win rate
Description The win rate for opportunities
Field type metric
Data type float.number.ratio
opportunity_time_to_close
Field label Age (days)
Description The time it took in days to close the opportunity
Field type metric
Data type int.number.value
opportunity_average_time_to_close
Field label Avg. age (days)
Description The average time, in days, it took to close the opportunity
Field type metric
Data type float.number.value

PROSPECT

prospect_id
Field label Prospect ID
Description Prospect ID
Field type dimension
Data type string.text.value
prospect_campaign_id
Field label Campaign ID
Description Prospect campaign ID
Field type dimension
Data type string.text.value
prospect_prospect_account_id
Field label Account ID
Description Prospect account ID
Field type dimension
Data type string.text.value
prospect_company
Field label Company
Description Prospect company
Field type dimension
Data type string.text.value
prospect_source
Field label Source
Description Prospect source
Field type dimension
Data type string.text.value
prospect_grade
Field label Grade
Description Grade of the prospect
Field type dimension
Data type string.text.value
prospect_created_at_date
Field label Created at date
Description Prospect created at date
Field type dimension
Data type string.time.date
prospect_created_at_time
Field label Created at time
Description Prospect created at time
Field type dimension
Data type string.time.datetime
prospect_last_updated_at_date
Field label Last updated at date
Description Prospect last updated at date
Field type dimension
Data type string.time.date
prospect_last_updated_at_time
Field label Last updated at time
Description Prospect last updated at time
Field type dimension
Data type string.time.datetime
prospect_last_activity_date
Field label Last activity date
Description Prospect last activity date
Field type dimension
Data type string.time.date
prospect_last_activity_time
Field label Last activity time
Description Prospect last activity time
Field type dimension
Data type string.time.datetime
prospect_first_assigned_date
Field label First assigned date
Description The date the prospect was first assigned to a user
Field type dimension
Data type string.time.date
prospect_first_assigned_time
Field label First assigned time
Description The time the prospect was first assigned to a user
Field type dimension
Data type string.time.datetime
prospect_is_starred
Field label Starred
Description Prospect is starred
Field type dimension
Data type bool
prospect_is_reviewed
Field label Reviewed
Description Prospect is reviewed
Field type dimension
Data type bool
prospect_first_name
Field label First name
Description Prospect first name
Field type dimension
Data type string.text.value
prospect_last_name
Field label Last name
Description Prospect last name
Field type dimension
Data type string.text.value
prospect_job_title
Field label Job title
Description Prospect job title
Field type dimension
Data type string.text.value
prospect_department
Field label Department
Description Prospect department
Field type dimension
Data type string.text.value
prospect_email
Field label Email
Description Prospect email
Field type dimension
Data type string.text.value
prospect_phone_number
Field label Phone number
Description Prospect phone number
Field type dimension
Data type string.text.phone
prospect_fax_number
Field label Fax number
Description Prospect fax number
Field type dimension
Data type string.text.phone
prospect_country
Field label Country
Description Prospect country
Field type dimension
Data type string.geo.country
prospect_city
Field label City
Description Prospect city
Field type dimension
Data type string.geo.city
prospect_us_state
Field label US state
Description Prospect US state
Field type dimension
Data type string.geo.region
prospect_territory
Field label Territory
Description Prospect territory
Field type dimension
Data type string.text.value
prospect_postal_code
Field label Postal code
Description Prospect postal code
Field type dimension
Data type string.text.value
prospect_comments
Field label Comments
Description Prospect comments
Field type dimension
Data type string.text.value
prospect_notes
Field label Notes
Description Prospect notes
Field type dimension
Data type string.text.value
prospect_crm_lead_id
Field label CRM lead ID
Description Prospect CRM lead ID
Field type dimension
Data type string.text.value
prospect_crm_contact_id
Field label CRM contact ID
Description Prospect CRM contact ID
Field type dimension
Data type string.text.value
prospect_crm_owner_id
Field label CRM owner ID
Description Prospect CRM owner ID
Field type dimension
Data type string.text.value
prospect_crm_account_id
Field label CRM account IDa
Description Prospect CRM account ID
Field type dimension
Data type string.text.value
prospect_last_sync_date
Field label CRM last sync date
Description Prospect CRM last sync date
Field type dimension
Data type string.time.date
prospect_last_sync_time
Field label CRM last sync time
Description Prospect CRM last sync time
Field type dimension
Data type string.time.datetime
prospect_link_to_crm
Field label Link to CRM
Description Prospect link to CRM
Field type dimension
Data type string.text.url
prospect_deleted_at_date
Field label Deleted date
Description Date that prospect delete occurred
Field type dimension
Data type string.time.date
prospect_deleted_at_time
Field label Deleted time
Description Time that prospect delete occurred
Field type dimension
Data type string.time.datetime
prospect_count
Field label Prospects
Description Prospects
Field type metric
Data type int.number.value
prospect_starred_prospects
Field label Starred prospects
Description Starred prospects
Field type metric
Data type int.number.value
prospect_reviewed_prospects
Field label Reviewed prospects
Description Reviewed prospects
Field type metric
Data type int.number.value
prospect_score
Field label Score
Description Prospect score
Field type metric
Data type float.number.value
prospect_average_score
Field label Avg. score
Description Prospect average score
Field type metric
Data type float.number.value
prospect_total_score
Field label Total score
Description Prospect total score
Field type metric
Data type float.number.value
prospect_annual_revenue
Field label Annual revenue
Description Annual revenue
Field type metric
Data type float.number.value
prospect_employees
Field label Number of employees
Description Number of employees
Field type metric
Data type int.number.value

PROSPECT ACCOUNT

prospect_account_id
Field label Prospect account ID
Description Prospect account ID
Field type dimension
Data type string.text.value
prospect_account_name
Field label Prospect account name
Description Prospect account name
Field type dimension
Data type string.text.value
prospect_account_created_at_time
Field label Prospect account created at time
Description Prospect account created at time
Field type dimension
Data type string.time.datetime
prospect_account_updated_at_time
Field label Prospect account updated at time
Description Prospect account updated at time
Field type dimension
Data type string.time.datetime
prospect_account_deleted_at_time
Field label Prospect account deleted at time
Description Prospect account deleted at time
Field type dimension
Data type string.time.datetime

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Description Year, e.g. 2017
Field type dimension
Data type string.time.year
yearOfWeek
Field label Year of week (Sun-Sat)
Description Year of week for US-style Sunday-Saturday weeks, e.g. 2017
Field type dimension
Data type string.time.year
yearOfWeekIso
Field label Year of week (Mon-Sun)
Description Year of week for ISO standard Monday-Sunday weeks, e.g. 2017
Field type dimension
Data type string.time.year
yearMonth
Field label Year & month
Description Year and month, e.g. 2017|06
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Description Month, e.g. 6
Field type dimension
Data type string.time.month
yearWeek
Field label Year & week (Sun-Sat)
Description Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweek
yearWeekIso
Field label Year & week (Mon-Sun)
Description Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Description US week number, e.g. 51
Field type dimension
Data type string.time.week
weekIso
Field label Week (Mon-Sun)
Description ISO week number, e.g. 51
Field type dimension
Data type string.time.weekiso
dayOfMonth
Field label Day of month
Description Day of month, e.g. 2
Field type dimension
Data type string.time.dayofmonth
dayOfWeekName
Field label Day of week (Sun-Sat)
Description Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday
Field type dimension
Data type string.time.dayofweek
dayOfWeekNameIso
Field label Day of week (Mon-Sun)
Description Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
hour
Field label Hour
Description Hour in a 24-hour clock, e.g. 18
Field type dimension
Data type string.time.hour

VISIT

visit_id
Field label Visit ID
Description Visit ID
Field type dimension
Data type string.text.value
visit_visitor_id
Field label Visit visitor ID
Description Visit visitor ID
Field type dimension
Data type string.text.value
visit_prospect_id
Field label Visit prospect ID
Description Visit prospect ID
Field type dimension
Data type string.text.value
visit_first_visitor_page_view_at_date
Field label First page visit view date
Description First page visit view date
Field type dimension
Data type string.time.date
visit_first_visitor_page_view_at_time
Field label First page visit view time
Description First page visit view time
Field type dimension
Data type string.time.datetime
visit_last_visitor_page_view_at_date
Field label Last page visit view date
Description Last page visit view date
Field type dimension
Data type string.time.date
visit_last_visitor_page_view_at_time
Field label Last page visit view time
Description Last page visit view time
Field type dimension
Data type string.time.datetime
visit_campaign_parameter
Field label Visit campaign parameter
Description Visit campaign parameter
Field type dimension
Data type string.text.value
visit_medium_parameter
Field label Visit medium parameter
Description Visit medium parameter
Field type dimension
Data type string.text.value
visit_source_parameter
Field label Visit source parameter
Description Visit source parameter
Field type dimension
Data type string.text.value
visit_content_parameter
Field label Visit content parameter
Description Visit content parameter
Field type dimension
Data type string.text.value
visit_term_parameter
Field label Visit term parameter
Description Visit term parameter
Field type dimension
Data type string.text.value
visit_created_at_date
Field label Created date
Description Date that visit occurred
Field type dimension
Data type string.time.date
visit_created_at_time
Field label Created time
Description Time that visit occurred
Field type dimension
Data type string.time.datetime
visit_updated_at_date
Field label Updated date
Description Date that visit update occurred
Field type dimension
Data type string.time.date
visit_updated_at_time
Field label Updated time
Description Time that visit update occurred
Field type dimension
Data type string.time.datetime
visit_visitor_page_view_count
Field label Page view count
Description Number of page views for this visit
Field type metric
Data type int.number.value
visit_duration_in_seconds
Field label Duration in seconds
Description Length of this visit
Field type metric
Data type int.number.value

VISITOR

visitor_id
Field label Visitor ID
Description Visitor ID
Field type dimension
Data type string.text.value
visitor_campaign_id
Field label Visitor campaign ID
Description Visitor campaign ID
Field type dimension
Data type string.text.value
visitor_prospect_id
Field label Visitor prospect ID
Description Visitor prospect ID
Field type dimension
Data type string.text.value
visitor_ip_address
Field label Visitor ip address
Description Visitor ip address
Field type dimension
Data type string.network.ip
visitor_hostname
Field label Visitor hostname
Description Visitor hostname
Field type dimension
Data type string.text.value
visitor_campaign_parameter
Field label Visitor campaign parameter
Description Visitor campaign parameter
Field type dimension
Data type string.text.value
visitor_medium_parameter
Field label Visitor medium parameter
Description Visitor medium parameter
Field type dimension
Data type string.text.value
visitor_source_parameter
Field label Visitor source parameter
Description Visitor source parameter
Field type dimension
Data type string.text.value
visitor_content_parameter
Field label Visitor content parameter
Description Visitor content parameter
Field type dimension
Data type string.text.value
visitor_term_parameter
Field label Visitor term parameter
Description Visitor term parameter
Field type dimension
Data type string.text.value
visitor_created_at_date
Field label Created date
Description Date that visitor occurred
Field type dimension
Data type string.time.date
visitor_created_at_time
Field label Created time
Description Time that visitor occurred
Field type dimension
Data type string.time.datetime
visitor_updated_at_date
Field label Updated date
Description Date that visitor update occurred
Field type dimension
Data type string.time.date
visitor_updated_at_time
Field label Updated time
Description Time that visitor update occurred
Field type dimension
Data type string.time.datetime
visitor_deleted_at_date
Field label Deleted date
Description Date that visitor delete occurred
Field type dimension
Data type string.time.date
visitor_deleted_at_time
Field label Deleted time
Description Time that visitor deleted occurred
Field type dimension
Data type string.time.datetime
visitor_page_view_count
Field label Page view count by this visitor
Description Number of page views by this visitor
Field type metric
Data type int.number.value

VISITOR PAGE VIEW

visitor_page_view_id
Field label Visitor page view ID
Description Visitor page view ID
Field type dimension
Data type string.text.value
visitor_page_view_visitor_id
Field label Visitor page view visitor ID
Description Visitor page view visitor ID
Field type dimension
Data type string.text.value
visitor_page_view_campaign_id
Field label Visitor page view campaign ID
Description Visitor page view campaign ID
Field type dimension
Data type string.text.value
visitor_page_view_visit_id
Field label Visitor page view visit ID
Description Visitor page view visit ID
Field type dimension
Data type string.text.value
visitor_page_view_url
Field label Visitor page view url
Description Visitor page view url
Field type dimension
Data type string.text.url
visitor_page_view_title
Field label Visitor page view title
Description Visitor page view title
Field type dimension
Data type string.text.value
visitor_page_view_created_at_date
Field label Created date
Description Date that visitor page view occurred
Field type dimension
Data type string.time.date
visitor_page_view_created_at_time
Field label Created time
Description Time that visitor page view occurred
Field type dimension
Data type string.time.datetime