DrilldownReports
Query detailed reports about messages in ActOn.
View Specific Information
The connector will use the Act-On API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- MessageId supports the '=' operator.
- Drilldown supports the '=' operator.
MessageId and Drilldown are required to select from this view and will be filtered by the Act-On API.
SELECT * FROM DrilldownReports WHERE MessageId = 's-0003-1803' AND Drilldown = 'SENT'
Columns
| Name | Type | Description |
| MessageId | String | The id of the message. |
| Drilldown | String | Type of message.
The allowed values are SENT, SUPPRESSED, OPENED, CLICKED, BOUNCED, OPT_OUT, SPAM. |
| String | The receiver email. | |
| Name | String | Name of the receiver. |
| ListId | String | Id of the list the receiver belongs to. |
| RecId | String | The id of the receiver. |
| Timestamp | Datetime | When the message was sent. |