CollectorStats

Shows statistics regarding all or specific messages sent from a collector.

Table Specific Information

You must specify the collector Id to query from this view. The adapter will execute other filters client-side in memory.

For example, the following queries are processed server side:

SELECT * FROM CollectorStats WHERE CollectorId = '175305200'

SELECT * FROM CollectorStats WHERE CollectorId = '175305200' AND MessageId = '57071816'

Name	Type	Description
CollectorId	String	The Id of the collector these statistics belongs to.
MessageId	String	The Id of the message these statistics belong to. Null if they don't belong to a specific message.
Recipients	Integer	Count of recipients included in the stats.
CompletelyResponded	Integer	Count of recipients who have completed a survey response.
NotResponded	Integer	Count of recipients who have not started the survey.
PartiallyResponded	Integer	Count of recipients who have begun the survey but not completed it.
Opened	Integer	Count of recipients that have opened the message.
OptedOut	Integer	Count of recipients that have clicked on the opt out link.
NotSent	Integer	Count of recipients that have been added but their message has not been delivered.
Sent	Integer	Count of recipients that messages have been sent to.
Bounced	Integer	Count of recipients with messages that bounced.
LinkClicked	Integer	Count of messages where the included survey link was clicked on.