User profiles can be exported using the ReachFive Console in
This export allows to retrieve all or just the latest data of your users.
You can export data in CSV or JSON.
Exports are handled by jobs and executed on demand or scheduled.
Export definitions set the destination, scheduling, file format, and filtering options.
Create a definition in, click New definition, then Save.
The export job then appears in the Export definitions list.
Read below for how to set definition options.
To dump exported data, you must select a destination to receive the output JSON or CSV file:
Secured File Transfer Protocol servers (SFTP)
Amazon S3 (S3)
Google Cloud Storage solutions (GCS)
Set the required authentication options to your storage, and provide the path of the destination file.
To overwrite the file with every new run, select
Schedule job executions with CRON expressions.
To help write your CRON expressions, check CronMaker.
Format dropdown, you can choose between CSV and JSON.
When selecting JSON, all fields of the user profile data model will be exported, including consents.
You have the option to
Include custom fields in the export as well.
When using CSV format, you can define the columns to include in the export.
You can include all attributes of the user profile data model, including custom fields and consents.
Encoding dropdown, select UTF-8 or ISO-8859-1, for a better compatibility with your system.
Then, set the formatting options below:
Delimiter— to separate columns of the file
Quote char— to prevent column splitting issues
Escape character— to escape characters inside columns
If you have a large user database, you can filter what to export to limit the size of files that are generated.
Filters allow to define a value of range of values user profiles should match to.
User Age between 25 and 35
Filters are combined with the AND operator: the more filters you add, the more refined the data becomes.
User Age between 25 and 35 User Gender = Female
is not empty