Engaged Nation's REACH® platform integrates with Salesforce Marketing Cloud to scrub and suppress bad emails and generate a unique subscriber_id as the Subscriber Key. 

The Subscriber Key is a text field that serves as the singular unique identifier for each subscriber. A subscriber key value should not equal an email address to allow multiple records with shared email addresses in a singular database.

A subscriber's status and history are tied to their subscriber key, so it must be present for all imports. If your original data was ingested using the REACH platform, you'll need to export your Master Data Extension to find all records' subscriber_ids.

Otherwise, an Engaged Nation email team member can import the file for you, after you submit a Data Ingestion Only Request here.

How to Export a Data Extension

1. From Email Studio, navigate to Subscribers > Data Extensions and locate the data extension you want to export.
2. From the table view, click the right arrow in the Actions column and select Export.
3. In the Export window, set your export settings.
  • File Name
  • File Type (CSV, txt, other)
  • Export Options (Compress file if it is greater than 20 MB - see size next to Data Extension name in the export window.)
  • Delivery location - Choose Browser Download. If the file is larger than 20 MB, you will need to send it to the Salesforce FTP.


How to Import Data into a Data Extension

1. Select the destination Data Extension.
2. From the table view, in the Actions section, select Image PlaceholderImport. 
  •   Choose the file you are importing, from your computer or FTP.
  •   If the file is larger than 20MB, compress zip it and check Compressed.
3. Select the file type (.csv - comma or .txt - tab)
4. Import type
  • If the data extension is empty, without existing records, choose Overwrite, as your import type.
  • If choosing Add or Update, the primary keys or required fields must exist in the data file you are importing.
5. Import options: Check Skip rows in the import file with bad data. Optional - Respect double quotes as a text qualifier.
6. Click Next.

7. Map your fields.

  • Map by Header Row  - If the field names match the field names in the data extension it will map by header row names.
  • Map by Ordinal - Will map them in the order of the fields in the imported file.
  • Map Manually - You can manually map header rows from the file to the data extension fields. 
8. Click Next.
9. Review, enter the email address that should receive the import notification after the import has been processed, and Click Import.