Overview
Vero now offers a seamless way to export message, campaign and profile data to major data warehouses with minimal setup. This feature allows syncing historical and real-time message data directly into your own data infrastructure without relying on webhooks or third-party ETL tools.Key Features
- One-click data export : Easily enable data export from Vero to supported data warehouses.
- Automatic backfilling : Syncs historical data for comprehensive reporting.
- Seamless integration : Uses existing data source credentials to create a data destination.
- Secure connection : Ensures safe data handling via secure connection to your DWH.
- Failure alerts : Automated notifications for sync failures.
How to add a data destination
To use this feature, ensure you have a data source setup for the database you would like the data exported to. Read the relevant help article for your SQL data source to setup access. Once you’ve added a data source, please contact support@getvero.com to have one of our team members configure the data source as a destination and start syncing data via ETL.Exported data schema
Once running, Vero will sync the following tables to your data warehouse: Table name:campaigns
Table name:
profiles
Table name:
sends
Table name:
deliveries
Table name:
opens
Table name:
clicks
Table name:
conversions
Table name:
unsubscribes