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 本製品 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'
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. |