When configuring a CX Route outbound voice campaign, leads can be imported into a Sheet from a CSV file.

Before you set the lead type, you must have a program/campaign created. For more information on that, click here.

Anchor
1
1
1. Creating the Spreadsheet

A Lead List using CX Route's Sheet feature can be created at any time during campaign setup.

From any spreadsheet program, add your lead information in designated columns:
Image Modified

Columns should NOT have a header
Columns of data that are not within the standard OBTM columns can be customized
*For more information on adding custom column headers, click here.
If a field is only applicable to some records and not others, the records without that information should be left blank.
- If this is not done, the contact records will not display properly:
  Image Modified
  *In the above example, you can see how all of column E should be reserved for Address Line 2 only, allowing columns F=city, G=state, H=zip code.
The sheet must be saved as a standard Comma Separated Values (.csv) file:

Image Modified

Anchor
2
2
2. Setting the Lead Type

From CX Route:

Browse to the OB campaign you will be using
Click to view the Details tab
Scroll down and change the Lead Source option from Internal[default] to Sheet
Image Modified
Scroll down and click Update so that the Leads Sheet entry appears underneath
Image Modified
- CX Route will create this for you using the naming convention
  {Campaign Name} Leads
- To access the lead sheet, click the blue button with the Leads Sheet name
  Image Modified
  *This will take you to Sheets, where the leads are stored and can be viewed/edited. For more information on managing all sheets, including leads sheets, click here.

Anchor
3
3
3. Syncing the Creation Event

A vital step in the creation of a lead sheet is to sync the record creation event BEFORE you import the records.
Image Modified If this is not done, or done out of sequence, the leads will not be created.

Click the blue button (shown above) to access the lead sheet details.
Click the Events tab
Image Modified
Click the Sync checkbox for the Sheet Record Created Event
Image Modified
Click Update to save the synced event
Image Modified

Anchor
4
4
4. Uploading Records to the Lead List

From the Leads Sheet section of the Details tab: Click the Leads Sheet button (see above)
*Lists can also be managed directly from the Sheets section in the left-hand navigation bar.

Click the Import tab
Image Modified
Click the + to browse to the location of your spreadsheet to add it
Click Continue
Image Modified
*The Import Template dropdown will list any previous sheets that have been uploaded to this campaign. Choosing a template will ensure that your previously-assigned column headers will be used. If this is the first import to the campaign, this dropdown will be empty, defaulting to "New Template".
The records will now be displayed on the Import tab:
Image Modified
Match up each of the columns by clicking the dropdown above it and select the default option that best represents it.
Image Modified
Image Modified Does your spreadsheet contain data that isn't covered by one of the default columns?
You can create a custom column header as part of Sheet Management. For details, click here.
Make sure every column is assigned
Image Modified
Click Import Data to save the records
Image Modified
A summary of the import will appear:
Image Modified
Click Update to save the import