SSIS Components for Salesforce Marketing Cloud Account Engagement

Build 23.0.8839


Retrieve email stats.

Table Specific Information

The component will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following column and operator. To query this table, you need to specify the Id. The rest of the filter is executed client side within the component.

  • Id supports '='.

For example, the following query is processed server side:

SELECT * FROM EmailStats WHERE Id = 10


Name Type References Description
Id [KEY] Int64 Pardot ID for this email.
Sent Integer Sent status.
Delivered Integer Delivered status.
TotalClicks Integer Total clicks.
UniqueClicks Integer Unique clicks.
SoftBounced Integer Soft bounces.
HardBounced Integer Hard bounces.
OptOuts Integer Opt count.
SpamComplains Integer Spam complains.
Opens Integer Opens.
UniqueOpens Integer Unique opens.
DeliveryRate String Delivery rate.
OpensRate String Open rate.
ClickThroughRate String Click through rate.
UniqueClickThroughRate String Unique click through rate.
ClickOpenRatio String Click to open ration.
OptOutrate String Opt rate.
SpamComplaintRate String Spam complaint rate.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839