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:
- phone_number (formats accepted: +11234567890, +1 (123) 456-7890, (123) 456-7890, 1234567890, 123 456 7890)
- zip (example: 12345)
- zip_plus_4 (example: 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 firstname.lastname@example.org.
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:
04a896501541df2e90ef2a11,Camden,Jason,Hermiston,MD,email@example.com,9825661616,1092 Hansen Mall,O'Keefeberg,MI,62224,5627
873c3d0c7c78d48b2a130c5b,Brenda,Lyla,Senger,PhD,firstname.lastname@example.org,6169727951,269 Elliott Ridge,Jerdebury,ME,47932,4817
4cd294d3b1c033cb38cb5943,Jed,Verner,Hauck,II,email@example.com,4389506572,110 Marquardt Flats,New Zoey,HI,88339,7147
2df9cf42507ea31678f84802,Adriana,Erling,Mohr,PhD,firstname.lastname@example.org,6241946487,44945 Aufderhar Stream,Port Krystel,SD,61066,3194
fb100d6da400868874a2a451,Mercedes,Fritz,Satterfield,II,email@example.com,6017553723,8668 Haley Isle,Deonburgh,MI,86746,9639
e24996c06e6cc5973ebf6aa9,Willis,Chance,Murphy,IV,firstname.lastname@example.org,9419226644,38477 Hayes Burgs,Kadenport,NH,38555,3112
c32a212a3a90394c9c700899,Doug,Halie,Klein,III,email@example.com,9683929733,6581 Rosemary Mountains,Cristopherfort,LA,77337,1481
157e92718f859f8c7398cad1,Kasey,Anissa,Hessel,I,firstname.lastname@example.org,2253208692,7666 Botsford Squares,Lake Gardner,IA,62051,5888
b85e28beff3f796d65d8231f,Lina,Naomi,Huel,DVM,email@example.com,8788032555,935 Kennedy Corners,Lake Joannehaven,KS,82717,9269
1a7885d322961046043bfe5f,Chad,Roscoe,Hermiston,I,firstname.lastname@example.org,4164060248,9068 Koepp Path,Isobelshire,WI,91157,5770
Download the same sample CSV file here
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.
Revolution Messaging – Employee Sign Up 6/12/16