ForwardedEmailOptInEvent
Specifies opt-in events that occur when a recipient subscribes as a result of receiving a Forward to a Friend email in Salesforce Marketing Cloud. This view helps identify new subscribers who joined through referral-based interactions.
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 ForwardedEmailOptInEvent WHERE Id = 123 SELECT * FROM ForwardedEmailOptInEvent WHERE Id IN (123, 456) SELECT * FROM ForwardedEmailOptInEvent WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ID [KEY] | Int | Stores the read-only identifier (Id) that uniquely identifies this forwarded email opt-in event record. This Id is used for tracking, auditing, and referencing individual opt-in actions that occur through forwarded email interactions. |
| ObjectID | String | Stores the system-controlled text string Id that uniquely identifies this event object across Salesforce Marketing Cloud systems. This value ensures consistent referencing in reporting, automation, and API-based operations. |
| PartnerKey | String | Contains the partner-defined unique Id that links this forwarded email opt-in event to an external integration. This key supports cross-system traceability when partner platforms participate in opt-in processing. |
| CreatedDate | Datetime | Indicates the date and time when the record for the forwarded email opt-in event was created. This timestamp supports event auditing and helps reconstruct subscriber engagement timelines. |
| ModifiedDate | Datetime | Indicates the most recent date and time when the forwarded email opt-in event record was updated. This value supports troubleshooting and reconciliation activities. |
| Client_ID | Int | Specifies the client Id that associates the forwarded email opt-in event with the appropriate Salesforce Marketing Cloud account or business unit. This association ensures that opt-in activity is evaluated within the correct account context. |
| SendID | Int | Specifies the Id of the send operation that delivered the original email that led to the opt-in. This value allows downstream reporting tools to link the opt-in activity to the specific message send. |
| SubscriberKey | String | Stores the subscriber key that identifies the contact associated with the original forwarded email interaction. This value distinguishes the forwarding contact from the subscriber who opted in. |
| EventDate | Datetime | Indicates the date and time when the forwarded email opt-in event occurred. This information helps reconstruct engagement patterns and opt-in sequences. |
| EventType | String | Specifies the type of tracking event captured for the forwarded email opt-in action. This classification allows reporting tools to differentiate opt-ins from other engagement events such as opens, clicks, or bounces. |
| TriggeredSendDefinitionObjectID | String | Stores the system-controlled text string Id that identifies the triggered send definition that is associated with this opt-in event. This Id links the activity back to the triggered send configuration that produced the email. |
| BatchID | Int | Specifies the batch Id used to group this forwarded email opt-in event with other related tracking events. This grouping supports aggregated reporting for a specific send execution. |
| OptInSubscriberKey | String | Stores the subscriber key of the individual who opted in through the forwarded email process. This value identifies the newly opted-in subscriber and differentiates this contact from the subscriber who performed the forwarding action. |