Self-serve data export

You can create up to three data export connections in Ometria which allow you to export the following information from Ometria into your AWS S3 bucket:

• Contact records
• Email events - for all email types; automation, broadcast and transactional
• Website interaction events

Once you’ve created your connection, Ometria will send the data to your S3 bucket every 24 hours between 1:00am and 5:00am (UTC).

The contact data will include all records that had changes in the past 24 hours.

File format

The export sent to your S3 bucket is in JSON lines (.jsonl) and saved with .json extension.

This is to keep the file size manageable.

You can use the AWS Command Line Interface (CLI) to change the file extension if needed. 

Data dictionaries

See also: Data export examples

To understand the data you export, refer to the following dictionaries:

• Data export dictionary: Contact records 
• Data export dictionary: Email events
• Data export dictionary: Website interaction events 

Historical data and your first export

The first time you create a data export connection for email events or website interaction, Ometria will export all of your data from January of the previous year up to today. 

E.g. if you create a data export on 6th October 2023, you will receive all of your data from 1st January 2022 up to 6th October 2023. 

For contact data exports, you will receive all of your historical data for all time.

You'll receive a separate historical file per day - so if you create an email events data export on 6th October 2023, you'll receive 644 files, each representing the daily changes which occurred in your email events data since 1st January 2022.

This historical export will only happen the first time, so make sure you save these files in a safe place and make a copy for your records.

Before you begin

Create an AWS S3 bucket and make a note of the following details:

• AWS access key
• AWS secret key
• AWS region
• AWS bucket name
• AWS bucket path

See: AWS security credentials

Creating a data export connection

You will need to have the right permissions to create a data export connection. 

In Ometria, go to Settings and select the Connections tab:

Click Add new connection, then select the Data export tile:

Complete all of the fields using the information from your AWS S3 bucket:

Click Create connection. Your data will begin processing.

The first export can take up to 48 hours.

Remember that your first email events or website interaction export will contain historical data.

You can check the status of your connection in the Connections screen:

See also:

• Edit a data export connection
• Delete a data export connection