Send

Used to send email and retrieve aggregate data. This table does not support 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	Identifier for an object.
PartnerKey	String	False	Unique identifier provided by partner for an object, accessible only via API.
CreatedDate	Datetime	False	Indicates the date and time of the object's creation.
ModifiedDate	Datetime	False	Indicates the last time object information was modified.
Client_ID	Int	False	The Id of the client.
Client_PartnerClientKey	String	False	User-defined partner key for an account.
Email_ID	Int	False	Identifier for an object.
Email_PartnerKey	String	False	Unique identifier provided by partner for an object, accessible only via API.
SendDate	Datetime	False	Indicates the date on which a send occurred.
FromAddress	String	False	Indicates From address associated with a object.
FromName	String	False	Specifies the default email message From Name.
Duplicates	Int	False	Represent the number of duplicate email addresses associated with a send.
InvalidAddresses	Int	False	Specifies the number of invalid addresses associated with a send.
ExistingUndeliverables	Int	False	Indicates whether bounces occurred on previous send.
ExistingUnsubscribes	Int	False	Indicates whether unsubscriptions occurred on previous send.
HardBounces	Int	False	Indicates number of hard bounces associated with a send.
SoftBounces	Int	False	Indicates number of soft bounces associated with a specific send.
OtherBounces	Int	False	Specifies number of Other-type bounces in a send.
ForwardedEmails	Int	False	Number of emails forwarded for a send.
UniqueClicks	Int	False	Indicates number of unique clicks on message.
UniqueOpens	Int	False	Indicates number of unique opens resulting from a triggered send.
NumberSent	Int	False	Number of emails actually sent as part of an email send.
NumberDelivered	Int	False	Number of sent emails that did not bounce.
NumberTargeted	Int	False	Indicates the number of possible recipients for an email send.
NumberErrored	Int	False	Number of emails not sent as part of a send because an error occurred while trying to build the email.
NumberExcluded	Int	False	Indicates the number recipients excluded froman email send because of a held, unsubscribed, master unsubscribed, or global unsubscribed status.
Unsubscribes	Int	False	Indicates the number of unsubscribe events associated with a send.
MissingAddresses	Int	False	Specifies number of missing addresses encountered within a send.
Subject	String	False	Defines the status of an object.
PreviewURL	String	False	Indicates URL used to preview the message associated with a send.
SentDate	Datetime	False	Indicates date on which a send took place.
EmailName	String	False	Specifies the name of an email message associated with a send.
Status	String	False	The status of the object.
IsMultipart	Bool	False	Indicates whether the email is sent with Multipart/MIME enabled.
SendLimit	Int	False	Indicates limit of messages to send as part of a send definition within a predefined send window.
SendWindowOpen	Datetime	False	Defines the beginning of a send window for a send definition.
SendWindowClose	Datetime	False	Defines the end of a send window for a send definition.
IsAlwaysOn	Bool	False	Indicates whether the request can be performed while the system is is maintenance mode.
Additional	String	False	The ID for a send that customers use as a campaign ID.
BCCEmail	String	False	Indicates email addresses to receive blind carbon copy of a message.
EmailSendDefinition_ObjectID	String	False	System-controlled, text string identifier for object.
EmailSendDefinition_CustomerKey	String	False	The customer key of the email send definition.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。