Export an audience's email addresses instantly

This walkthrough describes how to instantly export the email addresses of an audience that viewed a campaign on your website over the past weekend. It assumes that you have a Scheduled or Live segment with at least one segment member.

Using the exported data, you can import the email addresses of this audience into an email marketing app, then re-engage the audience.

This walkthrough describes how to:

Create an audience export.
Include email addresses in the output.
Test, then run the export instantly.

Create an audience export

The first step to exporting an audience is to create an export.

On the navigation menu, click Audience export > Audience export > Create export > Full export.

You create a full export because you want to run it instantly.
Enter a unique and intuitive name for the export and click Create.
In the Audience section, click Add segment, then select the segment for this export.
Click Output format > Define output.
On the Define output screen, on the File format tab, click CSV.

This walkthrough uses the CSV output as an example. In production, choose the file format that the email marketing app requires for importing email recipients.

Include email addresses in the output

After choosing the file format, you stay on the Define output screen to choose what data to include in the output of the audience export.

On the Define output screen, on the Output structure tab, click Add column.
In the newly added column, in the Header field, enter email.

The header will appear in the first row in the CSV output.
In the same column, in the Attribute value field, enter ${guest.email}.

This is a reference to the email address of every guest in the segment. The email addresses will appear in the email column in the CSV output.

Tip

Using a utility function, you can hash email addresses so they're securely exported.
Click Save, then close the Define output screen.

Test, then run the export instantly

After including email addresses in the output, you test the export, then run it instantly.

On the audience export page, click Test > Test scenario.
On the Test scenario tab, click in the search field, and then click Customer.

This selects a random guest for testing the export. Alternatively, you can select a guest from the exact segment you're using for this export.
Click Test. After the test runs, in Response > Output, you should see an output similar to:
RequestResponse
```
"email"
"[email protected]"
```
This shows that your output will be in the CSV format containing an email header title and the email addresses of your audience.

Note

If you don't see an email address, that's because the guest profile of the guest selected for the test doesn't contain the email address. In production, make sure that the data you reference from the guest profile is available in the guest profile.

You're now ready to export your audience.
Close the Test window.
Click Run now. The export starts running.

After the audience export finishes running, if your administrator enabled downloading the output directly from Sitecore CDP, you can do this on the same webpage: on the Activity tab, in the Finished exports section, click Download output. Alternatively, you can get an email notification with download instructions or send a webhook notification to external APIs or integration tools. See Accessing the exported data.

Next steps

You've now successfully exported an audience's email addresses from Sitecore CDP, and you can now re-engage this audience by sending them an email.

Do you have some feedback for us?

If you have suggestions for improving this article,