SenderProfile

Stores sender profile configurations in Salesforce Marketing Cloud. A sender profile defines the 'From' name, 'From' email address, and reply handling for outbound messages. This table supports integration with send definitions to maintain consistent sender identity across campaigns.

Table-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 SenderProfile WHERE ObjectID = 'nzxcaslkjd-123'

SELECT * FROM SenderProfile WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')

SELECT * FROM SenderProfile WHERE CreatedDate > '2017/01/25'

Insert

You must specify the following fields when inserting to this table: Name, FromName, and FromAddress.

INSERT INTO SenderProfile (Name, FromName, FromAddress) VALUES ('Test', 'Friendly Neighborhood', '[email protected]')

Update

You must specify the ObjectID in the WHERE clause when executing an update against this table.

UPDATE SenderProfile SET Name = 'changed_name', Description = 'changed_desc', FromName = 'changed_from_name', FromAddress = '[email protected]' WHERE ObjectID = 'nzxcaslkjd-123'

Delete

You must specify the ObjectID in the WHERE clause when executing a delete against this table.

DELETE FROM SenderProfile WHERE ObjectID = 'nzxcaslkjd-123'

Columns


Name	Type	ReadOnly	Description
Name	String	False	Specifies the display name that is assigned to the sender profile and shown throughout Email Studio and related send configuration workflows.
Description	String	False	Provides a description that explains the purpose, usage context, or administrative details of the sender profile.
FromName	String	False	Specifies the default From Name that is used in email messages that reference this sender profile.
FromAddress	String	False	Specifies the default 'From Address' value that is associated with this sender profile and applied to outbound email messages.
UseDefaultRMMRules	Bool	False	Returns a value of 'true' when the sender profile uses the default Reply Mail Management (RMM) rules that are configured for the account. It returns a value of 'false' when the profile uses custom RMM rules instead of the account defaults.
AutoForwardToEmailAddress	String	True	Specifies the email address to which automatically forwarded replies should be sent when reply forwarding is enabled for the sender profile.
AutoForwardToName	String	True	Specifies the display name that is used as the To Name on automatically forwarded email messages.
DirectForward	Bool	False	Returns a value of 'true' when the sender profile allows replies to be forwarded directly to the designated forwarding address without RMM intervention. It returns a value of 'false' when replies are processed through RMM logic instead of being forwarded directly.
AutoForwardTriggeredSend_ObjectID	String	False	Specifies the system-controlled object identifier (Id) that represents the triggered send definition that is used for automatic forwarding actions.
AutoReply	Bool	False	Returns a value of 'true' when the sender profile sends an automatic reply message for inbound replies. It returns a value of 'false' when the profile does not send automatic replies.
AutoReplyTriggeredSend_ObjectID	String	False	Specifies the system-controlled object Id of the triggered send definition that is used to generate an automatic reply email.
SenderHeaderEmailAddress	String	False	Specifies the email address that is included in the sender header when outbound messages reference this sender profile.
SenderHeaderName	String	False	Specifies the display name that is included in the sender header when outbound messages reference this sender profile.
DataRetentionPeriodLength	String	False	Specifies the number of time units for which data that relates to the sender profile should be retained as part of data retention and compliance policies.
ReplyManagementRuleSet_ObjectID	String	False	Specifies the system-controlled object Id that identifies the rule set that governs reply mail management behavior for this sender profile.
RMMRuleCollection_ObjectID	String	False	Specifies the system-controlled object Id for the collection of RMM rules that apply to the sender profile.
Client_ID	Long	False	Specifies the Id of the client that owns or manages the sender profile.
PartnerKey	String	False	Specifies the unique partner-provided key that is associated with the sender profile and accessible only through the API.
CreatedDate	Datetime	False	Indicates the date and time when the sender profile was created. This value is system-generated and read-only.
ModifiedDate	Datetime	False	Indicates the date and time when the sender profile was last modified. This value updates when administrative or automated changes occur.
ObjectID	String	False	Specifies the system-controlled object Id that uniquely identifies the sender profile within Marketing Cloud.
CustomerKey	String	False	Specifies the user-supplied unique Id for the sender profile within its object type. This Id is used for API interactions and cross-object references.
Client_CreatedBy	Int	False	Returns the Id of the user who created the sender profile.
Client_ModifiedBy	Int	False	Returns the Id of the user who last modified the sender profile.