The Activities Transcript is accessible via the Transcripts area of the Study Admin menu. The transcript will provide you with the desired participant response data for any Activities within the Study. Depending on the settings you choose, Recollective will produce a file or series of files that you can download directly to your device.
In addition to the ability to locally download and extract all available response data, you'll have access to plenty of optional transcript settings and inclusions such as file output, response format, participant identity format, and even included Segments.
Preparing Your Transcript
Just like Reports within Recollective, your transcripts can be customized for your given need and use case. These controls allow you to produce a transcript that contains all individuals and includes all Activities or more focused ones that target specific Activities, participants or Segments.
Recollective can produce your Activity Transcript in three different formats:
1. Formatted document (HTML)
This option produces a media embedded HTML transcript of the participant responses. It closely resembles a Word document format whereby Activity and participant metadata is displayed in a vertically scrolling document.
This output type is desirable for read-through documents and also allows you to customize the document further with the Simplify Transcript option.
You can always export the response data to an Excel or CSV file using the export options in the upper right hand corner. There's also a Print option if you'd like to use the transcript as a physical deliverable. If you'd like to save a version of your document, you can use the Print option to Save as PDF within your internet browser.
2. Formatted Spreadsheet (Excel)
This option will produce an Excel workbook file for each Activity the transcript includes. The Excel output will separate the different Activity content into different worksheets (e.g. the participants and Task responses, comments, excerpts).
For the participant response sheet, the first row will act as a header row denoting the column field and stating the Task number, Task type and title for each of the programmed Tasks. The second row will include the actual Task instructions and question verbiage for the relevant Task columns. The following rows will identify the individual participant with the subsequent columns indicating their responses.
Embedded links to media such as participant submitted photos and videos are included as well. Clicking a link will take the user directly to the full sized versions of the content.
3. Text-only data export (CSV)
The CSV option contains all of the participant response data in a single sheet. No media is embedded in this export type and it is a text-only output of the requested participant and response data. This format is best used when attempting to import the data into external data analysis tools.
These options determine what data will be produced within the export with reference to instructions and responses. In most cases you'll want to extract both Instructions and responses (default). However, you'll also have the ability to produce a transcript of the Responses Only or Instructions Only.
You'll also be able to customize the amount of extra data that is included within your Activities Transcript. There are six optional settings you can include within your transcript:
- Comments: Includes participant and Admin related comments tied to Task responses
- Ratings: If you've enabled social ratings from the Study Settings: Configuration area, you'll be able to include any personal Likes and Dislikes on participant responses
- Excerpts: Any participant text that was saved as coded excerpts will be included in the transcript
- Backroom: Includes any Admin-only facing backroom comments and Tasks
- Photos: By default, photos are not included within the transcripts to minimize the file size but if you'd like to include all associated image data, just include this option as part of your transcript file (please note that file sizes may significantly increase as well as the time to generate the file)
- Incompletes: In certain cases, some of your participants may fail to complete all of their assigned Activities and Tasks - enabling this option will include all participant responses including those that are incomplete or in draft
Response Date Range
This section allows you to determine the date range of the included Activity data. In most cases, you'll typically extract all of the associated data from your Study using the All Time default. However, if you need to drill down on a specific month or response period, you have a custom as well as standardized date options.
This area controls which participant responses are actually included within your transcript. While most users will create a data export that includes All Participants, you may find yourself downloading filtered data either by Select Participants or even Select Segments if required.
This series of options will allow you to determine exactly what participant ID information you'd like to include in your transcript. This ranges from including the participant's Full name, to more limited options such as Username only or Unique ID only.
Participant privacy is an incredibly important aspect of the platform. For best practices, we highly recommend the use of extraction options that involve limiting the amount of personally identifiable information being downloaded in physical files. There are dedicated controls to Include participant photos and Include participant emails.