Upload historical data for loss prevention
You can upload historical data from transactions, sales, payments, and payment methods into the system, so that the adaptive artificial intelligence (AI) models can look for anomalies. The historical data is processed and used to generate reports that show trends and anomalies. These reports provide actionable insights about any anomalies that the AI models detected.
The historical data must be imported from four entities:
This data is sensitive, and you should upload it only from a secure network location. Be aware that Microsoft requests only partial data about payment instruments (the bank identification number [BIN] and the last four digits). Microsoft doesn't request the full payment instrument number or Social Security number (SSN). Therefore, we recommend that you exclude this type of data from the files that you upload. For more information about how data is used and protected in Microsoft Dynamics 365 Fraud Protection, see Security, compliance, and data subject requests.
You can upload your historical data from the Loss prevention tab of the Data upload page.
To ensure that Fraud Protection can correctly interpret the files that you upload, make sure that they meet the following requirements, and that they follow the required schemas:
- The files are in CSV UTF-8 (comma-delimited) format (*.csv).
- The maximum file size is 10 gigabytes (GB).
- DateTime columns are in International Organization for Standardization (ISO) 8601 format.
- The decimal precision is two decimal places.
- The following characters are escaped in all columns: commas, new line characters, and multiline characters.
To browse and upload data files:
In the left navigation, select Data, and then select Data upload.
On the Data upload page, on the Loss prevention tab, select Select data source.
Select the file format type: CSV or TSV.
If the file has no column headers, select the This file doesn't include column headers option.
The system will automatically assign default column headers.
To begin data mapping, select Next, and then select the columns in your file that you want to map to each schema attribute.
In the data preview pane at the bottom of the page, confirm that the mapping is correct.
When all the attributes are mapped, select Save and close to return to the Data upload page.
Select Process data.
You can save an incomplete mapping and then return to the Loss prevention tab later to complete it.
For related data types, such as purchase and account data, every file must be uploaded before you process the data.
To upload additional data files:
- On the Data upload page, on the Loss prevention tab, select Edit.
- Select Change data source to upload more files.
- To apply the currently saved mapping to the newly uploaded file, select Keep the current mapping.
- After mapping is completed, select Save and close.
- On the Data upload page, select Process data.
Data processing might take up to a few hours, depending on the size of the file. You can check the status of data processing for each data source. If data processing encounters data errors, processing will fail, and the data import will be incomplete. Review the error file details, and fix the data issue that is noted. After you've finished fixing the issues, re-upload the file, remap the attributes if remapping is required, and retry data processing.
To remove previously uploaded data files:
- On the Data upload page, on the Loss prevention tab, select the files to remove, and then select Delete.
During the evaluate and protect experiences, data can also be ingested through the API. A score will be returned for data that you upload in this way. For a more comprehensive overview of this process, see Integrate Dynamics 365 Fraud Protection APIs.
Download sample data
Before you use your internal data, you can download sample data and use it to explore Fraud Protection options.
To download sample data:
- Select Loss prevention sample data file.
Connect to Dynamics 365 Commerce
In addition to uploading local files, you can connect to Dynamics 365 Commerce if this option is available to you. Note that when you connect to Commerce, all required data for Loss Prevention reports will automatically be imported and mapped. For more information, see Loss prevention integration with Dynamics 365 Commerce.