Audiences Anywhere is part of the Enrich Anywhere app family, along with Profile Anywhere.
After creating an audience, you can export a list of users in an audience to a CSV. This enables you to leverage the data gathered and processed by Dynamic Yield in various platforms to analyze or target a set of users.
Configuration options:
- An automatic nightly export that can include one or more audiences, delivered to an allocated AWS S3 bucket. The export is done after the site's nightly job finishes, between 05:00 AM to 09:00 AM, based on the site's local time zone.
- Simply export any individual audience on demand at any time, sent to your email, password protected.
Note: Session-based audiences can't be exported, because users are kept within an audience only for the duration of their session. After the session ends, the users do not exist in the audience.
For additional use cases, you can read here.
Prerequisites to export audiences identified by email or externalID
Provide a list of eligible users. Only users who opted in can be included in the export. This list is stored in dedicated personal-data-compliant storage. You maintain the list outside of Dynamic Yield, and sync a copy of it to Dynamic Yield using one of the following methods:
- An Opted-in Email Addresses feed. These data feeds are built from a CSV file stored in an Amazon S3 bucket.
- Message opt-in and message opt-out events.
Automatically exporting multiple audiences
You can configure a nightly export of users and each audience they belong to. The data is stored in an AWS S3 bucket provided by Dynamic Yield. Only matched users are included in the export.
- Go to Audience › Export Audience File and click Export File.
- Specify a name to use to identify the export job and include as part of every exported file name.
- Select the user identifier to export, based on how you identify them on the site.
- The identifier list is created dynamically once a day, nightly.
- You can export at any given time based on 1 identifier only.
- The list of audiences and their counters is updated. The calculation is done each night, as follows:
- For email addresses and external IDs, the counter is of the users who belong to the audience, and whose identifier was managed for opt-in.
- For all other identifiers, the count represents the number of users who match the defined audience conditions.
- Select one or more audiences to export.
- Click Export Audiences.
- Copy your S3 bucket and credentials to a secure location. This screen is only visible to users who have been granted permission to export audiences by their Customer Success Manager. You can only access the credentials twice per user if you forget them (for security reasons) by going to Options › Access File Data.
- Test the integration with your marketing platform by exporting a sample file. The file has the same structure as the file exported to S3 but contains fake identifiers. Click the Options menu and select Export a Sample.
- You can edit the exported file and view the status of the synchronization at any time in the audience export list (Audience › Export Audience File).
Note: To prevent errors, you cannot rename or delete an audience that is in the process of being exported. If you want to rename or delete an audience, disable the export, change the name, and reconfigure your marketing platform to import the new audience.
File Format
- The exported file includes identifiers of matched audience members at the time of the execution of the export job.
- The file is in CSV format, comma-separated, and UTF-8 encoded.
- The S3 path of the output is: s3://dy-audience-export-v2/audExport/{date}/{section}/{export_name} (US) or
s3://dy-eudc-audience-export-v2/{section}/{date}/{export_name} (EU)
- The exported data can be divided into several different files depending on the number of entries (maximum 5 million per file).
- The files are named as follows: part-{NNNNN}-{export_id}.csv
- When the export is completed successfully, an empty _SUCCESS file is added to the output folder.
- The first column contains the user identifier and is called “identity”.
- There is one column for each audience included in the export
- For each user (row), the value in each audience column is 1 if the user belongs to the audience and 0 if they do not.
- If a user is not in any audience, even if they were previously in an audience, they are not included in the exported file.
- The users are not listed in any particular order.
- Exported files are saved in S3 for 30 days, after which they are deleted.
Example file with 1 exported audience using plain text emails:
identity |
affinity_brand_a |
---|---|
email1@host.com |
1 |
email2@host.com |
1 |
email3@host.com |
1 |
email4@host.com |
1 |
email5@host.com |
1 |
email6@host.com |
1 |
email7@host.com |
1 |
Example file with 3 exported audiences using plain text emails
identity |
affinity_brand_a |
affinity_on_sale |
purchased_last_30_days |
---|---|---|---|
email1@host.com |
0 |
1 |
0 |
email2@host.com |
0 |
1 |
1 |
email3@host.com |
1 |
1 |
1 |
email4@host.com |
1 |
1 |
1 |
email5@host.com |
1 |
1 |
1 |
email6@host.com |
1 |
0 |
1 |
email7@host.com |
0 |
0 |
1 |
email8@host.com |
0 |
1 |
1 |
email9@host.com |
1 |
0 |
0 |
email10@host.com |
1 |
1 |
1 |
email11@host.com |
1 |
0 |
0 |
email12@host.com |
1 |
1 |
0 |
Frequently Asked Questions
What if I don't see an identifier I want to use the export list?
For an identifier to appear in the list, the following must be true:
- The use is identified in a website/mobile/API context (identity, login, signup APIs).
- At least one audience is defined, and that user is included in it.
- At least 1 night has passed from the time the previous conditions became true (because the list is calculated every night)
Note: If the section has used both email and external ID identifiers types, only 1 of them can be used for export and count. Contact your Customer Success Manager if you need additional assistance.
Manually Exporting a Single Audience
You can export a list of users in a given audience to a CSV file on demand. The data is sent as an attachment to the email address of the currently logged-in user and includes a list of all user IDs and emails of users that have been associated with a hashed or standard email address. It requires you to upload and synchronize a list of user emails. The manual export only supports audiences whose users are identified by email or externalID type.
- Go to Audience › Audience Manager.
- In the Actions column of any audience, click the more options icon
and then click Export User Data.
Note: Before exporting an audience with special characters in its name, edit the name and remove all special characters.
- When you receive the file, enter your site ID as the password to open the CSV.
Important: The CSV files are not encrypted and may contain sensitive data such as email addresses.
Sample Files