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 driver will execute other filters client-side in memory. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
For example, the following queries are processed server side:
SELECT * FROM CollectorStats WHERE CollectorId = '175305200' SELECT * FROM CollectorStats WHERE CollectorId = '175305200' AND MessageId = '57071816'
|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.|