Data Download: Accessing the Collected Data

Figure 1. Data Download Section

There are two options to download your data. The first option is to use the internal download option in the Project Hub. The second one is to download the data through the API.

Download Donations Through the Project Hub

Downloading the data through the Project Hub is a two-step process.

First, go to the Project Hub, scroll down to the section "Data Center" and download the Participation Overview:

Figure 2. Participation Overview Download

This will download a CSV file containing one row for every participant that has started participation in the project (i.e., this also contains participants that have not completed the donation). The file includes the following variables:

Variable/Column	Description
participant_id	The ID of the participant.
start_time	Date and time in ISO 8601 format when the participant first accessed the project (e.g., "2024-07-16 20:30:40.863581+00:00").
end_time	Date and time in ISO 8601 format when the participant accessed the debriefing page of the project (e.g., "2024-07-16 22:25:30.1634581+00:00").
current_step	The last step of the participation flow that the participant has accessed ("1" = Briefing page, "2" = data donation step, "3" = questionnaire, "4" = debriefing page).
completed	Indicates whether the participant has completed the participation (True/False).
extra_data	Contains any extra data recorded in relation to a participation (e.g., extracted URL parameters).
blueprint_<X>_name	The name of the blueprint with ID "X".
blueprint_<X>_time_submitted	Date and time in ISO 8601 format when the participant has submitted their donation for blueprint X.
blueprint_<X>_consent	Indicates whether the participant has consented to the donation of their data related to blueprint X.
blueprint_<X>_status	Indicates the status of the participant’s donation in relation to blueprint X ("success" = donation was successful, "pending" = data donation step reached but donation not attempted, "failed" = donation attempted but donation failed due to an error, "nothing extracted" = all data filtered out)
donation_download_link	A link though which the donation for the participant can be downloaded. Can be opened in the browser where you are logged in to DDM.

Variable/Column

Description

participant_id

The ID of the participant.

start_time

Date and time in ISO 8601 format when the participant first accessed the project (e.g., "2024-07-16 20:30:40.863581+00:00").

end_time

Date and time in ISO 8601 format when the participant accessed the debriefing page of the project (e.g., "2024-07-16 22:25:30.1634581+00:00").

current_step

The last step of the participation flow that the participant has accessed ("1" = Briefing page, "2" = data donation step, "3" = questionnaire, "4" = debriefing page).

completed

Indicates whether the participant has completed the participation (True/False).

extra_data

Contains any extra data recorded in relation to a participation (e.g., extracted URL parameters).

blueprint_<X>_name

The name of the blueprint with ID "X".

blueprint_<X>_time_submitted

Date and time in ISO 8601 format when the participant has submitted their donation for blueprint X.

blueprint_<X>_consent

Indicates whether the participant has consented to the donation of their data related to blueprint X.

blueprint_<X>_status

Indicates the status of the participant’s donation in relation to blueprint X ("success" = donation was successful, "pending" = data donation step reached but donation not attempted, "failed" = donation attempted but donation failed due to an error, "nothing extracted" = all data filtered out)

donation_download_link

A link though which the donation for the participant can be downloaded. Can be opened in the browser where you are logged in to DDM.

Next, you can download the data donations for each participant through the donation download link.

For larger donation projects where you collect data donations from many participants, it may be more convenient to download the data donations through the API (see below).

Download Questionnaire Responses Through the Project Hub

To download the questionnaire responses as a csv table, go to the Project Hub, scroll down to the section "Data Center" and download the file by clicking on Download CSV:

Figure 3. Questionnaire Responses Download

Download via API

To download your data via the API, you first have to create an API token. You can do so by going to the "Data Center" section in your Project Hub, and then clicking on "Manage Access Token". In the page that opens you can create an API token that is used to authenticate your external download request.

A list of available API endpoints and a more detailed description on how to use them can be found in the API section of the documentation.

Through the admin interface, a project can only be accessed by the user who created it. This means that the internal download is only accessible for a project owner. The API token, on the other hand, can be used to share data access with colleagues working on the same project. However, be careful with whom you share this token as it exposes the sensitive data collected from participants. We recommend choosing a short expiration date for Tokens that you create.