Power BI Connector for Salesforce Marketing Cloud Account Engagement

Build 24.0.9060

Prospects

Retrieve and modify prospects.

Table Specific Information

Select

The connector will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.

  • Id supports '=', '<', '<=', '>', '>='.
  • UserId supports '=', '<', '<=', '>', '>='.
  • AssignedToId supports '=', '<', '<=', '>', '>='.
  • LastActivityAt supports '=', '<', '<=', '>', '>='.
  • IsDeleted supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.
  • UpdatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side: 

SELECT * FROM Prospects WHERE Id = 3457992
SELECT * FROM Prospects WHERE UserId = 14
SELECT * FROM Prospects WHERE UpdatedAt < '2021-12-30T03:16:27-08:00' AND CreatedAt >= '2021-11-12T07:18:56-08:00'

Get Deleted

To retrieve deleted prospects, a GETDELETED statement can be executed. 

GETDELETED FROM Prospects

Columns

Name Type ReadOnly References Description
Id [KEY] Int64 True

Pardot ID for this prospect.

AddressOne String False

Prospect's address, line 1.

AddressTwo String False

Prospect's address, line 2.

AnnualRevenue String False

Prospect's annual revenue.

CampaignId Int64 False

Pardot campaign related to this object.

CampaignParameter String True

Prospect's campaign parameter utm_campaign from Google Analytics.

SalesforceCampaignId String True

The alpha-numeric Id of the associated campaign in the Salesforce Org.

City String False

Prospect's city.

Comments String False

Comments about this prospect.

Company String False

Prospect's company.

ContentParameter String True

Prospect's content parameter utm_content from Google Analytics.

ConvertedAt Datetime True

Time when prospect was converted from visitor.

ConvertedFromObjectName String True

Name of object associated with visitor activity that resulted in prospect being converted from visitor.

ConvertedFromObjectType String True

ype of object associated with visitor activity that resulted in prospect being converted from visitor. Supported values include 'Form', 'FormHandler', 'LandingPage', 'MultivariateTestVariation', and 'Video'.

Country String False

Prospect's country.

SalesforceAccountId String True

Account ID in a supported Salesforce system.

SalesforceContactId String True

Prospect's contact ID in a supported Salesforce system.

SalesforceLastSync Datetime True

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

SalesforceLeadId String True

Prospect's lead ID in a supported Salesforce system.

SalesforceOwnerId String False

Prospect's owner ID in a supported Salesforce system.

SalesforceId String False

The alpha-numeric Id of the Salesforce Org.

Department String False

Prospect's department.

Email String False

Prospect's email address.

EmailBouncedAt Datetime True

Time

EmailBouncedReason String True

Reason why prospect email address hard bounced.

Employees String False

Prospect's number of employees.

Fax String False

Prospect's fax number.

FirstActivityAt Datetime True

Time when first visitor activity occurred for this prospect.

FirstAssignedAt Datetime True

Time prospect was first assigned to a user.

FirstName String False

Prospect's first name.

FirstReferrerQuery String True

First referrer's search query.

FirstReferrerType String True

First referrer's vendor and type (such as 'Google Natural Search').

FirstReferrerUrl String True

First referrer's URL.

Grade String True

Prospect's letter grade.

Industry String False

Prospect's industry.

IsDeleted Boolean True

True if the object is in the recycle bin in Pardot.

IsDoNotCall Boolean False

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

IsDoNotEmail Boolean False

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

isEmailHardBounced Boolean True

If true, prospect email address has hard bounced.

IsReviewed Boolean False

If value is 1, prospect has been reviewed.

IsStarred Boolean False

If value is 1, prospect has been starred.

JobTitle String False

Prospect's job title.

LastActivityAt Datetime True

Time stamp of this prospect's latest visitor activity.

LastName String False

Prospect's last name.

MediumParameter String True

Prospect's medium parameter utm_medium from Google Analytics.

Notes String False

Notes about this prospect.

OptedOut Boolean False

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

Password String True

Prospect's password.

Phone String False

Prospect's phone number.

ProspectAccountId Int64 False

Prospect's account ID.

Salutation String False

Prospect's formal prefix.

Score Integer False

Prospect's score.

Source String False

Prospect's source.

SourceParameter String True

Prospect's source parameter utm_source from Google Analytics.

State String False

Prospect's US state.

TermParameter String True

Prospect's term parameter utm_term from Google Analytics.

Territory String False

Prospect's territory.

Website String False

Prospect's website URL.

YearsInBusiness String False

Prospect's number of years in business.

Zip String False

Prospect's postal code.

AssignedToId Int64 True

ID of the user who the object record is assigned to.

ProfileId Int64 False

Pardot profile related to this object.

SalesforceUrl String True

URL to view the prospect within the Salesforce system.

LifecycleStageId Int64 True

Pardot lifecycle stage related to this object.

UserId Int64 False

User the prospect is assigned to.

RecentInteraction String True

Describes the prospect's most recent interaction with Pardot.

CreatedAt Datetime True

Time prospect was created in Pardot.

UpdatedAt Datetime True

Last time prospect was updated in Pardot.

CreatedById Int64 True

ID of the individual who created this object.

UpdatedById Int64 True

ID of the individual who last updated this object.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060