Important:
- We may change the data structure by adding or removing table columns in Open Data at our own discretion. As these changes may break your exports and queries, we will always endeavor to notify you in advance of such modifications, to give you time to update your configuration. Please note, however, that Emarsys cannot be held responsible for any losses or damages resulting from such changes.
- Please note that when a contact is deleted, all historical data relating to that contact is also deleted, which will be reflected in your Open Data datasets.
- Please use exact field selection in queries instead of
SELECT *, because if we extend the dataset, then it will break queries.
To check the contact_id field, you need to export a list of contacts manually, automatically or via the API. This identifier is an internal one for Emarsys. Via the Contacts > Data Export menu in Emarsys, you can gain access to such internal identifiers generated and used internally by Emarsys. Do not rely on these in any way, using our internal variables outside Emarsys as identifiers is considered a risky implementation practice.
The Data platform Big Query tables are raw, not unique tables, which means they may contain duplicates. However, the rate of duplication is extremely low: cca 0.001%.
In case you need exclusively unique data, please perform manual filtering for duplicated events.
Data views
For more information on the Open Data - Data views, see the following pages: