Follow

LeadManager: How To: Import Leads From A Spreadsheet    

 

TOPICS COVERED IN THIS ARTICLE:

  • How to import leads from a spreadsheet

 

 

ENVIRONMENT:

  • LeadManager – Standard 
  • Microsoft Excel

 

 

 

STEP BY STEP INSTRUCTIONS:

 

 

 

 

First, access the Menu page by clicking on your name in the upper right of the header.

 

 

 Under Lead Management click on Import Leads

 

 

 

 

The Import Leads page will load

 

 import_lead_from_spreadsheet2.jpg

 

 

Click the Download Import Template link

 

 import_lead_from_spreadsheet3.jpg 

 

 

Click Save File button and then OK save the template on your computer

 

 import_lead_from_spreadsheet4.jpg

 

 

Next open the import template and a the Excel spreadsheet with the leads to be imported.

 

Depending on the industry, the import template spreadsheet will be named something like: BPT Mortgage2.2.ImportTemplate.xls. 

 

  • This spreadsheet does not contain any lead information.

 

  • This spreadsheet documents the exact order of the columns required for all lead imports.

 

  • Do not change the order of the columns.

  

Example Import Template 

import_lead_from_spreadsheet5.jpg

 

 

The spreadsheet that contains the existing leads to be imported.       

 

For this example it is called: My-Existing-Leads-Spreadsheet.xlsx.

 

 import_lead_from_spreadsheet6.jpg

 

 

Copy the lead data from the list of leads to be imported to the import template without changing the order of the columns. 

 

This step will likely  require manipulation of the lead data to match the order of the columns in the import template.

 

Example

 

 

 

When this is done, the BPT Mortgage2.2.ImportTemplate.xls should look like this:

 

import_lead_from_spreadsheet7.jpg 

 

  • Note that there is an upload limit of 1000 leads.

 

  • To upload more, break the list into batches of 999 rows plus column header.  

 

When you have added all of your lead data to the spreadsheet, save and close it.

 

  • In this example, it will be saved as My-Existing-Leads-Ready-To-Import.xls

 

Now go back to the Import Leads page in LeadManager and click the Browsebutton on the line that reads File to Upload.

 

 import_lead_from_spreadsheet8.jpg

 

When the explorer window opens, select the file and click Open.

 

 import_lead_from_spreadsheet9.jpg

 

After clicking the open button, you will be back on the Import Leads page and you will see your leads spreadsheet is ready to be imported.

 

 import_lead_from_spreadsheet10.jpg

 

 

Select the CampaignStatus and User to whom the leads should be associated with when they enter the system.

 

In the example, when leads are imported they will be: associated with the Self Generated campaign - in the New status - all assigned to the user named Richard Greene.

 

import_lead_from_spreadsheet11.jpg

 

If you would like the leads to be distributed by automatic distribution, import the leads set the Status and User dropdowns to New and --Select User-- respectively.

 

Click the Simulate button to test that there are no errors in the lead data, and click the Import

  

 import_lead_from_spreadsheet12.jpg

 

  • If you encounter errors when simulating the import, make sure that all of your lead data has been copied into the columns in the import template correctly, and make sure that the order of the columns has not been changed.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk