ADO.NET Provider for Salesforce Pardot

Build 21.0.8137

EmailClicks

Retrieve email clicks.

Table Specific Information

Select

The provider 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 provider.

  • Id supports '>', '>='.
  • ListEmailId supports '='.
  • DripProgramActionId supports '='.
  • EmailTemplateId supports '='.
  • TrackerRedirectId supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM EmailClicks WHERE ListEmailId = 20
SELECT * FROM EmailClicks WHERE DripProgramActionId = 42
SELECT * FROM EmailClicks WHERE EmailTemplateId = 26 AND TrackerRedirectId = 31 AND CreatedAt > '02/03/2019 23:11:33'

Columns

Name Type References Description
Id [KEY] Integer Pardot ID for this email click.
ProspectId Integer

Prospects.Id

Pardot ID for the associated prospect.
Url String URL of the email click.
ListEmailId Integer Pardot ID for the associated list email. Value not present if null.
DripProgramActionId Integer Pardot ID for the associated drip program action. Value not present if null.
EmailTemplateId Integer

EmailTemplates.Id

Pardot ID for the associated email template. Value not present if null.
TrackerRedirectId Integer Pardot ID for the associated tracker redirect. Value not present if null.
CreatedAt Datetime Time that email click occurred.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137