ReportsByPeriod
Query the reports related to messages in ActOn.
View Specific Information
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.
- Period supports the '=' and 'IN' operators.
For example, the following queries are processed server side:
SELECT * FROM ReportsByPeriod WHERE Period = 'January 2018'
SELECT * FROM ReportsByPeriod WHERE Period IN ('January 2018', 'March 2018')
If not specified, the period will be the current month.Columns
| Name | Type | Description |
| Period | String | The period defined in the format '{month} yyyy' used to filter the reports. If not specified, report for the current month will return. |
| DayOfMonth | Int | The day of the month the report is about. |
| DayOfWeek | Int | The day of the week the report is about. |
| Sent | Int | The number of sent messages. |
| Bounced | Int | The number of bounced messages. |
| Clicked | Int | The number of clicked messages. |
| Opened | Int | The number of opened messages. |
| OptedOut | Int | Th number of opted out. |