JDBC Driver for Salesforce Pardot

Build 22.0.8462

EmailStats

Retrieve email stats.

Table Specific Information

The driver will use the Salesforce Pardot 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 driver.

  • Id supports '='.

For example, the following query is processed server side:

SELECT * FROM EmailStats WHERE Id = 10

Columns

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462