What are data exports?

Last updated: April 28, 2026

You can export data from ComplyAdvantage Mesh as a .CSV file. This can help you to create management reports or analyse the efficiency and effectiveness of your compliance program.

This article describes the content of the following data exports:

Customer screening

The Customer Screening export provides details about the customers screened, the date and time of the screening, and the match results.

This information is essential for understanding your screening processes. You can use it to calculate metrics such as the number of screenings over time, match rates and the average number of hits per match.

Each row in the export represents one screening.

These are the fields in the export:

Column	Field name	Description
A	screening_id	A unique ID for the screening.
B	screening_config_id	A unique ID of the screening configuration used.
C	screening_config_name	The name of the screening configuration used.
D	screening_config_version	The version of the screening configuration used.
E	internal_customer_id	The unique customer ID generated by ComplyAdvantage.
F	created_at	The timestamp of when the screening took place.
G	updated_at	The timestamp of when the screening was updated.
H	match_status	Indicates whether a screening returned any hits with TRUE or FALSE.
I	number_of_hits	The total number of hits returned for a given screening.
J	account_identifier	Your ComplyAdvantage account ID. This will be the same for all the rows of the export.
K	external_customer_id	Your unique ID for the customer. This ID is generated by you and is your reference for the customer.
L	person_full_name	If the customer is a person, their full name is provided.
M	company_legal_name	If the customer is a company, the legal company name is provided.
N	undefined_name	If the customer type is undefined, the customer name is provided.

Customers

The Customer export contains information about your customers, including their creation date and monitoring status. It also details each customer's risk level and their case count.

Each row in the export represents one customer.

These are the fields in the export:

Column	Field name	Description
A	internal_customer_id	The unique customer ID generated by ComplyAdvantage.
B	external_customer_id	Your unique ID for the customer. This ID is generated by you and is your reference for the customer.
C	created_at	The date and time the customer was created.
D	updated_at	The date and time when the customer was updated.
E	customer_status	The status of a customer (processing, active or closed).
F	customer_type	The type of customer (person or company).
G	customer_labels	The labels associated with this customer
H	customer_version	The version of the customer
I	person_first_name	The first name of the customer if the type is person.
J	person_middle_name	The middle name of the customer if the type is person.
K	person_last_name	The last name of the customer if the type is person.
L	person_full_name	The full name of the customer if the type is a person, and if their name information was provided as a single field.
M	person_date_of_birth	The date of birth of the customer if the type is a person.
N	person_country_of_birth	The country of birth of the customer if the type is a person.
O	person_nationality_list	A list of the customer’s nationalities if the type is a person.
P	person_country_of_residence_list	A list of the customer’s countries of residence if the type is a person.
Q	person_address_country_list	A list of the customer’s address countries if the type is a person.
R	company_address_country_list	A list of the customer’s address countries if the type is a company.
S	company_legal_name	The legal name of the customer if the type is a company.
T	company_place_of_registration	The place of registration of the customer if the type is a company.
U	company_incorporation_date	The incorporation date of the customer if the type is a company.
V	undefined_name	The name of the customer for a customer where the customer type was not provided and hence is categorised as 'undefined'.
W	undefined_country_list	Countries associated with a customer where the type is 'undefined'.
X	undefined_birth_year	Year of birth of a customer where the type is 'undefined' .
Y	customer_risk_level	The overall risk level of a customer (low, medium, high, prohibited or unspecified).
Z	is_monitored	Whether the customer is being monitored on an ongoing basis (YES or NO).
AA	last_monitor_run	The date and time the customer was last monitored.
AB	total_open_onboarding_cases	The number of open onboarding cases associated with the customer.
AC	total_closed_onboarding_cases	The number of closed onboarding cases associated with the customer.
AD	total_open_monitoring_cases	The number of open monitoring cases associated with the customer.
AE	total_closed_monitoring_case	The number of closed monitoring cases associated with the customer.
AF	total_open_payment_screening_cases	The number of open payment screening cases associated with the customer.
AG	total_closed_payment_screening_cases	The number of closed payment screening cases associated with the customer.
AH	account_identifier	Your ComplyAdvantage account ID. This will be the same for all the rows of the export.
AI	acquisition_source	The source through which the customer was acquired

Screening and monitoring cases

The Screening and Monitoring Cases export contains the creation date, type and decision for each case. It also shows who worked on the case, the total time taken to remediate the case and the screening configuration applied.

There are customer details, so that the exported data can be paired with your data for analysis.

Each row in the export represents a combination of a case and an alert within the case. If a case contains multiple alerts, then the case will be shown multiple times in the export, once for each alert.

These are the fields in the export:

Column	Field name	Description
A	case_id	The unique ID for a case.
B	case_type	The type of the case (onboarding or monitoring).
C	case_stage_name	The latest status of the case. You can customize the statuses but the defaults are: Not started In Progress Escalated On Hold No risk - Accept Manageable risk - Accept Unacceptable risk - Reject
D	created_at	The date and time the case was created.
E	updated_at	The date and time the case was last updated.
F	assignee_id	The unique ID of a ComplyAdvantage Mesh user assigned to a case.
G	external_customer_id	Your unique ID for the customer. This ID is generated by you and is your reference for the customer.
H	customer_type	The type of customer (person or company).
I	customer_labels	The labels associated with this customer.
J	customer_acquisition_source	The acquisition source of the customer.
K	customer_version	The customer version.
L	customer_risk_level	The overall risk level of a customer (low, medium, high, prohibited or unspecified).
M	person_first_name	The first name of the customer if the type is person.
N	person_middle_name	The middle name of the customer if the type is person.
O	person_last_name	The last name of the customer if the type is person.
P	person_full_name	The full name of the customer if the type is a person, and if their name information was provided as a single field.
Q	person_country_of_birth	The country of birth of the customer if the type is a person.
R	person_nationality_list	The nationality of the customer if the type is a person.
S	person_country_of_residence_list	The country of residence of the customer if the type is a person.
T	person_address_country_list	List of countries in customer addresses, if the customer type is a person.
U	person_date_of_birth	The date of birth of the customer if the type is a person.
V	company_legal_name	The legal name of the customer if the type is a company.
W	company_place_of_registration	The place of registration of the customer if the type is a company.
X	company_incorporation_date	The incorporation date of the customer if the type is a company.
Y	company_address_country_list	List of countries in customer addresses, if the customer type is a company.
Z	undefined_name	The name of the customer for a customer where the customer type was not provided and hence is categorised as 'undefined'.
AA	undefined_country_list	Countries associated with a customer where the type is 'undefined'.
AB	undefined_birth_year	Year of birth of a customer where the type is 'undefined'.
AC	screening_id	The unique ID of the screening that triggered a case.
AD	screening_type	The origin of the screening (onboarding or monitoring).
AE	screening_configuration_id	The ID of the screening configuration used to screen or monitor the customer.
AF	screening_configuration_name	The name of the screening configuration used to screen or monitor the customer.
AG	number_of_profiles	The number of profiles returned for a given case.
AH	Sanctions	The number of profile hits for Sanctions.
AI	Warnings	The number of profile hits for Warnings.
AJ	Fitness and probity	The number of profile hits for Fitness and probity.
AK	PEP	The number of profile hits for politically exposed persons (PEPs).
AL	PEP Class 1	The number of profile hits for PEP Class 1.
AM	PEP Class 2	The number of profile hits for PEP Class 2.
AN	PEP Class 3	The number of profile hits for PEP Class 3.
AO	PEP Class 4	The number of profile hits for PEP Class 4.
AP	Adverse Media	The number of profile hits for Adverse Media.
AQ	assignee_name	The name of the case assignee.
AR	time_to_remediate	Time taken to remediate the case, calculated from case creation, until (the final) case decision.
AS	Sanctions risk	The number of profile hits for Sanctions (v3 data).
AT	Political exposure risk	The number of profile hits for Sanctions (v3 data).
AU	Terrorist financing risk	The number of profile hits for Terrorist financing (v3 data).
AV	Proliferation financing risk	The number of profile hits for Proliferation financing (v3 data).
AW	Money laundering risk	The number of profile hits for Money laundering (v3 data).
AX	Regulatory & Reputational risk	The number of profile hits for Regulatory & Reputational risk (v3 data).
AY	Fraud risk	The number of profile hits for Fraud (v3 data).
AZ	account_identifier	Your ComplyAdvantage account ID. This will be the same for all the rows of the export.

Profiles

When a customer is screened against the ComplyAdvantage database and there are matches, the screening results are returned as individual profiles. A profile is a collection of information about a person or company.

The screening and monitoring cases exports give you the total number of profiles broken down by anti-money laundering (AML) types within a case. The profiles export lists all the profiles that were created and can be used to identify which sources are producing a lot of results, and how many of those are true positives.

Each profile is linked to the screening that generated the hit and the associated customer. This enables data to be paired for analysis of the true positive (TP) and false positive (FP) decision ratios, as well as the type and level of risk found during initial customer screening.

Each row in the export represents one profile.

These are the fields in the export:

Column	Field Name	Description
A	profile_id	The unique identifier for each profile generated by ComplyAdvantage.
	risk_id	The unique identifier for each risk generated by ComplyAdvantage.
B	screening_id	The unique ID of the screening that returned a hit.
C	internal_customer_id	The unique customer ID generated by ComplyAdvantage.
D	external_customer_id	Your unique ID for the customer. This ID is generated by you and is your reference for the customer.
	person_full_name	The full name of the customer who the profile is matched with, if the customer type is a person.
	company_legal_name	The legal name of the customer who the profile is matched with, if the customer type is a company.
	undefined_name	The name of the customer who the profile is matched with, if the customer type is undefined.
E	created_at	The date and time when the initial screening took place.
F	updated_at	The date and time when the profile status was last updated.
	profile_last_updated_by_id	The unique ID of the user who last updated the profile.
	profile_last_updated_by_user	The name of the user who last updated the profile.
	profile_change_type	The type of the latest profile change.
G	profile_status	The latest status of a profile. The statuses are: Not Reviewed In Review True Positive False Positive
H	aml_category_list	The list of anti-money-laundering (AML) categories associated with a profile. The categories are: Sanctions Warnings Fitness and probity Politically exposed persons (PEPs) Adverse media
I	aml_source_list	The list of sources associated with the corresponding AML category for a given profile (for example: OFAC).
	risk_type_list	The list of risk types associated with the profile.
J	account_identifier	Your ComplyAdvantage account ID. This will be the same for all the rows of the export.
	screening_type	The type of Screening: Screening or Monitoring.
	screening_configuration_id	The unique ID of the screening configuration used.
	screening_configuration_name	The name of the screening configuration used.
	is_muted	A boolean value indicating whether the profile was muted at the time of screening: TRUE or FALSE.
	has_alerted	A boolean value indicating whether the profile has alerted in this screening: TRUE or FALSE.

For more details on creating exports, see: