CData Python Connector for Act-On

Build 24.0.9062

DrilldownReports

Query detailed reports about 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 本製品.

  • MessageId supports the '=' operator.
  • Drilldown supports the '=' operator.

MessageId and Drilldown are required to select from this view and will be filtered by the Act-On API.

SELECT * FROM DrilldownReports WHERE MessageId = 's-0003-1803' AND Drilldown = 'SENT'

Columns

Name Type Description
MessageId String The id of the message.
Drilldown String Type of message.

使用できる値は次のとおりです。SENT, SUPPRESSED, OPENED, CLICKED, BOUNCED, OPT_OUT, SPAM

Email String The receiver email.
Name String Name of the receiver.
ListId String Id of the list the receiver belongs to.
RecId String The id of the receiver.
Timestamp Datetime When the message was sent.

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