Excel Add-In for Salesforce Pardot

Build 21.0.7930

Prospects

Retrieve and modify prospects.

Table Specific Information

Select

The add-in will use the Salesforce Pardot API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in.

  • Id supports '=', '<', '<=', '>', '>='.
  • Email supports '='.
  • Score supports '=', '<', '<=', '>', '>='.
  • Grade supports '<', '>'.
  • LastActivityAt supports '=', '<', '<=', '>', '>='.
  • IsStarred supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.
  • UpdatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM Prospects WHERE Id = 3457992
SELECT * FROM Prospects WHERE Email = 'example@exampledomain.com'
SELECT * FROM Prospects WHERE Score = 14

Insert

The following attribute is required when performing an insert: Email.

INSERT INTO Prospects(Email) VALUES('example@exampledomain.com')

Get Deleted

To retrieve deleted records, a GETDELETED statement can be executed. The GETDELETED statement supports the same server side filters that are supported by the SELECT statement (except ID and Email when using the equality(=) operator), but does not perform any client side filtering.

GETDELETED FROM Prospects WHERE Score > 2

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Pardot ID for this prospect.

CampaignId Integer False

Pardot ID of the campaign associated with this prospect Note: Information about a prospect's campaign association is returned in a campaign node in the XML response. However, updates to campaign associations are done by providing campaign_id during an UPDATE> request. See XML Response Formats in Using Prospects for more details.

Salutation String False

Prospect's formal prefix.

FirstName String False

Prospect's first name.

LastName String False

Prospect's last name.

Email String False

Prospect's email address.

Password String False

Prospect's password.

Company String False

Prospect's company.

ProspectAccountId Integer False

Prospect's account ID.

Website String False

Prospect's website URL.

JobTitle String False

Prospect's job title.

Department String False

Prospect's department.

Country String False

Prospect's country.

AddressOne String False

Prospect's address, line 1.

AddressTwo String False

Prospect's address, line 2.

City String False

Prospect's city.

State String False

Prospect's US state.

Territory String False

Prospect's territory.

Zip String False

Prospect's postal code.

Phone String False

Prospect's phone number.

Fax String False

Prospect's fax number.

Source String False

Prospect's source.

AnnualRevenue String False

Prospect's annual revenue.

Employees String False

Prospect's number of employees.

Industry String False

Prospect's industry.

YearsInBusiness String False

Prospect's number of years in business.

Comments String False

Comments about this prospect.

Notes String False

Notes about this prospect.

Score Integer False

Prospect's score.

Grade String True

Prospect's letter grade.

LastActivityAt Datetime True

Time stamp of this prospect's latest visitor activity.

RecentInteraction String True

Describes the prospect's most recent interaction with Pardot.

CrmLeadFid String True

Prospect's lead ID in a supported CRM system.

CrmContactFid String True

Prospect's contact ID in a supported CRM system.

CrmOwnerFid String True

Prospect's owner ID in a supported CRM system.

CrmAccountFid String True

Account ID in a supported CRM system.

CrmLastSync Datetime True

Last time this prospect was synced with a supported CRM system.

CrmUrl String True

URL to view the prospect within the CRM system.

IsDoNotEmail Boolean False

If value is 1, prospect prefers not to be emailed.

IsDoNotCall Boolean False

If value is 1, prospect prefers not to be called.

OptedOut Boolean True

If value is 1, prospect has opted out of marketing communications.

IsReviewed Boolean False

If value is 1, prospect has been reviewed.

IsStarred Boolean False

If value is 1, prospect has been starred.

CreatedAt Datetime True

Time prospect was created in Pardot.

UpdatedAt Datetime True

Last time prospect was updated in Pardot.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930