ClickEvent
Contains tracking data for link click events in Salesforce Marketing Cloud. Each record includes the timestamp, URL identifier (Id), and destination URL for a link that a subscriber clicked in a sent message. This view is essential for analyzing engagement metrics and user interaction behavior.
View-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM ClickEvent WHERE Id = 123 SELECT * FROM ClickEvent WHERE Id IN (123, 456) SELECT * FROM ClickEvent WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ID [KEY] | Int | Specifies the system-generated identifier (Id) that uniquely represents the click event record within Salesforce Marketing Cloud. This Id is read-only and allows tracking systems to reference the specific engagement activity. |
| ObjectID | String | Specifies the system-controlled, read-only text string that uniquely identifies the click event object across API operations. This value ensures consistency when retrieving, correlating, or auditing tracking data. |
| PartnerKey | String | Specifies the unique Id that an external partner system provides for the click event. This value is available only through the API and supports cross-platform reconciliation and event mapping. |
| CreatedDate | Datetime | Indicates the date and time when the click event record was created within the tracking system. This value supports auditing and historical analysis. |
| ModifiedDate | Datetime | Indicates the most recent date and time when the click event record was updated. This value captures system adjustments that occur during processing or data normalization. |
| Client_ID | Int | Specifies the Id of the business unit that is associated with the click event. This value establishes the organizational context for the send and engagement activity. |
| SendID | Int | Specifies the Id of the email send that is associated with the click event. This Id ties the engagement activity to the specific send job that produced the message. |
| SubscriberKey | String | Specifies the unique subscriber key that identifies the contact who generated the click event. This value connects the engagement to a specific Salesforce Marketing Cloud contact record. |
| EventDate | Datetime | Indicates the date and time when the click tracking event occurred. This value reflects the moment when the subscriber clicked a tracked URL in the message. |
| EventType | String | Specifies the type of tracking event. For click events, this value identifies the activity as an interaction with a tracked URL. |
| TriggeredSendDefinitionObjectID | String | Specifies the object Id of the triggered send definition that is associated with the click event. This value links the engagement back to the triggered send configuration. |
| BatchID | Int | Specifies the batch Id that groups triggered send events together. This value allows reporting systems to correlate the click event with other events from the same triggered send execution. |
| URLID | Int | Specifies the Id of the URL that the subscriber clicked. This value maps the engagement to a tracked link in the message. |
| URL | String | Specifies the URL that the subscriber clicked as part of the tracking event. This value enables detailed reporting on link-level engagement. |