Query detailed reports about messages in ActOn.
View Specific Information
The driver 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 driver.
- 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'You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will result in unfiltered data being pushed.
|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.|