When uploading an audience list to Revere Exchange the audience validator will look for the following column names in the CSV for processing. Please format the CSV file accordingly:

  • vanid
  • first_name
  • middle_name
  • last_name
  • suffix
  • email
  • phone_number (formats accepted: +11234567890, +1 (123) 456-7890, (123) 456-7890, 1234567890, 123 456 7890)
  • address
  • city
  • state
  • zip (example: 12345)
  • zip_plus_4 (example: 12345-1234)

Please note: Any extraneous characters or non-compliant column formatting may result in upload errors. Field names need to match the names above to be processed correctly. No column name should be duplicated. Any other column names will be ignored when uploaded. Should you encounter errors while trying to upload a file, please email the file to vip@revolutionmessaging.com.

Note: All audiences must have more than 1,000 rows/entries in order to be used for an advertising campaign.

Below is an example CSV file that could be uploaded to Revere Exchange:

Download the same sample CSV file here

Audience Naming

In uploading audiences, it is very helpful to name the audience something that can be located and identified quickly. We request when uploading any audiences, all clients utilize the structure Organization Name – List Name.

Example:

Revolution Messaging – Employee Sign Up 6/12/16