Application reports

Use reports to analyse your compliance processes.

To see the Reports tab and access the applications reports, you must have Read-only access or Read and write access for the All reports permission. To change your permissions, contact the administrator of your account.

What are the application reports?

These are the reports for applications:

  • Conversion rate
  • Time to decision
  • Straight through processing (STP)

To view a report, go to the Reports tab, click Applications, and select the report you want to see.

By default, all reports show data for profiles who are prospects and/or customers. To view the data for company associates, change the options for the Profile type filter criterion.

Conversion rate

The Conversion rate report shows the percentage of applications that have been approved each week.

There are three metrics:

  • Created: The number of applications created that week.
  • Approved: The number of applications created that week that have been approved since then.
  • % Approval rate: The percentage of applications created that week that have been approved since then.

In the example above, 10 applications were created the week of September 23. Of those 10 applications, 3 have been approved since, which makes the approval rate 30%. They may have been approved at any time.

Time to decision

The Time to decision report shows the amount of time it took for a percentile of applications to be decided (approved or rejected) each week.

There are three metrics:

  • 50th percentile: The amount of time it took for 50% of the applications approved/rejected that week to be decided.
  • 80th percentile: The amount of time it took for 80% of the applications approved/rejected that week to be decided.
  • 95th percentile: The amount of time it took for 95% of the applications approved/rejected that week to be decided.

In the example above, 50% of the applications approved/reject the week of July 22 were decided in 21 hours or less. 80% of applications approved/rejected that week were decided in 2 days or less. 95% of applications approved/rejected that week were decided in 3 days or less.

This report shows the time to the first application decision. For example, if an application was initially approved, then later rejected, the Time to decision report only shows the amount of time before the application was approved.
If the Time to decision report shows 0 seconds, there is no data for that plot point. For example, if the 50th percentile of applications in a given week were decided in 0 seconds, there were likely no applications decided that week.

Straight through processing (STP)

The Straight through processing (STP) report shows the percentage of applications decided that week that did not have any manual intervention during the date range. Learn more about how STP is determined.

There are three metrics:

  • Decided (all): The number of applications decided that week, including those decided with STP and those decided with manual intervention.
  • Decided with STP: The number of applications decided that week that did not have any manual intervention.
  • % decided with STP: The percentage of applications decided that week that did not have any manual intervention.

In the example above, 10 applications were decided the week of November 18. Of those 10 applications, 3 were decided with STP, which means that 30% of all applications decided that week were decided with STP.

This data shows the time to the first application decision. For example, if an application was initially approved, then later rejected, the STP report only shows the amount of time before the application was approved.
How is STP determined?

An application is decided with STP when it goes from created to approved or rejected automatically, with no manual intervention.

If any of the following actions take place between the time the application was created and first decided, the application was not decided with STP:

  • Update the application manually (e.g. a user runs a check).
  • Update the profile manually (e.g. a user adds profile data), even if that data does not affect the outcome of the application.
  • Update a company associate manually (e.g. a user runs a check on the associate or adds data to the associate's profile).
  • Update a different application the profile has open at the same time manually (e.g. a user runs a check on that application or updates a company associate who's being verified for that application).

The following actions do not affect whether the application was decided with STP:

  • Create the profile.
  • View the profile.
  • Add/delete a task note.
  • Add/remove a tag.
  • Add a comment to the application.
  • Download an audit file.
  • Download an audit report.

Reading reports

When you open a report, a graph and a table are displayed. They show different views of the same data.

The dates on the timeline of the graph show the first Monday of each week, aside from the exceptions described in About the data where data begins or ends midweek.

About the data

There are a few important things to note about the data:

  1. Most data is only available from 1 September 2018 onward. Data for Risk level (at first decision) is only available from 19 September 2019 onward. Data for Straight through processing (STP) is only available from 24 July 2019 onward.
  2. The data for your account is refreshed every day from 2:00 AM - 4:00 AM UTC. Reports can still be used during this time. If the date range for the report includes today, you may see some data for the previous day (e.g. new applications may have been created or application statuses may have changed since the data has refreshed).
  3. The graph and table start with the first week in the date range that has data and end with the last week in the date range that has data. For example, if you're looking at the Time to decision report and you select a date range that starts with the first week of January and ends with the last week of December but applications were only decided between April 1st and April 30th, the timeline for the graph starts with 1 Apr and ends with 30 Apr.

Changing the plot lines on the graph

To change which lines are plotted on the graph, click the Plot on graph drop-down and select your option.

The plot lines that are available depend on the report.

Changing the plot lines on the graph does not affect the data in the table.

Select a date range

By default, all the available data for the last 12 weeks is displayed.

To change the time range:

  1. Click the Select date range drop-down.
  2. Select a new start date from the Select start date calendar. To change months, use the arrows next to the month in the calendar.
  3. Select a new end date from the Select end date calendar.
  4. Click Apply date range.

The data for your date range is displayed.

The graph and table start with the first week in the date range that has data and end with the last week in the date range that has data. Learn more.

If no applications were created in the given time range, the graph displays a message to say there are no results.

Report data refreshes every day, so if your date range includes today, you may see some data for the previous day. Learn when your data refreshes.
Days are determined by Coordinated Universal Time (UTC).

Filter report data

To view only applications that meet specific criteria, filter your data.

Apply a filter

To apply a filter to your data, click the drop-down for one of the criteria under Filter Report Data and select the option(s) you want to apply.

As you select option(s), the data is filtered automatically.

Follow the same steps to add as many filter criteria as you like.

Filter criteria with many options have a search tool in the drop-down so it's easy to find what you're looking for.
Remove a filter

To remove all options for a filter criterion, click the drop-down for the criterion and select the first option. This option has the name of the filter criterion (e.g. "Country of nationality").

When you click the option, all filtering for that criterion is removed from the data.

You can also remove all options for a filter criterion except one. To do this, click the drop-down for the filter criterion, hover over the option you want to keep, and click Only.

When you click Only, all other filtering options for that criterion are removed from the data.

Data you can filter

You can choose from any of the criteria below and only the data from applications that meet your criteria are displayed:

  • Application status (current): The status of the application. Possible statuses are: Applied (meaning that the application has not yet been approved or rejected for the first time), Approved, Cancelled, In Review, and Rejected.
  • Application status (at first decision): Whether an application was initially approved or rejected. Note that the decision may have changed since (e.g. the first application decision was Approved but the current state of the application is Cancelled). To see applications that haven't been approved or rejected yet (i.e. they're in the Applied state), select No data.
  • Product: The product the application is for.
  • Profile type: The type of profile. The options for this filter are: INDIVIDUAL_CUSTOMER (individuals applying for your product), COMPANY_CUSTOMER (companies applying for your product), INDIVIDUAL_ASSOCIATED (company associates who are individuals), COMPANY_ASSOCIATED (company associates who are companies).
  • Country of incorporation: The profile's country of incorporation. To see applications from profiles with no country of incorporation (i.e. all individual profiles, plus any company profiles that have no data for this field), select No data.
  • Country of current address: The profile's country of address. To see applications from profiles with no country of address (i.e. all company profiles, plus any individual profiles that have no data for this field), select No data.
  • Country of nationality: The profile's country of nationality. To see applications from profiles with no country of nationality (i.e. all company profiles, plus any individual profiles that have no data for this field), select No data.
  • Risk level (current): The current risk level of the application. To see applications that do not have a risk level (e.g. a risk level won't be assigned because there's no risk model for that product), select No data. To see applications with a risk level that could not be calculated, select UNDETERMINED. Note that this criterion is only displayed if you're using Risk. Equally, the UNDETERMINED option is only available if at least one application has a risk level that could not be calculated.
  • Risk level (at first decision): The risk level of the application when it was initially approved or rejected. Note that the risk level may have changed since then (e.g. an application might have been initially evaluated low risk, but a sanctions match could be later discovered and cause the risk level to be re-evaluated as high risk). To see applications with a risk level that could not be determined, select UNDETERMINED. Note that this criterion is only displayed if you're using Risk. Equally, the UNDETERMINED option is only available if at least one application's risk level could not be calculated.
  • Associate role: The company associate's role (e.g. beneficial owner, director, etc). Note that applications for associates are created once per role, so if an associate has multiple roles at the same company, they'll have multiple applications. To see profiles that are not company associates, select No data.

Group report data

To see a segment of your data in detail and compare it, use the Group by feature.

For example, you can group by Product to compare how applications for two of your products are performing.

Apply a group

To apply a group, click the Group by drop-down and select any option (e.g. Product).

The table and the graph are updated with your selection.

This is still the same data selection you were viewing before. Any filter criteria are still applied to your data, and the time range stays the same.
How the table changes

The first column of the table displays your group selection as the first column. For example, if you select Products, the first column of the table displays the names of your products.

The other columns show the same metrics as before, but specific to each row in the table.

In the example above, the Time to decision report is grouped by Product. During the date range, 50% of the applications made for a Forexo Basic Account were decided in 3 minutes and 1 second. By contrast, 50% of the application made for a Forexo Pro Account were decided in 46 minutes and 47 seconds.

How the graph changes

The graph is re-plotted with one plot line for each element of your group.

In the example above, the Time to decision report is grouped by Product. The plot lines on the graph are:

  • Forexo Pro Account - 50th percentile: The time it took for 50% of the Forexo Pro Account product applications approved/rejected that week to be decided.
  • Forexo Pro Account - 80th percentile: The time it took for 80% of the Forexo Pro Account product applications approved/rejected that week to be decided.
  • Forexo Pro Account - 95th percentile: The time it took for 95% of the Forexo Pro Account product applications approved/rejected that week to be decided.
  • Forexo Basic Account - 50th percentile: The time it took for 50% of the Forexo Basic Account product applications approved/rejected that week to be decided.
  • Forexo Basic Account - 80th percentile: The time it took for 80% of the Forexo Basic Account product applications approved/rejected that week to be decided.
  • Forexo Basic Account - 95th percentile: The time it took for 95% of the Forexo Basic Account product applications approved/rejected that week to be decided.
The graph always starts with the first week in the given date range that has data and ends with the last week in the given date range that has data. Learn more.
To keep the graph readable: 1) If you are viewing all plot lines and your selection has more than 3 groups, the first 3 rows in the table are plotted; 2) If you selected a single plot line using the Plot on graph option, the first 10 rows of the table are plotted.
To plot specific groups, select them from the filter criteria. For example, if you grouped your data by Product and you have more than three products, the first three products in the table are plotted. If you're interested in comparing two products, select those products from the Product filter and they'll be plotted on the graph.

No results

If you see a message that says No results, there's no application data that matches your date range and filter criteria.

Try using a different date range or changing your filter criteria.

Report data refreshes every day, so if your date range includes today, you may see some data for the previous day. Learn when your data refreshes.

Saving and sharing reports

You can copy the URL, and save it or share it.

Anyone who has Read-only or Read and write access for the All reports permission will see that report when they follow the link.

If you select a date range and/or apply filter criteria or groups before copying the URL, your options are applied when the URL is followed.

Exporting report data

You can download a copy of the raw report data (with the date range and any filter criteria applied) as a CSV file.

The raw data contains more information than is displayed in the graph and table (e.g. PEPs, sanctions, and adverse media matches).

Export filtered data

To export the data:

  1. Click Export filtered data (.CSV). A dialog is displayed with all the data you can export.

    The data is grouped into the following categories: Standard profile data and Custom fields. To get a description of the data, see Data you can export.
  2. Select the data you would like to export. To see data from a different category, click the name of the category. You can also use the search tool at the top of the dialog to search for specific data.
  3. Click Export .CSV.

A ZIP file is downloaded. It contains a CSV file of the raw data you selected. Each row in the file corresponds to one application created during the report's date range.

You can open the file in Excel or any other CSV-compatible application.

To download the data, you need Read-only access for the Export data permission.
CSV files can only be generated for reports with tables that are 300,000 rows or less. You can reduce the number of rows in your report table by changing the date range or applying filters.
The CSV file uses UTF-8 encoding, so it displays correctly in almost all environments.

Data you can export

You can export the following data.

Standard profile data:

  • Application date: The date and time the application was created. Note that the date and time are determined using UTC.
  • Application ID: The application's ID in PassFort.
  • Application first decision date: The date and time that the application was initially approved or rejected. If the application hasn't been approved or rejected yet, this is blank. Note that the date and time are determined using UTC.
  • Application first decision week: The week (starting on Monday) that the application was initially approved or rejected. If the application hasn't been approved or rejected yet, this is blank.
  • Application status (current): The status of the application at the time the data was exported. This data corresponds to the Application status (current) filter.
  • Application status (at first decision): Indicates whether the application was initially approved or rejected. If the application hasn't been approved or rejected yet, this is blank. Note that this may be different from Application status (current). This data corresponds to the Application status (at first decision) filter.
  • Application week: The week (starting on Monday) that the application was created.
  • Associate role: If the profile is a company associate, this column displays the associate's role. If the profile is a customer or prospect, this is blank. This data corresponds to the Associate role filter.
  • Company number: The company's registration number.
  • Country of current address: If the profile is an individual, this is the country of residence. If the profile does not have a country of residence or the profile is a company, this is blank. Note that the country is provided as an ISO3 code. This data corresponds to the Country of current address filter.
  • Country of incorporation: If the profile is a company, this is the country in which the company is incorporated. If the profile does not have a country of incorporation or the profile is an individual, this is blank. Note that the country is provided as an ISO3 code. This data corresponds to the Country of incorporation filter.
  • Country of nationality: If the profile is an individual, this is the country of nationality. If the profile does not have a country of nationality or the profile is a company, this is blank. Note that the country is provided as an ISO3 code. This data corresponds to the Country of nationality filter.
  • Customer reference: An optional profile field that can be used to add a unique identifier for the profile (e.g. the unique identifier from your CRM).
  • Date of birth: If the profile is an individual, this is the date they were born. If the profile does not have a date or birth or the profile is a company, this field is blank.
  • Date of incorporation: If the profile is a company, this is the date it was incorporated. If the profile does not have a date of incorporation or if the profile is an individual, this field is blank.
  • Display name: The name of the profile or associate profile.
  • Product: The product that the application is for. This data corresponds to the Product filter.
  • Profile creation date: The date the profile was created. Note that the date and time are determined using UTC.
  • Profile ID: The profile's ID in PassFort.
  • Profile type: Indicates whether the profile is an individual or a company and whether the profile is an associate or not. This data corresponds to the Profile type filter.
  • Risk level (at first decision): Indicates the risk level when the application was first approved or rejected. This data corresponds to the Risk level (at first decision) filter. Note that this column is only displayed if you're using Risk.
  • Risk level (current): The application's risk level at the time the data was exported. This data corresponds to the Risk level (current) filter. Note that this column is only displayed if you're using Risk.
  • Screening events: Adverse media count (confirmed): The number adverse media matches for the profile have been confirmed.
  • Screening events: Adverse media count (ignored): The number of adverse media matches for the profile have been ignored.
  • Screening events: Adverse media count (potential): The number of adverse media matches for the profile haven't yet been confirmed or ignored.
  • Screening events: PEP count (confirmed): The number of PEPs matches for the profile that have been confirmed.
  • Screening events: PEP count (ignored): The number of PEPs matches for the profile that have been ignored.
  • Screening events: PEP count (potential): The number of PEPs matches for the profile that haven't yet been confirmed or ignored.
  • Screening events: Referral count (confirmed): The number of risk matches for the profile that don't fit into the PEPs, sanctions, or adverse media categories (e.g. a criminal record) that have been confirmed.
  • Screening events: Referral count (ignored): The number of risk matches for the profile that don't fit into the PEPs, sanctions, or adverse media categories (e.g. a criminal record) that have been ignored.
  • Screening events: Referral count (potential): The number of risk matches for the profile that don't fit into the PEPs, sanctions, or adverse media categories (e.g. a criminal record) that haven't yet been confirmed or ignored.
  • Screening events: Sanctions count (confirmed): The number of sanctions matches for the profile that have been confirmed.
  • Screening events: Sanctions count (ignored): The number of sanctions matches for the profile that have been ignored.
  • Screening events: Sanctions count (potential): The number of sanctions matches for the profile that haven't yet been confirmed or ignored.
  • Ultimate parent display name: If the profile is an associate, this is the name of the product application that their application is contributing to. If the profile is not an associate, this is blank.
  • Ultimate parent profile ID: If the profile is an associate, this is the ID number of the profile that made the original product application. If the profile is not an associate, this is blank.

Custom fields:

This category contains any custom fields you have.

If a profile is initially created via the API as an INDIVIDUAL_CUSTOMER or COMPANY_CUSTOMER and then manually linked to another profile as an associate, it will retain its INDIVIDUAL_CUSTOMER or COMPANY_CUSTOMER profile type.
In some cases, an associate profile may have more than one parent. If an individual or company is an associate of multiple companies, by default one application is created for every role the individual or company has. However, it's possible for users to merge the profiles into a single profile as part of the resolve possible duplicates feature. When this happens, there will be one profile with a parent for every company that it's an associate of.
To learn more about screening events, see the PEPs and sanctions screening (individuals) and the Sanctions and adverse media screening (companies).


How did we do?


Powered by HelpDocs