Qualtrics: Survey

Description

• Detailed view of all surveys created, enhanced with distribution and response metrics.

Supported Data Sources

• Qualtrics

Columns

Type	Name	Description
STRING	survey_id	The unique identifier for this survey. Match pattern = ^SV_[a-zA-Z0-9]{11,15}$
STRING	survey_name	Name of the survey.
STRING	survey_status	The distribution status of the survey, or a flag indicating that it's a library blockAllowed values - Inactive, Active, Pending, LibBlock, Deactive, Temporary
STRING	brand_base_url	Base url for the organization/brand.
STRING	brand_id	Unique ID of the organization/brand.
INTEGER	bundle_short_name	Short name for the content bundle that the survey is from.
INTEGER	composition_type	Survey composition type.
INTEGER	auto_scoring_category	The automated scoring category.
INTEGER	default_scoring_category	The default scoring category.
INTEGER	division_id	The unique identifier for the Division ID. Match pattern = ^DV_[0-9a-zA-Z]{11,15}$
STRING	creator_user_id	The unique identifier for a specific USER who created the survey.
STRING	owner_user_id	The unique identifier for a specific user who owns this.
STRING	project_category	Project category of the survey.Allowed values - CORE, CX, EX, BX, PX
STRING	project_type	Type of Qualtrics project. Match pattern = ^[a-zA-Z]+$
INTEGER	registry_sha	The survey registry SHA.
INTEGER	registry_version	The survey registry version.
INTEGER	schema_version	Qualtrics schema version.
BOOLEAN	scoring_summary_after_questions	Boolean representing whether the scoring summary is after questions.
BOOLEAN	scoring_summary_after_survey	Boolean representing whether the scoring summary is after the survey.
INTEGER	scoring_summary_category	The unique identifier for the scoring.
INTEGER	last_accessed_at	The date the survey was last accessed.
STRING	last_activated_at	The date the survey was last activated.
STRING	last_modified_at	The point in time when the record was last modified.
BOOLEAN	is_deleted	Boolean representing whether the record was soft-deleted in Qualtrics.
DATETIME	_fivetran_synced	The time when a record was last updated by Fivetran.
STRING	source_relation	The schema or database this record came from if you are making use of the qualtrics_union_schemas or qualtrics_union_databases variables, respectively. Empty string if you are not using either of these variables to union together multiple Qualtrics connectors.
INTEGER	version_id	The unique identifier for this survey version.
INTEGER	version_number	The version number of this survey.
STRING	version_description	A user-provided description of the survey version.
STRING	survey_version_created_at	The creation date and time of the record, expressed as an ISO 8601 value.
INTEGER	count_published_versions	Number of versions that have been published for this survey.
STRING	publisher_user_id	ID of USER who published this survey version in your org.
STRING	publisher_email	Email of the USER who published the latest survey version.
STRING	creator_email	Email of the USER who created the object.
STRING	owner_email	Email of the USER who owns the object.
INTEGER	count_questions	Total number of questions (does not include deleted ones) in the survey.
DECIMAL	avg_response_duration_in_seconds	On average, how long it took a respondent to finish a survey in seconds.
DECIMAL	median_response_duration_in_seconds	The median of how long it took a respondent to finish a survey in seconds.
DECIMAL	avg_survey_progress_pct	On average, how far a respondent has progressed through a survey as a percentage out of 100.
DECIMAL	median_survey_progress_pct	The median of how far a respondent has progressed through a survey as a percentage out of 100.
INTEGER	count_survey_responses	Total number of survey responses.
INTEGER	count_completed_survey_responses	Total number of completed survey responses (ie is_finished=true).
INTEGER	count_survey_responses_30d	Number of survey responses recorded in the past 30 days.
INTEGER	count_completed_survey_responses_30d	Number of completed survey responses recorded in the past 30 days.
INTEGER	count_anonymous_survey_responses	Number of recorded survey responses distributed anonymously.
INTEGER	count_anonymous_completed_survey_responses	Number of completed recorded survey responses distributed anonymously.
INTEGER	count_social_media_survey_responses	Number of recorded survey responses distributed via social media.
INTEGER	count_social_media_completed_survey_responses	Number of completed survey responses distributed via social media.
INTEGER	count_personal_link_survey_responses	Number of recorded survey responses distributed via personal links.
INTEGER	count_personal_link_completed_survey_responses	Number of completed survey responses distributed via personal links.
INTEGER	count_qr_code_survey_responses	Number of recorded survey responses distributed via QR codes.
INTEGER	count_qr_code_completed_survey_responses	Number of completed survey responses distributed via QR codes.
INTEGER	count_email_survey_responses	Number of recorded survey responses distributed via email.
INTEGER	count_email_completed_survey_responses	Number of completed survey responses distributed via email.
INTEGER	count_sms_survey_responses	Number of recorded survey responses distributed via SMS invite.
INTEGER	count_sms_completed_survey_responses	Number of completed survey responses distributed via SMS invite.
INTEGER	count_uncategorized_survey_responses	Number of recorded survey responses not distributed via the default channels.
INTEGER	count_uncategorized_completed_survey_responses	Number of completed survey responses not distributed via the default channels.