Send

Represents email send operations in Salesforce Marketing Cloud. Each record includes aggregate tracking data for sent emails, such as audience size, delivery results, and performance metrics. This table supports query and reporting but does not allow deletes or updates.

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 Send WHERE Id = 123

SELECT * FROM Send WHERE Id IN (123, 456)

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

Insert

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

INSERT INTO Send (FromName, Email_Id, List_Id) VALUES ('NASA', 31677, 52362)

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Int	False	Specifies the system-generated identifier (Id) that is used to uniquely identify the send record. This value supports tracking and reporting workflows.
PartnerKey	String	False	Specifies the unique partner-supplied key that is associated with the send record and is accessible only through API integrations.
CreatedDate	Datetime	False	Specifies the date and time when the send record was created. This value is read-only.
ModifiedDate	Datetime	False	Indicates the date and time when the send record was last modified. This value reflects system-managed changes.
Client_ID	Int	False	Specifies the Id of the client that owns or initiates the send operation.
Client_PartnerClientKey	String	False	Specifies the partner-defined client key that is associated with the marketing account and exposed through API workflows.
Email_ID	Int	False	Specifies the Id of the email asset that is used for the send operation.
Email_PartnerKey	String	False	Specifies the unique partner-supplied key that is associated with the email asset and is accessible only through API integrations.
SendDate	Datetime	False	Specifies the date and time when the send action occurred. This value is used for tracking and reporting.
FromAddress	String	False	Specifies the 'From' email address that is associated with the send record. This address reflects the configured sender profile.
FromName	String	False	Specifies the display name that is associated with the sender and shown to recipients.
Duplicates	Int	False	Indicates the number of duplicate email addresses that are detected during the send process.
InvalidAddresses	Int	False	Indicates the number of recipient addresses that are determined to be invalid during the send process.
ExistingUndeliverables	Int	False	Indicates whether prior bounces exist for recipients that are included in the send.
ExistingUnsubscribes	Int	False	Indicates whether prior unsubscribe events are associated with recipients included in the send.
HardBounces	Int	False	Indicates the number of hard bounces that occur as part of the send processing.
SoftBounces	Int	False	Indicates the number of soft bounces that occur during the send.
OtherBounces	Int	False	Specifies the number of bounces classified as 'Other' that occur during the send.
ForwardedEmails	Int	False	Indicates the number of messages that recipients forward to additional recipients.
UniqueClicks	Int	False	Indicates the number of unique click events that are recorded for the message.
UniqueOpens	Int	False	Indicates the number of unique open events that are registered for the message.
NumberSent	Int	False	Indicates the total number of email messages that are sent as part of the send operation.
NumberDelivered	Int	False	Indicates the number of sent messages that are successfully delivered without bouncing.
NumberTargeted	Int	False	Indicates the number of potential recipients that are targeted as part of the send.
NumberErrored	Int	False	Indicates the number of emails that are not sent because an error occurs during message construction or processing.
NumberExcluded	Int	False	Indicates the number of recipients that are excluded from the send because of held, unsubscribed, master unsubscribed, or global unsubscribed status.
Unsubscribes	Int	False	Indicates the number of unsubscribe events that occur as part of the send.
MissingAddresses	Int	False	Specifies the number of records that do not include required address information.
Subject	String	False	Specifies the subject line that is associated with the email message.
PreviewURL	String	False	Specifies the URL that is used to preview the message that is associated with the send.
SentDate	Datetime	False	Specifies the date and time when the send operation took place. This value can match or differ from the scheduled SendDate value that is based on processing time.
EmailName	String	False	Specifies the name of the email asset that is used for the send.
Status	String	False	Specifies the status that is associated with the send record (for example, Completed or InProgress).
IsMultipart	Bool	False	Returns a value of 'true' when the message is sent with Multipart/MIME enabled. It returns a value of 'false' when the message is delivered without Multipart/MIME formatting applied.
SendLimit	Int	False	Indicates the maximum number of messages that the send definition allows within a designated send window.
SendWindowOpen	Datetime	False	Specifies the date and time when the send window begins for the send definition.
SendWindowClose	Datetime	False	Specifies the date and time when the send window ends for the send definition.
IsAlwaysOn	Bool	False	Returns a value of 'true' when the send operation is allowed to proceed while the system is in maintenance mode. It returns a value of 'false' when the operation is restricted during maintenance windows.
Additional	String	False	Specifies the campaign identifier that customers assign to group or categorize the send.
BCCEmail	String	False	Specifies the blind carbon copy (Bcc) email addresses that are configured to receive a copy of the message.
EmailSendDefinition_ObjectID	String	False	Specifies the system-controlled object Id that is associated with the email send definition.
EmailSendDefinition_CustomerKey	String	False	Specifies the customer key that is associated with the email send definition.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.