EmailClicks
Retrieve email clicks.
Table Specific Information
Select
The connector will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- 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] | Int64 | Pardot ID for this email click. | |
| ProspectId | Int64 |
Prospects.Id | Pardot ID for the associated prospect. |
| Url | String | URL of the email click. | |
| ListEmailId | Int64 | 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 | Int64 | Pardot ID for the associated email template. Value not present if null. | |
| TrackerRedirectId | Int64 | Pardot ID for the associated tracker redirect. Value not present if null. | |
| CreatedAt | Datetime | Time that email click occurred. |