Follow

Batch Import

LeadConduit allows you to upload leads in batch files in .csv format. Upon import, these leads funnel through the specified lead flow, just as POSTed leads do. If you cannot POST leads in real time, you can use the import feature.

 

How to import a batch of leads

Generate a CSV (Comma Separate Value) formatted file of your lead data. Typically this is a spreadsheet saved with a .csv extension.

If you have a system generating the CSV, be sure the generated file conforms to CSV best standards. For example, if the lead data contains commas or carriage returns, that data must be enclosed in quotes.

From your Source-specific Posting Instructions page, click the link to import your leads via batch.

csv_import.png

 

Select Import Leads, then Choose File and select your .csv file, then click Next

screencapture-next-leadconduit-flows-58c1751d3fb79a1c4dc8b2fb-sources-53a310fa9d29c9c72100006c-docs-1489073949500.png

 

On the Batch File Setup screen:

The import screen will default to use the first row of your file as the column headers and LeadConduit flow fields will be displayed in the second row of the import screen.


The import screen will attempt to match existing flow fields with column headers.

 

If your CSV doesn't have column headers, be sure to uncheck CSV Column Header

 

screencapture-next-leadconduit-flows-58c1751d3fb79a1c4dc8b2fb-sources-53a310fa9d29c9c72100006c-docs-1489073996955.png

screencapture-next-leadconduit-flows-58c1751d3fb79a1c4dc8b2fb-sources-53a310fa9d29c9c72100006c-docs-1489074007542.png



In some cases, you will need to manually map a field. Use the dropdowns to match column headers to flow fields.

screencapture-next-leadconduit-flows-58c1751d3fb79a1c4dc8b2fb-sources-53a310fa9d29c9c72100006c-docs-1489074027906.png

 

Click Next to enter the FINAL STEP screen and watch the progress bar as your lead data is validated.

    • This validation is checking the data in the file against the acceptance criteria of the flow
    • Should any of your lead data not meet acceptance criteria, you will receive a complete report of which rows have missing or unacceptable data
    • At this time you can choose to complete the import or you can adjust your data and begin the process again

 

When the status bar shows that the leads are done validating, click the Import Leads button in the bottom right corner to complete the import.

 

screencapture-next-leadconduit-flows-58c1751d3fb79a1c4dc8b2fb-sources-53a310fa9d29c9c72100006c-docs-1489074039285.png

 

NOTE Do not close this page/tab while the import is in progress

 

Review the Summary of Batch Import. This screen will show you which specific leads resulted in a failure in the flow and will include a failure reason.

These failures reasons are also available in a real time report available to all lead sources upon request. 

 

Commonly Asked Questions

Q: Is there an API I can upload a CSV to or do I have to use the import option on the Posting Instructions?

A: No, there's not an option to upload a CSV to an API endpoint. You must use the import on the Posting Instructions

//--//

Q: Can I import an Excel Spreadsheet instead?

A: No. The file format must be CSV. Excel files are easily converted to CSV format before uploading.

//--//

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Count von Count

    I accidentally closed my browser tab before the import was complete. What should I do?

  • Avatar
    Jeremy Brown

    You have a few options:


    1) Re-import the entire CSV
    This option should be okay if the flow has a deduplication filter configured.

    Please note the duplicates will incur a partial cost (the duplicates will be counted as a source event) before being marked as duplicates.

    2) Create a trimmed down CSV of only the remaining leads and start a new import.

    If you're the LeadConduit account holder, log in to LeadConduit and find the last lead that was imported.

    If you're not the LeadConduit account holder, you can determine the last imported lead either from your report page (assuming your lead buyer has provided a link to the report) or you'll have to follow up with your lead buyer directly for that information.

    Edited by Jeremy Brown
You must be logged in to comment.