Overview

List Analyzer allows you analyze a list of potential Leads that have not yet been created in Salesforce and determine if there are any matches to other Leads, Contacts, or Accounts that currently exist in your Salesforce instance.

Please Note: List Analyzer will use the default out-of-the-box Tiebreakers to determine the best matches.

Best Practice: While we do not have a hard limit on the size of your file to be analyzed we do have recommendations. For total file size we recommend a file under 70,000 rows of data. Also the size of the data in each field can be a factor. We factor in both the number of columns and column character count. With an average of 30 characters per column you can have a max of 42 columns.

Analyze Leads

In order to access the List Analyzer section, you must go to the LeanData app. Click the Matching section, List Analyzer, and then click the Analyze Leads section.

Analyzer Wizard

Once inside the List Analyzer, click on the Analyze New List button. This will open the Analyzer Wizard page which will help guide you through the set-up.

Choose the CSV file you want to send through the List Analyzer. The CSV file must include a header row at the top.

*Note LeanData will NOT upload these leads into Salesforce.

Click Next after uploading the file successfully.

Map Lead Fields

You will need to map the .CSV file headers with the corresponding Salesforce Lead Fields. The Last Name field and Company field are required. Leave the value as "None" if the remaining fields do not contain the relevant Field Mappings. Click Next after mapping your fields.

The confirmation page will include a summary before starting to analyze the Leads.

Name of the CSV file that you have uploaded.
Indicates the number of Leads present on the file to be analyzed.
Shows the list of Mapped Fields selected in Step 2.
Notify on completion is checked by default. You can disable the notification if you chose.
After reviewing the information, click ‘Analyze’.

The List Analyzer will begin to process the Leads. Click OK at the bottom of the screen to finish the Analyzer Wizard.

Once the List Analyzer job has completed, a results file will generate providing you with an insight into the analyzed Leads. Under the Status Column you can download the analyzed list to review the information in greater detail.

Matched Object Fields

This section allows you to select Matched Object Fields that will be viewable in the results download. Under the Matching section of the LeanData Dashboard, Select List Analyzer, then Matched Object Fields.

On the Matched Object Fields page you can select the object and its fields to include in the List Analyzer output final. You can include fields from the following objects:

Duplicate Contact
Duplicate Lead
Matched Account
Related Lead

Select the Object(s) you wish to include fields from, on the Matched Object menu. Then select the field(s) you want to include in the output file. Use the arrow buttons to move the fields from Available Fields column to the Selected Fields column. In the Selected Fields column, the fields are separated by object type. Save your changes.

When viewing the .CSV the results will include columns that reference the Fields you selected.

Please Note: By default, the output .CSV file includes the Salesforce Record ID field for the owner of Duplicate Leads, Duplicate Contacts, Related Leads, and Matched Accounts. To see the names of the owners of these records, you can include the owner.name field in your Matched Object Fields.