An Import Data Source allows you to import leads via a .csv file (unformatted spreadsheet). You may do this to transfer leads from an old CRM or import leads purchased from a lead vendor.
This article includes the following topics:
- Setting up an Import Data Source
- Configuring the .csv file
- Selecting Additional Options
- Uploading the .csv file and mapping the fields
Setting up an Import Data Source
- From the Contacts tab, click Data Source.
- Do the following in the Name / Field Assignment section (click to enlarge):
* Required ** Recommended
- *Source Name - Enter a name for the data source. We suggest naming the data source after the marketing company or use the web URL for the website the leads will be importing from.
- *Type - Select Import to accept the import file. We will review this in the next step. Web Form Data Sources are discussed here.
- *File Type - Select the type of program from the File Type menu you wish the contact to be created as.
- **Stage and Status - Select the workflow stage and status you want the contact to be placed into on creation.
- Campaign - Select an option from the Campaign menu the leads should be assigned to.
- **De-Dupe Field - The de-duplication feature is used to identify OR prevent duplicate leads from being created. Select the field you wish to check for duplicates by. We recommend "Email" address as "Phone" could be a shared number and possibly still separate leads from the same household. You would use "My ID" in cases where you are purchasing leads from a lead vendor and you want to be sure they are not importing duplicate leads to your account.
- De-Dupe Action - What do you want to happen to the duplicate?
- Reject means the lead will be rejected and no contact will be created. There will be no record of this contact attempting to be imported.
- Flag as Dupe allows the system to still create the contact but will flag it as a possible duplicate. You will find a link on the Client Dashboard to view and compare the possible duplicate and decide if you wish to merge or leave them separate.
- De-Dupe Status - In the case you are flagging duplicates, you can also have the new possible duplicate contacts placed in a separate workflow status so they can be sorted thru later.
DO NOT SAVE YET! Saving the Data Source prior to uploading the .csv file will prevent the system from being capable of reading the file, and you'll need to start over by creating a new Data Source.
Configuring the .csv file
It is VERY important the CSV file is setup correctly.
- To start with is should be the file type "CSV (Comma Delimited)" any spreadsheet software should be able to Save (or Save As) the file in this format. If not in this format the data source will not work. Lets start by looking at an example .csv file.
In the example below we can see a few things needed for the data source to properly import the file. Particularly you want to pay attention to the Header Row.
- The first row of the spread sheet should always be a Header Row. If you plan to use the data source to import several files of leads you want to make sure the Header Row is the same every time. The system will be looking for this row in order to properly map the fields later on.
- Special fields that contain functions and characters such as ($,&,/,?, etc...) can cause the file to not import properly.
- It is recommended using only lowercase letters with no spaces as this reduces the possibilities of problems during import.
- Avoid using any duplicate headers. If the file contains 2 "phone" headers you will want to change the duplicate to "phone2" or maybe change them to "homephone" and "cellphone".
- View the .csv file in excel or other similar software you are still having issues importing the .csv file (preferably in a Notepad editor). This may reveal some issue not easily visible in Excel. For example in the item pictured below the you may notice there is a 'space' in front of the "phone" column header. This is something that will cause the import to fail and you may have not noticed it when viewing the file in Excel.
- Do either of the following:
- Click Save Data Source; or
- Go to Selecting Additional Options.
Selecting Additional Options
The following options are not required for the data source to function but can be used to apply additional automation when creating contacts.
The assignment options allow you to assign leads on creation to users and companies. This will allow leads to be worked as soon as they are received into the CRM.
- Assigning On - Check the box to activate the further assignment options you will set in this section.
- Public - Checking this box will make all the leads created thru this data source "Public". Public leads are viewable within the entire company and do not follow the other sharing options that may limit what contact users are able to see. The contact can be made "Private" again later from the edit contact page (Client Dashboard).
- Company - Select the company you wish to assign the lead to. This will affect what user are displayed in the next option; Assigned To.
- Assigned To - Select the user you want leads to be assigned to. You can select multiple users by holding down 'CTRL' while clicking on the users. If multiple user are selected the leads will be distributed evenly.
- Additional Company Assignment - You can add secondary company assignments by company type. To set a company's type. go to the Admin Tab > Companies > Select the company to edit and change the option set for "Company Type".
- Role Assignment - Assigned users secondarily by role. In order for the user role to be available you will need to make it assignable. See our article on Role Assignments here for more information.
- Team Assignment - Select the team(s) (data source) you want the leads to be assigned to.
- Notification - Select an email template to be sent to the assigned to rep on creation. The email template must have the Category set as "Notification" to appear in this menu.
The send notification section can be used to send email messages notifying parties when a contact is created. First select the template. Then select users you wish to receive notifications. You can also add other email addresses in the "More People" box if you wish to notify someone who may not be a user within the CRM. You could use this to send a confirmation email to lead vendors to confirm you have received a lead they've provided.
Creating an Auto-Responder
The Auto-Responder can be used to send a message to the newly created contacts upon file import.
Although this feature is available for Import Data Sources, you would really only set up an Auto-Responder on a Web Form Data Source to let a client know that their form submission has been received. Enabling the Auto-Responder on an Import Data Source will immediately email all contacts on the Import file.
- Select the On checkbox to activate the feature, and then an option from the E-Category menu.
This is the email template type that has been applied to a template form the E-Marketing tab.
- Select a campaign from the Template menu.
- Select a sender you wish the message to come from the Sender menu.
Webhooks can be setup to immediately post lead information out of the system upon creation. You may do this as part of the Data Source in order to post leads into a phone dialer campaign so that new leads can be contact as soon as possible. For more information on setting up WebHooks please visit our article here.
DO NOT SAVE YET! Saving the Data Source prior to uploading the CSV file will prevent the system from being capable of reading the file, and you'll need to start over by creating a new Data Source.
Uploading the .csv file and mapping the fields
The next step is to upload the CSV file and map the data fields.
- In the Import New Contacts from CSV section, click the Browse button and select the .csv file from your local drive.
- Leave the remaining items as is. if the CSV file has been setup correctly you should not need to change the other options here.
- Click Save Data Source.
- After saving the data source, the Import New Contacts from CSV section will be replaced with the Import Another File and Import Fields sections.
DON'T CLICK "Start Merge" yet! Merging before the fields have been mapped will cause all contacts to be uploaded with no data and you'll be left with blank contacts.
Mapping the Fields
- Now you will want to select the fields from within the CRM you wish to map the column headers from the csv file to. In the example below we are mapping "fname" to "First Name", "lname" to "Last Name", "phone" to "Home Phone" and "email" to "Email".
The drop down menu starts with Standard (system) fields, if you continue to scroll you will find your CRM's Custom Fields and other additional options. The ability to add the data as a note on the contact is the an option if you do not wish to save the information to a field.
- Now that you have mapped the fields you can click start merge to import the contacts. However you may wish to activate some of the additional options discussed in the next section of the article before doing so. Now that the field mapping is setup you can reuse this data source as long at the CSV file you are trying to upload is setup the same. Trying to upload a file containing a CSV file in a different format will not work. If you are working with a lead vendor it is of both your best interest to agree on a format for the file to be submitted in so that you do not have to repeat this process every time you wish to upload a file of leads from them.
- Click Starts Merge. The contacts will be created and a push notification will appear in the bottom right confirming the process has started. Depending on the number of contacts and fields included the CSV file you are attempting to upload the process will take varying amounts of time. You should see the contact filter into the All Contacts list or a list setup to display leads coming in from the Data Source.
- Once finished you will see a push notification appear in the bottom right confirming the process has been completed.
It is not possible to map Co-applicant fields. This is because the system cannot create the Primary contact and Co-applicant contact at the same time. If you have Co-applicant data that you would like to import, you may instead use Custom Fields.