Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Survey Sparrow data to
Survey Sparrow Connector Reference
13 metrics62 dimensions
The Survey Sparrow connector exposes 75 fields (13 metrics, 62 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available options
region Region
Specify the API region to use (EU or Non-EU).
Possible values (2)
eu-apiapidefault
Survey Sparrow Fields
Survey Sparrow contact_lists fields
The contact_lists report of the Survey Sparrow connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| contact_lists__created_at | TEXT | contact_lists.created_at | contact_lists.created_at |
| contact_lists__description | TEXT | contact_lists.description | contact_lists.description |
| contact_lists__id | NUMERIC | contact_lists.id | contact_lists.id |
| contact_lists__name | TEXT | contact_lists.name | contact_lists.name |
Survey Sparrow contacts fields
The contacts report of the Survey Sparrow connector includes 10 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| contacts__active | BOOLEAN | contacts.active | contacts.active |
| contacts__createddate | TEXT | contacts.createddate | contacts.createddate |
| contacts__email | TEXT | contacts.email | contacts.email |
| contacts__first_name | TEXT | contacts.first_name | contacts.first_name |
| contacts__id | NUMERIC | contacts.id | contacts.id |
| contacts__job_title | TEXT | contacts.job_title | contacts.job_title |
| contacts__last_name | TEXT | contacts.last_name | contacts.last_name |
| contacts__mobile | TEXT | contacts.mobile | contacts.mobile |
| contacts__name | TEXT | contacts.name | contacts.name |
| contacts__unsubscribed | BOOLEAN | contacts.unsubscribed | contacts.unsubscribed |
Survey Sparrow questions fields
The questions report of the Survey Sparrow connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| questions__annotations | OBJECT | questions.annotations | questions.annotations |
| questions__choices | OBJECT | questions.choices | questions.choices |
| questions__created_at | TEXT | questions.created_at | questions.created_at |
| questions__id | NUMERIC | questions.id | questions.id |
| questions__is_required | BOOLEAN | questions.is_required | questions.is_required |
| questions__multiple_answers | BOOLEAN | questions.multiple_answers | questions.multiple_answers |
| questions__parent_question_id | NUMERIC | questions.parent_question_id | questions.parent_question_id |
| questions__position | TEXT | questions.position | questions.position |
| questions__properties | OBJECT | questions.properties | questions.properties |
| questions__rtxt | TEXT | questions.rtxt | questions.rtxt |
| questions__scale_points | OBJECT | questions.scale_points | questions.scale_points |
| questions__section | OBJECT | questions.section | questions.section |
| questions__tags | OBJECT | questions.tags | questions.tags |
| questions__type | TEXT | questions.type | questions.type |
| questions__updated_at | TEXT | questions.updated_at | questions.updated_at |
Survey Sparrow responses fields
The responses report of the Survey Sparrow connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| responses__answers | OBJECT | responses.answers | responses.answers |
| responses__channel | OBJECT | responses.channel | responses.channel |
| responses__channel_id | NUMERIC | responses.channel_id | responses.channel_id |
| responses__completed_time | TEXT | responses.completed_time | responses.completed_time |
| responses__contact | TEXT | responses.contact | responses.contact |
| responses__expressions | OBJECT | responses.expressions | responses.expressions |
| responses__id | NUMERIC | responses.id | responses.id |
| responses__language | TEXT | responses.language | responses.language |
| responses__start_time | TEXT | responses.start_time | responses.start_time |
| responses__state | TEXT | responses.state | responses.state |
| responses__survey_id | NUMERIC | responses.survey_id | responses.survey_id |
| responses__variables | OBJECT | responses.variables | responses.variables |
Survey Sparrow roles fields
The roles report of the Survey Sparrow connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| roles__account_id | NUMERIC | roles.account_id | roles.account_id |
| roles__created_at | TEXT | roles.created_at | roles.created_at |
| roles__deleted_at | TEXT | roles.deleted_at | roles.deleted_at |
| roles__description | TEXT | roles.description | roles.description |
| roles__id | NUMERIC | roles.id | roles.id |
| roles__label | TEXT | roles.label | roles.label |
| roles__name | TEXT | roles.name | roles.name |
| roles__updated_at | TEXT | roles.updated_at | roles.updated_at |
Survey Sparrow survey_folders fields
The survey_folders report of the Survey Sparrow connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| survey_folders__auto_created | BOOLEAN | survey_folders.auto_created | survey_folders.auto_created |
| survey_folders__created_at | TEXT | survey_folders.created_at | survey_folders.created_at |
| survey_folders__description | TEXT | survey_folders.description | survey_folders.description |
| survey_folders__id | NUMERIC | survey_folders.id | survey_folders.id |
| survey_folders__name | TEXT | survey_folders.name | survey_folders.name |
| survey_folders__visibility | TEXT | survey_folders.visibility | survey_folders.visibility |
Survey Sparrow surveys fields
The surveys report of the Survey Sparrow connector includes 5 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| surveys__archived | BOOLEAN | surveys.archived | surveys.archived |
| surveys__created_at | TEXT | surveys.created_at | surveys.created_at |
| surveys__id | NUMERIC | surveys.id | surveys.id |
| surveys__name | TEXT | surveys.name | surveys.name |
| surveys__survey_type | TEXT | surveys.survey_type | surveys.survey_type |
Survey Sparrow users fields
The users report of the Survey Sparrow connector includes 10 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| users__admin | BOOLEAN | users.admin | users.admin |
| users__agency_owner | BOOLEAN | users.agency_owner | users.agency_owner |
| users__created_at | TEXT | users.created_at | users.created_at |
| users__email | TEXT | users.email | users.email |
| users__id | NUMERIC | users.id | users.id |
| users__name | TEXT | users.name | users.name |
| users__owner | BOOLEAN | users.owner | users.owner |
| users__phone | TEXT | users.phone | users.phone |
| users__role_id | NUMERIC | users.role_id | users.role_id |
| users__verified | BOOLEAN | users.verified | users.verified |
Survey Sparrow other fields
The Survey Sparrow connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |