CData Python Connector for Act-On

Build 24.0.9062

ReportsByPeriod

Query the reports related to messages in ActOn.

View Specific Information

The 本製品 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 本製品.

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062