Pardot: Most-used fields

The table below gives information about most-used fields that you can import from Pardot. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
addressOne	addressOne	The primary street address of the prospect.	dimension
addressTwo	addressTwo		dimension
annualRevenue	annualRevenue		dimension
assignedToId	assignedToId	The ID of the user or group to whom the prospect is assigned.	metric
campaign.cost	campaign.cost	The cost associated with the marketing campaign.	dimension
campaign.createdAt	campaign.createdAt	The date and time when the marketing campaign was created.	dimension
campaign.name	campaign.name	The name of the Pardot campaign associated with the prospect.	dimension
campaign.updatedAt	campaign.updatedAt	The date and time when the marketing campaign was last updated.	dimension
campaignId	campaignId	The unique identifier for the associated marketing campaign.	dimension
campaignParameter	campaignParameter		dimension
city	city	The city where the prospect is located.	dimension
company	company	The name of the prospect’s company.	dimension
contentParameter	contentParameter		dimension
convertedAt	convertedAt	The date and time when the prospect was converted (e.g., from lead to opportunity).	dimension
convertedFromObjectName	convertedFromObjectName	The name of the object type from which the prospect was converted.	dimension
convertedFromObjectType	convertedFromObjectType	The type of object from which the prospect was converted.	dimension
country	country	The country where the prospect is located.	dimension
createdAt	createdAt	The date and time when the prospect record was created. This timestamp is reported in the API user’s preferred timezone.	dimension
createdAt_date	createdAt_date	The date when the prospect record was created, derived from the createdAt timestamp.	dimension
createdById	createdById	The ID of the user who created the prospect record.	metric
department	department		dimension
doNotSell	doNotSell	Indicates whether the prospect has opted out of the sale of their personal information.	dimension
emailBouncedAt	emailBouncedAt	The date and time when an email sent to the prospect hard bounced.	dimension
emailBouncedReason	emailBouncedReason	The reason why an email sent to the prospect hard bounced.	dimension
employees	employees		dimension
fax	fax		dimension
firstActivityAt	firstActivityAt	The date and time of the prospect’s first recorded activity.	dimension
firstAssignedAt	firstAssignedAt	The date and time when the prospect was first assigned to a user or group.	dimension
firstName	firstName	The first name of the prospect.	dimension
firstReferrerQuery	firstReferrerQuery	The search query that led the prospect to the first referring URL.	dimension
firstReferrerType	firstReferrerType	The type of referrer that led to the prospect’s first interaction (e.g., search engine, social media).	dimension
firstReferrerUrl	firstReferrerUrl	The URL of the first referring page that led to the prospect’s interaction.	dimension
id	id	A unique identifier for the prospect record within Pardot.	metric
industry	industry	The industry of the prospect’s company.	dimension
isDeleted	isDeleted	Indicates whether the prospect record has been marked as deleted.	dimension
isDoNotCall	isDoNotCall	Indicates whether the prospect has requested not to be called.	dimension
isDoNotEmail	isDoNotEmail	Indicates whether the prospect has opted out of receiving emails.	dimension
isEmailHardBounced	isEmailHardBounced	Indicates whether an email sent to the prospect has resulted in a hard bounce.	dimension
jobTitle	jobTitle	The job title of the prospect.	dimension
lastActivityAt	lastActivityAt	The date and time of the prospect’s last recorded activity.	dimension
lastActivityAt_date	lastActivityAt_date	The date of the prospect’s most recent interaction or activity recorded in Pardot.	dimension
lastName	lastName	The last name of the prospect.	dimension
lifecycleStageId	lifecycleStageId	The unique identifier for the prospect’s current lifecycle stage (e.g., MQL, SQL).	metric
mediumParameter	mediumParameter		dimension
optedOut	optedOut	Indicates whether the prospect has opted out of all marketing communications.	dimension
phone	phone	The primary phone number of the prospect.	dimension
profileId	profileId	The unique identifier for the prospect’s profile, used for segmentation and scoring.	dimension
prospectAccountId	prospectAccountId	The unique identifier for the account associated with the prospect within Pardot.	metric
salesforceAccountId	salesforceAccountId	The unique identifier of the associated Salesforce Account record.	dimension
salesforceCampaignId	salesforceCampaignId	The unique identifier of the associated Salesforce Campaign record.	dimension
salesforceContactId	salesforceContactId	The unique identifier of the associated Salesforce Contact record.	dimension
salesforceId	salesforceId	The unique identifier of the associated record in Salesforce.	dimension
salesforceLastSync	salesforceLastSync	The date and time when the prospect record was last synchronized with Salesforce.	dimension
salesforceLeadId	salesforceLeadId	The unique identifier of the associated Salesforce Lead record.	dimension
salesforceOwnerId	salesforceOwnerId	The unique identifier of the Salesforce user who owns the prospect record.	dimension
salesforceUrl	salesforceUrl	The URL to the associated record within Salesforce.	dimension
salutation	salutation	The formal salutation or prefix for the prospect (e.g., Mr., Ms., Dr.).	dimension
score	score	The prospect’s score, indicating their engagement and qualification level.	metric
source	source	The source of the prospect’s origin, often derived from tracking parameters like utm_source from Google Analytics.	dimension
sourceParameter	sourceParameter		dimension
state	state	The state or province where the prospect is located.	dimension
termParameter	termParameter		dimension
territory	territory		dimension
updatedAt	updatedAt	The date and time when the prospect record was last updated.	dimension
updatedAt_date	updatedAt_date	The date when the prospect record was last updated. This date is derived from the updatedAt timestamp, which is reported in the API user’s preferred timezone.	dimension
updatedById	updatedById	The ID of the user who last updated the prospect record.	metric
userId	userId	The unique identifier for the prospect record.	metric
website	website	The website URL of the prospect’s company.	dimension
zip	zip	The zip or postal code of the prospect’s address.	dimension