TDV Adapter for Act-On

Build 22.0.8462

Reports

Query the available reports in ActOn.

View Specific Information

To query data from this view, you must specify MessageId.
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.

  • MessageId supports the '=' and 'IN' operators.

For example, the following queries are processed server side:

SELECT * FROM Reports WHERE MessageId = 'd-0008'
SELECT * FROM Reports WHERE MessageId IN ('d-0008','s-0004-1809')

Columns

Name Type Description
MessageId [KEY] String The Id of the message.
Title String The title of the message.
Status String The status of the message.
Bounced Int The number of times the message generated a bounce.
Clicked String The number of times the message has been clicked.
Delivered Int The number of times the message has been delivered.
EffectiveOpened String .
HardBounced Int The number of times the message generated hard bounce.
LastClick Datetime The timestamp of the last click.
LastOpen Datetime The timestamp of the last opening.
NotOpened Int The number of times the message has not been opened.
NotSent String The number of times the message has not been sent.
Opened String The number of times the message was opened.
OptOut Int The number of times the receiver opted out.
RedbroadcastClick Int .
Sent Int The number of times the message has been sent.
SentTo String The ids of the people who received the email.
SoftBounced Int The number of times the message generated soft bounce.
Spam Int The number of times has been considered as spam.
Subject String The subject of the message.
SuppressedOn String .

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462