Skip navigation

Import Data into Drip

People in Drip

In Drip the only requirement to create a person in our database is their email address. This is how we identify people in your account. Any additional information regarding a person needs to be added by you, the Drip user. Person Profile Fields, Custom Fields, and Tags are datasets that allow you to better understand, track, and manage the people on your list.

Curate Your List for Import

If you have customer data stored on an email service platform or ESP you will need to export the data before closing your account. When you export your list from the ESP, consider the following questions:  

  • Do you have consent to send to this list?

  • Have you engaged with this list in the past 6 months?

  • Has your list been actively engaging with your emails in the past 6 months?

To help your emails reach inboxes, you need a healthy list full of people who want to hear from you. List imports are subject to approval.  

Clean your list by running it through a service such as NeverbounceBriteVerify, or Kickbox.

Format Your List

spreadsheet-header-format

To format your list, you will create a spreadsheet and save it as a comma-separated value (CSV) file. You can use any of the following spreadsheet platforms to do this:

Format Profile Fields

Format your column headings in all lowercase with underscores to map them to the built-in profile fields:

  • email
  • first_name
  • last_name
  • phone
  • address1
  • address2
  • city
  • state
  • zip
  • country
  • lifetime_value
  • time_zone

Each column in your spreadsheet must contain an email address to append the data to. If there is no email address or a duplicate email address a new person will not be created in your account. 

Include the email column as the very first data column in your file.

The time_zone field must be entered in Olson format (also known as “tz database”): America/Los_Angeles. Leave this field lowercase when importing your CSV file. 

The lifetime_value field must be entered in cents. So if a person’s LTV is $10, you'd convert that to cents and enter that in as 1000 instead of 10.00. Leave this field lowercase when importing your CSV.

All other cells or Profile Fields may remain empty. Profile Fields may contain spaces, numbers, and capital letters.

Format Tags

Tags are a way of attaching a label to a person once they have done something specific, like when someone becomes a customer. Not only do they help you better understand the way people interact with your marketing, but they also provide an intuitive way of segmenting your list.

Your column header must be formatted as follows: tags If you format the column as Tags or tag, it will import the tags as a Custom Field. Each Tags cell can contain one or more tags separated by a comma. If the cell is empty, a Tag will not be applied to the person.

Format Custom Fields

custom_fields_format

Custom Fields contain information that is unique to an individual person on your list, such as their shirt size. They're also how personalized details are added into emails with Liquid Code.

All custom fields are represented by an Identifier. The identifier name is static and is used to identify it from others in your account. Stored in the Identifier, is the information that is unique to a person.

Your Custom Field column header will be formatted in Drip like this: custom_field_identifier. There is a limit of 1000 characters per field. There is no limit to the number of custom fields you can save per person.

Export to CSV

When your spreadsheet is correctly formatted, download or export it as a CSV file. Drip does not save hard copies of the CSV files you import and you should save a copy to your computer for your records.

Import Your List

Import a list of people to Drip.

To import your CSV file to Drip:

  1. Go to People
  2. Click + Add People
  3. Under Upload a list of people click Begin 
  4. Upload or drag and drop your CSV file. Once you upload your CSV, you'll see a preview of the first few rows
  5. Check the box to Treat the first row in your file as headers
  6. Click Next > Add these People
  7. Click Done to exit the page and view the progress of the operation, or click Cancel this Operation to cancel the operation

You have 30 seconds to cancel an operation once it’s been scheduled. After that, operations cannot be canceled or reversed. 

Push people into Drip with the correct marketing status to ensure you’re respecting people’s marketing preferences. Unsubscribed people from one platform won’t automatically be marked as unsubscribed in another, so it’s important to keep track of subscribed versus unsubscribed people when importing your list to Drip. 

You will want to perform two separate CSV file imports, one file for subscribed people and one filed for unsubscribed people. 

Import Subscribed People

Import your CSV file of subscribed people to Drip: 

  1. Go to People
  2. Click + Add People
  3. Under Upload a list of people click Begin 
  4. Upload or drag and drop your CSV file. Once you upload your CSV, you'll see a preview of the first few rows
  5. Check the box to Treat the first row in your file as headers
  6. Click More Actions
  7. Apply an "Initial Upload" tag with the date for housekeeping purposes
  8. Click Next > Add these People
  9. Click Done to exit the page and view the progress of the operation, or click Cancel this Operation to cancel the operation

You have 30 seconds to cancel an operation once it’s been scheduled. After that, operations cannot be canceled or reversed.

You’ll be redirected to the Bulk Operations page where you can see the progress of your import. The operation will show as pending while we import your list, and once it’s completed can be found under Complete bulk operations. You can locate the subscribed people you just imported in your account under People > Active > Subscribed to marketing email

Import Unsubscribed People 

Import your CSV file of unsubscribed people to Drip: 

  1. Go to People
  2. Click + Add People
  3. Under Upload a list of people click Begin 
  4. Upload or drag and drop your CSV file. Once you upload your CSV, you'll see a preview of the first few rows
  5. Check the box to Treat the first row in your file as headers
  6. Click More Actions
  7. Apply an "Initial Upload" tag with the date for housekeeping purposes
  8. Click + Add Another Action
  9. Select Unsubscribe a person > All mailings
  10. Click Next > Add these People
  11. Click Done to exit the page and view the progress of the operation, or click Cancel this Operation to cancel the operation

You have 30 seconds to cancel an operation once it’s been scheduled. After that, operations cannot be canceled or reversed.

You’ll be redirected to the Bulk Operations page where you can see the progress of your import. The operation will show as pending while we import your list, and once it’s completed can be found under Complete bulk operations. You can locate the unsubscribed people you just imported under People > Active > People unsubscribed from email marketing. 

View the People You’ve Imported

People tab

To view the people you’ve imported into your account, click the People tab.