CollectorStats
Shows statistics regarding all or specific messages sent from a collector.
Table Specific Information
Select
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'
Columns
| 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. |