Understanding the Progress CSV Export

Updated on 30 Jul 2024

Print
Share
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

The Progress export is a CSV file which gets exported when you choose "Export Report" from the Progress Page.

Once downloaded, open the file in Excel, Sheets, or Numbers to view the results.

Progress Export Data

The file contains the following columns:

Dtect ID	The ID dtect generated for the transaction
Participant ID	The supplier's unique identifier
Project Number	dtect generated project number for your account, starting at 1
Project Name	User generated name of the project
Supplier ID	A dtect generated ID representing which supplier the transaction is from, the ID starts at 1 and increments
Supplier Name	The supplier's name
Survey Status	The status of the respondent that comes from the survey redirect
Dtect Status	The final dtect disposition status
Dtect Status Description	A description of the dtect status
Screener Entered At	The GMT time the respondent entered dtect
Screener Exited At	The GMT time the respondent exited dtect
Survey Exited At	The GMT time the survey exited the survey
Length of Interview	How many minutes the respondent spent in the survey
Unique Ref	A unique value which represents which supplier entry link was used
Entry Link Data	contains a JSON list of variables passed in the URL from the supplier to dtect
Advanced Fraud Detection Score	This score is generated when Advanced Fraud Detection is enabled on the project and represents how "trustworthy" the respondent is 0-100 based on our Advanced Fraud Detection calculations
Dtect Entry Link	The link the respondent was sent to from the supplier to dtect (prior to the survey)
Survey Entry Link	The link the respondent was sent to so they can complete the survey
Dtect Redirect Link	The link the survey sent respondents to after finishing the survey
Supplier Redirect Link	The link dtect sent respondents to at the end of the workflow
Is Billable?	Is this a valid respondent or a test respondent?

Survey Status

Status	Description
complete	Successfully finished the survey as a qualified complete and was redirected back to dtect
duplicate	This respondent has been seen before, either their device or IP address
security_terminate	This respondent was sent to the "security terminate" redirect within the survey
over_quota	This respondent was sent to the "over quota" redirect within the survey
terminate	This respondent was sent to the regular terminate redirect in the survey

dtect Status

Status	Description
complete	Successfully passed all of dtect's enabled security tests and was sent to the survey
terminate	This means we terminated the transaction for a reason other than security/duplicate/over_quota. These typically come from transactions who choose not to proceed for various reasons. See the "dtect Status Description" below, e.g. preflight not run and user chose to return
dropped	The user/transaction entered dtect but left before being sent to the survey or supplier.
duplicate	This user's fingerprint or IP address has already completed
over_quota	This happens while the survey is paused/draft mode and if the quota stop has been reached
security_terminate	This status is used when the user fails one of the dtect security checks other than duplicate

dtect Status Description

dtect Status Description	dtect Status	Description
advanced fraud detection	security terminate	The Advanced Fraud Detection score did not meet the minimum threshold set in the Security tab
failed screener	terminate	The participant did not answer enough of the quality questions correctly to proceed based on the threshold set in your project's security settings
AI use detected	security terminate	The AI open end question in the Quality Questions detected a paste so the participant was terminated
botnet protection	security terminate	Removed due to botnet protection being enabled
locale lock	security terminate	Transaction is located outside one of the countries selected in project settings and locale lock is enabled in the security section of your project
duplicate device	duplicate	This device has already been evaluated by dtect and duplicate device checking is enabled
duplicate IP	duplicate	This IP address has already been evaluated by dtect and duplicate IP checking is enabled
duplicate ID	security terminate	The supplier ID has already been evaluated by dtect, you cannot disable this
quota stop	over quota	The project has a quota stop enabled in the project settings and the limit has been reached
project draft	over quota	The project is in draft mode
project paused	over quota	The project is currently paused
project closed	over quota	The project is currently closed
supplier paused	over quota	The supplier for this transaction has been paused, re-enable them to allow these transactions
supplier disabled	over quota	The supplier for this transaction has been disabled, re-enable them to allow these transactions
attempted retry	security terminate	We believe this user was trying to go through our prescreener again once they had already finished it.
user chose to return	terminate	The user has JavaScript disabled or is preventing the preflight check from running, the participant chose the option to return to the supplier rather than enabling the checks
missing device fingerprint	security terminate	The participant's device fingerprint is required but we could not retrieve it
missing IP address	security terminate	The participant's IP address is missing
preflight not run	security terminate	The preflight check (initial check when they land on the page) has not run, so we rejected the participant as they could be tampering with the requests

Was this article helpful?

What's Next

Understanding the Quality Settings