JDBC Driver for Act-On

Build 20.0.7655

ReportsByPeriod

Query the reports related to messages in ActOn.

View Specific Information

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.

  • 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.

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.

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655