JDBC Driver for SurveyMonkey

Build 20.0.7654

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654