Data Exports

This feature is currently in the Beta version.

Export raw data from IMF in a custom-defined structure to any file storage via any of the existing file storage integrations (SFTP). You can connect to tools/vendors that require bulk data processing (e.g. (email) campaign platforms, CRMs, etc.).

What does the feature provide

Data exports allow exporting of customers or events. The main focus is to allow full flexibility when defining the output; a user can choose data structure, format (CSV, JSON), mapping, target integration (eg: SFTP), and file naming (user-defined time-based naming). Exporting both static (raw data that were tracked) and dynamic data (enriched data, e.g. segmentation, aggregates, expressions) is available. Exports can be triggered manually, scheduled, or requested via API (manually).

Step-by-Step Guide:

You can find this feature by clicking through data and assets -> exports -> + new export.

Data source - choose customers or single event type that you want to export

note that in the bottom of the page you can see all the previous and following steps

Based on that click on +add filter condition and add customer or event filter to specify what data should be exported

You can apply any filters available to you. If you struggle with this step, read Filtering Data

Data structure - select and name fields in the export file

Name your export and scroll right to see all the details Exponea provides about your customers based on the information that we collect.

Be careful when adding and renaming columns, as having two identical column names will result in an error.

🚧

Privacy notice

Some export will contain personally identifying information (PII). Ensure that export is secured to reduce the risk of a data breach

Format & target - select filename, format, destination & security options

Format

Format specifies how will your final project look like based on your personal preferences. If you select CSV format, determine your Delimitor (which specifies the boundary between separate values) and Encoding (the process of converting data from one form to another).

JSON and JSON LINES files have a predefined Delimitor, hence simply select your Encoding. The difference between them is the way your exported data are written. While JSON writes data in comma-separated values [{"a":1},{"a":2}...], JSON LINES uses a new line for each value
{"a":1}
{"a":2}

Target

In the section Target select the place to which you export your data.
Click on the file storage and select an available integration (SFTP, Google storage)
Choose Path to parent directory to set where the Export will be located.
Select File name. Exponea allows dynamic naming. Adding %r after the name of the file will show its timestamp (eg: filename_1589460477.9546165). All other dynamic namings can be found here.

Schedule execution - one-time or repeated action

Now you should be ready to finish exporting your project

Updated about a month ago


Data Exports


This feature is currently in the Beta version.

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.


We rely on cookies

to optimize our communication and to enhance your customer experience. By clicking on the Accept and Close button, you agree to the collection of cookies. You can also adjust your preferences by clicking on Manage Preferences. For more information please see our Privacy policy.

Manage cookies
Accept & close

Cookies preferences

Accept & close
Back