Would you like to perform a deeper analysis of the data from Engage? Maybe set up an insight environment that can serve you with ground-level data, down to each transaction and email response?
Engage provides the opportunity to do a lot with your data. Whether you prefer to dig into it yourself, hire a data scientist, or set up reports locally, we offer quick access to all the data stored within Engage with our BI export.
Accessing data
You can get the data your need exported to an FTP every night to build your own insight environment. This is a great way to analyze your own data crossed with data provided from Engage, for example to compare members with non-member customers.
Once you have BI exports set up, you can create reports, perform machine learning, or other analysis. If you want, you can also feed data back into Engage so that you can act on your calculated segments.
Exports file format
- The files exported are CSV with semicolons as separators.
- The file format is UTF-8
- All export files have a standard format except for contacts since that can be unique for each client.
- Since the contact attributes differ depending on customer and contact type it is up to each client what fields to export, custom or not.
- Each file can contain a maximum of 100,000 rows.
Exports version control
- To be adaptable and not affect live exports we use versioning of the file formatting where each version is locked. Example: If you in the future would like to add a new field to the message export called "Campaign id" it would be added to a whole new file version, message_v2.
- It's up to you when/if you want to switch to a new file format.
- For contact exports, you can always choose to modify an existing file format where you can either add or remove a field from the export.
Integration log
You can monitor your BI export in the integration log under Administration in the left side menu in Engage.
Article last reviewed
Comments
0 comments
Please sign in to leave a comment.