> ## Documentation Index > Fetch the complete documentation index at: https://help.getvero.com/llms.txt > Use this file to discover all available pages before exploring further. # Data Destination overview > Sync message, campaign, and profile data to your data warehouse with automatic backfilling and real-time updates. **Note:** This is a beta feature. Contact [support@getvero.com](mailto:support@getvero.com) for access. ## 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](/vero-2/data-sources/data-sources-overview) to setup access. Once you've added a data source, please contact [support@getvero.com](mailto: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`** | Field Name | Data Type | Example | Description | | ------------------ | ----------- | ------------------------- | ----------------------------------------------- | | `id` | `int` | `1274274` | ID for the Vero campaign | | `title` | `string` | `New User Campaign` | The title of the Vero campaign | | `campaign_type` | `string` | `newsletter` | The type of campaign (newsletter or workflow) | | `campaign_channel` | `string` | `email` | The channel used for the campaign | | `conversion_event` | `string` | `cart_checkout` | The API event name used for conversion tracking | | `created_at` | `timestamp` | `2024-12-31 01:18:30.000` | Timestamp when the campaign was created | | `updated_at` | `timestamp` | `2024-12-31 01:18:30.000` | Timestamp when the campaign was last updated | Table name: **`profiles`** | Field Name | Data Type | Example | Description | | ------------- | ----------- | ------------------------- | ------------------------------------------- | | `profile_id` | `bigint` | `1841463542` | User ID maintained by Vero | | `customer_id` | `string` | `1841463542` | User ID set by Vero's customer. | | `email` | `string` | `hello@getvero.com` | Email address associated with the profile | | `created_at` | `timestamp` | `2024-12-31 01:18:30.000` | Timestamp when the profile was created | | `updated_at` | `timestamp` | `2024-12-31 01:18:30.000` | Timestamp when the profile was last updated | Table name: **`sends`** | Field Name | Data Type | Example | Description | | ------------- | ----------- | ------------------------- | -------------------------------------- | | `message_id` | `bigint` | `32387920585` | ID of the send | | `profile_id` | `bigint` | `1841463542` | User ID maintained by Vero | | `campaign_id` | `int` | `1274274` | ID for the Vero campaign | | `sent_to` | `string` | `hello@getvero.com` | Recipient address of the send | | `event_time` | `timestamp` | `2024-12-31 01:18:30.000` | Timestamp when the event was triggered | Table name: **`deliveries`** | Field Name | Data Type | Example | Description | | ------------- | ----------- | ------------------------- | -------------------------------------- | | `message_id` | `bigint` | `32387920585` | ID of the send | | `profile_id` | `bigint` | `1841463542` | User ID maintained by Vero | | `campaign_id` | `int` | `1274274` | ID for the Vero campaign | | `event_time` | `timestamp` | `2024-12-31 01:18:30.000` | Timestamp when the event was triggered | Table name: **`opens`** | Field Name | Data Type | Example | Description | | ------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------- | | `open_id` | `string` | 32380535857\_1735667150000000 | Unique ID to account for multiple opens per message | | `message_id` | `bigint` | `32387920585` | ID of the send | | `profile_id` | `bigint` | `1841463542` | User ID maintained by Vero | | `campaign_id` | `int` | `1274274` | ID for the Vero campaign | | `user_agent` | `string` | `Mozilla/5.0 (Linux; Android 15; Pixel 8 Build/AP4A.241205.013; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/131.0.6778.136 Mobile Safari/537.36` | User agent of the client that opened the email | | `is_bot` | `boolean` | `true` | Whether the open was triggered by a bot | | `event_time` | `timestamp` | `2024-12-31 01:18:30.000` | Timestamp when the event was triggered | Table name: **`clicks`** | Field Name | Data Type | Example | Description | | ------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------------------------------------------------- | | `click_id` | `string` | `32394413331_1735657501000000` | Unique ID to account for multiple clicks per message | | `message_id` | `bigint` | `32387920585` | ID of the send | | `profile_id` | `bigint` | `1841463542` | User ID maintained by Vero | | `campaign_id` | `int` | `1274274` | ID for the Vero campaign | | `user_agent` | `string` | `Mozilla/5.0 (Linux; Android 15; Pixel 8 Build/AP4A.241205.013; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/131.0.6778.136 Mobile Safari/537.36` | User agent of the client that clicked the link | | `is_bot` | `boolean` | `true` | Whether the click was triggered by a bot | | `url` | `string` | `https://www.getvero.com` | URL of the clicked link | | `event_time` | `timestamp` | `2024-12-31 01:18:30.000` | Timestamp when the event was triggered | Table name: **`conversions`** | Field Name | Data Type | Example | Description | | ----------------- | ----------- | ------------------------- | -------------------------------------- | | `message_id` | `bigint` | `32387920585` | ID of the send | | `profile_id` | `bigint` | `1841463542` | User ID maintained by Vero | | `campaign_id` | `int` | `1274274` | ID for the Vero campaign | | `conversion_type` | `string` | `Direct` | Type of conversion event | | `event_time` | `timestamp` | `2024-12-31 01:18:30.000` | Timestamp when the event was triggered | Table name: **`unsubscribes`** | Field Name | Data Type | Example | Description | | ------------- | ----------- | ------------------------- | -------------------------------------- | | `message_id` | `bigint` | `32387920585` | ID of the send | | `profile_id` | `bigint` | `1841463542` | User ID maintained by Vero | | `campaign_id` | `int` | `1274274` | ID for the Vero campaign | | `reason` | `string` | | Reason for the unsubscribe | | `event_time` | `timestamp` | `2024-12-31 01:18:30.000` | Timestamp when the event was triggered |