JDBC Driver for Salesforce Marketing Cloud

Build 22.0.8462

TriggeredSendSummary

Summary of results for a specific triggered send.

View-Specific Information

Select

The driver 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 driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.

For example, the following (but not only) queries are processed server side:

SELECT * FROM TriggeredSendSummary

SELECT * FROM TriggeredSendSummary WHERE ObjectID = 'nzxcaslkjd-123'

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

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

Columns

Name Type Description
ObjectID [KEY] String System-controlled, read-only text string identifier for object.
Client_ID Long The Id of the client.
Client_PartnerClientKey String User-defined partner key for an account.
CustomerKey String User-supplied unique identifier for an object within an object type.
PartnerKey String Unique identifier provided by partner for an object, accessible only via API.
Sent Long Indicates number of messages sent.
NotSentDueToOptOut Long Indicates number of sends not completed due to a subscriber's decision to opt out of receiving messages.
NotSentDueToUndeliverable Long Indicates number of sends not completed due to a subscriber's undeliverable status.
Bounces Long Indicates number of bounces resulting from a triggered send.
Opens Long Indicates number of opens from a triggered send.
UniqueOpens Long Indicates number of opens from a triggered send.
Clicks Long Indicates the number of clicks resulting from a triggered send.
UniqueClicks Long Indicates number of unique clicks on message.
OptOuts Long Indicates number of subscribers who opted out of receiving messages after receiving a triggered send.
SurveyResponses Long Indicates number of responses to a survey question contained in a triggered send.
FTAFRequests Long Indicates number of Forward To A Friend requests received as part of a triggered send.
FTAFEmailsSent Long Indicates Forward To A Friend emails sent as a result of a triggered send.
FTAFOptIns Long Indicates number of subscribers opting in to receiving messages as a result of a Forward To A Friend action from a triggered send.
Conversions Long Indicates the number of conversions results from a triggered send.
UniqueConversions Long Indicates number of unique conversions resulting from a triggered send.
InProcess Long Indicates the number of triggered send messages in progress. Deprecated.
NotSentDueToError Long Indicates number of triggered send messages not sent due to error.
RowObjectID String The row id of the object.
TriggeredSendDefinition_ObjectID String The Id of the associated triggered send definition for triggered send.
Queued Long Indicates number of messages queued for sending.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462