Query the available reports in ActOn.
View Specific Information
To query data from this view, you must specify MessageId.
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 '=' and 'IN' operators.
For example, the following queries are processed server side:
SELECT * FROM Reports WHERE MessageId = 'd-0008' SELECT * FROM Reports WHERE MessageId IN ('d-0008','s-0004-1809')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 [KEY]||String||The Id of the message.|
|Title||String||The title of the message.|
|Status||String||The status of the message.|
|Bounced||Int||The number of times the message generated a bounce.|
|Clicked||String||The number of times the message has been clicked.|
|Delivered||Int||The number of times the message has been delivered.|
|HardBounced||Int||The number of times the message generated hard bounce.|
|LastClick||Datetime||The timestamp of the last click.|
|LastOpen||Datetime||The timestamp of the last opening.|
|NotOpened||Int||The number of times the message has not been opened.|
|NotSent||String||The number of times the message has not been sent.|
|Opened||String||The number of times the message was opened.|
|OptOut||Int||The number of times the receiver opted out.|
|Sent||Int||The number of times the message has been sent.|
|SentTo||String||The ids of the people who received the email.|
|SoftBounced||Int||The number of times the message generated soft bounce.|
|Spam||Int||The number of times has been considered as spam.|
|Subject||String||The subject of the message.|