Audiences: Imported Lists

Chaya David
  • Updated
Follow

Overview

Imported lists enable you to upload customer lists from external sources—such as recall data, OEM lists, purchased leads, or any other external customer data—into the Fullpath CDP. Once uploaded, the CDP uses generative AI to match your customer data fields to the Fullpath Shopper data structure. Imported customer lists become Fullpath CDP Shoppers and can be activated in any engagement channels and products active on your account.
 

Important: Uploading a purchased list often yields low engagement because many addresses are outdated, invalid, or belong to people who never opted in. This causes opens and clicks to drop while bounces rise. Low engagement metrics, plus higher spam complaints and spam-trap hits, prompt ISPs and filters to flag your IP/domain and quickly degrade your sender reputation and deliverability. Ensure the list is valid and legally obtained, and do not use it in a single campaign all at once — break it up and send over time to maintain sender reputation.

 

Where to Find It

Navigation Path:

  1. Enter the Fullpath Dashboard
  2. Navigate to Audiences (top bar navigation)
  3. Scroll down to Audiences Imported Lists

https://dashboard.fullpath.com/shoppers/imported-lists

alt 

 

Import Process Overview

Importing a list into the CDP involves four key steps. The system leverages generative AI to automatically match your CSV columns to Fullpath's Shopper data structure. Here's what to expect:

Import Steps:

  1. Step 1: Upload or drag and drop your CSV file
  2. Step 2: Name the list (internal use only)
  3. Step 3: Match column labels and validate shopper details
  4. Step 4: Complete the upload

 

Step 1 — Upload Your CSV File

Begin by uploading your customer data file. You can either click to browse and select your CSV file or drag and drop it into the upload area. The file must be in CSV format and contain at least 2 columns with recognizable customer data fields.
 

Requirement: Your CSV must contain at least 2 columns and include at least 2 identifiers: a name field and either a phone number or email address.

 

Step 2 — Name Your List

After uploading, assign a name to your list. This name is for internal use only and helps you identify the list in your dashboard. Choose a descriptive name that reflects the source or purpose of the data (e.g., "OEM Recall List - March 2026" or "Purchased Lead List - Q2").

 

Step 3 — Match Columns & Validate Data

The Fullpath system will auto-detect and suggest matches for your CSV columns to Fullpath Shopper fields. Review each column match and adjust as needed. This step ensures your customer data maps correctly to our database structure.

Column Matching

The system presents each CSV column and allows you to select which Fullpath field it corresponds to. For example, a column labeled "customer_first" would be matched to First Name, or "mobile" would be matched to Cell Phone. You can also leave a column unmatched if it contains data not relevant to your import.

Important: Any column marked in red after your edits or adjustments will not be included in the upload. Ensure all required columns are properly matched and not marked red.

Automatic Field Processing

The system applies the following automatic transformations during the matching process:

  • Full Name Parsing: If you upload a full name column, it is automatically split into "first name" and "last name" fields
  • Middle Names: When a shopper has a middle name, it is automatically joined with the first name
  • Name Column Redundancy: If you upload three name columns (full name, first name, and last name), only the first and last name columns will be used

 

Step 4 — Complete the Upload

Once all columns are matched and validated, click Complete Upload to finalize the import. The system will process your list and begin identity resolution and matching against existing Shoppers in your CDP. The list will appear in your Imported Lists dashboard, and you can use it immediately to build audiences and activate campaigns.

Processing Time: For very large uploads (70,000–100,000 records), the system may remain in "Calculating" status for up to 24 hours and may still show this status after activation, which can limit campaign reach for the first 24–48 hours. Upload large lists at least 48 hours before your campaign start date.

 

Video Walkthrough

Watch the Imported Lists walkthrough on YouTube

 

Supported Data Fields

The following data points can be included in your imported CSV. All fields are optional unless noted otherwise. The system uses generative AI to match your column names to these fields automatically.

Contact Information

First Name

  • Description: Customer's first name
  • Input: String
  • Example: "John"
  • Mandatory: No

Last Name

  • Description: Customer's last name
  • Input: String
  • Example: "Smith"
  • Mandatory: No

Email

  • Description: Customer's email address
  • Input: Valid email string
  • Example: user@example.com
  • Mandatory: No

 

Address Information

Address

  • Description: Customer's street address
  • Input: String
  • Example: "123 Main St"
  • Mandatory: No

City

  • Description: Customer's city
  • Input: String
  • Example: "Springfield"
  • Mandatory: No

State

  • Description: Customer's state or region
  • Input: String
  • Example: "California"
  • Mandatory: No

Zipcode

  • Description: Customer's postal code
  • Input: String
  • Example: "90210"
  • Mandatory: No

 

Phone Numbers

Home Phone

  • Description: Customer's home phone number
  • Input: String
  • Example: "+1-555-987-6543"
  • Mandatory: No

Cell Phone

  • Description: Customer's mobile phone number
  • Input: String
  • Example: "+1-555-123-4567"
  • Mandatory: No

Work Phone

  • Description: Customer's work phone number
  • Input: String
  • Example: "+1-555-222-3333"
  • Mandatory: No

 

Engagement Preferences

Do Not Email

  • Description: Indicates if the customer should not be emailed
  • Input: Boolean (true / false)
  • Example: true
  • Mandatory: No

Do Not Call

  • Description: Indicates if the customer should not be called
  • Input: Boolean (true / false)
  • Example: false
  • Mandatory: No

Do Not Mail

  • Description: Indicates if the customer should not be sent mail
  • Input: Boolean (true / false)
  • Example: true
  • Mandatory: No

Do Not Text

  • Description: Indicates if the customer should not be texted
  • Input: Boolean (true / false)
  • Example: false
  • Mandatory: No

Last Contact

  • Description: Date of last contact with the customer
  • Input: Date string
  • Example: "2024-06-01"
  • Mandatory: No

 

Important Conditions & Best Practices

Upload Requirements

  • Must contain at least 2 columns
  • Must include at least 2 identifiers: Name and either phone number or email
  • Supports up to 10,000 records per upload
  • Very large uploads (70,000–100,000 records) can remain in "Calculating" status for up to 24 hours

Matching Requirements

  • Must have at least 2 columns matched with Fullpath field names
  • Any column marked in red after edits or adjustments will not be included in the upload

Engagement Preference Format

The Do Not Email, Do Not Call, Do Not Mail, and Do Not Text fields must be in true / false format for proper mapping. For example, if do_not_text = true, SMS engagement will not be allowed for that shopper.

Recommended: 24-Hour Delay Before Activation

It is recommended to wait at least 24 hours after uploading before using audiences built from imported lists. This allows the system to complete identity merges and resolution, ensuring the most accurate and up-to-date data is available for each shopper.

 

Using Imported Lists in Audiences

Once your list is successfully uploaded and processed, you can use it as the foundation for building audiences. In the Audience Builder, navigate to the Customer Source section and select your imported list as the starting point. You can then layer additional filters on top of your imported list to further refine your audience before activation.

Imported Lists dashboard showing uploaded list names, record counts, and action options

 

Reminder: Uploading a purchased list often yields low engagement because many addresses are outdated, invalid, or belong to people who never opted in. This causes opens and clicks to drop while bounces rise. Low engagement metrics, plus higher spam complaints and spam-trap hits, prompt ISPs and filters to flag your IP/domain and quickly degrade your sender reputation and deliverability. Ensure the list is valid and legally obtained, and do not use it in a single campaign all at once — break it up and send over time to maintain sender reputation.