EmailStats
Retrieve email stats.
Table Specific Information
The connector 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 connector.
- 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. |