How To Import Leads (Advanced)

In this tutorial, we’re going to outline how you can import leads into your my.hy.ly database. This will allow you to send emails to specific lead groups and residents.

For this tutorial, you’ll need a spreadsheet saved as a CSV file, with all of your prospects and residents. The spreadsheet should have five columns: First Name, Last Name, Email, Prospect Status, and Resident Status.

import-leads-1

Options for the Prospect Status can be Active, Dead, Leased, or Non-Applicable (N/A), and Resident Status options can be Current, Future, Past, or Non-Applicable (N/A). Each row represents a prospect or resident.

import-leads-2

If you’re working in Google Spreadsheets, like in the example above, click on “File,” go to “Download As,” and then select “Comma-separated values (.csv, current sheet)” to export your spreadsheet as a CSV file.

import-leads-3

Now that you have a CSV file, log in to your my.hy.ly account and click on your Leads app.

import-leads-4

Once you’re on the main page of Leads, click on its App Menu and select “Import / Export.” This is where you’ll be importing your leads.

import-leads-5

Click on the Upload CSV File link on the navigation bar. Once you’re on the page, click the “Select File” button under the section, Step 1: Upload CSV. Find your CSV file, and select it to be uploaded onto your my.hy.ly database.

import-leads-6

Once the file has been selected, a pop-up dialogue box will appear. This is to help you verify the rows and columns in your spreadsheet. The rows indicate the number of leads you have, plus one for the field labels. In our example’s case, the file contains the five fields that we mentioned before: First Name, Last Name, Email, Prospect Status, and Resident Status.

import-leads-7

If everything matches up with your imported spreadsheet, click the “Looks good” button. If you notice any errors, click the “Let me restart” button and make the necessary corrections.

import-leads-8

Before the spreadsheet is fully imported, we have to match our leads data under the section, Step 2: Map Fields. This way, the fields in our spreadsheet will be imported into the fields in the database.

import-leads-9

If your spreadsheet has column names in its first row, like the example, make sure that the option, “First row contains column names,” is checked.

import-leads-10

Let’s start by mapping out our essential fields first. Make sure that the property name is correct under the Select Property Name dropdown.

import-leads-11

Select “Email” for the Email field, and “Prospect Status” for the Status field. For Status Date, leave it with its default option, which will be the day of the file import.

import-leads-12

Finally under the Essential Fields section, select “Resident Status” for the Resident Status Field, and leave Batch with its default settings.

import-leads-13

Now we’re going to map out the non-essential fields, starting with the lead names. If your spreadsheet only has one field for names, you can leave the Compact View checkbox as is. However, if you have First Name and Last Name fields, make sure to unselect the Compact View checkbox. Map the name information in the necessary dropdown fields.

import-leads-14

Quick Note: For this tutorial, we’re going to leave the rest of the values as “NULL.”

Under Step 3: Load Lead, type in your email address in the field so you’re notified when the database is updated with your list. After that, click the “Load File” button.

import-leads-15

Check your inbox for the confirmation email. Once you receive it, you can click the link at the bottom of this page and see your database full of residents and prospects.

import-leads-16

And that’s it! For this tutorial’s exercise, create a CSV file with fake resident or prospect names and test it out for importing.