Export applicant data
Generate custom CSV reports with the applicant data you need for reporting, analytics, and audit workflows.
Custom CSV Export allows you to get large volumes of data about applicants who pass identity verification.
The process of generation of a custom CSV export includes the following steps:
- A Sumsub client opens the Individual applicants page and ensures that they have access to the Custom CSV Export feature.
- If there is appropriate permission granted to the profile, they click the Custom CSV Export button and select the profiles and data to export.
- Once done, Sumsub starts the report generation and redirects the client to the report page.
- The client reviews the report details and status.
- The client receives a notification of the readiness and downloads the report.
Applicant data available for Custom CSV Export
All data is divided into two groups — sensitive and non-sensitive. This separation allows us to manage access to particular information using different permissions.
| Data | Group |
|---|---|
|
General |
|
|
applicantId |
Not sensitive |
|
applicantPlatform |
Not sensitive |
|
applicantStatus |
Not sensitive |
|
clientId |
Not sensitive |
|
createdAt |
Not sensitive |
|
deactivated |
Not sensitive |
|
externalUserId |
Not sensitive |
|
inspectionDate |
Not sensitive |
|
inspectionResetDate |
Not sensitive |
|
language |
Not sensitive |
|
levelName |
Not sensitive |
|
questionnaires |
Not sensitive |
|
requiredIdDocSetTypes |
Not sensitive |
|
sourceKey |
Not sensitive |
|
tags |
Not sensitive |
|
type |
Not sensitive |
|
Applicant personal info |
|
|
addressState |
Sensitive |
|
age |
Sensitive |
|
ageAtVerification |
Sensitive |
|
country |
Sensitive |
|
countryOfBirth |
Sensitive |
|
dateOfBirth |
Sensitive |
|
|
Sensitive |
|
firstName |
Sensitive |
|
firstNameEn |
Sensitive |
|
ipCountry |
Sensitive |
|
gender |
Sensitive |
|
lastName |
Sensitive |
|
lastNameEn |
Sensitive |
|
middleName |
Sensitive |
|
middleNameEn |
Sensitive |
|
nationality |
Sensitive |
|
phone |
Sensitive |
|
placeOfBirth |
Sensitive |
|
stateOfBirth |
Sensitive |
|
tin |
Sensitive |
|
Review info |
|
|
reviewStatus |
Not sensitive |
|
reviewAnswer |
Not sensitive |
|
reviewRejectType |
Not sensitive |
|
rejectLabels |
Not sensitive |
|
buttonIds |
Not sensitive |
|
reviewCreateDate |
Not sensitive |
|
reviewDate |
Not sensitive |
|
userComment |
Not sensitive |
|
clientComment |
Not sensitive |
|
ID doc info |
|
|
idDocTypes |
Not sensitive |
|
idDocCountries |
Not sensitive |
|
lastPoiCountry |
Not sensitive |
|
lastPoiDate |
Sensitive |
|
lastPoiId |
Not sensitive |
|
lastPoiIdDocType |
Not sensitive |
|
lastPoiImageId |
Not sensitive |
|
PoA doc info |
|
|
lastPoaCountry |
Not sensitive |
|
lastPoaDate |
Sensitive |
|
lastPoaId |
Not sensitive |
|
lastPoaIdDocType |
Not sensitive |
|
lastPoaImageId |
Not sensitive |
|
Risk labels |
|
|
riskLabelsAml |
Not sensitive |
|
riskLabelsCrossCheck |
Not sensitive |
|
riskLabelsDevice |
Not sensitive |
|
riskLabelsEmail |
Not sensitive |
|
riskLabelsPerson |
Not sensitive |
|
riskLabelsPhone |
Not sensitive |
|
riskLabelsSelfie |
Not sensitive |
Applicant export permissions
To export applicant data, the user must have the relevant Custom CSV Export permission and access to applicant data.
Grant the following permissions:
- Custom CSV Export (Lower sensitive data) or Custom CSV Export (Higher sensitive data)
- See list of applicants
- See applicant’s personal data
Export applicant data
To create a custom CSV export with applicant data:
- In the Dashboard, navigate to the list of applicants and find the Custom CSV Export button in the upper-right corner of the page. If you can see the button, it means that you have been granted appropriate permissions.
- Sort applicants using the filters on the page. Note that some filters may work differently when you create a CSV report.
- When filtered, select which profiles to export:
- To export specific profiles from the filtered list, check the box to the left of the applicant’s name.
- To export all profiles, no action is required.
- Click the Custom CSV Export button to Initiate the process of creating the report. You will be asked to select the data to be exported. The set of fields can be modified and the system will remember selection on your device.
- (Only applicable to users with 2FA enabled) Complete two-factor authentication by entering the code.
- Review information on the report and its status. Once you have selected the data for export, Sumsub starts the report generation and redirects you to the page where you can find all the details regarding your report:
- Report Name. The name of your report.
- Current Status. The status of your report. The possible statuses are: Requested, Completed, Failed.
- Availability Period. Information on how many days the report will remain available for download.
- Download Button. This button is available once your report is ready.
- Report Information. Information on the author (user who requests a report), generation date, report type, file size, and number of entries.
- Filters Used. The filters that have been applied to generate the report.
- Report Columns. The columns that are included in the report.
- Delete report Button. The button for deleting reports.
- When you receive a notification of the readiness, download the report—follow the link and download an archive containing the report (CSV) and the separate file with its settings.
View available reports
You can find all reports you have access to on the Reports page.
On this page, you can view and download reports generated by your account within the last 30 days.