DrilldownReports
Query detailed reports about messages in ActOn.
View Specific Information
The adapter will use the ActOn API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.
- MessageId supports the '=' operator.
- Drilldown supports the '=' operator.
MessageId and Drilldown are required to select from this view and will be filtered by the ActOn 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. |