ReportsByPeriod
Query the reports related to messages in ActOn.
View Specific Information
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.
- 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. |