Guides
Sign InGet Started Free

Exporting Study Data (CSV)

Export a CSV file with your Study data

Suggest Edits

Overview

Draw further insights from your data by exporting a .csv file under Studies > {Select Your Study} > Download CSV

Note: CSV exports will be delivered to the user via email link

Download a CSV file

  1. Select Download CSV
  2. Choose your Column Format:
    1. Labels (Recommended) - a string describing the selected choice or theme
    2. Values (Preferred by Data Scientists) - an integer describing the selected choice or theme
    3. Both
  3. (Optional) Include themes generated by Sprig AI for Open Text responses
  4. (Optional) Include user attributes (that were used for survey targeting) alongside responses
  5. Select "Download CSV" - A download link will be delivered to your email inbox
    1. The link will expire after 1 week

Column Format Options

Sprig offers two different column export options for Surveys with Multiple Choice, Matrix or Open Text question types.

Labels

Values

Multiple Choice Multi Select questions will have answers indicated by 1/0 in a column that corresponds to choices while Multiple Choice Single Select or Matrix questions will have an index corresponding to the choice selected in a single cell (examples above).

Similarly, Open Text themes will be indicated by an index or a string based on export format (examples above).

Note: Text/URL Prompt, Consent/Legal, Open Text, Rating Scale, NPS, and Video & Voice question types will have their data structure displayed the same, regardless of column format choice.

File Columns:

In order from left to right in the CSV, below are the columns provided in the export:

  • surveyId: Integer
  • surveyName: String
  • visitorId: UUID
  • href: String
    • The page URL the study appeared on for in-product studies.
  • createdAt: Datetime
    • The study response start time/date in UTC.
  • completedAt: Datetime | Nullable
    • The study completion time/date if available in UTC.
  • userId: Integer | Nullable
  • os: String
    • The client OS
  • browser: String
  • userAgent: String
    • Information about the user's browser and client.
  • customMetadata: Object
    • This will be an empty Object, {}if there is no available customMetadata.
  • triggeringEvent: String
    • The event that triggered the study.
  • responseGroupUid: UUID
  • eventProperties: Object
    • This will be an empty Object, {} if there are no available eventProperties.
  • Q#_Response: Response Object
    • This is the stringified output of the response. The response data comes in number, string, and object data types.
  • Themes: String
    • When the "Include themes" checkbox is toggled, Sprig will return columns with theme data after a Open Text question response. Please refer to the above section for more details.
  • Attributes_#: String
    • When the "Include user attributes" checkbox is toggled, Sprig will append columns for all available attributes.

Updated 6 months ago