Get applicant data with Custom CSV Export

Get applicant data for in-depth analytics, auditors and regulators, additional quality control checks, and many more.

Custom CSV Export allows you to export large volumes of filtered data from the Dashboard for reporting, analytics, audits, and internal checks.

You can use Custom CSV Export to export:

The export mechanism is the same for both data types: apply filters on the relevant Dashboard page, start the export, wait until Sumsub generates the report, and download the CSV file from the report page.

The available fields, source page, and required permissions depend on the data type you export.

Benefits

Custom CSV Export provides the following benefits:

  • Ability to export a broad range of data.
  • Option to choose which data to export.
  • Flexible permission system that allows you to restrict sensitive data exports.
  • Support for exporting large volumes of data.
  • Export history maintained for up to 30 days.

Use cases

Custom CSV Export can help you with the following business processes:

  • Performing analytics and statistics.
  • Preparing reports for auditors and regulators.
  • Importing exported data into your internal systems.
  • Running additional quality control checks.
  • Reviewing large filtered sets of applicants or AML cases.

Technical limitations of Custom CSV Export feature

Custom CSV Export has some specific technical characteristics regarding the data retention period and filters that should be considered while using the feature.

Mismatch between filtered and exported entries

The number of exported applicant profiles may differ from the number of filtered entries in the Dashboard. This discrepancy is usually caused by the following reasons:

  • Applying a specific period of time. The Period filter operates differently in the Dashboard and Custom CSV Export. In the Dashboard, your local time zone is generally used, while the export feature uses the UTC time zone (UTC+0). Therefore, the applicant lists may vary.
  • Using unsupported filters. Some filters are not supported in Custom CSV Export, so applicants intended to be removed might be mistakenly included in the export.

Data retention period

All reports are stored for 30 days and are available for download during this time. The availability period of a report can be found on its page. After this period, reports are permanently deleted, and access to them is completely lost.

Search unavailability

You cannot use the search bar to find applicant profiles while using the Custom CSV Export feature. Instead, use the applicant filters located under the search bar.

Limitations of applicant filters

Before creating a custom CSV export for applicants, you can sort applicants using the filters available on the Applicants page.

Custom CSV Export supports most filters listed on the page. However, some filters may work differently when you create a CSV report.

Filter Name

Description

Period

On the applicant list page, the Period filter is based on the review.createDate value. However, in the export, the filter operates using the applicant.createdAt value. Since these dates can
differ, the number of exported applicants and the number of applicants displayed in the Dashboard table may vary.

When the period is set in the Dashboard, the list of applicants is displayed according to the user’s local time zone. In contrast, the Custom CSV Export feature uses the UTC time zone (UTC+0) to ensure consistency across all exports. As a result, the number of entries shown in the Dashboard and the number of entries in the exported file may differ for a specific user.

Risk labels

This filter is not supported by the Custom CSV Export feature. Some entries might be mistakenly included in the export.

Reuse scope

This filter is not supported by the Custom CSV Export feature. Some entries might be mistakenly included in the export.

Linked to company

This filter is not supported by the Custom CSV Export feature. Some entries might be mistakenly included in the export.

Enable Custom CSV Export notifications

Each account in the Sumsub Dashboard has its notification settings, which determine the information the account can receive.

You can enable the Custom CSV Export notifications by doing the following:

  1. Open the Dashboard and click the Profile icon in the upper-right corner.
  2. Select Profile settings.
  3. Navigate to the Notifications tab.
  4. Find Custom CSV export notifications and set up how you want to receive the alerts.

The Custom CSV Export notifications are sent when the report is ready and contain a link to the report page.

Configure Custom CSV Export permissions

To allow your team to create custom CSV exports via the Dashboard, you should grant them access using either:

These are the steps to be taken to manage the roles and give access to the feature:

  1. In the Dashboard, go to Settings and select Team.
  2. Navigate to Roles.
  3. Select a role or create a new one.
  4. Add the required permissions depending on the data type the user needs to export. If you do not have these permissions in the list, contact the Owner of your key, so they can set it up for you.
📘

Note

We recommend granting permission to export sensitive data only to a very limited group of individuals.

Who has access to Custom CSV reports

Access to the report is granted exclusively to the account that requested it. The report will not be accessible via a direct link, even if the users are on the same key and possess the full set of necessary permissions.

Restrict creating Custom CSV exports

There are additional settings that can be applied to the Dashboard profiles to impose limits on using the Custom CSV Export feature:

  • The See only sandbox environment data access limitation. The access limitations are set in Roles.
  • The See only those applicants that are created by this account, or via a link that this account generated account limitation.
  • Available source key values based on the specified restrictions in Source Key Restrictions.
  • The Hide approved applicants for this account access limitation.


Did this page help you?