Reports
Query the available reports in ActOn.
View Specific Information
To query data from this view, you must specify MessageId.
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 '=' 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 | . |