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.
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:
-
Open an existing email delivery, or create a new email delivery.
-
In the Audience section, click the Select audience button then choose Select from file.
{modal="regular"}
-
Select the local file to load. The file format must align with the sample file.
-
Preview and check how data is mapped in the central section of the screen.
-
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.
-
Adjust the column settings, and how to format the data from the available options.
-
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
{modal="regular"}
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:
-
Click the Simulate content button from your delivery content editing screen and click the Add test profile(s) button.
-
The profiles contained in the uploaded file display. Select the profile(s) that you want to use for previewing your content and click Select.
-
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"}
-
To send proofs, click the Send proof button.
-
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. -
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"}
-
You can monitor the sending of the proof using the View proofs button at any time. Learn more on proofs monitoring