Before running a Revive Campaign, we need a simple CSV (comma-separated value) file to upload and import old leads into CallAction. If the format is not done correctly, errors will always occur.
Sources of Errors:
Columns are in the wrong format.
The list contains numbers with an invalid area code (phone numbers that use 0 or 1 as the first digit).
The list contains toll-free phone numbers – 800, 888, 877, 866, 855, 844, and 833.
The list exceeds the maximum number of contacts permitted for upload. The recommended maximum number of contacts per upload is 500.
When creating the list, we recommend using Google Sheets and downloading it as a Comma Separated Values (.csv)
You may also use Microsoft Excel and save it as a CSV file.
The system can only successfully upload the contacts if the file is in the correct format. Columns of the CSV file must be in this exact order:
Phone - phone number needs to be a mobile number. Remember that you are trying to re-engage with your leads via SMS as we cannot send them a message on landline numbers. Also, make sure that all of the numbers are in the same format ie xxx-xxx-xxxx
Email - email address of the leads
First Name
Last Name
Optionally, you can also include additional information like address and tags in the upload CSV file format (Note: If you are missing data, leave the field blank):
Phone (area code and phone number) - Required
Email Address - Required
First Name - Required
Last Name - Required
Address
City
State (Two Letter Abbreviations Only)
Zip
Tags (you can import individual tags for each client, must include the ";" semicolon as a divider of tags)
Please contact our support team for more details if none of the aforementioned solutions worked. We offer live chat seven days a week.