Load an email audience from a file audience-from-file

Adobe Campaign Web User Interface allows you to target profiles stored in an external file. Once the profiles have been loaded, all fields from the input file are available for use to personalize your delivery Learn how to personalize your content.

Profiles from the input file are not added to the database. They are loaded and available for this specific standalone email delivery only.

NOTE
This page describes how to load external profiles from a file when creating a standalone email delivery. To load data from a file in the context of a workflow, refer to this page.

Must-read must-read

  • This capability is available for email deliveries only.
  • Supported file formats are: text (TXT) and comma-separated value (CSV).
  • You cannot use control groups when loading the target population from an external file.

Select and configure the input file upload

To target profiles from a file in your emails, follow these steps:

  1. Open an existing email delivery, or create a new email delivery.

  2. In the Audience section, click the Select audience button then choose Select from file.

    {modal="regular"}

  3. Select the local file to load. The file format must align with the sample file.

  4. Preview and check how data is mapped in the central section of the screen.

  5. Specify the column which contains the email address from the Address Field drop-down list. You can also select the denylist colum if you have such information in the input file.

  6. Adjust the column settings, and how to format the data from the available options.

  7. Click Confirm once settings are correct.

When creating the message content, you can add personalization by leveraging fields from the input file. Learn how to personalize content

Sample file sample-file

When loading an external file to target profiles in your deliveries, make sure the input file matches the recommendations below:

  • Supported formats are TXT and CSV.

  • The first line in the file is your column header.

  • Align your file format with the sample file below:

    code language-javascript
    {
    lastname,firstname,city,birthdate,email,denylist
    Smith,Hayden,Paris,23/05/1985,hayden.smith@example.com,0
    Mars,Daniel,London,17/11/1999,danny.mars@example.com,0
    Smith,Clara,Roma,08/02/1979,clara.smith@example.com,0
    Durance,Allison,San Francisco,15/12/2000,allison.durance@example.com,1
    }
    

Preview and test your email test

Campaign Web allows you to preview and send proofs when using an audience uploaded from a file. To do this, follow these steps:

  1. Click the Simulate content button from your delivery content editing screen and click the Add test profile(s) button.

  2. The profiles contained in the uploaded file display. Select the profile(s) that you want to use for previewing your content and click Select.

  3. A preview of the delivery content displays in the right pane of the screen. Personalized elements are replaced with the data from the profile selected in the left pane. Learn more on delivery content preview

    {modal="regular"}

  4. To send proofs, click the Send proof button.

  5. Click the Upload proof profiles button and select the .txt or .csv file that contains your proof recipients.

    note caution
    CAUTION
    Ensure that the file format matches the one used for uploading your audience. Any format errors will display an alert.
  6. When the proof profiles are added and you are ready to send the proofs, click the Send proof button and confirm the sending.

    {modal="regular"}

  7. You can monitor the sending of the proof using the View proofs button at any time. Learn more on proofs monitoring

recommendation-more-help
c39c2d00-ba9a-424b-adf9-66af58a0c34b