Reports
Query the available reports in ActOn.
View Specific Information
To query data from this view, you must specify MessageId.
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 '=' 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')
Columns
| Name | Type | Description |
| 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. |
| EffectiveOpened | String | . |
| 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. |
| RedbroadcastClick | Int | . |
| 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. |
| SuppressedOn | String | . |