Lead import

Import the users you already know to Dashly and start communicating with them

There are two ways of importing leads to Dashly:

  1. Via the Dashly interface;

  2. Via Rest API.

Before you import your lead database, please make sure you’ve done these two things:

Check your unique visitors quota

Imported leads will be included in the unique visitors quota. Make sure that the import does not exceed the quota. You can see your unique visitors quota in the “Subscription” section.

In case your unique visitors quota is exceeded, a unique visitors overrun payment will be included with your next invoice, you can read about unique visitors overrun on different Dashly plans in this article.

Pre-verify the emails you’re importing

If you’re going to send emails to the leads you’re uploading, we recommend you to go through email validation. 

Dashly has its own verification system so you don't have to worry about getting blocked for bounce rate. Nevertheless, remember that imported leads are counted in the quota and the overrun may affect the price. Don't import the leads you won’t use.

You can use any verification service. We prefer emaillistverify.com. Our experience with it has always led us to a bounce rate below 3%.

 Import via the Dashly interface

You can find the import interface in the “Lead database” section:

You can import your lead base either with User IDs or with emails addresses. 

Choosing either options will let you download a template import file. We recommend downloading the file and filling it with your lead database to make sure that the database is correctly prepared for uploading to Dashly. The file you import must be of .csv format and must have a size of less than 30 MB.

The list of standard Dashly properties can be found here, as well as in our documentation. The properties that are not on this list will be recorded as custom properties.

If your lead database contains the User IDs of your leads, select the “Registered users of your website” option. The User ID column must be placed first in the spreadsheet (the column must be named “$user_id”). If your Dashly leads database has lead cards with User IDs that match User IDs from the file you’re importing, the data you’re importing will merge with the existing Dashly lead cards.

Note: imported leads go to the unique visitors quota. If you’re importing data in an existing lead card (the imported lead will merge with the last active existing lead with the same User ID), the lead you’re importing it won’t be counted as a new unique visitor. 

If you have an existing lead database with a list of emails, but missing User IDs, choose “Email contacts list”, add a column named “$email” (or simply download our template, it will have the said column as well) and fill it with the emails of the leads you want to upload to Dashly. In case with uploading leads as a list of email contacts, make sure your import file doesn’t contain the “$user_id” column.

As it’s possible that your Dashly lead database may have several lead cards with similar emails, the lead data from the import file you upload will merge with the last active Dashly lead cards with the same emails.

Let’s say you want to upload a leads database, where your customers are divided into several categories such as “Current”, “New”, “Potential”. You can add custom properties into the import file to divide these leads. To do that, add a column with the name “Category” and place the values “Current”, “New” and “Potential” into the rows with the emails of corresponding leads. You can also find an example of how custom properties can be added with an import file in our template.

Segmenting leads by properties will allow you to send a manual email campaign to a target audience. 

There is no restriction on how many leads can be uploaded with a single import file, but the size of the import file must be under 30MB.

Check whether the properties you’ve added into the import file are correct, upload it, see if the encoding of property names and values is correct as well and click “Import leads”.

Note: Before you click “Import leads”, you can add a tag to the leads you’re importing. You will be able to segment the imported leads by this tag later.

The import process runs in the background, so you can safely close the tab or go to another section of your Dashly dashboard without losing any data.

Once the import is over, you will receive a notification showing that the import process has been successfully completed in the notification menu (the “Bell” icon in the upper-right corner of your dashboard).

This notification will also show you how many of the new leads have been added, how many of the previously existing lead cards have been updated with the data from your import file and how many of the leads weren't uploaded due to errors in the import file. 

Important: When you import leads as a list of email contacts, you will only be able to use these leads to send them email campaigns, these leads won’t merge with sessions of the cards with the same emails on your website (unless the cards with these emails are already present in your Dashly lead database at the moment you import them). You can only merge the lead card created by a lead’s session with the lead card you’ve imported manually. To do it, go to the “Lead database” section, tick these two lead cards and click “Merge two leads”.

If you’ve imported leads with User IDs, next time the leads from this list log in to your website, the lead cards created by their sessions and the lead cards you’ve imported will merge. 

 Import via REST API

You can import your lead base into Dashly via REST API as well. Read more about this method in our API documentation.

Important! Please refrain from synchronous API calls when importing leads, as it may overload our system and lead to your token getting blocked. The optimal call frequency is 2-3 calls per second.

Code example for leads import in PHP:

# List for import 
# The first element - User ID from your system
$users = array(
    array('id' => 123,
          'email' => 'mail1@mail.ru',
          'phone' => '891xxxxxx',
          'name' => 'Test'
    ),
    array('id' => 456,
          'email' => 'mail2@mail.ru',
          'phone' => '891xxxxxx',
          'name' => 'Test2'
    )
);
$auth_token = 'xxx'  # TODO: ADD YOUR AUTH_TOKEN, you can find it in Settings > API Keys
 
 
for ($i =0; $i < count($users); ++$i ) {
    $url = 'http://api.dashly.io/v1/users/'.$users[$i]['id'].'/props?auth_token='.$auth_token;
    $operations = json_encode(array(
            array('op' => 'update_or_create',
                  'key' => '$email',
                  'value' => $users[$i]['email']
            ),
            array('op' => 'update_or_create',
                  'key' => '$phone',
                  'value' => $users[$i]['phone']
            ),
            array('op' => 'update_or_create',
                  'key' => '$name',
                  'value' => $users[$i]['name']
            ),
        )
    );
 
    $result = file_get_contents($url, false, stream_context_create(array(
      'http' => array(
        'method'  => 'POST',
        'header'  => 'Content-type: application/x-www-form-urlencoded',
        'content' =>http_build_query(array('operations' => $operations,'by_user_id'  => 'true')),
      )
    )));
 
 
    print $result;
}

How to save Excel in Windows-1251 encoding

  1. Go to “File”,

  2. “Options” – “Advanced”,

  3. Scroll down to "General",

  4. Click "Web document options",

  5. Open the “Encoding” tab,

  6. In "Save document as" field choose the most preferable value and click OK.

There’s also an alternative way of doing this:

  1. Go to "File",

  2. Select "Save as...",

  3. Click "Service". There, you will find the same "Web document options" button.

Powered by